| description:
|
<DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 11 0;"><SPAN>Access transport sensor count data here:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Metadata info - https://gis-snowflake-opendata-public-wcc-arcgis-prod.s3.ap-southeast-2.amazonaws.com/transport_sen…</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>2023 - https://gis-snowflake-opendata-public-wcc-arcgis-prod.s3.ap-southeast-2.amazonaws.com/transport_sen…</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>2024 - https://gis-snowflake-opendata-public-wcc-arcgis-prod.s3.ap-southeast-2.amazonaws.com/transport_sen…</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>2025 - https://gis-snowflake-opendata-public-wcc-arcgis-prod.s3.ap-southeast-2.amazonaws.com/transport_sen…</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>File Listing - https://gis-snowflake-opendata-public-wcc-arcgis-prod.s3.ap-southeast-2.amazonaws.com/</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN>Intended Purpose:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>This data source is created to provide access to data from transport sensors installed in Wellington city, which measure transport counts and help analyse how people move around the city.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN>Abbreviations/Acronyms:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>WCC: Wellington City Council</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>API: Application Programming Interface</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN>Refresh Rate: The dataset will be refreshed no less than once per calendar month.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Data Security : Public</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Ownership: Digital Innovation team, WCC. Please contact: digitalinnovation@wcc.govt.nz for questions or feedback about this data.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Custodianship: Corporate GIS team, WCC.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Stewardship: City Insights team, WCC. </SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Authoritative Data Source (Data only): The primary source of data is from VivaCity Labs, which provides a dashboard and application programming interface (API) for collected data.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN>Outling Limitations of Data:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>This dataset provides valuable insights into transport activity over time, but there are a few limitations to keep in mind:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>While sensors are designed to be highly accurate, they may still produce occasional discrepancies due to technical faults, environmental conditions, or other external factors. The data is best used to understand patterns and trends rather than precise counts.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Work is underway to improve how data accuracy is monitored, resolved, and presented on the Open Data Portal.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Temporary gaps may appear due to sensor outages or scheduled maintenance.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>If data for one direction of a countline appears blank, it means that the countline is configured to count in only one direction.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>In locations where multiple sensors or countlines are close together, a single commuter may be counted more than once as they pass through each countline. Users should refer to the spatial layout provided in this layer to interpret the data accurately.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Sensors vary in installation dates, resulting in different data collection start points.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Historic data collected from old or inactive sensors may be excluded from the historic datasets.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN>Data Dictionary:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>1. Dimension/Look-Up Table</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Countline Meta Info - This model processes and enriches countline metadata by calculating the bearing and direction of lines based on their start and end coordinates. It provides relevant compass directions for each line, which can be used for navigation or spatial analysis.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN>Fields:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>countline_id - A unique identifier for each countline.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>name - The name of the countline, indicating generic location of countline.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>latitude_start_line - The latitude coordinate where the countline starts.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>longitude_start_line - The longitude coordinate where the countline starts.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>latitude_end_line - The latitude coordinate where the countline ends.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>longitude_end_line - The longitude coordinate where the countline ends.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>direction_in - The compass direction of the countline when moving toward the sensor’s view.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>direction_out - The compass direction of the countline when moving away from the sensor’s view.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>earliest - The earliest date when the countline was recorded.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>latest - The latest date when the countline was recorded. An older date may indicate that the countline is inactive or no longer in use.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN /></P><P STYLE="margin:0 0 11 0;"><SPAN>2. Count Dataset - This dataset aggregates mobility data from different countline sources, providing a comprehensive view of traffic flow and directionality.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Fields:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>countline_id - A unique identifier for each countline.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>countline_transport_class* - Classification of the transport modes, indicating the type of traffic being measured.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>countline_date - The date when the countline data was recorded.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>countline_hour - The hour of the day when the countline data was recorded.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>direction_count - The total count of traffic in a specific direction during the hour.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>direction - Normalised direction label, indicating the flow of traffic, as follows:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> N: North</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> NE: North East</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> E: East</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> SE: South East</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> S: South</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> SW: South West</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> W: West</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> NW: North West</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Countline transport classes</SPAN></P><TABLE><TBODY><TR><TD><P STYLE="font-weight:bold;margin:0 0 0 0;"><SPAN><SPAN>Wellington Transport Class</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN STYLE="font-weight:bold;"><SPAN>Description</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Pedestrian</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>People on foot</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Cyclist</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>People on any type of bikes</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Escooter</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Electric scooters</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Motorbike</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Motorbike</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Car</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Small passenger vehicles including car, taxi, and emergency car.</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>LGV</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>LGV (Light Goods Vehicle) includes van and emergency van.</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Bus</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>All types of buses and minibuses</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>OGV1</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>OGV 1 (Ordinary Goods Vehicle 1). Larger vehicles with two or three axles. Includes Rigid and Fire Engine in Wellington context.</SPAN></SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>OGV2</SPAN></SPAN></P></TD><TD><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>OGV 2 (Ordinary Goods Vehicle 2). Includes truck in Wellington context.</SPAN></SPAN></P></TD></TR></TBODY></TABLE><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;"><SPAN>Countline Directionality and Data Inclusions</SPAN></SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>Countline data can be recorded in two directions (in and out) to capture movement across a countline location. In certain cases, only one direction is relevant. For example, if a countline is located on a one-way street, only the direction that aligns with traffic flow may be included in the dataset.</SPAN></SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>This directionality inclusion is reflected in the Countline Meta Info columns:</SPAN></SPAN></P><UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>direction_in and direction_out indicate the compass direction of movement. </SPAN></SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>If a direction is excluded, the corresponding column will show no compass direction, signalling that data for that direction is not part of the countline record.</SPAN></SPAN></P></LI></UL><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>This approach ensures that the dataset accurately represents valid transport movements and avoids misleading counts for irrelevant directions. </SPAN></SPAN></P><OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="margin:0 0 11 0;"><SPAN /></P></LI></OL><P><SPAN /></P></DIV></DIV></DIV> |