Regions 2017 (Scale 1:1,000,000) - Part of Dataset on Statistical Areas in Finland
Click here for a data sample
The table, sourced from Finland's 'Tilastokeskus' (Statistics Finland), provides a comprehensive set of data relating to the 'Seutukunnat 2017' (Regions 2017) on a scale of 1:1 000 000. This table is part of a larger dataset collection named 'tilastointialueet_seutukunta1000k_2017'. The data within the table is organized into various columns each with a specific focus. Key columns include 'extract_date' and '_row_number' which provide information about when the data was extracted and the row number in the extracted data respectively. These two columns together uniquely identify each row. Other columns provide geographical data that can be utilized for geospatial data analytics. For instance, columns starting with 'geom' contain geographical information, including longitude and latitude, presented using the WGS 84 coordinate reference system. Additionally, columns like 'name', 'namn', 'nimi', 'seutukunta', and 'vuosi' provide further descriptive information. The data from this table can be used in various data analytics applications. For example, it could be used to analyze regional trends over time, or to create detailed geographic visualizations of the data. It could also be used in predictive modeling, for instance, to predict future population or economic trends in different regions.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column represents the date when the data was extracted from the source. It provides a reference point for when the data was fetched, and can be used to track changes in the data over time. |
|---|
| _row_number | long | This column contains the row numbers from the original data source, giving a unique identifier for each data entry when combined with the extract date. |
|---|
| geom_geojson | string | This column stores the geographical data in GeoJSON format, a widely used format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains geographical data in text format, specifically in the MULTIPOLYGON format, which defines multiple polygon areas. |
|---|
| geom_type | string | This column specifies the type of the geographical data. In this case, it is 'ST_MULTIPOLYGON', indicating that the geographic data is a collection of multiple polygons. |
|---|
| geom_centroid | string | This column contains the centroid of the geographical data, representing the geometric center of the set of polygons. |
|---|
| geom_center_x | double | This column represents the X-coordinate of the geometric center of the set of polygons. |
|---|
| geom_center_y | double | This column represents the Y-coordinate of the geometric center of the set of polygons. |
|---|
| gml_id | string | This column holds a unique identifier for each entry in the dataset, which is based on the 'seutukunta1000k_2017' dataset collection. |
|---|
| name | string | This column contains the names of the geographical areas in English. |
|---|
| namn | string | This column contains the names of the geographical areas in Swedish. |
|---|
| nimi | string | This column contains the names of the geographical areas in Finnish. |
|---|
| seutukunta | string | This column contains unique codes that represent different districts in Finland. |
|---|
| vuosi | double | This column represents the year when the data was collected. |
|---|
