Aircraft Parking Location Inventory At SFO by US Government | Ecommerce and Consumer Trends

About this Dataset

Aircraft Parking Location Inventory At SFO

A. SUMMARY This data set contains the aircraft parking location information recorded by the Aircraft Parking System at SFO. The columns in the dataset include details such as Spot ID, Spot Name, Start Date, End Date, Type, Configuration, Category, Status, as well as the Creation and Modification Dates of the parking location record. On the 28th day of each month, this dataset is exported from the Aircraft Parking System at SFO. B. HOW THE DATASET IS CREATED When new aircraft parking locations are added to SFO, the new parking location data are added to the aircraft parking location table of the Aircraft Parking System. On the 28th day of each month, this dataset is replaced with all the records retrieved from the aircraft parking location table of the Aircraft Parking System at SFO. C. UPDATE PROCESS When modifications are made to the existing aircraft parking locations at SFO, the updated parking location data are reflected in the aircraft parking location table within the Aircraft Parking System. On the 28th day of each month, this dataset is replaced with all the records retrieved from the aircraft parking location table of the Aircraft Parking System at SFO. D. HOW TO USE THIS DATASET Use the following selection criteria to return a list of Spots for a given date: ((End Date is NOT NULL) AND ( (Start Date is on or earlier than the given date) and (given date is on or earlier than the End Date ) ) OR ((End Date is NULL) AND (Start Date is on or earlier than the given date)) E. RELATED DATASETS Aircraft Tail Numbers and Models at SFO Aircraft Parking Activity Records at SFO Utilize the Spot column from the "Aircraft Parking Activity Records at SFO" dataset to connect with the Spot Name column in the "Aircraft Parking Locations at SFO" dataset, for referencing the corresponding parking location record.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:06.268224

Tables

Table 1

@usgov.city_of_san_francisco_aircraft_parking_location_invent_d20e8bc1.table_1

16.75 KB
283 rows
12 columns


CREATE TABLE table_1 (
  "spot_id" BIGINT,
  "spot_name" VARCHAR,
  "start_date" VARCHAR,
  "end_date" VARCHAR,
  "type" VARCHAR,
  "configuration" VARCHAR,
  "category" VARCHAR,
  "status" VARCHAR,
  "creation_date" VARCHAR,
  "modification_date" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);