Converts OpenStreetMap data to a PostgreSQL / PostGIS database

learn more… | top users | synonyms (1)

1
vote
2answers
41 views

Importing OSM data into PostGIS and display into QGIS

I am new to all the GIS thing but 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 with ...
0
votes
0answers
10 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
8 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
81 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
37 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
79 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
0answers
42 views
+50

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
32 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
0answers
55 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
26 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
43 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" and pointing the JOSM to my openstreetmap API URL. I imported a pbf file to my local database using » osm2pgsql ...
2
votes
2answers
117 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
45 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
72 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
103 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
105 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
37 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
130 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
91 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
190 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
40 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
52 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 ...
1
vote
0answers
99 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
56 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 ...
0
votes
0answers
59 views

osm2pgsql import fails with parse error

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 ...
0
votes
0answers
56 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
67 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
175 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
65 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
46 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
196 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
443 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
170 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
129 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
72 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
86 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
61 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
78 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
264 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: ...
0
votes
1answer
111 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
1answer
183 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
0answers
33 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 ...
1
vote
0answers
87 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 ...
0
votes
0answers
244 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 ...
1
vote
0answers
111 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
2answers
107 views

How to transfer large amount of OSM data to postgis using osm2pgsql?

I am new to using Openstreetmap data and PostGIS database. I learned how to use osm2pgsql and transferred osm data for a small city to PostGIS database and worked fine. The problem is that when I try ...
2
votes
0answers
109 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
1answer
123 views

Getting only points when importing from OSM to Postgresql

This is my very first time working with OpenStreetMap data so feel free to tell me if I am forgetting important information. I am trying to import some data from OpenStreetMap into PostGreSQL. I ...
1
vote
1answer
189 views

Renderd “planet_osm_polygon” not exists. What to do now?

I'm trying to create my map server. Importing a planet with osm2psql was perfect, I installed nominatim and is working too. I installed the libapache2-mod-tile packet, caring about to not create the ...
0
votes
0answers
76 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 ...