To download the data set, please sign up or log in
Lipas 2260 sulkapallohalli
Tables
-
Lipas 2260 sulkapallohalli, Lipaslipas 2260 sulkapallohalli, Full historyTSV
No description available for layer lipas:lipas_2260_sulkapallohalli (lipas_2260_sulkapallohalli)
-
Lipas 2260 sulkapallohalli, Lipaslipas 2260 sulkapallohalli, LatestTSV
No description available for layer lipas:lipas_2260_sulkapallohalli (lipas_2260_sulkapallohalli)
Column Descriptions
Lipas 2260 sulkapallohalli, Lipaslipas 2260 sulkapallohalli, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 80819 and maximum value is 528346. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aktia Arena/sulkapallohal... and first 25 characters of maximum string: Äänekosken Tennishalli Oy... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 54 rows, out of which 36 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Varistos Tenniscenter / B... |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 54 rows, out of which 49 are empty, making the null percent 90.74. First 25 characters of minimum string: ... and first 25 characters of maximum string: Suoraman liikuntahalli (s... |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 54 rows, out of which 9 are empty, making the null percent 16.67. Minimum string is and maximum string is toni.lotjonen@meripeli.fi. |
| www | string | Data source did not contain a description for www. Column www has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://huhtari.fi/... and first 25 characters of maximum string: www.ylojarvenliikuntakesk... |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 54 rows, out of which 2 are empty, making the null percent 3.70. Minimum string is and maximum string is 098735400. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 54 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 54 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 F. |
| rakennusvu | int | Data source did not contain a description for rakennusvu. Column rakennusvu has 54 rows, out of which 18 are empty, making the null percent 33.33. Minimum value is 1928 and maximum value is 2014. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 54 rows, out of which 47 are empty, making the null percent 87.04. Minimum value is 2002 and maximum value is 2017. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kunta and maximum string is Yritys. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kunta / liikuntatoimi and maximum string is Yksityinen / yritys. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakkulantie 23 and maximum string is Vellamontie 9. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 120 and maximum value is 90510. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is ÄÄNEKOSKI. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is Äänekoski. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 49 and maximum value is 992. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 54 rows, out of which 30 are empty, making the null percent 55.56. Minimum string is and maximum string is Varisto. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2260. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Sulkapallohalli. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| sulkapallo | int | Data source did not contain a description for sulkapallo. Column sulkapallo has 54 rows, out of which 2 are empty, making the null percent 3.70. Minimum value is 2 and maximum value is 23. |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 54 rows, out of which 23 are empty, making the null percent 42.59. Minimum string is and maximum string is Velour. |
| squashkent | int | Data source did not contain a description for squashkent. Column squashkent has 54 rows, out of which 43 are empty, making the null percent 79.63. Minimum value is 0 and maximum value is 5. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| pinta_ala | int | Data source did not contain a description for pinta_ala. Column pinta_ala has 54 rows, out of which 13 are empty, making the null percent 24.07. Minimum value is 237 and maximum value is 1886. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 54 rows, out of which 32 are empty, making the null percent 59.26. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vuokrattavana Puhos Cente... |
| tulostaulu | boolean | Data source did not contain a description for tulostaulu. |
| kioski | boolean | Data source did not contain a description for kioski. |
| salibandyk | int | Data source did not contain a description for salibandyk. Column salibandyk has 54 rows, out of which 45 are empty, making the null percent 83.33. Minimum value is 0 and maximum value is 2. |
| tenniskent | int | Data source did not contain a description for tenniskent. Column tenniskent has 54 rows, out of which 42 are empty, making the null percent 77.78. Minimum value is 0 and maximum value is 22. |
| katsomo_ka | string | Data source did not contain a description for katsomo_ka. Column is empty. |
| korkeus_m | int | Data source did not contain a description for korkeus_m. Column korkeus_m has 54 rows, out of which 39 are empty, making the null percent 72.22. Minimum value is 5 and maximum value is 18. |
| kentan_lev | float | Data source did not contain a description for kentan_lev. Column kentan_lev has 54 rows, out of which 50 are empty, making the null percent 92.59. Minimum value is 5.18 and maximum value is 98.00. |
| kentan_pit | float | Data source did not contain a description for kentan_pit. Column kentan_pit has 54 rows, out of which 50 are empty, making the null percent 92.59. Minimum value is 13.40 and maximum value is 34.70. |
| lentopallo | int | Data source did not contain a description for lentopallo. Column lentopallo has 54 rows, out of which 51 are empty, making the null percent 94.44. Minimum value is 0 and maximum value is 3. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 54 rows, out of which 8 are empty, making the null percent 14.81. Minimum string is and maximum string is Puu. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 54 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.480945650721132... and first 25 characters of maximum string: POINT (29.76824420504509 ... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.48 and maximum value is 29.77. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.16 and maximum value is 65.03. |
| geom_type | string | Geometry type. Column geom_type has 54 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. |
Lipas 2260 sulkapallohalli, Lipaslipas 2260 sulkapallohalli, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 80819 and maximum value is 528346. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aktia Arena/sulkapallohal... and first 25 characters of maximum string: Äänekosken Tennishalli Oy... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 54 rows, out of which 36 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Varistos Tenniscenter / B... |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 54 rows, out of which 49 are empty, making the null percent 90.74. First 25 characters of minimum string: ... and first 25 characters of maximum string: Suoraman liikuntahalli (s... |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 54 rows, out of which 9 are empty, making the null percent 16.67. Minimum string is and maximum string is toni.lotjonen@meripeli.fi. |
| www | string | Data source did not contain a description for www. Column www has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://huhtari.fi/... and first 25 characters of maximum string: www.ylojarvenliikuntakesk... |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 54 rows, out of which 2 are empty, making the null percent 3.70. Minimum string is and maximum string is 098735400. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 54 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 54 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 F. |
| rakennusvu | int | Data source did not contain a description for rakennusvu. Column rakennusvu has 54 rows, out of which 18 are empty, making the null percent 33.33. Minimum value is 1928 and maximum value is 2014. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 54 rows, out of which 47 are empty, making the null percent 87.04. Minimum value is 2002 and maximum value is 2017. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kunta and maximum string is Yritys. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kunta / liikuntatoimi and maximum string is Yksityinen / yritys. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakkulantie 23 and maximum string is Vellamontie 9. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 120 and maximum value is 90510. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is ÄÄNEKOSKI. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is Äänekoski. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 49 and maximum value is 992. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 54 rows, out of which 30 are empty, making the null percent 55.56. Minimum string is and maximum string is Varisto. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 2260. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Sulkapallohalli. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| sulkapallo | int | Data source did not contain a description for sulkapallo. Column sulkapallo has 54 rows, out of which 2 are empty, making the null percent 3.70. Minimum value is 2 and maximum value is 23. |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 54 rows, out of which 23 are empty, making the null percent 42.59. Minimum string is and maximum string is Velour. |
| squashkent | int | Data source did not contain a description for squashkent. Column squashkent has 54 rows, out of which 43 are empty, making the null percent 79.63. Minimum value is 0 and maximum value is 5. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| pinta_ala | int | Data source did not contain a description for pinta_ala. Column pinta_ala has 54 rows, out of which 13 are empty, making the null percent 24.07. Minimum value is 237 and maximum value is 1886. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 54 rows, out of which 32 are empty, making the null percent 59.26. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vuokrattavana Puhos Cente... |
| tulostaulu | boolean | Data source did not contain a description for tulostaulu. |
| kioski | boolean | Data source did not contain a description for kioski. |
| salibandyk | int | Data source did not contain a description for salibandyk. Column salibandyk has 54 rows, out of which 45 are empty, making the null percent 83.33. Minimum value is 0 and maximum value is 2. |
| tenniskent | int | Data source did not contain a description for tenniskent. Column tenniskent has 54 rows, out of which 42 are empty, making the null percent 77.78. Minimum value is 0 and maximum value is 22. |
| katsomo_ka | string | Data source did not contain a description for katsomo_ka. Column is empty. |
| korkeus_m | int | Data source did not contain a description for korkeus_m. Column korkeus_m has 54 rows, out of which 39 are empty, making the null percent 72.22. Minimum value is 5 and maximum value is 18. |
| kentan_lev | float | Data source did not contain a description for kentan_lev. Column kentan_lev has 54 rows, out of which 50 are empty, making the null percent 92.59. Minimum value is 5.18 and maximum value is 98.00. |
| kentan_pit | float | Data source did not contain a description for kentan_pit. Column kentan_pit has 54 rows, out of which 50 are empty, making the null percent 92.59. Minimum value is 13.40 and maximum value is 34.70. |
| lentopallo | int | Data source did not contain a description for lentopallo. Column lentopallo has 54 rows, out of which 51 are empty, making the null percent 94.44. Minimum value is 0 and maximum value is 3. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 54 rows, out of which 8 are empty, making the null percent 14.81. Minimum string is and maximum string is Puu. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 54 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.480945650721132... and first 25 characters of maximum string: POINT (29.76824420504509 ... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.48 and maximum value is 29.77. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 54 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.16 and maximum value is 65.03. |
| geom_type | string | Geometry type. Column geom_type has 54 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. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | September 23, 2018 |