Skip to content

Instantly share code, notes, and snippets.

@dlebauer
Last active August 29, 2015 14:17
Show Gist options
  • Select an option

  • Save dlebauer/215ccdf2051fa0433b24 to your computer and use it in GitHub Desktop.

Select an option

Save dlebauer/215ccdf2051fa0433b24 to your computer and use it in GitHub Desktop.
invalid geom
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
))
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