[postgis-users] FileGDB curves

Rémi Cura remi.cura at gmail.com
Wed Nov 12 01:58:41 PST 2014


Hey,
first qgis can't deal with curve (i think),
so your data may be curved in your postgis but the visualisation would be
incorrect
 so if you are going to see some curve in qgis, you have to convert the
curve to approximate theim using http://postgis.net/docs/ST_CurveToLine.html
,
then display the geom
(you can do this in a view if you don't want to duplicate data)

Now if you are really really sure that data in postgis is bad (use
ST_AsTExt(geom) for example to see if anything look like curve)
Either you approximate your curve with multiline and convert it back to
curve with postgis
(http://postgis.net/docs/ST_LineToCurve.html)

Or you have to go the long way and pass the curves as attributes, and
reconstruct it afterward.
This seems like a very bad idea.

I'm afraid curve support is very very limited in all gis tools.

Cheers,
Rémi-C

2014-11-12 0:00 GMT+01:00 Andy Colson <andy at squeakycode.net>:

> Hi All,
>
> Not sure where the best place to ask this, so I'll start here.
>
> I have a FileGDB that contains some curved lines, I import it into PostGIS
> and they come out as chopped off Multiline.
>
> Here are some screen shots to help explain:
>
> Here is arc viewing the .gdb:
> http://testmaps.camavision.com/arc.png
>
> Here is qgis viewing PostGIS:
> http://testmaps.camavision.com/qgis.png
>
>
> I tried to get arcCatalog to export to shapefile, but something went bad
> and I cannot even look at the .shp files.
>
> Any hints how I can get the curve back?
>
> Thanks for your time,
>
> -Andy
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141112/3f6ebcca/attachment.html>


More information about the postgis-users mailing list