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. ...


0

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 memory for temporary storage, which gives an option for coping with unordered files. The ...


1

The planet_osm_roads table in POSTGIS is only designed for rendering at lower zoom levels. For higher zoom levels, take the planet_osm_line table and filter for features with highway. If you still don't see all roads: How did you get the data from OSM? The export function might skip ways that are not completely inside the view. You better use the Overpass ...


0

osm2pgsql imports OSM data in Mercator EPSG:900913. Ensure your Geometry Column in PostGis is set to EPSG:900913 using UpdateGeometrySRID You may need to install the EPSG:900913 Proj in your PostGis database using the instructions here! Ensure your QGis Layer Projection matches as well. If you want to Reproject to EPSG:4326 (WGS84) Then you can do the ...



Top 50 recent answers are included