SFO Permitted Ground Transport Commercial Vehicles
Published by data.sf.gov
About this dataset
A. SUMMARY Permitted commercial vehicles that operate at SFO. 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. 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 track and manage records of commercial vehicles, including their operational status, ownership, and key characteristics. It enables users to monitor vehicle information such as type, fuel classification, and associated operators, supporting operational oversight and reporting