Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

0
votes
1answer
25 views

OSM Carto Street Numbers style rules for OSM Bright

I'm running an OSM tile server stack using Mod_tile, renderd, mapnik, osm2pgsql and a postgresql/postgis database on Ubuntu Linux 14.04. I've chosen OSM Bright for my tiles, but i would like to ...
2
votes
1answer
67 views

Tracking OSM “Planet” Extract dates

I'm trying to build a GUI that allows replacement / update of the PostGIS database that holds my OSM extract (which I use for rendering, typical mapnik / tile server arrangement). I'd like to show ...
0
votes
1answer
20 views

All OSM points/polygons with address string

How do you list all the polygons and points in qGIS in such way their full address shows up. My understanding is that an address is always constructed by looking at the 'building's or POI's adjacent ...
0
votes
1answer
17 views

osm2pgsql style - removing amenity=school but keeping the rest of amenities

I am trying to import a PBF file using osm2pgsql, and the file looks like this: ... node,way amenity text polygon # remove the school amenity data node,way amenity=school ...
1
vote
2answers
32 views

Negative OSM ID values - building polygons

The use case is simple: extract all the buildings from OSM via osm2pgsql. In the process, it seems other entities make it into the polygons list, such as "islands", only because they have the "...
1
vote
0answers
19 views

Output shortest route shapefile using pgRouting and JSON data

I'm interested in finding the shortest route between two sets of bike share stations (22/21 stations each) in the city of Glasgow. Note, I need to overlay the final shapefile onto an OSM basemap in ...
1
vote
2answers
37 views

osm2pgsql: Extracting full buildings polygons + addresses text from OSM

I'm trying to extract all the polygons for the buildings in my country, however, it seems osm2pgsql is extracting very little information compared to what I need. My idea was that I will rely on the ...
0
votes
0answers
13 views

osm2pgsql: bad result during COPY error

Hi Everyone so I am trying to import only the roads dataset into postgres. I have taken osm data from geofabrik regions and extracted roads from them using osmfilter them then combined them using ...
0
votes
0answers
35 views

renderd: encountered during parsing of layer 'landuse_gen0'

I am trying to set up open street map on a Ubuntu machine on Amazon. I have imported the whole world into postgresql and it took many days. I am following the tutorial at https://switch2osm.org/...
0
votes
1answer
13 views

How to extract seamarks from OSM PBF?

Ref to this: http://forum.openseamap.org/viewtopic.php?id=2060 and this: How to extract primary and secondary roads from OSM data? and this: http://wiki.openstreetmap.org/wiki/Seamarks/Seamark_Objects ...
0
votes
1answer
30 views

Delete tags from planet.osm with osm2pgsql and minimize size of database

I want to import into PostGIS the whole planet but I am interested for certain tags. Specifically I am not interested in nodes, ways and areas which are related with the land. Below is a small part ...
1
vote
0answers
29 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 --number-...
3
votes
1answer
41 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
35 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
42 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
85 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
36 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
192 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
43 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
99 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
66 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 pre-...
2
votes
1answer
30 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
102 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
63 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
154 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
124 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 --flat-...
0
votes
1answer
187 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
96 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
87 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
141 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
49 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
72 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
214 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 "addr:...
1
vote
1answer
93 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
99 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
181 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
177 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
44 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 --number-...
1
vote
1answer
335 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 ...
3
votes
1answer
227 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
340 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
63 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 ...
3
votes
2answers
117 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
270 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
73 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
114 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
94 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 --flat-...
2
votes
1answer
122 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
291 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 link:...