[postgis-users] Split Polygon Using Line

Robert Clift rob.clift at goisc.com
Tue Jul 8 08:11:58 PDT 2008


Hi All:

 

I'm new to the list and, having learned GIS concepts using ESRI and
IDRISI products, I'm also new to PostgreSQL/PostGIS.

 

My first real challenge is to create a polygon representing an electric
service area from a verbal description of said area. I was told that the
service area encompasses the city limits as well as a small area on
either side of a highway_a (running north/south) up to the point that it
intersects highway_b (running east/west).  I buffered the shortest
section of highway_a that I was able to isolate, combined the resulting
polygon with the city limits polygon, then trimmed highway_b so that it
is only as long as the highway_a buffer is wide.  So what I'm left with
is a single polygon and a single short section of line.  I need to use
the line to split the polygon.  I thought this would be simple, but I am
flummoxed.  I came across the following sample at
http://postgis.refractions.net/support/wiki/index.php?SplitPolygonWithLi
neString
<http://postgis.refractions.net/support/wiki/index.php?SplitPolygonWithL
ineString> :

 

SELECT astext(geom ) FROM dump (( 

SELECT polygonize(geomunion(boundary(poly), line)) AS mpoly FROM 

   (SELECT 'POLYGON ((1 1, 1 3, 3 3, 3 1, 1 1 ))'::geometry AS poly) AS
a,

   (SELECT 'LINESTRING (0 2, 4 2)'::geometry AS line) AS b

));

 

So here is my query:

 

SELECT astext (geometry) FROM dump (( 

 

SELECT polygonize (geomunion (boundary (mont_electric.the_geom),
jefferson_i10.the_geom)) AS mpoly FROM 

 

   (SELECT 'mont_electric ((-83.9124274522479
30.4161531930239,-83.9123954632441 30.4169383191109,-83.9123723632697
30.4178123304368,-83.912356926495 30.4195684073516,-83.9123557554809
30.4196139955294,-83.9119020144444 30.4302657522229,-83.9118880144037
30.4304104629267,-83.9117800847587 30.4311230569431,-83.9117185855323
30.4313695162009,-83.9114703995134 30.4320739125258,-83.9113737917156
30.4322870642814,-83.9111079787755 30.432759692131,-83.9110570900489
30.4328429773125,-83.9102741136895 30.4340260469112,-83.9102460486267
30.4340668093097,-83.9022675780893 30.4452119163576,-83.8963534336197
30.4535115573977,-83.8955399265471 30.4547899781828,-83.8951031871479
30.4556154096913,-83.8947159589183 30.4564547644137,-83.8944052679917
30.4573997377513,-83.894101041581 30.4585158259104,-83.8938983530806
30.459685566968,-83.8937698203154 30.4608593221223,-83.8929105414989
30.4689828053032,-83.8927230144455 30.4708937705598,-83.8927147318864
30.4709608489177,-83.892538812555 30.4721416990314,-83.8925125475809
30.4722729604429,-83.8923632882287 30.4728646906307,-83.892344092419
30.4729331386281,-83.8921946293405 30.4734167363876,-83.8921640796694
30.4735047050083,-83.8920085477676 30.4739071988352,-83.8920085477676
30.4739071988352,-83.8919464966645 30.4740444617605,-83.8916053519562
30.4746991220481,-83.8915940862262 30.4747202805856,-83.8911870119181
30.4754687257973,-83.8905605804959 30.4767981854206,-83.8905346143999
30.4768503429519,-83.8901000500449 30.477677980502,-83.8895038880307
30.4788586462341,-83.8895035553919 30.4788593045598,-83.8835585693784
30.4906170483901,-83.8831985831741 30.4914367078965,-83.8829872071769
30.4920152176218,-83.8827522098959 30.4928020355885,-83.8823149867843
30.4943695412639,-83.8810678006145 30.4988899813716,-83.8765021321246
30.5155393951345,-83.8748988000511 30.5214422686177,-83.875702614415
30.5208750114623,-83.876059602201 30.5212437892854,-83.8763655936941
30.521559887882,-83.8759589747145 30.5218244873041,-83.8761087572697
30.5219908896568,-83.8762205585223 30.5221150979922,-83.8766958039693
30.5219539339589,-83.8767029198737 30.521969654722,-83.8767089588098
30.5219839165925,-83.8769081042635 30.5219844022264,-83.8769162437533
30.5220108463421,-83.8769205406046 30.5220262416974,-83.87692450632
30.5220416921329,-83.8769281942875 30.5220572069221,-83.8769315511187
30.5220727767916,-83.8769345981838 30.5220883925321,-83.8769373248134
30.5221040449068,-83.8769397416873 30.522119733925,-83.8769418167445
30.5221354780142,-83.8769436141064 30.5221512403194,-83.8774281330744
30.522153355137,-83.8774235617897 30.5224599846778,-83.8774189899373
30.522767084892,-83.8774662900128 30.5227680021325,-83.8774640615629
30.5229227011523,-83.877461437993 30.5231052211078,-83.8769031309313
30.5230906870068,-83.8768807008588 30.523499321862,-83.8772458860421
30.5237073316462,-83.8775703590742 30.5238794563043,-83.8777874577371
30.5239946185154,-83.8779763681126 30.5240948260169,-83.878417101683
30.5242896004547,-83.8787962393162 30.5243580043284,-83.8789072781381
30.5243780394743,-83.8794436744826 30.5246872129496,-83.8796343482012
30.5247983360732,-83.8798778984633 30.5246261046345,-83.8799297308262
30.5243020556622,-83.8799847895891 30.5239578378804,-83.8800578545968
30.5238695909804,-83.8800863768689 30.5238351405611,-83.8802651447045
30.5236583510587,-83.8805010472726 30.5236550515028,-83.880815363285
30.5236506543799,-83.8811193906659 30.5236209550947,-83.8816246179259
30.5235715920311,-83.8821083661488 30.5233013187596,-83.8825054685797
30.5234838362767,-83.8826818211605 30.5235758884141,-83.8826767170864
30.5235944317295,-83.8826721299765 30.5236090445049,-83.882504365036
30.5240971490521,-83.8824312617748 30.5242604731149,-83.8823868481888
30.5243530541657,-83.8823405662754 30.5244449508245,-83.8822924481115
30.5245361262052,-83.8822678942959 30.5245848093515,-83.8822497754608
30.5246187520608,-83.8822309733871 30.5246524266037,-83.8822114987746
30.5246858145336,-83.8821913409633 30.524718897386,-83.8821705319826
30.5247516844148,-83.8821490611929 30.5247841387003,-83.8821269392637
30.5248162694787,-83.8821041768949 30.5248480583033,-83.8820807634166
30.5248794959371,-83.8820567308683 30.5249105824065,-83.8820320792705
30.5249412992559,-83.8823919947979 30.5254183970432,-83.8821566243441
30.5260186079571,-83.8813304996102 30.5257607585772,-83.8813165551392
30.5257669110403,-83.8812983261859 30.5257746194085,-83.8809638174629
30.5258754572051,-83.879431497345 30.5263310403779,-83.8791538994783
30.526413568271,-83.8790405215195 30.5264482142791,-83.8790089828158
30.5264575905082,-83.8789772417169 30.5264664959493,-83.8789453409544
30.5264749214109,-83.8789132698695 30.5264828484285,-83.8788566928455
30.5264955806948,-83.878823437512 30.5265023901432,-83.8787906848696
30.5265085633038,-83.8787578152973 30.5265142472929,-83.8787248608469
30.5265194329099,-83.8786917788083 30.5265241108909,-83.878658611882
30.5265282997273,-83.8786253707695 30.526531980973,-83.8785920554715
30.5265351546277,-83.8785586873383 30.5265378299373,-83.8785252663704
30.5265400069018,-83.8784918139497 30.526541667084,-83.8784583193755
30.5265428289301,-83.8784248146994 30.5265434832397,-83.8783913106023
30.5265436300219,-83.8781653387715 30.5265429297859,-83.8781742658641
30.5277305532259,-83.8780155461599 30.527729513353,-83.8760030581414
30.5277183116001,-83.875491792483 30.5277154580997,-83.8741350855834
30.5277078826029,-83.8735918539098 30.5277048464615,-83.8731221347138
30.5277022150432,-83.8728025804188 30.5277004265118,-83.8727853681614
30.529333557595,-83.871654760122 30.529315529614,-83.8710041045039
30.52930514328,-83.8708508665212 30.5298639515816,-83.8704574116184
30.5312988196879,-83.8703174107321 30.5318148515034,-83.8702919939185
30.531908535417,-83.8702258710374 30.5321525288097,-83.8702501266233
30.5324423736706,-83.8702065829786 30.532668569025,-83.8704506884025
30.5327434703838,-83.8709223313704 30.5328074763805,-83.8713888596043
30.5328707841367,-83.8727461474477 30.5330549578609,-83.8727398471533
30.5336528414074,-83.8745285880858 30.5338516667509,-83.8764456514868
30.533843576178,-83.8810030598381 30.5338188148895,-83.8851946726899
30.5337958935786,-83.8852562205261 30.5365589356269,-83.8831124871064
30.5365358894795,-83.8831190532005 30.5392255416505,-83.8840251152885
30.539233090738,-83.8847553078958 30.5392391726284,-83.8852619918305
30.5392433826267,-83.8852638828564 30.5401256835252,-83.8852646947808
30.5405024429927,-83.8852655174025 30.5408791933411,-83.8852658530496
30.5410436040757,-83.8855959390283 30.5410434814436,-83.8859260143344
30.5410433488119,-83.8863164092082 30.5410431988749,-83.8869073744065
30.5410429762244,-83.8871115337991 30.5410428886797,-83.8876013432595
30.5410427123102,-83.8880361633328 30.5410425372775,-83.8880400427679
30.5408780375818,-83.8888023947292 30.5408777107158,-83.8887470154814
30.5432251392198,-83.8879846573931 30.5432254750266,-83.8879888723862
30.543046764617,-83.887586230718 30.5431867374927,-83.8873665298333
30.5432631084497,-83.8873673266762 30.5434389253114,-83.8873611323975
30.5443368542129,-83.8870430986133 30.5443347296734,-83.8867250755337
30.5443325952062,-83.8866932753589 30.5443323854133,-83.8866892875036
30.5449080556632,-83.8861790683516 30.5449080557737,-83.8861642933807
30.5450895262736,-83.8861485691939 30.5461590849744,-83.8861385703713
30.5468389234324,-83.8872433786465 30.5470065184704,-83.8873705950774
30.5470258126594,-83.8873653089556 30.5474587016714,-83.8873643030645
30.5475411787079,-83.8873590168817 30.5479740771053,-83.8873537306658
30.5484069664074,-83.8873530636273 30.5484619449857,-83.8873523859056
30.5485169235578,-83.887347099626 30.5489498222537,-83.8878685308532
30.5489522259839,-83.8883899621039 30.5489546278094,-83.8889113933781
30.5489570277303,-83.8888973925979 30.5496804105243,-83.8894210988645
30.5496866214284,-83.8893971531898 30.5511739659909,-83.8851768035477
30.5511880651447,-83.8830628145673 30.5511950786518,-83.883011884794
30.5564426271932,-83.8726627586725 30.5564257155538,-83.8722939418406
30.5564251000502,-83.8722304080479 30.5564255599618,-83.8718467801202
30.556428372028,-83.8717832463237 30.5564288317406,-83.8713996290556
30.5564316426149,-83.8710160010953 30.5564344432208,-83.8710160135319
30.5564153508475,-83.8703128446681 30.5564136433882,-83.8700585385669
30.5564329843805,-83.8696734564953 30.5564367212943,-83.868591412585
30.5564472180643,-83.8685947959984 30.5563372161928,-83.8685956632256
30.5563097088251,-83.8684304669385 30.5563109131683,-83.868164558903
30.556312864086,-83.8678380826604 30.5564565717738,-83.8674285580828
30.556459560232,-83.8671108781886 30.5564618763549,-83.867114209952
30.5568055332127,-83.8674319122147 30.5568032355573,-83.8674359179785
30.5572156405038,-83.8671182251576 30.5572179474065,-83.8668005323114
30.5572202628302,-83.8665872805663 30.5572218169959,-83.8665483595521
30.5573595799254,-83.8665531129463 30.5579314520956,-83.8661431660101
30.5579344364803,-83.8661423615749 30.5578519572735,-83.866047064911
30.5578526430297,-83.8660478585775 30.5579351314549,-83.8659177336544
30.5579360705054,-83.865351455134 30.5579401883779,-83.8648749179182
30.5579436507438,-83.8648029187964 30.5580896685623,-83.8650482380882
30.5584131243759,-83.8651646215692 30.5585665642322,-83.8653914128216
30.558615058339,-83.8654964558032 30.5587225233437,-83.8655517924726
30.5587762538573,-83.8656082092996 30.5588291364063,-83.8656656742341
30.558881170959,-83.8657241766275 30.5589323298206,-83.8657837058314
30.5589825852961,-83.8658442511506 30.559031946602,-83.8659057698975
30.5590803767853,-83.8659682513882 30.5591278758347,-83.8660316956572
30.5591744160652,-83.8660960599702 30.5592199974356,-83.8661613229709
30.5592646106965,-83.8662675691804 30.5593338545485,-83.866138818215
30.5594813056968,-83.8660681071354 30.5596315887884,-83.8661590489078
30.5597140049844,-83.8670648174075 30.5603181315565,-83.8680875082447
30.5610168171084,-83.8674374988432 30.561688160472,-83.8673101315971
30.5617101428957,-83.8671832320021 30.5617340358097,-83.8670568427751
30.561759848483,-83.8669309853003 30.5617875624813,-83.8667699540113
30.561826003244,-83.8663015673069 30.5612463783781,-83.8667037165613
30.5607572901296,-83.8657161961217 30.5600932231021,-83.8659939643042
30.5597750677114,-83.8658895296456 30.5597093134648,-83.8658153616327
30.5596605391621,-83.8657421886653 30.559610649188,-83.865670032088
30.55955966202,-83.8655989132572 30.5595075869075,-83.8655842694391
30.5594964812422,-83.8655288535056 30.5594544515561,-83.865459895556
30.5594002652354,-83.8653920073351 30.5593450463726,-83.8653252636044
30.5592888134955,-83.8652596643523 30.5592315758339,-83.865195220239
30.5591733518551,-83.8651319632798 30.5591141692746,-83.865069914818
30.55905404657,-83.8650090855368 30.5589929837531,-83.8649494967558
30.5589310177571,-83.864891169818 30.5588681670596,-83.8648341154059
30.5588044316724,-83.8647783548271 30.5587398577565,-83.8647220747996
30.5586721550893,-83.8646523589328 30.5585845813398,-83.8646010570342
30.5585172893768,-83.8645511236422 30.5584492420135,-83.8645025694503
30.5583804300339,-83.8644554050698 30.5583109088165,-83.8644096625374
30.5582406876211,-83.8643653311562 30.5581697756669,-83.8643224429155
30.5580982191248,-83.8642809978132 30.5580260179964,-83.864241027862
30.5579531999969,-83.8642025223409 30.557879792801,-83.8641655025907
30.557805814886,-83.8641299899521 30.5577312847291,-83.8640959843754
30.5576562392428,-83.8640634858579 30.5575806784283,-83.8640325157046
30.5575046484461,-83.8640030952675 30.5574281585457,-83.8639752138251
30.5573512364012,-83.8639488927173 30.5572739004897,-83.863924131894
30.5571961877234,-83.8639009420117 30.557118116569,-83.8638793337386
30.5570396962654,-83.8638593070244 30.5569609637246,-83.8638408725253
30.5568819374132,-83.8638240301908 30.5568026542432,-83.8638087906889
30.5567231234531,-83.8637951646641 30.5566433727372,-83.8637831520772
30.5565634297795,-83.8637727315347 30.5564833130156,-83.8637639457188
30.556403059398,-83.8637567732475 30.5563226781344,-83.8637512247533
30.5562422061467,-83.8637473002088 30.5561616618906,-83.8637450102581
30.5560810730598,-83.8637443335077 30.5560004580899,-83.8637454613416
30.5559121765208,-83.8637457986698 30.5558990179582,-83.8637461787423
30.5558858502088,-83.8637466018426 30.5558724518047,-83.863748611982
30.5557458479147,-83.8637513663549 30.5555635824926,-83.8637707380778
30.5542831021475,-83.8637980233856 30.5515086857426,-83.8637383075534
30.5512909818718,-83.8635116616008 30.5513002515358,-83.8633847441312
30.5513054361196,-83.8627012805304 30.5513333496915,-83.8614319869923
30.5513851739082,-83.860488629446 30.5514236855062,-83.8604387938188
30.5514241720075,-83.8603116889181 30.5514254226339,-83.8600140532349
30.5514283239054,-83.8600123540767 30.5516482576471,-83.8600879609592
30.5543040125384,-83.8601205783577 30.555449448007,-83.8601508476134
30.5565123944929,-83.8570299509796 30.5565349104344,-83.8568711214988
30.5565360524115,-83.8569375661584 30.5588704491923,-83.8570237863881
30.5618994419341,-83.855851371831 30.5619600159169,-83.8514159722144
30.5621890908071,-83.8514279716233 30.5591550285416,-83.8514683405603
30.5558483291715,-83.8514948147059 30.5536789693905,-83.8515164266084
30.5519084888933,-83.8517253384863 30.5518783557839,-83.8517180513075
30.5524856947154,-83.8517044213942 30.5536203414991,-83.8522612663771
30.5536081475537,-83.8537003473447 30.5535766032193,-83.8537468866396
30.5553940886662,-83.8552736054008 30.5553534180196,-83.8552601000111
30.553491562403,-83.8558830595411 30.5534801964853,-83.8568028412317
30.5534634046449,-83.8569614485794 30.5534492513109,-83.8569588096512
30.5532982816423,-83.8569547611371 30.5530673515909,-83.8569507233235
30.5528364215879,-83.8569466855274 30.5526054916227,-83.8569426477488
30.5523745616952,-83.8569385993049 30.5521436317947,-83.8569345615614
30.5519127019425,-83.8569305238353 30.5516817721281,-83.8568720842774
30.5514627470484,-83.8563705273169 30.5514721816499,-83.855889546011
30.5514810446823,-83.8541137294034 30.5515137437377,-83.8539231656908
30.5515172399907,-83.8532830174614 30.5515291333323,-83.8528754785287
30.551546477426,-83.8526267724771 30.5515625264208,-83.8524006360321
30.5515807299417,-83.8524072737117 30.5508764711394,-83.8524104303106
30.5505411824283,-83.8524126344368 30.5503073523987,-83.8524179464806
30.5497424878481,-83.8524185954943 30.5496749872378,-83.8524218511103
30.5493298620931,-83.8524237798755 30.54912511796,-83.8524304042017
30.5484225675081,-83.8524348012287 30.5479551665551,-83.8524384323295
30.5475702520493,-83.8524405858061 30.5473420514013,-83.8524458208827
30.5467862680826,-83.8525379842914 30.5467732045162,-83.8525880817892
30.5467672028406,-83.8526382957394 30.5467619579448,-83.8526885940836
30.5467574790235,-83.8527389768357 30.5467537568486,-83.8527894333015
30.546750800637,-83.8528399421178 30.5467486103664,-83.8528904926288
30.5467471675703,-83.8531243194039 30.546745359779,-83.8539057359897
30.5467393053993,-83.8540961527048 30.5466965079677,-83.8549174560065
30.5466907841011,-83.855361404575 30.5466876819176,-83.8556785106795
30.546685465227,-83.8558647043479 30.5466841676762,-83.8561541644642
30.5466821434788,-83.856198560377 30.5466818375529,-83.8561440097427
30.5464892544199,-83.856142024743 30.5459657889045,-83.8563008491534
30.5459646477579,-83.8563028456159 30.5464881132813,-83.8563888240204
30.5466805065073,-83.8569860110505 30.5466763260573,-83.8571699400249
30.5466750429908,-83.857280704154 30.5466752552784,-83.8572492678799
30.5464827233612,-83.8572484097398 30.5462382697181,-83.8572474820036
30.5459660404753,-83.8572474065647 30.5458549381163,-83.8572461583701
30.5455827086269,-83.8572452199508 30.5453104887274,-83.8570856444455
30.5450919172103,-83.8570872559304 30.5444480982184,-83.85708769466
30.5442723560766,-83.8569564132471 30.544271855474,-83.8569247761187
30.5434424611866,-83.8568908905753 30.5425537122822,-83.8568728430574
30.5420810585203,-83.856870759167 30.5420261052433,-83.8568576548524
30.5416825987837,-83.8568471714467 30.5414078047483,-83.8567657087112
30.5413550234353,-83.8567562778213 30.5411079598505,-83.8568356565337
30.5411057694624,-83.8568257098867 30.5408449653163,-83.8569050777449
30.5408427564239,-83.8570042546373 30.5407730111127,-83.8570038355403
30.5404486190761,-83.8570036461927 30.5403111626443,-83.8570034675271
30.5401737062365,-83.8570032995312 30.5400362590805,-83.857003110185
30.5398988026886,-83.8573523364705 30.5398889554725,-83.8573840724432
30.5398882212825,-83.8577333093404 30.5398783731451,-83.8578601827052
30.5397841737363,-83.8578591349019 30.538984378358,-83.8557524840244
30.5390423928527,-83.8557517280581 30.5390011626373,-83.8557493784721
30.5388746943724,-83.8557468408132 30.5387372449444,-83.8557442924918
30.5385997862911,-83.8557430485161 30.5385324319298,-83.8557417548586
30.538462327662,-83.8557392172318 30.5383248690461,-83.8557366689302
30.5381874104327,-83.8557363406363 30.5381695452462,-83.8557341313041
30.538049961071,-83.8560799976163 30.5380401689569,-83.8561752359139
30.5380379949328,-83.8565244562132 30.5380281220719,-83.8565403397174
30.5380279257989,-83.8565401104353 30.5378491847764,-83.856952811196
30.5378380643207,-83.8569517920084 30.5370459105956,-83.8569994003699
30.5370445649153,-83.8573486066674 30.5370346808066,-83.8573803526935
30.5370337805312,-83.8577295695892 30.5370239047289,-83.8579835377191
30.5370167108775,-83.8583327545152 30.5370068243719,-83.8583644898434
30.537005923867,-83.8587137065688 30.5369960364295,-83.8588089445641
30.5369933438989,-83.8589509042959 30.5369893225526,-83.8589514301015
30.5369068181537,-83.8589800660829 30.5342928336289,-83.864022428657
30.5341499541097,-83.8640184370779 30.5329843462352,-83.8640114176978
30.5328771600516,-83.8640077148081 30.5327908408165,-83.864005763643
30.5327044771172,-83.8640055427892 30.532618105844,-83.8640070735926
30.532531736245,-83.864010345321 30.5324454052206,-83.8640153579347
30.5323591404537,-83.8640221007252 30.5322729603892,-83.8640305950146
30.5321868927302,-83.8640408087091 30.5321009743565,-83.8640527631545
30.5320152145158,-83.8640664369144 30.5319296685531,-83.8640818300082
30.5318443180127,-83.8640989530422 30.53175921827,-83.8641177846154
30.5316743969871,-83.8641383247122 30.5315898633909,-83.864160562589
30.5315056636087,-83.8641844875496 30.5314218068571,-83.8642100995315
30.5313383392736,-83.8642374092351 30.5312552424119,-83.8642663845206
30.5311725900619,-83.8642970146921 30.53109039144,-83.8643292997344
30.5310086557727,-83.8643632289165 30.5309274199592,-83.8643987808266
30.5308467208886,-83.8644359661425 30.5307665585698,-83.8644747527602
30.5306869791092,-83.8645151406651 30.530607991733,-83.8645571191267
30.5305296333404,-83.8652296514646 30.529420330074,-83.8672712337067
30.5260526854051,-83.8696903518463 30.5220619474289,-83.8698712173182
30.5220593995345,-83.8700520934612 30.5220568514206,-83.8703284806581
30.5220529503807,-83.8717349375522 30.5220330993156,-83.8719411986332
30.5220301886021,-83.871946018098 30.5220127570767,-83.8738969670708
30.5148300872178,-83.8738978288345 30.5148269296606,-83.8784642081427
30.498174923789,-83.8784647657704 30.498172896505,-83.8797127366215
30.4936496123112,-83.8797137519221 30.4936459524315,-83.8801547894051
30.4920647717042,-83.8801616129566 30.4920411422062,-83.8804117379821
30.491203673521,-83.8804372672965 30.4911267065034,-83.8806772832639
30.4904698127538,-83.8807092486044 30.4903902601651,-83.8811012255215
30.48949776039,-83.8811325148355 30.4894314667552,-83.8870938793893
30.4776413301353,-83.8876947155986 30.4764514074197,-83.8877045483459
30.476432313237,-83.8881305590839 30.475620966242,-83.8887612064795
30.4742825591648,-83.8887964907292 30.4742129663651,-83.8892164863609
30.4734407640589,-83.8895172315604 30.472863630854,-83.8896287801843
30.4725749593212,-83.8897539870311 30.4721698442171,-83.8898781594795
30.4716775696283,-83.8900392231249 30.4705964375978,-83.8902239475266
30.4687140323266,-83.8902249835606 30.4687038704635,-83.8910850613175
30.4605728342295,-83.8910855938375 30.460567887044,-83.8912189913619
30.4593497071371,-83.8912307906185 30.4592661726947,-83.8914515883014
30.4579919212474,-83.8914792879533 30.4578673764579,-83.8918094599444
30.4566561040743,-83.8918294763952 30.4565894858672,-83.8921752200343
30.4555378989277,-83.8922318449651 30.4553940220965,-83.8926669023701
30.4544509930003,-83.8926994745673 30.4543851594815,-83.8931786801065
30.4534794675474,-83.8932329889518 30.4533860687093,-83.8940945163897
30.4520321842494,-83.8941340455723 30.4519735168718,-83.9000695778233
30.4436438611933,-83.900071289162 30.4436414651118,-83.9080362105043
30.4325152849033,-83.908778577296 30.4313935759629,-83.9089628759096
30.4310658844015,-83.9091296356824 30.4305925903313,-83.9092075590406
30.4300781096358,-83.9096572312652 30.4195218699685,-83.9096725722098
30.4177766946261,-83.9096729913187 30.417752893507,-83.9096966607601
30.4168573358119,-83.9096973086394 30.4168380451291,-83.9097298575003
30.4160391781202,-83.9097302163234 30.4160309834162,-83.9099669752913
30.4109754257059,-83.9100052073436 30.4107135555795,-83.910093793105
30.4104641759175,-83.9102293282744 30.4102368702405,-83.9104066043112
30.4100403737782,-83.9106188085969 30.4098822377795,-83.9108577862395
30.409768539322,-83.9111143534625 30.4097036477738,-83.9113786505313
30.4096900568807,-83.9116405206577 30.409728288933,-83.9118899003197
30.4098168746944,-83.9121172059966 30.4099524098638,-83.9123137024589
30.4101296859007,-83.9124718384576 30.4103418901863,-83.9125855369151
30.4105808678289,-83.9126504284633 30.4108374350519,-83.9126640193565
30.4111017321207,-83.9124274522479 30.4161531930239))'::geometry AS
poly) AS a,

 

   (SELECT 'jefferson_i10 (-83.8910804546697
30.4756948695607,-83.8883392746518 30.4751780144512)'::geometry AS line)
AS b

 

));

 

This query returns:

 

ERROR: parse error - invalid geometry

 

However, both of the following queries return a Boolean value of true:

 

SELECT isvalid (mont_electric.the_geom) FROM mont_electric;

 

SELECT isvalid (jefferson_i10.the_geom) FROM jefferson_i10;

 

I hope that this is a matter of a simple syntax error committed by a SQL
newbie.  Any help will be greatly appreciated.

 

Cheers,

Rob Clift

Florida State University, Department of Geography

I.S. Consulting (GIS Intern)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080708/fd8f68e5/attachment.html>


More information about the postgis-users mailing list