<div dir="ltr"><div>Hi Tsolmon,<br><br></div><div>If memory serves, there's no support for TINs with ST_Within yet. I suspect (without testing the suspicion) that you can cast or convert to 3D polygons and do the test, but you'd need to use a 3D equivalent, probably ST_3DDFullyWithin, but the Oslandia folks might be able to answer more intelligently.<br>
<br>Best,<br>Steve<br><br><dl><dt><span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DClosestPoint.html">ST_3DClosestPoint</a></span><span class=""> — Returns the 3-dimensional point on g1 that is closest to g2. This is the first point of
the 3D shortest line. </span></dt><dt><span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DDistance.html">ST_3DDistance</a></span><span class=""> — For geometry type Returns the 3-dimensional cartesian minimum distance (based on spatial ref) between two geometries in
projected units. </span></dt><dt><span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DDWithin.html">ST_3DDWithin</a></span><span class=""> — For 3d (z) geometry type Returns true if two geometries 3d distance is within number of units. </span></dt>
<dt><span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DDFullyWithin.html">ST_3DDFullyWithin</a></span><span class=""> — Returns true if all of the 3D geometries are within the specified
distance of one another. </span></dt><dt><span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DIntersects.html">ST_3DIntersects</a></span><span class=""> — Returns TRUE if the Geometries "spatially
intersect" in 3d - only for points and linestrings
</span></dt><dt><span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DLongestLine.html">ST_3DLongestLine</a></span><span class=""> — Returns the 3-dimensional longest line between two geometries</span></dt><dt>
<span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DMaxDistance.html">ST_3DMaxDistance</a></span><span class=""> — For geometry type Returns the 3-dimensional cartesian maximum distance (based on spatial ref) between two geometries in
projected units. </span></dt><dt><span class=""><a href="http://postgis.net/docs/manual-2.1/ST_3DShortestLine.html">ST_3DShortestLine</a></span><span class=""> — Returns the 3-dimensional shortest line between two geometries</span></dt>
</dl><br></div><br><br><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Aug 19, 2014 at 5:43 AM, Tsolmongerel Orkhonselenge <span dir="ltr"><<a href="mailto:otsolmon@yahoo.com" target="_blank">otsolmon@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="color:#000;background-color:#fff;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;font-size:10pt">
<div>
<div>Dear PostGIS users,</div><div><br></div><div style="color:rgb(0,0,0);font-size:13.3333px;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;background-color:transparent;font-style:normal">
I would like to query if a point is located in the TIN
object. My TIN object is closed (convex hull) object (i.e. surface of a
round object). I tried to use ST_Within, but the error message returns
as:
ERROR: Unknown geometry type: 15 - Tin</div>
<div>My query is as follows: <br></div><div style="color:rgb(0,0,0);font-size:13.3333px;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;background-color:transparent;font-style:normal">SELECT ST_Within(mypoint,mytinobject) As mypointinmytinobject</div>
<div style="color:rgb(0,0,0);font-size:13.3333px;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;background-color:transparent;font-style:normal">
FROM
(SELECT ST_GeomFromText('POINT(x,y,z)', SRID) As mypoint, <br></div><div style="color:rgb(0,0,0);font-size:13.3333px;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;background-color:transparent;font-style:normal">
(SELECT geom FROM mytintable WHERE gid=1) As mytinobject
) As myobjects;</div><div style="color:rgb(0,0,0);font-size:13.3333px;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;background-color:transparent;font-style:normal"><br></div>
<div>What are the equivalent 3D query functions like ST_Within for 3D TIN object in PostGIS?</div>
<div><br></div><div style="color:rgb(0,0,0);font-size:13.3333px;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;background-color:transparent;font-style:normal">Thanks in advance.</div><div style="color:rgb(0,0,0);font-size:13.3333px;font-family:HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif;background-color:transparent;font-style:normal">
Tsolmon<br></div>
</div><div><br></div></div></div><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div>