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