public-data-docs

Table: PHYSICAL_STATIONS

Description:

Represents real-world station infrastructure — physical bays, docks and parking locations where vehicles are picked up or returned. Each physical station belongs to a branch and carries a geographic point, opening information, contact details and images.

Not the same as STATIONS. STATIONS models virtual and logical stations (geofenced pick-up/drop-off zones, docking, recommended and promotion stations) and is legitimately empty for operators who do not use them. PHYSICAL_STATIONS models the physical infrastructure itself. If you are looking for parking bays, this is the table you want. The two are independent — an operator may use either, both, or neither.

🔑 Primary Key

id

Field Name Data Type Description
id NUMBER Unique identifier for the physical station.
name TEXT Human-readable name of the physical station.
state TEXT Operational state of the physical station. Stored as a string label at source, so — unlike most enum fields — it has no companion state_name column.
position GEOMETRY Geolocation (point) of the physical station.
description TEXT Free-text description of the physical station.
opening_information VARIANT Structured opening hours / availability information.
contact_info VARIANT Structured contact information for the physical station.
images VARIANT Structured list of image references for the physical station.
branch_id NUMBER Foreign key to the branch the physical station belongs to.
created_at TIMESTAMP_TZ Creation timestamp.
updated_at TIMESTAMP_TZ Last update timestamp.
created_by NUMBER Identifier of the user who created the physical station.
updated_by NUMBER Identifier of the user who last updated the physical station.
_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