Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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
61 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 ...
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 ...
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 ...
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 ...
3
votes
2answers
162 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
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
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 ...
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. ...
-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 ...
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
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
1answer
168 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. ...
1
vote
4answers
290 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 ...
-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 ...
2
votes
2answers
83 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 ...
2
votes
1answer
208 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 ...
0
votes
3answers
64 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 ...
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
78 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 ...
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 ...
0
votes
1answer
255 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
98 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
56 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
319 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 ...
3
votes
3answers
716 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
191 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
168 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
90 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
109 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
91 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
106 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
395 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: ...