PostGIS – Convert EPSG:900913 to EPSG:4326 using Query

By | March 8, 2013

ST_AsText – represent geometry as WKT

ST_Transform – transform geometry from one projection to another

ST_GeomFromText – represent WKT as geometry

SELECT ST_AsText(ST_Transform(ST_GeomFromText(ST_AsText(geometry_column),900913), 4326)) from TABLE_NAME;

Reference: PostGIS 1.5 Manual

Leave a Reply

Your email address will not be published. Required fields are marked *

six + 3 =