Municipalities 2019 (1:1 000 000) - Version History
Click here for a data sample
The 'table__history' is part of the 'tilastointialueet_kunta1000k_2019' dataset collection, which is sourced from the 'Tilastokeskus' website based in Finland. This table serves as a history table, encapsulating the version history of its base table rows. It comprises of several columns that contain a variety of data, including geographic and temporal information. For instance, the 'start_date' column marks the date when a row was extracted from the data source, while the '_end_date' column indicates when a new version of the row was extracted. A combination of '_start_date' and '_row_number' uniquely identifies each row, with '_row_number' pointing to the number of the row in the raw data extracted from the data source. If the '_end_date' for a row is null, it means that the row is the most recent version. Geographical data is stored in the columns beginning with 'geom', which can be utilized for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Other columns indicate features like the name of the location in different languages, and the year of the data. Using this data, one could perform time-series analysis to track changes over time, or geospatial analysis to identify patterns or anomalies in specific geographic areas.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source, marking the start of the row's version in the history table. For example, a date could be '2024-11-11'. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source, marking the end of the row's version in the history table. If the value is null, it indicates that the row is the most recent version. For example, a value could be 'None'. |
|---|
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. In combination with '_start_date', it uniquely identifies each row in this version history table. |
|---|
| geom_geojson | string | This column contains the geographical information of the area in GeoJSON format (a format for encoding geographic data structures). |
|---|
| geom_geotext | string | This column contains the textual representation of the geographical information in multipolygon format. |
|---|
| geom_type | string | This column specifies the type of the geometrical object represented in the 'geom_geojson' and 'geom_geotext' columns. For example, it could be 'ST_MULTIPOLYGON'. |
|---|
| geom_centroid | string | This column contains the centroid (geographical center) of the area represented by the geographical information. |
|---|
| geom_center_x | double | This column contains the x-coordinate (longitude) of the center of the area represented by the geographical information. |
|---|
| geom_center_y | double | This column contains the y-coordinate (latitude) of the center of the area represented by the geographical information. |
|---|
| gml_id | string | This column contains the ID of the area in GML (Geography Markup Language) format. |
|---|
| kunta | string | This column contains a unique identifier for the area. |
|---|
| name | string | This column contains the name of the area in English. |
|---|
| namn | string | This column contains the name of the area in Swedish. |
|---|
| nimi | string | This column contains the name of the area in Finnish. |
|---|
| vuosi | long | This column contains the year associated with the data row. For example, it could be '2019'. |
|---|
