Hi Everyone, While all of 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 some 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 vaccuumm 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 ina an endlessly active state with nothing ever drawn. How does one go about a diagnosis from this point? A few quesions: - There is no SRID specifically called on the import - is it defaulting to 900913 succesfully 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 occassions I have been stuck with an active ProgressBar with nothing apparent going on. Cancelling 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
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user