This data includes all San Francisco 311 service requests from July 2008 to the present, and is updated daily. 311 is a non-emergency number that provides access to non-emergency municipal services.
This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery
Here are some examples of SQL queries you can run on this data in BigQuery.
Which neighborhoods have the highest proportion of offensive graffiti?
This query uses the complaint_type column which differentiates between offensive and non offensive graffiti, and calculates them as a percentage of total complaints for graffiti. Run this query.
Which complaint is most likely to be made using Twitter and in which neighborhood?
This query uses the source column to filter out requests made via Twitter, grouped by neighborhood andcomplaint_type. Run this query.
What are the most complained about Muni stops in San Francisco?
This query uses the category column value of MUNI Feedback to find the bus stop with the most service requests. Run this query.
This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://sfgov.org/
La console Google Cloud n'a pas pu charger les sources JavaScript depuis www.gstatic.com.
Voici les raisons possibles :