About this Dataset

Aircraft Noise Reports

A. SUMMARY This dataset consists of San Francisco International Airport (SFO) aircraft noise reports and if available, the correlated flight operation’s details for those reports. B. HOW THE DATASET IS CREATED SFO Noise Office collects this information via the WebTrak, Web, App, Complaint Hotline, emails, letters, and telephone calls to our office. This information is compiled and published in a monthly report which is presented at the SFO Airport Community Roundtable meetings (https://sforoundtable.org/). It serves to help understand community's aircraft noise concerns, to collaborate with all stakeholders in an effort to reduce and manage aircraft noise. C. UPDATE PROCESS Data is available starting in August 2019 and will be updated on a monthly basis. D. HOW TO USE THIS DATASET This data is the data source used to produce the Noise Reports section on page 5 of the monthly Airport Director’s Report. These reports are available online at https://www.flysfo.com/about/community-noise/noise-office/reports/airport-directors-report E. RELATED DATASETS Previously provided data, Aircraft Noise Complaint Data, from January 2005 to July 2019 is available here: https://data.sfgov.org/Transportation/Aircraft-Noise-Complaint-Data/q3xd-hfi8 Please contact the Noise Abatement Office at NoiseAbatementOffice@flysfo.com for any questions regarding this data.
Organization: City of San Francisco
Last updated: 2023-07-01T14:49:47.780069

Tables

Table 1

@usgov.city_of_san_francisco_aircraft_noise_reports.table_1

124.4 MB
6,716,608 rows
14 columns

CREATE TABLE table_1 (
  "disturbance_date_time" VARCHAR,
  "report_method" VARCHAR,
  "corr_id" BIGINT,
  "reporter_city" VARCHAR,
  "reporter_postal_code" VARCHAR,
  "aircraft_pca_altitude" DOUBLE,
  "airport_id" VARCHAR,
  "operation_type" VARCHAR,
  "runway_name" VARCHAR,
  "flight_no" VARCHAR,
  "aircraft_type" VARCHAR,
  "destination_origin" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);