sql空间函数修改srid
3033 - Binary geometry function st_contains given two geometries of different srids: 101 and 0, which should have been identical.
出现上述报错的原因为在使用空间函数时,两个表所定义的SRID不一致,用空间函数计算,两表需保持一致性;
如何查询srid?
select srid(column) from table;
一搬默认为0;
如何更新srid?
update table set column=geomfromtext(astext(column));
默认为0,若需修改为其它参数,需调整为
column=geomfromtext(astext(column),自定义);