Lipas 2340 miekkailutila

Tables

Lipas 2340 miekkailutila, Lipaslipas 2340 miekkailutila, Full historyTSV
No description available for layer lipas:lipas_2340_miekkailutila (lipas_2340_miekkailutila)
Lipas 2340 miekkailutila, Lipaslipas 2340 miekkailutila, LatestTSV
No description available for layer lipas:lipas_2340_miekkailutila (lipas_2340_miekkailutila)

Column Descriptions

Lipas 2340 miekkailutila, Lipaslipas 2340 miekkailutila, 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 89589 and maximum value is 528648.
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: Helsingin miekkailijat / ... and first 25 characters of maximum string: Töölön kisahalli / Miekka...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 7 rows, out of which 2 are empty, making the null percent 28.57. First 25 characters of minimum string: ... and first 25 characters of maximum string: Väderbacken / Utrymme för...
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 7 rows, out of which 4 are empty, making the null percent 57.14. Minimum string is and maximum string is Tuulimäen miekkailutila.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 7 rows, out of which 4 are empty, making the null percent 57.14. Minimum string is and maximum string is naashalli(at)tampere.fi.
www	string	Data source did not contain a description for www. Column www has 7 rows, out of which 1 are empty, making the null percent 14.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://palvelukartta.hel...
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum string is and maximum string is 09 310 87830.
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. 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 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
rakennusvu	int	Data source did not contain a description for rakennusvu. Column rakennusvu has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum value is 1950 and maximum value is 1992.
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. Minimum string is Ei tietoa and maximum string is Yritys.
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. Minimum string is Ei tietoa and maximum string is Yksityinen / yhdistys.
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 Itätuulenkuja 9 and maximum string is Tuureporinkatu 2.
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 240 and maximum value is 40700.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is TURKU.
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 Espoo and maximum string is Turku.
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 49 and maximum value is 853.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum string is and maximum string is Tapiola.
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 2340.
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: Miekkailutila.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
kioski	boolean	Data source did not contain a description for kioski.
korkeus_m	int	Data source did not contain a description for korkeus_m. Column korkeus_m has 7 rows, out of which 5 are empty, making the null percent 71.43. Constant value is 3.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 7 rows, out of which 4 are empty, making the null percent 57.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: Tuulimäen väestönsuojassa...
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum value is 151 and maximum value is 600.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum string is and maximum string is Puu.
miekkailu	int	Data source did not contain a description for miekkailu. Column miekkailu has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 3.
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: POINT (22.271396505755792... and first 25 characters of maximum string: POINT (25.711764088798628...
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 22.27 and maximum value is 25.71.
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 60.17 and maximum value is 62.24.
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_POINT.
orig_extractdate	string	The date when the data was originally fetched from the source.

Lipas 2340 miekkailutila, Lipaslipas 2340 miekkailutila, 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 89589 and maximum value is 528648.
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: Helsingin miekkailijat / ... and first 25 characters of maximum string: Töölön kisahalli / Miekka...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 7 rows, out of which 2 are empty, making the null percent 28.57. First 25 characters of minimum string: ... and first 25 characters of maximum string: Väderbacken / Utrymme för...
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 7 rows, out of which 4 are empty, making the null percent 57.14. Minimum string is and maximum string is Tuulimäen miekkailutila.
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 7 rows, out of which 4 are empty, making the null percent 57.14. Minimum string is and maximum string is naashalli(at)tampere.fi.
www	string	Data source did not contain a description for www. Column www has 7 rows, out of which 1 are empty, making the null percent 14.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://palvelukartta.hel...
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum string is and maximum string is 09 310 87830.
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. 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 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ?.
rakennusvu	int	Data source did not contain a description for rakennusvu. Column rakennusvu has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum value is 1950 and maximum value is 1992.
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. Minimum string is Ei tietoa and maximum string is Yritys.
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. Minimum string is Ei tietoa and maximum string is Yksityinen / yhdistys.
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 Itätuulenkuja 9 and maximum string is Tuureporinkatu 2.
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 240 and maximum value is 40700.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 7 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Espoo and maximum string is TURKU.
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 Espoo and maximum string is Turku.
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 49 and maximum value is 853.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum string is and maximum string is Tapiola.
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 2340.
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: Miekkailutila.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
kioski	boolean	Data source did not contain a description for kioski.
korkeus_m	int	Data source did not contain a description for korkeus_m. Column korkeus_m has 7 rows, out of which 5 are empty, making the null percent 71.43. Constant value is 3.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 7 rows, out of which 4 are empty, making the null percent 57.14. First 25 characters of minimum string: ... and first 25 characters of maximum string: Tuulimäen väestönsuojassa...
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 7 rows, out of which 6 are empty, making the null percent 85.71. The single string value is: .
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum value is 151 and maximum value is 600.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 7 rows, out of which 3 are empty, making the null percent 42.86. Minimum string is and maximum string is Puu.
miekkailu	int	Data source did not contain a description for miekkailu. Column miekkailu has 7 rows, out of which 1 are empty, making the null percent 14.29. Minimum value is 1 and maximum value is 3.
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: POINT (22.271396505755792... and first 25 characters of maximum string: POINT (25.711764088798628...
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 22.27 and maximum value is 25.71.
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 60.17 and maximum value is 62.24.
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_POINT.

Additional Info

Last Updated	September 10, 2020
Created	September 23, 2018