Regional Divisions 2013 (1:4 500 000) - Data Table
Click here for a data sample
The table is part of a larger dataset collection and it focuses on regional data from 2013, specifically referred to as 'Seutukunnat 2013' which translates to 'Sub-regions 2013'. This information is thoughtfully organized into various columns that encompass a wealth of information. For instance, the table includes columns that provide geographic information in the form of GeoJSON, GeoText, and centroid data. These geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude, which can be extremely useful for geospatial data analytics. Additionally, the table includes identifiers for each region, depicted in three different languages, and a unique region code ('seutukunta'). The data also provides the year of the data as another column. The table has two special columns that uniquely identify each row: '_extract_date', which contains the date when the data on the row was extracted, and '_row_number', which contains the row number in the data extracted from the source on the specific extract date. With such a wealth of information, the data in this table could be utilized in a variety of ways for data analytics. For instance, it could be used to track regional changes over time, assist in regional planning and development, or even be used in socio-economic studies to compare different regions. The data is sourced from the 'Tilastokeskus' (Statistics Finland) website in Finland.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This is a special column that contains the date when the data on the row of the table was extracted from the data source. This column, in combination with the '_row_number' column, is used to uniquely identify each row in the table. |
|---|
| _row_number | long | This is another special column that contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This column, along with the '_extract_date' column, uniquely identifies each row in the table. |
|---|
| geom_geojson | string | This column contains the geometric data of the regions in the MultiPolygon format in GeoJSON. |
|---|
| geom_geotext | string | This column contains the geometric data of the regions in the MultiPolygon format as text strings. |
|---|
| geom_type | string | This column specifies the type of the geometric data stored in the 'geom_geojson' and 'geom_geotext' columns. The type in this dataset is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygon shapes. |
|---|
| geom_centroid | string | This column contains the centroid point of the geometric shape representing the region. The centroid is calculated as the arithmetic mean position of all the points in the shape. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the centroid point of the geometric shape representing the region. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the centroid point of the geometric shape representing the region. |
|---|
| gml_id | string | This column contains the unique identifier of the region. The identifier is constructed as 'seutukunta4500k_2013' followed by a unique number for each region. |
|---|
| name | string | This column contains the name of the region in English. |
|---|
| namn | string | This column contains the name of the region in Swedish. |
|---|
| nimi | string | This column contains the name of the region in Finnish. |
|---|
| seutukunta | string | This column contains the statistical region code for the region. |
|---|
| vuosi | long | This column contains the year when the data was collected. In this dataset, the data was collected in the year 2013. |
|---|
