Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

0
votes
0answers
189 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 | ...
2
votes
1answer
65 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
24 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 ...
0
votes
1answer
197 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 ...
1
vote
2answers
248 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
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 ...
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
2answers
397 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
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
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
35 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 ...
1
vote
1answer
65 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
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
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 ...
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 ...
1
vote
2answers
99 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
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-...
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 ...
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 ,...
0
votes
2answers
84 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
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 ...
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 --...
2
votes
1answer
795 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
451 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 "./make.py",...
3
votes
2answers
720 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
59 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
190 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
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 ...
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
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-...
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 ...
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
98 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
268 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
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 ...
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
175 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
184 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
62 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
151 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-...
2
votes
1answer
226 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
870 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
85 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
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 ...
3
votes
2answers
210 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
656 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 /opt/...