I finished wiring up the backend data merge so user(s) (aka me, really) can record trees as they walk and have those merged into the general city data on my urban tree map app[1]. There's some very cool trees in the neighborhood I'm excited to have recorded.
Which leads me to trying to get the processing off github actions (it's all duckdb pipelines), which has led me to improve the orchestration implementation of my 'better sql' [2] to optimize the asset based refresh flow. I'm now wiring that up in a general cloud service to give me the data orchestration platform I've always wanted. Building a multi-tenant cloud experience has been interesting!
[1]: https://greenmtnboy.github.io/sf_tree_reporting [2]: https://github.com/trilogy-data/pytrilogy
How city authorities have such poor records of trees they purchase and plant is a mystery to me.
Because so much of the population would say "why should we keep track of that?" when it's brought up alongside something like recycling and tree/shade cover.