Lipas 108 virkistysmetsa

Tables

Lipas 108 virkistysmetsa, Lipaslipas 108 virkistysmetsa, Full historyTSV
No description available for layer lipas:lipas_108_virkistysmetsa (lipas_108_virkistysmetsa)
Lipas 108 virkistysmetsa, Lipaslipas 108 virkistysmetsa, LatestTSV
No description available for layer lipas:lipas_108_virkistysmetsa (lipas_108_virkistysmetsa)

Column Descriptions

Lipas 108 virkistysmetsa, Lipaslipas 108 virkistysmetsa, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72807 and maximum value is 603208.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Rasuanniemen virkistysmet... and first 25 characters of maximum string: Särkiniemi...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
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 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
www	string	Data source did not contain a description for www. Column www has 7 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://sl.kuvat.fi/kuvat/... and first 25 characters of maximum string: https://liikkuvakuopio.fi...
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 7 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 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: T.
rakennusvu	int	Data source did not contain a description for rakennusvu. Column rakennusvu has 7 rows, out of which 1 are empty, making the null percent 14.29. Constant value is 1997.
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 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kunta.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kunta / tekninen toimi.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Riihijärventie and maximum string is Särkiniementie.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 42300 and maximum value is 70700.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 7 rows, out of which 1 are empty, making the null percent 14.29. The single string value is: .
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Jämsä and maximum string is Kuopio.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 182 and maximum value is 297.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 108.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Virkistysmetsä.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
alue_id	int	Data source did not contain a description for alue_id. Column alue_id has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500005 and maximum value is 502433.
pinta_alak	int	Data source did not contain a description for pinta_alak. Column pinta_alak has 7 rows, out of which 1 are empty, making the null percent 14.29. Constant value is 94.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Natura-aluetta... and first 25 characters of maximum string: Särkiniemi on metsäinen n...
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((25.129706275163... and first 25 characters of maximum string: POLYGON ((27.648599239085...
geom_center_x	float	Longitude of center. Column geom_center_x has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25.14 and maximum value is 27.65.
geom_center_y	float	Latitude of center. Column geom_center_y has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61.95 and maximum value is 62.87.
geom_type	string	Geometry type. Column geom_type has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.
orig_extractdate	string	The date when the data was originally fetched from the source.

Lipas 108 virkistysmetsa, Lipaslipas 108 virkistysmetsa, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72807 and maximum value is 603208.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Rasuanniemen virkistysmet... and first 25 characters of maximum string: Särkiniemi...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
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 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
www	string	Data source did not contain a description for www. Column www has 7 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://sl.kuvat.fi/kuvat/... and first 25 characters of maximum string: https://liikkuvakuopio.fi...
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 7 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 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: T.
rakennusvu	int	Data source did not contain a description for rakennusvu. Column rakennusvu has 7 rows, out of which 1 are empty, making the null percent 14.29. Constant value is 1997.
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 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kunta.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kunta / tekninen toimi.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Riihijärventie and maximum string is Särkiniementie.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 42300 and maximum value is 70700.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 7 rows, out of which 1 are empty, making the null percent 14.29. The single string value is: .
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Jämsä and maximum string is Kuopio.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 182 and maximum value is 297.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 108.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Virkistysmetsä.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
alue_id	int	Data source did not contain a description for alue_id. Column alue_id has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 500005 and maximum value is 502433.
pinta_alak	int	Data source did not contain a description for pinta_alak. Column pinta_alak has 7 rows, out of which 1 are empty, making the null percent 14.29. Constant value is 94.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Natura-aluetta... and first 25 characters of maximum string: Särkiniemi on metsäinen n...
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((25.129706275163... and first 25 characters of maximum string: POLYGON ((27.648599239085...
geom_center_x	float	Longitude of center. Column geom_center_x has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 25.14 and maximum value is 27.65.
geom_center_y	float	Latitude of center. Column geom_center_y has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 61.95 and maximum value is 62.87.
geom_type	string	Geometry type. Column geom_type has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON.

Additional Info

Last Updated	September 11, 2020
Created	June 10, 2018