#til

* 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 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!

the new lua flex backend for #osm2pgsql means I can put PRINT STATEMENTS in my `osm2pgsql` import, and get debug output.

Je sais pas pourquoi j'avais jamais essayé avant de fouiller directement dans les données OSM.

Donc j'avais un peu de temps aujourd'hui, j'ai testé osm2pgsql, et c'est pas si compliqué que ça.
On peux remplir une BDD postgis avec les données qui nous intéressent, et ensuite les requêter directement, j'adore !

#osm2pgsql #openstreetmap #postgis

Tomorrow, I will be presenting at the #ILGISA Chicago Regional Meeting!

My goal is to completely overwhelm a bunch of public sector :arcgis: customers with FOSS stuff. I asked for an hour, but we'll see if I can fit it into the 30 minutes they gave me...

I will be talking about how to use things like #osmium, #osm2pgsql, #imposm, #postgis :postgis: , #qgis :qgis: , and #OpenStreetMap together to make really nice things.

`Backlog remaining: 1160 days, 4:13:03.391234`

Nice of `osm2pgsql` to give me microsecond precision.

#osm2pgsql

New blog post about some of the work that went into the @restobot back end using #osm2pgsql. I learned a lot doing this! https://mvexel.prose.sh/20230227-keeping-osm-database-uptodate-osm2pgsql

#OpenStreetMap #gis #opensource #data

Learned about pg_virtualenv
It starts a throw-away #postgresql environment and is therefore ideal for testing depending software like #osm2pgsql 
pg_virtualenv is available in the packages of many Linux distros like Debian or Ubuntu

Learned about pg_virtualenv
It starts at throw-away #postgresql environment and is therefore ideal for testing depending software like #osm2pgsql

pg_virtualenv is available in the standard packages of many Linux distros like Debian or Ubuntu

I learned a lot about #osm2pgsql and its amazing capability to customize how data is loaded into #PostGIS over the weekend.
With some preprocessing using #osmium, I can now load highways for the entire US with only the tags I want in less than 5 minutes.

Continuing analysis, here's another ways-by-age view

For automating #osm2pgsql I created a #Python script that can be called from #commandline.

See it in my updated post:

#openstreetmap #gischat #postgresql #postgis
https://jakobmiksch.eu/post/osm2pgsql-replication-script/

#osm2pgsql has a new release 🥳

The main change is the ability to define custom database indexes during import.

https://github.com/openstreetmap/osm2pgsql/releases/tag/1.8.0

#OpenStreetMap imports are a lot faster now - which is good news for everyone who regularly imports the #OSM data.

#osm2pgsql runs faster because of improvements in #PostgreSQL 15.

https://osm2pgsql.org/news/2023/01/22/faster-with-postgresql15.html