Sub-regions 2023 Projections (Scale 1:4,500,000) - Data Table
The table, a part of the dataset collection named 'tilastointialueet_seutukunta4500k_2023', is a rich source of geospatial data. It contains crucial information about the regional districts of Finland, as projected for the year 2023. The data is sourced from the Statistics Finland ('Tilastokeskus') website.
The table integrates a variety of data types, including dates, numbers, and geospatial data. The geospatial data is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This makes the data particularly useful for geospatial analytics, including mapping and spatial pattern recognition.
One of the unique features of the table is the inclusion of two special columns, '_extract_date' and '_row_number'. The '_extract_date' indicates the date the particular row was extracted from the source. The '_row_number', on the other hand, provides a unique identifier for each row, based on the data extracted on the specific '_extract_date'. This combination allows each entry to be uniquely identified and tracked over time.
The table includes geographic information such as the type of geographical shape (polygon or multipolygon), centroid point, and the central X and Y coordinates. This data could be used to visualize the geographic distribution of the districts.
Another interesting aspect of the table is the inclusion of multiple language versions for each district's name. This multicultural perspective enriches the data and provides more comprehensive insights.
The table also includes a unique identifier for each district and the year of projection. This data can be used for time series analysis, trend forecasting, or to compare changes over time in different regions.
In terms of data analytics, this table offers numerous possibilities. For instance, the geographic data could be used to create interactive maps, allowing users to explore the districts and their attributes. Moreover, the time-stamped data can provide insights into the evolution of Finland's administrative divisions over time. The multilingual district names also open avenues for linguistic analysis and cross-cultural studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column indicates the date when the data row was extracted from the data source. It helps to understand when the data was pulled for analysis. |
| _row_number | long | This column contains the row number in the data extracted from the source. It, in combination with the '_extract_date', uniquely identifies each row. |
| geom_geojson | string | This column contains geometric data in GeoJSON format. It represents the geographical features of the regions. |
| geom_geotext | string | This column contains geometric data in geotext format. It is another way to represent the geographical layout of the regions. |
| geom_type | string | This column describes the type of geometric data, which could be either Polygon or MultiPolygon. |
| geom_centroid | string | This column contains the centroid coordinates of the geometric shape representing the region. It provides the geographical center point of the regions. |
| geom_center_x | double | This column represents the X-coordinate of the center point of the geographic shape of the region. |
| geom_center_y | double | This column represents the Y-coordinate of the center point of the geographic shape of the region. |
| gml_id | string | This column contains a unique identifier for each region as provided by the data source. |
| name | string | This column contains the name of the region in English. |
| namn | string | This column includes the name of the region in a local language. |
| nimi | string | This column includes the name of the region in another local language. |
| seutukunta | string | This column contains a specific code assigned to each region. This serves as another way to identify the regions. |
| vuosi | long | This column indicates the year for which the data is relevant. It helps to understand the timeframe of the dataset. |
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 | e0a90f92-80cb-4498-8b24-266f9bb9c0ce |
| Package id | 88c8489a-62bf-4d37-a3e4-f3fef2b7f598 |
| Revision id | ca372de9-1088-4f2f-8ce9-bec87c2eeef8 |
| State | active |
| Table | tilastointialueet_seutukunta4500k_2023__table |