-boun...@lists.osgeo.org] On Behalf Of Mike Toews
Sent: Thursday, February 19, 2015 2:47 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] ST_intersects query that crosses date line
boundaries
Hi Trang,
Geometry types work in Cartesian space, and don't know what happens when Y
coordinates
;
Sent: Friday, February 20, 2015 10:57 AM
Subject: [postgis-users] ST_intersects query that crosses date line boundaries
Hi,
I am using Postgres 9.3 and have a table with geometry columns: startloc
geometry(Point), endloc geometry(Point), When I run a query that crosses
the date
Hi Trang,
Geometry types work in Cartesian space, and don't know what happens
when Y coordinates cross the antimeridian at -180/+180. Try
experimenting with the geography type, which works with some, but not
all PostGIS functions. ST_Intersects should work on geography types
for your example, e.g.
Hi,
I am using Postgres 9.3 and have a table with geometry columns:
startloc geometry(Point),
endloc geometry(Point),
When I run a query that crosses the date line boundary, I'm getting incorrect
results. Example:
SELECT * from od1.trip_v1_partitioned where startts>=TIMESTAMP
'2015-02-16T20
