Data · dataset · 2018
SFO Ground Transport Day Permits
Listed in Restaurants Health Score Data in San Francisco
A. SUMMARY Operators that have received a short-term permit to operate commercial vehicles at SFO International Airport B. HOW THE DATASET IS CREATED The dataset originates from GTU source systems, where the raw data is initially ingested and stored in Amazon RDS.
Description
It is then transformed and standardized through an ETL pipeline, and subsequently loaded into Snowflake, where it is structured and optimized for reporting and analytics consumption.
C. UPDATE PROCESS The dataset is updated in real time as users create or modify records through the application. Changes are processed using an upsert mechanism, ensuring that new records are inserted and existing records are updated accordingly. D. HOW TO USE THIS DATASET This dataset is used to manage and analyze information about permit holders.
Read the rest (1 more)
It enables users to identify permit holders, associate them with their respective companies, and review classification types along with relevant timestamps. The data supports operational tracking, reporting, and auditing of permit holder records
Links
Get the data
- CSV data.sf.gov/api/views/htiq-28bt/rows.csv?accessType=DOWNLOAD ↗
download · from data sfgov org
Where it is published
- data.sf.gov /Transportation/SFO-Ground-Transport-Day-Permits/htiq-28bt ↗
Restaurants Health Score Data in San Francisco dataset page
landing page · from data sfgov org
Catalogue records · 1
- SODA API data.sf.gov/resource/htiq-28bt.json ↗
metadata API · from data sfgov org
Topics
- Stated by source
- Transportation
- From keywords
- Engineering
Related
- Possibly the same asSFO Ground Transport Day Permits
Provenance · 1 source records, 9 field assertions
| Source | Key | Last seen | Raw |
|---|---|---|---|
| Restaurants Health Score Data in San Francisco | htiq-28bt | 11 d ago | JSON v1 |
| Field | Assertion | Extractor | Evidence |
|---|---|---|---|
| access_level | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| concepts[field].local:field:engineering | mapping · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| concepts[topic].socrata_category:data_sfgov_org:transportation | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| created_date | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| description | source · data sfgov org | connector:data_sfgov_org@1.0.0 | /resource/description |
| license | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| publication_date | source · data sfgov org | connector:data_sfgov_org@1.0.0 | |
| title | source · data sfgov org | connector:data_sfgov_org@1.0.0 | /resource/name |
| updated_date | source · data sfgov org | connector:data_sfgov_org@1.0.0 |