Stack Overflow
Stack Overflow

Questions tagged [osm2pgsql]

44 questions
1
vote
1 answer

Query not exposed attributes from PostGIS

I loaded an osm-file into PostGIS by using osm2pgsql. Now, I would like to query features with specific attributes. For example: "highway is not null" with "maxspeed is not null". PGadmin returns: "ERROR: column "maxspeed" does not exist" From…
Michael
  • 219
  • 2
  • 10
1
vote
0 answers

How to query way data from osm2pgsql?

using the way OSM ID, I want to get the lat, lon array for this way from osm2pgsql using the psql command ? Can someone please help me ? Thanks.
madan kandula
  • 460
  • 5
  • 22
1
vote
1 answer

Impossible to merge osm.pbf file properly

I've recently started to work on a project with SRTM datas and I've extracted pbf file using phyghtmap. To start I'm getting hgt files, converting them to tif using the following command : gdal_fillnodata.py data.hgt data.tif Then I'm warping them…
Lucas Miller
  • 123
  • 1
  • 6
1
vote
1 answer

missing data for column xxx

I've downloaded multiple metro extracts from openstreetmap as PBF files when i try to import them with osm2pgsql it works for the first and creates the tables. I then want to add a column in the planet_osm_ways with a cityID to know which "way id"…
PJ1992
  • 13
  • 2
1
vote
0 answers

OSM: Import ways without tag using osm2pgsql

I have a very special problem when importing OSM Data with osm2pgsql. I was searching for days on how to import ways which do not have any tag but which are part of a relation (which itself has tags) into PostgresDB. Take the following way for…
Martin Friedrich Bauer
  • 73
  • 1
  • 5
1
vote
1 answer

Incomplete road labels on tiles' edges rendered my python-mapnik

We imported Europe data file to Postgres database with psm2pgsql and rendered tiles with generate_tiles_multiprocess.py which comes from python-mapnik tools and road labels look quite strange as per attached screenshot. Why do these labels look…
user6787244
1
vote
1 answer

Error importing map with osm2pgsql

I've been following this guide to setting up my own osm node. https://switch2osm.org/serving-tiles/manually-building-a-tile-server-14-04/ I've gone trough all the compiles and configurations with no complications (twice) but in both runs I ended up…
Dormage
  • 45
  • 1
  • 7
1
vote
0 answers

ST_Contains(ST_MakeEnvelope) returns nothing while ST_Intersects(ST_MakeEnvelope) returns too many results

I have downloaded a dump of OSM data from http://geofrabrik.de as a .pbf file. I have used osm2pgsql to import this data into my postgis-enabled postgres database. I am trying to get the geometries that are contained within a bounding box that I…
user4726090
  • 27
  • 3
  • 9
0
votes
1 answer

osm2pgsql error: Cannot detect file format for 'postgres'. Try using -r

I am trying to import pbf file into postgis database using osm2pgsql. I can connect to database, but when i try to import the file: C:\osm2pgsql>osm2pgsql -s -a -d micronesia --flat-nodes C:\osm2pgsql\srbac.osm.pbf -U postgres -W postgres…
Sasa Stojkovic
  • 1
  • 1
0
votes
1 answer

osm2pgsql is taking forever to process with lua config

My osm2pgsql script is taking forever to load data into my database and I don't know why. The reference lua scripts which perform similar computations take 1/10th the same amount of time. I know my personal computer won't blaze through the data but…
evan
  • 169
  • 3
  • 12
0
votes
1 answer

Lua config file osm2pgsql issues with tagging nodes as part of relations and calculating length on demand

I am having trouble with the lua config file to add certain values to specific rows by ID on import. I want to add relation info to nodes like is possible with ways, and I want to only compute length via way:transform(srid):length() for ways that…
evan
  • 169
  • 3
  • 12
0
votes
0 answers

Osm2pgsql failed due to ERROR: Error loading lua config: ...l/share/lua/5.2/osml10n/get_localized_name_from_tags.lua:1: module 'unaccent' not found

i am using this project from github :( https://github.com/giggls/osml10n/blob/master ) i have completed all the installation steps but when i run this command (:osm2pgsql -G -O flex -d osm -S openstreetmap-carto-hstore-only-l10n.lua…
Syed Toqeer Ali Shah
  • 1
  • 1
0
votes
1 answer

Postgis Plugin: authentication method 10 not supported Connection with kosmtik

I'm working on a project with the kosmtik tool together with osm2pgsql to be able to generate data for OPENS STREET MAP directly from my postgres database, and I'm having this connection problem when I make requests to the database, they are being…
VINICIUS SILVA FARIAS
  • 1
0
votes
1 answer

pgrouting routing methods don't deliver shortest path

At first I'm pretty new to routing in general and need to use it for my bachelor thesis so I am pretty time limited to learn it. If there is anymore Information I can give to find the Problem or if you just have a idea please inform me. Thanks! I…
Sören Mehlhop
  • 11
  • 2
0
votes
0 answers

Nominatim - pgsql returned with error code (3)

When I try to install new osm file in my nominatim server. With the setup.php (10666 = 2/3 of 16G RAM) : cd /srv/nominatim/build/ && ./utils/setup.php --osm-file /srv/nominatim/Nominatim-3.4.1/data/france-latest.osm --all --osm2pgsql-cache 10666 I…
fabrice
  • 1,399
  • 1
  • 15
  • 27
1
2
3