Provinces 2020 - Detailed Geographical Dataset (1:1 000 000 Scale)
The 'table' is part of the larger dataset collection 'tilastointialueet_maakunta1000k_2020'. It is a structured collection of data that provides a snapshot of regions in Finland for the year 2020, sourced from the Finnish statistical agency, 'Tilastokeskus'. The table contains a variety of information, including geographic data and unique identifiers for each region.
Each row in the table represents a specific region, with unique attributes recorded in various columns. The geographic information is captured using the WGS 84 coordinate reference system, where longitude comes first, followed by latitude. This allows for detailed geospatial data analysis, such as understanding regional boundaries and calculating centroid points.
In addition to the geographic information, the table also includes unique identifiers for each region in different languages, making it a versatile tool for analysis in multilingual contexts.
The table carries a special timestamp feature, where the columns '_extract_date' and '_row_number' together form a unique identifier for each data row, indicating when the data was extracted and the order of extraction. This uniqueness of each row aids in tracking changes over time and ensuring data integrity.
The data in this table could be used in various ways. For example, it could be used to study regional differences in Finland, conduct spatial analysis, or support multilingual applications. It could also be useful for tracking how regional data changes over time, considering the unique timestamp feature of each row.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column represents the date when the data on the respective row was extracted from the source. It is a special column that, in combination with '_row_number', uniquely identifies each row in the table. |
| _row_number | long | This column provides the row number in the data as it was extracted from the source. This is a special column that, along with '_extract_date', uniquely identifies each row. |
| geom_geojson | string | This column represents the geographical shape of the Finnish region in geojson format. Geojson is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column provides the geographical shape of the respective Finnish region in geotext format, which is a textual representation of the geographical data. |
| geom_type | string | This column indicates the geometric data type of the region's geographic shape, which could be either 'ST_MULTIPOLYGON' for multiple polygons or 'ST_POLYGON' for a single polygon. |
| geom_centroid | string | This column represents the geographical center point of the region in the form of a 'POINT' with coordinates. |
| geom_center_x | double | This column contains the x-coordinate of the geographical center point of the region. |
| geom_center_y | double | This column contains the y-coordinate of the geographical center point of the region. |
| gml_id | string | This column contains a unique identifier for each row, following the format 'maakunta1000k_2020.[row_number]'. |
| maakunta | string | This column contains a code representing the Finnish region. |
| name | string | This column contains the English name of the Finnish region. |
| namn | string | This column contains the Swedish name of the Finnish region. |
| nimi | string | This column contains the Finnish name of the region. |
| vuosi | long | This column represents the year for which the data is relevant. In the provided dataset, all the data is for the year 2020. |
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 | 1527e1ac-c02d-49b7-8099-b90f1c0cc55d |
| Package id | 27a4c737-7c35-437e-8810-bf20d493d58d |
| Revision id | b3aa5810-3acd-4a54-834d-6651805f134d |
| State | active |
| Table | tilastointialueet_maakunta1000k_2020__table |