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
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,
Sent: Friday, February 20, 2015 10:57 AM
Subject: [postgis-users] ST_intersects query that crosses date line boundaries
!--#yiv5574049598 _filtered #yiv5574049598 {font-family:Calibri;panose-1:2 15
5 2 2 2 4 3 2 4;}#yiv5574049598 #yiv5574049598 p.yiv5574049598MsoNormal,
#yiv5574049598