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

Paul Ramsey pramsey at cleverelephant.ca
Tue Apr 13 20:59:03 PDT 2010


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
>
>



More information about the postgis-users mailing list