[postgis-devel] [PostGIS] #265: Geometry to Geography cast enhancement auto transform

[PostGIS]

#265: Geometry to Geography cast enhancement auto transform
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  low          |   Milestone:  postgis 1.5.0
Component:  postgis      |     Version:  trunk        
 Keywords:               |  
-------------------------+--------------------------------------------------
 I'm finding myself doing a lot of this:

 SELECT geography(ST_Transform(the_geom, 4326))

 Which is not bad for inserting data, but for the common use-case I can
 think of where one would want to keep their data in a good for
 presentation projection but use geography for distance calculations or
 across inherited tables, then they would be doing this a lot in queries
 which makes things a bit cluttered.

 Being able to do geography(the_geom) is so much nicer.

 Would be nice if the geometry -> geography cast was smart enough to read
 the SRID of a geometry and if it is a valid SRID (not -1 or 0), then it
 would do the transformation automagically to 4326.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/265>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS