Thanks 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.
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
Woo! osm2pgsql 2.0.0 is out!
https://github.com/osm2pgsql-dev/osm2pgsql/releases/tag/2.0.0
#osm2pgsql - the power tool to import #osm data into #postgis - released version 2.0.0
Breaking change: #Lua configuration becomes default and classic #pgsql output is deprecated
#openstreetmap #postgres #postgresql #sql
Awesome. The backbone of #OpenStreetMap data processing, `osm2pgsql` has a new, cool logo. Created by AI!
(Because, oh dear god we shouldn't let #AI anywhere need the code section)
<https://osm2pgsql.org/news/2024/04/01/osm2pgsql-goes-ai.html>
#osm #logo #osm2pgsql
Gar nicht mal so unaufwendig bezüglich compute-power ein wenig Statistik der Entwicklung bestimmter Daten[1] in der #openstreetmap Datenbank zu machen. Von der Technik her aber eigentlich relativ einfach Dank #osmium und #osm2pgsql.
[1] Um welche Daten es bei mir geht könnt ihr euch bestimmt denken.
Huge shout out to the osm2pgsql devs! Connection volume to Postgres had gotten a bit awkward with the Flex styles when they're used the way PgOSM Flex does. Replication with the default layerset previously used 207 connections!
The same step only uses 17 now!! (:latest on Docker Hub updated)
Details and before/after charts are in the comments of the PR for the curious
#postgis #osm2pgsql #postgres #postgresql #gischat #pgosm
https://github.com/rustprooflabs/pgosm-flex/pull/376
post about #nominatim 5 the #openstreetmap #geocoding framework
tldr: it replaces #PHP with #python and calls #osm2pgsql externally
Wie viel #RAM braucht man denn so für einen #osm2pgsql import ohne slim modus? #Openstreetmap
I went to an #osm2pgsql talk at #sotmeu and now I need to upgrade all the servers
The making of map5topo map.
Always a puzzle: multilayer bridges. Think ok now thanks to osm2pgsql and BGT z_order and Mapnik!
https://map5topo.nl
#osm2pgsql #openstreetmap
osm2pgsql moved to it's own GitHub organization, no longer using the OpenStreetMap org
#osm2pgsql #OSM #OpenStreetMap #GitHub #PostGIS #PostgreSQL
https://osm2pgsql.org/news/2023/09/20/new-github-organisation.html
Explore #Themepark, the solution for simplifying #osm2pgsql config creation. Effortlessly construct custom maps, mix and match with ease. Currently in BETA – get the details at https://osm2pgsql.org/themepark/
#GIS #postgres #postgis #openstreetmap #gischat
* updating #osm #OpenStreetMap rendering databases is a breeze thanks to an automatic script from #osm2pgsql that just needs a URL or the initial import data file and it just goes by itself.
* POST and PUT are definitely not the same HTTP verb :-P #mindtypo
Look out #ILGISA, I did it again. I submitted 4 things to present. And ILGISA just keeps saying yes! One of us will learn at some point.
For you IL #GIS folks, if you are interested in
- Using #Survey123 for restaurant inspections
-Using the #OSMUS Tasking Manager to oversee #OpenStreetMap editing campaigns
-Creating local extracts of OSM data with #osm2pgsql
-Using Amazon #S3 for a "serverless" basemap tile option
Then you should come to ILGISA this year!