Version History of Suuralueet in Vihdi, sourced from Helsingin kaupunkiympariston toimiala (Finland)
Click here for a data sample
This table contains the version history of the 'seutukarttavihti_suuralueet__vihti_suuralueetpolygon' table. The table was sourced from the website of Helsingin kaupunkiympariston toimiala, which is the Urban Environment Division of the City of Helsinki, Finland (ISO country code: FI). The table records the changes made to the base table over time, with two additional columns '_start_date' and '_end_date'. The '_start_date' column indicates the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The table is valuable for data analytics purposes, allowing users to track the historical changes made to the data, perform trend analysis, and identify patterns or anomalies over time.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The number of the row version. |
kokotun | int | Description of column 'kokotun' is not available. |
kunta | int | Description of column 'kunta' is not available. |
suur | int | Description of column 'suur' is not available. |
nimi_uusi | string | Description of column 'nimi_uusi' is not available. |
nimi_iso | string | Description of column 'nimi_iso' is not available. |
mtryhm | int | Description of column 'mtryhm' is not available. |
geom_geojson | string | Description of column 'geom_geojson' is not available. |
geom_geotext | string | Description of column 'geom_geotext' is not available. |
geom_type | string | Description of column 'geom_type' is not available. |
geom_centroid | string | Description of column 'geom_centroid' is not available. |
geom_center_x | double | Description of column 'geom_center_x' is not available. |
geom_center_y | double | Description of column 'geom_center_y' is not available. |
geom | binary | Description of column 'geom' is not available. |