id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc 265,Geometry to Geography cast enhancement auto transform,robe,pramsey,"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. ",enhancement,closed,low,PostGIS 1.5.0,postgis,master,fixed,,