still on memsql6.8.
I get the follow error when I try and insert the following column in a record: Invalid spatial insert in column, reason: ‘Polygon is not valid: ring 0 crosses itself at edges 8 and 535.’")
Could someone define what a ring is and how it can be crossed? From plotting the linestring there does not appear to be any rings.
POLYGON((-103.40985 32.18501, -103.41015 32.18459, -103.41018 32.18455, -103.41026 32.18443, -103.4108 32.18366, -103.41102 32.18336, -103.4119 32.18211, -103.41256 32.18118, -103.41341 32.18119, -103.41745 32.1812, -103.42063 32.18121, -103.4217 32.18121, -103.42382 32.18122, -103.42743 32.18123, -103.43062 32.18123, -103.43196 32.18124, -103.43318 32.18124, -103.43445 32.18125, -103.4356 32.18125, -103.43697 32.18124, -103.43764 32.18124, -103.44004 32.18126, -103.44039 32.18126, -103.44048 32.18125, -103.44055 32.18122, -103.44061 32.18119, -103.44064 32.18117, -103.44067 32.18115, -103.44071 32.18109, -103.44074 32.18098, -103.44079 32.18077, -103.4408 32.18052, -103.4408 32.18047, -103.44081 32.18031, -103.44079 32.17872, -103.44079 32.17868, -103.44077 32.17742, -103.44076 32.17688, -103.44076 32.17683, -103.44077 32.174, -103.44078 32.1731, -103.44078 32.17292, -103.44079 32.17148, -103.4408 32.1704, -103.4408 32.16914, -103.44081 32.16788, -103.44082 32.16716, -103.44098 32.16708, -103.44126 32.16695, -103.44167 32.16687, -103.44198 32.16684, -103.44243 32.16685, -103.44268 32.16685, -103.44433 32.16686, -103.44456 32.16686, -103.44676 32.1669, -103.44711 32.16691, -103.44817 32.16693, -103.44887 32.16694, -103.44916 32.16693, -103.44934 32.16689, -103.44944 32.16683, -103.44961 32.16673, -103.44977 32.16663, -103.44994 32.16652, -103.451 32.16586, -103.45168 32.16549, -103.45188 32.16537, -103.45255 32.16498, -103.45276 32.16485, -103.45304 32.16463, -103.45314 32.16454, -103.45348 32.16419, -103.45374 32.16377, -103.45383 32.16358, -103.45391 32.16342, -103.45391 32.16341, -103.45405 32.16277, -103.4541 32.16229, -103.45421 32.16138, -103.45421 32.16137, -103.4542 32.16052, -103.45414 32.15995, -103.45406 32.15947, -103.45404 32.1594, -103.45373 32.15799, -103.45369 32.15781, -103.45367 32.15775, -103.45352 32.15676, -103.4534 32.15581, -103.4533 32.15447, -103.45319 32.15351, -103.45316 32.15328, -103.45315 32.15316, -103.45309 32.15262, -103.45301 32.1519, -103.45292 32.15078, -103.45292 32.15074, -103.45287 32.15022, -103.45284 32.1499, -103.45279 32.14932, -103.45278 32.14926, -103.45279 32.14914, -103.45288 32.14844, -103.45298 32.14812, -103.45299 32.14808, -103.45323 32.14747, -103.45326 32.1474, -103.45396 32.1457, -103.45488 32.1435, -103.4549 32.14346, -103.4556 32.1418, -103.45567 32.14163, -103.45579 32.14134, -103.45615 32.1406, -103.45622 32.14046, -103.4563 32.1403, -103.45666 32.13959, -103.45681 32.13931, -103.4573 32.13847, -103.45749 32.13812, -103.4578 32.13772, -103.45787 32.13762, -103.45883 32.13675, -103.45943 32.13623, -103.45974 32.13595, -103.46009 32.13563, -103.46041 32.13535, -103.46059 32.13519, -103.46112 32.13471, -103.46147 32.1344, -103.46183 32.13408, -103.46258 32.13339, -103.46321 32.13283, -103.46567 32.13058, -103.46596 32.13033, -103.46627 32.13006, -103.4667 32.12968, -103.46687 32.12954, -103.46745 32.12905, -103.46755 32.12896, -103.46791 32.12868, -103.46827 32.1284, -103.46871 32.12809, -103.46933 32.12767, -103.46989 32.12731, -103.46997 32.12726, -103.47047 32.12694, -103.47072 32.12676, -103.47098 32.12655, -103.47117 32.1264, -103.47133 32.12625, -103.47154 32.12606, -103.47167 32.12593, -103.47179 32.12579, -103.47203 32.12551, -103.47222 32.12529, -103.47242 32.12506, -103.47264 32.12483, -103.47276 32.12472, -103.47288 32.12462, -103.47305 32.12449, -103.47309 32.12446, -103.47343 32.12421, -103.47368 32.12403, -103.47402 32.12382, -103.47429 32.12367, -103.47465 32.12347, -103.47524 32.12315, -103.47553 32.12297, -103.4759 32.12271, -103.47598 32.12264, -103.4767 32.12207, -103.47722 32.12165, -103.47739 32.12152, -103.47825 32.12083, -103.47846 32.12067, -103.47875 32.12044, -103.47928 32.12001, -103.47975 32.11962, -103.48014 32.1193, -103.48047 32.119, -103.48055 32.1189, -103.48063 32.11882, -103.48073 32.1187, -103.48091 32.11844, -103.48097 32.11836, -103.48125 32.11795, -103.48144 32.11767, -103.48175 32.11732, -103.48224 32.11687, -103.48281 32.11644, -103.48325 32.11615, -103.48415 32.11557, -103.48487 32.11514, -103.48512 32.11497, -103.48583 32.1145, -103.48685 32.11379, -103.48693 32.11373, -103.48769 32.11318, -103.48805 32.11297, -103.48848 32.11275, -103.48927 32.1123, -103.48982 32.11186, -103.49034 32.11134, -103.49046 32.11118, -103.49082 32.11073, -103.49119 32.11006, -103.49131 32.10974, -103.49166 32.10881, -103.49169 32.10871, -103.49173 32.1086, -103.4926 32.10612, -103.49271 32.10578, -103.49287 32.10504, -103.49289 32.10489, -103.49299 32.10393, -103.49304 32.10312, -103.49306 32.10256, -103.49306 32.10246, -103.49312 32.1014, -103.49323 32.10088, -103.49333 32.1006, -103.49346 32.10026, -103.49361 32.09992, -103.49361 32.09991, -103.49368 32.09967, -103.49428 32.0975, -103.49441 32.09688, -103.49442 32.09645, -103.49436 32.09596, -103.49432 32.09555, -103.49426 32.09514, -103.49424 32.0946, -103.49426 32.09443, -103.49428 32.09436, -103.49428 32.09434, -103.49429 32.09432, -103.49432 32.09429, -103.49439 32.09425, -103.49446 32.09422, -103.49462 32.0942, -103.49593 32.09407, -103.49665 32.09398, -103.49677 32.09397, -103.49727 32.09387, -103.49761 32.09375, -103.49795 32.09359, -103.49876 32.09319, -103.50004 32.09254, -103.50178 32.09167, -103.50435 32.09032, -103.50561 32.08966, -103.50894 32.08791, -103.51057 32.08706, -103.51183 32.08639, -103.51289 32.08583, -103.51291 32.08582, -103.51417 32.08516, -103.51526 32.08459, -103.51706 32.08364, -103.51832 32.08298, -103.51977 32.08222, -103.52103 32.08156, -103.52143 32.08135, -103.5243 32.07989, -103.52495 32.07957, -103.52539 32.07934, -103.52811 32.07793, -103.52899 32.07748, -103.53157 32.07617, -103.53251 32.0757, -103.53454 32.0747, -103.53564 32.07416, -103.53656 32.0737, -103.53692 32.07353, -103.53748 32.07325, -103.53932 32.07236, -103.54038 32.07185, -103.54209 32.07102, -103.54291 32.07063, -103.54365 32.07027, -103.54408 32.07002, -103.54434 32.06984, -103.54442 32.06977, -103.54463 32.06957, -103.54483 32.06925, -103.54519 32.06857, -103.54564 32.06769, -103.54571 32.06756, -103.54607 32.06685, -103.54631 32.0664, -103.54655 32.06603, -103.54681 32.06571, -103.54694 32.06557, -103.54715 32.06536, -103.54744 32.06512, -103.5493 32.06512, -103.54994 32.06512, -103.55036 32.06512, -103.55079 32.06511, -103.55203 32.0651, -103.55242 32.06508, -103.5526 32.06506, -103.55264 32.06506, -103.55266 32.06506, -103.55284 32.06504, -103.55297 32.06501, -103.55301 32.06499, -103.5532 32.06491, -103.55339 32.06482, -103.55376 32.06465, -103.5538 32.06463, -103.55448 32.06431, -103.55486 32.06411, -103.5552 32.06393, -103.5553 32.06386, -103.55565 32.06352, -103.55571 32.06346, -103.55575 32.06343, -103.55579 32.06338, -103.55629 32.06272, -103.55659 32.06232, -103.55716 32.06156, -103.55727 32.06141, -103.55762 32.06096, -103.55819 32.0602, -103.55826 32.0601, -103.5583 32.06004, -103.55841 32.05989, -103.55898 32.05913, -103.55984 32.05797, -103.56029 32.05736, -103.56127 32.05602, -103.56183 32.05525, -103.5619 32.05515, -103.56267 32.05419, -103.56332 32.05338, -103.5635 32.05315, -103.56408 32.0525, -103.56459 32.05194, -103.56477 32.05174, -103.56494 32.05158, -103.56554 32.05123, -103.56601 32.05115, -103.56658 32.05108, -103.56718 32.051, -103.56824 32.05083, -103.56863 32.05078, -103.56874 32.05076, -103.56889 32.05073, -103.56908 32.05066, -103.56923 32.05059, -103.56949 32.05012, -103.5697 32.04977, -103.56984 32.04951, -103.5707 32.04798, -103.57084 32.04772, -103.57098 32.04745, -103.57126 32.04695, -103.57158 32.04642, -103.57204 32.04561, -103.57213 32.04545, -103.57281 32.04429, -103.57306 32.04384, -103.57361 32.04286, -103.57384 32.04239, -103.57417 32.04185, -103.57448 32.04133, -103.57465 32.04105, -103.57467 32.04101, -103.57486 32.04074, -103.57526 32.04032, -103.57573 32.03982, -103.57704 32.03853, -103.57711 32.03846, -103.57791 32.0376, -103.57838 32.03709, -103.57847 32.03695, -103.57852 32.03681, -103.57854 32.03661, -103.57856 32.03636, -103.57856 32.03605, -103.57858 32.03572, -103.57861 32.03555, -103.57868 32.03521, -103.5789 32.03413, -103.57893 32.03399, -103.57913 32.03318, -103.57916 32.03308, -103.57936 32.03238, -103.57945 32.03206, -103.57975 32.03108, -103.5799 32.03053, -103.58008 32.02993, -103.58049 32.02856, -103.5805 32.02854, -103.58095 32.02705, -103.58146 32.02541, -103.5822 32.02297, -103.58234 32.02253, -103.58247 32.0221, -103.58264 32.02154, -103.58286 32.02082, -103.58307 32.02015, -103.58346 32.01894, -103.58395 32.01739, -103.5843 32.0163, -103.58515 32.0163, -103.58734 32.01629, -103.58989 32.0163, -103.59222 32.0163, -103.59519 32.0163, -103.5971 32.0163, -103.59943 32.0163, -103.60049 32.0163, -103.60155 32.0163, -103.60367 32.0163, -103.60516 32.0163, -103.60664 32.0163, -103.61025 32.0163, -103.61311 32.0163, -103.61392 32.01631, -103.61434 32.01631, -103.6154 32.01631, -103.61731 32.01631, -103.61731 32.01494, -103.61731 32.01458, -103.6173 32.01206, -103.6173 32.01188, -103.6173 32.01044, -103.61729 32.00882, -103.61771 32.00882, -103.61784 32.00881, -103.61793 32.00879, -103.61981 32.00829, -103.62113 32.00794, -103.62164 32.00783, -103.62219 32.00779, -103.62303 32.00779, -103.62333 32.00779, -103.62426 32.00781, -103.62482 32.00781, -103.6255 32.00782, -103.6257 32.00781, -103.62594 32.0078, -103.62781 32.0078, -103.628 32.0078, -103.62886 32.00781, -103.62908 32.0078, -103.63016 32.00777, -103.63035 32.00775, -103.6309 32.00771, -103.63127 32.00776, -103.63559 32.00775, -103.63788 32.00774, -103.63852 32.00774, -103.63876 32.00775, -103.6389 32.00776, -103.63935 32.00779, -103.63983 32.00781, -103.64024 32.00781, -103.6411 32.00782, -103.64307 32.00782, -103.6444 32.00781, -103.64615 32.00782, -103.64647 32.00782, -103.64795 32.00782, -103.64913 32.00781, -103.65058 32.0078, -103.65114 32.00781, -103.65169 32.00779, -103.65172 32.00779, -103.65252 32.0077, -103.65282 32.00771, -103.65313 32.00778, -103.65316 32.00779, -103.65368 32.00807, -103.65437 32.00853, -103.65615 32.0098, -103.65755 32.01081, -103.65825 32.01126, -103.6586 32.01152, -103.65991 32.01244, -103.66154 32.01359, -103.66333 32.01486, -103.66397 32.01531, -103.6648 32.01589, -103.66575 32.01654, -103.66612 32.0168, -103.6671 32.01748, -103.66775 32.01794, -103.66808 32.01817, -103.66813 32.0182, -103.66889 32.01875, -103.66905 32.01888, -103.66958 32.01924, -103.66972 32.01933, -103.67006 32.01953, -103.67048 32.01979, -103.67108 32.02006, -103.67393 32.02138, -103.67505 32.0219, -103.67654 32.02259, -103.67737 32.02297, -103.67784 32.0232, -103.67877 32.02366, -103.67894 32.02374, -103.67987 32.02418, -103.68043 32.02444, -103.6808 32.02463, -103.68098 32.02471, -103.68151 32.02495, -103.68211 32.0252, -103.68253 32.02526, -103.68384 32.02541, -103.68441 32.02549, -103.68444 32.02549, -103.68511 32.02557, -103.68547 32.0256, -103.68592 32.02564, -103.68672 32.02568, -103.68765 32.02571, -103.68801 32.02573, -103.68904 32.02578, -103.69034 32.02583, -103.69161 32.02589, -103.69331 32.02597, -103.69382 32.026, -103.69493 32.02603, -103.69496 32.02603, -103.69629 32.02605, -103.69904 32.02608, -103.69925 32.02608, -103.6996 32.02608, -103.69989 32.02608, -103.40985 32.18501))