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

LTJ avoin rauhoitettu luonnonmuistomerkit

No description available for layer avoindata:LTJ_avoin_rauhoitettu_luonnonmuistomerkit (LTJ_avoin_rauhoitettu_luonnonmuistomerkit)

Tables

Column Descriptions

Ltj avoin rauhoitettu luonnonmuistomerkitpoint, Avoindataltj avoin rauhoitettu luonnonmuistomerkit, 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 1 and maximum value is 179596.
tunnus int 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 value is 1 and maximum value is 34.
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: Lmm.
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: Luonnonmuistomerkki.
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: Hiidenkirnu, Käpylä... and first 25 characters of maximum string: Viiden tammen ryhmä, Meil...
kuvaus string Data source did not contain a description for kuvaus. Column kuvaus has 31 rows, out of which 24 are empty, making the null percent 77.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: Toinen kirnuista on Helsi...
huom string Data source did not contain a description for huom. Column huom has 31 rows, out of which 18 are empty, making the null percent 58.06. The single string value is: Rauhoitettu kaupungin oma...
pinta_ala int 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. Constant value is 0.
kohdetekst string Data source did not contain a description for kohdetekst. Column kohdetekst has 31 rows, out of which 2 are empty, making the null percent 6.45. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vuonna 2003 tehdyn mittau...
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: POINT (24.858659010103633... and first 25 characters of maximum string: POINT (25.23367179482834 ...
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.86 and maximum value is 25.23.
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.15 and maximum value is 60.28.
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. The single string value is: ST_POINT.

Ltj avoin rauhoitettu luonnonmuistomerkitpoint, Avoindataltj avoin rauhoitettu luonnonmuistomerkit, 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 1 and maximum value is 179596.
tunnus int 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 value is 1 and maximum value is 34.
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: Lmm.
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: Luonnonmuistomerkki.
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: Hiidenkirnu, Käpylä... and first 25 characters of maximum string: Viiden tammen ryhmä, Meil...
kuvaus string Data source did not contain a description for kuvaus. Column kuvaus has 31 rows, out of which 24 are empty, making the null percent 77.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: Toinen kirnuista on Helsi...
huom string Data source did not contain a description for huom. Column huom has 31 rows, out of which 18 are empty, making the null percent 58.06. The single string value is: Rauhoitettu kaupungin oma...
pinta_ala int 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. Constant value is 0.
kohdetekst string Data source did not contain a description for kohdetekst. Column kohdetekst has 31 rows, out of which 2 are empty, making the null percent 6.45. First 25 characters of minimum string: ... and first 25 characters of maximum string: Vuonna 2003 tehdyn mittau...
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: POINT (24.858659010103633... and first 25 characters of maximum string: POINT (25.23367179482834 ...
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.86 and maximum value is 25.23.
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.15 and maximum value is 60.28.
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. The single string value is: ST_POINT.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated July 6, 2022
Created July 6, 2022