Stack Overflow
Stack Overflow

Questions tagged [osm2pgsql]

44 questions
3
votes
1 answer

Import OSM file to PostGis on Windows10

can you help me with importing planet.osm file to my PostGist db? I am new in this and I found tutorials only for linux. There are some commands, but I do not know how use it ... I will be grateful for some step by step tutorial. I'm using GeoServer…
Denis Stephanov
  • 4,563
  • 24
  • 78
  • 174
3
votes
1 answer

Conversion of .osm file extension to .osm.pbf

I am trying to use osm2pgsql which requires me have a .pbf file extension. Is it possible to convert .osm file to .osm.pbf file? Thanks in advance :)
codego123
  • 171
  • 2
  • 12
2
votes
1 answer

Osm2pgsql failed due to ERROR: Cannot detect file format

Please help in resolving the error that I am getting while importing the OSM database to postgresql using Osm2pgsql for windows. Command and log is as shown below C:\osm2pgsql-bin>osm2pgsql osm.pbf -s -c -d suhas -U suhas -W Oracle@123 -H localhost…
SUHAS REKHU
  • 3,363
  • 2
  • 10
  • 13
2
votes
1 answer

Filtering openstreetmap data for postgis

I am creating a postgis database and want to use filtered OpenStreetMap data. For this i have tried the following process: Downloaded the planet.osm.bz2 file from https://planet.osm.org/ Unpacked to *.osm using bzip2 Filtered the file using…
Bramot
  • 21
  • 1
2
votes
2 answers

Where is latest build of osm2pgsql for Windows 64-bit

I am using some earlier build for Windows 64-bit downloaded form here: dl.dropboxusercontent.com/u/63393258/osm2pgsql_testRelease.zip from this website: awcull.com/2015/09/30/postgis-osm2pgsql-windows.html but it is crashing when I am importing…
user6787244
2
votes
2 answers

Exporting planet.osm.pbf into PostgreSql

could someone help with this? I found only this: http://wiki.openstreetmap.org/wiki/Osm2pgsql and this: http://learnosm.org/en/osm-data/osm2pgsql/ but windows binary was removed, and I never use cygwin or linux bash. Actually I've installed…
Denis Stephanov
  • 4,563
  • 24
  • 78
  • 174
2
votes
0 answers

64 bit version of Osm2pgsql for windows

Does anyone know the location of a 64 bit version of "Osm2pgsql.exe" for windows? I can only find a 32 bit version.
Dave
  • 35
  • 4
1
vote
1 answer

Lua config throwing error in metamethods?

getting the following error when attempting to load data into pgsql database with osm2pgsql: ERROR: Failed to execute Lua function 'osm2pgsql.process_node': test.lua:183: unknown field 'as_point' stack traceback: [C]: in function 'error' …
evan
  • 169
  • 3
  • 12
1
vote
0 answers

libboost_filesystem.so.1.71.0: cannot open shared object file: No such file or directory

Following the indications found here: https://switch2osm.org/serving-tiles/manually-building-a-tile-server-ubuntu-22-04-lts/ I'm trying to install Tile Server in Ubuntu 22.04 but I'm getting this error: raphy@pc:~$ sudo -u _renderd osm2pgsql -d gis…
Raphael10
  • 2,508
  • 7
  • 22
  • 50
1
vote
2 answers

Import only point features with osm2pgsql using style file

I am very new osm2pqsgl. I have downloaded a osm.pbf file for all of Europe and I want to add this data to my Postgres database. However, I am only interested in points, no linestrings nor polygon, and within the points I am only interested in these…
four-eyes
  • 10,740
  • 29
  • 111
  • 220
1
vote
2 answers

Query all primary roads from PostGis Database filled with OSM Data within a boundary

I imported OpenStreetMap data through osm2pgsql into PgSQL (PostGIS) and I would like to get an SF object from the data containing all primary roads (geometry) within a an area (bbox) into R. I got lost since I would like to have also relations and…
Andreas
  • 397
  • 4
  • 18
  • 37
1
vote
1 answer

osm2pgsql (v. 1.4.0) "Unknown option -- t" (Usage error)

I'm trying to import the OSM sample data from Mastering PostGIS, Chapter 1. I'm on Windows and am using this x64 binary (v1.4.0) I found here. The call is as in the book osm2pgsql -H localhost -P 5432 -U postgres -W -d mastering_postgis -S…
grg
  • 99
  • 6
1
vote
0 answers

How can use the hstore extension type when migrating OSM data to PostGreSQL?

I am trying to migrate some Open Street Maps .osm.pbf file to my postgresql database using osm2pgsql on an ubuntu machine. When I inspect the data after the process has been finished, the column for tags is types as text[] and filled with data like…
aviya.developer
  • 3,343
  • 2
  • 15
  • 41
1
vote
1 answer

Why are there tag keys missing when downloading OSM data to Postgis / Postgresql?

I'm working on a routing application using OSM data in pgrouting. I'm using overpass-api to access the data from a specific bounding box. However, after downloading the data, there seem to be tag_keys missing from the data. When inspecting the data…
ninodm
  • 13
  • 3
1
vote
1 answer

Query attributes with colon : inbetween with ogr2ogr and PostGIS

I'm running a PostGIS Database filled by osm2pgsql. The address-keys are stored for example as "addr:street" The objective is to store those geometries as GeoPackage by ogr2ogr. The script looks like this ogr2ogr -f "GPKG" address_point.gpkg…
Michael
  • 219
  • 2
  • 10
1
2 3