Description

– Each row is a total hourly sensor count of pedestrians

Column Name Type Description
ID Number Unique reading ID
Year Number Year of reading
Mdate Number Day of year (1, 2, 3, …, 31)
Time Number Time of day (0 = midnight-1am, 1 = 1am-2am, 2 = 2am-3am…)
Sensor_ID Number Sensor ID
Sensor_Name Plain Text Sensor name
Hourly_Counts Number Total hourly sensor readings (count of pedestrians)

Pedestrian Counting System – Sensor Locations
– Each row is a pedestrian sensor location information

Column Name Type Description
sensor_id Number The unique ID of the sensor
sensor_description Plain Text A description of where the sensor is located
sensor_name Plain Text The name of the sensor
status Plain Text Status of each sensor (A = Active, I = Inactive, R = Removed)
note Plain Text Further information on changes to sensor status or location
direction_1 Plain Text Direction 1 of the sensor reading
direction_2 Plain Text Direction 2 of the sensor reading
latitude Number Latitude of each sensor
longitude Number Longitude of each sensor
location Location The latitude and longitude of each sensor