Skip to content
fordfrog edited this page Sep 15, 2012 · 10 revisions

Some Notes

Due to the issues mentioned below, I have added option to convert GML geometries to EWKT before they are stored in database to avoid all GML related issues. This feature is available since version 1.3.0. To enable it, use --convert-to-ewkt command line switch. The feature is considered experimental at this moment. Any testing and feedback is welcome, especially checking of correctness of stored geometries. If you want to see EWKT strings as they are passed to database, use --debug switch on command line.

Known Issues

  • ruian2pgsql does not work on RÚIAN updates (with geometries) since 20120723 when using Postgis 2.0.1 (not sure about other versions) because GML polygon XML definitions crash Postgis (see bug).
  • Postgis (2.0.1 and probably even older versions) do not support <gml:MultiPoint><gml:pointMembers>...</gml:pointMembers></gml:MultiPoint>, silently ignores the points and stores empty multipoint in database instead of correct geometry (see bug). There is workaround for this issue in ruian2pgsql since version 1.1.0.
  • Some GML XML definitions from the import files are considered as invalid by Postgis (tested with version 2.0.1) so use of --ignore-invalid-gml is needed. At this point I am not sure whether it is really invalid GML or a Postgis bug.

ToDo

  • Add option to generate GeoRSS feed that can be used for expiration of cached map tiles.
Clone this wiki locally