To download the data set, please sign up or log in
Additional sign real
Tables
-
Additional sign real, City infraadditional sign real, Full historyTSV
No description available for layer city-infra:additional_sign_real (additional_sign_real)
-
Additional sign real, City infraadditional sign real, LatestTSV
No description available for layer city-infra:additional_sign_real (additional_sign_real)
Column Descriptions
Additional sign real, City infraadditional sign real, Full history
| Column | Type | Comment |
|---|---|---|
| is_active | string | Data source did not contain a description for is_active. Column is_active has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: T. |
| deleted_at | date | Data source did not contain a description for deleted_at. 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. |
| reflection | string | Data source did not contain a description for reflection. Column reflection has 1892 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 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: FLAT. |
| color | int | Data source did not contain a description for color. Column color has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1. |
| road_name | string | Data source did not contain a description for road_name. Column road_name has 1892 rows, out of which 1890 are empty, making the null percent 99.89. Minimum string is and maximum string is Testikuja. |
| lane_numbe | int | Data source did not contain a description for lane_numbe. Column lane_numbe has 1892 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 1892 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 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2. |
| installati | string | Data source did not contain a description for installati. Column is empty. |
| installat0 | date | Data source did not contain a description for installat0. Column is empty. |
| installat1 | string | Data source did not contain a description for installat1. Column installat1 has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: IN_USE. |
| installed | string | Data source did not contain a description for installed. 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. |
| 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 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 3. |
| condition | int | Data source did not contain a description for condition. Column condition has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5. |
| manufactur | string | Data source did not contain a description for manufactur. Column is empty. |
| rfid | string | Data source did not contain a description for rfid. Column is empty. |
| additional | string | Data source did not contain a description for additional. Column is empty. |
| created_by | string | Data source did not contain a description for created_by. Column created_by has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 949e0433-a8ba-4541-a150-9... and first 25 characters of maximum string: e89e0be6-d15c-4faf-aa9d-9... |
| deleted_by | string | Data source did not contain a description for deleted_by. Column is empty. |
| parent_id | string | Data source did not contain a description for parent_id. Column parent_id has 1892 rows, out of which 1425 are empty, making the null percent 75.32. First 25 characters of minimum string: ... and first 25 characters of maximum string: fc7eff46-984c-4d1d-ba74-0... |
| updated_by | string | Data source did not contain a description for updated_by. Column updated_by has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 949e0433-a8ba-4541-a150-9... and first 25 characters of maximum string: e89e0be6-d15c-4faf-aa9d-9... |
| attachment | string | Data source did not contain a description for attachment. Column attachment has 1892 rows, out of which 251 are empty, making the null percent 13.27. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://img.vionice.io/?b... |
| direction | int | Data source did not contain a description for direction. Column direction has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -180 and maximum value is 359. |
| height | int | Data source did not contain a description for height. Column is empty. |
| installat2 | string | Data source did not contain a description for installat2. Column is empty. |
| legacy_cod | int | Data source did not contain a description for legacy_cod. Column legacy_cod has 1892 rows, out of which 337 are empty, making the null percent 17.81. Minimum value is 812 and maximum value is 872. |
| operation | string | Data source did not contain a description for operation. Column is empty. |
| permit_dec | string | Data source did not contain a description for permit_dec. Column is empty. |
| scanned_at | date | Data source did not contain a description for scanned_at. Column is empty. |
| size | string | Data source did not contain a description for size. Column is empty. |
| source_id | int | Data source did not contain a description for source_id. Column source_id has 1892 rows, out of which 1643 are empty, making the null percent 86.84. Minimum value is 3 and maximum value is 1315. |
| source_nam | string | Data source did not contain a description for source_nam. Column source_nam has 1892 rows, out of which 2 are empty, making the null percent 0.11. Minimum string is and maximum string is Vaisala 2019-2020. |
| mount_real | string | Data source did not contain a description for mount_real. Column mount_real has 1892 rows, out of which 1643 are empty, making the null percent 86.84. First 25 characters of minimum string: ... and first 25 characters of maximum string: ff64ae7f-2cd8-4866-b63e-6... |
| mount_type | string | Data source did not contain a description for mount_type. Column mount_type has 1892 rows, out of which 1643 are empty, making the null percent 86.84. First 25 characters of minimum string: ... and first 25 characters of maximum string: dfd0cd84-bb72-4b1f-955d-2... |
| owner_id | string | Data source did not contain a description for owner_id. Column owner_id has 1892 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 1892 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.151373993456016... and first 25 characters of maximum string: POINT (25.033291233928217... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.15 and maximum value is 25.03. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.15 and maximum value is 60.30. |
| geom_type | string | Geometry type. Column geom_type has 1892 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 sign real, City infraadditional sign real, Latest
| Column | Type | Comment |
|---|---|---|
| is_active | string | Data source did not contain a description for is_active. Column is_active has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: T. |
| deleted_at | date | Data source did not contain a description for deleted_at. 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. |
| reflection | string | Data source did not contain a description for reflection. Column reflection has 1892 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 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: FLAT. |
| color | int | Data source did not contain a description for color. Column color has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1. |
| road_name | string | Data source did not contain a description for road_name. Column road_name has 1892 rows, out of which 1890 are empty, making the null percent 99.89. Minimum string is and maximum string is Testikuja. |
| lane_numbe | int | Data source did not contain a description for lane_numbe. Column lane_numbe has 1892 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 1892 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 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2. |
| installati | string | Data source did not contain a description for installati. Column is empty. |
| installat0 | date | Data source did not contain a description for installat0. Column is empty. |
| installat1 | string | Data source did not contain a description for installat1. Column installat1 has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: IN_USE. |
| installed | string | Data source did not contain a description for installed. 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. |
| 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 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 3. |
| condition | int | Data source did not contain a description for condition. Column condition has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5. |
| manufactur | string | Data source did not contain a description for manufactur. Column is empty. |
| rfid | string | Data source did not contain a description for rfid. Column is empty. |
| additional | string | Data source did not contain a description for additional. Column is empty. |
| created_by | string | Data source did not contain a description for created_by. Column created_by has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 949e0433-a8ba-4541-a150-9... and first 25 characters of maximum string: e89e0be6-d15c-4faf-aa9d-9... |
| deleted_by | string | Data source did not contain a description for deleted_by. Column is empty. |
| parent_id | string | Data source did not contain a description for parent_id. Column parent_id has 1892 rows, out of which 1425 are empty, making the null percent 75.32. First 25 characters of minimum string: ... and first 25 characters of maximum string: fc7eff46-984c-4d1d-ba74-0... |
| updated_by | string | Data source did not contain a description for updated_by. Column updated_by has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 949e0433-a8ba-4541-a150-9... and first 25 characters of maximum string: e89e0be6-d15c-4faf-aa9d-9... |
| attachment | string | Data source did not contain a description for attachment. Column attachment has 1892 rows, out of which 251 are empty, making the null percent 13.27. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://img.vionice.io/?b... |
| direction | int | Data source did not contain a description for direction. Column direction has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -180 and maximum value is 359. |
| height | int | Data source did not contain a description for height. Column is empty. |
| installat2 | string | Data source did not contain a description for installat2. Column is empty. |
| legacy_cod | int | Data source did not contain a description for legacy_cod. Column legacy_cod has 1892 rows, out of which 337 are empty, making the null percent 17.81. Minimum value is 812 and maximum value is 872. |
| operation | string | Data source did not contain a description for operation. Column is empty. |
| permit_dec | string | Data source did not contain a description for permit_dec. Column is empty. |
| scanned_at | date | Data source did not contain a description for scanned_at. Column is empty. |
| size | string | Data source did not contain a description for size. Column is empty. |
| source_id | int | Data source did not contain a description for source_id. Column source_id has 1892 rows, out of which 1643 are empty, making the null percent 86.84. Minimum value is 3 and maximum value is 1315. |
| source_nam | string | Data source did not contain a description for source_nam. Column source_nam has 1892 rows, out of which 2 are empty, making the null percent 0.11. Minimum string is and maximum string is Vaisala 2019-2020. |
| mount_real | string | Data source did not contain a description for mount_real. Column mount_real has 1892 rows, out of which 1643 are empty, making the null percent 86.84. First 25 characters of minimum string: ... and first 25 characters of maximum string: ff64ae7f-2cd8-4866-b63e-6... |
| mount_type | string | Data source did not contain a description for mount_type. Column mount_type has 1892 rows, out of which 1643 are empty, making the null percent 86.84. First 25 characters of minimum string: ... and first 25 characters of maximum string: dfd0cd84-bb72-4b1f-955d-2... |
| owner_id | string | Data source did not contain a description for owner_id. Column owner_id has 1892 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 1892 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.151373993456016... and first 25 characters of maximum string: POINT (25.033291233928217... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.15 and maximum value is 25.03. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 1892 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.15 and maximum value is 60.30. |
| geom_type | string | Geometry type. Column geom_type has 1892 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. |
Additional Info
| Last Updated | September 9, 2020 |
|---|---|
| Created | September 9, 2020 |