Aircraft Parking Location Inventory at SFO
Description
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.
Resources
| Name |
Format |
Description |
Link |
|
8 |
|
https://data.sfgov.org/api/views/2ymc-znns/rows.csv?accessType=DOWNLOAD |
|
40 |
|
https://data.sfgov.org/api/views/2ymc-znns/rows.rdf?accessType=DOWNLOAD |
|
23 |
|
https://data.sfgov.org/api/views/2ymc-znns/rows.json?accessType=DOWNLOAD |
|
55 |
|
https://data.sfgov.org/api/views/2ymc-znns/rows.xml?accessType=DOWNLOAD |