public-data-docs

Table: PHYSICAL_STATION_PARKING_AREAS

Description:

The parking area belonging to a physical station — the polygon describing where vehicles may be parked, together with its capacity.

Each row links to exactly one physical station, and station_id is unique at source, so today this is effectively one parking area per physical station. Do not assume a station can carry several areas without re-checking.

🔑 Primary Key

id

Field Name Data Type Description
id NUMBER Unique identifier for the parking area.
area GEOMETRY Polygon describing the parking area.
capacity NUMBER Number of vehicles the parking area can hold.
station_id NUMBER Foreign key to the physical station this area belongs to. Unique — one area per station.
created_at TIMESTAMP_TZ Creation timestamp.
updated_at TIMESTAMP_TZ Last update timestamp.
created_by NUMBER Identifier of the user who created the parking area.
updated_by NUMBER Identifier of the user who last updated the parking area.
_snowflake_inserted_at TIMESTAMP_NTZ Timestamp when the record was inserted into Snowflake.
_snowflake_updated_at TIMESTAMP_NTZ Timestamp when the record was last updated in Snowflake.
_snowflake_deleted BOOLEAN True if the record was deleted in the source.

Related tables