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:00:00.000Z'and startts<TIMESTAMP '2015-02-17T20:00:00.000Z'and
endts<TIMESTAMP '2015-02-17T20:00:00.000Z' and ST_intersects(startloc,
ST_MakeValid(ST_GeomFromText('MULTIPOLYGON(((179.64844 67.73477,-155.03906
67.60118,-161.19141 61.8462,179.64844 67.73477)))')))
Would I need to change how my columns are stored (this would require a big
migration), or is it possible to adjust my query to handle this correctly?
Thanks,
Trang
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
