Hi All, Thanks Mike. I have just loaded triangles as POLYGON with 3D (x,y,z) co-ordinates into postgres. And I want to know which triangles intersect with a 2D box or envelope. which I do something like the following:
ST_INTERSECTS( a.geomtext, ST_MakeEnvelope( 585570 ,5205600, 585570, 5205630 )) 5 | POLYGON Z ((585570 5205570 634,585570 5205600 661,585549.994940603 5205588.81757012 560.308887892328,585570 5205570 634)) 6 | POLYGON Z ((585570 5205600 661,585600 5205570 644,585600 5205600 670,585570 5205600 661)) 7 | POLYGON Z ((585600 5205570 644,585570 5205600 661,585570 5205570 634,585600 5205570 644)) The rows I get returned back, I am just wondering if its ok to intersect 3D triangles (polygons) with a 2D box? Will this give me the correct results? I just want to know all the triangles that are covered fully or partially by that 2D region. Thanks, Ed On Wed, Oct 10, 2012 at 9:23 AM, Mike Toews <mwto...@gmail.com> wrote: > From the pastebin text: NAD27 UTM Zone 10N > http://spatialreference.org/ref/epsg/26710/ > SRID=26710 > Try it! > > -Mike > > On 10 October 2012 20:18, Ed Linde <edoli...@gmail.com> wrote: > > Hi All, > > I have this file I downloaded from geocomm and I am trying to figure out > > what the SRID for it in postgis would be. Have no idea. > > Can someone please help? > > Some sample x,y,z values in the file are > > > > 590283.357 5219156.537 658.84 > > 590283.357 5219146.537 656.303 > > 590283.357 5219136.537 660.872 > > 590283.357 5219126.537 666.917 > > 590283.357 5219116.537 671.999 > > > > > > The .txt file with spatial information --> http://pastebin.com/1H0zVYTQ > > > > I tried looking at http://spatialreference.org/. But could not figure > out > > which one I should be using in Postgis. > > I basically want to transform that co-ordinate system into something more > > manageable where say each > > x,y,z value lies in the range of [0,1000] or something like that. Would > be > > nice to hear some suggestions. > > > > Cheers, > > Ed > > > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
