Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

0
votes
0answers
16 views

using changeset for larger region to update OSM data in PostGIS

I'm using the OSM import and update workflow described here to maintain OSM data in a PostGIS database. Import (osm2pgsql): osm2pgsql -c -d gps -U gps --cache 8000 --number-processes 4 --slim ...
1
vote
0answers
18 views

osm2pgsql --append extremely slow

I have planet.osm imported into a database. Now I am trying to set up hourly updates. I generated a file changes.osc.gz using osmosis. This file contains updates for 1 hour - which seem to be ...
0
votes
1answer
59 views

Nominatim installation error: Out of memory for node cache dense index

I am installing Nominatim on my Ubuntu server 14.04 through this link and trying to load OSM data into my postgreSQL database. For loading into my database I am using this command as given in the ...
0
votes
1answer
17 views

osm2pgsql: Failed to fork helper process

I am trying to import planet.osm on am Amazon EC2 machine. It is a a machine with 16 processors and 122GB RAM. The parameters I use are: osm2pgsql -s -H aws.rds.host -d osm -U user -C 92000 ...
1
vote
1answer
22 views

How to use the Tile Server to fetch latitude/longitude data

I have installed a tile server using the following link and my main purpose was to geocode as many times as possible. Initially I was using openstreet API to geocode but they have certain limits so ...
0
votes
1answer
24 views

Osm2pgsql failed due to error when I try to import data into PostgreSQL

I am using the following link to install openstreetmap server on my ubuntu 14.04 server. I have followed their tutorial line by line and installed most of the dependencies and everything. When I try ...
2
votes
2answers
115 views

PostgreSQL trouble editing points / lines / polygons in QGIS

I have a problem with postgresql and QGIS : I can add points/lines/polygons and fillup field But I can't : delete points/lines/polygons modify points/lines/polygons (move or modify field) ex : ...
0
votes
0answers
106 views

Installing OSM on Centos: Protobuf Problems

The Problem: I'm trying to install OSM on CentOS 7. One of the dependencies is protobuf and protobuf-devel. I've installed the library through the package manager, through source, with different ...
0
votes
0answers
56 views

Can't upload files to database by Nominatim

I was trying upload geofabric's netherlands-latest file into Nominatim's database. I used bellow command and all was fine: ./utils/setup.php --osm-file maps/netherlands-latest.osm.pbf --all 2>&1 | ...
1
vote
1answer
32 views

OSM import fails due to non-matching PostgreSQL version

I am trying to follow the installation of Nominatim, based on http://wiki.openstreetmap.org/wiki/Nominatim/Installation#Ubuntu.2FDebian. The command ./utils/setup.php —osm-file <pbf-file> —all ...
2
votes
1answer
40 views

Osm2pgsql: Error Loading in north-america-latest.osm.pbf

I've had my OSM Tile server working great for several days now, but just with Indiana. I decided to fill the gis database with all of North America. I run the following command: sudo -u user ...
1
vote
1answer
36 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
43 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
107 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
1answer
38 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
61 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
26 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
55 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
142 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
60 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
77 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
77 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
103 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
92 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
49 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
135 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
74 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
85 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
240 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
133 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
111 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
54 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
134 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 ...
3
votes
2answers
65 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
139 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
389 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
255 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
41 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
259 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
267 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
104 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
277 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
136 views

Can we use existing planet 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
34 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
334 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
273 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
282 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
47 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
36 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
227 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 ...