[Qgis-user] viewing PostGIS GEOGRAPHY data

[pcreso at pcreso.com]

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 <punk.kish at gmail.com> wrote:

From: Puneet Kishor <punk.kish at gmail.com>
Subject: [Qgis-user] viewing PostGIS GEOGRAPHY data
To: qgis-user at lists.osgeo.org
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
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20110916/3392d28f/attachment.html>