Statistical Region Mapping: Major Areas 2022
Tables
-
Historical Version Details of Large Areas 2022 (1:1 000 000)TSV
The 'table__history' is a historical accumulation of records, each representing a version of a row from its base table. It belongs to the dataset collection 'tilastointialueet_suuralue1000k_2022'. This history table is unique in the sense that it contains two additional columns to keep track of the version history of each row in the base table, namely the '_start_date' and '_end_date'. The '_start_date' indicates when the row was initially extracted from the data source, while the '_end_date' shows when a newer version of the row was extracted. If the '_end_date' is null, it indicates that the row is the most recent version. The table presents a detailed geographical dataset, specifically the 'Major Areas 2022 (1:1 000 000)' originating from the Finnish Statistics Bureau...
-
Large Areas 2022 (1:1 000 000) - Data Table from Finnish Statistical DatabaseTSV
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...
Column Descriptions
Large Areas 2022 (1:1 000 000) - Data Table from Finnish Statistical Database
Column | Type | Comment |
---|---|---|
_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. |
Historical Version Details of Large Areas 2022 (1:1 000 000)
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in the 'table__history' history table. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value in this column is null, it signifies that the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column for each row in this history table. |
geom_geojson | string | This column stores the geographical data in GeoJSON format, which represents simple geographical features. |
geom_geotext | string | This column contains the geographical data as text, specifically the geometrical representation of the feature. |
geom_type | string | This column specifies the type of the geographical data, which is 'ST_MULTIPOLYGON' indicating the data represents a complex geographical feature. |
geom_centroid | string | This column contains the central point of the geographical feature. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographical feature. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographical feature. |
gml_id | string | This column contains a unique identifier for each row in the base table. |
name | string | This column contains the English name of the geographical region. |
namn | string | This column contains the name of the geographical region in Swedish. |
nimi | string | This column contains the name of the geographical region in Finnish. |
suuralue | string | This column contains the identifier of the larger area that the region belongs to. |
vuosi | long | This column contains the year associated with the data row, indicating the year the data represents. |
Additional Info
Last Updated | November 12, 2024 |
---|---|
Created | November 11, 2024 |