Historical Version of Valuable Vegetation Areas Polygon in Helsinki Urban Environment Sector, Finland

To download the data set, please sign up or log in

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_datedateThe start date indicating the validity period of the row version.
_end_datedateThe end date indicating the validity period of the row version.
_row_numberlongThe unique row number of the version in the table.
idintThe unique identifier for the row.
tunnusstringThe tunnus column.
luokkatunnstringThe luokkatunn column.
luokan_nimstringThe luokan_nim column.
nimistringThe nimi column.
kuvausstringThe kuvaus column.
huomstringThe huom column.
digipvmstringThe digipvm column.
pvm_editoistringThe pvm_editoi column.
pinta_alafloatThe pinta_ala column.
kohdetekststringThe kohdetekst column.
arvoluokkastringThe arvoluokka column.
arvoluokanstringThe arvoluokan column.
metadatastringThe metadata column.
geom_geojsonstringThe geom_geojson column.
geom_geotextstringThe geom_geotext column.
geom_typestringThe geom_type column.
geom_centroidstringThe geom_centroid column.
geom_center_xdoubleThe geom_center_x column.
geom_center_ydoubleThe geom_center_y column.
geombinaryThe geom column.

No sample for this dataset

Additional Information

Last updated April 23, 2024
Created April 23, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Id00b568bb-675d-44a7-8edd-287c2132f895
Package idd2cd29bd-76eb-4d78-9406-d39d7e63e371
Position1
Revision id056abbc5-c447-443f-88e1-7bb017707b7e
Stateactive
Tableltj_avoinarvokkaat_kasvikohteet__arvokkaat_kasvikohteetpolygon__history