Historical Large Areas 2021 (1:1 000 000) Version Tracking
Click here for a data sample
The 'table__history' is a historical data repository that forms part of the dataset collection titled 'tilastointialueet_suuralue1000k_2021'. The table provides a valuable insight into the major areas of Finland, as sourced from the Finnish statistical agency 'Tilastokeskus' (Statistics Finland). The core of the table's contents highlights the names of these areas in different languages such as English, Finnish and Swedish. Each of these areas is assigned a unique identifier and a corresponding geographical attribute, presented using WGS 84 coordinate reference system, with longitude preceding latitude. The geographical attributes are stored as various 'geom_' prefixed columns, which can be instrumental for geospatial data analytics, such as mapping or studying spatial patterns and relationships. The 'vuosi' column indicates the year corresponding to the data entry. A unique aspect of this table is its ability to track version history. Each row in the table is distinguishable by a combination of the '_start_date' and '_row_number' columns. The '_start_date' shows when the data was pulled from the source, whereas the '_end_date' indicates when a new version was extracted. If the '_end_date' is null, it implies that the version is the most recent. For example, this historical data could facilitate temporal analysis to understand how these areas have evolved over time, or it could be used in combination with other socio-economic data to study regional disparities in Finland.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when each row was extracted from the data source, serving as the initial date for the version history of a row. |
|---|
| _end_date | date | This column holds the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | This column represents the number of the row in the raw data extracted from the data source. It, together with _start_date, uniquely identifies each row in this version history table. |
|---|
| geom_geojson | string | This column contains the geographical representation of each area in GeoJSON format, which is a popular format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column holds the geographical representation of each area in geotext format. |
|---|
| geom_type | string | This column specifies the type of the geographic data stored in the table, which in this case is ST_MULTIPOLYGON indicating a collection of polygons. |
|---|
| geom_centroid | string | This column contains the coordinates of the geographical center or centroid of each area. |
|---|
| geom_center_x | double | This column holds the x-coordinate (longitude) of the geographical center of each area. |
|---|
| geom_center_y | double | This column has the y-coordinate (latitude) of the geographical center of each area. |
|---|
| gml_id | string | This column, of type String, is an identifier for each area. |
|---|
| name | string | This column, of type String, contains the English name for each area. |
|---|
| namn | string | This column, of type String, holds the Swedish name for each area. |
|---|
| nimi | string | This column, of type String, carries the Finnish name for each area. |
|---|
| suuralue | string | This column, of type String, is an identifier for each large area, with areas represented by numbers. |
|---|
| vuosi | long | This column, of type Integer, represents the year associated with the data. |
|---|
