Version History of Statistical Areas in Kerava, Sourced from Helsinki City Environment Sector in Finland
Click here for a data sample
This table contains the version history of the rows from the 'seutukarttakerava_tilastoalueet__kerava_tilastoalueetpolygon' table. Each row in this table represents a specific version of a row from the base table. The '_start_date' column indicates the date when the 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 '_end_date' value is null, it means that the row is the most recent version. The data in this table originates from the web site of 'Helsinki City Planning Department', which is part of the 'Helsinki Metropolitan Area'. The source country for the data is Finland (FI).
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The timestamp indicating the start of the validity period for the row version. |
|---|
| _end_date | date | The timestamp indicating the end of the validity period for the row version. |
|---|
| _row_number | long | The unique identifier representing the version history of the row. |
|---|
| kokotun | int | The attribute representing the 'kokotun' value of the row. |
|---|
| kunta | int | The attribute representing the 'kunta' value of the row. |
|---|
| suur | int | The attribute representing the 'suur' value of the row. |
|---|
| tila | int | The attribute representing the 'tila' value of the row. |
|---|
| nimi | string | The attribute representing the 'nimi' value of the row. |
|---|
| nimi_iso | string | The attribute representing the 'nimi_iso' value of the row. |
|---|
| mtryhm | int | The attribute representing the 'mtryhm' value of the row. |
|---|
| geom_geojson | string | The attribute representing the 'geom_geojson' value of the row. |
|---|
| geom_geotext | string | The attribute representing the 'geom_geotext' value of the row. |
|---|
| geom_type | string | The attribute representing the 'geom_type' value of the row. |
|---|
| geom_centroid | string | The attribute representing the centroid of the geometry of the row. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the row. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the row. |
|---|
| geom | binary | The attribute representing the geometry of the row. |
|---|
