Lipas 4220 hiihtotunneli

Tables

Lipas 4220 hiihtotunneli, Lipaslipas 4220 hiihtotunneli, Full historyTSV
No description available for layer lipas:lipas_4220_hiihtotunneli (lipas_4220_hiihtotunneli)
Lipas 4220 hiihtotunneli, Lipaslipas 4220 hiihtotunneli, LatestTSV
No description available for layer lipas:lipas_4220_hiihtotunneli (lipas_4220_hiihtotunneli)

Column Descriptions

Lipas 4220 hiihtotunneli, Lipaslipas 4220 hiihtotunneli, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 98157 and maximum value is 604061.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hiihtotunneli Paippi and maximum string is Vuokatin hiihtoputki.
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 8 rows, out of which 6 are empty, making the null percent 75.00. Minimum string is and maximum string is Stensböle skidhall.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 8 rows, out of which 5 are empty, making the null percent 62.50. Minimum string is and maximum string is Vuokatin hiihtoputki.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 8 rows, out of which 3 are empty, making the null percent 37.50. Minimum string is and maximum string is myynti@jamikeskus.fi.
www	string	Data source did not contain a description for www. Column www has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum string is and maximum string is www.vesileppis.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum string is and maximum string is 09 224 5103.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
vapaa_kayt	string	Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
rakennusvu	int	Data source did not contain a description for rakennusvu. Column rakennusvu has 8 rows, out of which 3 are empty, making the null percent 37.50. Minimum value is 1997 and maximum value is 2019.
peruskorja	string	Data source did not contain a description for peruskorja. Column is empty.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 8 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 8 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 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hopeatie and maximum string is Vuokatinhovintie 2.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 940 and maximum value is 88610.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum string is and maximum string is Ylöjärvi.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Helsinki and maximum string is Ylöjärvi.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91 and maximum value is 980.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 8 rows, out of which 4 are empty, making the null percent 50.00. Minimum string is and maximum string is Vuokatti.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4220.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Hiihtotunneli.
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.
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 8 rows, out of which 6 are empty, making the null percent 75.00. Minimum string is and maximum string is Kivituhka.
reitin_pit	float	Data source did not contain a description for reitin_pit. Column reitin_pit has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum value is 0.62 and maximum value is 1.20.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 8 rows, out of which 7 are empty, making the null percent 87.50. Constant value is 6700.
reitin_lev	int	Data source did not contain a description for reitin_lev. Column reitin_lev has 8 rows, out of which 3 are empty, making the null percent 37.50. Minimum value is 5 and maximum value is 8.
pintamate0	string	Data source did not contain a description for pintamate0. Column is empty.
esteettomy	string	Data source did not contain a description for esteettomy. Column is empty.
korkeusero	int	Data source did not contain a description for korkeusero. Column korkeusero has 8 rows, out of which 4 are empty, making the null percent 50.00. Minimum value is 6 and maximum value is 18.
valinevuok	boolean	Data source did not contain a description for valinevuok.
suksihuolt	boolean	Data source did not contain a description for suksihuolt.
kioski	boolean	Data source did not contain a description for kioski.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 8 rows, out of which 1 are empty, making the null percent 12.50. First 25 characters of minimum string: ... and first 25 characters of maximum string: Lämpötila noin -5 astetta...
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 8 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.41114858323826 ... and first 25 characters of maximum string: POINT (28.291386875796594...
geom_center_x	float	Longitude of center. Column geom_center_x has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.41 and maximum value is 28.29.
geom_center_y	float	Latitude of center. Column geom_center_y has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.24 and maximum value is 64.14.
geom_type	string	Geometry type. Column geom_type has 8 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 4220 hiihtotunneli, Lipaslipas 4220 hiihtotunneli, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 98157 and maximum value is 604061.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hiihtotunneli Paippi and maximum string is Vuokatin hiihtoputki.
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 8 rows, out of which 6 are empty, making the null percent 75.00. Minimum string is and maximum string is Stensböle skidhall.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 8 rows, out of which 5 are empty, making the null percent 62.50. Minimum string is and maximum string is Vuokatin hiihtoputki.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 8 rows, out of which 3 are empty, making the null percent 37.50. Minimum string is and maximum string is myynti@jamikeskus.fi.
www	string	Data source did not contain a description for www. Column www has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum string is and maximum string is www.vesileppis.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum string is and maximum string is 09 224 5103.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
vapaa_kayt	string	Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
rakennusvu	int	Data source did not contain a description for rakennusvu. Column rakennusvu has 8 rows, out of which 3 are empty, making the null percent 37.50. Minimum value is 1997 and maximum value is 2019.
peruskorja	string	Data source did not contain a description for peruskorja. Column is empty.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 8 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 8 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 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hopeatie and maximum string is Vuokatinhovintie 2.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 940 and maximum value is 88610.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 8 rows, out of which 1 are empty, making the null percent 12.50. Minimum string is and maximum string is Ylöjärvi.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Helsinki and maximum string is Ylöjärvi.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91 and maximum value is 980.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 8 rows, out of which 4 are empty, making the null percent 50.00. Minimum string is and maximum string is Vuokatti.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4220.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Hiihtotunneli.
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.
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 8 rows, out of which 6 are empty, making the null percent 75.00. Minimum string is and maximum string is Kivituhka.
reitin_pit	float	Data source did not contain a description for reitin_pit. Column reitin_pit has 8 rows, out of which 2 are empty, making the null percent 25.00. Minimum value is 0.62 and maximum value is 1.20.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 8 rows, out of which 7 are empty, making the null percent 87.50. Constant value is 6700.
reitin_lev	int	Data source did not contain a description for reitin_lev. Column reitin_lev has 8 rows, out of which 3 are empty, making the null percent 37.50. Minimum value is 5 and maximum value is 8.
pintamate0	string	Data source did not contain a description for pintamate0. Column is empty.
esteettomy	string	Data source did not contain a description for esteettomy. Column is empty.
korkeusero	int	Data source did not contain a description for korkeusero. Column korkeusero has 8 rows, out of which 4 are empty, making the null percent 50.00. Minimum value is 6 and maximum value is 18.
valinevuok	boolean	Data source did not contain a description for valinevuok.
suksihuolt	boolean	Data source did not contain a description for suksihuolt.
kioski	boolean	Data source did not contain a description for kioski.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 8 rows, out of which 1 are empty, making the null percent 12.50. First 25 characters of minimum string: ... and first 25 characters of maximum string: Lämpötila noin -5 astetta...
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 8 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.41114858323826 ... and first 25 characters of maximum string: POINT (28.291386875796594...
geom_center_x	float	Longitude of center. Column geom_center_x has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.41 and maximum value is 28.29.
geom_center_y	float	Latitude of center. Column geom_center_y has 8 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.24 and maximum value is 64.14.
geom_type	string	Geometry type. Column geom_type has 8 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 16, 2018