Protective Areas in the Municipality - Helsingin kaupunkiymparisto - Finland
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_date | date | Date when the data was extracted |
_row_number | long | Number assigned to each row of the table |
gml_id | string | Unique identifier for each record |
kunta | int | Code representing the municipality |
kunta_nimi | string | Name of the municipality |
kunta_nim0 | string | Alternative name of the municipality |
suojeluala | string | Code representing a protected area |
suojelual0 | string | Alternative code representing a protected area |
suojelual1 | int | Another alternative code representing a protected area |
suojeluloh | string | Code representing a protected area division |
suojelulo0 | string | Another code representing a protected area division |
suojelulo1 | int | Another code representing a protected area division |
suojelupii | string | Code representing a protected area sub-region |
suojelupi0 | string | Another code representing a protected area sub-region |
suojelupi1 | int | Another code representing a protected area sub-region |
geom_geojson | string | Geometry in GeoJSON format |
geom_geotext | string | Geometry in geotext format |
geom_type | string | Type of geometry |
geom_centroid | string | Centroid point of the geometry |
geom_center_x | double | X coordinate of the geometry centroid |
geom_center_y | double | Y coordinate of the geometry centroid |
geom | binary | Geometry in an unspecified format |