Regional Statistics Collection Finland 2015
Tables
-
Historical Version Records of 'Regions 2015 (1:1 000 000)' TableTSV
The 'table__history' is a valuable source of information, providing a historical record of its corresponding base table. This history table originates from the 'Tilastokeskus' (Statistics Finland) website and forms part of the 'tilastointialueet_maakunta1000k_2015' dataset collection. The table offers a rich combination of data, including unique identifiers, date details, geographical information, and more. This table specifically focuses on the regions of Finland as of 2015, as described in the base table contents. Each row in this history table is uniquely identified by a combination of a start date and a row number. These dates denote when the row was extracted from the data source and when a new version was extracted, providing a timeline of changes. If the end date is null, this...
-
Regions of Finland 2015 (1:1 000 000) - Data TableTSV
The table at hand is part of a dataset collection that encapsulates a wealth of data related to statistical areas in Finland, specifically pertaining to the provinces as of 2015. This table offers an extensive and meticulously organized set of data that captures a variety of aspects surrounding these provinces. The table presents a unique blend of alphanumeric and geospatial data. Alphanumeric data includes information such as the provinces' names in different languages and the year of the data. The geospatial data, on the other hand, is captured through a series of columns that house geographic coordinates and related information. This geospatial data is particularly instrumental for geographic information system (GIS) analytics and provides valuable insights for geospatial data...
Column Descriptions
Regions of Finland 2015 (1:1 000 000) - Data Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It is one of the unique identifiers of each row in combination with the '_row_number'. |
_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 forms a unique identifier for each row in combination with the '_extract_date'. |
geom_geojson | string | This column contains the geometry data of the region in GeoJSON format, a common format for encoding geographic data structures. |
geom_geotext | string | This column contains the geometry data of the region in text format. |
geom_type | string | This column specifies the type of the geo-spatial data structure, which in this case is a multipolygon. |
geom_centroid | string | This column stores the geographical point that represents the centroid, or geometric center, of the region. |
geom_center_x | double | This column provides the x-coordinate of the center of the region's geometry. |
geom_center_y | double | This column provides the y-coordinate of the center of the region's geometry. |
gml_id | string | This column contains a unique identifier for each region. |
maakunta | string | This column contains the code of the region in the country. |
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. |
shape_star | double | This column contains the area of the region. |
shape_stle | double | This column contains the length of the boundary of the region. |
vuosi | double | This column indicates the year of the data. |
Historical Version Records of 'Regions 2015 (1:1 000 000)' Table
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a combination with the '_row_number' column to uniquely identify each row in the 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 is null, it means 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 combination with the '_start_date' column for each row in the history table. |
geom_geojson | string | This column contains the geographical data of the region in GeoJSON format, a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains the geographical data of the region in text format. |
geom_type | string | This column identifies the type of the geographical data. |
geom_centroid | string | This column contains the central point of the geographical data. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographical data. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographical data. |
gml_id | string | This column contains the unique identification code for the region. |
maakunta | string | This column contains a unique identification code for the region. |
name | string | This column contains the name of the region in the primary language. |
namn | string | This column contains the name of the region in another language. |
nimi | string | This column contains the name of the region in another language. |
shape_star | double | This column contains a real number representing a specific geographical attribute of the region. |
shape_stle | double | This column contains a real number representing a specific geographical attribute of the region. |
vuosi | double | This column contains the year associated with the data row. |
Additional Info
Last Updated | November 11, 2024 |
---|---|
Created | November 11, 2024 |