Provinces 2015 (1:4 500 000) - Dataset Collection of Finnish Statistical Regions

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

Click here for a data sample

The table in question belongs to a dataset collection that captures geospatial information related to the administrative regions of Finland in 2015. The data is sourced from 'Tilastokeskus' (Statistics Finland), the national statistical institution of Finland. The table contains various columns that store a wealth of information about each region.

The data in the table can be broken down into three main categories - geographic, identification, and shape data. The geographic data, including geospatial coordinates and geographic type, is stored in columns that start with 'geom_'. This data is presented using the WGS 84 coordinate reference system, which uses longitude and latitude to pinpoint locations. This information could be used for geospatial data analytics, such as plotting the regions on a map or calculating the distance between them.

The identification data, found in columns such as 'name', 'namn', and 'nimi', provides different names for each region in various languages. This can be useful for creating multilingual representations of the data or for cross-referencing with other datasets.

The shape data, contained in 'shape_star' and 'shape_stle', gives information about the physical characteristics of each region. The 'shape_star' column provides the area size of the region while the 'shape_stle' column provides the perimeter length. This information could be used to analyze the physical characteristics of each region, for instance, comparing their sizes or evaluating the compactness of their shapes.

In addition to these, the table also contains two special columns - '_extract_date' and '_row_number'. The '_extract_date' column provides the date when the row data was extracted, while the '_row_number' represents the unique row number on that extract date. This combination uniquely identifies each row, which is important for tracking data changes over time. For instance, if the data is extracted periodically, these columns could be used to analyze trends or changes in the region data over time.

Field Descriptions

Name Data type Description
_extract_datedateThis column indicates the date when the data on the row of the table was extracted from the source. This, along with '_row_number' column, helps in uniquely identifying each row.
_row_numberlongThis column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date' column, uniquely identifies each row.
geom_geojsonstringThis column contains geographical information in GeoJSON format, a format for encoding a variety of geographic data structures.
geom_geotextstringThis column stores the geographic data as text. It is a representation of the geographical region.
geom_typestringThis column contains the type of the geographical data, which in this dataset is usually a multi-polygon.
geom_centroidstringThis column contains the point that represents the geometric center of the region.
geom_center_xdoubleThis column represents the x-coordinate of the geometric center of the region.
geom_center_ydoubleThis column represents the y-coordinate of the geometric center of the region.
gml_idstringThis column holds a unique identifier for each record.
maakuntastringThis column contains the codes for the regions or provinces in Finland.
namestringThis column contains the English names of the regions or provinces.
namnstringThis column contains the Swedish names of the regions or provinces.
nimistringThis column contains the Finnish names of the regions or provinces.
shape_stardoubleThis column contains the area size of each region.
shape_stledoubleThis column contains the perimeter length of each region.
vuosidoubleThis column contains the year of the data, which in this dataset, is the year 2015.

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
Id8a891647-13f3-433a-a893-c83f054ab903
Package idcc7aa84b-9dd6-4f7c-9df8-317e1901f9bc
Revision id3501c7f7-5915-45dc-bea8-209b7b86d60c
Stateactive
Tabletilastointialueet_maakunta4500k_2015__table