地理空间数据库实现各种地理坐标转换，基于Postgresql和PostGIS

WGS84转GCJ02 select geoc_wgs84togcj02(geom) from test_table GCJ02转WGS84 select geoc_gcj02towgs84(geom) from test_table WGS84转BD09 select geoc_wgs84tobd09(geom) from test_table BD09转WGS84 select geoc_bd09towgs84(geom) from test_table CGCS2000转GCJ02 select geoc_cgcs2000togcj02(geom) from test_table GCJ02转CGCS2000 select geoc_gcj02tocgcs2000(geom) from test_table CGCS2000转BD09 select geoc_cgcs2000tobd09(geom) from test_table BD09转CGCS2000 select geoc_bd09tocgcs2000(geom) from test_table GCJ02转BD09 select geoc_gcj02tobd09(geom) from test_table BD09转GCJ02 select geoc_bd09togcj02(geom) from test_table