Name: Traffic Flow Data In Ho Chi Minh City, Viet Nam
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Traffic Flow Data In Ho Chi Minh City, Viet Nam

Context

Mining historical data from local traffic condition to learn/predict/analyze how traffic flow could be at different times of the day.

Content

The main file is train.csv: built from segments.csv and segment_status.csv. A day is split into 48 periods of 30 minutes, the first period is period_0_00 corresponding to 00:00 and the last one is period_23_30 corresponding to 23:30, each period is labeled by Level of Service (LOS - assessed by velocity at the time and the maximum velocity allowed.)
The original dataset provided and minimized for analytical purposes contains 4 tables only:

segment_status.csv: traffic status for a segment reported at different date and time.
segments.csv: detail information about a segment including start node, end node, length of the segment and its belonging street.
nodes.csv: a node is a point on Earth specified by longitude and latitude positions, it connects segments together.
streets.csv: many segments together form a street in real-world, the table contains details about street name, level, type of street and its maximum velocity when free flow.

Acknowledgements

Data provided: Research group from HCM University of Technology (website)
Banner image by Denys Nevozhai

Inspirations

Research motivation?

Tables

Nodes

@kaggle.thanhnguyen2612_traffic_flow_data_in_ho_chi_minh_city_viet_nam.nodes

12.05 MB
577,967 rows
3 columns

CREATE TABLE nodes (
  "n__id" BIGINT  -- Id,
  "long" DOUBLE,
  "lat" DOUBLE
);

Segments

@kaggle.thanhnguyen2612_traffic_flow_data_in_ho_chi_minh_city_viet_nam.segments

2.61 MB
84,633 rows
11 columns

CREATE TABLE segments (
  "n__id" BIGINT  -- Id,
  "created_at" VARCHAR,
  "updated_at" VARCHAR,
  "s_node_id" BIGINT,
  "e_node_id" BIGINT,
  "length" BIGINT,
  "street_id" BIGINT,
  "max_velocity" DOUBLE,
  "street_level" BIGINT,
  "street_name" VARCHAR,
  "street_type" VARCHAR
);

Segment Status

@kaggle.thanhnguyen2612_traffic_flow_data_in_ho_chi_minh_city_viet_nam.segment_status

1.39 MB
90,938 rows
4 columns

CREATE TABLE segment_status (
  "n__id" BIGINT  -- Id,
  "updated_at" VARCHAR,
  "segment_id" BIGINT,
  "velocity" BIGINT
);

Streets

@kaggle.thanhnguyen2612_traffic_flow_data_in_ho_chi_minh_city_viet_nam.streets

62.79 kB
5,553 rows
5 columns

CREATE TABLE streets (
  "n__id" BIGINT  -- Id,
  "level" BIGINT,
  "max_velocity" DOUBLE,
  "name" VARCHAR,
  "type" VARCHAR
);

Train

@kaggle.thanhnguyen2612_traffic_flow_data_in_ho_chi_minh_city_viet_nam.train

1.01 MB
33,441 rows
18 columns

CREATE TABLE train (
  "n__id" BIGINT  -- Id,
  "segment_id" BIGINT,
  "date" TIMESTAMP,
  "weekday" BIGINT,
  "period" VARCHAR,
  "los" VARCHAR,
  "s_node_id" BIGINT,
  "e_node_id" BIGINT,
  "length" BIGINT,
  "street_id" BIGINT,
  "max_velocity" DOUBLE,
  "street_level" BIGINT,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "long_snode" DOUBLE,
  "lat_snode" DOUBLE,
  "long_enode" DOUBLE,
  "lat_enode" DOUBLE
);