To download the data set, please sign up or log in
Traffic sign plan
Tables
-
Traffic sign plan, City infratraffic sign plan, Full historyTSV
No description available for layer city-infra:traffic_sign_plan (traffic_sign_plan)
-
Traffic sign plan, City infratraffic sign plan, LatestTSV
No description available for layer city-infra:traffic_sign_plan (traffic_sign_plan)
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 |