1. Home
  2. Datasets
  3. LTJ avoin vesi purojen ja ...
To download the data set, please sign up or log in

LTJ avoin vesi purojen ja lampien valuma alueet

No description available for layer avoindata:LTJ_avoin_vesi_purojen_ja_lampien_valuma_alueet (LTJ_avoin_vesi_purojen_ja_lampien_valuma_alueet)

Tables

Column Descriptions

Ltj avoin vesi purojen ja lampien valuma alueetpolygon, Avoindataltj avoin vesi purojen ja lampien valuma alueet, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 177956 and maximum value is 182091.
tunnus string Data source did not contain a description for tunnus. Column tunnus has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is LAM01 and maximum string is P86.
luokkatunn string Data source did not contain a description for luokkatunn. Column luokkatunn has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: PPV.
luokan_nim string Data source did not contain a description for luokan_nim. Column luokan_nim has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Pienvesi: Purojen ja lamp...
nimi string Data source did not contain a description for nimi. Column nimi has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Fallbäcken valuma-alue... and first 25 characters of maximum string: Östersundominpuron valuma...
kuvaus string Data source did not contain a description for kuvaus. Column is empty.
huom string Data source did not contain a description for huom. Column is empty.
pinta_ala float Data source did not contain a description for pinta_ala. Column pinta_ala has 55 rows, out of which 2 are empty, making the null percent 3.64. Minimum value is 0.75 and maximum value is 3124.93.
kohdetekst string Data source did not contain a description for kohdetekst. Column kohdetekst has 55 rows, out of which 51 are empty, making the null percent 92.73. First 25 characters of minimum string: ... and first 25 characters of maximum string: Mätäjoki on ELY:n päätöks...
metadata string Data source did not contain a description for metadata. Column metadata has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: https://kartta.hel.fi/pai...
datanomist string Data source did not contain a description for datanomist. Column datanomist has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/LTJ.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((25.087908... and first 25 characters of maximum string: POLYGON ((25.234719250587...
geom_center_x float Longitude of center. Column geom_center_x has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.86 and maximum value is 25.23.
geom_center_y float Latitude of center. Column geom_center_y has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.14 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.

Ltj avoin vesi purojen ja lampien valuma alueetpolygon, Avoindataltj avoin vesi purojen ja lampien valuma alueet, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 177956 and maximum value is 182091.
tunnus string Data source did not contain a description for tunnus. Column tunnus has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is LAM01 and maximum string is P86.
luokkatunn string Data source did not contain a description for luokkatunn. Column luokkatunn has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: PPV.
luokan_nim string Data source did not contain a description for luokan_nim. Column luokan_nim has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Pienvesi: Purojen ja lamp...
nimi string Data source did not contain a description for nimi. Column nimi has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Fallbäcken valuma-alue... and first 25 characters of maximum string: Östersundominpuron valuma...
kuvaus string Data source did not contain a description for kuvaus. Column is empty.
huom string Data source did not contain a description for huom. Column is empty.
pinta_ala float Data source did not contain a description for pinta_ala. Column pinta_ala has 55 rows, out of which 2 are empty, making the null percent 3.64. Minimum value is 0.75 and maximum value is 3124.93.
kohdetekst string Data source did not contain a description for kohdetekst. Column kohdetekst has 55 rows, out of which 51 are empty, making the null percent 92.73. First 25 characters of minimum string: ... and first 25 characters of maximum string: Mätäjoki on ELY:n päätöks...
metadata string Data source did not contain a description for metadata. Column metadata has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: https://kartta.hel.fi/pai...
datanomist string Data source did not contain a description for datanomist. Column datanomist has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Helsinki/LTJ.
paivitetty date Data source did not contain a description for paivitetty. Column is empty.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((25.087908... and first 25 characters of maximum string: POLYGON ((25.234719250587...
geom_center_x float Longitude of center. Column geom_center_x has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.86 and maximum value is 25.23.
geom_center_y float Latitude of center. Column geom_center_y has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 60.14 and maximum value is 60.29.
geom_type string Geometry type. Column geom_type has 55 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 6, 2022
Created July 4, 2022