https://xitter.cf/t.co/NAjF3qTPvK geo data visualization engineer at @Foursquare. creator of https://xitter.cf/t.co/FnUcAhZpmp and https://xitter.cf/t.co/Tx1sLyx3G7. past @teralytics @ixt @unifr

Zurich, Switzerland
Joined February 2009
We just launched Foursquare Spatial Desktop – a geospatial analysis tool powered by embedded DuckDB and built on sqlrooms.org. Everything runs locally. A modern reimagining of Kepler.gl. Mac only for now. foursquare.com/products/spat…
3
294
Ilya Boyandin 🇺🇦 retweeted
Today, we're thrilled to launch SQLRooms — a modular React toolkit that enables developers to build powerful single-node data applications running entirely in browsers or on desktop, with zero backend infrastructure required. While modern analytics frameworks still depend on hub-and-spoke architectures with heavy server-side processing, recent breakthroughs in single-node computing have fundamentally changed what's possible. 💡 We asked ourselves: what if data applications were architected for single-node performance from day one? SQLRooms, architected by @ilyabo, is our answer. By integrating @duckdb as the core compute engine, embedding AI assistance through @ollama, and providing a comprehensive component library, SQLRooms empowers developers to create enterprise-grade applications that run directly where where users need them — in browsers and on laptops. Key highlights 👇 → DuckDB-WASM at the core: Lightning-fast columnar SQL processing in-browser. → Modular & developer-centric: Mix and match UI components, layouts, SQL engines, data tables, editors, and visualizations. → Interactive SQL + visual analytics: Built-in SQL editor with syntax highlighting, query history, and seamless visualization library integrations. → AI-native analytics: Integrated agents that write and execute SQL queries, generating insights locally – no server roundtrips required. We believe single-node computing will unlock a new category of applications, especially as data privacy concerns grow and the proliferation of powerful edge models makes local processing the new standard. ✨ SQLRooms is our contribution to making that future accessible today. Ready to explore browser-native analytics? Read the full launch blog post by our CTO, @vikramgundeti, below and check out the SQLRooms homepage in the thread to get started with building your first single-node data application 👇 medium.com/@foursquare/fours… #SQLRooms #DataApps
1
3
6
770
Ilya Boyandin 🇺🇦 retweeted
Interact with millions of data points in real-time with Mosaic, now with support for geospatial data. Exploring 1M taxi pickups and dropoffs in NYC:
6
39
5
339
30,431
Ilya Boyandin 🇺🇦 retweeted
Published version 0.1 of the JavaScript geoarrow/deck.gl-layers library! Now it's just one function call to render a GeoArrow table in deck.gl with amazing performance. Fully binary. 🚀 github.com/geoarrow/deck.gl-…
3
16
83
7,080
Ilya Boyandin 🇺🇦 retweeted
Bird migration in Europe tracked by GPS.
89
1,462
119
7,400
743,326
Ilya Boyandin 🇺🇦 retweeted
Adding a little serendipity into your A* path finding makes it 4x-9x faster at cost of accuracy. In some cases this might be an acceptable tradeoff.
5
36
4
319
33,679
Ilya Boyandin 🇺🇦 retweeted
All @OvertureMaps places - 60 million of them - displayed in @maplibre with a 3.7GB tile archive: bdon.github.io/overture-tile… instructions github.com/bdon/overture-til… 2 steps @duckdb parquet -> CSV @felt tippecanoe CSV -> pmtiles Thanks @Maxxen_ @opencholmes for the tips!
12
62
5
269
34,430
Ilya Boyandin 🇺🇦 retweeted
Exploring efficient, vectorized geospatial operations in the browser with GeoArrow and GeoRust compiled to WebAssembly. observablehq.com/@kylebarron…
4
41
1
181
16,850
Ilya Boyandin 🇺🇦 retweeted
Read in #TheTorch: - CPJ’s support to exiled journalists jumped 227% in 3 years - CPJ to release report on rising threats to press freedom in Ecuador - Georgian journalist Nika Gvaramia pardoned - Bangladeshi journalist Golam Rabbani Nadim beaten to death cpj.org/thetorch/2023/06/cpj…
1
6
2
9
6,489
Ilya Boyandin 🇺🇦 retweeted
With Flowmap.blue built by @ilyabo, anyone can create visually attractive and informative representations of data on geographic movements. Learn how it's built with Mapbox GL JS: buff.ly/3pl0beA #BuiltWithMapbox #datavisualization #gischat
1
7
18
5,086
Ilya Boyandin 🇺🇦 retweeted
With millions of data entries, cross-filtering is painfully laggy Not with our (me and @domoritz) new JavaScript library FalconVis! With FalconVis, you can cross-filter your visualizations at scale with no interaction delay! Try it out! dig.cmu.edu/falcon-vis/cross… 🧵👇
3
43
6
272
34,813
new logo! because... Protomaps is moving from being "open-core", or partly proprietary, to an open source project. The only closed part has been the basemap planet.pmtiles generation; an open source implementation is WIP here! github.com/protomaps/basemap… More updates soon!
2
30
150
19,215
Ilya Boyandin 🇺🇦 retweeted
Finally launching github.com/dabreegster/route…! Sketch routes in #mapbox and #maplibre using a file you load once, instead of asking an API to route constantly. I'd love ideas for improving this, to see how people use it, and to get help developing it! #rust #wasm #openstreetmap
5
22
2
127
14,475
Ilya Boyandin 🇺🇦 retweeted
#30DayMapChallenge A hydrological map of Kenya. Rivers in Kenya flow from the highlands East & West of the Rift valley. Eastern rivers flow to Indian Ocean, Western rivers to Lake Victoria and a few rivers flow into Rift valley lakes. Which river(s) flow in your home County?
27
96
5
252
Ilya Boyandin 🇺🇦 retweeted
My first ever #30DayMapChallenge submission 🤗! Had to hurry it out, but it felt good to just throw a quick map together! Thermal anomaly hotspots in Ukraine from February to July 2022 as sensed by MODIS. – at Arvada, CO
10
32
4
233
Ilya Boyandin 🇺🇦 retweeted
#30DayMapChallenge, Day 5 Ukraine In Ukraine many villages share the same name. Each frame of animation present villages with a particular name along with their geometric centroid. Keep in mind the last name shown in the animation: Peremoha - you will hear this word a lot soon.
37
3
260
Ilya Boyandin 🇺🇦 retweeted
For #30DayMapChallenge I thought I'd start with a dataset I enjoy playing with, SF Elevation Contours. I rendered it as points (day 1!) in @FSQStudio. The highest point in SF is annotated.
1
5
58