History of Map Sheets Division (0.5x0.5km) - Helsingin kaupunkiympäristön toimiala - Finland
Click here for a data sample
This table contains the version history of the rows in the 'avoindatakarttalehtijako_05x05_km__karttalehtijako_05x05_kmpolygon' table sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The rows in this table represent different versions of the base table rows, with each row having '_start_date' and '_end_date' columns indicating the extraction dates. The table includes various columns such as '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', and 'geom_center_y'. This historical version data can be utilized in various data analytics tasks such as tracking changes in geographical features over time or analyzing historical trends in area sizes for specific features.
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 row number indicating the version history of the base table rows. |
|---|
| id | int | The unique identifier of the row. |
|---|
| tunnus | string | The tunnus of the row. |
|---|
| lehtikoko | int | The lehtikoko of the row. |
|---|
| lehtikoko0 | int | The lehtikoko0 of the row. |
|---|
| koordinaat | int | The koordinaat of the row. |
|---|
| koordinaa0 | int | The koordinaa0 of the row. |
|---|
| km_indeksi | int | The km_indeksi of the row. |
|---|
| km_indeks0 | int | The km_indeks0 of the row. |
|---|
| km_alainde | string | The km_alainde of the row. |
|---|
| kunnan_alu | string | The kunnan_alu of the row. |
|---|
| pintaala | string | The pintaala of the row. |
|---|
| luonti_pvm | string | The creation date of the row. |
|---|
| data_muokk | string | The data_muokk of the row. |
|---|
| muokkaus_p | string | The muokkaus_p of the row. |
|---|
| omistaja | string | The omistaja of the row. |
|---|
| historia_p | string | The historia_p of the row. |
|---|
| data_luoja | string | The data_luoja of the row. |
|---|
| geom_geojson | string | The geom_geojson of the row. |
|---|
| geom_geotext | string | The geom_geotext of the row. |
|---|
| geom_type | string | The geom_type of the row. |
|---|
| geom_centroid | string | The centroid of the geom field of the row. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geom field of the row. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geom field of the row. |
|---|
| geom | binary | The geom field of the row. |
|---|
