Regions 2017 (Scale 1:4 500 000) - Data Collection from Finnish Statistical Database
Click here for a data sample
The table is a part of a larger dataset called 'Regions 2017 (1:4 500 000)', which is sourced from the 'Statistics Finland' website. The data primarily represents the Finnish regions as they were in the year 2017. The table contains several columns, some of which provide geospatial data while others provide additional information about the regions. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Geospatial data is available in multiple formats, including GeoJSON and GeoText, and can be used for geospatial data analytics. The table also includes columns for region names in Finnish and Swedish, the two official languages of Finland, and a unique region identifier. Two key columns, '_extract_date' and '_row_number', contain the date when the data on the row was extracted from the source, and the row number in the extracted data, respectively. Combined, these two columns uniquely identify each row. The data in this table could be used for a wide range of data analytics tasks. For example, analyzing changes in regional boundaries over time, studying the geographical distribution of different regions, or integrating this data with other datasets to perform more complex geographical analyses.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data in the row was extracted from the source. It plays a critical role in identifying each row uniquely when combined with the '_row_number' column. |
|---|
| _row_number | long | This column contains the row number for the data extracted from the source. When paired with the '_extract_date' column, it helps in uniquely identifying each row. |
|---|
| geom_geojson | string | This column contains geometric data in the GeoJSON format, a popular open standard format designed for representing simple geographical features. |
|---|
| geom_geotext | string | This column holds geometric data in text format, offering a textual representation of the geographical features. |
|---|
| geom_type | string | This column specifies the type of geometric data in the row, such as 'ST_MULTIPOLYGON', indicating the representation of multiple polygon areas. |
|---|
| geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the given geographical feature. |
|---|
| geom_center_x | double | This column holds the x-coordinate of the center point of the geometric data. |
|---|
| geom_center_y | double | This column stores the y-coordinate of the center point of the geometric data. |
|---|
| gml_id | string | The 'gml_id' is a string type column that provides a unique identifier for each row. |
|---|
| maakunta | string | The 'maakunta' is a string type column that represents the region or province of the geographical feature. |
|---|
| name | string | This column contains the English name of the region or province. |
|---|
| namn | string | This column holds the Swedish name of the region or province. |
|---|
| nimi | string | The 'nimi' column represents the Finnish name of the region or province. |
|---|
| vuosi | double | The 'vuosi' column is a real type column that represents the year related to the data in the row. |
|---|
