mysql 经纬度 矩形_SQL判断经纬度在矩形内

1，将城市地图拆分等距拆分为矩形

数据结构如图：

2.查看高德JS API (点是否在多边形内)核心代码：

a=[114.069564,22.545774];

b=[

[114.067595,22.552082],

[114.077322,22.552082],

[114.077322,22.543099],

[114.067595,22.543099],

];

c=truelf:function(a, b, c) {var d = a[0];

a= a[1];var f = !1, g, h, k, l, m = b.length, n = 0;for (l = m - 1; n < m; l =n,

n+= 1) {var p = !1;

g= b[n][0];

h= b[n][1];

k= b[l][0];

l= b[l][1];if (g === d && h === a || k === d && l ===a)return c ? !0 : !1;if (h < a === l >=a) {

g= (k