Version History of 'Rauh Naturaline' Data from Helsinki City Environment Sector (Finland)
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_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The number indicating the order of the row version. |
id | int | The unique identifier of the row. |
tunnus | string | The identifier of the row. |
luokkatunn | string | The identifier of the class. |
luokan_nim | string | The name of the class. |
nimi | string | The name of the row. |
kuvaus | string | The description of the row. |
huom | string | Additional notes about the row. |
digipvm | date | The digital date of the row. |
pvm_editoi | date | The date when the row was last edited. |
pinta_ala | float | The surface area of the row. |
kohdetekst | string | The target text of the row. |
metadata | string | The metadata of the row. |
geom_geojson | string | The geometric data of the row in GEOJSON format. |
geom_geotext | string | The geometric data of the row in GEOTEXT format. |
geom_type | string | The type of the geometry of the row. |
geom_centroid | string | The centroid of the geometry of the row. |
geom_center_x | double | The x-coordinate of the center point of the geometry of the row. |
geom_center_y | double | The y-coordinate of the center point of the geometry of the row. |
geom | binary | The geometric representation of the row. |