Lipas 5140 vesihiihtoalue

Tables

Lipas 5140 vesihiihtoalue, Lipaslipas 5140 vesihiihtoalue, Full historyTSV
No description available for layer lipas:lipas_5140_vesihiihtoalue (lipas_5140_vesihiihtoalue)
Lipas 5140 vesihiihtoalue, Lipaslipas 5140 vesihiihtoalue, LatestTSV
No description available for layer lipas:lipas_5140_vesihiihtoalue (lipas_5140_vesihiihtoalue)

Column Descriptions

Lipas 5140 vesihiihtoalue, Lipaslipas 5140 vesihiihtoalue, Full history

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97542 and maximum value is 603646.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Harjavallan vesihiihtoalu... and first 25 characters of maximum string: Vesiurheilukeskus...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 6 rows, out of which 4 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ridenjoy wake park / Vatt...
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 6 rows, out of which 4 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Niihaman vesihiihtokeskus...
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 6 rows, out of which 4 are empty, making the null percent 66.67. Minimum string is and maximum string is info@ridenjoy.fi.
www	string	Data source did not contain a description for www. Column www has 6 rows, out of which 2 are empty, making the null percent 33.33. Minimum string is and maximum string is www.ridenjoy.fi.
puhelinnum	int	Data source did not contain a description for puhelinnum. Column puhelinnum has 6 rows, out of which 5 are empty, making the null percent 83.33. Constant value is 442393817.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 6 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 6 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 6 rows, out of which 2 are empty, making the null percent 33.33. Minimum value is 1975 and maximum value is 2019.
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 6 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 6 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 / yritys.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Keilalahdentie 8 and maximum string is Ritokallionpolku 3.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 330 and maximum value is 76130.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 6 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 Tampere.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 6 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 Tampere.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 6 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 837.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 6 rows, out of which 4 are empty, making the null percent 66.67. Minimum string is and maximum string is Otaniemi.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5140.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Vesihiihtoalue.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
pinta_alak	string	Data source did not contain a description for pinta_alak. Column is empty.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 6 rows, out of which 4 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Laguunissa on noin 600m2 ...
laituri	boolean	Data source did not contain a description for laituri.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 6 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.157704297740043... and first 25 characters of maximum string: POINT (27.132161443366783...
geom_center_x	float	Longitude of center. Column geom_center_x has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.16 and maximum value is 27.13.
geom_center_y	float	Latitude of center. Column geom_center_y has 6 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.62.
geom_type	string	Geometry type. Column geom_type has 6 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 5140 vesihiihtoalue, Lipaslipas 5140 vesihiihtoalue, Latest

Column	Type	Comment
id	int	Data source did not contain a description for id. Column id has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 97542 and maximum value is 603646.
nimi_fi	string	Data source did not contain a description for nimi_fi. Column nimi_fi has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Harjavallan vesihiihtoalu... and first 25 characters of maximum string: Vesiurheilukeskus...
nimi_se	string	Data source did not contain a description for nimi_se. Column nimi_se has 6 rows, out of which 4 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ridenjoy wake park / Vatt...
nimi_en	string	Data source did not contain a description for nimi_en. Column nimi_en has 6 rows, out of which 4 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Niihaman vesihiihtokeskus...
sahkoposti	string	Data source did not contain a description for sahkoposti. Column sahkoposti has 6 rows, out of which 4 are empty, making the null percent 66.67. Minimum string is and maximum string is info@ridenjoy.fi.
www	string	Data source did not contain a description for www. Column www has 6 rows, out of which 2 are empty, making the null percent 33.33. Minimum string is and maximum string is www.ridenjoy.fi.
puhelinnum	int	Data source did not contain a description for puhelinnum. Column puhelinnum has 6 rows, out of which 5 are empty, making the null percent 83.33. Constant value is 442393817.
koulun_lii	string	Data source did not contain a description for koulun_lii. Column koulun_lii has 6 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 6 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 6 rows, out of which 2 are empty, making the null percent 33.33. Minimum value is 1975 and maximum value is 2019.
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 6 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 6 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 / yritys.
katuosoite	string	Data source did not contain a description for katuosoite. Column katuosoite has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Keilalahdentie 8 and maximum string is Ritokallionpolku 3.
postinumer	int	Data source did not contain a description for postinumer. Column postinumer has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 330 and maximum value is 76130.
postitoimi	string	Data source did not contain a description for postitoimi. Column postitoimi has 6 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 Tampere.
kunta_nimi	string	Data source did not contain a description for kunta_nimi. Column kunta_nimi has 6 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 Tampere.
kuntanumer	int	Data source did not contain a description for kuntanumer. Column kuntanumer has 6 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 837.
kuntaosa	string	Data source did not contain a description for kuntaosa. Column kuntaosa has 6 rows, out of which 4 are empty, making the null percent 66.67. Minimum string is and maximum string is Otaniemi.
tyyppikood	int	Data source did not contain a description for tyyppikood. Column tyyppikood has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 5140.
tyyppi_nim	string	Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Vesihiihtoalue.
muokattu_v	date	Data source did not contain a description for muokattu_v. Column is empty.
pinta_alak	string	Data source did not contain a description for pinta_alak. Column is empty.
lisatieto	string	Data source did not contain a description for lisatieto. Column lisatieto has 6 rows, out of which 4 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: Laguunissa on noin 600m2 ...
laituri	boolean	Data source did not contain a description for laituri.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 6 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.157704297740043... and first 25 characters of maximum string: POINT (27.132161443366783...
geom_center_x	float	Longitude of center. Column geom_center_x has 6 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.16 and maximum value is 27.13.
geom_center_y	float	Latitude of center. Column geom_center_y has 6 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.62.
geom_type	string	Geometry type. Column geom_type has 6 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