Version History of Area Statistics in Pornainen, Finland
Click here for a data sample
This table contains the version history of rows from the table 'seutukarttapornainen_tilastoalueet__pornainen_tilastoalueetpolygon'. The rows in this table represent the different versions of the base table rows, with each version having a corresponding '_start_date' and '_end_date' indicating the extraction dates. The base table provides various information such as 'kokotun', 'kunta', 'suur', 'tila', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. This version history table can be utilized in data analytics by tracking changes and analyzing trends over time. For example, it can be used to identify when and how certain attributes of the base table rows have changed, monitor update frequencies, and analyze the impact of changes on other related data. The data in this table is sourced from the website of 'Helsinki City Environment on Sector' which originates from Finland (ISO country code 'fi').
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 assigned number of the row version. |
kokotun | int | Description not available. |
kunta | int | Description not available. |
suur | string | Description not available. |
tila | int | Description not available. |
nimi | string | Description not available. |
nimi_iso | string | Description not available. |
mtryhm | int | Description not available. |
geom_geojson | string | Description not available. |
geom_geotext | string | Description not available. |
geom_type | string | Description not available. |
geom_centroid | string | Description not available. |
geom_center_x | double | Description not available. |
geom_center_y | double | Description not available. |
geom | binary | Description not available. |