Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 9159

Converts OpenStreetMap data to a PostgreSQL / PostGIS database

3 votes

Negative OSM ID values - building polygons

This is not a NULL tag, but simply an empty field, and the way QGIS displays it. Negative osm_id have all polygons that are build from multipolygon relations, while polygons build from simple closed …
AndreJ's user avatar
  • 77.1k
4 votes

Download link to osm2pgsql

Personally, I am still using the May 2013 build of Dominik Perpeet from http://www.customdebug.com/osm2pgsql/ but the server is currently down. … Unfortuantely, the mingw version does not work for me because it cannot connect to the postgreSQL server (which works with all other versions osm2pgsql and QGIS). …
AndreJ's user avatar
  • 77.1k
3 votes

Convert OSM File to get addresses using Osm2pgsql

The names of the tables should be self-explaining: planet_osm_point is a point layer file planet_osm_line is a line layer file planet_osm_roads similar to line, contaning simplified geometries of ro …
AndreJ's user avatar
  • 77.1k
1 vote
Accepted

How to query osm2pgsql tables for address geocoding?

Unfortunately, not all are in the default osm2pgsql database scheme. You have to add the others manually before importing the data. … Maybe a nominatim database (also populated by osm2pgsql) is better suited for your needs. Nominatim has a different table layout than the default database scheme used for Mapnik. …
AndreJ's user avatar
  • 77.1k
3 votes
Accepted

osm2pgsql style not applied

Although the file is called style, it is not a rendering style like you apply on QGIS layers. It is just a filter on the OSM raw data ro be passed into the Postgis database. You still need rendering …
AndreJ's user avatar
  • 77.1k
1 vote

Transferring large amount of OSM data to PostGIS using osm2pgsql?

osm2pgsql is surely designed to import the whole planet into postgis. … Older versions of osm2pgsql will fail therefore. On windows, there are a few more pitfalls. You can follow https://github.com/openstreetmap/osm2pgsql/issues/17 to get the latest Windows binaries. …
AndreJ's user avatar
  • 77.1k
1 vote

Osm2pgsql crashed on import. Can I continue with what has been imported so far?

After the import of the raw data, osm2pgsql builds the polygon data out of closed ways and multipolygon relations. Building indices is the last step, so you might rescue the polygons. …
AndreJ's user avatar
  • 77.1k
1 vote

Getting OSM maps in Equirectangular Projection via osm2pgsql

Make sure that your version of osm2pgsql is built for the version of postgis you have. There were some major changes in postgis 2.0. … This was a Windows system, but make sure osm2pgsql can find the proj lib. …
AndreJ's user avatar
  • 77.1k
4 votes
Accepted

Planet_osm_point versus Planet_osm_nodes for querying places

planet_osm_node contains the point data in the same way they are stored in the OSM database. These nodes can contain attribute information, or are just part (vertices) of ways. planet_osm_point is a …
AndreJ's user avatar
  • 77.1k
1 vote
Accepted

Missing some lines after import of .PBF int PostGIS

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. …
AndreJ's user avatar
  • 77.1k
6 votes
Accepted

How to import OSM data into Postgres DB using osm2pgsql in Linux?

You have to set up the database in the form osm2pgsql expects it. I have written a detailed Howto here (you might use google to translate): http://wiki.openstreetmap.org/wiki/User:Ajoessen/Postgis …
AndreJ's user avatar
  • 77.1k
1 vote
Accepted

Strange exposure of a PostGIS layer in QGIS after importing OSM data into a database

A few possible reasons: Your version of osm2pgsql is not ready for 64-bit-long node numbers. Try the latest version Updating of the planet at Geofabrik failed before cutting into pieces. …
AndreJ's user avatar
  • 77.1k
4 votes
Accepted

Where can I download the last default.style for osm2pgsql?

Have a look here: https://raw.github.com/openstreetmap/osm2pgsql/master/default.style …
AndreJ's user avatar
  • 77.1k
3 votes

Work flow for using AND adding OSM-Data

QGIS had a plugin for editing and uploading OSM data, but that was dropped due to lack of maintenance. Currently, no OSM user authentication is stored inside QGIS, and there is no plan to do it. OSM …
AndreJ's user avatar
  • 77.1k
2 votes

Unable to load an OSM .bz2 file into a PostGIS database using osm2pgsql

Your version of osm2pgsql is outdated, and does not respect changes that were made for Postgis 2.0 You can get the latest windows builds here: https://github.com/openstreetmap/osm2pgsql/issues/472 Alternatively …
AndreJ's user avatar
  • 77.1k

15 30 50 per page