Regions 2014 (1:4 500 000) - A Detailed Geospatial Dataset
This table, located within the dataset 'tilastointialueet_maakunta4500k_2014', provides a comprehensive set of data related to the regions of Finland in 2014. The data has been sourced from the Finnish statistical agency, 'Tilastokeskus' (Statistics Finland). The table contains various columns which provide details such as the date of data extraction, row number, geographic details, and region-specific information. The geographic details are given in the WGS 84 coordinate reference system, with longitude first, followed by latitude. Columns starting with 'geom_' contain this geospatial information, which can be used for data analytics involving geographic positioning and visualization.
For instance, the data in the 'geom_center_x' and 'geom_center_y' columns represent the central longitude and latitude coordinates of each region respectively. The 'geom_type' column indicates the type of geographic shape that is represented, while the 'geom_centroid' and 'geom_geojson' provide detailed geometric descriptions of these regions.
The regional information includes columns for different names of the regions in various languages, and the year in the 'vuosi' column corresponds to the year of data. The table also includes an identification column 'gml_id' that provides a unique identifier for each row.
Two special columns, '_extract_date' and '_row_number', play a unique role in this table. The '_extract_date' column indicates the date when the row's data was extracted, and the '_row_number' identifies the order of the data extraction. Together, these two columns uniquely identify each row in the table.
This table can be used for various data analytics purposes. For instance, it could be used for regional demographic studies, geospatial analysis, or trend forecasting based on the year and region. It could also be used to create multilingual geographic visualizations or for conducting geospatial data analytics.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column records the date when the data on the row was extracted from the data source. This, combined with the '_row_number' column, forms a unique identifier for each row. |
| _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'. It helps in uniquely identifying each row in combination with the '_extract_date' column. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column holds the geometric data in text form. It is useful for visualizing the geographic structures associated with the data. |
| geom_type | string | This column specifies the type of geometric data stored in the row. For example, the type could be 'ST_MULTIPOLYGON' which represents a geographical shape that comprises multiple polygons. |
| geom_centroid | string | This column contains the central point of the geometric shape represented by the row. It is calculated based on the geometric data. |
| geom_center_x | double | This column records the x-coordinate of the center of the geometric shape. |
| geom_center_y | double | This column records the y-coordinate of the center of the geometric shape. |
| gml_id | string | This column contains the unique identifier for the geometric data in GML (Geography Markup Language) format. |
| maakunta | string | This column stores a unique identifier for the Finnish province ('maakunta' in Finnish) associated with the row. |
| name | string | This column contains the English name of the Finnish province associated with the row. |
| namn | string | This column holds the Swedish name of the Finnish province. In Finland, both Finnish and Swedish are official languages. |
| nimi | string | This column records the Finnish name of the province associated with the row. |
| vuosi | long | This column contains the year related to the data in the row. It helps in understanding the temporal context of the data. |
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 | 5cfb6d9a-ae1b-4d76-a8b7-4f7075cb4036 |
| Package id | 26b736d5-1838-4b9e-97e3-14afc409368a |
| Revision id | 3d5d040a-da52-4829-9920-7ea4ef743334 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2014__table |