sirdb
sf-tree-history
| sirdb | sf-tree-history | |
|---|---|---|
| 3 | 3 | |
| 568 | 40 | |
| 0.0% | - | |
| 0.0 | 8.5 | |
| 9 days ago | 2 days ago | |
| JavaScript | ||
| GNU Affero General Public License v3.0 | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sirdb
-
Show HN: DoltgreSQL – Version-Controlled Database, Like Git and PostgreSQL
Interesting. I've been investigating a DIY file-system based database in JSON that uses git to version it: https://github.com/dosyago/sirdb
-
London Street Trees
I love the idea of syncing git commit history with data change history, like using git for a repo of data. It's actually quite possible if you use pretty printed JSON as a record format (or other simple linear text formats).
I explored more of this "git as DB backend" in some places including: https://github.com/dosyago/sirdb
Also, just as a headsup to any folks, the SF version of this "tree map" (Heh) is at: https://web.archive.org/web/20230328192805/https://bsm.sfdpw... (O site seems to be down)
- Sirdb – Simple database using JSON on filesystem
sf-tree-history
-
Open Data Is Dead
I think this headline was poorly chosen.
When I see the term "Open Data" I instantly think of open data portals - mostly run by governments around the world. These things have never been healthier: ten years ago they hardly existed, today you can get civic data from local governments all over the place (last time I saw an attempt to count there were over 4,000 of these portals, and that was a few years ago).
My favourite example is still this CSV of all 190,000+ trees in San Francisco, which is updated most business days with details of the latest tree changes: https://data.sfgov.org/City-Infrastructure/Street-Tree-List/... - I track changes to it here: https://github.com/simonw/sf-tree-history/
This article is about something different: it's about what I guess you could call the "Open APIs" movement. Back in the days of Web 2.0 every service was launching an open API, hoping to harness developer attention to help make the platforms more sticky. Facebook and Twitter both did incredibly well out of this strategy, at least at first.
THOSE APIs are mostly on the way out now. Companies realized that giving away their data for free has a lot of disadvantages.
Open Data is doing great. Open APIs are not.
-
London Street Trees
I've been Git scraping the San Francisco version of this for a few years now.
My https://github.com/simonw/sf-tree-history repo now has 444 commits (most recent one was just 4 days ago) tracking every change that's been made to https://data.sfgov.org/City-Infrastructure/Street-Tree-List/... since March 2019.
I haven't yet done anything with this data, but there is so much potential for visualizations and other fun stuff with it. If anyone wants to have a go please be my guest!
Wrote more about this project here: https://simonwillison.net/2019/Mar/13/tree-history/
-
Looking for a dataset that is updated once a day ( not : stocks,crypto,weather)
Trees in San Francisco: https://github.com/simonw/sf-tree-history
What are some alternatives?
dolt - Dolt – Git for Data
data.gov - Main repository for the data.gov service
urban-tree - detect urban trees with the help of aerial images
scrape-hacker-news-by-domain - Scrape HN to track links from specific domains
scrape-soe-wwd - Scraping SARS-CoV-2 Measurements in Wastewater
cdc-vaccination-history - A git scraper recording the CDC's Covid Data Tracker numbers on number of vaccinations per state.
norcal.pub - The Norcal Pub is a public domain newspaper serving the people of the San Francisco Bay Area.
mcbroken-archive - :inbox_tray: Archive for data from mcbroken.com.
leafdb.org - A public domain database about trees.
scrape-instances-social - https://instances.social/instances.json
scrape-la-fires
public-apis - A collective list of free APIs