1. 在手动更新the_geom 字段后,需为该字段重新指定坐标系:
UPDATE `table name` SET `column name` = ST_GeomFromText(ST_AsText(`column name`), 4326);
1. 在手动更新the_geom 字段后,需为该字段重新指定坐标系:
UPDATE `table name` SET `column name` = ST_GeomFromText(ST_AsText(`column name`), 4326);