Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

0
votes
2answers
167 views

Enlisting all OpenStreetMap (OSM) street names for General Transit Feed Specification (GTFS) routes?

I have exported OpenStreetMap (OSM) data of a city to my local postgresql db using osm2pgsql. I would like to add the General Transit Feed Specification (GTFS) routes information (say bus routes) ...
0
votes
2answers
179 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
1answer
27 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
24 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
2answers
198 views

Getting OSM maps in Equirectangular Projection via osm2pgsql

I'm trying to import some OSM data into psql as equirectangular projection using osm2pgsql with the following command: osm2pgsql -c -d osm -S /usr/local/share/osm2pgsql/default.style -l ...
1
vote
0answers
33 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 ...
2
votes
1answer
545 views

Using osm2pgsql data with pgrouting 2.0

I have successfully manage to make the workshop from of pgrouting (wrote for v1) with pgrouting v2. Now I want to use pgrouting 2 on my postgis database created with osm2pgsql. The problem is first ...
2
votes
1answer
248 views

Geoserver OSM data Imported via osm2pgsql - most efficient tables to use to style roads

The Osm2pgsql importer for OSM data to Postgres results in two tables for ways, one called planet_osm_roads and a second one called planet_osm_lines The Osm2pgsql documentation states that the ...
0
votes
1answer
198 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
1answer
654 views

Unable to load Shapefile using pgShapeloader / shp2pgsql-gui (pgAdmin3's PostGIS Shapefile Import/Export Tool)

I am trying to load a shapefile (http://dds.cr.usgs.gov/pub/data/nationalatlas/statesp020_nt00032.tar.gz) into PostGIS 2.0.1 using pgAdmin3's PostGIS Shapefile Import/Export Tool. However its not ...
0
votes
0answers
73 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 ...
1
vote
1answer
116 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 ...
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
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
82 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
50 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
266 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 = ...
2
votes
1answer
201 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 ...
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
199 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
2answers
214 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
181 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 ...
4
votes
3answers
595 views

How to find out what features /tags are included in an .osm or .pbf file?

I would like to load osm data into a postgis (postgresql) database. In How to load OSM data into PostGIS preserving all Tags? there has been a solution posted: Download the OSM files (in .osm ...
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"] = ...
-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 ...
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
vote
0answers
387 views

Adding osm data to Postgres via Osm2pgsql : duplicate key value violates unique constraint

I'm trying to import osm global world data into a database created in postgreSQL but after a while of processing, I've got this error : Reading in file: E:\planet-latest.osm\planet-latest.osm ...
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.
0
votes
1answer
162 views

PostGis geometry name lookup failed for table

I have a table name erpAssets which has column name Region of type polygon. it contains entries of points also like (-79.4609576808001,43.9726680183837)). I have written query which convert these ...
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 ...