Regions 2013 (1:4 500 000) - Dataset Table
The table is a well-structured data set focusing on 'Regions in 2013 (1:4 500 000)', sourced from 'Tilastokeskus' (Statistics Finland). It is part of a more extensive dataset collection that includes related information.
The table comprises several columns that offer various pieces of information. For instance, two specific columns, the extract date and the row number, allow for the tracking and unique identification of each piece of data. The extract date indicates when the information was gathered, and the row number provides the sequence in which it was collected.
Geographical data is also a significant aspect of this table, with several columns dedicated to this aspect. These columns, starting with 'geom_', include geographic coordinates, which follow the WGS 84 coordinate reference system. This system orders the axis with longitude first, followed by latitude, providing precision in geospatial data analytics.
The table includes information about each region, such as its name, which is available in multiple languages. Additionally, data like the unique region identifier and the year of data collection (2013 in this case) are also available.
This table offers several opportunities for data analytics. For example, the geographical information could be used to create detailed maps and conduct spatial analysis. The multilingual region names could assist in international studies or localization efforts. The unique identifiers and extraction dates could also be useful in tracking changes over time or comparing data with other sources.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column represents the date when the data for the corresponding row was extracted. It helps in tracking the history of data updates. |
| _row_number | long | This column contains the unique row number in the data extracted. It is used in conjunction with '_extract_date' to uniquely identify each row in the data. |
| geom_geojson | string | This column holds the GeoJSON representation of the geographical data. This is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the text representation of the geographical data. It is typically in a format such as 'MULTIPOLYGON'. |
| geom_type | string | This column indicates the type of geometric data stored in the row. For example, 'ST_MULTIPOLYGON' signifies that the geographic data represents a multipart polygon. |
| geom_centroid | string | This column provides the geographic coordinates of the centroid, or geometric center, of the geographic feature. |
| geom_center_x | double | This column stores the X coordinate of the geometric center of the geographic feature. |
| geom_center_y | double | This column stores the Y coordinate of the geometric center of the geographic feature. |
| gml_id | string | This column holds a unique identifier for the geographic feature. It typically includes the dataset name and an individual ID for the feature. |
| maakunta | string | This column represents the 'province' in Finnish. It is an administrative division in Finland. |
| name | string | This column contains the English names of the provinces. |
| namn | string | This column contains the Swedish names for the provinces. Finland is a bilingual country with Finnish and Swedish as the official languages. |
| nimi | string | This column provides the Finnish names for the provinces. |
| vuosi | long | This column specifies the year to which the data pertains. |
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 | 1c3495b3-d607-4f82-908b-fa0c15f3fa35 |
| Package id | 85c02e6a-7af1-45ac-bf8c-72a438671e54 |
| Revision id | 298cfebb-819d-49ac-8758-051ba378a052 |
| State | active |
| Table | tilastointialueet_maakunta4500k_2013__table |