Large Areas 2021 (Scale 1:4 500 000) - Data Table
Click here for a data sample
The table forms part of a dataset collection concerning larger geographical areas in Finland for the year 2021, sourced from the website of the Finnish Statistical Central Office (Tilastokeskus). The table contains various columns providing unique and rich data for each row. Two special columns, '_extract_date' and '_row_number', help track the date of data extraction and the unique row number respectively. These two columns can be combined to uniquely identify each row. The table also includes geographic information, useful for geospatial data analytics, with coordinates presented using the WGS 84 coordinate reference system, where longitude is presented first, followed by latitude. The table further provides a comprehensive geographical description through multiple columns, including a 'geom_type' column indicating the type of the geographical feature, and 'geom_center_x' and 'geom_center_y' columns that provide the central coordinates of each area. The table also provides different naming conventions for each area, with 'name', 'namn', and 'nimi' columns representing the area names in English, Swedish, and Finnish, respectively, offering potential for multilingual data analysis. The data in this table could be used in various ways, including tracking the geographical distribution of various phenomena over time, performing multilingual analysis of area names, or conducting detailed geospatial data analytics.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column holds the date when the data row was extracted from the source. |
|---|
| _row_number | long | This column contains a unique identifier for each row, which is the row number in the data that was extracted from the source on the extract date. Together with the '_extract_date', this column uniquely identifies each row. |
|---|
| geom_geojson | string | This column holds the geographical data in GeoJSON format, likely representing the boundaries of a particular area. |
|---|
| geom_geotext | string | This column contains the geographical data in text format, likely a representation of the geographical boundaries of an area. |
|---|
| geom_type | string | This column indicates the type of the geometrical data represented in the 'geom_geojson' and 'geom_geotext' columns, for example, a MultiPolygon. |
|---|
| geom_centroid | string | This column contains the coordinates of the centroid of the geographical area represented by the geom_geojson and geom_geotext columns. |
|---|
| geom_center_x | double | This column holds the x-coordinate of the geographical center of the area represented by the geometrical data. |
|---|
| geom_center_y | double | This column holds the y-coordinate of the geographical center of the area represented by the geometrical data. |
|---|
| gml_id | string | This column likely contains a unique identifier for the geographical area represented by the geom_geojson and geom_geotext columns, possibly a combination of the dataset collection name and a unique number. |
|---|
| name | string | This column contains the English name of the geographical area represented by the geometrical data. |
|---|
| namn | string | This column contains the name of the geographical area in another language, possibly Swedish or Finnish. |
|---|
| nimi | string | This column contains the name of the geographical area in another language, likely Finnish. |
|---|
| suuralue | string | This column contains an identifier for the large area that the geographical area represented in the row is a part of. |
|---|
| vuosi | long | This column holds the year that the data row pertains to. |
|---|
