Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

1
vote
1answer
26 views

How to check if a node is in route computed with pgRouting?

I'm new to the GIS system and I'm following the pgRouting workshop. I've imported the locations of nodes (points, highway=street_lamp) using osm2pgsql. now I'm calculating a few paths between two ...
0
votes
1answer
23 views

Moving file flat-nodes.bin from an osm2pgsql import

I'm running PostgreSQL 9.4 and osm2pgsql 0.82.0 on Ubunt 14.04 (64bit). I'm new-ish to postgres and less new to OSM. My goal was to import the planet file. Unfortunately, when I started the import, ...
1
vote
0answers
31 views

Nominatim with osm2pgsql for rhel 6

I tried configure&make Nominatim on rhel6.5 but Nominatim compiled whithout osm2pgsql. I also tried complied osm2pgql by handle with ./autogen, ./configure make and got many errors like: ...
0
votes
0answers
22 views

pg_dump Database that was populated with osm2pgsql

Is it possible to dump a postgres database that was created with osm2pgsql and a .osm.pbf file with pg_dump and import this into a remote postgres database? After running osm2pgsql the database is ...
0
votes
1answer
29 views

Utilizing OSM Data in a Postgres/PostGIS database in ArcMap

I've been trying for over a week now, and I'm not sure what i'm doing wrong and I haven't found the answer yet. I am trying to display and symbolize the OSM dataset over Jordan in ArcGIS for Desktop ...
0
votes
0answers
18 views

OpenStreetMaps openstreetmap-carto XML error or Missing Data from osm2pgsql

I've successfully built a tile server using the documentation provided here: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ For my data, I obtained the north american ...
1
vote
0answers
35 views

OSM Bright Cartography XML

So I've successfully setup a tile server as described here: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ What's troubling is the lack of clarify surrounding OSM Bright ...
0
votes
0answers
71 views

Import OpenStreetMap to shapefile in ArcMap

I would like to import an osm file to a postgresql in order to be able to extract soe information and convert it to a shapefile. I have downloaded the PostgreSQL. My question is what are the main ...
1
vote
0answers
48 views

Loaded OSM Data into PostGIS Database. Cannot view in ArcMap “The coordinate system identifier is invalid”

I loaded OSM File for Pennsylvania into a PostGIS Database in PostgreSQL using osm2pgsql. Everything seemed to go without a hitch until I finally connected to the Database in arcCatalog and tried to ...
1
vote
2answers
72 views

How to transfer large amount of OSM data to postgis using osm2pgsql?

I am new to using Openstreetmap data and PostGIS database. I learned how to use osm2pgsql and transferred osm data for a small city to PostGIS database and worked fine. The problem is that when I try ...
2
votes
0answers
64 views

Cost_Matrix Distance: Vehicle routing problem!

I'd like to calculate the "real distance" between one source and many targets, such as we do in the "vehicle routing problem", in order to get the matrix distance at the end. after using the osm2po, ...
1
vote
1answer
86 views

Getting only points when importing from OSM to Postgresql

This is my very first time working with OpenStreetMap data so feel free to tell me if I am forgetting important information. I am trying to import some data from OpenStreetMap into PostGreSQL. I ...
1
vote
1answer
73 views

Renderd “planet_osm_polygon” not exists. What to do now?

I'm trying to create my map server. Importing a planet with osm2psql was perfect, I installed nominatim and is working too. I installed the libapache2-mod-tile packet, caring about to not create the ...
0
votes
0answers
41 views

How do I determine the hardware requirements for importing an OSM extract?

I have a 950MB OSM extract I'm trying to import into Postgres using osm2pgsql. All attempts thus far have failed as I've been running out of hard drive space. I have no problem processing metro or ...
1
vote
1answer
114 views

Isochrone driving/public transport map : Grass or postgis?

I have to do Isochrone driving / public transport map. It would seem that the two better open-source solutions are grass and postgis. Could you tell me which one is the better? the easier to ...
1
vote
1answer
59 views

How to get all the LineStrings of a street using PostGIS with OSM

I want to get all parts of a given street. I use a query like: Select * from planet_osm_lines where name = 'mystreet' As a result I get all the LineStrings that are part of a street with the ...
2
votes
1answer
68 views

What is the meaning of z_order in OSM/pgsql datamodel?

Site http://wiki.openstreetmap.org/wiki/Osm2pgsql/schema describe OSM/pgsql database schema. But I don't understand the meaning of z_order in this model.
2
votes
2answers
172 views

osm2pgsql: database “gis” does not exist

I am currently attempting to use OSM Bright to quickly style some OSM data, so I can export tiles without spending hours writing Carto in TileMill. This is my first time using osm2pgsql to import OSM ...
1
vote
1answer
79 views

osm2pgsql - can't find “maxspeed” tag after import

I have import a compressed osm file ".pbf" in a postgis database with osm2pgsql using the following command: osm2pgsql -c -d osm_france -U postgres -H localhost -S default.style -C 10000 ...
1
vote
1answer
89 views

Import of OSM data into PostgreSQL with osm2pgsql polygon problem

I've mananged to import my great-britain osm file successfully into postgres and I can query everything fine. osm2pgsql -s -j -G -l --number-processes 8 -K -U james -C 10000 -d osm myfile.osm I'm ...
0
votes
0answers
49 views

How to get a specific street using OSM with PostGis

I want to get the polygon form a specific street from the OSM data importtes with osm2pqsql using PostGis. Since the streetname isn't the only identifier I wanted to add the postal code as a second ...
1
vote
2answers
102 views

Planet_osm_point versus Planet_osm_nodes for querying places

Hello I am using a PostGis Database with OSM Data. After importing the data with osm2pgsql in slim mode I found a table named Planet_osm_nodes that has places also. It seems really compressed and has ...
2
votes
0answers
49 views

How to get changeset tag from .osm file into PostGIS enabled Postgres db

End goal: visualize geographic data from .osm file with QGIS by adding PostGIS layers which include changeset information. I have used osm2pgsql successfully to populate PostGIS and visualize the ...
3
votes
1answer
112 views

How to display OSM relations (in QGIS) from osm2pgsql populated PostGIS DB

I have a PostGIS DB populated with OSM data (osm2pgsql, standart.style). Now I would like to display a hiking trail (http://www.openstreetmap.org/relation/51855). It would also be fine, if I just ...
0
votes
0answers
264 views

osm2pgsql Error - no schema has been selected to create in

I have a Postgres database with Postgis and hstore extensions created. The data tables are in a schema called geodata with the search path set ALTER DATABASE wapdb1 SET search_path = ...
0
votes
2answers
178 views

using mod_tile in windows

I am trying to generate tiles on the fly in windows using mod_tile. I have followed the tutorial http://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ on ubuntu and successfully ...
1
vote
0answers
37 views

Can't find the proper settings to import Europe map using osm2pgsql?

I'm trying to deploy a map server, i used http://switch2osm.org/serving-tiles/building-a-tile-server-from-packages/. My server setup is: Xeon E3-1230v2 Quad-qore, 16GB RAM DDR3, 2x2TB HDD in Software ...
1
vote
1answer
196 views

Error while importing osm to Postgres

I'm trying to import osm to Postgres using the osm2pgsql tool. osm2pgsql -cGs -d osm -U postgres -W postgres -H localhost -S /usr/local/share/osm2pgsql/default.style ...
2
votes
1answer
197 views

How do I get the closest point on a road to a point when I have imported OSM data using osm2pgsql?

I have been trying to use OSM data to find the closest point to a road for a given point. I imported the OSM data into postgis using osm2pgsql, and I am getting results back, but they are at the ...
2
votes
1answer
91 views

osm: relation tags to nodes

I filter an osm planet extract using osmfilter. I am only interested in nodes belonging to route=subway relations. After performing this operation, I use osm2psql to load all the data into my postgres ...
2
votes
2answers
213 views

How to change from EPSG:900913 to EPSG:3857 in Postgresql

I didn't use the '-E 3857' switch when importing the OSM data into postgresql using osm2psql. I'm trying to set up a map server for the first time and I'm following the instructions from here: ...
2
votes
1answer
102 views

Can we use existing plant database for Nominatim

i have imported data from the OSM to PGSQL using osm2pgsql for generating tiles, and now i need to add Nominatim support also, this Nominatim requires the same OSM data. can we use the existing ...
1
vote
0answers
27 views

osm2pgsql error reading file

I am using the osm2pqsql utility to convert my osm file to PostgreSQL but it always stops showing the following error. How should I solve this problem?
0
votes
1answer
286 views

osm data import failed with osm2pgsql and windows

I am trying to import a .pbf file into my postgres/postgis database. I am using the following command line for importing the osm file C:\Users\Toton>osm2pgsql -c -d osmgb -U postgres -H localhost ...
1
vote
1answer
178 views

Delete duplicate geometry in postgis tables

After - I dont know what happend - all my entry's in my postgis tables are doubled! I tryed that to delete them but it does not delete any/all duplicates: DELETE FROM planet_osm_point WHERE ...
0
votes
1answer
197 views

osm2pgsql cannot connect to postgis database, running on a Bitnami project installer

Based on this guide I am trying to import an .osm.pbf file into my PostGIS database, which is running on my Postgres Bitnami installation here: [bitnami@ip-xxx]/usr/share/proj$ which postgres ...
0
votes
0answers
41 views

postgis & mapnik “column ”CLASS“ does not exist”

I've piped an osm map of greece into postgis with osm2pgsql and was playing around with C++ mapnik sample code giving "planet_osm_polygon" as the source table: parameters p0; p0["type"] = ...
0
votes
1answer
32 views

Tiles are missing when request from Openlayer2

I have configured a Tile server and i followed the Link for OSM Tile server from switch2osm everything is fine, except when i tried to get the tiles using Openlayers its not serving. But if i give ...
-1
votes
2answers
179 views

Error while building OSMBright

Error while building OSMBright when i run the make.py the following error is coming Traceback (most recent call last): File "./make.py", line 123, in <module> build() File ...
5
votes
1answer
236 views

TileMill fails to load Europe data from PostGIS. What am I doing wrong?

The Problem: Using OSM-Bright in combination with an imported (osm2psql) Europe shapefile, tiles won't load unless I have 2-3 layers active (of the total of 29). I don't have this problem with an ...
1
vote
1answer
87 views

How to export a postgis table to a pbf file?

I need a tool like osm2po or osm2pgsql but that does the opposite thing, convert a postgis table to a pbf file. I think qgis can do this but I can't find that option.
1
vote
3answers
45 views

Tilemill didn't render streets correctly, some parts are missing

can someone please explain me what's happend in the picture below or how i can debug what's going wrong? I downloaded some .osm.pbf files imported the files via osm2pgsql into a postgis database and ...
0
votes
1answer
32 views

Issue using Osmconvert with Python

I want to use osmconvert to parse down the size of my diff files for just the area I'm interested in because osmconvert is way faster than osm2pgsql, which loads the data. When I call the command ...
0
votes
1answer
36 views

osm2pgsql doesn't run in a QGis plugin

I have a problem with osm2pgsql when it runs in a qgis plugin. The function i use looks like this: osm2pgsql = "osm2pgsql -s -d {databaseName} -U {databaseUser} -H {databaseHost} -E ...
3
votes
2answers
250 views

What is the recommended workflow for using TileMill and OSM?

Using osm2pgsql, I imported an OSM extract into a Postgres database. Then I made a layer in in TileMill that contains the data from Postgres. The map was exported to a MBTiles file. At this point, all ...
2
votes
2answers
1k views

Download link to osm2pgsql

I need to download the osm2pgsql for Windows i tried from the path which is given in wiki http://customdebug.com/osm/osm2pgsql.zip and also from below link ...
1
vote
1answer
42 views

Minimum Information to be kept on importing OSM data to use it for creating random start and ent points

I want to only import the minimum of data from OpenStreetMap, to be able to distribute random start and end points for a simulation in administrative areas in germany. I found this file ...
5
votes
2answers
230 views

Working with address data extracted from *.osm

My goal is get all the addresses from a certain country, ideally - from all countries, but for now - only from one. I downloaded an *.osm file from here http://download.geofabrik.de/ for a certain ...
2
votes
0answers
66 views

Weird-looking France after OSM import with osm2pgsql

After importing france-latest.osm from Geofabrik, using osm2pgsql, it seems that the polygon attributed to Metropolitan France (osm_id = 1403916) is a bit odd: I'm far to be a geography expert, but ...
1
vote
0answers
234 views

Generating full planet tiles from OpenStreetMap data?

i am tested using two scenarios, 1) First, i am used switch2osm for tile rendering. its good it handles many things. But it takes long days to pre-render all tiles and it takes huge memory ...