Version History of Area Subdivision - Subarea Polygons
Click here for a data sample
This table contains the version history of the rows extracted from the 'Helsingin kaupunkiympariston toimiala' data source. It is sourced from the country 'Finland' with the ISO country code 'fi'. The table, named avoindatapiirijako_osaaluepiirijako_osaaluepolygonhistory, is a historical record of the base table avoindatapiirijako_osaalue__piirijako_osaaluepolygon. The rows in this table include information about the start and end dates when each row was extracted. The table includes various columns like '_row_number', 'id', 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'kokotunnus', 'paivitetty', 'datanomist', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. The data in this table can be utilized for data analytics purposes such as trend analysis and pattern recognition in the geographical context. By examining the changes in the rows over time, analysts can gain insights into the historical development and updates of the geographical areas and divisions represented in the data.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the beginning of the validity period for the row version. |
|---|
| _end_date | date | The end date indicating the end of the validity period for the row version. |
|---|
| _row_number | long | The row number indicating the position of the row version within the table. |
|---|
| id | int | The unique identifier for each row version. |
|---|
| aluejako | string | The area division. |
|---|
| kunta | int | The municipality. |
|---|
| tunnus | int | The identifier. |
|---|
| nimi_fi | string | The name in Finnish. |
|---|
| nimi_se | string | The name in Swedish. |
|---|
| yhtluontip | string | The creation date and time for the row version. |
|---|
| yhtmuokkau | string | The last modification date and time for the row version. |
|---|
| yhtdatanom | string | The date and time when the row version became invalid. |
|---|
| kokotunnus | int | The full identifier. |
|---|
| paivitetty | string | The last updated date and time for the row version. |
|---|
| datanomist | string | The data custodian. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Geotext format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid position for the geometry. |
|---|
| geom_center_x | double | The X-coordinate of the center point of the geometry. |
|---|
| geom_center_y | double | The Y-coordinate of the center point of the geometry. |
|---|
| geom | binary | The geometric data. |
|---|
