Provinces 2020 - Geographical Data and Attributes (Scale 1:4,500,000)
The table under consideration houses data that pertains to the 'Regions 2020 (1:4 500 000)' dataset, which is part of a larger dataset collection sourced from the 'Tilastokeskus' (Statistics Finland) website. This table is a structured arrangement of related data with several columns, each containing unique information.
The table's content includes geographic and demographic data about various regions in Finland for the year 2020. One of the notable features of this table is its geospatial data columns, which contain geographic information useful for geospatial data analytics. These 'geom_' columns include details about geographic shapes (polygons and multipolygons), geographic center points, and the X and Y coordinates of these center points. All geographic coordinates are presented using the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude.
The table also contains demographic data, such as the region's name in English and other languages, and a unique identifier for each region. This combination of geospatial and demographic data provides a comprehensive view of each region, opening up numerous possibilities for analysis and exploration.
Two special columns, '_extract_date' and '_row_number', provide information about the data extraction process. The '_extract_date' column specifies the date when the data was extracted, while the '_row_number' indicates the row number in the data extracted from the source on the specified extract date. This combination uniquely identifies each row.
The richness of this table's data content opens up numerous possibilities for analytics. For instance, the geospatial data could be used to visualize the geographical distribution of regions, while the demographic data could be used for comparative regional analysis. Similarly, historical trends could be analyzed by comparing data from different '_extract_date' entries.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This is a special column that holds the date when the data row was extracted from the data source. |
| _row_number | long | This special column contains the row number in the data extracted from the source on the extraction date specified by the column '_extract_date'. Together with '_extract_date', it uniquely identifies each row. |
| geom_geojson | string | This column stores the geographical data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column represents the geographical data in a textual format. |
| geom_type | string | This column indicates the type of the geographical data stored in the 'geom_geojson' and 'geom_geotext' columns, for example, whether it's a polygon or a multipolygon. |
| geom_centroid | string | This column holds the geographical center point of the geographical shape represented in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | This column contains the x-coordinate of the center point of the geographical shape. |
| geom_center_y | double | This column contains the y-coordinate of the center point of the geographical shape. |
| gml_id | string | This string column holds a unique identifier for the geographical data. |
| maakunta | string | This string column represents the province code based on the Finnish province division. |
| name | string | This string column contains the English name of the province. |
| namn | string | This string column holds the Swedish name of the province. |
| nimi | string | This string column represents the Finnish name of the province. |
| vuosi | long | This integer column holds the year related to the data row. |
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 | a8c3a6b8-58db-40c0-b504-1eefb1afb3d8 |
| Package id | a8069dd1-6570-4f1a-835e-b9fae76de0ea |
| Revision id | db32e896-49fe-4c97-bf11-accdfa9620c2 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2020__table |