Regions 2024 Geographic Dataset Table (Scale 1:4,500,000)
The table in question is a structured collection of data belonging to a larger dataset, specifically related to the regions of Finland as projected for the year 2024. It is sourced from the 'Tilastokeskus' website, which can be translated to 'Statistics Finland'. The table provides a wealth of information, including geographical and regional data, and has a number of potential applications in the field of data analytics.
The table includes a range of columns. Of particular note are two special columns: '_extract_date' and '_row_number'. The former indicates the date when data was extracted, while the latter provides a unique identifier for each row based on the extraction date. This unique combination allows for precise tracking and referencing of each individual data entry.
Geographical information is provided in columns starting with 'geom_', which can be utilized for geospatial data analytics. This data uses the WGS 84 coordinate reference system, with longitude followed by latitude.
The contents of the table specifically pertain to the regional divisions of Finland, projected for the year 2024. Each row denotes a specific region, with its name provided in multiple languages. Additionally, each region is assigned a unique identifier.
In terms of data analytics, this table could be used in a variety of ways. For instance, the geographical data could be used to create detailed and interactive maps of Finland's projected regional divisions for 2024. Furthermore, the extraction dates could be used to track changes over time, providing valuable insights into regional trends and shifts. Additionally, the regional identifiers and names could be used to cross-reference with other datasets, thereby creating a comprehensive picture of each region's demographics, economy, and more.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the row data was extracted from the data source. It uniquely identifies the extraction date of each data row. |
| _row_number | long | This column contains the row number from the data source on the date of extraction. In combination with '_extract_date', it uniquely identifies each row. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which describes the shapes and structures of the geographical features. |
| geom_geotext | string | This column contains geometric data as textual representation. It provides similar information as 'geom_geojson' but in a different format. |
| geom_type | string | This column specifies the type of geometric data. It classifies the geometric data into categories like 'ST_POLYGON', 'ST_MULTIPOLYGON', etc. |
| geom_centroid | string | This column contains the geometric center or centroid of the geographical feature represented by the data row. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the geographical feature. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the geographical feature. |
| gml_id | string | This column contains a unique identifier for each data row. It is usually a combination of the table name and the row number. |
| name | string | This column contains the name of the geographical feature represented by the data row. The names are in multiple languages. |
| namn | string | This column contains the name of the geographical feature in another language. |
| nimi | string | This column contains the name of the geographical feature in yet another language. |
| seutukunta | string | This column contains a unique code representing the region of the geographical feature. |
| vuosi | long | This column contains the year related to the data row. It provides a temporal context to 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 | 82c5f180-8c3d-4976-8053-82b1278a47d7 |
| Package id | 92428bd4-2c64-44bd-b7bd-48f905840e9b |
| Revision id | 63ead55b-613c-424b-906c-defe9eee6bf4 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2024__table |