Regions 2019 (Scale 1:1 000 000) - Table from Finnish Statistical Dataset Collection
Click here for a data sample
The table contains detailed information about the provinces (Maakunnat) in Finland for the year 2019. The data provided is comprehensive, with a robust set of columns providing numerous perspectives on each province. For example, the data includes not only the name of the province but also its unique identifier, the year, and translations of the name into other languages. The data further offers geospatial information about each province, including its geographical center and the shape of its boundaries in various formats, which can be useful for geospatial data analytics. This geographical information is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Two special columns, '_extract_date' and '_row_number', provide additional insights: the former indicates the date when the data was extracted, and the latter provides the row number in the extracted data. These two columns combined can uniquely identify each row. This table can be utilized in various ways. For instance, the geospatial data can be used to create visual maps of the provinces and analyze geographical trends and patterns. The names and identifiers can be used to cross-reference other data sources for a more comprehensive understanding of each province. The table was sourced from the Finnish website 'Tilastokeskus' (Statistics Finland).
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. This information, combined with the '_row_number', provides a unique identifier for each row. |
|---|
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This information, combined with the '_extract_date', provides a unique identifier for each row. |
|---|
| geom_geojson | string | This column contains the geometry of the region in GeoJSON format, a popular format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains the geometry of the region in text format. |
|---|
| geom_type | string | This column specifies the type of geometry used for the region, for example, 'ST_MULTIPOLYGON'. |
|---|
| geom_centroid | string | This column contains the centroid of the geographic region, which is the arithmetic mean position of all the points in the shape. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center point of the geographic region. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center point of the geographic region. |
|---|
| gml_id | string | This column contains a unique identifier for each geographic region. |
|---|
| maakunta | string | This column contains a coded representation of the 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. |
|---|
| vuosi | long | This column contains the year of the data. |
|---|
