Lipas 4710 ulkokiipeilyseina

Tables

Lipas 4710 ulkokiipeilyseina, Lipaslipas 4710 ulkokiipeilyseina, Full historyTSV
No description available for layer lipas:lipas_4710_ulkokiipeilyseina (lipas_4710_ulkokiipeilyseina)
Lipas 4710 ulkokiipeilyseina, Lipaslipas 4710 ulkokiipeilyseina, LatestTSV
No description available for layer lipas:lipas_4710_ulkokiipeilyseina (lipas_4710_ulkokiipeilyseina)

Column Descriptions

Lipas 4710 ulkokiipeilyseina, Lipaslipas 4710 ulkokiipeilyseina, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 510453 and maximum value is 602861.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Arabianrannan liikuntapui... and first 25 characters of maximum string: Yyterin näkötornin ulkoki...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 16 rows, out of which 4 are empty, making the null percent 25.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: Äventyrpark Huippu / Linb...
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 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum string is and maximum string is varaukset@korkee.fi.
www	string	Data source did not contain a description for www. Column www has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum string is and maximum string is www.zippy.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: (09) 310 71653 / 050 5591... and first 25 characters of maximum string: 09 8165 6018...
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 16 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 16 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 16 rows, out of which 7 are empty, making the null percent 43.75. Minimum value is 1912 and maximum value is 2020.
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 16 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 16 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 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arabianpolku 3 and maximum string is Veräjäpellonkatu 17.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 350 and maximum value is 93400.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum string is and maximum string is Virrat.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 16 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 Virrat.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 16 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 936.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 16 rows, out of which 5 are empty, making the null percent 31.25. Minimum string is and maximum string is Vuosaari.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4710.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ulkokiipeilyseinä.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
kiipeilyse	int	Data source did not contain a description for kiipeilyse. Column kiipeilyse has 16 rows, out of which 9 are empty, making the null percent 56.25. Minimum value is 3 and maximum value is 15.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 16 rows, out of which 9 are empty, making the null percent 56.25. Minimum value is 15 and maximum value is 1000.
jaakiipeil	boolean	Data source did not contain a description for jaakiipeil.
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 16 rows, out of which 6 are empty, making the null percent 37.50. Minimum string is and maximum string is Puu.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 16 rows, out of which 4 are empty, making the null percent 25.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yhteensä 10 rataa, joista...
kiipeilys0	int	Data source did not contain a description for kiipeilys0. Column kiipeilys0 has 16 rows, out of which 5 are empty, making the null percent 31.25. Minimum value is 3 and maximum value is 38.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 16 rows, out of which 14 are empty, making the null percent 87.50. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vaijerit kulkevat talon s...
valaistus	boolean	Data source did not contain a description for valaistus.
kiipeilyre	int	Data source did not contain a description for kiipeilyre. Column kiipeilyre has 16 rows, out of which 8 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 13.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 16 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.189627597213825... and first 25 characters of maximum string: POINT (28.198809426554355...
geom_center_x	float	Longitude of center. Column geom_center_x has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.19 and maximum value is 28.20.
geom_center_y	float	Latitude of center. Column geom_center_y has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.18 and maximum value is 65.56.
geom_type	string	Geometry type. Column geom_type has 16 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 4710 ulkokiipeilyseina, Lipaslipas 4710 ulkokiipeilyseina, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 510453 and maximum value is 602861.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Arabianrannan liikuntapui... and first 25 characters of maximum string: Yyterin näkötornin ulkoki...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 16 rows, out of which 4 are empty, making the null percent 25.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: Äventyrpark Huippu / Linb...
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 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum string is and maximum string is varaukset@korkee.fi.
www	string	Data source did not contain a description for www. Column www has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum string is and maximum string is www.zippy.fi.
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: (09) 310 71653 / 050 5591... and first 25 characters of maximum string: 09 8165 6018...
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 16 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 16 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 16 rows, out of which 7 are empty, making the null percent 43.75. Minimum value is 1912 and maximum value is 2020.
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 16 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 16 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 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Arabianpolku 3 and maximum string is Veräjäpellonkatu 17.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 350 and maximum value is 93400.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 16 rows, out of which 1 are empty, making the null percent 6.25. Minimum string is and maximum string is Virrat.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 16 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 Virrat.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 16 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 936.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 16 rows, out of which 5 are empty, making the null percent 31.25. Minimum string is and maximum string is Vuosaari.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4710.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Ulkokiipeilyseinä.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
kiipeilyse	int	Data source did not contain a description for kiipeilyse. Column kiipeilyse has 16 rows, out of which 9 are empty, making the null percent 56.25. Minimum value is 3 and maximum value is 15.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 16 rows, out of which 9 are empty, making the null percent 56.25. Minimum value is 15 and maximum value is 1000.
jaakiipeil	boolean	Data source did not contain a description for jaakiipeil.
pintamater	string	Data source did not contain a description for pintamater. Column pintamater has 16 rows, out of which 6 are empty, making the null percent 37.50. Minimum string is and maximum string is Puu.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 16 rows, out of which 4 are empty, making the null percent 25.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yhteensä 10 rataa, joista...
kiipeilys0	int	Data source did not contain a description for kiipeilys0. Column kiipeilys0 has 16 rows, out of which 5 are empty, making the null percent 31.25. Minimum value is 3 and maximum value is 38.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 16 rows, out of which 14 are empty, making the null percent 87.50. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vaijerit kulkevat talon s...
valaistus	boolean	Data source did not contain a description for valaistus.
kiipeilyre	int	Data source did not contain a description for kiipeilyre. Column kiipeilyre has 16 rows, out of which 8 are empty, making the null percent 50.00. Minimum value is 1 and maximum value is 13.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 16 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.189627597213825... and first 25 characters of maximum string: POINT (28.198809426554355...
geom_center_x	float	Longitude of center. Column geom_center_x has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.19 and maximum value is 28.20.
geom_center_y	float	Latitude of center. Column geom_center_y has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.18 and maximum value is 65.56.
geom_type	string	Geometry type. Column geom_type has 16 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 11, 2020
Created	September 23, 2018