Ticket #265 (closed enhancement: fixed)
Geometry to Geography cast enhancement auto transform
|Reported by:||robe||Owned by:||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.