Questions tagged [osm2pgsql]

Converts OpenStreetMap data to a PostgreSQL / PostGIS database

Filter by
Sorted by
Tagged with
1
vote
1answer
23 views

How much disk space is expected to take an osm2pgsql import of Europe in 2021?

My europe-latest.osm.pbf file is 24GB. I'm currently importing it on 8-core 32GB-RAM server with osm2pgsql as part of switch2osm. I've run the default docker container of switch2osm and after 2 days, ...
0
votes
0answers
36 views

Extract all cities with lat lon coords from Slovakia OSM using PostGIS

I need to extract all cities with lat lon coords from Slovakia OSM. This is how I imported OSM file downloaded from Geofabrik: osm2pgsql --slim --username postgres --database gis --hstore slovakia-...
1
vote
0answers
28 views

OSM tile server — too many highway labels

I'm running a local OSM tile server. I've combined three pbfs (three neighboring states) using osmconvert, then loaded them into postgis database: osm2pgsql --slim -d gis --hstore --multi-geometry --...
0
votes
1answer
30 views

Exporting the data in pbf format, which is imported using osm2pgsql tool

I have imported the pbf data to postgres using osm2pgsql. osm2pgsql -U postgres -W -d osmdbv4 --output-pgsql-schema=db_snapshot --latlong -H localhost -C 20480 --middle-schema=db_snapshot -S default....
0
votes
1answer
49 views

Download all coffe-shop locations in Italy from OSM. Stuck with Qgis, R and geofabrik

I wanted to download all café locations from OSM in Italy. I tried various ways and one of them was in qgis. I used the awesome quickosm-plugin and did the following: But it always fails with a ...
0
votes
0answers
15 views

Installing older version of osm2pgsql

I am trying to use open source project named SciGRID to construct a power network. The project requires power tag data to be filtered (using osmosis) and loaded into a postgres database using ...
0
votes
1answer
43 views

No password supplied error from osm2pgsql

I want to load some power data to a database I have created in postgres (postgis). But when type the following command in the terminal (ubuntu 18.04) I ended up with the following error. osm2pgsql -r ...
0
votes
1answer
27 views

Import OSM file into pgrouting, keeping certain key/values

i want to import a big (10G) OSM network into PostGIS for pgRouting. As i have to do some postprocessing with Postgres i need to load some key/values from the OSM dataset into the database as well, e....
0
votes
0answers
50 views

Rebuild PostgreSQL index during import osm2pgsql

I started the full planet import, and after a week of work the job was ALMOST done, failed during building indexes after the import as the harddrive run out of space. Is there a way how I can just ...
0
votes
0answers
16 views

T-rex basemap style

I've figured out how to display a tile using T-rex, only problem i don't have any basemap is it normal ? Do i need to load another table ? I took my data form geofrabrik as an .pbf file. I have used ...
0
votes
0answers
19 views

Tile server fail to display map

I ma begining with vector tiles and geo data in general. I am running a T-rex server to serv data post a postGIS database. i have an issue with my browser part because i can't display anything ! ...
0
votes
0answers
28 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&...
0
votes
1answer
152 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 ...
1
vote
0answers
38 views

Get all bus lines for a set of stops in overpass / OSM

I am trying to get a list of lines for a large set of busstops (lets assume to query worldwide). As far as I have figured it out, I get a set of busstops from download.osmdata.xyz. Now I could query ...
1
vote
0answers
43 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 ...
1
vote
1answer
47 views

Troubles translating own OSM server tile to English (ubuntu 18.04)

I have created a OSM tile server using the https://switch2osm.github.io/ tutorial for ubuntu 18.04 with great success but no matter what I cannot display the map labels in English only, I have tried ...
0
votes
0answers
30 views

Osm2pgql failed to output expired tiles for “delete” operation when running in cron

I am using osm2pgsql to: Append .osc files into gis rendering database (based on mod_tile / Mapnik stack) to "delete" some features Generate expired tiles list via -e -o options Fed the ...
0
votes
2answers
71 views

GeoServer complains because osm2pgsql didn’t create primary keys

I imported OSM data into a PostGIS database using osm2pgsql, then served it in WFS via GeoServer. However, QGIS gets stalled when trying to view these layers. I found corresponding GeoServer errors ...
0
votes
1answer
134 views

osm2pgsql failed import The system cannot find the file specified

I got error message, when loading osm file to PostgreSQL by osm2pgsql command. I run the following command line : osm2pgsql -c -G -U postgres --hstore -S D:\osm2pgsql\default.style -U postgres -W ...
0
votes
1answer
27 views

Coordinate drift when using osm2pgsql and specifying EPSG code

We had a PostGIS database which was initialized quite some time ago using an osm.pbf file from Geofabrik, without a specified coordinate system. It defaulted to using EPSG 900913 (Google Maps Global ...
2
votes
1answer
157 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 ...
0
votes
0answers
30 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 ...
0
votes
1answer
194 views

Matching GPS trackers POINT data between Nodes of OSM (Open Street Map) [closed]

I have GPS point data of vehicles from XYZ Tracking Company. The data has following columns: UnitID RecordDateTime LATITUDE LONGITUDE Speed Direction Reason Altitude Data Dictionary is given below:...
3
votes
3answers
136 views

Intersecting Polygons to Build Boundary Hierearchy using PostGIS

I have a set of polygons that are stored flat in a table (these are OSM admin boundaries extracted through Osmium and osm2pgsql). Each polygon has one record for it. However, these polygons form ...
2
votes
1answer
379 views

Determine correct tolerance/epsilon for line simplification in different zoom-levels when generating vector tiles

I am writing my own vector-tile generator for a map renderer that I have written, but I am unsure of how to pick the correct epsilon value to use in the PostGIS method ST_Simplify depending on the ...
1
vote
1answer
73 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 ...
0
votes
0answers
178 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 ...
1
vote
2answers
112 views

How to get land_area polygons with osm2pgsql?

I want to get the polygons of several administrative land areas. For example https://wiki.openstreetmap.org/wiki/DE:Grenze#Innerstaatliche_Grenzen contains the relation numbers for the land areas of ...
2
votes
0answers
73 views

Download certain POIs for a whole country and transfer to PostgreSQL database

I'd like to extract certain data from OSM for a whole country (Germany). The data I'd like to obtain are POI's, but obviously not all of them. I'd like to filter only the supermarkets for example and ...
2
votes
1answer
193 views

Lossless import of full OpenStreetMap planet dump into PostGIS

I would like to import a full OpenStreetMap planet dump as PBF into a PostGIS tables. With tools like osm2pgsql or imposm3, configuration files are neccessary. Unfortunately, it is not possible to ...
1
vote
0answers
44 views

Extracting city information only from OpenStreetMap

I need to extract City as well as hierarchy of admin entities for selected countries. My understanding for now is that I'll have to get node primarily and find a clever filtering based on tags. And ...
0
votes
0answers
95 views

osm2pgsql: does table planet_osm_roads contain any non-duplicate data?

Although there is a osm wiki page that attempts to shed light on the different tables which are created within a postgres/postgis database there is something that is not quite made clear: Is the data ...
2
votes
0answers
183 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: ...
0
votes
0answers
49 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, ...
0
votes
0answers
28 views

osm2pgsql osm_timestamp is NULL

I use osm2pgsql to load osm.pbf Data into a PostGIS database. One objective is to store the osm_timestamp into a column. The flag "-x" is used in the cmd code. With the following line in the ...
1
vote
0answers
143 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 ...
3
votes
1answer
187 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 ...
1
vote
1answer
181 views

Creating Isochrones - pgr_drivingDistance 2.6 SQL error

Im trying to create a matrix of driving distances from an osm2pgrouting parsed dataset. Following many blogs I have the below incorrect SQL: SELECT * from ways join ( SELECT * FROM ...
1
vote
1answer
45 views

mod_tile renders OpenStreetMap without some water

My rendered map: The same view from openstreetmap.org: What went wrong? I downloaded europe_latest.osm.pbf and nigeria_latest.osm.pbf and imported these files using --append. Now, I'm trying to ...
2
votes
1answer
178 views

Some OSM tags in polygons and some in points - how to bring them together

Tagging objects in OSM can sometimes be done as polygon or as point. For example ruins or museum So far so good, but finding a specific object in a osm-dataset makes it necessary to look into the ...
0
votes
1answer
73 views

How to load OSM file from local machine to the server using osm2pgsql?

I wanted to upload the OSM file from my local machine to server using osm2pgsql, but the data is not imported. I have just created the database s1(no table), do I need to create the table also, if ...
0
votes
1answer
599 views

Adding custom layer to OSM data in switch2osm?

I'm new to switch2osm and I've created an OSM Tile Server with switch2osm on Ubuntu 16.04 LTS. It uses Apache, Mod_tile, renderd and Mapnik to render tiles. It uses PostgreSQL as DBMS and osm2pgsql to ...
5
votes
1answer
424 views

Create a line string from street geometry

I'm currently facing some hard times trying to create a simplified line from a street geometry. The data that I'm currently using comes from OpenStreetMap, using osm2pgsql.(Which means PostGIS, but I'...
2
votes
0answers
277 views

osm2pgsql import OSM data in EPSG:27700

I am trying to use osm2pgsql on Windows to import OSM data to a PostGIS database. I want to pass the EPSG:27700 via the --proj option as follows: osm2pgsql --proj 27700 <other options not shown>...
0
votes
1answer
143 views

Loading layers from PostGIS db (populated with osm2pgsql) in QGIS?

I have downloaded some OSM data from geofabrik and used this to create a PostgreSQL/PostGIS database using the osm2pgsql tool: osm2pgsql -G -d <db> -U postgres myfile.osm Examining the ...
0
votes
1answer
263 views

Where to find Windows osm2psql binaries in 2018?

I've read all the stuff in their git, here at stackexchange, in OSM wiki, but all links are broken and the latest windows binary I found is HOTOSM bundle built at 2010. Download link to osm2pgsql ...
1
vote
1answer
169 views

Creating osm2pgsql hstore tags using PostGIS column

This is the opposite question to this one: Creating columns in PostGIS using osm2pgsql hstore tags First, I changed default.style to make separate 'lanes' column. Then I extracted osm database ...
1
vote
1answer
131 views

Find polygon boundary dynamically based on a point (lat/long) having type farmland using OSM

There are many ways to retrieve the polygon information when you know that the information is already present somewhere (data locally or in database containing extracted info about polygon). But this ...
1
vote
2answers
113 views

Ring geometries in pgRouting OSM DUMP

After performing pgRouting's "pgr_analyzeGraph" algorithm, over an Open Street Map dump uploaded to my PostGIS DB, I get this output, by I can't figure out what "ring geometries" are. Does somebod ...
0
votes
0answers
52 views

osm2pgsql stops after importing several extracts

I want to import several city extracts from the bbike website into my postgis database. I use windows on a desktop pc with 16GB RAM and a quadcore processor. The first couple of extracts imported ...

1
2 3 4 5 6