Large Areas 2019 (Scale 1:1,000,000) - Dataset Table
The table is a part of a dataset collection, and it encompasses a multitude of data primarily focused on geographic regions in Finland, specifically the major areas in 2019 (as translated from Suuralueet 2019). This data spans various geographic parameters and descriptions, providing a comprehensive profile of each region.
The table includes key details about the regions such as their names in different languages, including English, Finnish, and Swedish. It also provides a numerical representation of each region and the year of the data, which in this case is 2019.
A significant part of the table is dedicated to geospatial information, providing various forms of geographic data. This includes the geojson and geotext formats, the type of the geometric shape representing each region, the coordinates of the central point of each region, and the x and y coordinates of the center of the geometric shape. This geographic data is represented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. This data is crucial for geospatial data analytics, such as spatial analysis, routing, and geofencing.
Two special columns in the table are '_extract_date' and '_row_number'. The '_extract_date' column provides the date when the data was extracted from the source, while the '_row_number' column denotes the row number in the data as extracted from the source on the specified extract date. These two columns uniquely identify each row, ensuring easy and precise data tracking and retrieval.
The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland. The data in this table could be utilized in various ways in data analytics. For instance, it could be used to study regional trends over time, analyze spatial relationships and patterns, inform regional planning and policy-making, or provide geographic context to other datasets.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column records the date when the row's data was extracted from the source. It helps to track the freshness of the data. |
| _row_number | long | This column indicates the row number when the data was extracted from the source. It helps in maintaining the order of the data. |
| geom_geojson | string | This column contains geometric data in a GeoJSON format. It can be used for spatial analysis and visualizations. |
| geom_geotext | string | This column contains geometric data in text format. It provides a human-readable representation of the spatial data. |
| geom_type | string | This column defines the type of the geometry of the data. For example, it can be a multipolygon. |
| geom_centroid | string | This column contains the coordinates of the centroid of the geometry. It is useful for spatial analysis. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry. It is used for spatial analysis and visualizations. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry. It is used for spatial analysis and visualizations. |
| gml_id | string | This column contains a unique identifier for each record. It helps in reference and data management. |
| name | string | This column contains the English name of the region. It is useful for understanding the geographic context of the data. |
| namn | string | This column contains the Swedish name of the region. It provides a multilingual perspective on the data. |
| nimi | string | This column contains the Finnish name of the region. It provides a local context to the data. |
| suuralue | string | This column contains a numerical code for the region. It can be used for data analysis and joins with other tables. |
| vuosi | long | This column indicates the year the data pertains to. It can be used for temporal analysis and trend identification. |
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 | 5e000a93-80f9-435e-b14f-f947a6652342 |
| Package id | ea34732d-13b4-4170-bc63-a0dd05783666 |
| Revision id | 809150c0-2e8d-40dd-943d-66c1c5ba0fca |
| State | active |
| Table | tilastointialueet_suuralue1000k_2019__table |