Version History of AvoinData Karttalehtijako 5x5 km - Karttalehtijako 5x5 km Polygon
Click here for a data sample
This table contains the version history of the 'avoindatakarttalehtijako_5x5_km__karttalehtijako_5x5_kmpolygon' table. It has two additional columns compared to its base table: '_start_date' and '_end_date'. The '_start_date' column contains the date when the row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row is the most recent version of the row. The data in this table has been sourced from the website of 'Helsinki City Environment Sector' in the country Finland (ISO country code: FI). The table includes various columns like 'id', 'tunnus', 'lehtikoko', 'lehtikoko0', 'koordinaat', 'koordinaa0', 'km_indeksi', 'km_indeks0', 'km_alainde', 'kunnan_alu', 'pintaala', 'luonti_pvm', 'data_muokk', 'muokkaus_p', 'omistaja', 'historia_p', 'data_luoja', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. This table provides significant data analytics potential, such as analyzing the changes in geographical features over time, calculating the area of specific regions, identifying ownership trends, and exploring the historical background of different geographic locations.
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 in the version history. |
|---|
| id | int | The unique identifier of the row. |
|---|
| tunnus | string | The identifier of the row for reference purposes. |
|---|
| lehtikoko | int | The size of the leaf. |
|---|
| lehtikoko0 | int | An additional size identifier of the leaf. |
|---|
| koordinaat | int | The coordinates of the location. |
|---|
| koordinaa0 | int | An additional set of coordinates for the location. |
|---|
| km_indeksi | int | The kilometer index. |
|---|
| km_indeks0 | int | An additional kilometer index. |
|---|
| km_alainde | string | The sub kilometer index. |
|---|
| kunnan_alu | string | The municipality area. |
|---|
| pintaala | string | The surface area of the row. |
|---|
| luonti_pvm | string | The date of creation. |
|---|
| data_muokk | string | The date of data modification. |
|---|
| muokkaus_p | string | The type of modification. |
|---|
| omistaja | string | The owner of the row. |
|---|
| historia_p | string | The historical preservation status of the row. |
|---|
| data_luoja | string | The creator of the data. |
|---|
| geom_geojson | string | The geographic JSON representation of the geometry. |
|---|
| geom_geotext | string | The text representation of the geometry. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometric representation of the row. |
|---|
