Statistics Area Major Region 2021 Dataset Collection
Tables
-
Large Areas 2021 (Scale 1:4 500 000) - Data TableTSV
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...
-
Version History of Large Areas 2021 (1:4 500 000)TSV
The 'table__history' is an integral part of a larger collection of tables, specifically the 'tilastointialueet_suuralue4500k_2021'. It is a historical table signifying the version history of its base table rows. This is a rich and diverse table containing a wealth of information, including geographical data, that could prove beneficial in the field of geospatial data analytics. The table's content primarily revolves around 'Major Areas 2021' at a scale of 1:4 500 000. It includes geographical identifiers, names in multiple languages, and the year of data collection. This information is meticulously organized into several columns, each containing specific types of data. For instance, there are columns that contain the dates signifying when a row was added ('_start_date') and when it was...
Column Descriptions
Large Areas 2021 (Scale 1:4 500 000) - Data Table
| Column | Type | Comment |
|---|---|---|
| _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. |
Version History of Large Areas 2021 (1:4 500 000)
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The _start_date column contains the date when the row was extracted from the data source. This, in combination with the _row_number, makes each row in the version history table uniquely identifiable. |
| _end_date | date | The _end_date column contains the date when a new version of the row was extracted from the data source. If this value is null, it signifies that the row is the most recent version. |
| _row_number | long | The _row_number column contains the number of the row in the raw data extracted from the source. It helps to uniquely identify each row in combination with the _start_date. |
| geom_geojson | string | The geom_geojson column contains geographical coordinates in GeoJSON format which represent the geometry of the area. |
| geom_geotext | string | The geom_geotext column holds the geographical data in text format. |
| geom_type | string | The geom_type column specifies the type of the geographical data. It is typically a type of shape, such as 'ST_MULTIPOLYGON', that indicates the data is a multipolygon shape. |
| geom_centroid | string | The geom_centroid column contains the geographical coordinates of the centroid or geometric center of the area. |
| geom_center_x | double | The geom_center_x column contains the x-coordinate (longitude) of the geometric center of the area. |
| geom_center_y | double | The geom_center_y column contains the y-coordinate (latitude) of the geometric center of the area. |
| gml_id | string | The gml_id column contains a unique identifier for each area. |
| name | string | The name column contains the English name of the area. |
| namn | string | The namn column contains the name of the area in Swedish. |
| nimi | string | The nimi column contains the name of the area in Finnish. |
| suuralue | string | The suuralue column contains a numerical identifier for each large area. |
| vuosi | long | The vuosi column contains the year to which the data pertains. |
Additional Info
| Last Updated | November 12, 2024 |
|---|---|
| Created | November 11, 2024 |