To download the data set, please sign up or log in

Traffic sign plan

Traffic sign plan

Tables

Column Descriptions

Traffic sign plan, City infratraffic sign plan, Latest

Column Type Comment
height int Data source did not contain a description for height. Column height has 3 rows, out of which 1 are empty, making the null percent 33.33. Constant value is 3.
direction int Data source did not contain a description for direction. Column direction has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
value int Data source did not contain a description for value. Column is empty.
txt string Data source did not contain a description for txt. Column is empty.
decision_d date Data source did not contain a description for decision_d. Column is empty.
decision_i string Data source did not contain a description for decision_i. Column is empty.
validity_p date Data source did not contain a description for validity_p. Column is empty.
validity_0 date Data source did not contain a description for validity_0. Column is empty.
created_at date Data source did not contain a description for created_at. Column is empty.
updated_at date Data source did not contain a description for updated_at. Column is empty.
deleted_at date Data source did not contain a description for deleted_at. Column is empty.
size string Data source did not contain a description for size. Column size has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: M.
reflection string Data source did not contain a description for reflection. Column reflection has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: R1.
surface_cl string Data source did not contain a description for surface_cl. Column surface_cl has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: FLAT.
seasonal_v date Data source did not contain a description for seasonal_v. Column is empty.
seasonal_0 date Data source did not contain a description for seasonal_0. Column is empty.
lifecycle int Data source did not contain a description for lifecycle. Column lifecycle has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 3.
road_name string Data source did not contain a description for road_name. Column road_name has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eteläranta and maximum string is Simonkatu.
lane_numbe int Data source did not contain a description for lane_numbe. Column lane_numbe has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 11.
lane_type int Data source did not contain a description for lane_type. Column lane_type has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
location_s int Data source did not contain a description for location_s. Column location_s has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
device_typ string Data source did not contain a description for device_typ. Column device_typ has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: d1944175-7ec3-402d-8e50-8... and first 25 characters of maximum string: f93a15f9-f4ac-487a-8268-f...
created_by string Data source did not contain a description for created_by. Column created_by has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 949e0433-a8ba-4541-a150-9...
deleted_by string Data source did not contain a description for deleted_by. Column is empty.
mount_plan string Data source did not contain a description for mount_plan. Column is empty.
updated_by string Data source did not contain a description for updated_by. Column updated_by has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 949e0433-a8ba-4541-a150-9...
source_id string Data source did not contain a description for source_id. Column is empty.
source_nam string Data source did not contain a description for source_nam. Column is empty.
is_active string Data source did not contain a description for is_active. Column is_active has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: T.
plan_id string Data source did not contain a description for plan_id. Column is empty.
mount_type string Data source did not contain a description for mount_type. Column is empty.
owner_id string Data source did not contain a description for owner_id. Column owner_id has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 2b32d466-662f-42ef-844d-3...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (24.93724793115416 ... and first 25 characters of maximum string: POINT (24.95269745507805 ...
geom_center_x float Longitude of center. Column geom_center_x has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.94 and maximum value is 24.95.
geom_center_y float Latitude of center. Column geom_center_y has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.17 and maximum value is 60.19.
geom_type string Geometry type. Column geom_type has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Traffic sign plan, City infratraffic sign plan, Full history

Column Type Comment
height int Data source did not contain a description for height. Column height has 3 rows, out of which 1 are empty, making the null percent 33.33. Constant value is 3.
direction int Data source did not contain a description for direction. Column direction has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 0.
value int Data source did not contain a description for value. Column is empty.
txt string Data source did not contain a description for txt. Column is empty.
decision_d date Data source did not contain a description for decision_d. Column is empty.
decision_i string Data source did not contain a description for decision_i. Column is empty.
validity_p date Data source did not contain a description for validity_p. Column is empty.
validity_0 date Data source did not contain a description for validity_0. Column is empty.
created_at date Data source did not contain a description for created_at. Column is empty.
updated_at date Data source did not contain a description for updated_at. Column is empty.
deleted_at date Data source did not contain a description for deleted_at. Column is empty.
size string Data source did not contain a description for size. Column size has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: M.
reflection string Data source did not contain a description for reflection. Column reflection has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: R1.
surface_cl string Data source did not contain a description for surface_cl. Column surface_cl has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: FLAT.
seasonal_v date Data source did not contain a description for seasonal_v. Column is empty.
seasonal_0 date Data source did not contain a description for seasonal_0. Column is empty.
lifecycle int Data source did not contain a description for lifecycle. Column lifecycle has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 3.
road_name string Data source did not contain a description for road_name. Column road_name has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Eteläranta and maximum string is Simonkatu.
lane_numbe int Data source did not contain a description for lane_numbe. Column lane_numbe has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 11.
lane_type int Data source did not contain a description for lane_type. Column lane_type has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
location_s int Data source did not contain a description for location_s. Column location_s has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1.
device_typ string Data source did not contain a description for device_typ. Column device_typ has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: d1944175-7ec3-402d-8e50-8... and first 25 characters of maximum string: f93a15f9-f4ac-487a-8268-f...
created_by string Data source did not contain a description for created_by. Column created_by has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 949e0433-a8ba-4541-a150-9...
deleted_by string Data source did not contain a description for deleted_by. Column is empty.
mount_plan string Data source did not contain a description for mount_plan. Column is empty.
updated_by string Data source did not contain a description for updated_by. Column updated_by has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 949e0433-a8ba-4541-a150-9...
source_id string Data source did not contain a description for source_id. Column is empty.
source_nam string Data source did not contain a description for source_nam. Column is empty.
is_active string Data source did not contain a description for is_active. Column is_active has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: T.
plan_id string Data source did not contain a description for plan_id. Column is empty.
mount_type string Data source did not contain a description for mount_type. Column is empty.
owner_id string Data source did not contain a description for owner_id. Column owner_id has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: 2b32d466-662f-42ef-844d-3...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (24.93724793115416 ... and first 25 characters of maximum string: POINT (24.95269745507805 ...
geom_center_x float Longitude of center. Column geom_center_x has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.94 and maximum value is 24.95.
geom_center_y float Latitude of center. Column geom_center_y has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.17 and maximum value is 60.19.
geom_type string Geometry type. Column geom_type has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 9, 2020
Created September 9, 2020