Regional Units 2024 (Scale 1:1,000,000) - Data Table
The table in question is a part of a larger dataset collection, which is primarily related to the regional statistics of Finland. The dataset collection references the planned regional divisions for the year 2024, as stated in the Finish Statistics Bureau's website, 'Tilastokeskus'. The table contains various columns which include geospatial data and other related information about different regions.
The columns in this table contain information such as the date of data extraction, the row number, geometric information in various formats, the names of the regions in different languages, and the year associated with the data. More specifically, the 'geom_' columns contain geographic information which can be crucial for geospatial data analytics. They represent geospatial data in GeoJSON, GeoText, centroid, and center x and y coordinates. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
Two columns in particular, '_extract_date' and '_row_number', play a unique role in the way the data is organized. The '_extract_date' column specifies the date when the data was extracted, and the '_row_number' column assigns a unique number to each row. The combination of these two columns can uniquely identify each row in the table.
This table can be a useful resource for a variety of data analytics tasks. For instance, the geographic data can be used in geospatial analytics to study regional trends or patterns. The table could also be used to track changes over time, using the '_extract_date' column to see when the data was collected. Additionally, the multilingual naming columns can support international research or cross-cultural studies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. It helps to identify when the data was fetched. |
| _row_number | long | This column contains the row number of the data extracted from the source on the extract date specified by the column '_extract_date'. Each number is unique and helps to identify each row. |
| geom_geojson | string | This column contains the geospatial data in GeoJSON format, which is a format for encoding geographic data structures. |
| geom_geotext | string | This column contains the geospatial data in text format. It can be used to visually represent the geographic area. |
| geom_type | string | This column indicates the type of the geographical data. In this table, it is 'ST_POLYGON' indicating that the geographical data represents a polygon. |
| geom_centroid | string | This column provides the centroid of the geographical data, which is the arithmetic mean position of all the points in the shape. |
| geom_center_x | double | This column provides the X-coordinate of the center of the geographical data. |
| geom_center_y | double | This column provides the Y-coordinate of the center of the geographical data. |
| gml_id | string | This column provides a unique identifier for each row of data. |
| name | string | This column contains the name of the region in English. |
| namn | string | This column contains the name of the region in Swedish. |
| nimi | string | This column contains the name of the region in Finnish. |
| seutukunta | string | This column contains a coded value representing the region. |
| vuosi | long | This column contains the year associated with the data in the row. In this dataset, it is 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 | ec0389f5-5828-487f-b143-4c6406ccee57 |
| Package id | 2b30b2b0-1662-4d20-8335-5907b4b9c5bd |
| Revision id | 11fd320d-4436-4a1e-b926-a6a06b1dfbb5 |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2024__table |