Live data from Hacker News

London Street Trees

apps.london.gov.uk

41–50 of 74 posts

Re: London Street Trees

#42
post #5

This is an unusually nice website, but if you like this, check your own city, they might have one too! For example, here's: DC: https://trees.dc.gov/apps/3677bceead544db79a412e3ab0a68588/e... Boston: https://boston.maps.arcgis.com/apps/webappviewer/index.html?... LA: https://losangelesca.treekeepersoftware.com/index.cfm

Melbourne (Australia): http://melbourneurbanforestvisual.com.au/ (Can email any tree)

Re: London Street Trees

#44
post #38

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 st…

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 and archive seems to be down)

Re: London Street Trees

#45
post #38

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 st…

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:/…

Yeah I have a bunch of these using pretty-printed JSON - here's one that scrapes Hacker News for mentions of my site, for example: https://github.com/simonw/scrape-hacker-news-by-domain/blob/...

Re: London Street Trees

#46
post #45

Earlier quoted context omitted.

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:/…

Yeah I have a bunch of these using pretty-printed JSON - here's one that scrapes Hacker News for mentions of my site, for example: https://github.com/simonw/scrape-hacker-news-by-domain/blob/...

Wow you're the creator of datasette! Cool, man! I thought that was a really revolutionary idea, and also related to this notion of git backed DB...I'm so glad to sort of see it confirmed with this! Haha :)

Re: London Street Trees

#49
post #13

Earlier quoted context omitted.

London GDP is about £500 billion. They’ll need this info to maintain the trees in any case. If it cost 100k, it would be 0.02% of GDP. For the difference trees make to urban areas, it would be utterly trivial. If you made £50k cash after tax a year (so closer to 80k before tax), it would be £10 a year, that’s the fraction. Of course it costs far more than £100k to maintain this data.

I think most Londoners wouldn't want to pay £10/year for a tree database. Imagine a sign saying "Just donate £10 so we can have a database to tell us where our trees are", I bet the vast majority of Londoners wouldn't hand over £10. Even a keen gardener wouldn't likely pay £10 to have a map of where all the vegetables in their vegetable patch were.

Trees can be a hazard. Roots and branches need to be monitored, for tripping or falling risks, or the risk of the tree falling over. Trees need to be trimmed, especially where they intrude into problem space - cables (very rare in London), double decker buses, people's property, and so on.

The database needs to be built.

Re: London Street Trees

#50
post #13

Earlier quoted context omitted.

London GDP is about £500 billion. They’ll need this info to maintain the trees in any case. If it cost 100k, it would be 0.02% of GDP. For the difference trees make to urban areas, it would be utterly trivial. If you made £50k cash after tax a year (so closer to 80k before tax), it would be £10 a year, that’s the fraction. Of course it costs far more than £100k to maintain this data.

I think most Londoners wouldn't want to pay £10/year for a tree database. Imagine a sign saying "Just donate £10 so we can have a database to tell us where our trees are", I bet the vast majority of Londoners wouldn't hand over £10. Even a keen gardener wouldn't likely pay £10 to have a map of where all the vegetables in their vegetable patch were.

Trees can be a hazard. Roots and branches need to be monitored, for tripping or falling risks, or the risk of the tree falling over. Trees need to be trimmed, especially where they intrude into problem space - cables (very rare in London), double decker buses, people's property, and so on.

The database needs to be built.

Also as someone else pointed out I got my maths wrong (I blame no calculator on an ipad): it is about 1p from 50k a year. I calculated with 500 million not billion.

Post reply on HN