3

Take the hints from the function output and compare with the docs carefully; the function signature is defined as [emphasis mine; slightly reduced to lessen confusion]: pgr_nodenetwork(edge_table, tolerance, id, the_geom, table_ending, rows_where, outall) RETURNS TEXT and your progress messages read [...] NOTICE: id: way NOTICE: the_geom: osm_id [...] ...


2

Speaking of osm2pgrouting you're correct that there is a limit in how large the OSM data can be, that you can import at once. But you can split your data into parts and import it incrementally. If the database table exists already only missing network data will be added. With the --attributes flag you can import all the other OSM attributes.


2

The default style file is meant to be used with the pgsql output. For the flex output, there is no default and you would have to provide your own Lua config file. See the doc for the various output type and more specifically for the new flex output type.


2

One option is to convert the PBF to Spatialite using OGR2OGR: ogr2ogr -f "SQLite" -dsco SPATIALITE=YES italy.db italy.osm.pbf Then you can connect to the Spatialite database from within QGIS. Layer->Add Layer->Add Spatialite Layer Add a New connection (to italy.db) Select the Points layer Set Filter as per the following: "other_tags&...


1

I see you marked your post with the "postgis" and "osm2pgsql" tags, so I am assuming you are using these tools. If so, and you run a system with the latest v1.5.1 of osm2pgsql supporting the new "flex output" option of osm2pgsql, then there is the work of Paul Norman on the draft version of the flex Lua style file of '...


1

osm2pgsql can use Lua-packages if you store them in the osm2pgsql-bin folder. In this case just store "dkjson.lua" from http://dkolf.de/src/dkjson-lua.fsl/home in the folder.


1

If you want a password prompt, you must use the -W or --password option


1

I had the problem. In past other people of my company used this (bad :() SQL: select pn.id, pn.tags, pn.lat, pn.lon from planet_nodes pn where pn.tags is not null and array_to_string(pn.tags,',') like '%LocationCode%' After my last import in table planet_nodes column tags is missing and the SQL don't working. The solution is: Don't use planet_node. This ...


Only top voted, non community-wiki answers of a minimum length are eligible