Historical Version of Valuable Vegetation Areas Polygon in Helsinki Urban Environment Sector, Finland
Click here for a data sample
This table contains the version history of the rows in the 'Arvokkaat_kasvikohteetPolygon' table sourced from the website of 'Helsinki City Environment Services' in Finland. It provides information about various valuable plant locations. The table includes columns such as '_start_date', '_end_date', 'row_number', 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'pinta_ala', 'kohdetekst', 'arvoluokka', 'arvoluokan', 'metadata', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column denotes the date when a particular row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it signifies that the row is the most recent version. This table is suitable for data analytics purposes, such as analyzing changes over time in the characteristics of valuable plant locations, calculating the area of these locations, and studying the distribution patterns and geometry of the plants' locations.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date indicating the validity period of the row version. |
_end_date | date | The end date indicating the validity period of the row version. |
_row_number | long | The unique row number of the version in the table. |
id | int | The unique identifier for the row. |
tunnus | string | The tunnus column. |
luokkatunn | string | The luokkatunn column. |
luokan_nim | string | The luokan_nim column. |
nimi | string | The nimi column. |
kuvaus | string | The kuvaus column. |
huom | string | The huom column. |
digipvm | string | The digipvm column. |
pvm_editoi | string | The pvm_editoi column. |
pinta_ala | float | The pinta_ala column. |
kohdetekst | string | The kohdetekst column. |
arvoluokka | string | The arvoluokka column. |
arvoluokan | string | The arvoluokan column. |
metadata | string | The metadata column. |
geom_geojson | string | The geom_geojson column. |
geom_geotext | string | The geom_geotext column. |
geom_type | string | The geom_type column. |
geom_centroid | string | The geom_centroid column. |
geom_center_x | double | The geom_center_x column. |
geom_center_y | double | The geom_center_y column. |
geom | binary | The geom column. |