MySQL 空间坐标系修改

查看mysql空间坐标系

select st_srid(geom) from  f_base_facility

更新数据坐标系到4326

update t_road set geom= geomfromtext(st_astext(geom),4326);