MySQL Error 3033 Binary geometry function mbrintersects given two geometries of different srids: 0 and 3857, which should have been identical 问题分析及解决
背景
查询sql
SELECT
*
FROM
table_name1
WHERE
ST_Intersects (
sys_geom,
GeomFromText ( 'POLYGON ((113.792406 22.461996, 114.379488 22.461996, 114.379488 22.631952, 113.792406 22.631952, 113.792406 22.461996))', 3857 ))
插入sql
INSERT INTO table_name1 ( sys_code, sys_name, sys_geom, sys_state, sys_create_user, sys_create_time )
VALUES
(
'110101',
'东城区',
ST_GeomFromText ( 'MULTIPOLYGON(((116.387663 39.960923,116.389479 39.961038,116.389506 39.963147,116.392385 39.963169,116.392514 39.963128,116.392658 39.963171,116.393041 39.963174,116.393126 39.963147,116.393199 39.963175,116.39429 39.963183,116.394675 39.963195,116.394796 39.963195,116.394822 39.963195,116.394926 39.963198,116.395046 39.963158,116.395105 39.963218,116.395179 39.963191,116.396959 39.963204,116.398227 39.962532,116.398739 39.962562,116.398852 39.96238,116.399703 39.962389,116.40045 39.962051,116.401301 39.962082,116.401449 39.962424,116.402682 39.962433,116.403671 39.961848,116.404192 39.961891,116.40447 39.961891,116.405477 39.96187,116.405486 39.962256,116.407873 39.962178,116.407778 39.965139,116.407743 39.96608,116.407718 39.966562,116.407666 39.966909,116.407553 39.967352,116.407483 39.96763,116.407466 39.967951,116.407388 39.969661,116.407362 39.970204,116.407406 39.970477,116.407484 39.970824,116.407545 39.971085,116.407571 39.97135,116.407579 39.971654,116.40751 39.974002,116.409359 39.974036,116.409341 39.97253,116.408821 39.972496,116.408786 39.971463,116.411095 39.971454,116.411227 39.968831,116.411233 39.968785,116.411232


4375

被折叠的 条评论
为什么被折叠?



