Version History of 'Rauh Naturaline' Data from Helsinki City 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 extracted from the website of 'Helsinki City Environment Services'. The data in this table is sourced from the 'Rauh Natural Area Database'. The data in this table is specific to the country Finland (ISO country code: fi). The table has additional columns '_start_date' and '_end_date' compared to its base table. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The table contains various columns such as 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'pinta_ala', 'kohdetekst', 'metadata', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table can be utilized for data analytics purposes such as spatial analysis, finding centroids, calculating surface areas, examining metadata, and investigating the temporal changes and updates in the natural areas of Helsinki.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the validity period for the row version.
_end_datedateThe end date of the validity period for the row version.
_row_numberlongThe number indicating the order of the row version.
idintThe unique identifier of the row.
tunnusstringThe identifier of the row.
luokkatunnstringThe identifier of the class.
luokan_nimstringThe name of the class.
nimistringThe name of the row.
kuvausstringThe description of the row.
huomstringAdditional notes about the row.
digipvmdateThe digital date of the row.
pvm_editoidateThe date when the row was last edited.
pinta_alafloatThe surface area of the row.
kohdetekststringThe target text of the row.
metadatastringThe metadata of the row.
geom_geojsonstringThe geometric data of the row in GEOJSON format.
geom_geotextstringThe geometric data of the row in GEOTEXT format.
geom_typestringThe type of the geometry of the row.
geom_centroidstringThe centroid of the geometry of the row.
geom_center_xdoubleThe x-coordinate of the center point of the geometry of the row.
geom_center_ydoubleThe y-coordinate of the center point of the geometry of the row.
geombinaryThe geometric representation of the row.

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
Id5d707d5f-2004-4143-a4cb-655688bfd3d3
Package id162911a9-5cef-402b-8235-c3e46e667f8a
Position1
Revision id283e4d19-9055-4388-a310-ad966f2d15b3
Stateactive
Tableltj_avoinrauh_natura__rauh_naturaline__history