The average city is swimming in data these days. Many expose it through various APIs. The Socrata platform (disclaimer: I work there) is one example of many. F

The average city is swimming in data these days. Many expose it through various APIs. The Socrata platform (disclaimer: I work there) is one example of many. For instance, here's Edmonton's tree dataset: https://data.edmonton.ca/Environmental-Services/Trees/eecg-fc54 https://data.edmonton.ca/Environmental-Services/Trees/eecg-f... API docs are here (there's an API button on the top right of the first linked page that takes you here): https://dev.socrata.com/foundry/data.edmonton.ca/eecg-fc54 https://dev.socrata.com/foundry/data.edmonton.ca/eecg-fc54 Example query - 10 most recently-planted trees bearing edible fruit: https://data.edmonton.ca/resource/eecg-fc54.json?$query=select%20owner,%20planted_date,%20type_of_edible_fruit%20where%20bears_edible_fruit%20=%20%22Yes%22%20order%20by%20planted_date%20desc%20limit%2010 https://data.edmonton.ca/resource/eecg-fc54.json?$query=sele...