To download the data set, please sign up or log in

Lipas 1120 lahiliikuntapaikka

Lipas 1120 lahiliikuntapaikka

Tables

Column Descriptions

Lipas 1120 Lahiliikuntapaikka, Lipaslipas 1120 Lahiliikuntapaikka

Column Type Comment
id int Data source did not contain a description for id. Column id has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72269 and maximum value is 529923.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aarnivalkean koulu / Lähi... and first 25 characters of maximum string: Monitoimiareena...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 863 rows, out of which 628 are empty, making the null percent 72.77. First 25 characters of minimum string: ... and first 25 characters of maximum string: Pirkkala utomhusinnebandy...
nimi_en string Data source did not contain a description for nimi_en. Column nimi_en has 863 rows, out of which 845 are empty, making the null percent 97.91. Minimum string is and maximum string is Niittysillan pk / luist.
sahkoposti string Data source did not contain a description for sahkoposti. Column sahkoposti has 863 rows, out of which 519 are empty, making the null percent 60.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: jouni.romppainen@hyrynsal...
www string Data source did not contain a description for www. Column www has 863 rows, out of which 248 are empty, making the null percent 28.74. Minimum string is and maximum string is http://www.isojoki.fi/.
puhelinnum string Data source did not contain a description for puhelinnum. Column puhelinnum has 863 rows, out of which 392 are empty, making the null percent 45.42. Minimum string is and maximum string is 06-24132000.
koulun_lii string Data source did not contain a description for koulun_lii. Column koulun_lii has 863 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 863 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 863 rows, out of which 323 are empty, making the null percent 37.43. Minimum value is 1969 and maximum value is 2018.
peruskorja int Data source did not contain a description for peruskorja. Column peruskorja has 863 rows, out of which 850 are empty, making the null percent 98.49. Minimum value is 2011 and maximum value is 2018.
omistaja string Data source did not contain a description for omistaja. Column omistaja has 863 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 863 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 / liikuntatoimi.
katuosoite string Data source did not contain a description for katuosoite. Column katuosoite has 863 rows, out of which 1 are empty, making the null percent 0.12. Minimum string is and maximum string is Kristiinantie 17 b.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 100 and maximum value is 99950.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 863 rows, out of which 67 are empty, making the null percent 7.76. Minimum string is and maximum string is Isojoki.
kunta_nimi string Data source did not contain a description for kunta_nimi. Column kunta_nimi has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Isojoki.
kuntanumer int Data source did not contain a description for kuntanumer. Column kuntanumer has 863 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 863 rows, out of which 601 are empty, making the null percent 69.64. Minimum string is and maximum string is Alapitkä.
tyyppikood int Data source did not contain a description for tyyppikood. Column tyyppikood has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1120.
tyyppi_nim string Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Lähiliikuntapaikka.
muokattu_v date Data source did not contain a description for muokattu_v. Column is empty.
pintamater string Data source did not contain a description for pintamater. Column pintamater has 863 rows, out of which 339 are empty, making the null percent 39.28. Minimum string is and maximum string is Hiekkatekonurmi.
valaistus boolean Data source did not contain a description for valaistus.
kaukalo_lk int Data source did not contain a description for kaukalo_lk. Column kaukalo_lk has 863 rows, out of which 491 are empty, making the null percent 56.89. Minimum value is 0 and maximum value is 3.
pintamate0 string Data source did not contain a description for pintamate0. Column pintamate0 has 863 rows, out of which 822 are empty, making the null percent 95.25. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ulkokuntoilupaikkojen pin...
kenttien_l int Data source did not contain a description for kenttien_l. Column kenttien_l has 863 rows, out of which 339 are empty, making the null percent 39.28. Minimum value is 1 and maximum value is 6.
kuntoilula int Data source did not contain a description for kuntoilula. Column kuntoilula has 863 rows, out of which 719 are empty, making the null percent 83.31. Minimum value is 1 and maximum value is 20.
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 863 rows, out of which 366 are empty, making the null percent 42.41. Minimum value is 0 and maximum value is 96100.
esteettomy string Data source did not contain a description for esteettomy. Column esteettomy has 863 rows, out of which 850 are empty, making the null percent 98.49. First 25 characters of minimum string: ... and first 25 characters of maximum string: Areenalle on esteetön kul...
lisatieto string Data source did not contain a description for lisatieto. Column lisatieto has 863 rows, out of which 205 are empty, making the null percent 23.75. First 25 characters of minimum string: ... and first 25 characters of maximum string: Leikkikentällä myös monit...
leikkipuis boolean Data source did not contain a description for leikkipuis.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 863 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.769967480416405... and first 25 characters of maximum string: POINT (21.95780970954767 ...
geom_center_x float Longitude of center. Column geom_center_x has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.77 and maximum value is 30.94.
geom_center_y float Latitude of center. Column geom_center_y has 863 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.83 and maximum value is 69.51.
geom_type string Geometry type. Column geom_type has 863 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 May 5, 2019
Created September 23, 2018