Provinces 2021 - Detailed Geographical Information
The table under discussion is part of a dataset collection focusing on regional statistical areas in Finland. The table itself is named 'Regions 2021 (1:4 500 000)', providing a comprehensive view of Finland's regions for the year 2021. This table is sourced from the Finnish Statistics Bureau website ('Tilastokeskus') and offers a rich collection of information for each region, including geographic and demographic data.
The table contains columns that cater to a variety of data points. Key among these are '_extract_date' and '_row_number'. The former provides the date when the data row was extracted, and the latter offers a unique identifier for each data row based on the extraction date. This combination ensures each row in the table is distinct and easily identifiable.
Moving on to the geography-related columns, the table employs the WGS 84 coordinate reference system with longitude coming before latitude. The geographic data is contained in several columns all starting with 'geom_', for instance, 'geom_geojson' and 'geom_center_x'. These columns serve up a wealth of geospatial data that can be applied in numerous ways, from mapping region boundaries to pinpointing the geographic center of each region.
The table also includes columns related to the region's name in various languages, such as English, Swedish, and Finnish. This allows for easy cross-referencing and comparison of regions across different linguistic contexts.
This wealth of information can be utilized in a variety of ways. For instance, the geographic data can be used to create detailed maps of the regions, while the demographic data can be applied in socio-economic research to track regional development over time. Moreover, the data could be used in predictive modeling to forecast population shifts or other regional changes based on historical trends.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It helps in tracking when the specific data was fetched for reference or analysis. |
| _row_number | long | This column contains the row number in the data extracted from the source on the specified extract date. It is part of a unique identifier for each row when coupled with the '_extract_date'. |
| geom_geojson | string | This column stores the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geographic data in text format. It represents the shape of a geographic feature. |
| geom_type | string | This column indicates the type of the geographic data. For example, it can be a point, line, or polygon. |
| geom_centroid | string | This column contains the geographic coordinate of the centroid of the geometric shape. It represents the center point of the geographic feature. |
| geom_center_x | double | This column represents the X-coordinate of the geographic center of the feature. It's part of the geographic coordinate system. |
| geom_center_y | double | This column represents the Y-coordinate of the geographic center of the feature. It's also part of the geographic coordinate system. |
| gml_id | string | This column contains identifiers that are used to link geographic features to their descriptions. |
| maakunta | string | This column contains unique identifiers for regions in Finland. |
| name | string | This column contains the English names of the regions in Finland. |
| namn | string | This column contains the Swedish names of the regions in Finland. |
| nimi | string | This column contains the Finnish names of the regions in Finland. |
| vuosi | long | This column indicates the year the data row was collected or relevant for. |
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 | c0bc0fc1-6470-4bb0-8a99-ee850248b551 |
| Package id | a3009d2e-0bd6-4e46-b3e2-1c87085fb48a |
| Revision id | 4e667e87-5d4b-4754-85ce-ffdaf3a3a223 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2021__table |