Tag Info

New answers tagged

0

Well you can let it be created on the "public" schema and after: - ALTER TABLE IF EXISTS public.actions SET SCHEMA gis; - ALTER TABLE IF EXISTS public.schema_info SET SCHEMA gis; - ALTER TABLE IF EXISTS public.users SET SCHEMA gis; - ALTER TABLE IF EXISTS public.way_nodes SET SCHEMA gis; - ALTER TABLE IF EXISTS public.relations SET SCHEMA gis; - ...


0

I Finally found the relevant post from Paul Norman and Andre Joost on a similar Question .. What is occuring appears to be a somewhat subtle bug with osm2pgsql where osm2pgsql requires id-sorted nodes, but the API does not guarantee that. The easiest solution is to import with --slim --drop. The --slim flag causes osm2pgsql to use the database instead of ...


0

It seems you encountered a strange bug inside the osm importer. It expects the nodes to be ordered, but they are not. Using QGIS, I get the same strange 4-node polygon using Add Vector layer from GDAL , but the Openstreetmap plugin does it right (i.e. it self-orders the nodes). It looks like osm2pgsql expects the nodes ordered as well, but the export ...


0

I use both GraphHopper AND Pg_Routing Pg_Routingis a lot more flexible but is relatively slower (Depending on the size of the area). You can change costs on an edge in real time GraphHopper buids graphs from an OSM Extract and has its own built in web Server, so is very quick to get up and running ..


1

If you're a very beginner you should try this tutorial of osm2po by @Underdark Osm2po will give you ready to use graph from osm data as sql script file, all you have to do is load it into database via psql -f command. In this table every single record is edge. Every edge has 2 vertices source and target - coordinations of this points are in column x1,y2 ...


1

You should check the pgRouting project. There is a great step to step workshop/tutorial. http://workshop.pgrouting.org/


0

At least it is in the pbf file: I filtered the file with osmosis for ref="B 10", and loaded the result into QGIS. Osm2pgsql needs a bit longer, but has the line in the same way. Same osm2pgsql version, but with an extended default style, and 32bit PostgreSQL 9.3 using Windows 7. EDIT Mapnik for Windows is currently only available for 32bit, so you ...


2

I imported a Planet File on a 24Gb Machine (Ubuntu Trusty) with the following .. bzcat planet-latest.osm.bz2 | osm2pgsql --verbose -U YourUser --flat-nodes flat-nodes --keep-coastlines --cache 24000 --hstore --hstore-add-index --tablespace-index pg_default --exclude-invalid-polygon --number-processes 6 --unlogged --cache-strategy dense --extra-attributes ...


2

Your computer should be fine for importing Europe. Given your dataset size and computer, I'd recommend something like this osm2pgsql -c -S /usr/share/osm2pgsql/default.style --slim -d osm-europe --flat-nodes flat-nodes.bin --number-processes 8 -C 20000 europe-latest.osm.pbf I'm assuming that you have an 8 thread CPU, if not, adjust --number-processes. ...



Top 50 recent answers are included