To download the data set, please sign up or log in
Liikennemerkkipilotti liikennemerkit
Tables
-
Liikennemerkkipilotti Liikennemerkitpoint, Avoindataliikennemerkkipilotti LiikennemerkitTSV
No description available for layer avoindata:liikennemerkkipilotti_liikennemerkit (liikennemerkkipilotti_liikennemerkit)
Column Descriptions
Liikennemerkkipilotti Liikennemerkitpoint, Avoindataliikennemerkkipilotti Liikennemerkit
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 21178. |
| tyyppi | int | Data source did not contain a description for tyyppi. Column tyyppi has 21175 rows, out of which 7205 are empty, making the null percent 34.03. Minimum value is 115 and maximum value is 872. |
| nimi | string | Data source did not contain a description for nimi. Column nimi has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ajoneuvojen sijoitus pysä... and first 25 characters of maximum string: Pysäköinti kielletty... |
| teksti | string | Data source did not contain a description for teksti. Column teksti has 21175 rows, out of which 16521 are empty, making the null percent 78.02. Minimum string is and maximum string is unreadable. |
| kiinnitys | string | Data source did not contain a description for kiinnitys. Column kiinnitys has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Lightpole and maximum string is Pole. |
| kuvaus_pvm | timestamp | Data source did not contain a description for kuvaus_pvm. Column kuvaus_pvm has 21175 rows, out of which 4 are empty, making the null percent 0.02. Minimum value is 2015-10-05 00:00:00 and maximum value is 2015-10-27 00:00:00. |
| katselusuu | int | Data source did not contain a description for katselusuu. Column katselusuu has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 359. |
| x | int | Data source did not contain a description for x. Column x has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25491860 and maximum value is 25498806. |
| y | float | Data source did not contain a description for y. Column y has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6670493.50 and maximum value is 6674687.00. |
| z | float | Data source did not contain a description for z. Column z has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2.34 and maximum value is 28.73. |
| datanomist | string | Data source did not contain a description for datanomist. Column datanomist has 21175 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Helsinki/MAKA. |
| paivitetty | string | Data source did not contain a description for paivitetty. Column is empty. |
| geom_geojson | string | Geometry in GeoJSON format. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | April 12, 2019 |
|---|---|
| Created | August 7, 2018 |