2016 Regional Statistical Areas Collection
Tables
-
Historical Version Records for 'Regional Units 2016 (1:1 000 000)'TSV
The 'table__history' is a part of a larger dataset collection that houses related data tables. This particular table is a history table, storing the version history of the base table rows, adding a unique aspect to its structure. The table is distinguished by two additional columns: '_start_date' and '_end_date', which respectively indicate the date of row extraction from the data source and the date when a new version of the row was extracted. If the '_end_date' value is null, this signifies that the row is the most recent version. The table's contents are representative of the 'Seutukunnat 2016 (1:1 000 000)' base table, which could be loosely translated to 'Regions 2016 (1:1 000 000)'. Each row in the table is uniquely identified by a combination of the '_start_date' and...
-
Regional Units 2016 (Scale 1:1 000 000) - Dataset TableTSV
The table under consideration contains information related to regional units in Finland from the year 2016, as sourced from the Finnish statistical authority, 'Tilastokeskus'. This data is part of a wider dataset collection, which potentially includes other related tables. Each row in the table presents data for a specific regional unit, with the data extracted on a specific date. The data fields include various geographic coordinates, names of regions in different languages, a unique identifier, and a year indicator. The geographic coordinates presented in the table use the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. These coordinates could be highly valuable for geospatial data analytics, for example, for creating detailed maps...
Column Descriptions
Regional Units 2016 (Scale 1:1 000 000) - Dataset 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 special columns that, in combination with '_row_number', uniquely identifies each row. |
_row_number | long | This column contains the row number in the data extracted from the source. It is one of the special columns that, in combination with '_extract_date', uniquely identifies each row. |
geom_geojson | string | This column contains geographical data in the format of GeoJSON, a popular open standard for representing geographical features with JSON. |
geom_geotext | string | This column stores geographical data as text in the Multipolygon format, which describes a shape composed of multiple polygons. |
geom_type | string | This column specifies the type of the geographical data stored in the table. In this case, it is a MultiPolygon type. |
geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of the area represented by the geographical data. |
geom_center_x | double | This column represents the x-coordinate of the center of the geographical area. |
geom_center_y | double | This column represents the y-coordinate of the center of the geographical area. |
gml_id | string | This column contains a unique identifier for the geographical data, which includes the year of data collection. |
name | string | This column contains the name of the area in English. |
namn | string | This column contains the name of the area in Swedish. |
nimi | string | This column contains the name of the area in Finnish. |
seutukunta | string | This column contains a unique code for the region. |
vuosi | double | This column represents the year of data collection. |
Historical Version Records for 'Regional Units 2016 (1:1 000 000)'
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was initially extracted from the data source. |
_end_date | date | This column holds 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 as extracted from the source. Together with '_start_date', it uniquely identifies each row in this version history table. |
geom_geojson | string | This column contains geometric data in GeoJSON format, typically used to represent spatial data. |
geom_geotext | string | This column contains geometric data in text format, typically used to represent spatial data. |
geom_type | string | This column specifies the type of the geometric data, in this case, multi-polygon. |
geom_centroid | string | This column describes the geometric center or centroid of the spatial data. |
geom_center_x | double | This column contains the x-coordinate of the geometric center of the spatial data. |
geom_center_y | double | This column contains the y-coordinate of the geometric center of the spatial data. |
gml_id | string | This string type column contains unique identifiers for each row. |
name | string | This column contains the English names of regions. |
namn | string | This column contains the names of regions in Swedish. |
nimi | string | This column contains the names of regions in Finnish. |
seutukunta | string | This string type column contains codes representing different regions. |
vuosi | double | This real type column indicates the year associated with the data entry. |
Additional Info
Last Updated | November 12, 2024 |
---|---|
Created | November 11, 2024 |