Binary geometry function mbrintersects given two geometries of different srids:0 and 3857问题推测

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 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值