en.osm.town is one of the many independent Mastodon servers you can use to participate in the fediverse.
An independent, community of OpenStreetMap people on the Fediverse/Mastodon. Funding graciously provided by the OpenStreetMap Foundation.

Server stats:

258
active users

#osm2pgsql

0 posts0 participants0 posts today

Thanks to botsin.space/@planetpostgresql 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.

botsin.spacePlanet PostgreSQL (Unofficial) (@planetpostgresql@botsin.space)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

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
github.com/rustprooflabs/pgosm

GitHubTesting osm2pgsql PR #2134 for reducing conections by rustprooflabs · Pull Request #376 · rustprooflabs/pgosm-flexBy rustprooflabs

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!