Hi, EPSG:4326 supports longitude in both 0-360 & +-180 spaces. Postgis supports both.
Try the function at: http://www.postgis.org/documentation/manual-1.5/ST_Shift_Longitude.html If you are trying to do operations like point in polygon queries, then both points & polygons need to be in the same long space, as -179 is not = 181. This does not provide a complete solution, but does provide a solution for some dateline problems. HTH, Brent Wood --- On Fri, 9/16/11, Puneet Kishor <[email protected]> wrote: From: Puneet Kishor <[email protected]> Subject: [Qgis-user] viewing PostGIS GEOGRAPHY data To: [email protected] Date: Friday, September 16, 2011, 10:14 AM I am trying to deal with data crossing the date line. I have kept a file on my Dropbox/Public folder [http://dl.dropbox.com/u/3526821/PA.gmt] which has a series of lat/lng pairs, one per line, making a single polygon. If I insert them into PostGIS as GEOMETRY, the resulting polygon is messed up. If I insert them as GEOGRAPHY, I can't view the polygon in Quantum GIS. Any suggestion on how can I view it in QGIS? I am using QGIS 1.7 on a Mac, and Pg/Pgis 9.0.4/1.53. Puneet._______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
