[postgis-users] more postgis and osm data help needed

Thomas Endres endres.thomas at gmail.com
Fri Dec 4 11:14:13 PST 2015


Hi Everyone,
While my shapefiles have been imported into PostGIS and work great in QGIS,
I am struggling to do the same with OSM data.
I've tried suggestions from this list to no avail - hoping for some fresh
eyes.

Using the following with QGIS 2.12.1, Postgres 9.4.5, and PostGIS 2.2 on an
ubuntu instance.
Postgres is running locally at our office and is a beast of a machine - no
issues with hardware.

osm2pgsql --create --slim --cache 14000 --number-processes 4
--multi-geometry --hstore -d osm --flat-nodes /usr/local/osm/flat_nodes.bin
--style /usr/local/osm/default.style  /tmp/north-america-latest.osm.pbf

After the data is loaded, primary keys and indexes are generated and a full
vacuum is performed.

Start with an empty project, disable 'Render',
add planet_osm_lines to the project and create a rule:
"railway" = 'rail'
enable 'Render'
results in progress bar in an endlessly active state with nothing ever
drawn.
There is an index an the railway column.

How does one go about a diagnosis from this point?

A few questions:
- There is no SRID specifically called on the import - is it defaulting to
900913 successfully or should it be called as I see this error in QGIS:
2015-12-02T11:53:20 1 Feature type or srid for way of
"public"."planet_osm_polygon" could not be determined or was not requested.
Is this error fixable?

- Might the use of --slim and --flat-nodes switches be causing issues?

- Is it possible to see what processes are responsible for the
ProgressBar's active state?
On several occasions I have been stuck with an active ProgressBar with
nothing apparent going on.
Canceling out leaves me with a dark screen and a force quit. Joy.

Also seeing the following in QGIS Messages:
2015-12-02T11:31:49 1 NOTICE: WARNING:  there is no transaction in progress
2015-12-02T11:32:00 1 NOTICE: row number 0 is out of range 0..-1
2015-12-02T11:33:22 1 NOTICE: row number 0 is out of range 0..-1
2015-12-02T11:34:32 1 NOTICE: WARNING:  there is no transaction in progress
2015-12-02T11:34:51 1 NOTICE: WARNING:  there is no transaction in progress
and
Simplify transform error caught: forward transform of
(nan, -1.570796)
PROJ.4:  +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0
+y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs +to  +proj=merc +a=6378137
+b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m
+nadgrids=@null +no_defs
Error: tolerance condition error
Any thoughts welcome.

-tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20151204/b8be3d4c/attachment.html>


More information about the postgis-users mailing list