[postgis-users] problem with data crossing the date line

[Puneet Kishor]

On Sep 15, 2011, at 3:06 PM, Paul Ramsey wrote:

> Might want to cross-post this to QGIS, it's more their problem than ours.

Righto. But, let me ask this... is inserting such data in Pg as `GEOGRAPHY(Polygon,4326)` the right thing to do? Doing it as GEOMETRY produces mostly nonsense.

Just want to cover all the bases.



> 
> P
> 
> On Thu, Sep 15, 2011 at 1:22 PM, Puneet Kishor <punk.kish at gmail.com> wrote:
>> well, I've reached that point where I have 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 the best way to handle this?
>> 
>> Puneet.
>>