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

LTJ avoin muut luontokohteet

No description available for layer avoindata:LTJ_avoin_muut_luontokohteet (LTJ_avoin_muut_luontokohteet)

Tables

Column Descriptions

Ltj avoin muut luontokohteetpolygon, Avoindataltj avoin muut luontokohteet, Full history

Column Type Comment
id int Data source did not contain a description for id. Column id has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 175710 and maximum value is 176277.
tunnus string Data source did not contain a description for tunnus. Column tunnus has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is HKR 1 and maximum string is KSV 1.
luokkatunn string Data source did not contain a description for luokkatunn. Column luokkatunn has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: MUU.
luokan_nim string Data source did not contain a description for luokan_nim. Column luokan_nim has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Muut luontokohteet.
nimi string Data source did not contain a description for nimi. Column nimi has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Alppipuiston eteläosa, ka... and first 25 characters of maximum string: Yliskylän kartanopuisto v...
kuvaus string Data source did not contain a description for kuvaus. Column kuvaus has 31 rows, out of which 28 are empty, making the null percent 90.32. First 25 characters of minimum string: ... and first 25 characters of maximum string: Kolmeosainen kohde: Eugen...
huom string Data source did not contain a description for huom. Column huom has 31 rows, out of which 29 are empty, making the null percent 93.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Kohteesta on tallennettu ...
pinta_ala float Data source did not contain a description for pinta_ala. Column pinta_ala has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0.2 and maximum value is 94.26.
kohdetekst string Data source did not contain a description for kohdetekst. Column is empty.
metadata string Data source did not contain a description for metadata. Column metadata has 31 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 31 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 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.932016... and first 25 characters of maximum string: POLYGON ((25.160018421444...
geom_center_x float Longitude of center. Column geom_center_x has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.87 and maximum value is 25.16.
geom_center_y float Latitude of center. Column geom_center_y has 31 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.27.
geom_type string Geometry type. Column geom_type has 31 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.

Ltj avoin muut luontokohteetpolygon, Avoindataltj avoin muut luontokohteet, Latest

Column Type Comment
id int Data source did not contain a description for id. Column id has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 175710 and maximum value is 176277.
tunnus string Data source did not contain a description for tunnus. Column tunnus has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum string is HKR 1 and maximum string is KSV 1.
luokkatunn string Data source did not contain a description for luokkatunn. Column luokkatunn has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: MUU.
luokan_nim string Data source did not contain a description for luokan_nim. Column luokan_nim has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. The single string value is: Muut luontokohteet.
nimi string Data source did not contain a description for nimi. Column nimi has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: Alppipuiston eteläosa, ka... and first 25 characters of maximum string: Yliskylän kartanopuisto v...
kuvaus string Data source did not contain a description for kuvaus. Column kuvaus has 31 rows, out of which 28 are empty, making the null percent 90.32. First 25 characters of minimum string: ... and first 25 characters of maximum string: Kolmeosainen kohde: Eugen...
huom string Data source did not contain a description for huom. Column huom has 31 rows, out of which 29 are empty, making the null percent 93.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Kohteesta on tallennettu ...
pinta_ala float Data source did not contain a description for pinta_ala. Column pinta_ala has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 0.2 and maximum value is 94.26.
kohdetekst string Data source did not contain a description for kohdetekst. Column is empty.
metadata string Data source did not contain a description for metadata. Column metadata has 31 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 31 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 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((24.932016... and first 25 characters of maximum string: POLYGON ((25.160018421444...
geom_center_x float Longitude of center. Column geom_center_x has 31 rows, out of which 0 are empty, making the null percent 0. The column is fully populated. Minimum value is 24.87 and maximum value is 25.16.
geom_center_y float Latitude of center. Column geom_center_y has 31 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.27.
geom_type string Geometry type. Column geom_type has 31 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.

Additional Info

Last Updated July 6, 2022
Created July 6, 2022