Profile avatar
pwramsey.bsky.social
Loving open source software, practicing the piano, moving things around, working @crunchydata.com More at https://blog.cleverelephant.ca
151 posts 568 followers 254 following
Regular Contributor
Active Commenter
Posts 24 Comments 26

We're proud to announce that #Finland just launched theit new Topographic Data System built on #QGIS https://positio-magazine.eu/2025/06/finland-launches-modern-topographic-data-system-built-on-open-source-qgis/ #osgeo #gischat #gis #OpenSource

submitted 1 day ago • 0 comments

i like @powen.net approach to getting people into his talk

submitted 7 days ago • 1 comment

Chatbots — LLMs — do not know facts and are not designed to be able to accurately answer factual questions. They are designed to find and mimic patterns of words, probabilistically. When they’re “right” it’s because correct things are often written down, so those patterns are frequent. That’s all.

submitted 8 days ago • 558 comments

submitted 16 days ago • 1 comment

Google and Meta search both report that Cape Breton Island has its own time zone 12 minutes ahead of mainland Nova Scotia time because they are both drawing that information from a Beaverton article I wrote in 2024

submitted 17 days ago • 111 comments

New blog. This time Getting tracks from #Garmin connect to #PostGIS. I present two options with code. www.acgeospatial.co.uk/getting-trac... Using #geopandas, #sqlalchemy

submitted 19 days ago • 0 comments

For the gazillionth time, he is not the "leader of the free world". He's not even the leader of a free country.

submitted 21 days ago • 20 comments

if you’re a data platform, you need a database. if you’re a database, you need a data platform. the drive towards consolidated general purpose database platforms continues.

submitted 24 days ago • 1 comment

This is pretty amazing. A new study with robust clinical trial data shows regular exercise can improve survival rates for colorectal cancer patients. Colorectal cancer will become the leading cause of cancer death among adults ages 20 to 49 by 2030.

submitted 25 days ago • 6 comments

The new GDAL 3.11 CLI has context-aware bash completion and spelling suggestions – options, formats, sub-commands, and more! No more fumbling for inconsistent names or orderings. Join us at the GDAL CLI Deep Dive webinar on June 3rd at 1400 UTC to learn more. numfocus-org.zoom.us/webinar/regi...

submitted 31 days ago • 0 comments

PostGIS tip: Get faster spatial queries and maps with st_simplfy. ⚡ When you don't need exact topology and want to make things faster and simpler, look at the ST_Simplify and ST_SimplifyPreserveTopology functions. Example in the video.

submitted 31 days ago • 0 comments

This seems like an interesting new scam. But I miss the Nigerian princes of old.

submitted 31 days ago • 1 comment

I feel like I've found a new controlling meme for open source contribution and innovation.

submitted 33 days ago • 0 comments

It is ridiculous how Happy listening to a political podcast, drinking a scotch, and cooking some sausage makes me. Such a simple creature I am.

submitted 37 days ago • 0 comments

Wait a minute? You’re saying that Joe Biden was secretly old during the 2024 election? And nobody said anything? Fishy.

submitted 38 days ago • 0 comments

My politics in a headline:

submitted 40 days ago • 26 comments

OK, it's official, I have submitted my talks to FOSS4G-NA, the bestest FOSS4G on the continent. My trip this week to pgconf.dev has gone very well, time to start getting the conferencing muscles fully toned up.

submitted 43 days ago • 0 comments

Presenting now at #PGConfdev is Marco Slot of Crunchy Data talking about “The Trouble with Extensions”, an exploration of the structural problems you’ll face if you want to build reliable, sustainable extensions

submitted 44 days ago • 0 comments

I want on this train too… is there a talk I should be doing? I am paralyzed by options and not knowing audience

submitted 46 days ago • 0 comments

It's the 21st century, we were promised flying air palaces, and instead we got 140 characters.

submitted 46 days ago • 0 comments

“At this point, 17 years after crypto arrived on the scene, there are still no — I repeat, no — significant legal use cases.” paulkrugman.substack.com/p/crypto-is-...

submitted 49 days ago • 1 comment

Utah approved these, there is nothing stopping us from doing the same www.theverge.com/news/661640/...

submitted 49 days ago • 1 comment

"In Venice, after a doge who attempted to make himself autocrat was beheaded for his offense, subsequent doges were followed in official processions by a sword-bearing symbolic executioner as a reminder of the punishment intended for any leader who attempted to assume dictatorial power." /1

submitted 52 days ago • 10 comments

Starting an important port to GEOS! Coverage cleaning has been a white whale feature for a long time, but here it comes. github.com/locationtech...

submitted 56 days ago • 1 comment