To download the data set, please sign up or log in
Retkikartta reitit
Tables
-
Retkikartta reitit, Lipasretkikartta reitit, Full historyTSV
Retkikartassa näytettävät Lipas reitit
-
Retkikartta reitit, Lipasretkikartta reitit, LatestTSV
Retkikartassa näytettävät Lipas reitit
Column Descriptions
Retkikartta reitit, Lipasretkikartta reitit, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91936 and maximum value is 604049. |
| category_i | int | Data source did not contain a description for category_i. Column category_i has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4401 and maximum value is 4452. |
| name_fi | string | Data source did not contain a description for name_fi. Column name_fi has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aarnikotkan polku and maximum string is Öllölä - Tuupovaara. |
| name_se | string | Data source did not contain a description for name_se. Column name_se has 17224 rows, out of which 15294 are empty, making the null percent 88.79. Minimum string is and maximum string is Östra Vilkaharju. |
| name_en | string | Data source did not contain a description for name_en. Column name_en has 17224 rows, out of which 16638 are empty, making the null percent 96.60. First 25 characters of minimum string: ... and first 25 characters of maximum string: Virpiniemi-kiviniemi kunt... |
| ext_link | string | Data source did not contain a description for ext_link. Column ext_link has 17224 rows, out of which 3128 are empty, making the null percent 18.16. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.ylivieska.fi/latukart... |
| admin | string | Data source did not contain a description for admin. Column admin has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski. |
| reitisto_i | int | Data source did not contain a description for reitisto_i. Column reitisto_i has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 18734 and maximum value is 509969. |
| reitti_id | int | Data source did not contain a description for reitti_id. Column reitti_id has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30283 and maximum value is 512565. |
| reittiosa | int | Data source did not contain a description for reittiosa. Column reittiosa has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 302 and maximum value is 600509. |
| length | float | Data source did not contain a description for length. Column length has 17224 rows, out of which 2869 are empty, making the null percent 16.66. Minimum value is 0.00 and maximum value is 900.00. |
| talvikaytt | string | Data source did not contain a description for talvikaytt. Column talvikaytt has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?. |
| kesakaytto | string | Data source did not contain a description for kesakaytto. Column kesakaytto has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is T. |
| info_fi | string | Data source did not contain a description for info_fi. Column info_fi has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Osoite: -, 42100 Jämsä... and first 25 characters of maximum string: Osoite: Öjantie 460, 6855... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (20.7583547080... and first 25 characters of maximum string: LINESTRING (31.3235240678... |
| geom_center_x | float | Longitude of center. Column is empty. |
| geom_center_y | float | Latitude of center. Column is empty. |
| geom_type | string | Geometry type. Column geom_type has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING. |
Retkikartta reitit, Lipasretkikartta reitit, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91936 and maximum value is 604049. |
| category_i | int | Data source did not contain a description for category_i. Column category_i has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4401 and maximum value is 4452. |
| name_fi | string | Data source did not contain a description for name_fi. Column name_fi has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aarnikotkan polku and maximum string is Öllölä - Tuupovaara. |
| name_se | string | Data source did not contain a description for name_se. Column name_se has 17224 rows, out of which 15294 are empty, making the null percent 88.79. Minimum string is and maximum string is Östra Vilkaharju. |
| name_en | string | Data source did not contain a description for name_en. Column name_en has 17224 rows, out of which 16638 are empty, making the null percent 96.60. First 25 characters of minimum string: ... and first 25 characters of maximum string: Virpiniemi-kiviniemi kunt... |
| ext_link | string | Data source did not contain a description for ext_link. Column ext_link has 17224 rows, out of which 3128 are empty, making the null percent 18.16. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.ylivieska.fi/latukart... |
| admin | string | Data source did not contain a description for admin. Column admin has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski. |
| reitisto_i | int | Data source did not contain a description for reitisto_i. Column reitisto_i has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 18734 and maximum value is 509969. |
| reitti_id | int | Data source did not contain a description for reitti_id. Column reitti_id has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30283 and maximum value is 512565. |
| reittiosa | int | Data source did not contain a description for reittiosa. Column reittiosa has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 302 and maximum value is 600509. |
| length | float | Data source did not contain a description for length. Column length has 17224 rows, out of which 2869 are empty, making the null percent 16.66. Minimum value is 0.00 and maximum value is 900.00. |
| talvikaytt | string | Data source did not contain a description for talvikaytt. Column talvikaytt has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?. |
| kesakaytto | string | Data source did not contain a description for kesakaytto. Column kesakaytto has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ? and maximum string is T. |
| info_fi | string | Data source did not contain a description for info_fi. Column info_fi has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Osoite: -, 42100 Jämsä... and first 25 characters of maximum string: Osoite: Öjantie 460, 6855... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (20.7583547080... and first 25 characters of maximum string: LINESTRING (31.3235240678... |
| geom_center_x | float | Longitude of center. Column is empty. |
| geom_center_y | float | Latitude of center. Column is empty. |
| geom_type | string | Geometry type. Column geom_type has 17224 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | August 7, 2018 |