Search Results
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 |
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 …
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). …
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 …
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. …
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 …
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. …
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. …
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. …
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 …
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. …
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 …
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. …
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 …
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 …
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 …