Malcolm Meyer

github.com/Leaflet/Leaf...

Interesting results from benchmarking #duckdb on large spatial queries - www.malcolmmeyer.com/posts/benchm... tl;dr - use "WHERE ST_Intersects(g, geom) IS TRUE" IS TRUE being key there - with a bbox filter to get faster results #gis #geospatial #cloudnative #parquet #osm #openstreetmap #overture

Why, why does #claude create markdown files I can't edit 🤔🤦 #aifail #ai #llm

#freebuff is looking like a very attractive alternative to co-pilot or one-off subscriptions for personal side projects freebuff.com

Rediscovered while excavating my archives. Three vignettes show a bit of how I think about geometric relationships in #map labeling. (In case the embedded video gets compressed beyond recognition, it's also on YouTube: www.youtube.com/watch?v=GQws...)

One cool feature of my camera map is the on-the-fly spatial search with #duckdb and #parquet sourced from from us census urban areas #gis #geospatial #webdev - no need for pre-processing all the data xycameras.com#12/39.93001/...

Added a small bookmark tool with auto-naming and collapsible legend. So many cameras, so little time! xycameras.com#11.75/39.930...

the data on here is so crazy - we have a long way to go - data360.worldbank.org/en/atlas/ -

generative art #trees #fractals

Heard the one about how dozens of researchers assigned $144,000 worth of real world human tasks to the world’s “smartest” AIs to manage and… They fucked up so monumentally that they were able to generate $1700 between them arxiv.org/pdf/2510.26787

Retro css theme on perplexity AI rn 😂😂

studyfinds.org/chatgpts-hal...

Careful what you chat about folks... arstechnica.com/tech-policy/...

lots of images coming in from Vantor and Capella for the #melissa #hurricane #disaster #disasterreposnse www.mappingdisasters.com#6.05/20.662/...

It's like I'll have to rework the back end infrastructure for mapping disasters... Maybe a good excuse to test out #duckdb

Is it possible to have high quality printed maps from mapbox/maplibre...of course it is! If you want to get inspired for your next open source project, come check out my talk on Wednesday at #FOSS4GNA on one city's ongoing transition to an open source GIS solution. #postgresql #webmaps #foss4g

Before and after: Some of the devastation in Black River, Jamaica after Hurricane Melissa (📷: Vantor) #Melissa #Jamaica

It's almost time for #foss4gna and I have yet to promote my talk. Need inspiration for that next conversation from proprietary to open source GIS, come check me out on Wednesday! #postgres #mapbox #maplibre #docker

#duckdb and #deckgl have come a long way, amazing what can be done directly in the browser @developmentseed.org developmentseed.org/spatial-acce...

this is how easily facts can be spun - using the term "deeply divided" when the percentages are 60/40 is a complete joke - "Americans are deeply divided on Donald Trump. A recent Reuters/Ipsos poll found that only 40% approved of his performance as president, while 58% disapproved." from the #bbc

Ever since X became a dumpster fire and moving to bsky I still have not found that awesome feed that once scrolled across my phone in the prime days of twitter, beautiful maps and trending news...maybe I'm just not following the right people or social media or people's use of it has just changed 🤷

A lovely ocean tides map using the Spilhaus projection for some Wednesday mappy goodness #MapoftheWeek mapoftheweek.substack.com/p/a-world-of...

#trains #transport #datavis #datascience chronotrains.com - great tool for estimating travel distance vs travel times created by Benjamin Tran Dinh tip by @forrest.nyc

If you use #LinkedIn, you may want to access your settings here and opt out of having your data used to train their AI. This opt-in by default is ILLEGAL in the EU, but, you know, potatoes This is the direct link to opt out www.linkedin.com/mypreference...

cool - nice to see domain verification via handles @bsky.app

#ocean #coast #scarolina #minimal

www.pbs.org/newshour/nat...

People on here seem to like mushrooms 🍄 so, here's a mushroom

added speedtest tracker to my self-hosted server setup and now I see what you pay for 300 Mbps vs what your get 140 Mbps #monopoly #Internet #digitaldivide

testing out yet another online notes editor [I've used Paper, Asana, Slack documents, DIY self-hosted, notepad, apple notes...] and actually loving it so far - I wish images were part of the free plan but still great interface and markdown editor - #journaling #notes #todo #webdev notesnook.com

Dammam, الدمام Saudi Arabia sentinel-spy.netlify.app?lat=26.62501... #beautifulearth #remotesensing

what's possible on a $5 4 core VPS? A lot actually: full-text search with #sqlite and fts5, lightning fast vector tiles with mbtiles, and decent performance with vector tiles generated on-the-fly via #flatgeobuf #geopackage easily increased with double the cores #gis #gischat www.getbounds.dev

Since I'm an adult I no longer watch afternoon cartoons (remember those) and watch stuff like this instead #gis #webmaps youtu.be/uTIK3x-1-6M?...

Cloud-native Geo may be the hot new thing but turns out a simple SQLite database with an r-tree spatial index (GPKG) works just fine even for 6 million features, on a cheap 4 core server. Plus it gives you search-as-you-type via fts5. #gis #gischat #webmaps #cng

Flatgeobuf on-demand vector tiling performance on a $5 4-core server *almost* good enough. The FGB process uses http range requests with minimal latency as the data host is the web server not a cloud bucket. More/faster server cores (my m2 Mac) make it much more viable. #gis #gischat #webmaps #cng

Testing out SQLite FTS5 multi-field full-text search with a 6 million feature dataset on a $5 server for a web map experiment...and the performance is insane! 🤯 Part of larger personal project serving out statewide parcel data on a high permanent web map. #sqlite #gis #gischat

why am I seeing so many bunnies in my thread? 🐰 🤷

This: “The choice isn’t simply between open and closed borders, asylum and amnesty or disappearances and deportations. This picture of migration is one in which all nations, rich and poor, participate in a great network of human movement, linked by cultural, economic, historical and family ties…”

Mapped: net domestic migration per 1000 residents by county from the 2024 U.S. Census Bureau Population Estimates Lots to explore in here; a few things that stand out:

#distractions #fridaynightlights #gis #gicshat #deckgl #maplibre