<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:12.0pt'>Hi All:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>I’m new to the list
and, having learned GIS concepts using ESRI and IDRISI products, I’m also
new to PostgreSQL/PostGIS.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>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 <a
href="http://postgis.refractions.net/support/wiki/index.php?SplitPolygonWithLineString"><span
style='color:windowtext;text-decoration:none'>http://postgis.refractions.net/support/wiki/index.php?SplitPolygonWithLineString</span></a>:<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>SELECT astext(geom ) FROM
dump (( <o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>SELECT
polygonize(geomunion(boundary(poly), line)) AS mpoly FROM <o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'> (SELECT 'POLYGON
((1 1, 1 3, 3 3, 3 1, 1 1 ))'::geometry AS poly) AS a,<o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'> (SELECT
'LINESTRING (0 2, 4 2)'::geometry AS line) AS b<o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>));<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt'>So here is my query:<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>SELECT astext (geometry) FROM
dump (( <o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'><o:p> </o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>SELECT polygonize (geomunion
(boundary (mont_electric.the_geom), jefferson_i10.the_geom)) AS mpoly FROM <o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'><o:p> </o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'> (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,<o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'><o:p> </o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'> (SELECT
'jefferson_i10 (-83.8910804546697 30.4756948695607,-83.8883392746518
30.4751780144512)'::geometry AS line) AS b<o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'><o:p> </o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>));<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt'>This query returns:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>ERROR: parse error - invalid
geometry<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>However, both of the
following queries return a Boolean value of true:<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>SELECT isvalid
(mont_electric.the_geom) FROM mont_electric;<o:p></o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'><o:p> </o:p></span></p>
<p class=MsoNormal style='background:white'><span style='font-size:8.0pt;
font-family:"Verdana","sans-serif";color:#555555'>SELECT isvalid
(jefferson_i10.the_geom) FROM jefferson_i10;<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>I hope that this is a matter
of a simple syntax error committed by a SQL newbie. Any help will be
greatly appreciated.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>Cheers,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>Rob Clift<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>Florida State University,
Department of Geography<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:12.0pt'>I.S. Consulting (GIS Intern)<o:p></o:p></span></p>
</div>
</body>
</html>