All Questions
67 questions
1
vote
1
answer
48
views
Does PostgreSQL function concat_ws works as expected?
You find the documentation of the concat_ws PostgreSQL function here.
It says this request concat_ws(',', 'abcde', 2, NULL, 22) results in this reply abcde,2,22.
This example does not proves the ...
1
vote
0
answers
110
views
Updating existing PostgreSQL database with OSM data
I currently work on the project which is directly working with the geo data of the country where I live. The database we have is quite huge, containing not only the geo data but also some other stuff. ...
- 11
0
votes
0
answers
56
views
osm2pgsql : How to store "nd ref" data to a column in PostgreSQL/PostGIS
I'm using osm2pgql to import an OSM map. I imported it successfully but I need also the information in the "nd ref" node of the OSM XML.
I.e. my OSM XML has a node like:
<way id='1805' ...
0
votes
1
answer
149
views
Osm2pgsql data dump in specific schema not working
While using osm2pgsql 1.6 i am trying to dump PBF into specific schema of postgres DB using following commands using docker. (i am setting database properties in docker env)
docker run -v /mnt/ne-...
- 1
1
vote
0
answers
252
views
osm2pgsql get_way failed: server closed the connection unexpectedly
I'm trying to import OSM Europe to postgresql under Debian.
If I am importing only e.g. Czech Republic, then import is successful. But if I try to import Europe then I always got an warnings and error:...
- 119
0
votes
0
answers
164
views
osmpgsql fails to load all data from OSM file
I have a project where I need to use osm2pgsql to load an OpenStreetMap file (osm.pbf).
(Using a command like this:
osm2pgsql -c -d database_name -U user -H localhost -W -S "path to style file&...
- 1
0
votes
1
answer
1k
views
Error appending data to existing PostgreSQL database for OSM with osm2pgsql
When running osm2psql on an existing database I get an error
osm2pgsql -v -d gis -a -s -G --flat-nodes ./nodes.cache --number-processes 8 ./thailand.osm.pbf
Output is :
Allocating memory for dense ...
- 3
1
vote
0
answers
78
views
Extending OSM database with new data
I want to add a new table inside my OSM database with extra data for every restaurant, and then when retrieving the places join the table by the "osm_id", is this possible and if yes, any ...
- 11
2
votes
1
answer
582
views
How to increase a PostGIS query efficiency when querying OSM information
I have this SQL query to get roads from my PostGIS server.
WITH boxed_roads AS
(SELECT * FROM "planet_osm_line"
WHERE ST_Within(way, ST_MakeEnvelope(xmax ,xmin, ymax, ymin, 4326))
)
SELECT ...
- 154
0
votes
0
answers
69
views
Problem with osm2pgsql
I'm having a problem importing a .pbf file in PostgreSQL using the osm2pgsql.
I've downloaded the italy-latest.osm.pbf and as I do every year I'm going to upload it in PostgreSQL.
I did it for other ...
- 153
1
vote
1
answer
162
views
Osmosis failed: ERROR: relation "pend_ways" does not exist
I tried to generate osm update using osmosis and osmium(omsium only for setting configuration.txt from existing russia-latest.osm.pbf).
I use osmosis like that:
osm2pgsql -append --slim --cache ...
- 433
2
votes
0
answers
415
views
How to load OSM data to RDS instance (PostgreSQL) on AWS
I am trying to load the OSM data to PostgreSQL (RDS on AWS). I could not find any information on loading the OSM data to cloud. I tried the steps outlined in many website and osm2pgsql but nothing ...
- 121
2
votes
0
answers
374
views
Osm2pgsql failed Cannot detect file format. Try using -r
I use Osm2pgsql 1.0 and this my action :
sudo osm2pgsql --slim -c --cache 29000 --proj 3857 russia-latest.osm.pbf -H xxxx.local -d osm -U osm_user -W -P 5432
was failed after some time:
...
- 433
2
votes
0
answers
195
views
Getting node way relationship from Osm2pgsql data
I would like to ask what is the best way to extract which way a node belongs to given a Postgresql databased generated by Osm2pgsql.
For example, in https://www.openstreetmap.org/node/4961890042, ...
- 121
2
votes
0
answers
352
views
Combine data of OSM roads into longer lines using PostGIS
For my vector map I'd love to display highways at a quite early zoom level. The problem is that this data would be quite big, so I thought I simply ST_Simplify it. The problem though is that the OSM ...
- 1,011
3
votes
1
answer
440
views
How to set schema parameter in osm2pgsql calling
How I can to set schema name parameter when call osm2pgsql?
For example:
osm2pgsql --create -s -C 2500 -G -S D:\default.style -d osm_db -o input -U osm_user -W -H localhost -r pbf D:\osm.pbf
I set ...
- 433
3
votes
1
answer
3k
views
Where is flat-nodes file located?
I would like to use osm2pgsql to load the europe.osm.pbf to the database.
I've already read about the optimalization to make the osm2pgsql do it as fast as possible. However, there's one option, that ...
- 215
1
vote
1
answer
288
views
What are the options for generating images from OSM data without importing it to PostgreSQL
While I'm waiting for my first try of an osm2pgsql import to succeed I am wondering if what I'm doing is really necessary.
The goal is to periodically produce some .png maps from a slightly filtered ...
1
vote
4
answers
2k
views
Column "tags" is missing in PostgreSQL table created with osm2pgsql
I downloaded osm2pgsql for Windows from AppVeyor (https://ci.appveyor.com/api/projects/openstreetmap/osm2pgsql/artifacts/osm2pgsql_Release_x64.zip?tag=0.96.0&job=Environment%3A%20arch%3Dx64) and ...
1
vote
1
answer
475
views
How to import OSM relations to PostgreSQL databases? [closed]
I have created PostgreSQL databases using Osm2pgsql. I have all the lines and points data.
How can I import the relations stored in OSM file? for example turn restriction?
Is there an easy way to ...
- 11
0
votes
1
answer
356
views
ST_AsGeoJSON providing unexpected values
GIS newbie here! I have been playing around with the import I did from an OSM region (that I got from here) to postgres using the osm2pgsql conversion tool. The command I used to import was this:
...
- 111
4
votes
1
answer
695
views
Define table name with osm2pgsql
When I load OpenStreetMap data to PostGIS using osm2pgsql the resulting tables look like this:
+----------+--------------------+--------+---------+
| Schema | Name | Type | Owner |...
- 899
5
votes
3
answers
4k
views
Loading OpenStreetMap data to a custom PostgreSQL schema via osm2pgsql
What is the procedure to load OSM to a different schema than public?
The osm2pgsql documentation mention the parameter --prefix for specifying the tables prefix (planet_osm by default) but does not ...
- 43.2k
0
votes
0
answers
137
views
Updating OpenStreetMap in PostgreSQL?
I can't use imposm tool, because it is not compatible with Nominatim.
So it seems that I can use only osm2pgsql. But is there any ready to use toolchain, that allows to update OSM in an easy way.
I ...
- 389
1
vote
1
answer
698
views
How to import OSM ways, without tags, into PostgreSQL using osm2pgsql?
I have a particular problem when importing OSM Data with osm2pgsql.
I have been searching for days on how to import ways, which do not have any tag, but which are part of a relation (which itself has ...
2
votes
1
answer
788
views
Postgis-Sharpmap Query
I want to display a map in offline mode (without Internet connectivity), so I have imported OSM data into my PostgreSQL database using osm2pgsql installer.
I went through various links and tutorials ...
- 53
1
vote
1
answer
538
views
Unable to load an OSM .bz2 file into a PostGIS database using osm2pgsql
Following is the query :
C:>osm2pgsql -c --slim -d osm_1 -U postgres -H localhost -S C:\default.style C:\mumbai_india.osm.pbf
Following is the error on which i am stuck:
Using projection SRS 900913 (...
- 53
2
votes
1
answer
550
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
...
- 2,190
7
votes
1
answer
6k
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 ...
- 3,217
1
vote
1
answer
1k
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 ...
- 103
5
votes
3
answers
2k
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 ...
- 63
1
vote
1
answer
522
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 ...
- 121
2
votes
2
answers
3k
views
Applying OSM z-order after osm2pgsql with qgis
I've trying to find a solution to applying the OpenStreetMap 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 ...
- 307
6
votes
1
answer
3k
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.
...
- 3,698
2
votes
0
answers
507
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-...
- 802
2
votes
1
answer
2k
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:...
- 285
1
vote
1
answer
626
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 ...
- 285
4
votes
1
answer
8k
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 ...
- 285
1
vote
0
answers
661
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 | ...
- 413
2
votes
1
answer
288
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 —...
- 1,217
1
vote
1
answer
457
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 ...
- 175
0
votes
1
answer
804
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
2
votes
1
answer
1k
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 ...
- 181
1
vote
0
answers
244
views
OSM Bright Cartography XML
I have 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 ...
- 181
2
votes
1
answer
642
views
Import of OSM data into PostgreSQL with osm2pgsql polygon problem
I've mananged to import my great-britain osm file successfully into postgres and I can query everything fine.
osm2pgsql -s -j -G -l --number-processes 8 -K -U james -C 10000 -d osm myfile.osm
I'm ...
- 23
4
votes
2
answers
6k
views
How to change from EPSG:900913 to EPSG:3857 in Postgresql
I didn't use the '-E 3857' switch when importing the OSM data into postgresql using osm2psql.
I'm trying to set up a map server for the first time and I'm following the instructions from here: https:/...
- 201
7
votes
1
answer
921
views
TileMill fails to load Europe data from PostGIS. What am I doing wrong?
The Problem:
Using OSM-Bright in combination with an imported (osm2psql) Europe shapefile, tiles won't load unless I have 2-3 layers active (of the total of 29). I don't have this problem with an ...
- 121
1
vote
1
answer
112
views
Minimum Information to be kept on importing OSM data to use it for creating random start and ent points
I want to only import the minimum of data from OpenStreetMap, to be able to distribute random start and end points for a simulation in administrative areas in germany. I found this file https://github....
- 591
9
votes
2
answers
4k
views
Working with address data extracted from *.osm
My goal is get all the addresses from a certain country, ideally - from all countries, but for now - only from one.
I downloaded an *.osm file from here http://download.geofabrik.de/ for a certain ...
- 193
1
vote
1
answer
411
views
osm2pgsql missing coordinates
I am quite new to GIS and OSM and am trying to get my head around exporting custom OSM region and uploading them into PostgreSQL.
I have started with a very small map area to export with only two ...
- 135