PostGIS, PostgreSQL

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

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 *

10 + six =