https://app.honeycombmaps.com/shared/UoeChOqwxXf3fI2PxKXRBmh_RHW-3UVa
This map shows population of each US county over time, from the US census. It also shows the US rail network over time, with data from Jeremy Atack at Vanderbilt. I think it's interesting to see the interdependence between them. And the fact that the US rail network was substantially complete by 1900.
I recently moved to San Francisco & am fascinated by the microclimates. This tool takes raw data from the GOES satellite, detects areas matching fog, then intersects this with different Bay Area neighborhoods & cities. Delivered via a basic web app, optimized for mobile. Data updates every 5m.
Started seeing issues when trying to update issues through the GitHub web interface. It appears that the service behind their graphQL endpoint (https://github.com/_graphql) is broken. In addition, their support ticket interface at https://support.github.com/ is not working, returning various 500 status codes.
https://honeycombmaps.com/tools/shapefile-to-csv-converter
There are many times I find some government data in shapefile (.shp) format but want to use the attributes inside for analysis in tabular format. It's always a pain to open this in QGIS, convert the CRS correctly, then save as CSV. So I built a tool that will handle this for you, all running within the browser so data doesn't need to be sent anywhere. Under the hood it's using DuckDB built for...
When using EPSG:4326 lat/lons, I don't think GeoParquet would give you any benefits over just having separate columns (this is what I typically do, and it's plenty fast).
If you are using range requests to fetch only parts of parquet files at a time, you could potentially sort your data using a hilbert curve, which could limit the number of row groups that need to be fetched to execute a query.
The big idea is to use Uber's H3 spatial index to harmonize spatial data from different sources, then display it on a map and allow for interactive aggregation. Everything is done in the browser on-the-fly. Behind the scenes is DuckDB, Turf.js, and Deck.gl. Very impressed with the DuckDB performance.