Historical Versions of Protection Area Blocks in Helsinki, Finland
Click here for a data sample
This table contains the version history of rows from the 'Helsingin kaupunkiympariston toimiala' website's base table 'helpel_suojelulohko__pel_suojelulohko'. It is sourced from the country with ISO country code 'fi'. Each row in this table represents a specific version of a row from the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates of the row versions. The table contains various columns such as 'gml_id', 'kunta', 'kunta_nimi', 'kunta_nim0', 'suojeluloh', 'suojelulo0', 'suojelulo1', 'suojelupii', 'suojelupi0', 'suojelupi1', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which provide additional information about the rows. This historical table can be utilized in data analytics to track changes in the data over time, analyze trends, identify updates or modifications in the base table, and perform comparisons between different versions of the rows.
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 number assigned to the row version in the table. |
|---|
| gml_id | string | The unique identifier of the row version in the GML format. |
|---|
| kunta | int | The code representing the 'kunta' attribute of the row version. |
|---|
| kunta_nimi | string | The name of the 'kunta' attribute of the row version. |
|---|
| kunta_nim0 | string | The previous name of the 'kunta' attribute of the row version. |
|---|
| suojeluloh | string | The code representing the 'suojeluloh' attribute of the row version. |
|---|
| suojelulo0 | string | The previous value of the 'suojelulo' attribute of the row version. |
|---|
| suojelulo1 | int | The current value of the 'suojelulo' attribute of the row version. |
|---|
| suojelupii | string | The code representing the 'suojelupii' attribute of the row version. |
|---|
| suojelupi0 | string | The previous value of the 'suojelupii' attribute of the row version. |
|---|
| suojelupi1 | int | The current value of the 'suojelupii' attribute of 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 Geotext format. |
|---|
| geom_type | string | The type of geometry of the row version. |
|---|
| geom_centroid | string | The centroid of the geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the centroid of the geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the centroid of the geometry of the row version. |
|---|
| geom | binary | The spatial data structure representing the geometry of the row version. |
|---|
