Version History of Statistical Areas in Kirkkonummi - Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
This table contains the version history of the rows extracted from the data source 'Helsinki Urban Environment'. The table provides information about various statistical areas in Kirkkonummi, a municipality in Finland. The rows in this table represent different versions of the statistical area data over time. Each row includes the start and end dates, as well as other attributes like 'kokotun', 'kunta', 'suur', 'tila', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom'. The 'geom' column stores the geometric information of the statistical area. By analyzing the data in this table, one can gain insights into the changes and updates made to the statistical area data over time in Kirkkonummi, Finland.
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 | The value of the 'kokotun' column. |
|---|
| kunta | int | The value of the 'kunta' column. |
|---|
| suur | int | The value of the 'suur' column. |
|---|
| tila | int | The value of the 'tila' column. |
|---|
| nimi | string | The value of the 'nimi' column. |
|---|
| nimi_iso | string | The value of the 'nimi_iso' column. |
|---|
| mtryhm | int | The value of the 'mtryhm' column. |
|---|
| geom_geojson | string | The value of the 'geom_geojson' column. |
|---|
| geom_geotext | string | The value of the 'geom_geotext' column. |
|---|
| geom_type | string | The value of the 'geom_type' column. |
|---|
| geom_centroid | string | The centroid of the geometry specified in the 'geom' column. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry specified in the 'geom' column. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry specified in the 'geom' column. |
|---|
| geom | binary | The geometry of the row version. |
|---|
