[postgis-users] Spatial Reference ID

[Ed Linde]

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 <mwtoews at 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 <edolinde at 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 at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121010/90f091b8/attachment.html>