Version History of Map Sheet Division in 2x2 KM Grid - Polygon
Click here for a data sample
This table contains the version history of the rows extracted from the dataset 'Helsingin kaupunkiympariston toimiala' from the country Finland (ISO country code 'fi'). The table '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If '_end_date' is null, it indicates that the row is the most recent version. The table 'avoindatakarttalehtijako_2x2_kmkarttalehtijako_2x2_kmpolygonhistory' is derived from the base table 'avoindatakarttalehtijako_2x2_km__karttalehtijako_2x2_kmpolygon'. 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', which provide valuable data for data analytics purposes. For instance, one can analyze the change in 'pintaala' (surface area) over time to understand the trends and patterns in the dataset. Similarly, the 'kunnan_alu' (municipal area) column can be used to examine the distribution of data across different municipalities. Additionally, the geographic information stored in columns like 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' allows for spatial analysis and visualizations.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for this version of the row. |
|---|
| _end_date | date | The end date of the validity period for this version of the row. |
|---|
| _row_number | long | The row number of the version in the table. |
|---|
| id | int | The unique identifier for the row. |
|---|
| tunnus | string | A value representing the tunnus of the row. |
|---|
| lehtikoko | int | The lehtikoko value for the row. |
|---|
| lehtikoko0 | int | An additional lehtikoko value for the row. |
|---|
| koordinaat | int | The koordinaat value for the row. |
|---|
| koordinaa0 | int | An additional koordinaat value for the row. |
|---|
| km_indeksi | int | The km_indeksi value for the row. |
|---|
| km_indeks0 | int | An additional km_indeksi value for the row. |
|---|
| km_alainde | string | The km_alainde value for the row. |
|---|
| kunnan_alu | string | The kunnan_alu value for the row. |
|---|
| pintaala | string | The pintaala value for the row. |
|---|
| luonti_pvm | string | The creation date of the row. |
|---|
| data_muokk | string | The date of the last data modification for the row. |
|---|
| muokkaus_p | string | The muokkaus_p value for the row. |
|---|
| omistaja | string | The owner of the row. |
|---|
| historia_p | string | The historia_p value for the row. |
|---|
| data_luoja | string | The creator of the row data. |
|---|
| geom_geojson | string | The geojson representation of the geometry of the row. |
|---|
| geom_geotext | string | The geotext representation of the geometry of the row. |
|---|
| geom_type | string | The type of geometry for the row. |
|---|
| geom_centroid | string | The centroid of the geometry for the row. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry for the row. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry for the row. |
|---|
| geom | binary | The geometry of the row. |
|---|
