close SQLite db #hoodmaps at end of script to try reduce “database is locked” errors

try to fix twitter card image for social media preview but it won’t accept og:image for redirects somehow #hoodmaps

see #hoodmaps grow after fixing performance issues by making it completely static on Cloudflare

set some new SQLite config optimizations form phiresky.github.io/blog/2020/… to fix incidental error #hoodmaps

fix Berlin too small map boundaries limit max #hoodmaps

fix og:image by rerunning Twitter’s card validator #hoodmaps

fix blank colors #hoodmaps for some big cities like NYC, London, cause worker was failing cuz too much data but now with new runner it works

merge #hoodmaps workers into one runner script so it stops failing in the middle

also disconnect tag adding by client to directly go into db, and instead put it in the /../data/hoodmaps.db.queue.txt which gets inserted hourly by a worker instead to fix db issues #hoodmaps

hard run averageCoordinates, colorGeoJSONWithNormalizedNeighborhoods and generateCacheForAllCityPages and then clear CF cache #hoodmaps

fix if GPS is enabled on #hoodmaps it will keep zooming in when location changes (eg you’re in a car)

make averageCoordinatesRunner.php script that runs averageCoordinates.php for every city because it ran out of memory as a foreach script with all cities #hoodmaps

fix mostCommonCategory null for some neighborhoods on #hoodmaps because averageCoordinates script was modified improperly, revert back to 2020 version

spend more hours to fix #hoodmaps screenshot cache once and for all

change hoodmaps grey to black to be consistent with other sites #hoodmaps

fix #hoodmaps 404s getting cached by CF cause no cache headers present, so add 404.php with cat.gif

make #hoodmaps screenshots work with API Flash after much debugging

switch #hoodmaps to APIflash screenshot service too

fix #hoodmaps GeoJSON for Lisbon went too much out into the sea which meant GeoJSON clusters were not summarized correctly because the invalid sea data was included (via @PascalPixel)

rename Hipster to Hip #hoodmaps because hipster is a bit outdated word in 2022