Version History of Kauniainen Small Area Polygons from Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
This table contains the version history of the base table 'seutukarttakauniainen_pienalueet__kauniainen_pienalueetpolygon'. It includes additional columns '_start_date' and '_end_date', representing the extraction dates of each row. The data in this table is sourced from the website of 'Helsinki Urban Environment Division', which originates from the country with the ISO country code 'FI'. The table can be leveraged for various data analytics purposes, such as analyzing changes and updates made to the base table over time, tracking historical trends and patterns, and identifying the most recent version of rows based on the '_end_date' column.
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 | A unique identifier for each row version in the table. |
|---|
| kokotun | int | The value of the 'kokotun' column in the base table for the given row version. |
|---|
| kunta | int | The value of the 'kunta' column in the base table for the given row version. |
|---|
| suur | int | The value of the 'suur' column in the base table for the given row version. |
|---|
| tila | int | The value of the 'tila' column in the base table for the given row version. |
|---|
| pien | int | The value of the 'pien' column in the base table for the given row version. |
|---|
| nimi | string | The value of the 'nimi' column in the base table for the given row version. |
|---|
| nimi_iso | string | The value of the 'nimi_iso' column in the base table for the given row version. |
|---|
| mtryhm | int | The value of the 'mtryhm' column in the base table for the given row version. |
|---|
| geom_geojson | string | The value of the 'geom_geojson' column in the base table for the given row version. |
|---|
| geom_geotext | string | The value of the 'geom_geotext' column in the base table for the given row version. |
|---|
| geom_type | string | The value of the 'geom_type' column in the base table for the given row version. |
|---|
| geom_centroid | string | The value of the 'geom_centroid' column in the base table for the given row version. |
|---|
| geom_center_x | double | The X-coordinate of the center point of the geometry in the 'geom' column for the given row version. |
|---|
| geom_center_y | double | The Y-coordinate of the center point of the geometry in the 'geom' column for the given row version. |
|---|
| geom | binary | The geometry value for the given row version in the base table. |
|---|
