Version History of Statistical Areas in Hyvinkaa, sourced from Helsingin kaupunkiympariston toimiala (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 rows from the base table 'seutukarttahyvinkaa_tilastoalueet__hyvinkaa_tilastoalueetpolygon'. Each row in this table represents a specific version of a row in the base table, with additional columns '_start_date' and '_end_date'. The '_start_date' column holds the date when the specific version of the row was extracted from the data source. The '_end_date' column denotes the date when a new version of the row was extracted, or it is null if the row is the most recent version. The data in this table is sourced from the website of Helsingin kaupunkiympariston toimiala, which is operated by the country with ISO country code 'fi'. The table provides valuable data for data analytics, such as analyzing changes and trends over time in various attributes of the base table rows, including 'kokotun', 'kunta', 'suur', 'tila', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. Utilizing this historical information can help in gaining insights into patterns and patterns, and perform in-depth analysis of the evolving trends.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the row version validity period.
_end_datedateThe end date of the row version validity period.
_row_numberlongThe number assigned to the row version.
kokotunintThe value of column kokotun.
kuntaintThe value of column kunta.
suurintThe value of column suur.
tilaintThe value of column tila.
nimistringThe value of column nimi.
nimi_isostringThe value of column nimi_iso.
mtryhmintThe value of column mtryhm.
geom_geojsonstringThe value of column geom_geojson.
geom_geotextstringThe value of column geom_geotext.
geom_typestringThe value of column geom_type.
geom_centroidstringThe centroid of the geometry.
geom_center_xdoubleThe x-coordinate of the geometry's center point.
geom_center_ydoubleThe y-coordinate of the geometry's center point.
geombinaryThe geometry object.

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
Id33e6162c-6a0b-4879-82ba-50eacebe8b20
Package id115174be-9231-45f8-8cff-b7900f966958
Position1
Revision id905886f5-14e0-4608-84a0-db77ceee94e6
Stateactive
Tableseutukarttahyvinkaa_tilastoalueet__hyvinkaa_tilastoalueetpolygon__history