This page provides a guide to the BigQuery tables used for training models, including their schemas and field descriptions. You'll also find a breakdown of the core concepts—snapshots, assets, and observations—that structure the data, along with details on how to use the tables where relevant.
snapshots
A snapshot is a fixed, unchangeable copy of a dataset at a specific moment in time. The snapshot table provides metadata associated with snapshots, to allow you to understand the temporal state of the data at a high level.
| Column name | Type | Description |
|---|---|---|
snapshot_id |
STRING | Unique identifier for the snapshot. Used as a key to join tables. |
subscription_id |
STRING | Unique identifier for the subscription. |
creation_time |
TIMESTAMP |
Timestamp of when the snapshot was first created. ISO 8601 formatted timestamp e.g., 2019-09-25 17:26:27.757171 UTC.
|
all_observations
An "observation" is a detection of an asset in the real world. Observations differ from assets in that they contain metadata for the detection of an asset, i.e., the time the image was captured and the position of the camera.
The all_observations table provides observations from all snapshots. You can
use this table to detect differences in observations between snapshots.
| Column name | Type | Description |
|---|---|---|
observation_id |
STRING | String that uniquely identifies the observation. |
snapshot_id |
STRING | Unique identifier for the snapshot which collected this observation. |
asset_id |
STRING | Unique identifier for the asset associated with this observation. |
asset_type |
STRING | Major classification of the asset. Valid values are ASSET_CLASS_ROAD_SIGN and ASSET_CLASS_UTILITY_POLE. |
location |
STRUCT | Struct containing lat/lng coordinates as floats. |
capture_time |
TIMESTAMP |
Timestamp of when the observation was first captured. ISO 8601 formatted timestamp e.g., 2019-09-25 17:26:27.757171 UTC.
|
detection_time |
TIMESTAMP |
Timestamp of when the asset was first detected. ISO 8601 formatted timestamp e.g., 2019-09-25 17:26:27.757171 UTC.
|
bbox |
STRUCT | Struct of structs containing the x/y coordinates aligning the asset's bounding box. |
camera_pose |
STRUCT | The position of the camera LLA and Euler angles. Struct containing floats for lat/lng, altitude (in meters), pitch, heading, and roll. |
gcs_uri |
STRING | Google Cloud Storage URI where the image is hosted. |
map_url |
STRING | Google Maps URL that shows the location of the observation. |
all_assets
An "asset" is an object in the real world. The all_assets table provides
assets from all snapshots. You can use this table to detect differences in
assets between snapshots.
| Column name | Type | Description |
|---|---|---|
asset_id |
STRING | Unique identifier for the asset associated with this observation. |
snapshot_id |
STRING | Unique identifier for the snapshot which collected this observation. |
asset_type |
STRING | Major classification of the asset. Valid values are ASSET_CLASS_ROAD_SIGN and ASSET_CLASS_UTILITY_POLE. |
observation_id |
STRING | String that uniquely identifies the observation. |
location |
STRUCT | Struct containing lat/lng coordinates as floats. |
detection_time |
TIMESTAMP |
Timestamp of when the asset was first detected. ISO 8601 formatted timestamp e.g., 2019-09-25 17:26:27.757171 UTC.
|
latest_observations
The latest_observations table provides observations only from the most recent
snapshot.
| Column name | Type | Description |
|---|---|---|
observation_id |
STRING | String that uniquely identifies the observation. |
snapshot_id |
STRING | Unique identifier for the snapshot which collected this observation. |
asset_id |
STRING | Unique identifier for the asset associated with this observation. |
asset_type |
STRING | Major classification of the asset. Valid values are ASSET_CLASS_ROAD_SIGN and ASSET_CLASS_UTILITY_POLE. |
location |
STRUCT | Struct containing lat/lng coordinates as floats. |
capture_time |
TIMESTAMP |
Timestamp of when the observation was first captured. ISO 8601 formatted timestamp e.g., 2019-09-25 17:26:27.757171 UTC.
|
detection_time |
TIMESTAMP |
Timestamp of when the asset was first detected. ISO 8601 formatted timestamp e.g., 2019-09-25 17:26:27.757171 UTC.
|
bbox |
STRUCT | Struct of structs containing the x/y coordinates aligning the asset's bounding box. |
camera_pose |
STRUCT | The position of the camera LLA and Euler angles. Struct containing floats for lat/lng, altitude (in meters), pitch, heading, and roll. |
gcs_uri |
STRING | Google Cloud Storage URI where the image is hosted. |
map_url |
STRING | Google Maps URL that shows the location of the observation. |
latest_assets
The latest_assets table provides assets only from the most recent snapshot.
| Column name | Type | Description |
|---|---|---|
asset_id |
STRING | Unique identifier for the asset associated with this observation. |
snapshot_id |
STRING | Unique identifier for the snapshot which collected this observation. |
asset_type |
STRING | Major classification of the asset. Valid values are ASSET_CLASS_ROAD_SIGN and ASSET_CLASS_UTILITY_POLE. |
observation_id |
STRING | String that uniquely identifies the observation. |
location |
STRUCT | Struct containing lat/lng coordinates as floats. |
detection_time |
TIMESTAMP |
Timestamp of when the asset was first detected. ISO 8601 formatted timestamp e.g., 2019-09-25 17:26:27.757171 UTC.
|