Subregions 2018 (1:1 000 000) - Data Table of the Statistical Area Collection
Click here for a data sample
The table is an integral part of a dataset collection, providing an in-depth view of the regional divisions of Finland in 2018. The data is sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains various columns that provide a detailed representation of each region, inclusive of geographical and statistical information. The table hosts a wealth of information for each region, including its name in various languages, a unique indicator, and an associated year. The geographical information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. This information can be instrumental in performing geospatial data analytics. The table also contains special columns like '_extract_date' and '_row_number', which respectively record the date of data extraction and the unique row number for each extracted data. This combination allows for each row to be uniquely identified. This data could be utilized to perform trend analysis of regional development, to aid in planning logistical routes considering geographical data, or to perform comparative studies of regional statistics over time.
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 plays a crucial role in identifying each row in combination with the '_row_number' column. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. The combination of this column with '_extract_date' provides a unique identifier for each row. |
|---|
| geom_geojson | string | This column contains geographical data in GeoJSON format, a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the textual representation of the geographical data. |
|---|
| geom_type | string | This column indicates the type of the geographical data structure. For instance, it can be a 'MultiPolygon' which represents a shape consisting of multiple polygons. |
|---|
| geom_centroid | string | This column contains the centroid of the geographical data structure. The centroid is the arithmetic mean position of all the points in the shape. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical data structure. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical data structure. |
|---|
| gml_id | string | This is a string type column which does not have a clear description provided by the source. |
|---|
| name | string | This is a string type column with the 'name' of the corresponding entry. |
|---|
| namn | string | This is a string type column which is not clearly described by the source. |
|---|
| nimi | string | This is a string type column which is not clearly described by the source. |
|---|
| seutukunta | string | This is a string type column. The exact meaning and usage is not clear from the data source. |
|---|
| vuosi | long | This integer type column does not have a clear description provided by the source. |
|---|
