AndreaBozzo/ceres-open-data-index huggingface dataset:
San Francisco Ballot Propositions Database - Historical Ballot Propositions 1907-present

<strong>A. SUMMARY</strong>

The San Francisco Public Library is thrilled to share our dataset from the San Francisco Ballot Propositions Database on DataSF. This dataset contains full text of San Francisco ballot propositions dating back to 1907 and links to digitized PDF versions of the pamphlets for each election. 

Visit SFPL's <a href="https://sfpl.org/locations/main-library/government-information-center/san-francisco-government/san-francisco-1/san-1" target="_blank" rel="noopener">San Francisco Ballot Propositions Database</a> for a keyword searchable interface and links to Voter Information pamphlets.

<strong>B. HOW THE DATASET IS CREATED</strong>

San Francisco Public Library received a Library Services and Technology grant to finance the digital scanning and microfilming of the Library's print collection of voter information pamphlets and handbooks for San Francisco municipal elections. Although not complete, the collection dates back to 1907. Approximately 59,000 voter pamphlet pages, including 1,500 propositions, were digitized into PDF files. For some elections, separate pamphlets were created for each voting district or a combination of each voting district and political party, and there is no singular representative pamphlet which includes all of the candidates for that election. As a result, the hard copies of the various pamphlets were bound together to represent that particular election, and this resulted in extra-large digitized versions. 

Because the PDF files of the voter pamphlets are images instead of text, they cannot be searched electronically. San Francisco Public Library staff developed the San Francisco Ballot Propositions Database to provide keyword access to San Francisco propositions, pass/fail outcomes and other information, and links to the full-text PDF Voter Information Pamphlet.
 
<strong>C. UPDATE PROCESS</strong>

This dataset is updated when the final election results from the <a href="https://sfelections.sfgov.org/results">San Francisco Department of Elections</a> are available.

<strong>D. HOW TO USE THIS DATASET</strong>

This dataset contains the number and percentage of ballots cast, percentage required to pass, as well as pass/fail outcomes, the full text of each proposition, and a link to a PDF version of the Voter Information Pamphlet for that election, if available.

Tags: ballot-measure, elections, propositions
Organization: City of San Francisco
DPW Street & Sidewalk Evaluation Results, 7-1-2013 to 6-30-2018 (FY13-FY18)

The Controller's Office's City Services Auditor (CSA) Division has worked with the Department of Public Works (DPW) to develop maintenance standards for streets and sidewalks and schedules and inspect for compliance since July 2004, as mandated by 2003 Prop. C. This data file contains street and sidewalk evaluation results from 7/1/2013  to 6/30/18 under the FY12 standards.  Older evaluation results are also available on DataSF but are not comparable due to changes in the way the standards are calculated.  You can also access the annual reports in PDF at "Street Maintenance" section of http://sfcontroller.org/index.aspx?page=49 or https://sf.gov/resource/2022/street-and-sidewalk-maintenance-standards

Tags: controllers-street-evaluation-program, evaluation, graffiti, grime, inspection, leaks, litter, performance, results, sidewalk, spills, street, street-sweeping, trash, tree
Organization: City of San Francisco
SFEC Form 3610b - City Officer Behested Payment - Filings

San Francisco Campaign and Governmental Conduct Code section 3.610 requires City elective officers and members of certain boards and commissions to file behested payment reports (Form SFEC-3610(b)) with the Ethics Commission.

Effective September 24, 2020, Mayoral Executive Directive 20-02 requires Department Heads to file behested payment Form SFEC-3610(b) and to comply with the City’s behested payment requirements that apply to City elected officials and members of boards and commissions that are contained in Article III, Chapter 6 of the Campaign and Governmental Conduct Code. 

An officer must file Form SFEC-3610(b) any time a behested payment of $1,000 or more is made at his or her behest by an interested party. An “interested party” is a person who is a party, participant or agent of a party or participant to certain types of proceedings before the official in question. Those proceedings are limited to administrative enforcement proceedings and proceedings regarding permits, licenses, or other entitlements for use. A party to such a proceeding is someone who files an application for a license, permit, or entitlement for use or is the subject of the administrative enforcement. A participant in such a proceeding is someone who is not a party to the proceeding but who actively supports or opposes a particular decision in the proceeding and has a financial interest in the decision. An agent is someone who represents a party or a participant in such a proceeding.

The filing deadline for Form SFEC-3610(b) depends on the circumstances under which the behested payment was made.

If the behested payment was made while the proceeding involving the interested party is pending before the official, then the form must be filed within thirty days of the payment being made. If there is a series of behested payments, the form is due within 30 days of the payment that makes the total $1,000 or more.

If the behested payment was made within six months following the date on which a final decision was made in the proceeding involving the interested party, then the form must be filed within thirty days of the payment. If there is a series of behested payments, the form is due within 30 days of the payment that makes the total $1,000 or more.

Finally, if the behested payment was made in the 12 months prior to the commencement of the proceeding involving the interested party, the form is due within 30 days of the date the official knew or should have known that the source of the behested payment became an interested party.

Each row on this table represents the contents of a Form SFEC-3610(b) filed with the Ethics Commission. There are three sub-tables of information on Form SFEC-3610(b): Payors, Reportable Interests with Payee, and Communications Featuring Officer. These three subtable datasets are linked from this dataset's primer page. Join this dataset with the sub-table using the DocuSignID.

Tags: permit, permits
Organization: City of San Francisco
108" Inundation Vulnerability Zone Line (Sea Level Rise + 100YR Flood Event)

Disclaimer: The Sea Level Rise (SLR) map shows the most extreme level of SLR possible. It is a very, very unlikely scenario that would only occur if no efforts to address SLR occur and both a King Tide and 100-year storm occur at the same time. The real purpose of the maps is to provide a broad net to help the City identify projects that that may be vulnerable. The data is based on what was in the ground as of 2010 and doesn’t include piers. 

The inundation maps and the associated analyses are intended as planning level tools to illustrate the potential for inundation and coastal flooding under a variety of future sea level rise and storm surge scenarios. The maps depict possible future inundation that could occur if nothing is done to adapt or prepare for sea level rise over the next century. The maps do not represent the exact location or depth of flooding. The maps relied on a 1-m digital elevation model created from LiDAR data collected in 2010 and 2011. Although care was taken to capture all relevant topographic features and coastal structures that may impact coastal inundation, it is possible that structures narrower than the 1-m horizontal map scale may not be fully represented. The maps are based on model outputs and do not account for all of the complex and dynamic San Francisco Bay processes or future conditions such as erosion, subsidence, future construction or shoreline protection upgrades, or other changes to San Francisco Bay or the region that may occur in response to sea level rise. For more context about the maps and analyses, including a description of the data and methods used, please see the Climate Stressors and Impacts Report: Bayside Sea Level Rise Inundation Mapping Technical Memorandum, July 2014.

More information at http://onesanfrancisco.org/node/148

Tags: climate-change, planning, preparedness, resiliency
Organization: City of San Francisco
Tsunami Inundation Hazard Zone (2021 Update)

California Tsunami Hazard Area Maps and data are prepared to assist cities and counties in identifying their tsunami hazard for tsunami response planning. The maps and data are compiled with the best currently available scientific information and represent areas that could be exposed to tsunami hazards during a tsunami event. They are primarily based on inundation limits corresponding to a 975-year average return period tsunami event model. These limits have been extended to reflect potential local tsunami sources not considered in probabilistic analysis and are also modified to reflect the practical need to define limits that coincide with geographic features or city streets.

State of California, 2021, Tsunami Hazard Area Map, County name County; produced by the California Geological Survey, the California Governor's Office of Emergency Services, and AECOM; dated date on the map, mapped at multiple scales.

Organization: City of San Francisco
Bay Area Bike Share Stations

<strong>A. SUMMARY</strong>
This dataset contains datapoints on the location of bike share locations across the Bay Area.

<strong>B. HOW THE DATASET IS CREATED</strong>
This dataset is an extract from the MTA feature server.

<strong>C. UPDATE PROCESS</strong>
An extract is pulled from the MTA feature server on a weekly basis. A few fields are added such as data_loaded_at.

<strong>D. HOW TO USE THIS DATASET</strong>
Use this dataset to understand and locate the locations of bike share stations.

Tags: bike-share
Organization: City of San Francisco
Dam or Reservoir Failure Hazard Zone

This map shows the inundation hazard zones from dam and reservoir failure, based on modelling. The analysis was done by SFPUC in partnership with DEM and includes analysis of potential flooding from the following structures: Stanford heights - Agua Way and Teresita Blvd, Summit - La Avanzada St. and Palo Alto Ave., Sunset North - 28th ave and Ortega, Sunset South - 28th ave and Quintara, Sutro -  Clarendon ave and Olympia Way, University Mound North - University St and Bacon St., University Mound South - University St. and Bacon St.

Tags: geologic, hcr, reservoir-inundation-hazard-zones
Organization: City of San Francisco
Travel Decision Survey Data 2012

This workbook provides data and data dictionaries for the SFMTA 2012 Travel Decision Survey.
The 2012 Summary Report, with methodology and survey instrument, is located at https://www.sfmta.com/about-sfmta/reports/travel-decision-survey-2012.
Data, methodologies, and summary report for other SFMTA travel decision surveys are available on sfmta.com.
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. 
This dataset incorporates 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:
2012: October 2012 – January 2013
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
Campaign Finance - Summary of Third Party Disclosure Forms Regarding San Francisco Candidates - November 8, 2011 Election

San Francisco Campaign and Governmental Conduct Code ("S.F. C&GC Code") sections 1.143(c), 1.152(a)(3), 1.161(b), 1.161.5, and 1.160.5 require persons who make any independent expenditure, electioneering communication, or member communication that clearly identifies a candidate for City elective office or who authorizes, administers or pays for a persuasion poll to file disclosure statements with the Ethics Commission. For detailed instructions, please see Third Party Disclosure Form Regarding Candidates.

Tags: 2011, campaign, disclosure, election, finance, mayor, third-party
Organization: City of San Francisco
ARCHIVED: Mpox Vaccinations Given to SF Residents Over Time

<strong>In early February 2024, we will be retiring the Mpox Vaccinations Given to SF Residents Over Time dataset. This dataset will be archived and no longer update. A historic record of this data will remain available </strong>

<strong>A. SUMMARY </strong>
This dataset represents doses of mpox vaccine (JYNNEOS) administered in California to residents of San Francisco ages 18 years or older. This dataset only includes doses of the JYNNEOS vaccine given on or after 5/1/2022. All vaccines given to people who live in San Francisco are included, no matter where the vaccination took place.

<strong>B. HOW THE DATASET IS CREATED </strong>
Information on doses administered to those who live in San Francisco is from the  <a href="https://cdph.ca.gov/CAIR">California Immunization Registry (CAIR2)</a>, run by the California Department of Public Health (CDPH).

<strong>C. UPDATE PROCESS </strong>
Updated daily via automated process.

<strong>D. HOW TO USE THIS DATASET </strong>
Each row reflects the number of first, second, and total doses administered on that date and up through that date.

<strong>E. CHANGE LOG </strong>
<ul><li>UPDATE 1/3/2023: Due to low case numbers, this page will no longer include vaccinations after 12/31/2022.</li></ul>

Tags: monkeypox, mpx
Organization: City of San Francisco
Parking Management Districts

A. SUMMARY Boundaries of parking management districts, including SFpark pilot and control areas (different from meter rate area boundaries).

B. METHODOLOGY  Updated via the SFpark data warehouse

C. UPDATE FREQUENCY  These areas do not change over time. Very infrequently. 

D. OTHER CRITICAL INFO  These areas do not correspond to meter rate areas.

Tags: parking, parking-district, parking-management-district, pmd
Organization: City of San Francisco
Census 2020: Block Groups for San Francisco Clipped to the Shoreline

<strong>A. SUMMARY</strong>
Census blocks with Pacific Ocean and San Francisco Bay water clipped out. Census Block groups are the next level above census blocks in the geographic hierarchy. Block groups are a combination of census blocks that is a subdivision of a census tract.A block group consists of all census blocks whose numbers begin with the same digit in a given census tract; for example, block group 3 includes all census blocks numbered in the 300s. More information on the census tracts can be found <u><a href="https://www.census.gov/programs-surveys/geography/about/glossary.html#:~:text=Block%20Groups%20(BGs)%20are%20statistical,data%20and%20control%20block%20numbering.">here</a></u>.

<strong>B. HOW THE DATASET IS CREATED</strong>
The boundaries are uploaded from TIGER/Line shapefiles provided by the <u><a href="https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2021&layergroup=Block+Groups">U.S. Census Bureau</a></u> and clipped using the <u><a href="https://www.census.gov/cgi-bin/geo/shapefiles/index.php?year=2021&layergroup=Water">water boundaries</a></u> provided by the U.S. Census Bureau. 
 
<strong>C. UPDATE PROCESS</strong>
This dataset is static. Changes to the census blocks are tracked in multiple datasets. See here for <u><a href="https://data.sfgov.org/d/wymm-gfht">2000</a></u> census tract boundaries. 

<strong>D. HOW TO USE THIS DATASET</strong>
This boundary file can be joined to other census datasets on GEOID. Column descriptions can be found on in the <u><a href="https://www.census.gov/programs-surveys/geography/technical-documentation/complete-technical-documentation/tiger-geo-line.2020.html">technical documentation</a></u> included on the census.gov website


<strong>E. RELATED DATASETS</strong>
<u><a href="https://data.sfgov.org/d/tmph-tgz9">Census 2020: Census Tracts for San Francisco</a></u> 
 <u><a href="https://data.sfgov.org/d/sevw-6tgi">Analysis Neighborhoods - 2020 census tracts assigned to neighborhoods</a></u> 
 <u><a href="https://data.sfgov.org/d/p2fw-hsrv">Census 2020: Blocks for San Francisco</a></u>
 <u><a href="https://data.sfgov.org/d/e2st-aufe">Census 2020: Blocks for San Francisco Clipped to SF Shoreline</a></u>
 <u><a href="https://data.sfgov.org/d/24e8-pd2q">Census 2020: Blocks Groups for San Francisco</a></u>

Tags: census, census-block-group
Organization: City of San Francisco
Citywide Performance Measurement Annual Report FY14

CCSF Controller's Office manages the Citywide Performance Measurement Program that collects and reports performance data from 50 City departments. The dataset  contains over 1,100 performance measures, which are collected semi-annually.  Please see the accompanying data dictionary for more information.  Our website at www.sfgov.org/controller/performance provides additional details and contacts.

Tags: annual-dataset, city-departments, citywide-performance-measurement
Organization: City of San Francisco
100-year storm + 66 inches Sea Level Rise

This data originates from San Francisco Bay Conservation and Development Commission's Adapting to Rising Tides Program which performed extensive modelling of expected sea level rise impact across the entire 9-county bay area. This data shows inundation from 66 inches of sea level rise combined with a 100-year storm event (equaling 108 inches of total water level)

Tags: climate-change, hcr, sea-level-rise, slr
Organization: City of San Francisco
Transit Rail Signals maintainted by MTA

<strong>A. Summary </strong> 
Current inventory of transit rail signals maintained by Muni MOW.

<strong> B. METHODOLOGY</strong> 
Manual edits to Access database export. 

<strong>C. UPDATE FREQUENCY</strong>  
Updated as changes are made through SRC and Rail CCB.	 

<strong> D. OTHER CRITICAL INFO </strong> 
 n/a	

<strong> E. ATTRIBUTES </strong> 
CNN: The intersection associated with the signal;
STREET_1, _2, _3, _4: The cross streets nearest to the signal;
LOC: Whether the signal is at an intersection or at a midblock location;
LAT: Latitude in WGS-84;
LON: Longitude in WGS-84;
SIGNAL_TYPE: The type of signal (i.e. whether it shows ROW or a switch position);
SIGNAL_ID: The ID of the signal per Muni records;
LINE: Which lines use the signal, or if the signal is on a non-revenue track segment;
DIRECTION: If used for a line, whether it is the inbound or outbound track;
NO_ASPECTS: The number of aspects that comprise the signal;
ASPECT_1, _2, _3, _4, _5: A description of the aspects from top to bottom;
SIGNAL_HEAD_SIZE: The diameter of the signal head;
SRC_NO: The number for the latest SRC Work Order that concerns this signal;
DATE_SUBMITTED: The date that the SRC Work Order was submitted to the shop;
DATE_COMPLETED: The latest date that work was completed on this signal;Date_Last: Date of last edit

Organization: City of San Francisco
Tall Building Inventory

Inventory of tall buildings in San Francisco, focusing on attributes that are relevant to building performance during an earthquake or to post-earthquake recovery. Where possible, the attributes were collected from permitting documents at the Department of Building Inspections. As of October 1, 2018, this database includes a complete list of the 156 buildings taller than 240 ft, as well as another 24 buildings over 160 ft. For more information on the Tall Building Safety Strategy, see <a href="http://OneSanFrancisco.org/Resilient-SF" target="_blank" rel="nofollow external">http://OneSanFrancisco.org/Resilient-SF</a>. 

If you find any errors or emissions in this database, please contact us at <a href="mailto:cpp@sfgov.org?subject=Tall Buildings Database">cpp@sfgov.org</a>. For any other issues, please scroll down to "contact the dataset owner" on this page.

Tags: recovery, resilience
Organization: City of San Francisco
SFEC 143 - Requests by Candidates for Independent Determination of Filings - Filings

SFEC Form 143 is used by any candidate for Mayor or the Board of Supervisors.  Candidates seeking the same office as a candidate identified in a communication may object to the Executive Director’s determination of whether a communication reported on filings required under section 1.161, 1.162 or 1.163 actually supports or opposes a candidate or is neutral. Such requests must be filed within one business day from the date the Executive Director makes his or her determination. This dataset includes SFEC Form 143 filings as of March 4, 2020.

Organization: City of San Francisco
SFEC Form 3600 - Board And Commission Member Behested Payment Filings

Under San Francisco Campaign & Governmental Conduct Code Section 3.610, Members of City Boards and Commissions who are required to file a Form 700 are also required to file a Behested Payment report if they directly or indirectly request or solicit charitable contributions totaling $1,000 or more from any party, participant, or any agent of a party or participant involved in a proceeding regarding administrative enforcement, a license, a permit, or other entitlement for use before their Board or Commission. For more information visit www.sfethics.org.

The payors information on the form is also available in a parsed data table and can be joined using the DocuSign ID.  The payors table is available here:  https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-3600-Board-and-Commission-Member-Beheste/ibrg-quig

Tags: behested, board, commission, conflict-of-interest, contribution, ethics, member, payment, permit, permits
Organization: City of San Francisco