gis-rtree.test

视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.

  ('w', 's', 'p', GeomFromText('POINT(115 6)')),
  ('o', 'n', 'k', GeomFromText('POINT(158 129)')),
  ('j', 'h', 'l', GeomFromText('POINT(129 72)')),
  ('f', 'x', 'l', GeomFromText('POINT(139 207)')),
  ('u', 'd', 'n', GeomFromText('POINT(125 109)')),
  ('b', 'a', 'z', GeomFromText('POINT(30 32)')),
  ('m', 'h', 'o', GeomFromText('POINT(251 251)')),
  ('f', 'r', 'd', GeomFromText('POINT(243 211)')),
  ('b', 'd', 'r', GeomFromText('POINT(232 80)')),
  ('g', 'k', 'v', GeomFromText('POINT(15 100)')),
  ('i', 'f', 'c', GeomFromText('POINT(109 66)')),
  ('r', 't', 'j', GeomFromText('POINT(178 6)')),
  ('y', 'n', 'f', GeomFromText('POINT(233 211)')),
  ('f', 'y', 'm', GeomFromText('POINT(99 16)')),
  ('z', 'q', 'l', GeomFromText('POINT(39 49)')),
  ('j', 'c', 'r', GeomFromText('POINT(75 187)')),
  ('c', 'y', 'y', GeomFromText('POINT(246 253)')),
  ('w', 'u', 'd', GeomFromText('POINT(56 190)')),
  ('n', 'q', 'm', GeomFromText('POINT(73 149)')),
  ('d', 'y', 'a', GeomFromText('POINT(134 6)')),
  ('z', 's', 'w', GeomFromText('POINT(216 225)')),
  ('d', 'u', 'k', GeomFromText('POINT(132 70)')),
  ('f', 'v', 't', GeomFromText('POINT(187 141)')),
  ('r', 'r', 'a', GeomFromText('POINT(152 39)')),
  ('y', 'p', 'o', GeomFromText('POINT(45 27)')),
  ('p', 'n', 'm', GeomFromText('POINT(228 148)')),
  ('e', 'g', 'e', GeomFromText('POINT(88 81)')),
  ('m', 'a', 'h', GeomFromText('POINT(35 29)')),
  ('m', 'h', 'f', GeomFromText('POINT(30 71)')),
  ('h', 'k', 'i', GeomFromText('POINT(244 78)')),
  ('z', 'v', 'd', GeomFromText('POINT(241 38)')),
  ('q', 'l', 'j', GeomFromText('POINT(13 71)')),
  ('s', 'p', 'g', GeomFromText('POINT(108 38)')),
  ('q', 's', 'j', GeomFromText('POINT(92 101)')),
  ('l', 'h', 'g', GeomFromText('POINT(120 78)')),
  ('w', 't', 'b', GeomFromText('POINT(193 109)')),
  ('b', 's', 's', GeomFromText('POINT(223 211)')),
  ('w', 'w', 'y', GeomFromText('POINT(122 42)')),
  ('q', 'c', 'c', GeomFromText('POINT(104 102)')),
  ('w', 'g', 'n', GeomFromText('POINT(213 120)')),
  ('p', 'q', 'a', GeomFromText('POINT(247 148)')),
  ('c', 'z', 'e', GeomFromText('POINT(18 106)')),
  ('z', 'u', 'n', GeomFromText('POINT(70 133)')),
  ('j', 'n', 'x', GeomFromText('POINT(232 13)')),
  ('e', 'h', 'f', GeomFromText('POINT(22 135)')),
  ('w', 'l', 'f', GeomFromText('POINT(9 180)')),
  ('a', 'v', 'q', GeomFromText('POINT(163 228)')),
  ('i', 'z', 'o', GeomFromText('POINT(180 100)')),
  ('e', 'c', 'l', GeomFromText('POINT(182 231)')),
  ('c', 'k', 'o', GeomFromText('POINT(19 60)')),
  ('q', 'f', 'p', GeomFromText('POINT(79 95)')),
  ('m', 'd', 'r', GeomFromText('POINT(3 127)')),
  ('m', 'e', 't', GeomFromText('POINT(136 154)')),
  ('w', 'w', 'w', GeomFromText('POINT(102 15)')),
  ('l', 'n', 'q', GeomFromText('POINT(71 196)')),
  ('p', 'k', 'c', GeomFromText('POINT(47 139)')),
  ('j', 'o', 'r', GeomFromText('POINT(177 128)')),
  ('j', 'q', 'a', GeomFromText('POINT(170 6)')),
  ('b', 'a', 'o', GeomFromText('POINT(63 211)')),
  ('g', 's', 'o', GeomFromText('POINT(144 251)')),
  ('w', 'u', 'w', GeomFromText('POINT(221 214)')),
  ('g', 'a', 'm', GeomFromText('POINT(14 102)')),
  ('u', 'q', 'z', GeomFromText('POINT(86 200)')),
  ('k', 'a', 'm', GeomFromText('POINT(144 222)')),
  ('j', 'u', 'r', GeomFromText('POINT(216 142)')),
  ('q', 'k', 'v', GeomFromText('POINT(121 236)')),
  ('p', 'o', 'r', GeomFromText('POINT(108 102)')),
  ('b', 'd', 'x', GeomFromText('POINT(127 198)')),
  ('k', 's', 'a', GeomFromText('POINT(2 150)')),
  ('f', 'm', 'f', GeomFromText('POINT(160 191)')),
  ('q', 'y', 'x', GeomFromText('POINT(98 111)')),
  ('o', 'f', 'm', GeomFromText('POINT(232 218)')),
  ('c', 'w', 'j', GeomFromText('POINT(156 165)')),
  ('s', 'q', 'v', GeomFromText('POINT(98 161)'));
SET @@RAND_SEED1=692635050, @@RAND_SEED2=297339954;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=159925977, @@RAND_SEED2=942570618;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=328169745, @@RAND_SEED2=410451954;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=178507359, @@RAND_SEED2=332493072;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
SET @@RAND_SEED1=1034033013, @@RAND_SEED2=558966507;
DELETE FROM t1 ORDER BY RAND() LIMIT 10;
UPDATE t1 set spatial_point=GeomFromText('POINT(230 9)') where  c1 like 'y%';
UPDATE t1 set spatial_point=GeomFromText('POINT(95 35)') where  c1 like 'j%';
UPDATE t1 set spatial_point=GeomFromText('POINT(93 99)') where  c1 like 'a%';
UPDATE t1 set spatial_point=GeomFromText('POINT(19 81)') where  c1 like 'r%';
UPDATE t1 set spatial_point=GeomFromText('POINT(20 177)') where  c1 like 'h%';
UPDATE t1 set spatial_point=GeomFromText('POINT(221 193)') where  c1 like 'u%';
UPDATE t1 set spatial_point=GeomFromText('POINT(195 205)') where  c1 like 'd%';
UPDATE t1 set spatial_point=GeomFromText('POINT(15 213)') where  c1 like 'u%';
UPDATE t1 set spatial_point=GeomFromText('POINT(214 63)') where  c1 like 'n%';
UPDATE t1 set spatial_point=GeomFromText('POINT(243 171)') where  c1 like 'c%';
UPDATE t1 set spatial_point=GeomFromText('POINT(198 82)') where  c1 like 'y%';
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
  ('f', 'y', 'p', GeomFromText('POINT(109 235)')),
  ('b', 'e', 'v', GeomFromText('POINT(20 48)')),
  ('i', 'u', 'f', GeomFromText('POINT(15 55)')),
  ('o', 'r', 'z', GeomFromText('POINT(105 64)')),
  ('a', 'p', 'a', GeomFromText('POINT(142 236)')),
  ('g', 'i', 'k', GeomFromText('POINT(10 49)')),
  ('x', 'z', 'x', GeomFromText('POINT(192 200)')),
  ('c', 'v', 'r', GeomFromText('POINT(94 168)')),
  ('y', 'z', 'e', GeomFromText('POINT(141 51)')),
  ('h', 'm', 'd', GeomFromText('POINT(35 251)')),
  ('v', 'm', 'q', GeomFromText('POINT(44 90)')),
  ('j', 'l', 'z', GeomFromText('POINT(67 237)')),
  ('i', 'v', 'a', GeomFromText('POINT(75 14)')),
  ('b', 'q', 't', GeomFromText('POINT(153 33)')),
  ('e', 'm', 'a', GeomFromText('POINT(247 49)')),
  ('l', 'y', 'g', GeomFromText('POINT(56 203)')),
  ('v', 'o', 'r', GeomFromText('POINT(90 54)')),
  ('r', 'n', 'd', GeomFromText('POINT(135 83)')),
  ('j', 't', 'u', GeomFromText('POINT(174 239)')),
  ('u', 'n', 'g', GeomFromText('POINT(104 191)')),
  ('p', 'q', 'y', GeomFromText('POINT(63 171)')),
  ('o', 'q', 'p', GeomFromText('POINT(192 103)')),
  ('f', 'x', 'e', GeomFromText('POINT(244 30)')),
  ('n', 'x', 'c', GeomFromText('POINT(92 103)')),
  ('r', 'q', 'z', GeomFromText('POINT(166 20)')),
  ('s', 'a', 'j', GeomFromText('POINT(137 205)')),
  ('z', 't', 't', GeomFromText('POINT(99 134)')),
  ('o', 'm', 'j', GeomFromText('POINT(217 3)')),
  ('n', 'h', 'j', GeomFromText('POINT(211 17)')),
  ('v', 'v', 'a', GeomFromText('POINT(41 137)')),
  ('q', 'o', 'j', GeomFromText('POINT(5 92)')),
  ('z', 'y', 'e', GeomFromText('POINT(175 212)')),
  ('j', 'z', 'h', GeomFromText('POINT(224 194)')),
  ('a', 'g', 'm', GeomFromText('POINT(31 119)')),
  ('p', 'c', 'f', GeomFromText('POINT(17 221)')),
  ('t', 'h', 'k', GeomFromText('POINT(26 203)')),
  ('u', 'w', 'p', GeomFromText('POINT(47 185)')),
  ('z', 'a', 'c', GeomFromText('POINT(61 133)')),
  ('u', 'k', 'a', GeomFromText('POINT(210 115)')),
  ('k', 'f', 'h', GeomFromText('POINT(125 113)')),
  ('t', 'v', 'y', GeomFromText('POINT(12 239)')),
  ('u', 'v', 'd', GeomFromText('POINT(90 24)')),
  ('m', 'y', 'w', GeomFromText('POINT(25 243)')),
  ('d', 'n', 'g', GeomFromText('POINT(122 92)')),
  ('z', 'm', 'f', GeomFromText('POINT(235 110)')),
  ('q', 'd', 'f', GeomFromText('POINT(233 217)')),
  ('a', 'v', 'u', GeomFromText('POINT(69 59)')),
  ('x', 'k', 'p', GeomFromText('POINT(240 14)')),
  ('i', 'v', 'r', GeomFromText('POINT(154 42)')),
  ('w', 'h', 'l', GeomFromText('POINT(178 156)')),
  ('d', 'h', 'n', GeomFromText('POINT(65 157)')),
  ('c', 'k', 'z', GeomFromText('POINT(62 33)')),
  ('e', 'l', 'w', GeomFromText('POINT(162 1)')),
  ('r', 'f', 'i', GeomFromText('POINT(127 71)')),
  ('q', 'm', 'c', GeomFromText('POINT(63 118)')),
  ('c', 'h', 'u', GeomFromText('POINT(205 203)')),
  ('d', 't', 'p', GeomFromText('POINT(234 87)')),
  ('s', 'g', 'h', GeomFromText('POINT(149 34)')),
  ('o', 'b', 'q', GeomFromText('POINT(159 179)')),
  ('k', 'u', 'f', GeomFromText('POINT(202 254)')),
  ('u', 'f', 'g', GeomFromText('POINT(70 15)')),
  ('x', 's', 'b', GeomFromText('POINT(25 181)')),
  ('s', 'c', 'g', GeomFromText('POINT(252 17)')),
  ('a', 'c', 'f', GeomFromText('POINT(89 67)')),
  ('r', 'e', 'q', GeomFromText('POINT(55 54)')),
  ('f', 'i', 'k', GeomFromText('POINT(178 230)')),
  ('p', 'e', 'l', GeomFromText('POINT(198 28)')),
  ('w', 'o', 'd', GeomFromText('POINT(204 189)')),
  ('c', 'a', 'g', GeomFromText('POINT(230 178)')),
  ('r', 'o', 'e', GeomFromText('POINT(61 116)')),
  ('w', 'a', 'a', GeomFromText('POINT(178 237)')),
  ('v', 'd', 'e', GeomFromText('POINT(70 85)')),
  ('k', 'c', 'e', GeomFromText('POINT(147 118)')),
  ('d', 'q', 't', GeomFromText('POINT(218 77)')),
  ('k', 'g', 'f', GeomFromText('POINT(192 113)')),
  ('w', 'n', 'e', GeomFromText('POINT(92 124)')),
  ('r', 'm', 'q', GeomFromText('POINT(130 65)')),
  ('o', 'r', 'r', GeomFromText('POINT(174 233)')),
  ('k', 'n', 't', GeomFromText('POINT(175 147)')),
  ('q', 'm', 'r', GeomFromText('POINT(18 208)')),
  ('l', 'd', 'i', GeomFromText('POINT(13 104)')),
  ('w', 'o', 'y', GeomFromText('POINT(207 39)')),
  ('p', 'u', 'o', GeomFromText('POINT(114 31)')),
  ('y', 'a', 'p', GeomFromText('POINT(106 59)')),
  ('a', 'x', 'z', GeomFromText('POINT(17 57)')),
  ('v', 'h', 'x', GeomFromText('POINT(170 13)')),
  ('t', 's', 'u', GeomFromText('POINT(84 18)')),
  ('z', 'z', 'f', GeomFromText('POINT(250 197)')),
  ('l', 'z', 't', GeomFromText('POINT(59 80)')),
  ('j', 'g', 's', GeomFromText('POINT(54 26)')),
  ('g', 'v', 'm', GeomFromText('POINT(89 98)')),
  ('q', 'v', 'b', GeomFromText('POINT(39 240)')),
  ('x', 'k', 'v', GeomFromText('POINT(246 207)')),
  ('k', 'u', 'i', GeomFromText('POINT(105 111)')),
  ('w', 'z', 's', GeomFromText('POINT(235 8)')),
  ('d', 'd', 'd', GeomFromText('POINT(105 4)')),
  ('c', 'z', 'q', GeomFromText('POINT(13 140)')),
  ('m', 'k', 'i', GeomFromText('POINT(208 120)')),
  ('g', 'a', 'g', GeomFromText('POINT(9 182)')),
  ('z', 'j', 'r', GeomFromText('POINT(149 153)')),
  ('h', 'f', 'g', GeomFromText('POINT(81 236)')),
  ('m', 'e', 'q', GeomFromText('POINT(209 215)')),
  ('c', 'h', 'y', GeomFromText('POINT(235 70)')),
  ('i', 'e', 'g', GeomFromText('POINT(138 26)')),
  ('m', 't', 'u', GeomFromText('POINT(119 237)')),
  ('o', 'w', 's', GeomFromText('POINT(193 166)')),
  ('f', 'm', 'q', GeomFromText('POINT(85 96)')),
  ('x', 'l', 'x', GeomFromText('POINT(58 115)')),
  ('x', 'q', 'u', GeomFromText('POINT(108 210)')),
  ('b', 'h', 'i', GeomFromText('POINT(250 139)')),
  ('y', 'd', 'x', GeomFromText('POINT(199 135)')),
  ('w', 'h', 'p', GeomFromText('POINT(247 233)')),
  ('p', 'z', 't', GeomFromText('POINT(148 249)')),
  ('q', 'a', 'u', GeomFromText('POINT(174 78)')),
  ('v', 't', 'm', GeomFromText('POINT(70 228)')),
  ('t', 'n', 'f', GeomFromText('POINT(123 2)')),
  ('x', 't', 'b', GeomFromText('POINT(35 50)')),
  ('r', 'j', 'f', GeomFromText('POINT(200 51)')),
  ('s', 'q', 'o', GeomFromText('POINT(23 184)')),
  ('u', 'v', 'z', GeomFromText('POINT(7 113)')),
  ('v', 'u', 'l', GeomFromText('POINT(145 190)')),
  ('o', 'k', 'i', GeomFromText('POINT(161 122)')),
  ('l', 'y', 'e', GeomFromText('POINT(17 232)')),
  ('t', 'b', 'e', GeomFromText('POINT(120 50)')),
  ('e', 's', 'u', GeomFromText('POINT(254 1)')),
  ('d', 'd', 'u', GeomFromText('POINT(167 140)')),
  ('o', 'b', 'x', GeomFromText('POINT(186 237)')),
  ('m', 's', 's', GeomFromText('POINT(172 149)')),
  ('t', 'y', 'a', GeomFromText('POINT(149 85)')),
  ('x', 't', 'r', GeomFromText('POINT(10 165)')),
  ('g', 'c', 'e', GeomFromText('POINT(95 165)')),
  ('e', 'e', 'z', GeomFromText('POINT(98 65)')),
  ('f', 'v', 'i', GeomFromText('POINT(149 144)')),
  ('o', 'p', 'm', GeomFromText('POINT(233 67)')),
  ('t', 'u', 'b', GeomFromText('POINT(109 215)')),
  ('o', 'o', 'b', GeomFromText('POINT(130 48)')),
  ('e', 'm', 'h', GeomFromText('POINT(88 189)')),
  ('e', 'v', 'y', GeomFromText('POINT(55 29)')),
  ('e', 't', 'm', GeomFromText('POINT(129 55)')),
  ('p', 'p', 'i', GeomFromText('POINT(126 222)')),
  ('c', 'i', 'c', GeomFromText('POINT(19 158)')),
  ('c', 'b', 's', GeomFromText('POINT(13 19)')),
  ('u', 'y', 'a', GeomFromText('POINT(114 5)')),
  ('a', 'o', 'f', GeomFromText('POINT(227 232)')),
  ('t', 'c', 'z', GeomFromText('POINT(63 62)')),
  ('d', 'o', 'k', GeomFromText('POINT(48 228)')),
  ('x', 'c', 'e', GeomFromText('POINT(204 2)')),
  ('e', 'e', 'g', GeomFromText('POINT(125 43)')),
  ('o', 'r', 'f', GeomFromText('POINT(171 140)'));
UPDATE t1 set spatial_point=GeomFromText('POINT(163 157)') where  c1 like 'w%';
UPDATE t1 set spatial_point=GeomFromText('POINT(53 151)') where  c1 like 'd%';
UPDATE t1 set spatial_point=GeomFromText('POINT(96 183)') where  c1 like 'r%';
UPDATE t1 set spatial_point=GeomFromText('POINT(57 91)') where  c1 like 'q%';
UPDATE t1 set spatial_point=GeomFromText('POINT(202 110)') where  c1 like 'c%';
UPDATE t1 set spatial_point=GeomFromText('POINT(120 137)') where  c1 like 'w%';
UPDATE t1 set spatial_point=GeomFromText('POINT(207 147)') where  c1 like 'c%';
UPDATE t1 set spatial_point=GeomFromText('POINT(31 125)') where  c1 like 'e%';
UPDATE t1 set spatial_point=GeomFromText('POINT(27 36)') where  c1 like 'r%';
INSERT INTO t1 (c2, c1, c3, spatial_point) VALUES
  ('b', 'c', 'e', GeomFromText('POINT(41 137)')),
  ('p', 'y', 'k', GeomFromText('POINT(50 22)')),
  ('s', 'c', 'h', GeomFromText('POINT(208 173)')),
  ('x', 'u', 'l', GeomFromText('POINT(199 175)')),
  ('s', 'r', 'h', GeomFromText('POINT(85 192)')),
  ('j', 'k', 'u', GeomFromText('POINT(18 25)')),
  ('p', 'w', 'h', GeomFromText('POINT(152 197)')),
  ('e', 'd', 'c', GeomFromText('POINT(229 3)')),
  ('o', 'x', 'k', GeomFromText('POINT(187 155)')),
  ('o', 'b', 'k', GeomFromText('POINT(208 150)')),
  ('d', 'a', 'j', GeomFromText('POINT(70 87)')),
  ('f', 'e', 'k', GeomFromText('POINT(156 96)')),
  ('u', 'y', 'p', GeomFromText('POINT(239 193)')),
  ('n', 'v', 'p', GeomFromText('POINT(223 98)')),
  ('z', 'j', 'r', GeomFromText('POINT(87 89)')),
  ('h', 'x', 'x', GeomFromText('POINT(92 0)')),
  ('r', 'v', 'r', GeomFromText('POINT(159 139)')),
  ('v', 'g', 'g', GeomFromText('POINT(16 229)')),
  ('z', 'k', 'u', GeomFromText('POINT(99 52)')),
  ('p', 'p', 'o', GeomFromText('POINT(105 125)')),
  ('w', 'h', 'y', GeomFromText('POINT(105 154)')),
  ('v', 'y', 'z', GeomFromText('POINT(134 238)')),
  ('x', 'o', 'o', GeomFromText('POINT(178 88)')),
  ('z', 'w', 'd', GeomFromText('POINT(123 60)')),
  ('q', 'f', 'u', GeomFromText('POINT(64 90)')),
  ('s', 'n', 't', GeomFromText('POINT(50 138)')),
  ('v', 'p', 't', GeomFromText('POINT(114 91)')),
  ('a', 'o', 'n', GeomFromText('POINT(78 43)')),