Large Areas Projection for 2023 (Scale 1:1,000,000)
Click here for a data sample
The table, part of the 'tilastointialueet_suuralue1000k_2023' dataset, is a comprehensive compilation of data relating to the 'Major Areas 2023'. This dataset is sourced from Finland's 'Tilastokeskus' (Statistics Finland) website. The table is organized into several columns, each providing unique and crucial information. For instance, there are columns that provide geographic information such as multipolygon data, centroid points and x,y coordinates, which are invaluable for geospatial data analytics. These geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The table also includes identifiers such as 'name', 'namn', and 'nimi', which provide the names of the major areas in different languages. Additionally, the table contains a unique identifier 'gml_id', which is specific to the table. The 'vuosi' column indicates the year of the data, which in this case is 2023. Two unique columns in the table, '_extract_date' and '_row_number', serve a special purpose. '_extract_date' specifies the date when the data was extracted from the source and '_row_number' gives the row number in the extracted data. Together, these two columns uniquely identify each row in the table. This table could serve various data analytics purposes. For instance, using the geographic data, one could map out the major areas and analyze spatial patterns or trends. The '_extract_date' could be beneficial for tracking changes over time, and the multilingual naming columns could be useful for international data analytics.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This special column specifies the date when the data on each row of the table was extracted from the source. The format of the date is YYYY-MM-DD. |
|---|
| _row_number | long | This special column represents the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table. |
|---|
| geom_geojson | string | This column contains the geometric data of the region in GeoJSON format, a type of open standard format designed for representing simple geographical features. |
|---|
| geom_geotext | string | This column holds the geometric data of the region in a textual form. |
|---|
| geom_type | string | This column describes the type of the geometric data, for example, 'ST_MULTIPOLYGON', which represents a multi-polygonal area. |
|---|
| geom_centroid | string | This column contains the geometric center (centroid) of the region, represented as a point in the form of 'POINT (x y)'. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the geometric center of the region. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the geometric center of the region. |
|---|
| gml_id | string | This column contains a unique identifier for each row, usually in the format 'suuralue1000k_<year>.<region_number>'. |
|---|
| name | string | This column contains the name of the region in English. |
|---|
| namn | string | This column contains the name of the region in Swedish. |
|---|
| nimi | string | This column contains the name of the region in Finnish. |
|---|
| suuralue | string | This column contains the code for the region. |
|---|
| vuosi | long | This column contains the year related to the data, represented as an integer. |
|---|
