All Questions
Tagged with postgresql osm2pgsql
90
questions
1
vote
1
answer
37
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
88
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
44
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' ...
1
vote
1
answer
246
views
"Bad allocation" error when importing a large PBF file (OpenStreetMap) on PostgreSQL with osm2pgsql
I downloaded the 72 GB OpenStreetMap PBF file (planet-230619.osm.pbf) at this link https://planet.osm-hr.org/pbf/ and I am trying to import it into PostgreSQL + PostGIS with the library osm2pgsql ...
- 159
1
vote
2
answers
177
views
osm2pgsql error "no COPY in progress" when importing map data into PostgreSQL
I've been trying to import map data into PostgreSQL 12 database (on Ubuntu 20.04.5 with wsl) using osm2pgsql, but I get this error after executing this command:
$ osm2pgsql -U postgres -H localhost -...
- 21
0
votes
1
answer
135
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
239
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
3
votes
1
answer
280
views
pgrouting - pgr_nodeNetwork: Can NOT determine the srid of the geometry "osm_id" IN table
I have been following the guide in order to import PBF data into a PostGIS database: pgrouting - documentation.
I have downloaded the Belgium PBF from Geofabrik and installed all extensions needed ...
- 285
0
votes
0
answers
151
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
74
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
529
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
56
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
153
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
399
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