Regions 2022 (Scale 1:1 000 000) - Data Table from Finnish Statistical Collection
The table at hand is an integral part of a larger dataset collection and houses essential data related to 'Seutukunnat 2022' which translates to 'Regional Units 2022'. This information has been sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The table's contents are primarily organized in rows and columns, each offering unique insights.
The table contains several columns which present a plethora of information. For instance, some columns provide geographic information that can be utilized for geospatial data analytics. These columns store data in the form of polygons and multipolygons, representing different shapes and areas on a map. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the longitude mentioned first, followed by latitude.
The table also stores the name of the regional units in multiple languages. This can be useful for multi-lingual data analysis and localization. Additionally, a unique identification number for each regional unit is also stored in the table. This can be helpful in distinguishing between different areas, even if they have similar names.
The table also features two special columns: '_extract_date' and '_row_number'. The former provides the date that the data was retrieved from the source, while the latter indicates the row number in the data extracted from the source on the specific extract date. These two columns together uniquely identify each row, ensuring data traceability and integrity.
The data stored in this table can be utilized in numerous ways in data analytics. For example, the geographic information can be used to create detailed and interactive maps for spatial analysis. Furthermore, the multi-lingual names of regional units can be used for localization in developing international applications. The unique identifiers for each region can also be used for tracking changes in regional data over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted from the original data source. The format of the date is YYYY-MM-DD. |
_row_number | long | This column stores the row number of the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in combination with '_extract_date', uniquely identifies each row in the table. |
geom_geojson | string | This column contains geographic data in the GeoJSON format. The data can represent different types of geographical shapes such as polygons or multi-polygons. |
geom_geotext | string | This column holds the textual representation of the geographic data. The data is represented as polygons or multi-polygons. |
geom_type | string | This column specifies the type of the geographic shape that is represented in the 'geom_geojson' and 'geom_geotext' columns. The possible values are 'ST_POLYGON' and 'ST_MULTIPOLYGON'. |
geom_centroid | string | This column contains the geographic coordinate of the centroid of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_x | double | This column holds the x-coordinate of the center of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
geom_center_y | double | This column stores the y-coordinate of the center of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
gml_id | string | This column contains a unique identifier for each row, which follows a specific naming pattern. |
name | string | This column stores the name of the region. |
namn | string | This column contains the name of the region in a different language. |
nimi | string | This column holds another variant of the region's name in a different language. |
seutukunta | string | This column contains a code that represents the region. |
vuosi | long | This column holds the year that the data refers to. |
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 | 2bbb6ec3-ba86-4eae-922c-bfa81199c749 |
Package id | 5df7a1a6-bedf-4438-9251-b370173d9513 |
Revision id | 9d18dd52-5247-4231-baa7-0916c872a24b |
State | active |
Table | tilastointialueet_seutukunta1000k_2022__table |