Lipas 1170 pyorailurata

Tables

Lipas 1170 pyorailurata, Lipaslipas 1170 pyorailurata, Full historyTSV
No description available for layer lipas:lipas_1170_pyorailurata (lipas_1170_pyorailurata)
Lipas 1170 pyorailurata, Lipaslipas 1170 pyorailurata, LatestTSV
No description available for layer lipas:lipas_1170_pyorailurata (lipas_1170_pyorailurata)

Column Descriptions

Lipas 1170 pyorailurata, Lipaslipas 1170 pyorailurata, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 74662 and maximum value is 602160.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aurinkovuoren koulun alam... and first 25 characters of maximum string: Käpylän liikuntapuisto / ...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 3 rows, out of which 2 are empty, making the null percent 66.67. The single string value is: Kottby idrottspark / Velo...
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 is empty.
www	string	Data source did not contain a description for www. Column www has 3 rows, out of which 1 are empty, making the null percent 33.33. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.turku.fi/kult...
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is 09 310 87990.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 3 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 3 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 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1940 and maximum value is 2018.
peruskorja	int	Data source did not contain a description for peruskorja. Column peruskorja has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 1997.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kunta.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 3 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 Kunta / tekninen toimi.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asikkalantie 12 and maximum string is Mäkelänkatu 70.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 520 and maximum value is 20520.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is TURKU.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asikkala and maximum string is Turku.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16 and maximum value is 853.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 3 rows, out of which 2 are empty, making the null percent 66.67. The single string value is: .
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1170.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pyöräilyrata.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
radan_pitu	int	Data source did not contain a description for radan_pitu. Column radan_pitu has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 333 and maximum value is 400.
radan_leve	int	Data source did not contain a description for radan_leve. Column radan_leve has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 8.
pintamater	string	Data source did not contain a description for pintamater. Column is empty.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 3200.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 3 rows, out of which 1 are empty, making the null percent 33.33. First 25 characters of minimum string: ... and first 25 characters of maximum string: Velodromin katsomoissa on...
valaistus	boolean	Data source did not contain a description for valaistus.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is Betoni.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 3 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.302430462613742... and first 25 characters of maximum string: POINT (25.526748163758093...
geom_center_x	float	Longitude of center. Column geom_center_x has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.30 and maximum value is 25.53.
geom_center_y	float	Latitude of center. Column geom_center_y has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.20 and maximum value is 61.18.
geom_type	string	Geometry type. Column geom_type has 3 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 1170 pyorailurata, Lipaslipas 1170 pyorailurata, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 74662 and maximum value is 602160.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Aurinkovuoren koulun alam... and first 25 characters of maximum string: Käpylän liikuntapuisto / ...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 3 rows, out of which 2 are empty, making the null percent 66.67. The single string value is: Kottby idrottspark / Velo...
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 is empty.
www	string	Data source did not contain a description for www. Column www has 3 rows, out of which 1 are empty, making the null percent 33.33. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.turku.fi/kult...
puhelinnum	string	Data source did not contain a description for puhelinnum. Column puhelinnum has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is 09 310 87990.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 3 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 3 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 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1940 and maximum value is 2018.
peruskorja	int	Data source did not contain a description for peruskorja. Column peruskorja has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 1997.
omistaja	string	Data source did not contain a description for omistaja. Column omistaja has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Kunta.
yllapitaja	string	Data source did not contain a description for yllapitaja. Column yllapitaja has 3 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 Kunta / tekninen toimi.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asikkalantie 12 and maximum string is Mäkelänkatu 70.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 520 and maximum value is 20520.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is TURKU.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Asikkala and maximum string is Turku.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 16 and maximum value is 853.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 3 rows, out of which 2 are empty, making the null percent 66.67. The single string value is: .
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 1170.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Pyöräilyrata.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
radan_pitu	int	Data source did not contain a description for radan_pitu. Column radan_pitu has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum value is 333 and maximum value is 400.
radan_leve	int	Data source did not contain a description for radan_leve. Column radan_leve has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 8.
pintamater	string	Data source did not contain a description for pintamater. Column is empty.
pinta_ala	int	Data source did not contain a description for pinta_ala. Column pinta_ala has 3 rows, out of which 2 are empty, making the null percent 66.67. Constant value is 3200.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 3 rows, out of which 1 are empty, making the null percent 33.33. First 25 characters of minimum string: ... and first 25 characters of maximum string: Velodromin katsomoissa on...
valaistus	boolean	Data source did not contain a description for valaistus.
pintamate0	string	Data source did not contain a description for pintamate0. Column pintamate0 has 3 rows, out of which 1 are empty, making the null percent 33.33. Minimum string is and maximum string is Betoni.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 3 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.302430462613742... and first 25 characters of maximum string: POINT (25.526748163758093...
geom_center_x	float	Longitude of center. Column geom_center_x has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.30 and maximum value is 25.53.
geom_center_y	float	Latitude of center. Column geom_center_y has 3 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.20 and maximum value is 61.18.
geom_type	string	Geometry type. Column geom_type has 3 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 11, 2020
Created	June 11, 2018
score	-1.0