AndreaBozzo/ceres-open-data-index huggingface dataset:
CCSF Digital Basemap CAD Files

The San Francisco Basemap in CAD format comprised of 74 (zipped) tiled drawing files (SF00C.dwg - SF99C.dwg) refreshed weekly.

Projection and Datum
· The files are referenced to the California State Plane Coordinate System, Zone III. The coordinate units are in feet. 
· The Datum is North American Datum 1983.

Tags: base, basemap, blocks, cad, cadastral, drawings, map, parcel
Organization: City of San Francisco
Planning Department's Current Planning Team Boundaries

A. SUMMARY
These boundaries are the areas of responsibility of the Planning Department's Current Planning teams. Building permits and Planning records are assigned to planning staff on a geographic basis to the Current Planning teams. These areas are based on Supervisorial Districts.

B. HOW THE DATASET IS CREATED
Team boundaries are an aggregation of supervisorial districts.

C. UPDATE PROCESS
Boundaries change every 10 years (when supervisorial districts are updated).  Attribute data changes occasionally.  Updates are manual.

D. HOW TO USE THIS DATASET
Building permits and Planning records are assigned to planning staff on a geographic basis to the Current Planning teams.

Tags: current-planning, permits, planning
Organization: City of San Francisco
Crossing Guard Intersections

A. SUMMARY 
This table contains information about the intersection locations served by the SFMTA Adult School Crossing Guard Program. The placement and assignment of crossing guards is dependent on a number of criteria. To find out more about the program, please visit: http://www.sfmta.com/services/streets-sidewalks/request-crossing-guard. 

B. METHODOLOGY 
Manually updated.Updates from School Crossing Guard Program Manager.

C. UPDATE FREQUENCY 
Updated as needed

D. OTHER CRITICAL INFO 
N/A

Organization: City of San Francisco
SFEC 3.216(d) Gifts of Travel Filings - April 2015 to March 2018

This table includes legacy filings from April 2015 to March 2018. For current filings, see dataset https://data.sfgov.org/City-Management-and-Ethics/Gifts-Of-Travel/snqf-y894

Under section 3.216(d) of the San Francisco Campaign and Governmental Conduct Code, form SFEC-3.216(d) must be filed by an elected officer who either:(a) accepts a gift of transportation, lodging, or subsistence for any out-of-state travel that is paid for in part by an entity other than the City and County of San Francisco, another governmental body, or a bona-fide educational institution as defined in section 203 of the Revenue and Taxation Code, or that is paid for by the City in whole or in part with funds donated from any entity other than another governmental body or bona fide educational institution as defined in Section 203 of the Revenue and Taxation Code; or(b) reimburses the entity for the gift of transportation, lodging or subsistence in order to avoid receiving a gift.

Tags: conflict-of-interest, gifts, travel
Organization: City of San Francisco
Commerce & Industry Inventory 2012 Data

Exel Workbook of all tables in the San Francisco Planning Department's Commerce & Industry Inventory 2012. Go here for the document (http://www.sf-planning.org/ftp/files/publications_reports/Commerce_Industry_Inventory_Report_2012.pdf) or here for all documents (http://www.sf-planning.org/index.aspx?page=1663#commerce_industry).

Organization: City of San Francisco
Supervisor District (2012) to ZIP Code Crosswalk

View the 2022 Zip Code to Supervisor District Crosswalk: https://data.sfgov.org/Geographic-Locations-and-Boundaries/Supervisor-District-2022-to-ZIP-Code-Crosswalk/2x22-z5j6

Lists intersecting Supervisor Districts and ZIP Codes for City and County of San Francisco.

Tags: district, supervisor, zip-code
Organization: City of San Francisco
Travel Decision Survey Data 2014

This workbook provides data and data dictionaries for the SFMTA 2014 Travel Decision Survey. 
The 2014 Key Findings, Summary Report, and Methodology, including the survey instrument, can be found online at https://www.sfmta.com/about-sfmta/reports/travel-decision-survey-2014. 
On behalf of San Francisco Municipal Transportation Agency (SFMTA), Corey, Canapary & Galanis (CC&G) undertook a Mode Share Survey within the City and County of San Francisco as well as the eight surrounding Bay Area counties of Alameda, Contra Costa, San Mateo, Marin, Santa Clara, Napa, Sonoma and Solano.

The primary goals of this study were to:
• Assess percent mode share for travel in San Francisco for evaluation of the SFMTA Strategic Objective 2.3: Mode Share target of 50% non-private auto travel by FY2018 with a 95% confidence level and MOE +/- 5% or less.
• Evaluate the above statement based on the following parameters:  number of trips to, from, and within San Francisco by Bay Area residents. Trips by visitors to the Bay Area and for commercial purposes are not included.
• Provide additional trip details, including trip purpose for each trip in the mode share question series.
• Collect demographic data on the population of Bay Area residents who travel to, from, and within San Francisco.
• Collect data on travel behavior and opinions that support other SFMTA strategy and project evaluation needs.

The survey was conducted as a telephone study among with approximately 750 Bay Area residents aged 18 and older. Interviewing was conducted in English, Spanish, and Cantonese. Surveying was conducted via random digit dial (RDD) and cell phone sample. 
All three survey datasets incorporate respondent weighting based on age and home location; utilize the “weight” field when appropriate in your analysis. 

The survey period for this survey is as follows:
2014: October – November 2014

A few questions in TDS 2014 were added after the survey began. In the report, responses that did not answer those questions were excluded from the analysis. The questions that were added late are noted in the TDS 2014 methodology survey instrument.
The margin of error is related to sample size (n). For the total sample, the margin of error  is 3.5% for a confidence level of 95%. When looking at subsets of the data, such as just the SF population, just the female population, or just the population of people who bicycle, the sample size decreases and the margin of error increases. Below is a guide of the margin of error for different samples sizes. Be cautious in making conclusions based off of small sample sizes.
 
At the 95% confidence level is:
• n = 767 (Total Sample). Margin of error = +/- 3.5%
• n = 384. Margin of error = +/- 4.95%
• n = 100. Margin of error = +/- 9.80%

Tags: bicycling, biking, driving, survey, taxis, transit, transportation, walking
Organization: City of San Francisco
Bike Volume - Manual Counts

A. SUMMARY 
Bicycle counts (volume) from 2009-2017, with the exception of 2012 when counts were not collected.

B. METHODOLOGY  
Manually updated

C. UPDATE FREQUENCY  
Annually in the fall, counts are collected the second week of September in coordination with the National Bicycle and Pedestrian Documentation Project. 

D. OTHER CRITICAL INFO  
A bicycle count value of “-1” indicates a null value (bicycle count data was not collected at this location for that year). Bike counts for 2012 are not included in this file, as they are not available/unable to be located. One empty feature from the original “citywide_manual_bicycle_count_locations” (feature 50) was deleted.

Tags: bicycle, bicycle-counts, bike, bike-volume, volume
Organization: City of San Francisco
Municipal Transportation Agency Board Resolutions

The SFMTA Board of Directors provides policy oversight for the safe and efficient transportation of goods and people in San Francisco in accordance with the San Francisco Charter and the Transit First Policy. This includes the San Francisco Municipal Railway (Muni), automobiles and trucks, taxis, bicycling and walking. The SFMTA Board of Directors also serves as members of the San Francisco Parking Authority.

The Board votes on various items that are captured in the official minutes of each meeting. The map represents the individual items voted on at each board meeting that could be associated with a location either via a block range or intersection. Data are extracted voluntarily by a third-party XTreet (https://xtreet.org) from the PDF minutes. As such, there may be errors or omissions. Also note that data lags minutes as they are transcribed in bulk through a combination of automated and manual processing. The data is provided as is. If you are in need of the accurate accounting of the meetings, please refer to the minutes available at https://www.sfmta.com/about-sfmta/organization/divisions-and-units/board-directors

Organization: City of San Francisco
Regression data for Inclusionary Housing Simulation Model

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.

Tags: inclusionary-housing, probability, regression-model, statistics
Organization: City of San Francisco
Recognized Healthy Nail Salons in San Francisco

The San Francisco Healthy Nail Salon Program is a free and voluntary program open to all nail salons in the City. The goal of the Healthy Nail Salon Program is to reduce exposure of nail salon employees and residents to the toxic chemicals in nail products. The benefits of the Healthy Nail Salon Program include: 

- Enhanced health and well being of staff 
- Safer environment for customers
- Recognition and promotion by San Francisco’s Department of Environment 
- Potential to attract new customers 

The data set is a list of all certified Healthy Nail Salons recognized by San Francisco Department of the Environment.

Organization: City of San Francisco
Campaign Consultants - List of Registered Campaign Consultants and their Respective Clients

This dataset will no longer be updated as of March 2024, and is scheduled to be replaced with a new dataset in January of 2025. New filings are available in scanned paper format through the Ethics Commission's <a href="https://public.netfile.com/pub2/?aid=sfo">public disclosure portal</a>.

In 1997, San Francisco voters approved the Regulation of Campaign Consultants Ordinance (“Ordinance”). The Ordinance requires persons who earn $1,000 or more per year for campaign consultant services to register with the Ethics Commission and file quarterly activity reports. The Ordinance defines “campaign consultant” as a person or entity that receives or is promised $1,000 or more in a calendar year for either campaign management or campaign strategy.

Tags: campaign, client, consultant, ethics, registered
Organization: City of San Francisco
StreetSmArts Murals

<strong>A. SUMMARY</strong>
StreetSmARTS is a Department of Public Works (DPW) graffiti abatement program, administered through the San Francisco Arts Commission (SFAC). The program connects artists with private property owners to create murals on their buildings, enhancing the character of the property and surrounding neighborhood, while deterring ongoing vandalism.

<strong>B. HOW THE DATASET IS CREATED</strong>
In 2017, an inventory was compiled manually by staff and it has been updated with each new mural created since.

<strong>C. UPDATE PROCESS</strong>
Dataset updated as needed manually by staff.

<strong>D. HOW TO USE THIS DATASET</strong>
The majority of murals have street addresses but a few have street intersections instead. The address is the building location but the mural may be on the side of the building or around the corner. The data column "number_of_districts" refers to how many Cultural Districts a mural is in. If a mural is in more than Cultural Districts, the districts will be listed in the "Cultural_District" column and separated by a semicolon. This is because cultural districts can overlap. 

The <a href="https://data.sfgov.org/Culture-and-Recreation/Cultural-Heritage-Districts/5xmc-5bjj">cultural heritage districts dataset is also available online</a>.

Organization: City of San Francisco
100-Year Storm Flood Elevations (December 2024)

<strong>Summary</strong>
This shapefile (polygon feature) contains flood elevation zones associated with the 100-Year Storm Flood Risk Zone. Flood elevation zones are an area with a single, uniform flood elevation that refers to the height (rounded to the nearest foot) that stormwater is likely to reach during a 100-year storm, measured from the San Francisco City Datum (SFCD). Parcels may have multiple flood elevations zones. 

<strong>HOW THE DATASET IS CREATED</strong>
Additional information on the 100-Year Flood Risk Zone and flood elevations can be found on the Flood Maps website https://www.sfpuc.gov/learning/emergency-preparedness/flood-maps and on the Information Sheet https://www.sfpuc.gov/sites/default/files/documents/SFPUC_100_Year_Flood_Map_FAQs.pdf

<strong>RELATED DATASETS</strong>
Refer to the 100-Year Storm Flood Risk Zone shapefile for more information on the extent of the polygon https://data.sfgov.org/Public-Safety/100-Year-Storm-Flood-Risk-Zone-July-2022-/jzu3-4yxp/about_data.

Organization: City of San Francisco
311 Explorer

The SF311 Explorer is a new website that provides a simple way to see service request data by neighborhood, location and/or category. Users can search the last year of SF311 service request data by Service Request Number (Ticket ID), or click into the application and select one of the ready made charts. Additionally, visitors to the SF311 Explorer can submit requests using the web version of the SF311 mobile app (Submit a Ticket) or see the full dataset of SF311 service requests going back to July of 2008 via the Access Dataset link.

Organization: City of San Francisco
SFEC Form 125 - Bundled Contributions Disclosure Report - Filings

Under San Francisco Campaign & Governmental Conduct Code Section 1.125, any committee controlled by a City elective officer or candidate for City elective office that receives contributions totaling $5,000 or more that have been bundled by a single individual shall file Form 125 at the same time that they are required to file semi-annual or pre-election campaign statements until the committee is terminated. Committees shall be required to provide this information following the receipt of the final contribution that makes the cumulative total $5,000 or more. For more information visit www.sfethics.org.

Each row on this table represents the contents of a Form 125 filed with the Ethics Commission. There are two sub-tables of information on "Officers" and "Contributions". The sub-tables are parsed into separate datasets: "SFEC Form 125 - Bundled Contributions Disclosure Report - Officers" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-125-Bundled-Contributions-Disclosure-Rep/x9je-gi3q and "SFEC Form 125 - Bundled Contributions Disclosure Report - Contributions" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-125-Bundled-Contributions-Disclosure-Rep/dzp4-4my5. Join this dataset with the sub-table using the DocuSignID.

Organization: City of San Francisco
Campaign Finance - Individual Expenditure Ceilings  IECs  - November 4, 2014 Election

In the November 4, 2014 election, only candidates for the Board of Supervisors who have been certified as eligible to receive public funds are bound by an Individual Expenditure Ceiling (IEC). Each publicly financed candidate's IEC begins at $250,000 and may be raised in increments of $10,000.

Tags: 2014, campaign, candidate, ceilings, election, expenditure, finance, financing, iec, individual, november, public
Organization: City of San Francisco
Campaign Finance - Data Key

The dataset contains descriptions for each column of historical campaign finance data available on data.sfgov.org or the Excel exports on the Ethics Commission's Campaign Finance Database at http://nf4.netfile.com/pub2?aid=sfoPlease note -- the column header names on different schedules of Form 460 often match, but sometimes have different meanings.

Tags: campaign, data, finance, key
Organization: City of San Francisco
San Francisco Speed Limit Compliance

Statistics on speeding rates and exceedance of speed limit along selected street segments throughout San Francisco. The dataset was prepared as part of the SF Indicators project and covers from 2004 through 2009. http://www.sfindicatorproject.org/indicators/view/49

Tags: cars, collisions, department-of-public-health, dph, environmental-health, hdmt, healthy-development-measurement-tool, motor-vehicles, phes, safety, san-francisco, sci, sfdph, sfmta, sfphes, speed-limit, sustainable-communities-index, transportation
Organization: City of San Francisco
SFMTA - Transit Vehicle Location History (Current Year)

<strong>A. SUMMARY</strong>
Location data of SFMTA Transit Vehicles. Location information includes reported location date and time, vehicle identifier, location latitude and longitude, heading and speed. This dataset will only contain data for the current calendar year and will reset to the next calendar year the first of every year.  Prior years are saved as separate datasets.
<strong>B HOW THE DATASET IS CREATED</strong>
Vehicle location data is provided by the SFMTA’s computer aided dispatch and automated vehicle location system. 
<strong>C. UPDATE PROCESS</strong>
Location data is published daily for the previous day, resulting in a lag, up to 24 hours.  
<strong>D. HOW TO USE THIS DATASET</strong>
Location data can be used to visualize vehicle routes and city wide traffic patterns.

Tags: avl, gps, muni, sfmta, transit
Organization: City of San Francisco
City Construction Projects to Proceed During Shelter-in-place

<strong>A. SUMMARY</strong>
List of public works construction projects that the City Administrator has designated as serving an Essential Government Function. This designation allows a public works project to continue, provided that it has a Site-Specific Health and Safety Plan, Code of Safe Practices and posts a Social Distancing Protocol onsite.
 
<strong>B. HOW THE DATASET IS CREATED</strong>
City departments and other government agencies submit projects to the City Administrator. In consultation with the Health Officer, the City Administrator determines whether it meets an Essential Government Function. Only the projects that meet that test are listed here.
 
<strong>C. UPDATE PROCESS</strong>
Updated as required, dataset uploaded manually by staff.
 
<strong>D. HOW TO USE THIS DATASET</strong>
Data will be updated as available and may change as more information becomes available.

Organization: City of San Francisco
SFEC Form 125 - Bundled Contributions Disclosure Report - Officers

Under San Francisco Campaign & Governmental Conduct Code Section 1.125, any committee controlled by a City elective officer or candidate for City elective office that receives contributions totaling $5,000 or more that have been bundled by a single individual shall file Form 125 at the same time that they are required to file semi-annual or pre-election campaign statements until the committee is terminated. Committees shall be required to provide this information following the receipt of the final contribution that makes the cumulative total $5,000 or more. For more information visit www.sfethics.org.

Each row in this dataset represents information about officers reported in the "Information Regarding Bundler" sub-table of a Form 125 filed with the Ethics Commission. The parent filing and form data is available in a separate dataset: "SFEC Form 125 - Bundled Contributions Disclosure Report - Filings" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-125-Bundled-Contributions-Disclosure-Rep/wv58-ismt. Join this dataset with the sub-table using the DocuSignID.

Organization: City of San Francisco
SFO Screening Checkpoint Satisfaction October, 2019

The screening checkpoint experience is a key driver of satisfaction at SFO, thus understanding the quality of the service and controllable experiences is required to improve it. SFO conducted two surveys of the Terminal 2 checkpoint in 2019. One in May, and after improvements were made, another in October to understand whether this changes were successful or in any way impactful.

A code-list is attached to assist with analysis.

Our research partner is San Francisco-based Corey, Canapary & Galanis  Reasearch

Tags: customer, satisfaction-survey, screening-checkpoint, sfo, survey
Organization: City of San Francisco
List of Historical Ballot Measures

Ballot Proposition Symbols	This is an explanation of the last two columns of the Ballot Proposition Data. The first symbol is a letter indicating the type of measure--for example, a charter amendment or ordinance.	The second symbol is a letter indicating how the measure was placed on the ballot--for example, by the Board of Superviors or by initiative petition.	These are their meanings:	First Letter--The Type of Legislaton	B	Bond IssueC	Charter AmendmentL	Lease Revenue Bond IssueO	OrdinanceP	Policy DeclarationR	RecallRM	Regional��MeasureT	Tax Authority for School DistrictSecond Letter--How it was placed on the Ballot	C	Charter Commission, elected by the votersI	Initiative PetitionL	Labor DisputesM	MayorR	Referendum PetitionS	The Board of��Supervisorss	Four or more individual��supervisorsse	Special, i.e. Board of Education2	By��two��of the above methods

Organization: City of San Francisco
San Francisco Environmental Justice Communities Map

The Environmental Justice Communities Map (“EJ Communities Map”) describes areas of San Francisco that have higher pollution and are predominately low-income. This map is based on CalEnviroScreen, a tool created by CalEPA & OEHHA that maps California communities that are most affected by pollution and other health risks. This EJ Communities Map includes additional local data on pollution and demographics, and was refined during the community engagement process based on public feedback. 
“EJ Communities” are defined as the areas facing the top one-third of cumulative environmental and socioeconomic burdens across the City. The EJ Communities include areas of Bayview Hunters Point, Chinatown, Excelsior, Japantown, Mission, Ocean View-Merced Heights-Ingleside, Outer Mission, Potrero Hill, SoMa, Tenderloin, Treasure Island, Visitacion Valley, and Western Addition.

"EJ Communities” are defined as the areas facing the top one-third of cumulative environmental and socioeconomic burdens across the City, with scores 21-30.

Further information is available here: https://sfplanning.org/project/environmental-justice-framework-and-general-plan-policies#ej-communities

Tags: environment, justice, planning
Organization: City of San Francisco
San Francisco Department of Public Health Flu Shot Locations 2013

List of San Francisco Department of Public Health clinics offering flu vaccinations throughout the city in fall 2013.This dataset complies with the  emerging Data Specification for Flu Shot Locations. For information about the specification, please see https://github.com/CityOfPhiladelphia/flu-shot-spec.For more information about SFDPH's Influenza Program  www.sfcdcp.org/flu or call 311For more information about SFDPH's Open data Initiatives http://www.sfphes.org/resources/health-data or Contact Cyndy.comerford@sfdph.org

Tags: environmental-health, flu, influenza, phes, public-health, san-francisco, sfdph, sfphes, vaccination, vaccines
Organization: City of San Francisco