Last active
August 29, 2015 14:17
-
-
Save dlebauer/215ccdf2051fa0433b24 to your computer and use it in GitHub Desktop.
invalid geom
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select ST_isvalid( | |
| ST_SetSRID ( | |
| ST_MakePolygon ( | |
| ST_GeomFromText ( | |
| 'LINESTRING(-90.9112091064453 39.8377532958984 219.834060668945, | |
| -87.9547500610352 38.8522682189941 136.305511474609, | |
| -87.6338958740234 39.1731262207031 134.396545410156, | |
| -87.5765991210938 39.0642623901367 131.822998046875, | |
| -90.9112091064453 39.8377532958984 219.834060668945)' | |
| ) | |
| ), | |
| 4326 | |
| )) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| ST_isvalid ( | |
| ST_SetSRID ( | |
| ST_MakePolygon ( | |
| ST_Force_3D ( | |
| ST_GeomFromText ( | |
| 'LINESTRING(-90.9112091064453 39.8377532958984 219.834060668945,-91.4497909545898 39.8549423217773 146.471527099609,-91.4669799804688 40.0096435546875 147.479156494141,-89.2152633666992 37.345386505127 135.113784790039,-89.249641418457 37.2709045410156 104.617362976074,-89.2668228149414 37.1964225769043 98.1575469970703,-89.2610931396484 37.1104774475098 99.0588684082031,-89.1808776855469 37.070369720459 89.4199981689453,-89.2439041137695 37.070369720459 97.2477645874023,-89.2610931396484 37.0245323181152 93.3310241699219,-89.3527679443359 37.0417213439941 98.3858489990234,-89.4444427490234 37.1792297363281 99.0061950683594,-89.5131912231445 37.2880935668945 100.97200012207,-89.2782821655273 38.7319450378418 135,-89.6392440795898 39.0012359619141 171.242950439453,-89.2610931396484 39.0069694519043 194.216064453125,-88.9402389526367 42.496280670166 246.150573730469,-88.9402389526367 42.1582374572754 228.483947753906,-90.69921875 40.0898551940918 154.994567871094,-90.607551574707 39.9752655029297 179.893478393555,-90.5445175170898 39.9294281005859 131.880294799805,-90.9112091064453 39.8377532958984 219.834060668945,-89.2152633666992 41.3159866333008 136.581008911133,-89.34130859375 41.2529640197754 154.834594726562,-89.6392440795898 41.144100189209 236.609802246094,-89.8512420654297 41.4821434020996 188.784149169922,-90.6361923217773 39.3965797424316 159.01286315918,-90.607551574707 39.2304191589355 127.276756286621,-90.6018142700195 39.0814514160156 132.723663330078,-90.5216064453125 38.9496688842773 127.450004577637,-90.5445175170898 38.8866424560547 145.635192871094,-90.6705703735352 38.9152946472168 132.828231811523,-90.69921875 39.1100997924805 131.726852416992,-90.7450561523438 39.2361526489258 134.676712036133,-90.9341354370117 39.4023056030273 136.770004272461,-90.16064453125 41.9347801208496 178.332763671875,-90.16064453125 42.1009368896484 179.607543945312,-89.9199905395508 42.2040710449219 270.569915771484,-90.429931640625 40.044017791748 142.951614379883,-90.3611755371094 40.1185073852539 148.15104675293,-90.2866897583008 40.0497512817383 136.223358154297,-90.1720962524414 40.061206817627 137.178863525391,-90.0345916748047 40.1013145446777 140.534698486328,-89.9944839477539 39.8664054870605 190.414138793945,-90.5273361206055 39.9638061523438 132.142639160156,-88.0120468139648 40.3935241699219 226.048049926758,-87.9432907104492 40.2216377258301 221.840393066406,-88.4646835327148 40.2159080505371 235.495758056641,-89.1407699584961 39.3507423400879 203.95671081543,-89.4788208007812 39.6372184753418 178.214004516602,-89.3871459960938 39.7460823059082 165.944183349609,-89.2782821655273 39.8091087341309 185.229614257812,-89.1808776855469 39.7976493835449 181.181625366211,-89.0261840820312 39.6544075012207 187.275939941406,-87.9719390869141 39.4825248718262 221.962844848633,-87.536491394043 39.3564720153809 138.683181762695,-87.6052474975586 39.2647972106934 136.842788696289,-87.6338958740234 39.1731262207031 134.396545410156,-88.0177764892578 39.1731262207031 177.413208007812,-88.699592590332 38.9095611572266 172.722839355469,-88.2698745727539 38.7204895019531 146.399536132812,-88.2813339233398 38.6689224243164 138.654922485352,-88.2813339233398 38.6173553466797 145.671493530273,-89.7080078125 38.4110908508301 117.708473205566,-89.2782821655273 38.7319450378418 135,-89.3298492431641 38.5142250061035 136.162063598633,-89.4157943725586 38.4855766296387 132.255447387695,-89.5704956054688 38.4855766296387 123.048034667969,-89.6335144042969 38.4454689025879 121.840858459473,-87.9719390869141 39.4825248718262 221.962844848633,-88.4761428833008 39.4424133300781 231.740631103516,-87.9719390869141 39.6830558776855 202.629531860352,-87.6740036010742 42.0665626525879 175.212997436523,-87.6052474975586 41.854564666748 175.203002929688,-87.525032043457 41.4649543762207 203.654327392578,-87.9203720092773 41.6425743103027 208.574569702148,-87.977668762207 41.6654891967773 220.499282836914,-88.2756042480469 41.9863471984863 225.90071105957,-88.2068557739258 42.1582374572754 243.408111572266,-87.9547500610352 38.8522682189941 136.305511474609,-87.6338958740234 39.1731262207031 134.396545410156,-87.5765991210938 39.0642623901367 131.822998046875,-90.9112091064453 39.8377532958984 219.834060668945)' | |
| ) | |
| ) | |
| ), | |
| 4326 | |
| ) | |
| ) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment