Large Areas 2022 (1:1 000 000) - Data Table from Finnish Statistical Database
The table, sourced from the Finnish website 'Tilastokeskus' (Statistics Finland), contains comprehensive data about the 'Large Areas of 2022' at a scale of 1:1 000 000. The data is organized into several columns, each with a unique purpose.
Two special columns, '_extract_date' and '_row_number', provide context about when the data was extracted and the row number within the data source, respectively. Each row is uniquely identified by the combination of these two columns.
The table also includes a set of columns beginning with 'geom_', which contain geospatial data that can be utilized for geospatial data analytics. This data is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
In terms of content, the table includes the names of the large areas in multiple languages, providing a multinational perspective. Additionally, the year of reference is also included for further context.
Such a table could be utilized in several ways within data analytics. For example, the geospatial data could be used to create detailed maps of these large areas, or to analyze trends in the data over time using the extract date and year of reference. The multinational names could also be used to tailor visualizations or analyses to different language speakers.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the data source. It helps to track when the data was last updated. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It uniquely identifies each row. |
| geom_geojson | string | This column contains the geojson representation of the geographical area. It is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the text representation of the geographical area. It is a format for encoding complex geometric structures. |
| geom_type | string | This column defines the type of the geometric object. For example, in this table, the type is 'ST_MULTIPOLYGON' indicating that the object is a multipolygon. |
| geom_centroid | string | This column contains the geometric center or 'centroid' of the geographical area. It is typically represented as a point. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the geographical area. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the geographical area. |
| gml_id | string | This column contains an identifier for the geographical markup language (GML). It is a standard used for expressing geographical features. |
| name | string | This column contains the name of the geographical area in English. |
| namn | string | This column contains the name of the geographical area in Swedish. |
| nimi | string | This column contains the name of the geographical area in Finnish. |
| suuralue | string | This column contains a numerical identifier for the large area the geographical area belongs to. |
| vuosi | long | This column contains the year pertaining to the data in the row. It is an integer value. |
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 | 40deca67-6e27-4091-95b2-074f9c1e6bcc |
| Package id | 7b41b58d-e726-4a24-a604-e00cd0a60fb3 |
| Revision id | 594ad953-9230-4c1b-86dc-cb3774082821 |
| State | active |
| Table | tilastointialueet_suuralue1000k_2022__table |