Statistics Bureau Regional Statistical Area Collection 2021
Tables
-
Regional Units 2021 (Scale 1:4 500 000) Dataset TableTSV
The table under consideration is a structured collection of related data, which is a part of a larger dataset collection. This table is specifically designed to hold information regarding 'Seutukunnat 2021' or 'Regions 2021', a geographic dataset sourced from the 'Tilastokeskus' website in Finland. The table comprises of various columns, each holding specific information related to the regions. Two exclusive columns, namely the extraction date and row number, are integrated into the table to ensure each row is uniquely identified based on the date the data was extracted and the corresponding row number. Geographical data is a significant part of this table, with multiple columns starting with 'geom_' that hold various forms of geographic information. These columns are designed to hold...
-
Version History of Regional Units 2021 (1:4 500 000) - History TableTSV
The 'table__history' is a part of the dataset collection 'tilastointialueet_seutukunta4500k_2021'. This history table maintains the version history of its base table rows, providing a chronological record of updates. The base table contains data regarding 'Seutukunnat 2021 (1:4 500 000)', which translates to Regions 2021 (1:4 500 000) in English. This data, sourced from the 'Tilastokeskus' website, based in Finland, offers rich insights into various regional aspects. The table includes several columns that hold a variety of information. For instance, there are columns for dates indicating when the row was added to the table ('_start_date') and when the row was updated ('_end_date'). The unique combination of '_start_date' and '_row_number' distinguishes each row in this version history...
Column Descriptions
Regional Units 2021 (Scale 1:4 500 000) Dataset Table
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column records the exact date when the data was extracted from the source. It helps in keeping track of the data extraction process over time. |
| _row_number | long | This column holds the unique row number for each piece of data extracted from the source. It is used in conjunction with '_extract_date' to uniquely identify each row. |
| geom_geojson | string | This column contains geometric data in the GeoJSON format, which describes the shapes and locations of geographical features. |
| geom_geotext | string | This column stores the geometric data in text format. It is used to describe the shape and location of geographical features. |
| geom_type | string | This column specifies the type of the geographical feature represented, such as polygon or multipolygon. |
| geom_centroid | string | This column contains the coordinates of the centroid (geometric center) of the geographical feature, represented as a point. |
| geom_center_x | double | This column represents the X-coordinate (longitude) of the geometric center of the geographical feature. |
| geom_center_y | double | This column represents the Y-coordinate (latitude) of the geometric center of the geographical feature. |
| gml_id | string | This column contains a unique identifier for each row, which is derived from the name of the dataset collection and the row number. |
| name | string | This column provides the name of the geographical area, which corresponds to the geometric data. |
| namn | string | This column contains the local name for the geographical area, allowing for regional variations in naming. |
| nimi | string | This column also provides the local name of the geographical area, which may vary slightly from the 'name' column. |
| seutukunta | string | This column stores a numerical code that represents the geographical area, adding another method to categorize the data. |
| vuosi | long | This column indicates the year that the data corresponds to, helping to understand the temporal context of the data. |
Version History of Regional Units 2021 (1:4 500 000) - History Table
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source, marking the beginning of the validity period for the specific version of the row. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source, marking the end of the validity period for the specific version of the row. If the value is null, it means that the row is the most recent version. |
| _row_number | long | This column contains the number of the row in the raw data extracted from the data source. It, in combination with '_start_date', uniquely identifies each row in this version history table. |
| geom_geojson | string | This column contains the geometric data of the region in GeoJSON format, a popular format for encoding geographic data structures. |
| geom_geotext | string | This column contains the geometric data of the region in text format. |
| geom_type | string | This column specifies the type of the geometric data, in this case, a polygon. |
| geom_centroid | string | This column contains the centroid of the geometric data, which is the center point of the region. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the region. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the region. |
| gml_id | string | This column contains the unique identifier of the region. |
| name | string | This column contains the English name of the region. |
| namn | string | This column contains the name of the region in another language. |
| nimi | string | This column contains the name of the region in another language. |
| seutukunta | string | This column contains a code representing the region. |
| vuosi | long | This column contains the year of the data entry. |
Additional Info
| Last Updated | November 12, 2024 |
|---|---|
| Created | November 11, 2024 |