Large Areas Projection for 2024 (Scale 1:4,500,000)
This table, a part of the 'tilastointialueet_suuralue4500k_2024' dataset collection, provides an in-depth view into the regional geography of Finland. It contains important information about 'The Major Regions of Finland in 2024', which is the English translation of the table's original description: 'Suuralueet 2024 (1:4 500 000)'.
The information in the table is diverse and includes geographical data, such as 'geom_geojson' and 'geom_geotext', which offer multi-dimensional shapes of the regions. The 'geom_type' column indicates the type of the geographical shape. Furthermore, the table provides the center point of each region, as depicted by 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These geographical coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Apart from geographical data, the table also includes unique identifiers for each region in the 'gml_id' column. It also contains the names of the regions in different languages: English ('name'), Swedish ('namn'), and Finnish ('nimi'). There is also a column 'suuralue' that represents the numeric identifier for each region and 'vuosi' indicating the year of the data, which in this case is 2024.
The data in this table is organized with the help of two special columns: '_extract_date' and '_row_number'. The '_extract_date' column records the date when the data was extracted, while '_row_number' notes the row number in the extracted data. A combination of these two columns uniquely identifies each row in the table.
The data from this table, sourced from the Statistics Finland (Tilastokeskus) website, could serve a variety of uses in data analytics. For instance, it could be employed to perform geospatial analysis, study population distribution, undertake regional planning, or analyze economic performance by region. Moreover, the multilingual data can aid in creating region-specific communications in local languages.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date when the data on each row was extracted from the data source. This helps in tracking the timeline of data extraction. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It helps in uniquely identifying each row. |
geom_geojson | string | This is a geographical data column that contains geometric data in the form of GeoJSON, a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains geometric data in a text format, which represents various geographical structures. |
geom_type | string | This column specifies the type of the geometric data. In this case, it is 'ST_MULTIPOLYGON', indicating that the data represents a collection of polygons. |
geom_centroid | string | This column contains the geometric centroid of the geographic feature. The centroid is the arithmetic mean position of all the points in the shape. |
geom_center_x | double | This column contains the X coordinates of the geometric center of the feature. |
geom_center_y | double | This column contains the Y coordinates of the geometric center of the feature. |
gml_id | string | This is a unique identifier for each geographic feature in the GML (Geography Markup Language) format. |
name | string | This column presents the names of geographical areas in English. |
namn | string | This column presents the names of geographical areas in Swedish. |
nimi | string | This column presents the names of geographical areas in Finnish. |
suuralue | string | This column contains a numerical identifier for each large area. |
vuosi | long | This column contains the year associated with the data. In this case, the sample data is from the year 2024. |
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 | 55a0e19b-e910-4faf-b78b-24d496d9e437 |
Package id | 536873d1-133a-4d26-8019-1b21ad632dd3 |
Revision id | a95b5caa-a3ee-4181-a4f7-129954936da1 |
State | active |
Table | tilastointialueet_suuralue4500k_2024__table |