Version History of Statistical Areas in Hyvinkaa, sourced from Helsingin kaupunkiympariston toimiala (Finland)
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_date | date | The start date of the row version validity period. |
_end_date | date | The end date of the row version validity period. |
_row_number | long | The number assigned to the row version. |
kokotun | int | The value of column kokotun. |
kunta | int | The value of column kunta. |
suur | int | The value of column suur. |
tila | int | The value of column tila. |
nimi | string | The value of column nimi. |
nimi_iso | string | The value of column nimi_iso. |
mtryhm | int | The value of column mtryhm. |
geom_geojson | string | The value of column geom_geojson. |
geom_geotext | string | The value of column geom_geotext. |
geom_type | string | The value of column geom_type. |
geom_centroid | string | The centroid of the geometry. |
geom_center_x | double | The x-coordinate of the geometry's center point. |
geom_center_y | double | The y-coordinate of the geometry's center point. |
geom | binary | The geometry object. |