775

Tables (5)

DETECTION

  • detection_id — BIGINT
  • sensor_id — INT
  • device_id — VARCHAR(255)
  • timestamp — DATETIME
  • signal_strength — FLOAT

MATCHED_TRAVEL

  • match_id — BIGINT
  • origin_sensor_id — INT
  • destination_sensor_id — INT
  • device_id — VARCHAR(255)
  • start_time — DATETIME
  • end_time — DATETIME
  • travel_time_seconds — INT

SEGMENT

  • segment_id — INT
  • origin_sensor_id — INT
  • destination_sensor_id — INT
  • road_name — VARCHAR(255)
  • distance_miles — DECIMAL(6,3)

SENSOR

  • sensor_id — INT
  • sensor_location — VARCHAR(255)
  • road_name — VARCHAR(255)
  • latitude — DECIMAL(10,6)
  • longitude — DECIMAL(10,6)
  • direction — VARCHAR(50)

SUMMARY_INTERVAL

  • summary_id — BIGINT
  • segment_id — INT
  • time_interval_start — DATETIME
  • time_interval_end — DATETIME
  • avg_travel_time — FLOAT
  • avg_speed — FLOAT
  • sample_size — INT
  • std_dev_travel_time — FLOAT