To download the data set, please sign up or log in
Lipas 4610 ampumahiihdon harjoittelualue
Tables
-
Lipas 4610 ampumahiihdon harjoittelualue, Lipaslipas 4610 ampumahiihdon harjoittelualue, Full historyTSV
No description available for layer lipas:lipas_4610_ampumahiihdon_harjoittelualue (lipas_4610_ampumahiihdon_harjoittelualue)
-
Lipas 4610 ampumahiihdon harjoittelualue, Lipaslipas 4610 ampumahiihdon harjoittelualue, LatestTSV
No description available for layer lipas:lipas_4610_ampumahiihdon_harjoittelualue (lipas_4610_ampumahiihdon_harjoittelualue)
Column Descriptions
Lipas 4610 ampumahiihdon harjoittelualue, Lipaslipas 4610 ampumahiihdon harjoittelualue, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97225 and maximum value is 603416. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ampumahiihdon harjoittelu... and first 25 characters of maximum string: Yliviitalan ampumahiihtoa... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 35 rows, out of which 31 are empty, making the null percent 88.57. First 25 characters of minimum string: ... and first 25 characters of maximum string: Tokkapalo skjutbana, Haut... |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 35 rows, out of which 26 are empty, making the null percent 74.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: Pakkaspirtin ampumaurheil... |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 35 rows, out of which 29 are empty, making the null percent 82.86. First 25 characters of minimum string: ... and first 25 characters of maximum string: mikael.tackman@siemens.co... |
| www | string | Data source did not contain a description for www. Column www has 35 rows, out of which 24 are empty, making the null percent 68.57. Minimum string is and maximum string is www.ulvilanura.fi. |
| puhelinnum | int | Data source did not contain a description for puhelinnum. Column puhelinnum has 35 rows, out of which 33 are empty, making the null percent 94.29. Minimum value is 400678799 and maximum value is 624132000. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 35 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 35 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 35 rows, out of which 10 are empty, making the null percent 28.57. Minimum value is 1922 and maximum value is 2019. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 35 rows, out of which 34 are empty, making the null percent 97.14. Constant value is 2006. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 35 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 Valtio. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 35 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 / yhdistys. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ampujantie 112 and maximum string is Yliviitalantie 846. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4130 and maximum value is 99830. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 35 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 YLÄMYLLY. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 35 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 Ylivieska. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 35 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 977. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 35 rows, out of which 29 are empty, making the null percent 82.86. Minimum string is and maximum string is Tapionkylä. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4610. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ampumahiihdon harjoittelu... |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| kioski | boolean | Data source did not contain a description for kioski. |
| tulostaulu | string | Data source did not contain a description for tulostaulu. Column is empty. |
| ampumapaik | int | Data source did not contain a description for ampumapaik. Column ampumapaik has 35 rows, out of which 21 are empty, making the null percent 60.00. Minimum value is 1 and maximum value is 30. |
| tulospalve | boolean | Data source did not contain a description for tulospalve. |
| kesakaytto | boolean | Data source did not contain a description for kesakaytto. |
| suksihuolt | boolean | Data source did not contain a description for suksihuolt. |
| latu_perin | boolean | Data source did not contain a description for latu_perin. |
| taukopaika | string | Data source did not contain a description for taukopaika. Column is empty. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| reitin_pit | int | Data source did not contain a description for reitin_pit. Column reitin_pit has 35 rows, out of which 22 are empty, making the null percent 62.86. Minimum value is 0 and maximum value is 22. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 35 rows, out of which 27 are empty, making the null percent 77.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: yhdistyy Ruissalon 5km re... |
| latu_vapaa | boolean | Data source did not contain a description for latu_vapaa. |
| maalikamer | boolean | Data source did not contain a description for maalikamer. |
| automaatti | boolean | Data source did not contain a description for automaatti. |
| katsomo_ka | int | Data source did not contain a description for katsomo_ka. Column katsomo_ka has 35 rows, out of which 33 are empty, making the null percent 94.29. Minimum value is 0 and maximum value is 5000. |
| valaistua | int | Data source did not contain a description for valaistua. Column valaistua has 35 rows, out of which 24 are empty, making the null percent 68.57. Minimum value is 1 and maximum value is 10. |
| reitin_lev | int | Data source did not contain a description for reitin_lev. Column reitin_lev has 35 rows, out of which 33 are empty, making the null percent 94.29. Constant value is 4. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 35 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 (21.836004952601133... and first 25 characters of maximum string: POINT (29.54911968573698 ... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.84 and maximum value is 29.55. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.06 and maximum value is 68.34. |
| geom_type | string | Geometry type. Column geom_type has 35 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. |
Lipas 4610 ampumahiihdon harjoittelualue, Lipaslipas 4610 ampumahiihdon harjoittelualue, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97225 and maximum value is 603416. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Ampumahiihdon harjoittelu... and first 25 characters of maximum string: Yliviitalan ampumahiihtoa... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 35 rows, out of which 31 are empty, making the null percent 88.57. First 25 characters of minimum string: ... and first 25 characters of maximum string: Tokkapalo skjutbana, Haut... |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 35 rows, out of which 26 are empty, making the null percent 74.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: Pakkaspirtin ampumaurheil... |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 35 rows, out of which 29 are empty, making the null percent 82.86. First 25 characters of minimum string: ... and first 25 characters of maximum string: mikael.tackman@siemens.co... |
| www | string | Data source did not contain a description for www. Column www has 35 rows, out of which 24 are empty, making the null percent 68.57. Minimum string is and maximum string is www.ulvilanura.fi. |
| puhelinnum | int | Data source did not contain a description for puhelinnum. Column puhelinnum has 35 rows, out of which 33 are empty, making the null percent 94.29. Minimum value is 400678799 and maximum value is 624132000. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 35 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 35 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 35 rows, out of which 10 are empty, making the null percent 28.57. Minimum value is 1922 and maximum value is 2019. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 35 rows, out of which 34 are empty, making the null percent 97.14. Constant value is 2006. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 35 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 Valtio. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 35 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 / yhdistys. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ampujantie 112 and maximum string is Yliviitalantie 846. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4130 and maximum value is 99830. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 35 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 YLÄMYLLY. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 35 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 Ylivieska. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 35 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 977. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 35 rows, out of which 29 are empty, making the null percent 82.86. Minimum string is and maximum string is Tapionkylä. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4610. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ampumahiihdon harjoittelu... |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| kioski | boolean | Data source did not contain a description for kioski. |
| tulostaulu | string | Data source did not contain a description for tulostaulu. Column is empty. |
| ampumapaik | int | Data source did not contain a description for ampumapaik. Column ampumapaik has 35 rows, out of which 21 are empty, making the null percent 60.00. Minimum value is 1 and maximum value is 30. |
| tulospalve | boolean | Data source did not contain a description for tulospalve. |
| kesakaytto | boolean | Data source did not contain a description for kesakaytto. |
| suksihuolt | boolean | Data source did not contain a description for suksihuolt. |
| latu_perin | boolean | Data source did not contain a description for latu_perin. |
| taukopaika | string | Data source did not contain a description for taukopaika. Column is empty. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| reitin_pit | int | Data source did not contain a description for reitin_pit. Column reitin_pit has 35 rows, out of which 22 are empty, making the null percent 62.86. Minimum value is 0 and maximum value is 22. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 35 rows, out of which 27 are empty, making the null percent 77.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: yhdistyy Ruissalon 5km re... |
| latu_vapaa | boolean | Data source did not contain a description for latu_vapaa. |
| maalikamer | boolean | Data source did not contain a description for maalikamer. |
| automaatti | boolean | Data source did not contain a description for automaatti. |
| katsomo_ka | int | Data source did not contain a description for katsomo_ka. Column katsomo_ka has 35 rows, out of which 33 are empty, making the null percent 94.29. Minimum value is 0 and maximum value is 5000. |
| valaistua | int | Data source did not contain a description for valaistua. Column valaistua has 35 rows, out of which 24 are empty, making the null percent 68.57. Minimum value is 1 and maximum value is 10. |
| reitin_lev | int | Data source did not contain a description for reitin_lev. Column reitin_lev has 35 rows, out of which 33 are empty, making the null percent 94.29. Constant value is 4. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 35 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 (21.836004952601133... and first 25 characters of maximum string: POINT (29.54911968573698 ... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.84 and maximum value is 29.55. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 35 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.06 and maximum value is 68.34. |
| geom_type | string | Geometry type. Column geom_type has 35 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 11, 2020 |
|---|---|
| Created | June 10, 2018 |
| score | 0.8201478198967789 |