Version History of Helsinki Sub-AreasPolygon Data
Click here for a data sample
This table contains the version history of rows extracted from the dataset 'Helsingin kaupunkiympäristön toimiala' from Finland (ISO country code: 'fi'). The base table, 'seutukarttahelsinki_osa_alueet__helsinki_osaalueetpolygon', serves as the source for this table. The additional columns in this table compared to the base table are '_start_date' and '_end_date'. The '_start_date' column indicates the date when a row was initially extracted, 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 represents the most recent version of the data. Although the specific columns of this table are not listed or described, its data can be utilized in various ways for data analytics. For example, it can be used to track changes over time, analyze historical patterns, or identify updates made to the original dataset. The data in this table is structured for analysis and understanding of the different aspects of the given dataset.
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 sequential number of the row version. |
|---|
| kokotun | int | Description for column 'kokotun' is unavailable. |
|---|
| kunta | int | Description for column 'kunta' is unavailable. |
|---|
| suur | int | Description for column 'suur' is unavailable. |
|---|
| perus | int | Description for column 'perus' is unavailable. |
|---|
| osa | int | Description for column 'osa' is unavailable. |
|---|
| nimi | string | Description for column 'nimi' is unavailable. |
|---|
| nimi_iso | string | Description for column 'nimi_iso' is unavailable. |
|---|
| mtryhm | int | Description for column 'mtryhm' is unavailable. |
|---|
| geom_geojson | string | Description for column 'geom_geojson' is unavailable. |
|---|
| geom_geotext | string | Description for column 'geom_geotext' is unavailable. |
|---|
| geom_type | string | Description for column 'geom_type' is unavailable. |
|---|
| geom_centroid | string | Description for column 'geom_centroid' is unavailable. |
|---|
| geom_center_x | double | Description for column 'geom_center_x' is unavailable. |
|---|
| geom_center_y | double | Description for column 'geom_center_y' is unavailable. |
|---|
| geom | binary | Description for column 'geom' is unavailable. |
|---|
