Available Datasets

Smart Singapore

We have compiled a set of open datasets for the city state of Singapore. The date ranges covered by the datasets vary from 2017-2020, but specifically have been selected to cover at least the second half of 2019.

In addition, we have generated a synthetic dataset to emulate the data generated by the novel Electronic Road Pricing 2.0 system (ERP 2.0). The data has been generated based on an assumed 4 million journeys per day for a 12-month period, where active vehicles are sampled every second. This dataset, spanning 1.3 trillion rows and 108 TB, enables users to test the scalability of the platform. It is worth mentioning that some datasets are static, as they are commprised of point of interests (POI's) or polygons.

Table Description Raw data size Date range Source
sg_erp2_synthesis Synthetic ERP 2.0 108 TB 2019-01-01 to 2019-12-31 Generated by GeoSpock
sg_rainfall Rainfall 66.1 MB 2017-01-01 to 2020-06-30 source link
sg_wind_speed Wind speed 133.3 MB 2017-01-01 to 2020-06-30 source link
sg_pm25 PM 2.5 1.1 MB 2017-01-01 to 2020-06-30 source link
sg_psi PSI 16.3 MB 2017-01-01 to 2020-06-30 source link
sg_relative_humidity Relative humidity 218.9 MB 2017-01-01 to 2020-06-30 source link
sg_wind_direction Wind direction 221.2 MB 2017-01-01 to 2020-06-30 source link
sg_air_temperature Air temperature 127.8 MB 2017-01-01 to 2020-06-30 source link
sg_erp1_camera_location ERP 1 gantries locations 7.3 KB Static - POI source link
sg_speed_bands Traffic speed bands 25.2 GB 2019-07-03 to 2019-12-31 source link
sg_road_segments Road segments extracted from traffic speedbands data 9.8 MB Static - POI source link
sg_traffic_incidents Traffic incidents 38.5 MB 2019-06-26 to 2020-12-31 source link
sg_taxi_availability Taxi availability 3.0 GB 2018-12-31 to 2020-06-30 source link
sg_region_census Singapore districts 170.0 KB Static - Polygon source link
sg_planning_area_census Planning area census regions 244.7 KB Static - Polygon source link
sg_subzone_census Subzone census 398.6 KB Static - Polygon source link
sg_speed_laser_camera Speed laser camera 3.7 KB Static - POI source link