Provinces 2024 - Geospatial Data (1:1 000 000 Scale)
The table under consideration belongs to a dataset collection that focuses on regional statistics projected for the year 2024 in Finland. The data in the table comes from 'Tilastokeskus' (Statistics Finland), a reliable source of statistical information in the country.
The table contains a rich set of information, with columns providing various types of data. Two special columns, '_extract_date' and '_row_number', play a crucial role in identifying each row uniquely. The '_extract_date' column indicates the date when the specific row of data was extracted, while '_row_number' marks the order of the row in the data extracted on that specific date.
The table is particularly useful for geospatial data analytics, with several columns beginning with 'geom_' containing geographical information. These columns present geographic coordinates using the WGS 84 coordinate reference system, where the axis order is longitude first, followed by latitude.
The table provides a wealth of information about different regions, including their names in various languages and their unique identifiers ('gml_id'). It also includes regional codes ('maakunta') and projected data for the year 2024.
Potential applications of this table in data analytics could be abundant. For instance, one could use the geographic information to create detailed maps of the regions and their projected changes. The data could also be used to analyze regional differences or predict future trends based on the 2024 projections. Additionally, the unique identifiers could aid in cross-referencing and combining this data with other relevant datasets for more comprehensive and multifaceted analyses.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column indicates the date when the data row was extracted from the data source. |
| _row_number | long | This column provides the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| geom_geojson | string | This column contains geospatial data in GeoJSON format, a popular format for encoding geographic data structures. |
| geom_geotext | string | This column contains geospatial data in text format. |
| geom_type | string | This column defines the type of geometric data contained in the 'geom' columns. For instance, it could be a Point, LineString, Polygon, etc. |
| geom_centroid | string | This column contains the centroid (geometric center) of the shape defined in the 'geom' columns. |
| geom_center_x | double | This column represents the X coordinate for the geometric center point of the shape defined in the 'geom' columns. |
| geom_center_y | double | This column represents the Y coordinate for the geometric center point of the shape defined in the 'geom' columns. |
| gml_id | string | This is a unique identifier for each row in the table. |
| maakunta | string | This column contains the code for the region in question. |
| name | string | This column contains the English name of the region in question. |
| namn | string | This column contains the Swedish name of the region in question. |
| nimi | string | This column contains the Finnish name of the region in question. |
| vuosi | long | This column contains the year for which the data is relevant. |
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 | 45ff1a9e-e0a7-4b76-9fd0-ff5bfb5f1430 |
| Package id | 80f657df-c519-4c63-86b2-79200a5a0507 |
| Revision id | a2788108-53b7-48e8-88fd-b2bf1176b2f8 |
| State | active |
| Table | tilastointialueet_maakunta1000k_2024__table |