[postgis-users] Conversion from undefined geometry to geography?

[Paragon Corporation]

You mean ST_SetSRID :) 

R
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Tuesday, April 13, 2010 11:59 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Conversion from undefined geometry to
geography?

Just use geography(the_geom), it'll work fine. If you fine you have srid
issues (I don't think you should) use
geography(setsrid(the_geom,4326))

P

On Tue, Apr 13, 2010 at 8:47 PM, Nicholas Bower <nick at petangent.net> wrote:
> We have some tables in which we've used Geometry to store polygon and 
> point lan/lon (srid = -1).  We embarked on this before PostGIS 1.5.x's 
> spherical Geography objects.
> Now we intend to upgrade and migrate these to new Geography types (eg 
> new geography col, copy/convert, drop original geometry col).
> Is there an existing function that provides a conversion from Geometry 
> to Geography that could be used in a simple table update?  This 
> doesn't give away too many clues what will happen when given a 
> geometry with srid = -1 for example:
> http://postgis.refractions.net/docs/geography.html
> TIA.
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users