Version History of 'Protection Area Polygon' in 'Helsinki Urban Environment Department' sourced from 'Finland'
Click here for a data sample
This table represents the version history of the 'suojelupiiripolygon' table sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland. It includes the columns '_start_date', '_end_date', '_row_number', 'id', 'suojelupii', 'kunta', 'suojelupi0', 'suojelupi1', 'kunta_nimi', 'kunta_nim0', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column contains the date when a row was extracted, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' value is null, it means the row is the most recent version. This table provides valuable information for data analytics, such as tracking changes in 'suojelupiiripolygon' over time, identifying historical trends, conducting spatial analysis using the geometry columns, and deriving insights about protected circular areas ('suojelupii') and their related attributes in different municipalities ('kunta').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | Date when the row version starts being valid. |
_end_date | date | Date when the row version stops being valid. |
_row_number | long | Number indicating the order of the row version within the base table. |
id | int | Unique identifier for each row version. |
suojelupii | int | Field related to protection level. |
kunta | int | Field related to municipality. |
suojelupi0 | string | Field related to protection level (similar to suojelupii). |
suojelupi1 | string | Field related to protection level (similar to suojelupii). |
kunta_nimi | string | Field related to municipality name. |
kunta_nim0 | string | Field related to municipality name (similar to kunta_nimi). |
geom_geojson | string | Geometry field in geoJSON format. |
geom_geotext | string | Field containing text representation of the geometry. |
geom_type | string | Type of the geometry (e.g. point, line, polygon). |
geom_centroid | string | Centroid of the geometry. |
geom_center_x | double | X-coordinate of the center of the geometry. |
geom_center_y | double | Y-coordinate of the center of the geometry. |
geom | binary | Field containing the actual geometry data. |