home.social

#pgosm β€” Public Fediverse posts

Live and recent posts from across the Fediverse tagged #pgosm, aggregated by home.social.

  1. I explored the data quality of the generated edge network in the legacy version vs the latest version... Woah!! 🀩 It's so much better now!

    This post has my initial findings. I'm going to spend some time this week digging in further in Colorado where I actually know the roads!

    #gischat #postgis #pgrouting #pgosm #routing

    blog.rustprooflabs.com/2025/12

  2. I explored the data quality of the generated edge network in the legacy version vs the latest version... Woah!! 🀩 It's so much better now!

    This post has my initial findings. I'm going to spend some time this week digging in further in Colorado where I actually know the roads!

    #gischat #postgis #pgrouting #pgosm #routing

    blog.rustprooflabs.com/2025/12

  3. I explored the data quality of the generated edge network in the legacy version vs the latest version... Woah!! 🀩 It's so much better now!

    This post has my initial findings. I'm going to spend some time this week digging in further in Colorado where I actually know the roads!

    #gischat #postgis #pgrouting #pgosm #routing

    blog.rustprooflabs.com/2025/12

  4. I explored the data quality of the generated edge network in the legacy version vs the latest version... Woah!! 🀩 It's so much better now!

    This post has my initial findings. I'm going to spend some time this week digging in further in Colorado where I actually know the roads!

    #gischat #postgis #pgrouting #pgosm #routing

    blog.rustprooflabs.com/2025/12

  5. I explored the data quality of the generated edge network in the legacy version vs the latest version... Woah!! 🀩 It's so much better now!

    This post has my initial findings. I'm going to spend some time this week digging in further in Colorado where I actually know the roads!

    #gischat #postgis #pgrouting #pgosm #routing

    blog.rustprooflabs.com/2025/12

  6. The latest PgOSM Flex image now has osm2pgsql 2.0.0. Here's the quick start if you haven't tried PgOSM Flex yet!

    pgosm-flex.com/quick-start.htm

    #pgosm #postgis #openstreetmap #gischat

  7. Initial version of Windows instructions for PgOSM Flex are live! Hopefully this helps some folks out there.

    pgosm-flex.com/windows.html

    #pgosm #gischat #postgis #docker #windows

  8. I hadn't tried Docker Desktop on Windows before today. Gotta say... pretty good experience πŸ€“

    Julie is working on new training materials for PgOSM Flex and she wanted to run it on her Windows laptop... so we'll have a section to help Windows users in the user guide soon!! πŸŽ‰

    #pgosm #docker #postgis

  9. 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

  10. pgBouncer is being added to PgOSM Flex! This should help the connection load with --append workloads

    It is a WIP but I *think* it is functional! Testing and feedback welcome.

    This finally became possible b/c pgBouncer added support for prepared statements πŸ€“

    #pgosm #postgis #openstreetmap #gischat

    github.com/rustprooflabs/pgosm

  11. PgOSM Flex 0.9.0 is out! πŸŽ‰

    Please read the release notes, there are ⚠️ breaking changes ⚠️ to be aware of!

    This release continues using more of the newer features available in osm2pgsql

    github.com/rustprooflabs/pgosm

    #pgosm #postgis #openstreetmap #gischat

  12. PgOSM Flex 0.8.1 is out! πŸ€“

    Okay, the big news should be that it now attempts to prevent you from hosing your own database...

    However, I think the continuous improvements to the docs are more important! Now providing more guidance to decide which method to use to keep your DB updated πŸ‘

    pgosm-flex.com/data-updates.ht

    #pgosm #postgis #postgres #openstreetmap

  13. Hey PgOSM Flex Users! Can you help test / code review in the next couple of weeks? I'll be updating the PR I just started. Moving DB deploy away from Sqitch...

    Yes... this will fix a bug I recently introduced...

    More importantly -- this continues the move toward being more flexible! This change has been brewing for a while πŸ€“

    github.com/rustprooflabs/pgosm

    #pgosm #openstreetmap #postgis

  14. PgOSM Flex 0.8.0 will be out before too long. I'm pretty excited about it!

    #pgosm is the easiest way to load high quality #OpenStreetMap data to #postgis... it is:

    * Reliable
    * Easy to try out
    * Easy to load/update to prod
    * Low friction software updates

    #gischat #postgres #postgresql

    blog.rustprooflabs.com/2023/04

  15. Do you use PgOSM Flex without using the Docker image? Not just "Postgres outside docker" but completely no Docker. I want to hear from you!

    ⚠️⚠️⚠️

    Considering a breaking change

    github.com/rustprooflabs/pgosm

    #pgosm #postgis #openstreetmap

  16. PgOSM Flex docs has a new look and a new home! πŸ€“πŸ“–

    pgosm-flex.com/

    This is a huge step forward from the bare collection of MD scripts. The 0.7.0 release made a thorough review necessary anyway.

    Now to see if I can avoid breaking GH Pages...

    #pgosm #postgis #openstreetmap #documentation

  17. Woot! osm2pgsql 1.8.0 is out! πŸŽ‰

    PgOSM Flex is already using the new index support! Before now we had to create indexes in post-processing SQL, which was harder to keep consistent.

    With index creation defined in the Lua styles, we should be able to provide granular control over index creation... πŸ€“

    #openstreetmap #postgis #pgosm

    osm2pgsql.org/news/2023/01/28/

  18. PgOSM Flex 0.6.3 is out!

    You can use SP-GIST indexes w/ --sp-index

    Also, the --apend option is moving to --replication. Setting the stage for some breaking changes coming in 0.7.0.

    github.com/rustprooflabs/pgosm

    #pgosm #postgis #openstreetmap #gischat

  19. PgOSM Flex has a new option!

    Use --sp-gist to create SP-GIST indexes instead of standard GIST.

    It's in the latest Docker image now, expect a tagged 0.6.3 release before long. πŸ€“

    #pgosm #postgis #openstreetmap #gischat

    github.com/rustprooflabs/pgosm

  20. PgOSM Flex 0.6.2 is out!

    This release includes a bug fix from a new contributor! πŸ™

    Fixed: --append with --input-file

    It won't be long until append mode is the recommended approach! πŸŽ‰ πŸ€“

    #gischat #postgis #openstreetmap #pgosm

    github.com/rustprooflabs/pgosm