<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">On 5/22/2014 12:28 PM, Richard
Greenwood wrote:<br>
</div>
<blockquote
cite="mid:CAHBySPZwEFjPkvKnU3Ukirv1J5K14+JAN82K7fZPX5nm3dTLNQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>I have a polygon table that I want to convert to
linestrings without any duplicated (overlapping)
linestrings. I'm doing this simply to improve cartography so
I'm looking for a quick and dirty approach, avoiding
topology if possible. <br>
</div>
</div>
</div>
</blockquote>
<br>
I'm not sure I understand what it is you are attempting to do from
this description. I would expect lines going in two directions from
each polygon and I just don't know how you would use that to help
with "improve cartography".
<blockquote
cite="mid:CAHBySPZwEFjPkvKnU3Ukirv1J5K14+JAN82K7fZPX5nm3dTLNQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<br>
</div>
The closest I've gotten so far is to break the polygons
boundaries into simple (two vertex) lines and delete all the
duplicate lines. Now I'm stuck getting the simple lines back
into polylines. Just doing a union of the whole mess isn't
getting me individual linestrings.<br>
</div>
</div>
</blockquote>
So, crazy "out of the blue" question.. have you considered creating
a line (or lines) from the centroids?
<blockquote
cite="mid:CAHBySPZwEFjPkvKnU3Ukirv1J5K14+JAN82K7fZPX5nm3dTLNQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<br>
</div>
All this is turning into more steps that I anticipated and I
wonder if I'm missing simpler approach?<br>
</div>
</blockquote>
Or maybe describe what your target is? There are a lot of people a
lot more knowledgeable than I on this list, and if they haven't
answered, perhaps you haven't presented your challenge in a manner
that they can address.<br>
<br>
Roxanne
<blockquote
cite="mid:CAHBySPZwEFjPkvKnU3Ukirv1J5K14+JAN82K7fZPX5nm3dTLNQ@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div><br>
</div>
<div>Thanks,<br>
Rich<br>
</div>
<div><br>
-- <br>
<div dir="ltr">Richard W. Greenwood, PLS<br>
<a moz-do-not-send="true"
href="http://www.greenwoodmap.com" target="_blank">www.greenwoodmap.com</a></div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</body>
</html>