Regions 2013 (1:1 000 000) - Data Table from Finnish Statistical Data Collection

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

Click here for a data sample

The table is a rich collection of geospatial data pertaining to the regions in Finland, as sourced from the 'Tilastokeskus' (Statistics Finland) website. The table presents detailed information about regions defined in 2013, as indicated by the column 'vuosi'. Each row in the table represents a specific region, with unique identifiers provided by two special columns: '_extract_date', which indicates the date when the data was extracted, and '_row_number', which denotes the row number in the data extracted. The combination of these columns uniquely identifies each row.

The table includes a wealth of geographic data, encoded in several different formats. Columns starting with 'geom_' contain geographic information which can be utilized for geospatial data analytics. For instance, 'geom_geojson' and 'geom_geotext' provide geographic coordinates in different formats. 'geom_type' indicates the type of geographic shape used, such as 'ST_MULTIPOLYGON', while 'geom_centroid', 'geom_center_x', and 'geom_center_y' provide details about the central point of each region, all presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.

The table also provides multiple names for each region, as indicated by the 'name', 'namn', and 'nimi' columns, reflecting the multilingual nature of the country. It also includes an administrative identifier for each region, as provided by the 'maakunta' column.

The data in this table can be used in a variety of data analytics applications. For example, it can be used to perform geospatial analysis of regional trends or to create detailed, interactive maps of the country. It can also be used to correlate regional data with other data sources, providing richer insights and enabling more informed decision-making.

Field Descriptions

Name Data type Description
_extract_datedateThis is a special column that contains the date when the data on the row of the table was extracted from the source.
_row_numberlongThis is another special column that contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' uniquely identifies each row.
geom_geojsonstringThe column contains geometric data in GeoJSON format, a common open standard format designed for representing simple geographical features.
geom_geotextstringThis column holds geometric data as text. The data is organized in the form of Multipolygons, which represent a specific geographic area.
geom_typestringThis column specifies the type of geometric data contained in the row. In this case, it's 'ST_MULTIPOLYGON', implying that the data represents multiple polygon shapes.
geom_centroidstringThis column contains the geographic coordinates of the centroid (geometric center) of the Multipolygon.
geom_center_xdoubleThis column contains the x-coordinate of the geometric center of the Multipolygon.
geom_center_ydoubleThis column contains the y-coordinate of the geometric center of the Multipolygon.
gml_idstringThis is a unique identifier for each row of the dataset.
maakuntastringThis column contains codes representing different regions or 'maakunta' in Finnish.
namestringThis column contains the English names of the regions.
namnstringThis column contains the Swedish names of the regions.
nimistringThis column contains the Finnish names of the regions.
vuosilongThis column indicates the year of the data record.

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
Id4ebf242f-0217-4cd3-a883-65add634e569
Package idcaa06384-abc9-409b-b8da-33dc08247ccb
Revision id6fbd1a22-7e75-49c8-9312-253c517d3d67
Stateactive
Tabletilastointialueet_maakunta1000k_2013__table