Large Areas 2022 (Scale 1:4,500,000) - Dataset Table
The table, which is part of the 'tilastointialueet_suuralue4500k_2022' dataset collection, comprises data organized into several columns and rows. The table provides information on the 'Large Areas 2022', a geographical classification that is useful for spatial data analysis. The data in the table is sourced from the 'Tilastokeskus' website based in Finland.
The table comprises a number of columns, each providing different types of information. Special columns such as '_extract_date' and '_row_number' are included, recording the date of data extraction and the row number, respectively. This combination uniquely identifies each row in the table. Some of the columns provide geographical data, including geographic coordinates presented using the WGS 84 coordinate reference system. This system orders coordinates with longitude first, followed by latitude, making the geographic data useful for geospatial analysis.
The table can be utilized in various ways for data analytics. For instance, it can be used to analyze spatial patterns and trends over time, considering the data is updated regularly. Additionally, the geographic data can be used to create visual representations of the 'Large Areas', aiding in spatial understanding and analysis. Furthermore, the extracted data can be compared over different dates to track changes in these geographical areas over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_extract_date | date | This column contains the date when the data on the row was extracted. It helps in understanding the data collection period. |
_row_number | long | This column contains the row number in the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row. |
geom_geojson | string | This column contains the geographical data in GeoJSON format. It helps in representing and visualizing complex geographical structures. |
geom_geotext | string | This column holds the geographical data as text. It's primarily for representing the geographical data in a human-readable format. |
geom_type | string | This column specifies the type of the geographical data. In our table, it's 'ST_MULTIPOLYGON', representing a shape formed of multiple polygons. |
geom_centroid | string | This column contains the geometric centroid of the multipolygon. It's useful in determining the geographic center of the area. |
geom_center_x | double | This column holds the x-coordinate of the geographical center. Along with 'geom_center_y', it provides the exact location of the center. |
geom_center_y | double | This column holds the y-coordinate of the geographical center. It's used in conjunction with 'geom_center_x' to pinpoint the center of the area. |
gml_id | string | This column contains a unique identifier for each row in the table. |
name | string | This column contains the name of the area in English. |
namn | string | This column contains the name of the area in Swedish. |
nimi | string | This column contains the name of the area in Finnish. |
suuralue | string | This column contains a numeric identifier for the area. |
vuosi | long | This column contains the year pertaining to the data. It helps in understanding the time relevance 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 | 6f128887-a150-4d66-91ac-9f6a6fdf5aff |
Package id | d5a86a8e-8429-4fd5-8b8b-ed852e7568a5 |
Revision id | 61e176c4-789b-477e-af7e-cc6f78975f4d |
State | active |
Table | tilastointialueet_suuralue4500k_2022__table |