Regional Units 2021 (Scale 1:4 500 000) Dataset Table
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 geographic data in formats such as GeoJSON and Geotext. There are also columns holding the type of geometry, centroid of the geometry, and the x and y coordinates of the geometry's center. The geographic coordinates are presented using the WGS 84 coordinate reference system, where longitude is provided first, followed by latitude.
Apart from the geographic information, other columns in the table hold the names of the regions in various languages, the unique identifier of the region, and the year to which the data pertains.
This table can serve as an essential resource for data analytics, especially in the domain of geospatial analytics. For instance, it can be used to study the geographic distribution of regions and their characteristics over time. It can also be used to perform comparative analyses of different regions based on the data available. Additionally, the geographic information can be utilized to overlay the regions on a map for better visualization and understanding.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _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. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | f979bc18-8bd3-4c0c-b624-61d657d7b3b4 |
| Package id | 98a77627-d640-4781-83f4-479559485b1d |
| Revision id | 1c93fafd-0fe9-4360-86f9-c4e73854c3db |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2021__table |