Major Regions 2017 (Scale 1:4,500,000) - Dataset Table
The table is a part of the dataset collection that houses data related to 'Major Regions 2017 (1:4 500 000)'. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. The data is organized in columns, each representing a specific aspect of the major regions.
The table contains special columns such as '_extract_date', which signifies the date the data was extracted, and '_row_number', which represents the row number in the data extracted. These two columns uniquely identify each row.
The table also contains several columns starting with 'geom_', these columns carry geographic information that can be used for geospatial data analytics. For instance, 'geom_center_x' and 'geom_center_y' represent the geographic coordinates of the major regions, specified in the WGS 84 coordinate reference system.
Columns like 'name', 'namn', and 'nimi' provide the names of the major regions in different languages. Other columns such as 'suuralue' and 'vuosi' offer additional information about the major regions.
The data in this table can be utilized in various ways. For instance, it can be used to analyze the geographic distribution of different regions. The 'extract_date' column can be used to track changes in the data over time. The 'geom' columns can be used in geospatial analytics to visualize the spatial distribution and characteristics of these regions. The multi-lingual names can aid in making the data accessible and understandable to a wider audience.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This special column contains the date when the row data was extracted from the source. It helps in tracking when the specific data was fetched. |
| _row_number | long | Another special column which stores the row number of the extracted data from the source. When combined with '_extract_date', it uniquely identifies each row. |
| geom_geojson | string | This column contains the geographical data in the GeoJSON format representing different regions. |
| geom_geotext | string | Stores geographical data as text, typically used for complex geographical structures. |
| geom_type | string | Specifies the type of the geographical data stored. In this case, it is 'ST_MULTIPOLYGON', indicating that the data represents multiple polygon shapes. |
| geom_centroid | string | Contains the central point (centroid) of the geographical figure represented. |
| geom_center_x | double | The X-coordinate of the center point of the geographical area. |
| geom_center_y | double | The Y-coordinate of the center point of the geographical area. |
| gml_id | string | A unique identifier for each record in the table. |
| name | string | The English name of the region represented by the row. |
| namn | string | The name of the region in Swedish. |
| nimi | string | The name of the region in Finnish. |
| suuralue | string | A numerical code representing the large area (suuralue in Finnish) the region belongs to. |
| vuosi | double | The year the data was collected or is relevant to. |
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 | 67ea99f6-1b83-47b9-b62a-eff1e1d5cc7d |
| Package id | 822b3e38-3ee8-45e5-96d4-a8d92a040f1f |
| Revision id | 65c0546b-a760-4925-af17-304885acb71c |
| State | active |
| Table | tilastointialueet_suuralue4500k_2017__table |