To download the data set, please sign up or log in
Lipas 4411 maastopyorailyreitti
Tables
-
Lipas 4411 maastopyorailyreitti, Lipaslipas 4411 maastopyorailyreitti, Full historyTSV
No description available for layer lipas:lipas_4411_maastopyorailyreitti (lipas_4411_maastopyorailyreitti)
-
Lipas 4411 maastopyorailyreitti, Lipaslipas 4411 maastopyorailyreitti, LatestTSV
No description available for layer lipas:lipas_4411_maastopyorailyreitti (lipas_4411_maastopyorailyreitti)
Column Descriptions
Lipas 4411 maastopyorailyreitti, Lipaslipas 4411 maastopyorailyreitti, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 96166 and maximum value is 604012. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aholahti-Tervastupa... and first 25 characters of maximum string: Äänemäen maastopyöräreiti... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column is empty. |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 971 rows, out of which 970 are empty, making the null percent 99.90. The single string value is: Oulangan maastopyöräreitt... |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 971 rows, out of which 465 are empty, making the null percent 47.89. Minimum string is and maximum string is ville@bikehike.fi. |
| www | string | Data source did not contain a description for www. Column www has 971 rows, out of which 129 are empty, making the null percent 13.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.vedenjakajareitistö.f... |
| puhelinnum | int | Data source did not contain a description for puhelinnum. Column puhelinnum has 971 rows, out of which 939 are empty, making the null percent 96.70. Minimum value is 358137341 and maximum value is 401051000. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 971 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. |
| vapaa_kayt | string | Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 971 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. |
| rakennusvu | int | Data source did not contain a description for rakennusvu. Column rakennusvu has 971 rows, out of which 461 are empty, making the null percent 47.48. Minimum value is 1983 and maximum value is 2020. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 971 rows, out of which 962 are empty, making the null percent 99.07. Constant value is 2019. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yritys. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yksityinen / yritys. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arppentie 6 and maximum string is Äänemäentie. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1450 and maximum value is 99980. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 971 rows, out of which 72 are empty, making the null percent 7.42. Minimum string is and maximum string is Äänekoski. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hamina and maximum string is Äänekoski. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 75 and maximum value is 992. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 971 rows, out of which 828 are empty, making the null percent 85.27. Minimum string is and maximum string is Terhola. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4411. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Maastopyöräilyreitti. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| reitti_id | int | Data source did not contain a description for reitti_id. Column reitti_id has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500277 and maximum value is 512513. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 971 rows, out of which 282 are empty, making the null percent 29.04. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yhdysreitti Kontioniemi T... |
| saa_julkai | boolean | Data source did not contain a description for saa_julkai. |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 971 rows, out of which 821 are empty, making the null percent 84.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vaihteleva: asfaltti, hie... |
| reitin_pit | int | Data source did not contain a description for reitin_pit. Column reitin_pit has 971 rows, out of which 67 are empty, making the null percent 6.90. Minimum value is 0 and maximum value is 2500. |
| reitin_lev | float | Data source did not contain a description for reitin_lev. Column reitin_lev has 971 rows, out of which 892 are empty, making the null percent 91.86. Minimum value is 1.00 and maximum value is 4.00. |
| valaistua | int | Data source did not contain a description for valaistua. Column valaistua has 971 rows, out of which 788 are empty, making the null percent 81.15. Minimum value is 0 and maximum value is 12. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 971 rows, out of which 525 are empty, making the null percent 54.07. Minimum string is and maximum string is Sora. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 971 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 (21.4797338756... and first 25 characters of maximum string: LINESTRING (30.9004852186... |
| 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 971 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. |
Lipas 4411 maastopyorailyreitti, Lipaslipas 4411 maastopyorailyreitti, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 96166 and maximum value is 604012. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aholahti-Tervastupa... and first 25 characters of maximum string: Äänemäen maastopyöräreiti... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column is empty. |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 971 rows, out of which 970 are empty, making the null percent 99.90. The single string value is: Oulangan maastopyöräreitt... |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 971 rows, out of which 465 are empty, making the null percent 47.89. Minimum string is and maximum string is ville@bikehike.fi. |
| www | string | Data source did not contain a description for www. Column www has 971 rows, out of which 129 are empty, making the null percent 13.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.vedenjakajareitistö.f... |
| puhelinnum | int | Data source did not contain a description for puhelinnum. Column puhelinnum has 971 rows, out of which 939 are empty, making the null percent 96.70. Minimum value is 358137341 and maximum value is 401051000. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 971 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. |
| vapaa_kayt | string | Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 971 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. |
| rakennusvu | int | Data source did not contain a description for rakennusvu. Column rakennusvu has 971 rows, out of which 461 are empty, making the null percent 47.48. Minimum value is 1983 and maximum value is 2020. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 971 rows, out of which 962 are empty, making the null percent 99.07. Constant value is 2019. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yritys. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yksityinen / yritys. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arppentie 6 and maximum string is Äänemäentie. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1450 and maximum value is 99980. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 971 rows, out of which 72 are empty, making the null percent 7.42. Minimum string is and maximum string is Äänekoski. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hamina and maximum string is Äänekoski. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 75 and maximum value is 992. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 971 rows, out of which 828 are empty, making the null percent 85.27. Minimum string is and maximum string is Terhola. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4411. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Maastopyöräilyreitti. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| reitti_id | int | Data source did not contain a description for reitti_id. Column reitti_id has 971 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500277 and maximum value is 512513. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 971 rows, out of which 282 are empty, making the null percent 29.04. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yhdysreitti Kontioniemi T... |
| saa_julkai | boolean | Data source did not contain a description for saa_julkai. |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 971 rows, out of which 821 are empty, making the null percent 84.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vaihteleva: asfaltti, hie... |
| reitin_pit | int | Data source did not contain a description for reitin_pit. Column reitin_pit has 971 rows, out of which 67 are empty, making the null percent 6.90. Minimum value is 0 and maximum value is 2500. |
| reitin_lev | float | Data source did not contain a description for reitin_lev. Column reitin_lev has 971 rows, out of which 892 are empty, making the null percent 91.86. Minimum value is 1.00 and maximum value is 4.00. |
| valaistua | int | Data source did not contain a description for valaistua. Column valaistua has 971 rows, out of which 788 are empty, making the null percent 81.15. Minimum value is 0 and maximum value is 12. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 971 rows, out of which 525 are empty, making the null percent 54.07. Minimum string is and maximum string is Sora. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 971 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 (21.4797338756... and first 25 characters of maximum string: LINESTRING (30.9004852186... |
| 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 971 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 10, 2020 |
|---|---|
| Created | June 16, 2018 |