This exercise involves completing several queries set up in the notebook presented by Dara Adib, using Postgis. The first few were done mostly in class, so should already mostly be done. The ones numbered 1-3 are near the bottom of the notebook.
This exercise is due by end of Tuesday.
Queries mostly completed in class:
How many AC transit bus routes exist?
How many AC Transit bus stops are on Telegraph?
What is the average population of a Census block in Alameda County, excluding blocks without residents?
What percent of the population in Alameda County is Black or African American alone?
Which Census block in Alameda County, with more than 200 residents, has the highest percent Asian alone? Hint: use `ORDER BY` and `LIMIT`.
Which BART lines service Downtown Berkeley?
Which cities are served by the 800 AC Transit bus?
Which Alameda County city has the lowest population density?
Can't change a rubric once you've started using it.