Lipas 4630 kilpahiihtokeskus

Tables

Lipas 4630 kilpahiihtokeskus, Lipaslipas 4630 kilpahiihtokeskus, Full historyTSV
No description available for layer lipas:lipas_4630_kilpahiihtokeskus (lipas_4630_kilpahiihtokeskus)
Lipas 4630 kilpahiihtokeskus, Lipaslipas 4630 kilpahiihtokeskus, LatestTSV
No description available for layer lipas:lipas_4630_kilpahiihtokeskus (lipas_4630_kilpahiihtokeskus)

Column Descriptions

Lipas 4630 kilpahiihtokeskus, Lipaslipas 4630 kilpahiihtokeskus, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97177 and maximum value is 603588.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aavasaksan kisan hiihtoke... and first 25 characters of maximum string: Öjbergetin talviurheiluke...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 123 rows, out of which 101 are empty, making the null percent 82.11. Minimum string is and maximum string is Ålands skidcentrum.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 123 rows, out of which 38 are empty, making the null percent 30.89. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yliviitalan liikunta-ja h...
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 123 rows, out of which 93 are empty, making the null percent 75.61. Minimum string is and maximum string is yhteispalvelu@kurikka.fi.
www	string	Data source did not contain a description for www. Column www has 123 rows, out of which 56 are empty, making the null percent 45.53. Minimum string is and maximum string is www.ylivieska.fi.
puhelinnum	int	Data source did not contain a description for puhelinnum. Column puhelinnum has 123 rows, out of which 108 are empty, making the null percent 87.80. Minimum value is 8471927 and maximum value is 505827444.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 123 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 123 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 123 rows, out of which 14 are empty, making the null percent 11.38. Minimum value is 0 and maximum value is 2015.
peruskorja	int	Data source did not contain a description for peruskorja. Column peruskorja has 123 rows, out of which 119 are empty, making the null percent 96.75. Minimum value is 1985 and maximum value is 2014.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 123 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 123 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 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkkulanrinne 7 and maximum string is Önningebyvägen 5.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1200 and maximum value is 99870.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 123 rows, out of which 3 are empty, making the null percent 2.44. 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 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 123 rows, out of which 107 are empty, making the null percent 86.99. Minimum string is and maximum string is Ylikylä.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4630.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kilpahiihtokeskus.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
yleiso_wc	boolean	Data source did not contain a description for yleiso_wc.
suihku	boolean	Data source did not contain a description for suihku.
latu_vapaa	boolean	Data source did not contain a description for latu_vapaa.
automaatti	boolean	Data source did not contain a description for automaatti.
valaistua	int	Data source did not contain a description for valaistua. Column valaistua has 123 rows, out of which 32 are empty, making the null percent 26.02. Minimum value is 1 and maximum value is 34.
tulostaulu	boolean	Data source did not contain a description for tulostaulu.
suksihuolt	boolean	Data source did not contain a description for suksihuolt.
katsomo_ka	int	Data source did not contain a description for katsomo_ka. Column katsomo_ka has 123 rows, out of which 114 are empty, making the null percent 92.68. Minimum value is 0 and maximum value is 2800.
kioski	boolean	Data source did not contain a description for kioski.
latu_perin	boolean	Data source did not contain a description for latu_perin.
sauna	boolean	Data source did not contain a description for sauna.
maalikamer	boolean	Data source did not contain a description for maalikamer.
esteettomy	string	Data source did not contain a description for esteettomy. Column is empty.
reitin_pit	int	Data source did not contain a description for reitin_pit. Column reitin_pit has 123 rows, out of which 50 are empty, making the null percent 40.65. Minimum value is 0 and maximum value is 200.
pukukopit	boolean	Data source did not contain a description for pukukopit.
reitin_lev	int	Data source did not contain a description for reitin_lev. Column reitin_lev has 123 rows, out of which 113 are empty, making the null percent 91.87. Minimum value is 4 and maximum value is 9.
tulospalve	boolean	Data source did not contain a description for tulospalve.
taukopaika	int	Data source did not contain a description for taukopaika. Column taukopaika has 123 rows, out of which 119 are empty, making the null percent 96.75. Minimum value is 1 and maximum value is 4.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 123 rows, out of which 91 are empty, making the null percent 73.98. First 25 characters of minimum string: ... and first 25 characters of maximum string: Välinevuokraamo 1,5 km=Ki...
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 123 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 (19.95066887043629 ... and first 25 characters of maximum string: POINT (30.936299319770242...
geom_center_x	float	Longitude of center. Column geom_center_x has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.95 and maximum value is 30.94.
geom_center_y	float	Latitude of center. Column geom_center_y has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.99 and maximum value is 68.90.
geom_type	string	Geometry type. Column geom_type has 123 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 4630 kilpahiihtokeskus, Lipaslipas 4630 kilpahiihtokeskus, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97177 and maximum value is 603588.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aavasaksan kisan hiihtoke... and first 25 characters of maximum string: Öjbergetin talviurheiluke...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 123 rows, out of which 101 are empty, making the null percent 82.11. Minimum string is and maximum string is Ålands skidcentrum.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 123 rows, out of which 38 are empty, making the null percent 30.89. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yliviitalan liikunta-ja h...
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 123 rows, out of which 93 are empty, making the null percent 75.61. Minimum string is and maximum string is yhteispalvelu@kurikka.fi.
www	string	Data source did not contain a description for www. Column www has 123 rows, out of which 56 are empty, making the null percent 45.53. Minimum string is and maximum string is www.ylivieska.fi.
puhelinnum	int	Data source did not contain a description for puhelinnum. Column puhelinnum has 123 rows, out of which 108 are empty, making the null percent 87.80. Minimum value is 8471927 and maximum value is 505827444.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 123 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 123 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 123 rows, out of which 14 are empty, making the null percent 11.38. Minimum value is 0 and maximum value is 2015.
peruskorja	int	Data source did not contain a description for peruskorja. Column peruskorja has 123 rows, out of which 119 are empty, making the null percent 96.75. Minimum value is 1985 and maximum value is 2014.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 123 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 123 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 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alkkulanrinne 7 and maximum string is Önningebyvägen 5.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1200 and maximum value is 99870.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 123 rows, out of which 3 are empty, making the null percent 2.44. 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 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alajärvi and maximum string is Äänekoski.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 123 rows, out of which 107 are empty, making the null percent 86.99. Minimum string is and maximum string is Ylikylä.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4630.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kilpahiihtokeskus.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
yleiso_wc	boolean	Data source did not contain a description for yleiso_wc.
suihku	boolean	Data source did not contain a description for suihku.
latu_vapaa	boolean	Data source did not contain a description for latu_vapaa.
automaatti	boolean	Data source did not contain a description for automaatti.
valaistua	int	Data source did not contain a description for valaistua. Column valaistua has 123 rows, out of which 32 are empty, making the null percent 26.02. Minimum value is 1 and maximum value is 34.
tulostaulu	boolean	Data source did not contain a description for tulostaulu.
suksihuolt	boolean	Data source did not contain a description for suksihuolt.
katsomo_ka	int	Data source did not contain a description for katsomo_ka. Column katsomo_ka has 123 rows, out of which 114 are empty, making the null percent 92.68. Minimum value is 0 and maximum value is 2800.
kioski	boolean	Data source did not contain a description for kioski.
latu_perin	boolean	Data source did not contain a description for latu_perin.
sauna	boolean	Data source did not contain a description for sauna.
maalikamer	boolean	Data source did not contain a description for maalikamer.
esteettomy	string	Data source did not contain a description for esteettomy. Column is empty.
reitin_pit	int	Data source did not contain a description for reitin_pit. Column reitin_pit has 123 rows, out of which 50 are empty, making the null percent 40.65. Minimum value is 0 and maximum value is 200.
pukukopit	boolean	Data source did not contain a description for pukukopit.
reitin_lev	int	Data source did not contain a description for reitin_lev. Column reitin_lev has 123 rows, out of which 113 are empty, making the null percent 91.87. Minimum value is 4 and maximum value is 9.
tulospalve	boolean	Data source did not contain a description for tulospalve.
taukopaika	int	Data source did not contain a description for taukopaika. Column taukopaika has 123 rows, out of which 119 are empty, making the null percent 96.75. Minimum value is 1 and maximum value is 4.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 123 rows, out of which 91 are empty, making the null percent 73.98. First 25 characters of minimum string: ... and first 25 characters of maximum string: Välinevuokraamo 1,5 km=Ki...
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 123 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 (19.95066887043629 ... and first 25 characters of maximum string: POINT (30.936299319770242...
geom_center_x	float	Longitude of center. Column geom_center_x has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.95 and maximum value is 30.94.
geom_center_y	float	Latitude of center. Column geom_center_y has 123 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.99 and maximum value is 68.90.
geom_type	string	Geometry type. Column geom_type has 123 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	June 16, 2018