Lipas 4440 koirahiihtolatu

Tables

Lipas 4440 koirahiihtolatu, Lipaslipas 4440 koirahiihtolatu, Full historyTSV
No description available for layer lipas:lipas_4440_koirahiihtolatu (lipas_4440_koirahiihtolatu)
Lipas 4440 koirahiihtolatu, Lipaslipas 4440 koirahiihtolatu, LatestTSV
No description available for layer lipas:lipas_4440_koirahiihtolatu (lipas_4440_koirahiihtolatu)

Column Descriptions

Lipas 4440 koirahiihtolatu, Lipaslipas 4440 koirahiihtolatu, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500147 and maximum value is 601719.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Akonvaara-Seitenahveninen... and first 25 characters of maximum string: Vimpelin valaistu latu...
nimi_se	string	Data source did not contain a description for nimi_se. Column is empty.
nimi_en	string	Data source did not contain a description for nimi_en. Column is empty.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 269 rows, out of which 77 are empty, making the null percent 28.62. Minimum string is and maximum string is tourist.info@salla.fi.
www	string	Data source did not contain a description for www. Column www has 269 rows, out of which 63 are empty, making the null percent 23.42. Minimum string is and maximum string is www.ukkohalla.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 269 rows, out of which 174 are empty, making the null percent 64.68. Minimum string is and maximum string is 0983911.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 269 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.
vapaa_kayt	string	Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 269 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 269 rows, out of which 198 are empty, making the null percent 73.61. Minimum value is 1976 and maximum value is 2016.
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 269 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 Kunta.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 269 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 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alakyläntie and maximum string is Värälänkatu.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 690 and maximum value is 99555.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 269 rows, out of which 25 are empty, making the null percent 9.29. Minimum string is and maximum string is Ylivieska.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 269 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 Ylivieska.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 269 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 977.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 269 rows, out of which 160 are empty, making the null percent 59.48. Minimum string is and maximum string is Väisälä.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4440.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Koirahiihtolatu.
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 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 65826 and maximum value is 511883.
valaistua	int	Data source did not contain a description for valaistua. Column valaistua has 269 rows, out of which 148 are empty, making the null percent 55.02. Minimum value is 0 and maximum value is 12.
taukopaika	int	Data source did not contain a description for taukopaika. Column taukopaika has 269 rows, out of which 140 are empty, making the null percent 52.04. Minimum value is 0 and maximum value is 3.
latu_perin	boolean	Data source did not contain a description for latu_perin.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 269 rows, out of which 170 are empty, making the null percent 63.20. Minimum string is and maximum string is Yksi kaavatien ylitys.
reitin_lev	float	Data source did not contain a description for reitin_lev. Column reitin_lev has 269 rows, out of which 267 are empty, making the null percent 99.26. Constant value is 4.50.
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 269 rows, out of which 179 are empty, making the null percent 66.54. Minimum string is and maximum string is Vesi.
yleiso_wc	boolean	Data source did not contain a description for yleiso_wc.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 269 rows, out of which 262 are empty, making the null percent 97.40. Minimum string is and maximum string is Lumi.
latu_vapaa	boolean	Data source did not contain a description for latu_vapaa.
reitin_pit	int	Data source did not contain a description for reitin_pit. Column reitin_pit has 269 rows, out of which 31 are empty, making the null percent 11.52. Minimum value is 0 and maximum value is 24.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 269 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 (23.1453662102... and first 25 characters of maximum string: LINESTRING (29.2029771033...
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 269 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 4440 koirahiihtolatu, Lipaslipas 4440 koirahiihtolatu, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500147 and maximum value is 601719.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Akonvaara-Seitenahveninen... and first 25 characters of maximum string: Vimpelin valaistu latu...
nimi_se	string	Data source did not contain a description for nimi_se. Column is empty.
nimi_en	string	Data source did not contain a description for nimi_en. Column is empty.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 269 rows, out of which 77 are empty, making the null percent 28.62. Minimum string is and maximum string is tourist.info@salla.fi.
www	string	Data source did not contain a description for www. Column www has 269 rows, out of which 63 are empty, making the null percent 23.42. Minimum string is and maximum string is www.ukkohalla.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 269 rows, out of which 174 are empty, making the null percent 64.68. Minimum string is and maximum string is 0983911.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 269 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.
vapaa_kayt	string	Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 269 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 269 rows, out of which 198 are empty, making the null percent 73.61. Minimum value is 1976 and maximum value is 2016.
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 269 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 Kunta.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 269 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 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alakyläntie and maximum string is Värälänkatu.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 690 and maximum value is 99555.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 269 rows, out of which 25 are empty, making the null percent 9.29. Minimum string is and maximum string is Ylivieska.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 269 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 Ylivieska.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 269 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 977.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 269 rows, out of which 160 are empty, making the null percent 59.48. Minimum string is and maximum string is Väisälä.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4440.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Koirahiihtolatu.
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 269 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 65826 and maximum value is 511883.
valaistua	int	Data source did not contain a description for valaistua. Column valaistua has 269 rows, out of which 148 are empty, making the null percent 55.02. Minimum value is 0 and maximum value is 12.
taukopaika	int	Data source did not contain a description for taukopaika. Column taukopaika has 269 rows, out of which 140 are empty, making the null percent 52.04. Minimum value is 0 and maximum value is 3.
latu_perin	boolean	Data source did not contain a description for latu_perin.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 269 rows, out of which 170 are empty, making the null percent 63.20. Minimum string is and maximum string is Yksi kaavatien ylitys.
reitin_lev	float	Data source did not contain a description for reitin_lev. Column reitin_lev has 269 rows, out of which 267 are empty, making the null percent 99.26. Constant value is 4.50.
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 269 rows, out of which 179 are empty, making the null percent 66.54. Minimum string is and maximum string is Vesi.
yleiso_wc	boolean	Data source did not contain a description for yleiso_wc.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 269 rows, out of which 262 are empty, making the null percent 97.40. Minimum string is and maximum string is Lumi.
latu_vapaa	boolean	Data source did not contain a description for latu_vapaa.
reitin_pit	int	Data source did not contain a description for reitin_pit. Column reitin_pit has 269 rows, out of which 31 are empty, making the null percent 11.52. Minimum value is 0 and maximum value is 24.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 269 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 (23.1453662102... and first 25 characters of maximum string: LINESTRING (29.2029771033...
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 269 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 11, 2020
Created	June 10, 2018