Provinces 2024 Dataset: Geographic and Demographic Details (1:4 500 000 scale)
The table in focus is a constituent of a dataset collection, comprising related data tables. This table, specifically, holds an array of data related to 'Regions 2024' at a scale of 1:4,500,000, sourced from the Finnish statistical agency 'Tilastokeskus'. The data represents a detailed geographical and statistical outlook of various regions, with the scope of this data spanning to the year 2024. The table includes columns that store the date of data extraction and the row number from the original data source, providing a unique identifier for each row of data.
The table incorporates a rich set of geographical data, with several columns storing geospatial information. This information can be leveraged for geospatial data analytics, exploring geographical patterns and trends. The data includes different types of geographic shapes, such as polygons and multipolygons, and their corresponding coordinates. Geographical coordinates are expressed in the WGS 84 coordinate reference system, with the longitude appearing first, followed by latitude.
Other columns in the table hold statistical and descriptive data about the regions. This includes the unique identifier of each region, the region's name in different languages, and a year marker. This variety of data offers a wide range of possibilities for data analysis. For instance, it can be used to study regional characteristics, perform comparative analysis between regions, or trace changes over time.
To summarize, this table offers a comprehensive dataset that combines temporal, geographical, and statistical data, providing a solid basis for diverse data analytics tasks. From studying regional variations and exploring geospatial patterns, to tracking changes over time, the potential applications of this data are extensive.
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 source. It plays a critical role in uniquely identifying each row in combination with '_row_number'. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, in combination with '_extract_date', uniquely identifies each row. |
| geom_geojson | string | This column contains the geometric representation of the area in GeoJSON format. This is a standard format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geometric information in text format. It provides a human-readable representation of the geographic data. |
| geom_type | string | This column specifies the type of the geometric information stored in the 'geom_geojson' and 'geom_geotext' columns. It can be either a polygon or a multipolygon. |
| geom_centroid | string | This column contains the geometric center, or centroid, of the area represented by the geometric information in the row. The centroid is a single point that defines the geometric center of all points in the object. |
| geom_center_x | double | This column contains the x-coordinate of the centroid of the area. It is a part of the geometric center information. |
| geom_center_y | double | This column contains the y-coordinate of the centroid of the area. It is a part of the geometric center information. |
| gml_id | string | This is a string column which contains a unique identifier for each row. |
| maakunta | string | This is a string column which contains the name of the region in local language. |
| name | string | This column contains the name of the region in English. |
| namn | string | This column contains the name of the region in another local language. |
| nimi | string | This column contains the name of the region in a different local language. |
| vuosi | long | This is an integer column which contains the year for which the data was collected. |
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 | c55357ab-7cf8-4777-93a7-67fe63c55c8a |
| Package id | 09bcca84-8376-4b08-9ecd-1e56452c3b26 |
| Revision id | 9465f522-6a8e-4af5-98f2-0dfd1a75121a |
| State | active |
| Table | tilastointialueet_maakunta4500k_2024__table |