Lipas 3220 uimaranta

Tables

Lipas 3220 uimaranta, Lipaslipas 3220 uimaranta, Full historyTSV
No description available for layer lipas:lipas_3220_uimaranta (lipas_3220_uimaranta)
Lipas 3220 uimaranta, Lipaslipas 3220 uimaranta, LatestTSV
No description available for layer lipas:lipas_3220_uimaranta (lipas_3220_uimaranta)

Column Descriptions

Lipas 3220 uimaranta, Lipaslipas 3220 uimaranta, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 98578 and maximum value is 603176.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahveniston uintikeskus and maximum string is Österhankmo uimaranta.
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 157 rows, out of which 120 are empty, making the null percent 76.43. Minimum string is and maximum string is Österhankmo simstrand.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 157 rows, out of which 114 are empty, making the null percent 72.61. Minimum string is and maximum string is Vihnuksen uimala.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 157 rows, out of which 99 are empty, making the null percent 63.06. Minimum string is and maximum string is sivistystoimi@hyvinkaa.fi.
www	string	Data source did not contain a description for www. Column www has 157 rows, out of which 43 are empty, making the null percent 27.39. Minimum string is and maximum string is www.seinajoki.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 157 rows, out of which 54 are empty, making the null percent 34.39. First 25 characters of minimum string: ... and first 25 characters of maximum string: Destia/Hannu Huhtala puh....
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 157 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 157 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 157 rows, out of which 53 are empty, making the null percent 33.76. Minimum value is 1929 and maximum value is 2019.
peruskorja	int	Data source did not contain a description for peruskorja. Column peruskorja has 157 rows, out of which 141 are empty, making the null percent 89.81. Minimum value is 1996 and maximum value is 2020.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 157 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 157 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 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alasjärvenranta 41 and maximum string is Yttrelångskat 81.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 157 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 90510.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 157 rows, out of which 5 are empty, making the null percent 3.18. Minimum string is and maximum string is Österhankmo.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 157 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 Ylöjärvi.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20 and maximum value is 980.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 157 rows, out of which 95 are empty, making the null percent 60.51. Minimum string is and maximum string is Väinölänniemi.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 3220.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Uimaranta.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
saa_julkai	boolean	Data source did not contain a description for saa_julkai.
eu_ranta	boolean	Data source did not contain a description for eu_ranta.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 157 rows, out of which 97 are empty, making the null percent 61.78. Minimum string is and maximum string is Vesiliukumäki.
yleiso_wc	boolean	Data source did not contain a description for yleiso_wc.
laituri	boolean	Data source did not contain a description for laituri.
suihku	boolean	Data source did not contain a description for suihku.
rannan_pit	int	Data source did not contain a description for rannan_pit. Column rannan_pit has 157 rows, out of which 101 are empty, making the null percent 64.33. Minimum value is 5 and maximum value is 800.
sauna	boolean	Data source did not contain a description for sauna.
pukukopit	boolean	Data source did not contain a description for pukukopit.
hyppytelin	boolean	Data source did not contain a description for hyppytelin.
kioski	boolean	Data source did not contain a description for kioski.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 157 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.223225294049847... and first 25 characters of maximum string: POINT (31.08393024211351 ...
geom_center_x	float	Longitude of center. Column geom_center_x has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.22 and maximum value is 31.08.
geom_center_y	float	Latitude of center. Column geom_center_y has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.84 and maximum value is 65.03.
geom_type	string	Geometry type. Column geom_type has 157 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.

Lipas 3220 uimaranta, Lipaslipas 3220 uimaranta, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 98578 and maximum value is 603176.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ahveniston uintikeskus and maximum string is Österhankmo uimaranta.
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 157 rows, out of which 120 are empty, making the null percent 76.43. Minimum string is and maximum string is Österhankmo simstrand.
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 157 rows, out of which 114 are empty, making the null percent 72.61. Minimum string is and maximum string is Vihnuksen uimala.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 157 rows, out of which 99 are empty, making the null percent 63.06. Minimum string is and maximum string is sivistystoimi@hyvinkaa.fi.
www	string	Data source did not contain a description for www. Column www has 157 rows, out of which 43 are empty, making the null percent 27.39. Minimum string is and maximum string is www.seinajoki.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 157 rows, out of which 54 are empty, making the null percent 34.39. First 25 characters of minimum string: ... and first 25 characters of maximum string: Destia/Hannu Huhtala puh....
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 157 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 157 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 157 rows, out of which 53 are empty, making the null percent 33.76. Minimum value is 1929 and maximum value is 2019.
peruskorja	int	Data source did not contain a description for peruskorja. Column peruskorja has 157 rows, out of which 141 are empty, making the null percent 89.81. Minimum value is 1996 and maximum value is 2020.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 157 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 157 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 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alasjärvenranta 41 and maximum string is Yttrelångskat 81.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 157 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 90510.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 157 rows, out of which 5 are empty, making the null percent 3.18. Minimum string is and maximum string is Österhankmo.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 157 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 Ylöjärvi.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20 and maximum value is 980.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 157 rows, out of which 95 are empty, making the null percent 60.51. Minimum string is and maximum string is Väinölänniemi.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 3220.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Uimaranta.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
saa_julkai	boolean	Data source did not contain a description for saa_julkai.
eu_ranta	boolean	Data source did not contain a description for eu_ranta.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 157 rows, out of which 97 are empty, making the null percent 61.78. Minimum string is and maximum string is Vesiliukumäki.
yleiso_wc	boolean	Data source did not contain a description for yleiso_wc.
laituri	boolean	Data source did not contain a description for laituri.
suihku	boolean	Data source did not contain a description for suihku.
rannan_pit	int	Data source did not contain a description for rannan_pit. Column rannan_pit has 157 rows, out of which 101 are empty, making the null percent 64.33. Minimum value is 5 and maximum value is 800.
sauna	boolean	Data source did not contain a description for sauna.
pukukopit	boolean	Data source did not contain a description for pukukopit.
hyppytelin	boolean	Data source did not contain a description for hyppytelin.
kioski	boolean	Data source did not contain a description for kioski.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 157 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.223225294049847... and first 25 characters of maximum string: POINT (31.08393024211351 ...
geom_center_x	float	Longitude of center. Column geom_center_x has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.22 and maximum value is 31.08.
geom_center_y	float	Latitude of center. Column geom_center_y has 157 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.84 and maximum value is 65.03.
geom_type	string	Geometry type. Column geom_type has 157 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	September 10, 2020
Created	September 23, 2018