To download the data set, please sign up or log in
Lipas 4403 kavelyreitti
Tables
-
Lipas 4403 kavelyreitti, Lipaslipas 4403 kavelyreitti, Full historyTSV
No description available for layer lipas:lipas_4403_kavelyreitti (lipas_4403_kavelyreitti)
-
Lipas 4403 kavelyreitti, Lipaslipas 4403 kavelyreitti, LatestTSV
No description available for layer lipas:lipas_4403_kavelyreitti (lipas_4403_kavelyreitti)
Column Descriptions
Lipas 4403 kavelyreitti, Lipaslipas 4403 kavelyreitti, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 92112 and maximum value is 604060. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 2200 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: Ämmänmäki-Pilvilampi ulko... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 2200 rows, out of which 1612 are empty, making the null percent 73.27. Minimum string is and maximum string is Vandringsled. |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 2200 rows, out of which 2190 are empty, making the null percent 99.55. Minimum string is and maximum string is Rivieran ulkoilureitti. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 2200 rows, out of which 1323 are empty, making the null percent 60.14. Minimum string is and maximum string is yhteispalvelu@kurikka.fi. |
| www | string | Data source did not contain a description for www. Column www has 2200 rows, out of which 692 are empty, making the null percent 31.45. Minimum string is and maximum string is www.visitpuumala.fi. |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 2200 rows, out of which 1143 are empty, making the null percent 51.95. Minimum string is and maximum string is 4045420220. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 2200 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 2200 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 2200 rows, out of which 1513 are empty, making the null percent 68.77. Minimum value is 1962 and maximum value is 2020. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 2200 rows, out of which 2120 are empty, making the null percent 96.36. Minimum value is 2010 and maximum value is 2020. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 2200 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 2200 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 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alapitkäntie 518... and first 25 characters of maximum string: Ymmerstanmäki 14 / Espoon... |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 250 and maximum value is 701260. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 2200 rows, out of which 222 are empty, making the null percent 10.09. Minimum string is and maximum string is Öllölä. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus and maximum string is Äänekoski. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 2200 rows, out of which 1316 are empty, making the null percent 59.82. Minimum string is and maximum string is Öllölä. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4403. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kävelyreitti/ulkoilureitt... |
| 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 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 33708 and maximum value is 512534. |
| valaistua | float | Data source did not contain a description for valaistua. Column valaistua has 2200 rows, out of which 1310 are empty, making the null percent 59.55. Minimum value is 0.00 and maximum value is 40.00. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 2200 rows, out of which 1075 are empty, making the null percent 48.86. Minimum string is and maximum string is Sora. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 2200 rows, out of which 728 are empty, making the null percent 33.09. Minimum string is and maximum string is Ympärivuotinen käyttö. |
| taukopaika | int | Data source did not contain a description for taukopaika. Column taukopaika has 2200 rows, out of which 1830 are empty, making the null percent 83.18. Minimum value is 0 and maximum value is 13. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 2200 rows, out of which 1874 are empty, making the null percent 85.18. First 25 characters of minimum string: ... and first 25 characters of maximum string: sorapäällysteistä leveää ... |
| kuntoilute | boolean | Data source did not contain a description for kuntoilute. |
| saa_julkai | boolean | Data source did not contain a description for saa_julkai. |
| esteettomy | string | Data source did not contain a description for esteettomy. Column esteettomy has 2200 rows, out of which 1842 are empty, making the null percent 83.73. First 25 characters of minimum string: ... and first 25 characters of maximum string: Suunniteltu erityisesti v... |
| reitin_pit | float | Data source did not contain a description for reitin_pit. Column reitin_pit has 2200 rows, out of which 440 are empty, making the null percent 20.00. Minimum value is 0.00 and maximum value is 900.00. |
| reitin_lev | int | Data source did not contain a description for reitin_lev. Column reitin_lev has 2200 rows, out of which 1924 are empty, making the null percent 87.45. Minimum value is 1 and maximum value is 8. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 2200 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.2547534142... and first 25 characters of maximum string: LINESTRING (30.9379762599... |
| 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 2200 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 4403 kavelyreitti, Lipaslipas 4403 kavelyreitti, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 92112 and maximum value is 604060. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 2200 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: Ämmänmäki-Pilvilampi ulko... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 2200 rows, out of which 1612 are empty, making the null percent 73.27. Minimum string is and maximum string is Vandringsled. |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 2200 rows, out of which 2190 are empty, making the null percent 99.55. Minimum string is and maximum string is Rivieran ulkoilureitti. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 2200 rows, out of which 1323 are empty, making the null percent 60.14. Minimum string is and maximum string is yhteispalvelu@kurikka.fi. |
| www | string | Data source did not contain a description for www. Column www has 2200 rows, out of which 692 are empty, making the null percent 31.45. Minimum string is and maximum string is www.visitpuumala.fi. |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 2200 rows, out of which 1143 are empty, making the null percent 51.95. Minimum string is and maximum string is 4045420220. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 2200 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 2200 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 2200 rows, out of which 1513 are empty, making the null percent 68.77. Minimum value is 1962 and maximum value is 2020. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 2200 rows, out of which 2120 are empty, making the null percent 96.36. Minimum value is 2010 and maximum value is 2020. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 2200 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 2200 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 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alapitkäntie 518... and first 25 characters of maximum string: Ymmerstanmäki 14 / Espoon... |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 250 and maximum value is 701260. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 2200 rows, out of which 222 are empty, making the null percent 10.09. Minimum string is and maximum string is Öllölä. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus and maximum string is Äänekoski. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 2200 rows, out of which 1316 are empty, making the null percent 59.82. Minimum string is and maximum string is Öllölä. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4403. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kävelyreitti/ulkoilureitt... |
| 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 2200 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 33708 and maximum value is 512534. |
| valaistua | float | Data source did not contain a description for valaistua. Column valaistua has 2200 rows, out of which 1310 are empty, making the null percent 59.55. Minimum value is 0.00 and maximum value is 40.00. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 2200 rows, out of which 1075 are empty, making the null percent 48.86. Minimum string is and maximum string is Sora. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 2200 rows, out of which 728 are empty, making the null percent 33.09. Minimum string is and maximum string is Ympärivuotinen käyttö. |
| taukopaika | int | Data source did not contain a description for taukopaika. Column taukopaika has 2200 rows, out of which 1830 are empty, making the null percent 83.18. Minimum value is 0 and maximum value is 13. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 2200 rows, out of which 1874 are empty, making the null percent 85.18. First 25 characters of minimum string: ... and first 25 characters of maximum string: sorapäällysteistä leveää ... |
| kuntoilute | boolean | Data source did not contain a description for kuntoilute. |
| saa_julkai | boolean | Data source did not contain a description for saa_julkai. |
| esteettomy | string | Data source did not contain a description for esteettomy. Column esteettomy has 2200 rows, out of which 1842 are empty, making the null percent 83.73. First 25 characters of minimum string: ... and first 25 characters of maximum string: Suunniteltu erityisesti v... |
| reitin_pit | float | Data source did not contain a description for reitin_pit. Column reitin_pit has 2200 rows, out of which 440 are empty, making the null percent 20.00. Minimum value is 0.00 and maximum value is 900.00. |
| reitin_lev | int | Data source did not contain a description for reitin_lev. Column reitin_lev has 2200 rows, out of which 1924 are empty, making the null percent 87.45. Minimum value is 1 and maximum value is 8. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 2200 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.2547534142... and first 25 characters of maximum string: LINESTRING (30.9379762599... |
| 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 2200 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 |