Regional Units 2013 (1:1 000 000) from the Statistical Database
The table in discussion is a part of a larger dataset collection and contains significant information about the subregions of Finland in the year 2013. The data has been sourced from the Finnish Statistical Authority, 'Tilastokeskus' (Statistics Finland). Each row in the table represents a different subregion, with the data having been extracted on specific dates.
The table includes columns that provide both general and geospatial data. General data includes the unique identification of each subregion, its name in different languages including Finnish and Swedish, and the year of data collection.
Geospatial data is presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. These columns provide a wealth of information such as the type of geographical shape that represents the subregion, the geotext and geojson data which can be used in mapping software, the centroid of the shape, and the x and y coordinates of the centre of the shape.
Two special columns, '_extract_date' and '_row_number', provide additional context to the data. The '_extract_date' column contains the date when the data for each row was extracted, while the '_row_number' column represents the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. Together, they uniquely identify each row in the table.
The data in this table can be used for a variety of data analytics applications. For example, the geospatial data can be used to conduct geographical analyses of the subregions, such as determining their size, shape, and location. The general data can be used to study trends and patterns in the naming and numbering of these subregions. Furthermore, the '_extract_date' and '_row_number' can be utilized to track changes in the data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the row data was extracted from the dataset. It helps to track the freshness of the data. |
| _row_number | long | This column contains the unique row number for each data extraction. It can be used in combination with '_extract_date' to uniquely identify each row. |
| geom_geojson | string | This column contains geometric data in GeoJSON format, which is a standard format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geometric data as text. It is another way of representing geographic data besides GeoJSON. |
| geom_type | string | This column describes the type of geometric data contained in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the area represented by the geometric data. |
| geom_center_x | double | This column contains the X-coordinate of the geometric center of the area. |
| geom_center_y | double | This column contains the Y-coordinate of the geometric center of the area. |
| gml_id | string | This column contains a unique identifier for each row, which can be used for referencing specific entries. |
| name | string | This column contains the name of the region described by the row data in English. |
| namn | string | This column contains the name of the region in another language, providing a multilingual aspect to the dataset. |
| nimi | string | This column contains the name of the region in yet another language, further enhancing the multilingual nature of the dataset. |
| seutukunta | string | This column contains a distinct code representing the region. |
| vuosi | long | This column contains the year the data was collected, which is helpful for understanding the temporal context of the data. |
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 | 305e4f63-56a7-416a-b94f-67d7e1d54149 |
| Package id | 30d5c858-98f8-43cf-93a9-b17290d3cb64 |
| Revision id | fdd7eaf2-5ad1-46b2-a561-5254fb422133 |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2013__table |