AndreaBozzo/ceres-open-data-index huggingface dataset:
SFEC Campaign Consultant Report - Clients

<strong>A. SUMMARY</strong>
This dataset contains information about the clients section of the Campaign Consultant Report.

For more information, visit the Ethics Commission’s webpage on <a href="https://sfethics.org/guidance/campaign-consultants">Campaign Consultants</a>.

<strong>B. HOW THE DATASET IS CREATED</strong>
Data for this dataset is created when campaign consultants electronically file the following reports with client information: 

Form 1 – Registration Report
Form 3 – Quarterly Disclosure Report for Campaign Consultants
Form 6 – Campaign Consultant Termination Statement

This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required.

<strong>C. UPDATE PROCESS</strong>
The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants.

<strong>D. HOW TO USE THIS DATASET</strong>
The unique row identifier for a client entry is “Entry Id”. This dataset should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”.

<strong>E. RELATED DATASETS</strong>
For detail reporting on campaign consultant activities, visit <a href="https://data.sfgov.org/City-Management-and-Ethics/SFEC-Campaign-Consultant-Report/iv34-5p9x/about_data">SFEC Campaign Consultant Report</a>.

Organization: City of San Francisco
SF County Line 2020 Reestablishment

<strong>A. SUMMARY</strong>
This dataset represents the surveyed southerly boundary of San Francisco County. It is intended to provide a visual reference of the county line based on an official Record of Survey. The dataset is not a legal boundary layer, but rather a graphical depiction to support general understanding and mapping applications.

<strong>B. HOW THE DATASET IS CREATED</strong>
The dataset was derived from CAD files prepared in support of Record of Survey #9999, which was prepared and filed jointly by the San Francisco and San Mateo County Surveyors. The CAD geometry was converted into GIS format (shapefile), preserving the alignment and positional intent of the surveyed boundary as shown on the recorded survey.

<strong>C. UPDATE PROCESS</strong>
This dataset is static and reflects the conditions documented in the recorded survey as of June 26, 2020. Updates would only occur if a new Record of Survey or other authoritative legal document supersedes the existing survey. Any such updates should follow the same process: derive geometry from the official survey record and document the source clearly.

<strong>D. HOW TO USE THIS DATASET</strong>
Intended for reference and visualization purposes only, such as mapping and planning, this dataset does not constitute a boundary determination and must not be used for property location or any legal purpose. The authoritative source is the Record of Survey, Document No. 2020944699, filed June 26, 2020, with the San Francisco Assessor-Recorder. In the event of any discrepancy, the recorded survey shall control.

<strong>F. KNOWN USES </strong>
This dataset is commonly used for mapping, visualization, and general planning purposes where a representation of the San Francisco County boundary is needed. It may support web maps, internal city applications, and reference mapping, but is not suitable for legal, surveying, or property boundary determination.

Organization: City of San Francisco
SFEC Campaign Consultant Report - Employees

<strong>A. SUMMARY</strong>
This dataset contains information about the employees section of the Campaign Consultant Report.

For more information, visit the Ethics Commission’s webpage on <a href="https://sfethics.org/guidance/campaign-consultants">Campaign Consultants</a>.

<strong>B. HOW THE DATASET IS CREATED</strong>
Data for this dataset is created when campaign consultants electronically file the following reports with employee information: 

Form 1 – Registration Report
Form 2 – Re-registration Report

This dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required.

<strong>C. UPDATE PROCESS</strong>
The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants.

<strong>D. HOW TO USE THIS DATASET</strong>
The unique row identifier for an employee entry is “Entry Id”. This data set should be joined with the SFEC Campaign Consultant Report dataset by “Envelope Id”.

<strong>E. RELATED DATASETS</strong>
For detail reporting on campaign consultant activities, visit <a href="https://data.sfgov.org/City-Management-and-Ethics/SFEC-Campaign-Consultant-Report/iv34-5p9x/about_data">SFEC Campaign Consultant Report</a>.

Organization: City of San Francisco
Air Traffic Landings Statistics

<strong>A. SUMMARY</strong>
This dataset consists of San Francisco International Airport (SFO) The aircraft landing dataset contains data about aircraft landings at SFO with monthly landing counts and landed weight by airline, region and aircraft model and type.  

<strong>B. HOW THE DATASET IS CREATED</strong>
Data is self-reported by airlines and is only available at a monthly level. 

<strong>C. UPDATE PROCESS</strong>
Data is available starting in July 1999 and will be updated monthly.


<strong>D. HOW TO USE THIS DATASET</strong>
Airport data is seasonal in nature; therefore, any comparative analyses should be done on a period-over-period basis (i.e. January 2010 vs. January 2009) as opposed to period-to-period (i.e. January 2010 vs. February 2010). It is also important to note that fact and attribute field relationships are not always 1-to-1. For example, Cargo Statistics belonging to United Airlines will appear in multiple attribute fields and are additive, which provides flexibility for the user to derive categorical Cargo Statistics as desired.  

<strong>E. RELATED DATASETS</strong>
A summary of monthly comparative air-traffic statistics is also available on SFO’s internet site at

https://www.flysfo.com/about/media/facts-statistics/air-traffic-statistics

Tags: airlines, airport, flights, landings, sfo
Organization: City of San Francisco
SFMTA General Transit Feed Specification (GTFS) Production

This file contains SFMTA transit stop and schedule data in the <a href="https://gtfs.org/">General Transit Feed Specification (GTFS) format</a>, which is an open data standard. The SFMTA publishes new transit schedules in this format as soon as schedule changes are planned and finalized, which occurs at least quarterly (and usually more often).

For our legal protection, you'll need to agree to the SFMTA Transit Data License Agreement in order to use it. 

Note: This is not real-time data, only scheduled service. For more regional routes and schedules (as well as real-time data) in the GTFS format please see the <a href="https://511.org/open-data/transit">MTC's Portal for Open Transit Data</a>.

Tags: gtfs, transit
Organization: City of San Francisco
Nighttime High Power Run-ups

<strong>A.	SUMMARY</strong>
This dataset shows the amount of nighttime engine high power run-ups from 10:00 p.m. to 7:00 a.m. by air carrier operations using jet and regional jet aircraft.  Power run-up activities are conducted at designated locations on the airfield, furthest from residential communities, and monitored by SFO to manage nighttime noise. A power run-up is a procedure used to test an aircraft engine or aircraft system after maintenance or repair is performed. The aircraft engines' throttle settings can range from ground idle to high power and the length of the operational checks may vary in duration. These checks are required to ensure normal operating standards are met, prior to returning the aircraft to service.

<strong>B.	HOW THE DATASET IS CREATED</strong>
Details of each power run-up are logged into the Airport Operations System. It serves to help quantify, analyze, and report on power run-up activities in support of programs to reduce aircraft noise in communities surrounding SFO.

<strong>C.	UPDATE PROCESS</strong>
Data is available starting in January 2005 and will be updated monthly.

<strong>D.	HOW TO USE THIS DATASET</strong>
This information is the data source used in producing the Nighttime Power Run-ups section (page 4) of the Airport Director’s Reports. These reports are presented at the SFO Airport Community Roundtable Meetings and available online at https://noise.flysfo.com/reports/?category=airport-directors-report

Please contact the Noise Abatement Office at NoiseAbatementOffice@flysfo.com for any questions regarding this data.

<strong>E.	RELATED DATASETS</strong>
Other related datasets are Aircraft Noise Reports, Late Night Aircraft Departures, Runway Usage, Flight Operations, Aircraft Noise Climates, and Noise Exceedance Rating.

Data is available starting in January 2005 and will be updated monthly.

Tags: aircraft, airport, complaints, engine-runs, noise, sfo
Organization: City of San Francisco
Noise Exceedance Rating

Counts of airline operations that incur noise exceeding threshold by airline and by month. The Aircraft Noise Abatement Office collects this data using an Airport Noise and Operations Management System. It is collected using remote noise monitor sites in the communities surrounding SFO. This data is collected to monitor and grade airlines' performance as part of SFO's Fly Quiet Program.

Tags: aircraft, airlines, airport, noise, sfo
Organization: City of San Francisco
SFEC Form 113 - Important Notice for Initiative, Recall and Referendum Petitions - Filings

The proponent of any petition that is circulated to qualify a measure for the ballot must inform the Ethics Commission that the proponent has begun to circulate the petition.  The notification must occur within one business day of the first date that the petition is circulated.  This dataset contains electronic notification filings starting February 26, 2020.

Organization: City of San Francisco
SFO Flight Operations

<strong>A. SUMMARY</strong>
San Francisco International Airport (SFO) keeps track of historical flight operations, also known as aircraft RADAR data for analysis and reporting.

<strong>B. HOW THE DATASET IS CREATED</strong>
Details of flights from the Federal Aviation Administration’s National Offload Program are processed into SFO’s Airport Noise and Operations Management System (ANOMS) where it is correlated with noise reports from the communities and to noise levels collected from noise monitor sites on the San Francisco Peninsula. In ANOMS, various analysis gates (imaginary vertical curtain in space) are used to identify which route flights flew departing and arriving SFO. It serves to quantify, analyze, respond to noise concerns, and report on Runway Use and various programs to reduce aircraft noise in communities surrounding SFO.

<strong>C. UPDATE PROCESS</strong>
Data is available starting in August 2019 and will be updated monthly.

<strong>D. HOW TO USE THIS DATASET</strong>
It is important to note, that this dataset is of flights departing and landing at SFO only and not flight activities associated with other airports in the Bay Area region. This information is the data source used to produce the Flight Operations sections (pages 3-5) of the Airport Director’s Report. These reports are presented at the SFO Airport Community Roundtable Meetings and available online at https://noise.flysfo.com/reports/?category=airport-directors-report

<strong>E. RELATED DATASETS</strong>
<a href="https://data.sfgov.org/d/c3tb-f695">Unique Flight Operations</a> - This filtered view contains unique records of flight operations. For example, one record for a flight that departed SFO or one record for a flight that landed at SFO.

<a href="https://data.sfgov.org/d/k3hb-m3dm">Arrival and Departure Routes</a> - This filtered view contains records of flights with details of analysis gate(s) the aircraft flight track penetrates, to derive which route was used to depart and land at SFO.

This dataset contains Operations and Arrival and Departure Routes joined on operation_number.  The field gate_penetration is derived by ordering the arrival and departure routes for each operation over gate_penetration_time. Unique_identifier is then created by joining operation_number and gate_penetration.

Other provided datasets are Aircraft Noise Reports, Late Night Aircraft Departures, Air Carrier Runway Use, and Late Night Preferential Runway Use, Aircraft Noise Climates, and Noise Exceedance Rating.

Please contact the Noise Abatement Office at NoiseAbatementOffice@flysfo.com for any questions regarding this data.

Date created: November 17, 2023

Organization: City of San Francisco
Runway Usage

<strong>A.	SUMMARY</strong>
This information shows SFO’s Nighttime Preferential Runway Use program and air carrier operations using jet and regional aircraft. The Nighttime Preferential Runway Use program aims to maximize overwater departures and minimize flights over residential areas between 1:00 a.m. and 6:00 a.m. to reduce aircraft noise in surrounding communities. The preferred departing runways during these hours are Runways 10 Left (10L) / 10 Right (10R), 1 Left (1L) / 1 Right (1R), or 28 Left (28L) / 28 Right (28R) with an immediate right-turn; when safety, weather, and traffic operations permit. Although the program cannot be used 100% of the time due to these factors, all stakeholders work together to maximize its use when conditions allow. This dataset also provides air carrier total monthly departures and monthly arrivals by runway, along with percent utilization. 

<strong>B.	HOW THE DATASET IS CREATED</strong>
Details of flights from the Federal Aviation Administration’s National Offload Program are processed into SFO’s Airport Noise and Operations Management System (ANOMS) where reports are generated. It serves to quantify, analyze, and report on runway usage in support of programs to help reduce aircraft noise in communities surrounding SFO.

<strong>C.	UPDATE PROCESS</strong>
Data is available starting in January 2005 and will be updated monthly.

<strong>D.	HOW TO USE THIS DATASET</strong>
This information is the data source used in producing the Runway Usage and Nighttime Operations sections (page 4) of the Airport Director’s Reports. These reports are presented at the SFO Airport Community Roundtable Meetings and available online at https://noise.flysfo.com/reports/?category=airport-directors-report

Please contact the Noise Abatement Office at NoiseAbatementOffice@flysfo.com for any questions regarding this data.

<strong>E.	RELATED DATASETS</strong>
Other related datasets are Aircraft Noise Reports, Late Night Aircraft Departures, Flight Operations, Aircraft Noise Climates, and Noise Exceedance Rating.

Date created: September 27, 2023

Organization: City of San Francisco
Neighborhoods_2012b

Neighborhood boundaries in Chicago, as developed by the Office of Tourism. These boundaries are approximate and names are not official. The data can be viewed on the Chicago Data Portal with a web browser. However, to view or use the files outside of a web browser, you will need to use compression software and special GIS software, such as ESRI ArcGIS (shapefile) or Google Earth (KML or KMZ), is required.

Tags: boundaries, gis, shapefiles
Organization: City of Chicago
Libraries - 2026 Holds Filled by Location

This data is for materials pulled to fulfill patron holds. Chicago Public Library consists of the Harold Washington Library Center, Sulzer, Legler and Woodson regional libraries and over 70 neighborhood branches. Many locations experience sporadic closures to perform facilities upgrade or emergency closures due to heating or air conditioning issues, or area power outages.

Tags: 2026, holds-filled, libraries
Organization: City of Chicago
Libraries - 2026 WiFi Usage

The Chicago Public Library offers free WiFi at all locations. Chicago Public Library consists of the Harold Washington Library Center, Sulzer, Legler and Woodson regional libraries and over 70 neighborhood branches. Many locations experience sporadic closures to perform facilities upgrade or emergency closures due to heating or air conditioning issues, or area power outages.

Tags: 2026, libraries, wi-fi
Organization: City of Chicago
CTA-L-Rail-Stations-Shapefile

Point data representing location of CTA Rail Station. To view or use these files, compression software and special GIS software, such as ESRI ArcGIS is required. Projected Coordinate System: NAD_1983_StatePlane_Illinois_East_FIPS_1201_Feet

Tags: cta, gis, public-transit, rail, transportation
Organization: City of Chicago
Financial Incentive Projects - TIF Works

TIFWorks data includes all projects that have been completed and received a grant payment since January, 2011. TIFWorks stimulates business success by funding workforce-training costs for companies located in tax increment financing (TIF) districts. With TIFWorks support, businesses can become better equipped to improve performance and productivity, expand product lines and gain new customers.

Tags: financial, financial-incentive, incentive, tif, tif-works
Organization: City of Chicago
Libraries - 2026 Computer Sessions by Location

he Chicago Public Library offers one-hour computer sessions and 15-minute computer sessions. Chicago Public Library consists of the Harold Washington Library Center, Sulzer, Legler and Woodson regional libraries and over 70 neighborhood branches. Many locations experience sporadic closures to perform facilities upgrade or emergency closures due to heating or air conditioning issues, or area power outages.

Tags: 2026, computer-sessions, libraries
Organization: City of Chicago
311 Service Requests - Tree Trims - Historical

As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only.

All open and completed tree trim requests made to 311 since January 1, 2011. The Department of Streets and Sanitation maintains all trees growing in the public way and performs regular maintenance trimming in response to 311 requests. Crisis trimming is performed on an emergency basis in response to hazardous conditions such as broken or hanging branches. Requests that have been labeled as Duplicates are in the same geographic area and have been entered into 311’s Customer Service Requests (CSR) system at around the same time as a previous request. Duplicate requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.

Tags: 311, historical, service-requests, trees
Organization: City of Chicago
COVID-19 Wastewater Detection - Historical

As described in https://data.cityofchicago.org/stories/s/sihu-d8va, the function of this dataset was replaced by https://data.cityofchicago.org/d/4tzt-ir6h. This dataset is historical-only.

Concentrations of the SARS-CoV-2 virus (the COVID-19 virus) gene in the Chicago sewer system, as measured at eight sewershed sites. These sites represent catchment areas that describe wastewater from 319,700 Chicagoans as of January 2023.

Because SARS-CoV-2 is shed in human feces, this method can be used to estimate changes in COVID-19 at different times and locations across Chicago. While the data in this dataset do not indicate how many people were infected with SARS-CoV-2, differences in the the normalized_n1 indicate whether the proportion of individuals at the site who are shedding that virus has changed.

Tags: covid-19, health, historical, public-health, sanitation, testing
Organization: City of Chicago
CTA - Ridership - 'L' Station Entries - Monthly Day-Type Averages & Totals

This dataset lists monthly station entry averages, by day type (Weekday, Saturday or Sunday/Holiday), as well as monthly totals, beginning in 2001. Note that some stations (such as on the Cermak Branch--now Pink Line) and Skokie did not have Saturday and/or Sunday/holiday service until more recent years, although, in cases where weekday service ran past midnight, late evening fares may appear as part of Saturday tallies.

Tags: cta, public-transit, ridership
Organization: City of Chicago
311 Service Requests - Alley Lights Out - Historical

As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only.

This dataset contains all open 311 reports of one or more lights out on a wooden pole in the alley and all completed requests since January 1, 2011.  If two requests regarding the same address are made within 30 calendar days of each other, the newest CSR is automatically given the status of “Duplicate (Open)”.   Once the alley light is repaired, the CSR status will read “Completed” for the original request and “Duplicate (Closed)” for any duplicate requests. Data is updated daily.

Tags: 311, alleys, historical, lights, service-requests, streets
Organization: City of Chicago
Financial Incentive Projects - Neighborhood Opportunity Fund (NOF) Small

Neighborhood Opportunity Fund, Small Project data includes all projects that have received a final grant payment. Small Projects may have grants up to $250,000 and must be located in an Eligible Commercial Corridor. The Neighborhood Opportunity Fund (“NOF”) receives funds from downtown development in order to support the growth and creation of inclusively vibrant commercial corridors in Chicago’s underserved neighborhoods. Business and property owners may apply for grant funding that will pay for the development or rehabilitation of real estate and projects that support new or expanding businesses or cultural assets.

Tags: financial, financial-incentive, incentive, nof
Organization: City of Chicago