Large Areas 2014 (Scale 1:4 500 000) - Detailed Geospatial Data
The table is part of a larger dataset collection and it contains various pieces of information related to the 'Major Areas 2014' (Suuralueet 2014), which is a geographic region representation at a scale of 1:4 500 000. This table was sourced from the 'Tilastokeskus' website, a statistical database from Finland.
The data in this table is organized into several columns, each representing a unique aspect of the data. There are columns containing geographic information, which can be utilized for geospatial data analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This includes the geographical shape of the area (represented as a multipolygon), the centroid of this shape, and the center coordinates.
The table also contains columns providing multilingual names for each region, in languages including Finnish, Swedish, and English. There is also a column indicating the year of the data, which in this case is 2014.
Special attention should be given to two specific columns: '_extract_date' and '_row_number'. The '_extract_date' column contains the date when the row data was extracted from the data source, providing temporal context to the information. The '_row_number' column contains the row number in the data extracted from the source, which along with the '_extract_date' column, uniquely identifies each row.
We can utilize the data in this table for a variety of data analytics applications. For instance, the geographic information could be used to perform spatial analysis of different regions in Finland, such as identifying patterns or anomalies. The multiple languages of region names can aid in cross-lingual data analysis or in creating multilingual data visualizations. The year column can be helpful in temporal analysis or in comparing data across different years.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted from the source. It allows for tracking of the extraction history and data source updates. |
_row_number | long | This column contains the row number in the extracted data, which, in combination with the '_extract_date', uniquely identifies each row. |
geom_geojson | string | This column contains the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains the textual representation of the geographic data, which aligns with the GeoJSON data. |
geom_type | string | This column specifies the type of the geographic data, which in this case is a multi-polygon, indicating complex geographic structures. |
geom_centroid | string | This column contains the geographic coordinates of the centroid, which is the geographic center of the multi-polygon. |
geom_center_x | double | This column indicates the X coordinate (longitude) of the geographic center of the multi-polygon. |
geom_center_y | double | This column indicates the Y coordinate (latitude) of the geographic center of the multi-polygon. |
gml_id | string | This column contains a unique identifier for each row, following the GML (Geography Markup Language) standard. |
name | string | This column contains the English name of the area represented by the row's geographic data. |
namn | string | This column contains the name of the area in Swedish, one of the official languages in Finland. |
nimi | string | This column contains the name of the area in Finnish, the other official language in Finland. |
suuralue | string | This column contains a code associated with the area represented by the row's geographic data. |
vuosi | long | This column contains the year associated with the data, which indicates the temporal applicability 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 | 88912207-48ad-4929-8bba-1a2f9e9b739e |
Package id | bef5b4c5-c51f-48bf-8866-fc50581e5b89 |
Revision id | c41528f3-7f44-4bc1-abef-6aa464108ded |
State | active |
Table | tilastointialueet_suuralue4500k_2014__table |