Amᵃᵖanda | map data witch
Jakob Miksch#osm2pgsql version 2.2 released with a new "locator" feature and callbacks for deleted objects
#osm #openstreetmap #postgres #postgresql #postgis #gis #geodata
https://github.com/osm2pgsql-dev/osm2pgsql/releases/tag/2.2.0
#osm2pgsql's flex backend / themepark stuff is pretty cool TBH
#osm2pgsql code got some cleanup
#openstreetmap #osm #postgis #postgresql #cpp #gis
https://osm2pgsql.org/news/2025/08/21/zero-warnings.html
#openstreetmap #osm #postgis #postgresql #cpp #gis
https://osm2pgsql.org/news/2025/08/21/zero-warnings.html
Sven GeggusIn case someone is interested. Importing an #Openstreetmap planet file into #postgresql using #osm2pgsql in non-slim mode took me just under 5 hours here and requires a machine with at least 128GB RAM.
#osm2pgsql FAQ:
If you don’t need your database to be updateable and you have enough RAM, use non-slim mode.
Unfortunately it does not tell what "enough" roughly means means.
If you don’t need your database to be updateable and you have enough RAM, use non-slim mode.
Unfortunately it does not tell what "enough" roughly means means.
@isotopp @masek Dealing with #Openstreetmap data I usually have a lot of utf-8 crap *inside* #postgresql string columns. LTR and RTL just came to my mind. #osm2pgsql will likely also support utf-8 in table names and indexes %-/
Marcos DioneThanks to https://botsin.space/@planetpostgresql/113510452678670732 I got importing Europe on my puny rig from some 43h to 14h! I didn't quite used the same numbers because I only have 32GiB and it's also my desktop, and I'm also pretty sure I can reduce some numbers given that I don't import the whole planet.
Planet PostgreSQL (Unofficial) (@[email protected])
Greg Smith: Loading the World! OpenStreetMap Import In Under 4 Hours https://www.crunchydata.com/blog/loading-the-world-openstreetmap-import-in-under-4-hours #postgres #postgresql
After I upgraded the #postgresql backend to the latest and greatest version of #osm2pgsql and replaced #hstore by #json (jsonb) at the @geofabrik #Openstreetmap hack-weekend the https://opencampingmap.org Website is now up and running again.
Oh wow!, #osm2pgsql, the powerhorse of #OpenStreetMap data processing, has reached a milestone, and released version 2!
🌐 https://github.com/osm2pgsql-dev/osm2pgsql/releases/tag/2.0.0
