Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

1
vote
2answers
78 views

Importing OSM data into PostGIS and display into QGIS

I am new to all things GIS! However, I need to set up a full GIS infrastructure for a project. I have installed a Postgres server with PostGIS. That is on ancient hardware for now, 32bits processor ...
1
vote
0answers
12 views

Osm2pgsql error, unable to open

I have a problem when I run osm2pgsql for Liechtenstein (small dataset). I have a VM running Ubuntu (64-bit) with 5GB of RAM. This is the error I get: osm2pgsql --create --slim --cache 512 ...
1
vote
2answers
232 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
369 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
1answer
37 views

Getting node information of a way in OSM2PGSQL data

I have a feeling this is not possible, but I am looking to get information on the nodes which are part of a line in the planet_osm_line table. The issue which I am trying to handle is I am trying to ...
3
votes
1answer
31 views

How to update OSM data using osm2pgsql?

I have already loaded osm data into postgresql earlier. Now I want to update the database. I have downloaded the pbf file from geofabrik. How I can update the database without deleting the existing ...
0
votes
0answers
29 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
2answers
54 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 ...
1
vote
1answer
104 views

OSM data import error on Windows 2012 server using osm2pgsql

I am trying to use OSM data using mapserver (ms4w) on windows. Set up all tools and downloaded data for this purpose. http://download.geofabrik.de/north-america/us/georgia-latest.osm.bz2 Extracted ...
3
votes
1answer
31 views

How to quickly load two distinct areas into postGIS without using --append flag?

I have two distinct / non-overlapping areas that I wish to load into a postGIS database. The trouble is that once one area is loaded, it becomes painfully slow to load the second area using the ...
2
votes
1answer
697 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
2answers
421 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 ...
3
votes
2answers
636 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
58 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
108 views

How to build osm tileserver (Ubuntu 14.04 LTS)?

I'm trying to follow the tutorial: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ And the first part works greatly, but because i'm new at using Linux (Ubuntu 14.04 LTS ...
1
vote
1answer
67 views

No data found in this area ERROR - JOSM

I'm trying to edit my local database using JOSM. I'm already running the "Rails Port API" and pointing to it. I imported a pbf file to my local database using the osm2pgsql without errors. The ...
1
vote
0answers
94 views

osm2pgsql import fails with parse error [closed]

I'm attempting to import the 45GB (compressed) planet-latest.osm.bz2 file downloaded from ftp://ftp.spline.de/pub/openstreetmap/planet/planet-latest.osm.bz2 but I receive parsing errors. As of now I ...
1
vote
0answers
49 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 ...
0
votes
1answer
32 views

Get invalid blocksize error when trying to generate a render base with osm2pgsql

I'm trying to generate a database with the osm2pgsql schema using the osm2pgsql application, with the command: osm2pgsql -H host -U user -P 5433 -W -d db -k -l -c -s file.pbf But when I'm running ...
2
votes
2answers
1k views

osm2pgsql import planet.osm.bz2 slowness

I am trying to import whole planet data to my i7 3770k + postgres on SSD + 16gb RAM in order to render my custom tiles. But the process is painfully slow and multi core is not helping (though you ...
0
votes
2answers
54 views

Error on basic usage of osm2pgsql

I need only basic osm2pgsql usage. Using postgres user and sandbox (created) database. sudo -u postgres osm2pgsql -s -U postgres -d sandbox brazil-latest.osm.pbf NOTES Using UBUNTU 14 LTS, ...
2
votes
1answer
202 views

osm2pgsql Ways importing very slowly in .pbf, much slower than .osm

I'm currently importing the planet-latest.osm.pbf file I downloaded from ftp://ftp.spline.de/pub/openstreetmap/pbf/planet-latest.osm.pbf some time last week. I'm importing it using the following ...
2
votes
1answer
29 views

Preprocess OSM streets to see if query points fall “on” them

I am interested in the following query: Given a set of query points ($\leq 10$), how many of them have distance at most $s$ meters to the closest point on the closest street. What's the most ...
4
votes
1answer
82 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 ...
-1
votes
1answer
154 views

Pedestrian Routing using pgRouting

I'm new to pgRouting and I want to implement a pedestrian routing system. I've already implemented a routing system using pgRouting, PostGIS, GeoServer, OSM data and Open Layers 3 and it uses dijkstra ...
0
votes
1answer
132 views

pgsql2osm? How to generate osm files from osm2pgsql database?

I want a method to export osm files from a postgress database. I already have a osm2pgsql database, a apidb database and nominatim database in which I have imported osm files. Now I need to export ...
0
votes
0answers
48 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 ...
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 ...
3
votes
3answers
114 views

Importing OSM files to PostGIS

I have installed QGIS 2.4.0 on Windows. I also downloaded an OSM file form Geofrabrik (SouthAmerica). I have been searching an option (plugin also) in QGIS for importing the OSM file to my PostGIS ...
0
votes
0answers
86 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 ...
2
votes
1answer
215 views

Postgis and python parameterised queries

I have a python script that i am trying to run in order to dump a postgres table and I noticed there is a pgsql2shp command in bash to perform this easily but I would like to incoperate the same ...
3
votes
3answers
712 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 : ...
-1
votes
1answer
60 views

osm converter cant convert osm to pbf [duplicate]

i downloaded .pbf file from this link and then i renamed it to tu.osm becuase it is a .osm file then i used osmconverter to convert it to .pbf using: c:\osm>osmconvert tu.osm --out-pbf >tu.pbf ...
0
votes
0answers
45 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 ...
3
votes
2answers
161 views

Reverse geocoding using OSM data imported into PostGIS

I'm trying to reverse geocode some points using an OSM import into PostGIS. I imported the OSM data (for Denmark so all addresses should be avaialable) into PostGIS using osm2pgsql enabling ...
1
vote
1answer
573 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 ...
1
vote
2answers
89 views

Extremely slow OSM data import

I'm using osm2pgsql to import the entire planet database. I've followed the instructions from the switch2osm (https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/) page and used ...
2
votes
1answer
379 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 ...
1
vote
1answer
73 views

Applying OSM z-order after osm2pgsql with qgis

I've trying to find a solution to applying the OSM z-order in qgis after using osm2pgsql. Everything is working perfectly, until I add the each layer to the canvas, where the z-order is not being ...
1
vote
2answers
263 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) ...
1
vote
4answers
289 views

OpenStreetMap Style Editor besides Mapbox TileMill and CloudMade

I'm looking for an online OSM style editor that lets me style OSM ways and nodes by tags. I know CloudMade's editor is no longer available, and Mapbox's does this but has zoom level rendering limits ...
0
votes
1answer
154 views

Creating my own map server - with Road speed and Reverse geo coding - using OSM data

Currently I'm using a few services for mapping/reverse Geo coding/road speeds 1 open.mapquestapi.com/geocoding - revese geo coding (usually street name) 2 api.geonames.org - get POI name (e.g. ...
2
votes
1answer
95 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
0answers
41 views

Resuming an osm2pgsql import to postgres [closed]

I was doing an import of the north american data with osm2pgsql using sudo ./osm2pgsql -c -S /home/osmNA/nfs/osmNA/osm2pgsql/default.style --slim -d addressNA --flat-nodes flat-nodes.bin ...
-1
votes
1answer
52 views

How to order points on a road linestring to follow the road

So I'm using a osm2pgsql schema. When I get a road, the points in the linestring don't have an order, so when I try to draw the road, it won't follow the road but will be a bunch of lines. Do I have ...
1
vote
1answer
270 views

osm2pgsql vs imposm rendering performance

Is there any difference in rendering performance between using a osm2pgsql vs imposm imported PostGIS DB in Mapnik? Or asking it differently, is there any downside of using imposm if I only want to ...
2
votes
3answers
533 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 ...
0
votes
3answers
63 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 ...
2
votes
1answer
166 views

Alternative approach for loading osm2pgsql data

I am slowly going insane trying to successfully complete an OSM data import and I would like to find an alternative approach. What I'm attempting is frustratingly simple yet fails repeatedly. ...
2
votes
2answers
82 views

How do I convert the coordinate data from osm into actual longitude latitude points

So I've imported a osm dataset into a PostGIS db using osm2pgsql, however when I call ST_asText( way ) I get weird coordinates like "POINT(16767838.9 -4051592.94)" What format are these ...