[ad_1]
I have a table with geometries stored as text. I am attempting to query the table and create a spatial index as I need to be able to filter by location and use spatial functions.
I have attempted to query and store data is different ways, however, I haven’t had much luck.
Is there a way to check for valid geometries (stored as text) and then query them? I keep getting Invalid GIS data provided to function error.
I am on the latest version of MySQL 8.0.
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html#function_st-isvalid
CREATE TABLE `geo` (`id` int, `geometry` text);
INSERT INTO `geo` VALUES (1, 'POLYGON((-80.960868 35.171999, -80.960824 35.171942, -80.960747 35.171859, -80.960637 35.171754, -80.960507 35.171676, -80.960404 35.171628, -80.960309 35.171598, -80.959202 35.171415, -80.959001 35.171374, -80.958889 35.171351, -80.958564 35.171285, -80.957318 35.171015, -80.956585 35.170856, -80.955659 35.170662, -80.955213 35.170579, -80.954875 35.170537, -80.954561 35.170515, -80.954387 35.170512, -80.954381 35.169877, -80.954364 35.169242, -80.95434 35.168836, -80.954315 35.16849, -80.953085 35.168556, -80.952896 35.168543, -80.952745 35.16852, -80.952531 35.168456, -80.95188 35.168214, -80.951785 35.168189, -80.951685 35.168175, -80.945631 35.16812, -80.945524 35.168111, -80.945316 35.168062, -80.945126 35.167981, -80.943684 35.169989, -80.943621 35.170103, -80.943513 35.170501, -80.943443 35.170493, -80.94334 35.170472, -80.943204 35.170437, -80.943055 35.170376, -80.942959 35.170325, -80.942859 35.170265, -80.942813 35.170233, -80.942606 35.170071, -80.941492 35.169094, -80.940937 35.168605, -80.940858 35.168535, -80.940839 35.168518, -80.940325 35.168074, -80.940268 35.168025, -80.940134 35.167893, -80.940116 35.167875, -80.939932 35.167644, -80.939878 35.167565, -80.939648 35.167171, -80.939598 35.167089, -80.939378 35.166726, -80.93918 35.166413, -80.939086 35.166281, -80.939051 35.166238, -80.938928 35.166085, -80.938842 35.165993, -80.938708 35.16587, -80.938699 35.165862, -80.938467 35.16568, -80.938231 35.16551, -80.938211 35.165496, -80.937793 35.165196, -80.93759 35.165051, -80.937495 35.164986, -80.937319 35.164876, -80.937141 35.164773, -80.93662 35.164492, -80.93594 35.164117, -80.93543 35.163845, -80.935187 35.163739, -80.935 35.163682, -80.934866 35.163657, -80.934722 35.163645, -80.934598 35.163643, -80.934527 35.163647, -80.934379 35.163663, -80.934221 35.163696, -80.934035 35.163747, -80.932992 35.164111, -80.932906 35.164129, -80.932818 35.164143, -80.932646 35.164145, -80.932564 35.164134, -80.932409 35.164097, -80.932244 35.164034, -80.932147 35.163985, -80.93146 35.163591, -80.93124 35.163476, -80.931054 35.163391, -80.930892 35.163324, -80.930741 35.163271, -80.930499 35.1632, -80.930452 35.163186, -80.930196 35.163125, -80.929977 35.163085, -80.929754 35.163055, -80.929646 35.163047, -80.92939 35.163043, -80.929356 35.163042, -80.928988 35.16306, -80.927549 35.163188, -80.925994 35.163319, -80.925018 35.163402, -80.924865 35.163414, -80.924512 35.163445, -80.922353 35.163629, -80.921424 35.163717, -80.921222 35.163741, -80.921156 35.163565, -80.920932 35.163058, -80.920748 35.162659, -80.920694 35.16253, -80.920663 35.162437, -80.92064 35.16235, -80.920629 35.162295, -80.920621 35.162256, -80.920609 35.162129, -80.920613 35.162024, -80.920637 35.161864, -80.920642 35.161831, -80.920789 35.161309, -80.921002 35.160639, -80.921025 35.160557, -80.921053 35.160458, -80.921061 35.160393, -80.921071 35.160303, -80.92106 35.160189, -80.921185 35.16018, -80.921327 35.160187, -80.921518 35.160208, -80.921553 35.160209, -80.921612 35.160218, -80.921971 35.160366, -80.922133 35.16044, -80.922292 35.160551, -80.922465 35.16082, -80.92256 35.160963, -80.92362 35.161248, -80.923773 35.161184, -80.923828 35.16112, -80.924076 35.160658, -80.924325 35.160197, -80.924338 35.1602, -80.924607 35.159632, -80.924711 35.15963, -80.924836 35.15964, -80.924986 35.159663, -80.925175 35.159648, -80.925395 35.159632, -80.925614 35.159662, -80.925675 35.159682, -80.92587 35.159771, -80.925937 35.159797, -80.926136 35.159841, -80.926193 35.159843, -80.92663 35.15932, -80.926678 35.159289, -80.926706 35.15925, -80.926724 35.159205, -80.926742 35.15914, -80.926806 35.158813, -80.926818 35.15873, -80.926502 35.158689, -80.926195 35.158655, -80.92594 35.158621, -80.925676 35.158611, -80.925594 35.158617, -80.925447 35.158642, -80.9253 35.158681, -80.924824 35.158848, -80.924774 35.158781, -80.924734 35.158744, -80.924621 35.158677, -80.923926 35.158349, -80.923797 35.158278, -80.923766 35.158253, -80.923717 35.158194, -80.923655 35.158083, -80.92364 35.158025, -80.923648 35.157877, -80.92366 35.157435, -80.923659 35.15735, -80.923641 35.157263, -80.92361 35.157193, -80.923577 35.157145, -80.923516 35.157088, -80.923471 35.157057, -80.923389 35.157013, -80.923285 35.156977, -80.923098 35.156931, -80.922372 35.156731, -80.92246 35.156538, -80.922492 35.156469, -80.922708 35.155943, -80.92286 35.155546, -80.923009 35.155125, -80.923081 35.154901, -80.923187 35.154632, -80.923289 35.15431, -80.9238 35.152998, -80.924037 35.152377, -80.924186 35.151987, -80.924338 35.151572, -80.924505 35.151171, -80.924881 35.150225, -80.925209 35.149404, -80.925478 35.148728, -80.925519 35.148623, -80.925822 35.147868, -80.925913 35.147642, -80.926011 35.147397, -80.926163 35.147036, -80.924361 35.146058, -80.923203 35.145417, -80.92144 35.144472, -80.921 35.144237, -80.920305 35.143866, -80.919988 35.143696, -80.919571 35.143464, -80.918241 35.142777, -80.917569 35.14243, -80.914795 35.141141, -80.912945 35.140282, -80.911641 35.139677, -80.910976 35.139375, -80.909737 35.138823, -80.908775 35.138391, -80.907988 35.138038, -80.907725 35.13792, -80.907404 35.137776, -80.907319 35.137738, -80.907203 35.137686, -80.90716 35.137667, -80.906829 35.137518, -80.906528 35.137383, -80.905819 35.137065, -80.90562 35.136976, -80.905196 35.136786, -80.905127 35.136754, -80.904644 35.13653, -80.903458 35.135983, -80.901911 35.135265, -80.901286 35.134981, -80.900389 35.134557, -80.899679 35.134221, -80.899391 35.134092, -80.899215 35.134013, -80.898812 35.133844, -80.898609 35.133778, -80.898399 35.133728, -80.898185 35.133696, -80.898023 35.133683, -80.897837 35.133691, -80.897747 35.133703, -80.897472 35.133766, -80.897294 35.133825, -80.897145 35.133886, -80.89687 35.134015, -80.896628 35.134148, -80.896377 35.134312, -80.895715 35.134691, -80.895518 35.134784, -80.89531 35.134861, -80.895052 35.134935, -80.894484 35.135053, -80.89305 35.135322, -80.891998 35.135509, -80.891848 35.13554, -80.891455 35.135621, -80.890107 35.135926, -80.888476 35.136306, -80.887888 35.136443, -80.886955 35.136665, -80.88656 35.136758, -80.886168 35.136845, -80.885886 35.136908, -80.885699 35.136953, -80.885605 35.136976, -80.884322 35.137279, -80.883923 35.137373, -80.881648 35.137903, -80.881462 35.137936, -80.881319 35.137956, -80.881034 35.137983, -80.88082 35.137994, -80.880529 35.137989, -80.880213 35.137963, -80.879351 35.13784, -80.878647 35.137737, -80.87837 35.137706, -80.878078 35.137692, -80.878024 35.137691, -80.877931 35.13769, -80.876681 35.137713, -80.876335 35.137719, -80.876579 35.138963, -80.876561 35.139869, -80.876504 35.142861, -80.876483 35.143847, -80.876468 35.144614, -80.876477 35.14487, -80.876456 35.145606, -80.876432 35.146787, -80.876407 35.147758, -80.876407 35.147866, -80.874729 35.147859, -80.874286 35.147858, -80.874142 35.147863, -80.873938 35.147888, -80.873798 35.14791, -80.873895 35.148264, -80.873905 35.148372, -80.873894 35.14848, -80.873865 35.148578, -80.874268 35.148685, -80.874436 35.148741, -80.874564 35.148802, -80.874623 35.148839, -80.87473 35.148922, -80.875031 35.149207, -80.874715 35.149431, -80.874605 35.14952, -80.874511 35.149621, -80.874436 35.149732, -80.87433 35.149938, -80.87428 35.150021, -80.874499 35.150107, -80.874606 35.150168, -80.874655 35.150204, -80.8747 35.150244, -80.87474 35.150287, -80.874784 35.150353, -80.874823 35.150448, -80.874841 35.150547, -80.874817 35.151784, -80.8748 35.151988, -80.87468 35.152698, -80.874645 35.152901, -80.874631 35.153056, -80.874598 35.154585, -80.874583 35.155498, -80.874576 35.15556, -80.874561 35.155632, -80.87452 35.155741, -80.874491 35.155792, -80.874419 35.155889, -80.87428 35.156034, -80.874524 35.1562, -80.874956 35.156504, -80.875079 35.156578, -80.875232 35.156653, -80.875379 35.156705, -80.875533 35.156741, -80.875612 35.156752, -80.875871 35.156772, -80.876007 35.156776, -80.876247 35.156776, -80.876223 35.158099, -80.876208 35.158486, -80.8762 35.159052, -80.876187 35.159546, -80.876177 35.160443, -80.876164 35.160799, -80.876161 35.161076, -80.876096 35.161967, -80.876092 35.162908, -80.876091 35.163129, -80.876158 35.163983, -80.876152 35.164767, -80.876139 35.164923, -80.876056 35.166492, -80.876044 35.16717, -80.87604 35.167785, -80.876032 35.168213, -80.876014 35.168732, -80.876009 35.169391, -80.87599 35.170091, -80.875944 35.172618, -80.875944 35.17272, -80.875945 35.172954, -80.875959 35.173362, -80.875954 35.173667, -80.875952 35.173773, -80.875928 35.175059, -80.875902 35.17557, -80.875876 35.176484, -80.87856 35.177593, -80.879386 35.177935, -80.87943 35.177948, -80.879462 35.178435, -80.879462 35.179563, -80.879359 35.180691, -80.879113 35.181901, -80.878539 35.183953, -80.877903 35.185594, -80.877139 35.186966, -80.876918 35.187358, -80.876539 35.18813, -80.876385 35.188445, -80.875665 35.189576, -80.87549 35.189851, -80.875347 35.189821, -80.875131 35.190253, -80.874613 35.191168, -80.873958 35.192341, -80.873728 35.192734, -80.873417 35.193293, -80.873177 35.19372, -80.872991 35.194036, -80.872928 35.194156, -80.872848 35.194292, -80.872548 35.194804, -80.872709 35.194858, -80.872496 35.195216, -80.872317 35.195518, -80.872022 35.195986, -80.87165 35.196489, -80.870493 35.197949, -80.869442 35.199404, -80.869524 35.199437, -80.869987 35.199692, -80.870115 35.199769, -80.870169 35.199807, -80.870926 35.199296, -80.87097 35.199273, -80.871074 35.199234, -80.87113 35.199222, -80.871244 35.19921, -80.871302 35.199212, -80.871415 35.199228, -80.871499 35.199249, -80.871617 35.199306, -80.872614 35.199886, -80.87363 35.200464, -80.873825 35.200223, -80.874824 35.200743, -80.875861 35.199418, -80.875436 35.199197, -80.874874 35.198876, -80.875681 35.197837, -80.876139 35.197247, -80.877215 35.195861, -80.877605 35.195995, -80.879055 35.196527, -80.879327 35.196623, -80.88081 35.197148, -80.88147 35.197386, -80.881733 35.197482, -80.881731 35.198811, -80.881721 35.199006, -80.881695 35.199308, -80.881619 35.199715, -80.881577 35.200005, -80.88151 35.200177, -80.881361 35.200515, -80.881106 35.201037, -80.880663 35.202017, -80.880648 35.202057, -80.880406 35.202534, -80.880183 35.202936, -80.880274 35.203112, -80.880479 35.2035, -80.88059 35.203613, -80.880657 35.203697, -80.880697 35.203774, -80.880742 35.203932, -80.880753 35.204167, -80.88079 35.204228, -80.880801 35.204263, -80.88077 35.204316, -80.880776 35.204357, -80.880801 35.204409, -80.880799 35.204486, -80.880783 35.204527, -80.880783 35.204564, -80.880811 35.204614, -80.880838 35.204681, -80.880854 35.204766, -80.880848 35.204819, -80.880827 35.204871, -80.880816 35.204933, -80.880843 35.205089, -80.880854 35.205197, -80.880845 35.205264, -80.880827 35.205322, -80.880831 35.205364, -80.880866 35.205424, -80.880888 35.20551, -80.880911 35.205649, -80.880972 35.205761, -80.881091 35.205809, -80.881376 35.205921, -80.881459 35.205973, -80.881569 35.20605, -80.881725 35.206142, -80.881961 35.206303, -80.882105 35.206423, -80.882153 35.206476, -80.882246 35.206539, -80.8824 35.206569, -80.88253 35.20659, -80.882647 35.207232, -80.882673 35.207334, -80.882726 35.207457, -80.882799 35.207579, -80.882895 35.207714, -80.882985 35.207836, -80.883174 35.207733, -80.883296 35.207625, -80.883356 35.207573, -80.883751 35.207113, -80.883921 35.206937, -80.884121 35.206776, -80.884426 35.206649, -80.884595 35.206546, -80.884692 35.206508, -80.884816 35.206467, -80.884997 35.206414, -80.885346 35.206438, -80.885698 35.206564, -80.885824 35.206678, -80.885995 35.206902, -80.886467 35.207077, -80.886572 35.207203, -80.886671 35.20747, -80.886878 35.207631, -80.887112 35.207702, -80.887329 35.207751, -80.887525 35.207794, -80.887659 35.207838, -80.887926 35.207924, -80.88825 35.207961, -80.888477 35.208041, -80.888828 35.208137, -80.889023 35.208179, -80.889295 35.208227, -80.889477 35.208164, -80.889549 35.208139, -80.889747 35.208027, -80.889949 35.207907, -80.890385 35.207547, -80.890473 35.207493, -80.890463 35.207314, -80.890589 35.207146, -80.890795 35.206981, -80.891297 35.206556, -80.891587 35.206226, -80.891864 35.205843, -80.892276 35.205495, -80.892399 35.205314, -80.89261 35.205158, -80.892729 35.205071, -80.893012 35.204925, -80.893219 35.204861, -80.893379 35.204791, -80.893449 35.204762, -80.893499 35.204738, -80.893963 35.204509, -80.894132 35.204286, -80.894218 35.2042, -80.894415 35.204, -80.894467 35.203844, -80.894736 35.203521, -80.89497 35.203339, -80.895274 35.20295, -80.895523 35.202726, -80.895776 35.202551, -80.896288 35.202301, -80.896395 35.202217, -80.896452 35.20215, -80.896632 35.201942, -80.896728 35.201828, -80.896834 35.201662, -80.896894 35.20157, -80.897026 35.201364, -80.897096 35.201164, -80.897706 35.200628, -80.897862 35.200586, -80.897992 35.200538, -80.899057 35.200117, -80.899534 35.199936, -80.899622 35.199904, -80.900127 35.199712, -80.901171 35.199264, -80.902137 35.19895, -80.90219 35.198927, -80.903118 35.198585, -80.903788 35.198335, -80.904255 35.19816, -80.904493 35.19801, -80.905027 35.197673, -80.906356 35.196809, -80.907462 35.195715, -80.907937 35.19517, -80.907994 35.195064, -80.908146 35.194776, -80.908191 35.19448, -80.908196 35.194164, -80.90836 35.194024, -80.908946 35.193814, -80.909026 35.193774, -80.909162 35.193705, -80.909455 35.193585, -80.909671 35.193465, -80.909914 35.193419, -80.91007 35.193491, -80.910215 35.193689, -80.910384 35.19377, -80.91068 35.193766, -80.911064 35.193696, -80.911484 35.193542, -80.911854 35.19342, -80.912241 35.193498, -80.912757 35.193554, -80.913066 35.19358, -80.913903 35.193672, -80.914352 35.193634, -80.914977 35.193364, -80.915092 35.193525, -80.915224 35.193622, -80.915269 35.193715, -80.915287 35.193843, -80.915392 35.194115, -80.915466 35.194247, -80.915569 35.194311, -80.915706 35.194372, -80.91587 35.194393, -80.916118 35.194414, -80.916333 35.194432, -80.916595 35.194454, -80.917032 35.19447, -80.917256 35.194411, -80.917359 35.194361, -80.917608 35.194216, -80.917713 35.194202, -80.917988 35.194248, -80.918122 35.194344, -80.918401 35.194001, -80.919099 35.193132, -80.919603 35.192492, -80.919963 35.192038, -80.920318 35.191601, -80.920675 35.191181, -80.920958 35.190828, -80.921176 35.190533, -80.921294 35.190345, -80.921404 35.190144, -80.921501 35.189927, -80.921548 35.189798, -80.921576 35.189703, -80.921905 35.189788, -80.922442 35.189892, -80.922971 35.18998, -80.923204 35.190048, -80.92346 35.190122, -80.92371 35.190176, -80.923921 35.190217, -80.924103 35.190218, -80.924226 35.19021, -80.924473 35.190177, -80.924764 35.190119, -80.925298 35.190035, -80.925942 35.189917, -80.92675 35.18978, -80.927286 35.189697, -80.927771 35.1896, -80.927953 35.189578, -80.92811 35.189568, -80.928392 35.18958, -80.928468 35.189592, -80.928726 35.189652, -80.928887 35.189705, -80.929047 35.189772, -80.929171 35.189837, -80.929256 35.189906, -80.929594 35.190214, -80.929959 35.190582, -80.930311 35.190923, -80.930549 35.190773, -80.930826 35.19062, -80.931236 35.190464, -80.931373 35.190434, -80.931488 35.190484, -80.933457 35.192469, -80.933566 35.192506, -80.933791 35.192521, -80.93545 35.19251, -80.935502 35.192928, -80.935547 35.193407, -80.937908 35.193287, -80.938504 35.193255, -80.938594 35.19325, -80.939329 35.193234, -80.939801 35.193232, -80.94 35.19324, -80.940672 35.193261, -80.941028 35.193263, -80.941348 35.193278, -80.941514 35.19328, -80.941662 35.193277, -80.941819 35.193268, -80.94199 35.193253, -80.942298 35.193208, -80.943015 35.193058, -80.943954 35.19287, -80.944441 35.19277, -80.944653 35.19273, -80.944904 35.192695, -80.945169 35.192672, -80.945361 35.192664, -80.945524 35.192663, -80.94573 35.192656, -80.946061 35.192654, -80.946672 35.19264, -80.946821 35.19263, -80.947027 35.192608, -80.947192 35.19258, -80.947322 35.192548, -80.947455 35.192507, -80.947624 35.192445, -80.947865 35.192346, -80.948222 35.192192, -80.948279 35.192298, -80.948323 35.192397, -80.94835 35.192473, -80.948367 35.192561, -80.948348 35.192703, -80.948244 35.193044, -80.947857 35.19414, -80.94778 35.19432, -80.947703 35.194471, -80.947562 35.194703, -80.9474 35.194925, -80.947237 35.195119, -80.947075 35.195279, -80.946948 35.195394, -80.946747 35.19555, -80.946503 35.195724, -80.946287 35.195891, -80.946098 35.196076, -80.945916 35.196284, -80.945754 35.196505, -80.945673 35.196635, -80.945599 35.196768, -80.945507 35.19697, -80.945954 35.196876, -80.946419 35.196809, -80.947016 35.196732, -80.947574 35.196647, -80.949373 35.196375, -80.949834 35.196301, -80.950298 35.19622, -80.950788 35.196123, -80.95119 35.196036, -80.951701 35.195912, -80.952211 35.195776, -80.952694 35.195637, -80.953072 35.19552, -80.953662 35.195325, -80.954478 35.194966, -80.954807 35.19479, -80.955087 35.194592, -80.955205 35.194831, -80.955224 35.194825, -80.956427 35.194437, -80.957577 35.194071, -80.957917 35.193969, -80.958538 35.193776, -80.959034 35.193626, -80.958772 35.192915, -80.958687 35.192661, -80.958507 35.192062, -80.958316 35.191357, -80.958198 35.190891, -80.958067 35.190368, -80.957978 35.189967, -80.957973 35.189946, -80.957959 35.189783, -80.957967 35.189614, -80.958152 35.189059, -80.958353 35.188558, -80.958682 35.187768, -80.959064 35.186818, -80.959081 35.186773, -80.959134 35.186628, -80.959174 35.186504, -80.95921 35.186345, -80.959221 35.18618, -80.95921 35.18603, -80.959178 35.185851, -80.959153 35.185757, -80.959107 35.18563, -80.959091 35.185595, -80.959036 35.185478, -80.958947 35.185312, -80.958863 35.185172, -80.958542 35.184692, -80.958385 35.184474, -80.958253 35.184308, -80.958073 35.184113, -80.957943 35.18399, -80.957794 35.183864, -80.95759 35.183717, -80.957475 35.183639, -80.957194 35.183463, -80.956993 35.183328, -80.956903 35.183261, -80.956757 35.183133, -80.956712 35.183089, -80.95662 35.182981, -80.956559 35.182891, -80.956489 35.182765, -80.95644 35.182645, -80.956408 35.182534, -80.956392 35.182435, -80.956387 35.18224, -80.956396 35.182108, -80.956416 35.181972, -80.956613 35.180937, -80.956677 35.180603, -80.956859 35.179635, -80.956928 35.179345, -80.956968 35.179207, -80.957067 35.178919, -80.957345 35.1782, -80.957434 35.17797, -80.95791 35.176742, -80.958085 35.176299, -80.958455 35.175325, -80.958556 35.17501, -80.958656 35.174698, -80.958834 35.174114, -80.959026 35.173485, -80.959052 35.173419, -80.959144 35.173234, -80.959213 35.173124, -80.95927 35.17305, -80.959402 35.172915, -80.959519 35.172825, -80.959699 35.172701, -80.960212 35.172391, -80.960422 35.172269, -80.960868 35.171999)) POLYGON ((35.171999 -80.960868, 35.171942 -80.960824, 35.171859 -80.960747, 35.171754 -80.960637, 35.171676 -80.960507, 35.171628 -80.960404, 35.171598 -80.960309, 35.171415 -80.959202, 35.171374 -80.959001, 35.171351 -80.958889, 35.171285 -80.958564, 35.171015 -80.957318, 35.170856 -80.956585, 35.170662 -80.955659, 35.170579 -80.955213, 35.170537 -80.954875, 35.170515 -80.954561, 35.170512 -80.954387, 35.169877 -80.954381, 35.169242 -80.954364, 35.168836 -80.95434, 35.16849 -80.954315, 35.168556 -80.953085, 35.168543 -80.952896, 35.16852 -80.952745, 35.168456 -80.952531, 35.168214 -80.95188, 35.168189 -80.951785, 35.168175 -80.951685, 35.16812 -80.945631, 35.168111 -80.945524, 35.168062 -80.945316, 35.167981 -80.945126, 35.169989 -80.943684, 35.170103 -80.943621, 35.170501 -80.943513, 35.170493 -80.943443, 35.170472 -80.94334, 35.170437 -80.943204, 35.170376 -80.943055, 35.170325 -80.942959, 35.170265 -80.942859, 35.170233 -80.942813, 35.170071 -80.942606, 35.169094 -80.941492, 35.168605 -80.940937, 35.168535 -80.940858, 35.168518 -80.940839, 35.168074 -80.940325, 35.168025 -80.940268, 35.167893 -80.940134, 35.167875 -80.940116, 35.167644 -80.939932, 35.167565 -80.939878, 35.167171 -80.939648, 35.167089 -80.939598, 35.166726 -80.939378, 35.166413 -80.93918, 35.166281 -80.939086, 35.166238 -80.939051, 35.166085 -80.938928, 35.165993 -80.938842, 35.16587 -80.938708, 35.165862 -80.938699, 35.16568 -80.938467, 35.16551 -80.938231, 35.165496 -80.938211, 35.165196 -80.937793, 35.165051 -80.93759, 35.164986 -80.937495, 35.164876 -80.937319, 35.164773 -80.937141, 35.164492 -80.93662, 35.164117 -80.93594, 35.163845 -80.93543, 35.163739 -80.935187, 35.163682 -80.935, 35.163657 -80.934866, 35.163645 -80.934722, 35.163643 -80.934598, 35.163647 -80.934527, 35.163663 -80.934379, 35.163696 -80.934221, 35.163747 -80.934035, 35.164111 -80.932992, 35.164129 -80.932906, 35.164143 -80.932818, 35.164145 -80.932646, 35.164134 -80.932564, 35.164097 -80.932409, 35.164034 -80.932244, 35.163985 -80.932147, 35.163591 -80.93146, 35.163476 -80.93124, 35.163391 -80.931054, 35.163324 -80.930892, 35.163271 -80.930741, 35.1632 -80.930499, 35.163186 -80.930452, 35.163125 -80.930196, 35.163085 -80.929977, 35.163055 -80.929754, 35.163047 -80.929646, 35.163043 -80.92939, 35.163042 -80.929356, 35.16306 -80.928988, 35.163188 -80.927549, 35.163319 -80.925994, 35.163402 -80.925018, 35.163414 -80.924865, 35.163445 -80.924512, 35.163629 -80.922353, 35.163717 -80.921424, 35.163741 -80.921222, 35.163565 -80.921156, 35.163058 -80.920932, 35.162659 -80.920748, 35.16253 -80.920694, 35.162437 -80.920663, 35.16235 -80.92064, 35.162295 -80.920629, 35.162256 -80.920621, 35.162129 -80.920609, 35.162024 -80.920613, 35.161864 -80.920637, 35.161831 -80.920642, 35.161309 -80.920789, 35.160639 -80.921002, 35.160557 -80.921025, 35.160458 -80.921053, 35.160393 -80.921061, 35.160303 -80.921071, 35.160189 -80.92106, 35.16018 -80.921185, 35.160187 -80.921327, 35.160208 -80.921518, 35.160209 -80.921553, 35.160218 -80.921612, 35.160366 -80.921971, 35.16044 -80.922133, 35.160551 -80.922292, 35.16082 -80.922465, 35.160963 -80.92256, 35.161248 -80.92362, 35.161184 -80.923773, 35.16112 -80.923828, 35.160658 -80.924076, 35.160197 -80.924325, 35.1602 -80.924338, 35.159632 -80.924607, 35.15963 -80.924711, 35.15964 -80.924836, 35.159663 -80.924986, 35.159648 -80.925175, 35.159632 -80.925395, 35.159662 -80.925614, 35.159682 -80.925675, 35.159771 -80.92587, 35.159797 -80.925937, 35.159841 -80.926136, 35.159843 -80.926193, 35.15932 -80.92663, 35.159289 -80.926678, 35.15925 -80.926706, 35.159205 -80.926724, 35.15914 -80.926742, 35.158813 -80.926806, 35.15873 -80.926818, 35.158689 -80.926502, 35.158655 -80.926195, 35.158621 -80.92594, 35.158611 -80.925676, 35.158617 -80.925594, 35.158642 -80.925447, 35.158681 -80.9253, 35.158848 -80.924824, 35.158781 -80.924774, 35.158744 -80.924734, 35.158677 -80.924621, 35.158349 -80.923926, 35.158278 -80.923797, 35.158253 -80.923766, 35.158194 -80.923717, 35.158083 -80.923655, 35.158025 -80.92364, 35.157877 -80.923648, 35.157435 -80.92366, 35.15735 -80.923659, 35.157263 -80.923641, 35.157193 -80.92361, 35.157145 -80.923577, 35.157088 -80.923516, 35.157057 -80.923471, 35.157013 -80.923389, 35.156977 -80.923285, 35.156931 -80.923098, 35.156731 -80.922372, 35.156538 -80.92246, 35.156469 -80.922492, 35.155943 -80.922708, 35.155546 -80.92286, 35.155125 -80.923009, 35.154901 -80.923081, 35.154632 -80.923187, 35.15431 -80.923289, 35.152998 -80.9238, 35.152377 -80.924037, 35.151987 -80.924186, 35.151572 -80.924338, 35.151171 -80.924505, 35.150225 -80.924881, 35.149404 -80.925209, 35.148728 -80.925478, 35.148623 -80.925519, 35.147868 -80.925822, 35.147642 -80.925913, 35.147397 -80.926011, 35.147036 -80.926163, 35.146058 -80.924361, 35.145417 -80.923203, 35.144472 -80.92144, 35.144237 -80.921, 35.143866 -80.920305, 35.143696 -80.919988, 35.143464 -80.919571, 35.142777 -80.918241, 35.14243 -80.917569, 35.141141 -80.914795, 35.140282 -80.912945, 35.139677 -80.911641, 35.139375 -80.910976, 35.138823 -80.909737, 35.138391 -80.908775, 35.138038 -80.907988, 35.13792 -80.907725, 35.137776 -80.907404, 35.137738 -80.907319, 35.137686 -80.907203, 35.137667 -80.90716, 35.137518 -80.906829, 35.137383 -80.906528, 35.137065 -80.905819, 35.136976 -80.90562, 35.136786 -80.905196, 35.136754 -80.905127, 35.13653 -80.904644, 35.135983 -80.903458, 35.135265 -80.901911, 35.134981 -80.901286, 35.134557 -80.900389, 35.134221 -80.899679, 35.134092 -80.899391, 35.134013 -80.899215, 35.133844 -80.898812, 35.133778 -80.898609, 35.133728 -80.898399, 35.133696 -80.898185, 35.133683 -80.898023, 35.133691 -80.897837, 35.133703 -80.897747, 35.133766 -80.897472, 35.133825 -80.897294, 35.133886 -80.897145, 35.134015 -80.89687, 35.134148 -80.896628, 35.134312 -80.896377, 35.134691 -80.895715, 35.134784 -80.895518, 35.134861 -80.89531, 35.134935 -80.895052, 35.135053 -80.894484, 35.135322 -80.89305, 35.135509 -80.891998, 35.13554 -80.891848, 35.135621 -80.891455, 35.135926 -80.890107, 35.136306 -80.888476, 35.136443 -80.887888, 35.136665 -80.886955, 35.136758 -80.88656, 35.136845 -80.886168, 35.136908 -80.885886, 35.136953 -80.885699, 35.136976 -80.885605, 35.137279 -80.884322, 35.137373 -80.883923, 35.137903 -80.881648, 35.137936 -80.881462, 35.137956 -80.881319, 35.137983 -80.881034, 35.137994 -80.88082, 35.137989 -80.880529, 35.137963 -80.880213, 35.13784 -80.879351, 35.137737 -80.878647, 35.137706 -80.87837, 35.137692 -80.878078, 35.137691 -80.878024, 35.13769 -80.877931, 35.137713 -80.876681, 35.137719 -80.876335, 35.138963 -80.876579, 35.139869 -80.876561, 35.142861 -80.876504, 35.143847 -80.876483, 35.144614 -80.876468, 35.14487 -80.876477, 35.145606 -80.876456, 35.146787 -80.876432, 35.147758 -80.876407, 35.147866 -80.876407, 35.147859 -80.874729, 35.147858 -80.874286 ))');
SELECT `id`, ST_PolygonFromText(geometry) FROM `geo`;
SELECT ST_GeomFromText(geometry, 4326, 'axis-order=lat-long')
FROM `geo`;
I am not very familiar with using try / catch or exception handler in MySQL. Is there is way to handle exception and query the geometries? I’d like to either read the data as geometry or create a spatial index on the table and save the column as geometry.
[ad_2]