在项目开发中遇到 Operation on mixed SRID geometries (Polygon, 0) != (Polygon, 4326) 报错解决
1、修改表空间字段坐标系
SELECT updategeometrysrid(‘table_name’,‘area_geom’,4326);
SELECT updategeometrysrid(‘表名’,‘字段名’,坐标系编号);
2、查询空间字段转化坐标系
select st_setsrid(“area_geom”,4326) from table_name;
select st_setsrid(“字段名”,坐标系编号) from table_name;