Version History of Protected Area Blocks in Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
This table contains the version history of the rows in the 'helpel_suojelualalohko__pel_suojelualalohko' table sourced from the website of 'Helsinki City Environment Division'. The table tracks changes to the rows over time, with each row having a start date and an end date. If the end date is null, it means that the row is the most recent version. The table includes columns such as '_start_date', '_end_date', 'gml_id', 'kunta', 'kunta_nimi', 'kunta_nim0', 'suojeluala', 'suojelual0', 'suojelual1', 'suojeluloh', 'suojelulo0', 'suojelulo1', 'suojelupii', 'suojelupi0', 'suojelupi1', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides valuable data that can be utilized for various data analytics purposes. For example, it can be used to analyze the changes in protected areas over time and their spatial distribution within municipalities. The data can also be used to study the characteristics and attributes of different types of protected areas or to identify patterns and trends in the protection of specific natural or cultural heritage sites. The source of this data is the official website of Helsinki City Environment Division and it originates from Finland (ISO country code 'fi').
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The row number of the version in the version history table. |
|---|
| gml_id | string | The globally unique identifier of the row version. |
|---|
| kunta | int | The code representing the municipality associated with the row version. |
|---|
| kunta_nimi | string | The name of the municipality associated with the row version. |
|---|
| kunta_nim0 | string | The alternative name of the municipality associated with the row version. |
|---|
| suojeluala | string | The code representing the protected area associated with the row version. |
|---|
| suojelual0 | string | The alternative code representing the protected area associated with the row version. |
|---|
| suojelual1 | int | Another alternative code representing the protected area associated with the row version. |
|---|
| suojeluloh | string | The code representing the protected site associated with the row version. |
|---|
| suojelulo0 | string | The alternative code representing the protected site associated with the row version. |
|---|
| suojelulo1 | int | Another alternative code representing the protected site associated with the row version. |
|---|
| suojelupii | string | The code representing the protected area boundary associated with the row version. |
|---|
| suojelupi0 | string | The alternative code representing the protected area boundary associated with the row version. |
|---|
| suojelupi1 | int | Another alternative code representing the protected area boundary associated with the row version. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in text format. |
|---|
| geom_type | string | The type of geometry of the row version. |
|---|
| geom_centroid | string | The centroid point of the geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the centroid point of the geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the centroid point of the geometry of the row version. |
|---|
| geom | binary | The full geometry of the row version. |
|---|
