HHTBS 2016 Dataset Location Paths

Location tracking data for rMoves trips consisting of two data-sets.

SQL Tables: [hhtbs2016].[location_lines] and [hhtbs2016].[location_points]

Points: Ordered location point data

Field	Description	Valid Count	Missing Count	Pct. Missing
point_id	surrogate key ordered by (trip_id_location, collected_at)	6300600	0	0
trip_id_location	trip identifier for joining to trip list	6300600	0	0
collected_at	datetime of location data collected	6300600	0	0
accuracy	location accuracy in meters	6300600	101	0
heading	heading in degrees	6300600	101	0
speed	speed in meters per second	6300600	101	0
latitude	location point latitude	6300600	0	0
longitude	location point longitude	6300600	0	0
shape	location point geometry (EPSG: 2230)	6300600	0	0

Lines: Trip paths built from ordered location point data

Field	Description	Valid Count	Missing Count	Pct. Missing
trip_id_location	trip identifier for joining to trips table	264431	0	0
shape	trip path linestring geometry (EPSG:2230)	264431	0	0