1. Home
  2. Datasets
  3. Lipas 5110 soutustadion
To download the data set, please sign up or log in

Lipas 5110 soutustadion

Lipas 5110 soutustadion

Tables

Column Descriptions

Lipas 5110 soutustadion, Lipaslipas 5110 soutustadion, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97487 and maximum value is 525535.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Joutjärven melontakeskus... and first 25 characters of maximum string: Turun Soutu- ja Melontake...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 9 rows, out of which 5 are empty, making the null percent 55.56. Minimum string is and maximum string is Soutu- ja melontastadion.
nimi_en string Data source did not contain a description for nimi_en. Column nimi_en has 9 rows, out of which 4 are empty, making the null percent 44.44. Minimum string is and maximum string is Soutu- ja melontastadion.
sahkoposti string Data source did not contain a description for sahkoposti. Column sahkoposti has 9 rows, out of which 7 are empty, making the null percent 77.78. First 25 characters of minimum string: ... and first 25 characters of maximum string: valkeakoskenvesiveikot[at...
www string Data source did not contain a description for www. Column www has 9 rows, out of which 2 are empty, making the null percent 22.22. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.hel.fi/kulttu...
puhelinnum string Data source did not contain a description for puhelinnum. Column puhelinnum has 9 rows, out of which 5 are empty, making the null percent 55.56. Minimum string is and maximum string is 09 310 71513.
koulun_lii string Data source did not contain a description for koulun_lii. Column koulun_lii has 9 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 9 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 9 rows, out of which 1 are empty, making the null percent 11.11. Minimum value is 0 and maximum value is 1988.
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 9 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 9 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 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alanteentie and maximum string is Uimarannankatu 3.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 260 and maximum value is 90650.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Helsinki and maximum string is Valkeakoski.
kunta_nimi string Data source did not contain a description for kunta_nimi. Column kunta_nimi has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Helsinki and maximum string is Valkeakoski.
kuntanumer int Data source did not contain a description for kuntanumer. Column kuntanumer has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91 and maximum value is 908.
kuntaosa string Data source did not contain a description for kuntaosa. Column kuntaosa has 9 rows, out of which 6 are empty, making the null percent 66.67. Minimum string is and maximum string is Taka-Töölö.
tyyppikood int Data source did not contain a description for tyyppikood. Column tyyppikood has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5110.
tyyppi_nim string Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Soutustadion.
muokattu_v date Data source did not contain a description for muokattu_v. Column is empty.
yleiso_wc boolean Data source did not contain a description for yleiso_wc.
automaatti string Data source did not contain a description for automaatti. Column automaatti has 9 rows, out of which 8 are empty, making the null percent 88.89. The single string value is: .
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 9 rows, out of which 8 are empty, making the null percent 88.89. Constant value is 716.
katsomo_ka int Data source did not contain a description for katsomo_ka. Column katsomo_ka has 9 rows, out of which 4 are empty, making the null percent 44.44. Minimum value is 0 and maximum value is 1000.
laituri boolean Data source did not contain a description for laituri.
lisatieto string Data source did not contain a description for lisatieto. Column lisatieto has 9 rows, out of which 5 are empty, making the null percent 55.56. First 25 characters of minimum string: ... and first 25 characters of maximum string: Soutajille stadionilla on...
radan_pitu int Data source did not contain a description for radan_pitu. Column radan_pitu has 9 rows, out of which 3 are empty, making the null percent 33.33. Minimum value is 0 and maximum value is 2000.
tulostaulu string Data source did not contain a description for tulostaulu. Column tulostaulu has 9 rows, out of which 8 are empty, making the null percent 88.89. The single string value is: .
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 9 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.262228436210336... and first 25 characters of maximum string: POINT (28.382938172408338...
geom_center_x float Longitude of center. Column geom_center_x has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.26 and maximum value is 28.38.
geom_center_y float Latitude of center. Column geom_center_y has 9 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.02.
geom_type string Geometry type. Column geom_type has 9 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 5110 soutustadion, Lipaslipas 5110 soutustadion, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97487 and maximum value is 525535.
nimi_fi string Data source did not contain a description for nimi_fi. Column nimi_fi has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Joutjärven melontakeskus... and first 25 characters of maximum string: Turun Soutu- ja Melontake...
nimi_se string Data source did not contain a description for nimi_se. Column nimi_se has 9 rows, out of which 5 are empty, making the null percent 55.56. Minimum string is and maximum string is Soutu- ja melontastadion.
nimi_en string Data source did not contain a description for nimi_en. Column nimi_en has 9 rows, out of which 4 are empty, making the null percent 44.44. Minimum string is and maximum string is Soutu- ja melontastadion.
sahkoposti string Data source did not contain a description for sahkoposti. Column sahkoposti has 9 rows, out of which 7 are empty, making the null percent 77.78. First 25 characters of minimum string: ... and first 25 characters of maximum string: valkeakoskenvesiveikot[at...
www string Data source did not contain a description for www. Column www has 9 rows, out of which 2 are empty, making the null percent 22.22. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.hel.fi/kulttu...
puhelinnum string Data source did not contain a description for puhelinnum. Column puhelinnum has 9 rows, out of which 5 are empty, making the null percent 55.56. Minimum string is and maximum string is 09 310 71513.
koulun_lii string Data source did not contain a description for koulun_lii. Column koulun_lii has 9 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 9 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 9 rows, out of which 1 are empty, making the null percent 11.11. Minimum value is 0 and maximum value is 1988.
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 9 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 9 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 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alanteentie and maximum string is Uimarannankatu 3.
postinumer int Data source did not contain a description for postinumer. Column postinumer has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 260 and maximum value is 90650.
postitoimi string Data source did not contain a description for postitoimi. Column postitoimi has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Helsinki and maximum string is Valkeakoski.
kunta_nimi string Data source did not contain a description for kunta_nimi. Column kunta_nimi has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Helsinki and maximum string is Valkeakoski.
kuntanumer int Data source did not contain a description for kuntanumer. Column kuntanumer has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91 and maximum value is 908.
kuntaosa string Data source did not contain a description for kuntaosa. Column kuntaosa has 9 rows, out of which 6 are empty, making the null percent 66.67. Minimum string is and maximum string is Taka-Töölö.
tyyppikood int Data source did not contain a description for tyyppikood. Column tyyppikood has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5110.
tyyppi_nim string Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Soutustadion.
muokattu_v date Data source did not contain a description for muokattu_v. Column is empty.
yleiso_wc boolean Data source did not contain a description for yleiso_wc.
automaatti string Data source did not contain a description for automaatti. Column automaatti has 9 rows, out of which 8 are empty, making the null percent 88.89. The single string value is: .
pinta_ala int Data source did not contain a description for pinta_ala. Column pinta_ala has 9 rows, out of which 8 are empty, making the null percent 88.89. Constant value is 716.
katsomo_ka int Data source did not contain a description for katsomo_ka. Column katsomo_ka has 9 rows, out of which 4 are empty, making the null percent 44.44. Minimum value is 0 and maximum value is 1000.
laituri boolean Data source did not contain a description for laituri.
lisatieto string Data source did not contain a description for lisatieto. Column lisatieto has 9 rows, out of which 5 are empty, making the null percent 55.56. First 25 characters of minimum string: ... and first 25 characters of maximum string: Soutajille stadionilla on...
radan_pitu int Data source did not contain a description for radan_pitu. Column radan_pitu has 9 rows, out of which 3 are empty, making the null percent 33.33. Minimum value is 0 and maximum value is 2000.
tulostaulu string Data source did not contain a description for tulostaulu. Column tulostaulu has 9 rows, out of which 8 are empty, making the null percent 88.89. The single string value is: .
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 9 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.262228436210336... and first 25 characters of maximum string: POINT (28.382938172408338...
geom_center_x float Longitude of center. Column geom_center_x has 9 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.26 and maximum value is 28.38.
geom_center_y float Latitude of center. Column geom_center_y has 9 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.02.
geom_type string Geometry type. Column geom_type has 9 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 10, 2018