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