Context

DataSF seeks to transform the way that the City of San Francisco works -- through the use of data.

https://datasf.org/about/

Content

This dataset contains the following tables: ['311_service_requests', 'bikeshare_stations', 'bikeshare_status', 'bikeshare_trips', 'film_locations', 'sffd_service_calls', 'sfpd_incidents', 'street_trees']

• 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 data includes fire unit responses to calls from April 2000 to present and is updated daily. Data contains the call number, incident number, address, unit identifier, call type, and disposition. Relevant time intervals are also included. Because this dataset is based on responses, and most calls involved multiple fire units, there are multiple records for each call number. Addresses are associated with a block number, intersection or call box.
• This data includes incidents from the San Francisco Police Department (SFPD) Crime Incident Reporting system, from January 2003 until the present (2 weeks ago from current date). The dataset is updated daily. Please note: the SFPD has implemented a new system for tracking crime. This dataset is still sourced from the old system, which is in the process of being retired (a multi-year process).
• This data includes a list of San Francisco Department of Public Works maintained street trees including: planting date, species, and location. Data includes 1955 to present.

This dataset is deprecated and not being updated.

Fork this kernel to get started with this dataset.

Acknowledgements

http://datasf.org/

• https://cloud.google.com/bigquery/public-data/sfo-311
• https://cloud.google.com/bigquery/public-data/sffd-service-calls
• https://cloud.google.com/bigquery/public-data/sfpd-reports
• https://cloud.google.com/bigquery/public-data/sfo-trees

Dataset Source: SF OpenData. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://sfgov.org/ - and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @meric from Unplash.

Inspiration

Which neighborhoods have the highest proportion of offensive graffiti?

Which complaint is most likely to be made using Twitter and in which neighborhood?

What are the most complained about Muni stops in San Francisco?

What are the top 10 incident types that the San Francisco Fire Department responds to?

How many medical incidents and structure fires are there in each neighborhood?

What’s the average response time for each type of dispatched vehicle?

Which category of police incidents have historically been the most common in San Francisco?

What were the most common police incidents in the category of LARCENY/THEFT in 2016?

Which non-criminal incidents saw the biggest reporting change from 2015 to 2016?

What is the average tree diameter?

What is the highest number of a particular species of tree planted in a single year?

Which San Francisco locations feature the largest number of trees?

A log of dataset alerts open, monitored or resolved on the open data portal. Alerts can include issues as well as deprecation or discontinuation notices.

Graph and download economic data for Employed Persons in San Francisco County/City, CA (LAUCN060750000000005) from Jan 1990 to Apr 2025 about San Francisco County/City, CA; household survey; employment; persons; and USA.

The City Survey asks residents to indicate their usage and satisfaction with city services and infrastructure like libraries, Muni, public safety, and street cleanliness. The City Survey was conducted every year from 1996 to 2004, and biennially from 2005 onward. The City Survey was not conducted in 2019 due to the COVID-19 pandemic, and resumed in 2023. Survey methodology was changed in 2015 from a mail to a phone survey, and expanded to include in-person and online options in 2023. Comparisons to previous years should be interpreted with caution. Results should be weighted using the column "weight" in order to adjust for demographic differences between the City Survey sample and San Francisco's population. Please note that survey results were originally reported as unweighted until 1997. From 1997 onward, all City Survey results were reweighted with the exception of data from 2011. For ease of use, the column "weight" has been coded with a value of one for these years. A code book is also attached to this dataset under About > Attachments. Neighborhood and Zip Code data have been hidden from this data set and are only available upon special request to citysurvey@sfgov.org. For more information regarding San Francisco City Survey 1996-2023 Database, please visit the City Survey website at https://sf.gov/citysurvey or contact the San Francisco Controller's Office at citysurvey@sfgov.org.

Statistics for moving services in san-francisco including costs, move sizes, and other relevant data as of June 2025.

About this dataset

Context

The dataset tabulates the population of San Francisco township by gender across 18 age groups. It lists the male and female population in each age group along with the gender ratio for San Francisco township. The dataset can be utilized to understand the population distribution of San Francisco township by gender and age. For example, using this dataset, we can identify the largest age group for both Men and Women in San Francisco township. Additionally, it can be used to see how the gender ratio changes from birth to senior most age group and male to female ratio across each age group for San Francisco township.

Key observations

Largest age group (population): Male # 65-69 years (67) | Female # 60-64 years (56). Source: U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Age groups:

• Under 5 years
• 5 to 9 years
• 10 to 14 years
• 15 to 19 years
• 20 to 24 years
• 25 to 29 years
• 30 to 34 years
• 35 to 39 years
• 40 to 44 years
• 45 to 49 years
• 50 to 54 years
• 55 to 59 years
• 60 to 64 years
• 65 to 69 years
• 70 to 74 years
• 75 to 79 years
• 80 to 84 years
• 85 years and over

Scope of gender :

Please note that American Community Survey asks a question about the respondents current sex, but not about gender, sexual orientation, or sex at birth. The question is intended to capture data for biological sex, not gender. Respondents are supposed to respond with the answer as either of Male or Female. Our research and this dataset mirrors the data reported as Male and Female for gender distribution analysis.

Variables / Data Columns

• Age Group: This column displays the age group for the San Francisco township population analysis. Total expected values are 18 and are define above in the age groups section.
• Population (Male): The male population in the San Francisco township is shown in the following column.
• Population (Female): The female population in the San Francisco township is shown in the following column.
• Gender Ratio: Also known as the sex ratio, this column displays the number of males per 100 females in San Francisco township for each age group.

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for San Francisco township Population by Gender. You can refer the same here

This dataset has been replaced by the following datasets: Planning Department Records - Projects Planning Department Records - Non-Projects Data from the Planning Department's Accela permitting system. A. SUMMARY All records from the San Francisco Planning Department's permit and project tracking system. B. HOW THE DATASET IS CREATED Records have been joined to associated parcels to map each record. C. UPDATE PROCESS Updated nightly D. HOW TO USE THIS DATASET For further information on permits: https://sfplanning.org/permits Record types are listed here: https://sfplanning.org/resource/project-suffixes-and-descriptions-case-numbers

In 2023, the GDP of the San Francisco Bay Area amounted to 681.89 billion U.S. dollars, an increase from the previous year. The overall quarterly GDP growth in the United States can be found here. The GDP of the San Francisco Bay Area The San Francisco Bay Area, commonly known as the Bay Area, is a metropolitan region that surrounds the San Francisco and San Pablo estuaries in Northern California. The region encompasses metropolitan areas such as San Francisco-Oakland (12th largest in the country), San Jose (31st largest in the country), along with smaller urban and rural areas. Overall, the Bay Area consists of nine counties, 101 cities, and 7,000 square miles. The nine counties are Alameda, Contra Costa, Marin, Napa, San Francisco, San Mateo, Santa Clara, Solano, and Sonoma. There are approximately 4.62 million people living in the metro area as of 2022. Silicon Valley In the ten year period between 2001 and 2011, the Bay Area saw steady GDP growth. Starting in 2012, it began to skyrocket. This is thanks to an economic boom in the tech sector, and high value companies headquartered in Silicon Valley - also part of the Bay Area. Silicon Valley is known as the center of the global technology industry. Companies like Google, Facebook, eBay and Apple are headquartered there. Additionally, California ranked first on a list of U.S. states by GDP, with more than 3.59 trillion U.S. dollars in GDP in 2022.

As of July 19, 2015, the PD District boundaries have been updated through a redistricting process. These new boundaries are not reflected in the dataset yet so you cannot compare data from July 19, 2015 onward to official reports from PD with the Police District column. We are working on an update to the dataset to reflect the updated boundaries starting with data entered July 19 onward.

Incidents derived from SFPD Crime Incident Reporting system Updated daily, showing data from 1/1/2003 up until two weeks ago from current date. Please note: San Francisco police have implemented a new system for tracking crime. The dataset included here is still coming from the old system, which is in the process of being retired (a multi-year process). Data included here is no longer the official SFPD data. We will migrate to the new system for DataSF in the upcoming months.

Financial overview and grant giving statistics of Fotc - Sf Bay Area

Inspiration

SFO is one of the busiest airports in the United States and also an important transpacific gateway for international passenger / cargo travel. It would be interesting to use the data for the following

• Study the passenger travel and cargo movement patterns during COVID-19 pandemic
• Use the tabular data for clustering algorithms
• Perform traffic forecasting

Check out my notebook for details and EDA

Dataset

This dataset consists of two files;

• Air_Traffic_Passenger_Statistics.csv - Details here

• Air_Traffic_Cargo_Statistics.csv - Details here

Acknowledgements

Data source : https://data.sfgov.org

Cover Photo by Ken Yam on Unsplash

In order to understand how higher inclusionary housing requirements affects the feasibility of new market-rate housing development, the Controller's Office contracted with Blue Sky Consulting Group to statistically model the factors that affect the probability of housing development in San Francisco. This data underlies the model reported in our preliminary report. An overview of the statistical analysis is provided in main section of the report, with more details provided in the Appendix.

Mobile Food Facility Permits including name of vendor, location, type of food sold and status of permit. Mobile Food Facility Permit Schedule is here https://data.sfgov.org/d/jjew-r69b

Graph and download economic data for Civilian Labor Force in San Francisco County/City, CA (CASANF0LFN) from Jan 1990 to Apr 2025 about San Francisco County/City, CA; San Francisco; civilian; labor force; CA; labor; and USA.

Financial overview and grant giving statistics of San Francisco Tyee Club

This graph shows the GDP of the San Francisco Bay Area in 2022, by industry. In 2022, the GDP of the San Francisco metro area amounted to about 654.73 billion U.S. dollars. About 68.02 billion U.S. dollars were generated in the manufacturing industries. The overall quarterly GDP growth in the United States can be found here. The San Francisco Bay Area’s GDP The San Francisco Bay Area, commonly known as the Bay Area, is a metropolitan region that surrounds the San Francisco and San Pablo estuaries in Northern California. The region encompasses metropolitan areas such as San Francisco-Oakland (12th largest in the country), San Jose (31st largest in the country), along with smaller urban and rural areas. Overall, the Bay Area consists of nine counties, 101 cities, and 7,000 square miles. The nine counties are Alameda, Contra Costa, Marin, Napa, San Francisco, San Mateo, Santa Clara, Solano, and Sonoma. The United States Census Bureau considers the Bay Area a Combined Statistical Area (CSA) with approximately 7.4 million people, including the nine counties bordering San Francisco Bay as well as Santa Cruz and San Benito Counties, making it the sixth largest CSA in the United States.

In the ten year period between 2001 and 2011, the Bay Area saw its GDP grow considerably. In 2001, GDP was 239 billion U.S. dollars. This value rose to 347 billion U.S. dollars by 2011. Additionally, California ranked first on a list of U.S. states by GDP, with two trillion U.S. dollars of GDP in 2012. Silicon Valley, located in the Bay Area, is in great part responsible for the Bay Area’s and California’s high GDPs, as it is known as the center of the global technology industry. Companies like Google, Facebook, eBay and Apple are headquartered there.

About this dataset

Context

The dataset tabulates the population of San Francisco County by gender across 18 age groups. It lists the male and female population in each age group along with the gender ratio for San Francisco County. The dataset can be utilized to understand the population distribution of San Francisco County by gender and age. For example, using this dataset, we can identify the largest age group for both Men and Women in San Francisco County. Additionally, it can be used to see how the gender ratio changes from birth to senior most age group and male to female ratio across each age group for San Francisco County.

Key observations

Largest age group (population): Male # 30-34 years (50,273) | Female # 30-34 years (44,861). Source: U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Content

When available, the data consists of estimates from the U.S. Census Bureau American Community Survey (ACS) 2019-2023 5-Year Estimates.

Age groups:

• Under 5 years
• 5 to 9 years
• 10 to 14 years
• 15 to 19 years
• 20 to 24 years
• 25 to 29 years
• 30 to 34 years
• 35 to 39 years
• 40 to 44 years
• 45 to 49 years
• 50 to 54 years
• 55 to 59 years
• 60 to 64 years
• 65 to 69 years
• 70 to 74 years
• 75 to 79 years
• 80 to 84 years
• 85 years and over

Scope of gender :

Please note that American Community Survey asks a question about the respondents current sex, but not about gender, sexual orientation, or sex at birth. The question is intended to capture data for biological sex, not gender. Respondents are supposed to respond with the answer as either of Male or Female. Our research and this dataset mirrors the data reported as Male and Female for gender distribution analysis.

Variables / Data Columns

• Age Group: This column displays the age group for the San Francisco County population analysis. Total expected values are 18 and are define above in the age groups section.
• Population (Male): The male population in the San Francisco County is shown in the following column.
• Population (Female): The female population in the San Francisco County is shown in the following column.
• Gender Ratio: Also known as the sex ratio, this column displays the number of males per 100 females in San Francisco County for each age group.

Good to know

Margin of Error

Data in the dataset are based on the estimates and are subject to sampling variability and thus a margin of error. Neilsberg Research recommends using caution when presening these estimates in your research.

Custom data

If you do need custom data for any of your research project, report or presentation, you can contact our research staff at research@neilsberg.com for a feasibility of a custom tabulation on a fee-for-service basis.

Inspiration

Neilsberg Research Team curates, analyze and publishes demographics and economic data from a variety of public and proprietary sources, each of which often includes multiple surveys and programs. The large majority of Neilsberg Research aggregated datasets and insights is made available for free download at https://www.neilsberg.com/research/.

Recommended for further research

This dataset is a part of the main dataset for San Francisco County Population by Gender. You can refer the same here

Graph and download economic data for Unemployment Rate in San Francisco-Oakland-Hayward, CA (MSA) (SANF806URN) from Jan 1990 to Apr 2025 about San Francisco, CA, unemployment, rate, and USA.

About 30 percent of San Francisco's housing stock consisted of single-family homes in 2023. Buildings with two to four units, as well as large multifamily buildings each accounted for 20 percent of the housing stock.

Graph and download economic data for Employed Persons in San Francisco-Oakland-Hayward, CA (MSA) (LAUMT064186000000005) from Jan 1990 to Apr 2025 about San Francisco, CA, household survey, employment, persons, and USA.