Large Areas 2014 (Scale 1:4 500 000) - Detailed Geospatial Data

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThis 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_numberlongThis column contains the row number in the extracted data, which, in combination with the '_extract_date', uniquely identifies each row.
geom_geojsonstringThis column contains the geographic data in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotextstringThis column contains the textual representation of the geographic data, which aligns with the GeoJSON data.
geom_typestringThis column specifies the type of the geographic data, which in this case is a multi-polygon, indicating complex geographic structures.
geom_centroidstringThis column contains the geographic coordinates of the centroid, which is the geographic center of the multi-polygon.
geom_center_xdoubleThis column indicates the X coordinate (longitude) of the geographic center of the multi-polygon.
geom_center_ydoubleThis column indicates the Y coordinate (latitude) of the geographic center of the multi-polygon.
gml_idstringThis column contains a unique identifier for each row, following the GML (Geography Markup Language) standard.
namestringThis column contains the English name of the area represented by the row's geographic data.
namnstringThis column contains the name of the area in Swedish, one of the official languages in Finland.
nimistringThis column contains the name of the area in Finnish, the other official language in Finland.
suuraluestringThis column contains a code associated with the area represented by the row's geographic data.
vuosilongThis 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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id88912207-48ad-4929-8bba-1a2f9e9b739e
Package idbef5b4c5-c51f-48bf-8866-fc50581e5b89
Revision idc41528f3-7f44-4bc1-abef-6aa464108ded
Stateactive
Tabletilastointialueet_suuralue4500k_2014__table