Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

0
votes
3answers
60 views

Openstreetmap-carto style with Tilemill - unknown black line in streets

I was hoping someone experienced this problem in the past, I am at a loss as to what would be causing it. There is an unknown black line in the center of about 80% streets. I have been adjusting ...
3
votes
2answers
105 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 ...
1
vote
2answers
227 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 ...
1
vote
2answers
356 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 ...
0
votes
2answers
35 views

Casting between PostGIS types in GeoAlchemy

I'm working with OpenStreetMap data, and loading it into a PostGIS database using osm2pgsql. The issue that I am currently dealing with is that osm2pgsql stores the shape as a geometry type. I'm ...
4
votes
1answer
72 views

BoundingBox key in Geo API of Redis

I am very happy so see that Redis now offers a Geo API I would like to host a service where, given a latitude-longitude pair, I retrieve a bounding-box (of OSM) from a pgsql query. Since I expect ...
2
votes
1answer
88 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 ...
1
vote
1answer
205 views

Import OSM data into ArcSDE using osm2pgsql

I am trying to import OpenStreetMap (osm) data into a PostGRES database using OSM2PGSQL, and then I need to convert that data so I can use it in ArcSDE/ArcGIS Desktop 10.2. Here is what I do: ...
0
votes
1answer
101 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, ...
0
votes
1answer
150 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
42 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 ...
2
votes
0answers
128 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, ...
2
votes
0answers
72 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
37 views

Errors when trying to optimize OSM Tileserver

So I followed this guide to create my (very first) tile server. While the server works and we are able to serve tiles, when zooming in tiles take a long time (30s) to render. I'm attempting to ...
1
vote
0answers
13 views

OSM2PGSQL cgywin package issues

I'm having an issue getting the OSM2PGSQL cgywin windows package to stay open. When I click the OSM2PGSQL.exe file after unzipping the command prompt window opens then immediately closes. I have tried ...
1
vote
0answers
75 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
375 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: ...
1
vote
0answers
93 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 ...
1
vote
0answers
140 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
0answers
57 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
0answers
64 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?
1
vote
0answers
355 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 ...
1
vote
0answers
167 views

identify subgraphs within planet_osm_line table

I want to identify subgraphs within the planet_osm_line table of the osm2pgsql-schema. those subgraphs are classified by certain tags i want to check. My first attempt was to do this recursively with ...
1
vote
0answers
362 views

Limit data imported into PostGIS database?

I am building a web application in which members will be able to find other members in their area. This is your typical "nearest neighbor" search which I'll perform using their latitude and ...
1
vote
0answers
490 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
0answers
187 views

How to retrieve transport infrastructure data from google map?

I imported into postgis osm data using osm2pgsql. My objective was to get a database with roads elements for a specific region of Italy (i.e. traffic lights, driving directions and turning direction ...
0
votes
0answers
25 views

How to replace a part of OSM data in postgres?

i want to replace the apart of osm data in postgrs database. for example ,replace the osm data of china which in planet osm data. i hava used osm2pgsql, but if use osm2pgsql import the china data ...
0
votes
0answers
38 views

Cannot configure Osm2pgsql in ubuntu 14.04

I'am installing mapserver manually into ubuntu 14.04 using these following link https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ When i install osm2pgsql using ...
0
votes
0answers
79 views

update osm with osmosis fails with “Unknown file format 'auto'.”

I try to update update my data for europe, but it fails. this is how i imported the data: osm2pgsql --slim -d gis -C 20000 --number-processes 6 -S /usr/local/share/osm2pgsql/default.style ...
0
votes
0answers
40 views

PgRouting function to return the route geometry based on multiple stops(via)

Currently i am getting the route geometry by passing start and end points to function pgr_fromAtoB(int,int,int,int,bool,bool) But this will return route geometry only for start and end points but i ...
0
votes
0answers
190 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
157 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 | ...
0
votes
0answers
40 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 ...
0
votes
0answers
300 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 ...
0
votes
0answers
79 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 ...
0
votes
0answers
79 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 ...
0
votes
0answers
625 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
0answers
109 views

osm2pgsql ,AddGeometryColumn : Could not choose a best candidate function

I tried to load osm data into postgresql database using osm2pgsql, but an error occured : SELECT AddGeometryColumn('planet_osm_point', 'way', 4326, 'P... HINT: Could not choose a best candidate ...