Regional Units 2023 (1:1 000 000) - Data Table from Finland's Statistical Database
Click here for a data sample
The table is a comprehensive collection of related data, part of the dataset 'tilastointialueet_seutukunta1000k_2023'. It includes data on 'Regions 2023' at a scale of 1:1,000,000, sourced from the 'Tilastokeskus' website in Finland. The data is organized in a way that allows for easy analyses, with each row of data being uniquely identifiable through a combination of the 'extract_date' and '_row_number' columns, indicating the date of data extraction and the corresponding row number respectively. The table provides geographic data which can be utilized for geospatial data analytics. This information is contained in columns starting with 'geom' and is presented using WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. For instance, 'geom_geojson' and 'geom_geotext' columns offer geographic data in different formats, whereas 'geom_type' specifies the type of geographical data. The geographic center of each region is indicated by 'geom_centroid', with 'geom_center_x' and 'geom_center_y' representing the longitude and latitude coordinates respectively. Additional columns provide further details on each region, such as its name in different languages and a unique identifier ('gml_id'). The table could be utilized in various data analytics applications, for instance, in studying regional trends, plotting geographical distributions of data points, or in regional planning and development. As an example, the data could be used to map the population distribution across different regions in a given year, or to study the changes in population distribution over time.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the row data was extracted from the data source. It helps in tracking the currency of the data. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date. It, in combination with '_extract_date', uniquely identifies each row. |
|---|
| geom_geojson | string | This column contains the geographical data of the region in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geographical data of the region in text format. It helps in visualizing the region in a geospatial context. |
|---|
| geom_type | string | This column identifies the type of geographical shape or structure (like polygon or multipolygon) of the region represented in 'geom_geojson' and 'geom_geotext'. |
|---|
| geom_centroid | string | This column contains the centroid or the geometric center of the region. It is useful for identifying the central point of the region. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the geometric center of the region. It helps in mapping the region on a geospatial plane. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the geometric center of the region. It helps in mapping the region on a geospatial plane. |
|---|
| gml_id | string | This column contains a unique identifier for each row in the table. It is used for identifying each record uniquely. |
|---|
| name | string | This column contains the name of the region in English. It helps in identifying the region. |
|---|
| namn | string | This column contains the name of the region in Swedish. It provides a multilingual perspective to the data. |
|---|
| nimi | string | This column contains the name of the region in Finnish. It provides a multilingual perspective to the data. |
|---|
| seutukunta | string | This column contains an identifier for the region. It is used for identifying each region uniquely. |
|---|
| vuosi | long | This column contains the year for which the data is relevant. It helps in understanding the temporal context of the data. |
|---|
