[postgis-users] Spatial Reference ID

[Ed Linde]

Thanks Sandro.
Yes, that is what I want. So it seems that I don't have to do anything to
the
actual polygons. Like change them to be 2D and load them back into the DB
then?

Thanks,
Ed

On Wed, Oct 10, 2012 at 12:21 PM, Sandro Santilli <strk at keybit.net> wrote:

> On Wed, Oct 10, 2012 at 12:13:53PM +0200, Ed Linde wrote:
>
> > 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.
>
> ST_Intersect only looks at 2D.
> Only the "shadown" of your triangles will be considered.
>
> Seems to be what you want, right ?
>
> --strk;
> _______________________________________________
> 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/0e487cef/attachment.html>