Protective Areas in the Municipality - Helsingin kaupunkiymparisto - Finland

To download the data set, please sign up or log in

Click here for a data sample

This table contains data from 'Helsinki City environment sector' website, sourced from Finland. It provides information about protected areas ('suojelualalohko') in different municipalities ('kunta') across the country. The table includes various attributes such as the extraction date ('_extract_date'), row number ('_row_number'), GML identifier ('gml_id'), municipal names ('kunta_nimi'), protected area names ('suojeluala'), and other related attributes. The table also includes geographical information like the GeoJSON representation ('geom_geojson'), geospatial text representation ('geom_geotext'), and centroid point coordinates ('geom_centroid'). The 'geom' column stores the geometric information of the protected areas. This table can be utilized for data analytics purposes such as analyzing the distribution of protected areas across municipalities, calculating the area of each protected area, identifying the type of geometry used, and determining the central point of each protected area in terms of X and Y coordinates.

Field Descriptions

Name Data type Description
_extract_datedateDate when the data was extracted
_row_numberlongNumber assigned to each row of the table
gml_idstringUnique identifier for each record
kuntaintCode representing the municipality
kunta_nimistringName of the municipality
kunta_nim0stringAlternative name of the municipality
suojelualastringCode representing a protected area
suojelual0stringAlternative code representing a protected area
suojelual1intAnother alternative code representing a protected area
suojelulohstringCode representing a protected area division
suojelulo0stringAnother code representing a protected area division
suojelulo1intAnother code representing a protected area division
suojelupiistringCode representing a protected area sub-region
suojelupi0stringAnother code representing a protected area sub-region
suojelupi1intAnother code representing a protected area sub-region
geom_geojsonstringGeometry in GeoJSON format
geom_geotextstringGeometry in geotext format
geom_typestringType of geometry
geom_centroidstringCentroid point of the geometry
geom_center_xdoubleX coordinate of the geometry centroid
geom_center_ydoubleY coordinate of the geometry centroid
geombinaryGeometry in an unspecified format

No sample for this dataset

Additional Information

Last updated April 24, 2024
Created April 24, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Id9addbaf0-7fa9-452f-91a5-f832904192fb
Package idf4d2871a-a30c-41f8-85fe-f5c15bd0b23e
Revision idb9169480-bf9a-4379-93da-8a5a576f42c5
Stateactive
Tablehelpel_suojelualalohko__pel_suojelualalohko