Regions 2018 (Scale 1:1 000 000) - Geospatial Data
Click here for a data sample
The table is part of a dataset collection that encapsulates data related to the administrative regions of Finland for the year 2018. It is sourced from 'Tilastokeskus' (Statistics Finland), offering a detailed depiction of regions at a 1:1 000 000 scale. The information included ranges from the unique identifiers of these regions, their names in different languages, to the year of the data. It also provides a wealth of geospatial data, enabling the analysis of the regions' geographical characteristics. For instance, it includes geographical information in various formats, such as GeoJSON and GeoText, the type of the geometry, and the coordinates of the centroid of the geometry. The geographical coordinates are presented using the WGS 84 coordinate reference system, with the longitude coming before the latitude. Each row in the table is uniquely identified by a combination of the extraction date and the row number, indicating when the data was retrieved and its position in the extracted data. This table can serve multiple purposes in data analytics. It can be used to analyze geographical patterns and trends, to study regional differences and similarities, as well as to integrate with other data for comprehensive multidimensional analysis.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column records the date when the data row was extracted from the data source. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row. |
|---|
| geom_geojson | string | This column stores the geographical data in GeoJSON format which represents simple geographical features. |
|---|
| geom_geotext | string | This column contains the geographical data in text format. |
|---|
| geom_type | string | This column defines the type of the geographical object. |
|---|
| geom_centroid | string | This column represents the geographical center of the object in the form of a point. |
|---|
| geom_center_x | double | This column represents the X-coordinate of the geographical center of the object. |
|---|
| geom_center_y | double | This column represents the Y-coordinate of the geographical center of the object. |
|---|
| gml_id | string | This column contains a unique identifier for each row. |
|---|
| maakunta | string | This column represents the province code. |
|---|
| name | string | This column contains the name of the province in English. |
|---|
| namn | string | This column contains the name of the province in Swedish. |
|---|
| nimi | string | This column contains the name of the province in Finnish. |
|---|
| vuosi | long | This column represents the year to which the data refers. |
|---|
