Version History of 'Kirkkonummi Municipality Areas' in 'Helsinki Urban Environment Sector' Dataset from Finland
Click here for a data sample
This table contains the version history of the rows in the 'seutukarttakirkkonummi_suuralueet__kirkkonummi_suuralueetpolygon' table. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code: 'fi'). The '_start_date' column indicates the extraction date of each row, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The table includes additional columns such as 'kokotun', 'kunta', 'suur', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which contain various attributes related to the data. This table provides valuable information for data analytics purposes, allowing for the analysis and comparison of different versions of the rows over time.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the validity period of the row version. |
|---|
| _row_number | long | A unique identifier for each row version within the table. |
|---|
| kokotun | string | Unknown or unspecified column. |
|---|
| kunta | string | Unknown or unspecified column. |
|---|
| suur | string | Unknown or unspecified column. |
|---|
| nimi | string | Unknown or unspecified column. |
|---|
| nimi_iso | string | Unknown or unspecified column. |
|---|
| mtryhm | int | Unknown or unspecified column. |
|---|
| geom_geojson | string | Unknown or unspecified column containing geometry data in GeoJSON format. |
|---|
| geom_geotext | string | Unknown or unspecified column containing geometry data in geotext (text-based) format. |
|---|
| geom_type | string | The type of geometry represented by the row version. |
|---|
| geom_centroid | string | The centroid of the geometry represented by the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry represented by the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry represented by the row version. |
|---|
| geom | binary | Unknown or unspecified column containing geometry data. |
|---|
