Regions 2013 (1:1 000 000) - Data Table from Finnish Statistical Data Collection
The table is a rich collection of geospatial data pertaining to the regions in Finland, as sourced from the 'Tilastokeskus' (Statistics Finland) website. The table presents detailed information about regions defined in 2013, as indicated by the column 'vuosi'. Each row in the table represents a specific region, with unique identifiers provided by two special columns: '_extract_date', which indicates the date when the data was extracted, and '_row_number', which denotes the row number in the data extracted. The combination of these columns uniquely identifies each row.
The table includes a wealth of geographic data, encoded in several different formats. Columns starting with 'geom_' contain geographic information which can be utilized for geospatial data analytics. For instance, 'geom_geojson' and 'geom_geotext' provide geographic coordinates in different formats. 'geom_type' indicates the type of geographic shape used, such as 'ST_MULTIPOLYGON', while 'geom_centroid', 'geom_center_x', and 'geom_center_y' provide details about the central point of each region, all presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude.
The table also provides multiple names for each region, as indicated by the 'name', 'namn', and 'nimi' columns, reflecting the multilingual nature of the country. It also includes an administrative identifier for each region, as provided by the 'maakunta' column.
The data in this table can be used in a variety of data analytics applications. For example, it can be used to perform geospatial analysis of regional trends or to create detailed, interactive maps of the country. It can also be used to correlate regional data with other data sources, providing richer insights and enabling more informed decision-making.
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 source. |
_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'. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
geom_geojson | string | The column contains geometric data in GeoJSON format, a common open standard format designed for representing simple geographical features. |
geom_geotext | string | This column holds geometric data as text. The data is organized in the form of Multipolygons, which represent a specific geographic area. |
geom_type | string | This column specifies the type of geometric data contained in the row. In this case, it's 'ST_MULTIPOLYGON', implying that the data represents multiple polygon shapes. |
geom_centroid | string | This column contains the geographic coordinates of the centroid (geometric center) of the Multipolygon. |
geom_center_x | double | This column contains the x-coordinate of the geometric center of the Multipolygon. |
geom_center_y | double | This column contains the y-coordinate of the geometric center of the Multipolygon. |
gml_id | string | This is a unique identifier for each row of the dataset. |
maakunta | string | This column contains codes representing different regions or 'maakunta' in Finnish. |
name | string | This column contains the English names of the regions. |
namn | string | This column contains the Swedish names of the regions. |
nimi | string | This column contains the Finnish names of the regions. |
vuosi | long | This column indicates the year of the data record. |
No sample for this dataset
Additional Information
Last updated | November 11, 2024 |
---|---|
Created | November 11, 2024 |
License | No License Provided |
Geographic coverage | |
Geographic granularity | |
Temporal coverage from | |
Temporal coverage to | |
Temporal coverage to | |
Country | fi |
Database | fi_tilastokeskus |
Extract date | 2024-11-11 |
Id | 4ebf242f-0217-4cd3-a883-65add634e569 |
Package id | caa06384-abc9-409b-b8da-33dc08247ccb |
Revision id | 6fbd1a22-7e75-49c8-9312-253c517d3d67 |
State | active |
Table | tilastointialueet_maakunta1000k_2013__table |