Thanks for the tip!
On Wed, Oct 10, 2012 at 1:21 PM, Sandro Santilli wrote:
> On Wed, Oct 10, 2012 at 01:07:14PM +0200, Ed Linde wrote:
> > 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
On Wed, Oct 10, 2012 at 01:07:14PM +0200, Ed Linde wrote:
> 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?
Right, nothing to do.
In any case should you ever need t
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 wrote:
> On Wed, Oct 10, 2012 at 12:13:53PM +0200, Ed Linde w
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
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 ))
>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 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
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
590
