<div dir="ltr"><div><div><div><div><div><div><div><br>Good, you narrowed the error.<br><br>The function would do it for you,<br></div>it would convert the curved parts into curves and the straight part into segment,<br></div>forming a curved polygon, which is a set of curve and segments.<br><br></div>But I'm affraid your line must appoximate the curves to have a result.<br></div>Your 2 first screen shots indicate that the curve information is simply gone. <br><br></div>You can manually approximate curves into line in arcgis before export,<br></div>or maybe OGR driver for arcgis support curves<br>(<a href="http://www.gdal.org/drv_filegdb.html">http://www.gdal.org/drv_filegdb.html</a>)<br><br></div>Cheers,<br>Rémi-C<br><div><div><div><div><br><div><br></div></div></div></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2014-11-12 15:56 GMT+01:00 Andy Colson <span dir="ltr"><<a href="mailto:andy@squeakycode.net" target="_blank">andy@squeakycode.net</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Mapserver displays it the same way:<br>
<br>
<a href="http://testmaps.camavision.com/map/washingtonmn?pin=16.028.21.11.0039" target="_blank">http://testmaps.camavision.<u></u>com/map/washingtonmn?pin=16.<u></u>028.21.11.0039</a><br>
<br>
The data looks like:<br>
<br>
gis=# select st_AsText(the_geom) from streets where gid = 11517;<br>
-[ RECORD 1 ]-----------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>------------------------------<u></u>-<br>
st_astext | MULTILINESTRING((-10344354.<u></u>4038468 5608573.22422463,-10344363.<u></u>9860388 5608565.68874797,-10344398.<u></u>9885982 5608528.81799097,-10344438.<u></u>5518419 5608468.68094317,-10344404.<u></u>2129173 5608265.5414558,-10344355.<u></u>0291817 5608227.92219317,-10344239.<u></u>0250123 5608196.3261761,-10344230.<u></u>7760714 5608197.59004929,-10344187.<u></u>3835781 5608212.14184435))<br>
<br>
<br>
<br>
So I'm assuming that its a convert problem, not a display problem.<br>
<br>
I'm not sure how to use ST_LineToCurve. This is a road layer and everything is a MULTILINESTRING, I can't tell the straight from the curves. Can I?<br>
<br>
Thanks,<br>
<br>
-Andy<span class=""><br>
<br>
<br>
<br>
On 11/12/2014 3:58 AM, Rémi Cura wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Hey,<br>
first qgis can't deal with curve (i think),<br>
so your data may be curved in your postgis but the visualisation would<br>
be incorrect<br>
so if you are going to see some curve in qgis, you have to convert the<br>
curve to approximate theim using<br>
<a href="http://postgis.net/docs/ST_CurveToLine.html" target="_blank">http://postgis.net/docs/ST_<u></u>CurveToLine.html</a>,<br>
then display the geom<br>
(you can do this in a view if you don't want to duplicate data)<br>
<br>
Now if you are really really sure that data in postgis is bad (use<br>
ST_AsTExt(geom) for example to see if anything look like curve)<br>
Either you approximate your curve with multiline and convert it back to<br>
curve with postgis<br>
(<a href="http://postgis.net/docs/ST_LineToCurve.html" target="_blank">http://postgis.net/docs/ST_<u></u>LineToCurve.html</a>)<br>
<br>
Or you have to go the long way and pass the curves as attributes, and<br>
reconstruct it afterward.<br>
This seems like a very bad idea.<br>
<br>
I'm afraid curve support is very very limited in all gis tools.<br>
<br>
Cheers,<br>
Rémi-C<br>
<br>
2014-11-12 0:00 GMT+01:00 Andy Colson <<a href="mailto:andy@squeakycode.net" target="_blank">andy@squeakycode.net</a><br></span>
<mailto:<a href="mailto:andy@squeakycode.net" target="_blank">andy@squeakycode.net</a>>><u></u>:<span class=""><br>
<br>
Hi All,<br>
<br>
Not sure where the best place to ask this, so I'll start here.<br>
<br>
I have a FileGDB that contains some curved lines, I import it into<br>
PostGIS and they come out as chopped off Multiline.<br>
<br>
Here are some screen shots to help explain:<br>
<br>
Here is arc viewing the .gdb:<br></span>
<a href="http://testmaps.camavision." target="_blank">http://testmaps.camavision.</a>__<u></u>com/arc.png<span class=""><br>
<<a href="http://testmaps.camavision.com/arc.png" target="_blank">http://testmaps.camavision.<u></u>com/arc.png</a>><br>
<br>
Here is qgis viewing PostGIS:<br></span>
<a href="http://testmaps.camavision." target="_blank">http://testmaps.camavision.</a>__<u></u>com/qgis.png<span class=""><br>
<<a href="http://testmaps.camavision.com/qgis.png" target="_blank">http://testmaps.camavision.<u></u>com/qgis.png</a>><br>
<br>
<br>
I tried to get arcCatalog to export to shapefile, but something went<br>
bad and I cannot even look at the .shp files.<br>
<br>
Any hints how I can get the curve back?<br>
<br>
Thanks for your time,<br>
<br>
-Andy<br>
</span></blockquote><div class="HOEnZb"><div class="h5">
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
</div></div></blockquote></div><br></div>