Large Areas 2022 (Scale 1:4,500,000) - Dataset Table

To download the data set, please sign up or log in

Click here for a data sample

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_datedateThis column contains the date when the data on the row was extracted. It helps in understanding the data collection period.
_row_numberlongThis column contains the row number in the data extracted from the source. Combined with '_extract_date', it uniquely identifies each row.
geom_geojsonstringThis column contains the geographical data in GeoJSON format. It helps in representing and visualizing complex geographical structures.
geom_geotextstringThis column holds the geographical data as text. It's primarily for representing the geographical data in a human-readable format.
geom_typestringThis column specifies the type of the geographical data. In our table, it's 'ST_MULTIPOLYGON', representing a shape formed of multiple polygons.
geom_centroidstringThis column contains the geometric centroid of the multipolygon. It's useful in determining the geographic center of the area.
geom_center_xdoubleThis column holds the x-coordinate of the geographical center. Along with 'geom_center_y', it provides the exact location of the center.
geom_center_ydoubleThis 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_idstringThis column contains a unique identifier for each row in the table.
namestringThis column contains the name of the area in English.
namnstringThis column contains the name of the area in Swedish.
nimistringThis column contains the name of the area in Finnish.
suuraluestringThis column contains a numeric identifier for the area.
vuosilongThis 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
Countryfi
Databasefi_tilastokeskus
Extract date2024-11-11
Id6f128887-a150-4d66-91ac-9f6a6fdf5aff
Package idd5a86a8e-8429-4fd5-8b8b-ed852e7568a5
Revision id61e176c4-789b-477e-af7e-cc6f78975f4d
Stateactive
Tabletilastointialueet_suuralue4500k_2022__table