Lipas 106 monikayttoalue

Tables

Lipas 106 monikayttoalue, Lipaslipas 106 monikayttoalue, Full historyTSV
No description available for layer lipas:lipas_106_monikayttoalue (lipas_106_monikayttoalue)
Lipas 106 monikayttoalue, Lipaslipas 106 monikayttoalue, LatestTSV
No description available for layer lipas:lipas_106_monikayttoalue (lipas_106_monikayttoalue)

Column Descriptions

Lipas 106 monikayttoalue, Lipaslipas 106 monikayttoalue, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72737 and maximum value is 528537.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bjurs, Inkoo and maximum string is Tallholmen, Sipoo.
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 11 rows, out of which 7 are empty, making the null percent 63.64. Minimum string is and maximum string is Mikonniemi.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 11 rows, out of which 9 are empty, making the null percent 81.82. Minimum string is and maximum string is Mikonniemi.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 11 rows, out of which 4 are empty, making the null percent 36.36. First 25 characters of minimum string: ... and first 25 characters of maximum string: liikuntapalvelut@vantaa.f...
www	string	Data source did not contain a description for www. Column www has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum string is and maximum string is www.vantaa.fi/liikunta.
puhelinnum	int	Data source did not contain a description for puhelinnum. Column puhelinnum has 11 rows, out of which 8 are empty, making the null percent 72.73. Minimum value is 983911 and maximum value is 405132037.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 11 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 11 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 11 rows, out of which 3 are empty, making the null percent 27.27. Minimum value is 0 and maximum value is 1999.
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 11 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 Rekisteröity yhdistys.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 11 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 / yhdistys.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bjursintie 303 and maximum string is Väätäiskyläntie 1100.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 270 and maximum value is 42600.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Barösund and maximum string is Säynätsalo.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 11 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 Vihti.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 11 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 927.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 11 rows, out of which 9 are empty, making the null percent 81.82. The single string value is: .
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 106.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Monikäyttöalue, jolla on ...
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 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1378 and maximum value is 500714.
pinta_alak	float	Data source did not contain a description for pinta_alak. Column pinta_alak has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum value is 0.02 and maximum value is 3420000.00.
leikkipuis	string	Data source did not contain a description for leikkipuis. Column is empty.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 11 rows, out of which 5 are empty, making the null percent 45.45. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vantaan kaupunkin omistaa...
saa_julkai	boolean	Data source did not contain a description for saa_julkai.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 11 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 ((23.866178944078... and first 25 characters of maximum string: POLYGON ((25.760940175635...
geom_center_x	float	Longitude of center. Column geom_center_x has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23.90 and maximum value is 25.77.
geom_center_y	float	Latitude of center. Column geom_center_y has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.94 and maximum value is 62.49.
geom_type	string	Geometry type. Column geom_type has 11 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 106 monikayttoalue, Lipaslipas 106 monikayttoalue, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72737 and maximum value is 528537.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bjurs, Inkoo and maximum string is Tallholmen, Sipoo.
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 11 rows, out of which 7 are empty, making the null percent 63.64. Minimum string is and maximum string is Mikonniemi.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 11 rows, out of which 9 are empty, making the null percent 81.82. Minimum string is and maximum string is Mikonniemi.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 11 rows, out of which 4 are empty, making the null percent 36.36. First 25 characters of minimum string: ... and first 25 characters of maximum string: liikuntapalvelut@vantaa.f...
www	string	Data source did not contain a description for www. Column www has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum string is and maximum string is www.vantaa.fi/liikunta.
puhelinnum	int	Data source did not contain a description for puhelinnum. Column puhelinnum has 11 rows, out of which 8 are empty, making the null percent 72.73. Minimum value is 983911 and maximum value is 405132037.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 11 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 11 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 11 rows, out of which 3 are empty, making the null percent 27.27. Minimum value is 0 and maximum value is 1999.
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 11 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 Rekisteröity yhdistys.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 11 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 / yhdistys.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Bjursintie 303 and maximum string is Väätäiskyläntie 1100.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 270 and maximum value is 42600.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Barösund and maximum string is Säynätsalo.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 11 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 Vihti.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 11 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 927.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 11 rows, out of which 9 are empty, making the null percent 81.82. The single string value is: .
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 106.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Monikäyttöalue, jolla on ...
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 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1378 and maximum value is 500714.
pinta_alak	float	Data source did not contain a description for pinta_alak. Column pinta_alak has 11 rows, out of which 1 are empty, making the null percent 9.09. Minimum value is 0.02 and maximum value is 3420000.00.
leikkipuis	string	Data source did not contain a description for leikkipuis. Column is empty.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 11 rows, out of which 5 are empty, making the null percent 45.45. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vantaan kaupunkin omistaa...
saa_julkai	boolean	Data source did not contain a description for saa_julkai.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 11 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 ((23.866178944078... and first 25 characters of maximum string: POLYGON ((25.760940175635...
geom_center_x	float	Longitude of center. Column geom_center_x has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 23.90 and maximum value is 25.77.
geom_center_y	float	Latitude of center. Column geom_center_y has 11 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.94 and maximum value is 62.49.
geom_type	string	Geometry type. Column geom_type has 11 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 10, 2020
Created	June 10, 2018