mysql查询/更新地理空间数据投影

查询投影

1
select ST_SRID(the_geom) from tablename;

更新投影，将投影转换为 EPSG:4326

1
update tablename set the_geom = st_geomfromtext(st_astext(the_geom), 4326)