Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;">Intended Purpose: </SPAN><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 across the city. </SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;">Abbreviations/Acronyms:</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>WCC: Wellington City Council</SPAN></SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>API: Application Programming Interface</SPAN></SPAN></P><P STYLE="font-weight:bold;margin:0 0 11 0;"><SPAN>Refresh Rate (Data only): </SPAN><SPAN>The dataset will be refreshed no less than once per calendar month.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;">Ownership: </SPAN><SPAN>This data is owned by the WCC’s Smart Council Business Unit. Please contact: digitalinnovation@wcc.govt.nz for questions or feedback about this data source.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;">Stewardship: </SPAN><SPAN>Data accuracy, completeness, and consistency, metadata documentation (definitions, sources), determining business needs for open data, and identifying and supporting issue resolution is actioned by the WCC’s City Insights Team.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;">Custodianship: </SPAN><SPAN>Corporate GIS Team, WCC.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN STYLE="font-weight:bold;">Authoritative Data Source (Data only): </SPAN><SPAN>The primary source of data is from VivaCity Labs, which provides a dashboard and API for collected data.</SPAN></P><P STYLE="font-weight:bold;margin:0 0 11 0;"><SPAN>Outlining limitations of data: </SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>This dataset provides valuable insights into transport activity over time, but there are a few limitations to keep in mind:</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>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></SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>Work is underway to improve how data accuracy is monitored, resolved, and presented on the Open Data Portal.</SPAN></SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>Temporary gaps may appear due to sensor outages or scheduled maintenance.</SPAN></SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN><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></SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN><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></SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>Sensors vary in installation dates, resulting in different data collection start points.</SPAN></SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>Historic data collected from old or inactive sensors may be excluded from the historic datasets.</SPAN></SPAN></P></LI><LI><P STYLE="font-weight:bold;margin:0 0 11 0;"><SPAN>Data dictionary:</SPAN></P></LI></UL><P STYLE="font-weight:bold;margin:0 0 11 0;"><SPAN><SPAN>1. Dimension/Look-up table</SPAN></SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN>Countline Meta Info</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN><SPAN>Description: 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></SPAN></P><UL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="margin:0 0 11 48;"><SPAN><SPAN>Columns:</SPAN></SPAN></P><OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="margin:0 0 11 48;"><SPAN>1. </SPAN><SPAN>name: countline_id</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: A unique identifier for each countline.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 48;"><SPAN>2. </SPAN><SPAN>name: name</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: The name of the countline, indicating generic location of countline.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 48;"><SPAN>3. </SPAN><SPAN>name: latitude_start_line</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: The latitude coordinate where the countline starts.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 48;"><SPAN>4. </SPAN><SPAN>name: longitude_start_line</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: The longitude coordinate where the countline starts.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 48;"><SPAN>5. </SPAN><SPAN>name: latitude_end_line</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: The latitude coordinate where the countline ends.</SPAN></P><P STYLE="margin:0 0 11 48;"><SPAN>6. </SPAN><SPAN>name: longitude_end_line</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: The longitude coordinate where the countline ends.</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN>7. </SPAN><SPAN>name: direction_in</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: The compass direction of the countline when moving in a clockwise direction.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN> </SPAN><SPAN>8. </SPAN><SPAN>name: direction_out</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: The compass direction of the countline when moving in an anticlockwise direction.</SPAN></P></LI><LI><P><SPAN> 9. </SPAN><SPAN>name: earliest</SPAN></P><P><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: The earliest date when the countline was recorded.</SPAN></P></LI><LI><P><SPAN> 10. </SPAN><SPAN>name: latest</SPAN></P><P><SPAN> </SPAN><SPAN> </SPAN><SPAN> </SPAN><SPAN>description: The latest date when the countline was recorded.</SPAN></P><P /><P STYLE="font-weight:bold;margin:0 0 11 0;"><SPAN><SPAN>2. Count dataset</SPAN></SPAN></P><P STYLE="margin:0 0 11 48;"><SPAN><SPAN>Description: This dataset aggregates mobility data from different countline sources, providing a comprehensive view of traffic flow and directionality.</SPAN></SPAN></P></LI></OL></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>Columns:</SPAN></P></LI></UL><P STYLE="margin:0 0 11 48;"><SPAN>1. </SPAN><SPAN>name: countline_id</SPAN></P><OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="text-indent:48;margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: A unique identifier for each countline.</SPAN></P><OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="margin:0 0 11 0;"><SPAN> 2. </SPAN><SPAN>name: countline_transport_class*</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: Classification of the transport modes, indicating the type of traffic being measured.</SPAN><SPAN> </SPAN></P></LI></OL></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> 3.</SPAN><SPAN> name: countline_date</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: The date when the countline data was recorded.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> 4. </SPAN><SPAN>name: countline_hour</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: The hour of the day when the countline data was recorded.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> 5. </SPAN><SPAN> name: direction_count</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: The total count of traffic in a specific direction during the hour.</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> 6.</SPAN><SPAN> name: direction</SPAN></P><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>description: Normalized direction label, indicating the flow of traffic, as follows:</SPAN></P><OL STYLE="margin:0 0 0 0;padding:0 0 0 0;"><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>N: North</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>NE: North East</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>E: East</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>SE: South East</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>S: South</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>SW: South West</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>W: West</SPAN></P></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN> </SPAN><SPAN>NW: North West</SPAN></P></LI></OL></LI><LI><P STYLE="margin:0 0 11 0;"><SPAN>Countline transport classes</SPAN></P></LI></OL><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>
Copyright Text: Wellington City Council, Viva City