Regional Units 2020 (Scale 1:1,000,000) - Data Table
Click here for a data sample
The table comprises a dataset of regional units for the year 2020 at a scale of 1:1,000,000. The data originates from 'Tilastokeskus' (Statistics Finland), a Finnish web source. The table contains a wealth of information that can be used for various data analytics purposes. For instance, the name
, namn
, and nimi
columns contain the names of the regions in different languages, which can be beneficial for multilingual data analysis and reporting. The seutukunta
and vuosi
columns provide the code of the region and the year, respectively. The table also includes a unique identifier for each row, a combination of the 'extract_date' and '_row_number', which can be valuable for tracking data modifications over time. The table features multiple columns starting with 'geom', which contain geographic information useful for geospatial data analytics. For example, the 'geom_geojson' and 'geom_geotext' columns contain the geographical representation of the regions in different formats, while the 'geom_type' indicates the type of the geographical shape. The 'geom_centroid', 'geom_center_x', and 'geom_center_y' provide the center point of the regions. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. As a use case, the table can assist in understanding regional differences and trends within Finland, supporting decision-making in areas such as policy-making, urban planning, or market research.
Field Descriptions
Name |
Data type |
Description |
_extract_date | date | This column contains the date when the data on the corresponding row was extracted from the source. This information is crucial to understand the timeline of the dataset. |
_row_number | long | This column holds the row number as it is in the data extracted from the source on the extract date specified by the column '_extract_date'. This along with '_extract_date' column can be used to uniquely identify each row. |
geom_geojson | string | This column stores the geometric data of the regions in GeoJSON format, a popular open standard format designed for representing simple geographical features. |
geom_geotext | string | In this column, the geometric data is presented in textual format which is an alternative representation to the GeoJSON format in the 'geom_geojson' column. |
geom_type | string | This column specifies the type of geometric data, which can be either polygon or multipolygon, representing the shape of the statistical region. |
geom_centroid | string | This column stores the geographical point that represents the centroid, or the geometric center, of the region. |
geom_center_x | double | This column contains the X-coordinate of the centroid of the region. |
geom_center_y | double | This column contains the Y-coordinate of the centroid of the region. |
gml_id | string | This column holds a unique identifier for each row in the table. |
name | string | This column contains the name of the statistical region in English language. |
namn | string | This column provides the name of the statistical region in Swedish language. |
nimi | string | This column holds the name of the statistical region in Finnish language. |
seutukunta | string | This column contains a unique code assigned to each statistical region. |
vuosi | long | This column holds the year for which the statistical data is relevant. |