Version History of Provinces 2018 (1:1 000 000) Dataset
Click here for a data sample
The 'table__history' belongs to the dataset named 'tilastointialueet_maakunta1000k_2018' and it serves as a version history of its base table rows. The table's contents are sourced from the 'Tilastokeskus' (Statistics Finland) website. The table contains data pertaining to regions in Finland as per the 2018 census, which is indicated in the 'vuosi' column. Each row in the table represents a specific version of the data as indicated by the 'row_number' column, and the '_start_date' and '_end_date' columns denote the duration for which that particular version was valid. A null value in the '_end_date' column signifies that the version is the most recent. The geographical data contained in the 'geom' prefixed columns is particularly useful for geospatial data analytics. These columns hold geographic information like the type of the geographic data, the geojson and geotext representations of the geographic data, and the x and y coordinates of the geographic center of the regions. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. The 'maakunta', 'name', 'namn', and 'nimi' columns hold various identifiers for the regions. The data could be used for analyzing regional trends and changes over time, carrying out geospatial analysis of the regions, or for tracking the version history of the data.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source in the format YYYY-MM-DD. It forms a unique identifier for each row in combination with the '_row_number' column. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source in the format YYYY-MM-DD. If the value is null, it indicates 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 for each row in combination with the '_start_date' column. |
|---|
| geom_geojson | string | This column contains geometric data in GeoJSON format, a common format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains geometric data as text. The format used is 'MULTIPOLYGON', encapsulating multiple polygonal shapes. |
|---|
| geom_type | string | This column indicates the type of geometric data represented. In this case, it is 'ST_MULTIPOLYGON', a collection of polygons. |
|---|
| geom_centroid | string | This column contains the coordinates of the centroid of the geometric shape represented in the 'geom' column. |
|---|
| geom_center_x | double | This column contains the X coordinate of the center of the geometric shape. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the center of the geometric shape. |
|---|
| gml_id | string | This is an identifier column. It contains unique identifiers for each row in the table. |
|---|
| maakunta | string | This column contains string identifiers for the province. |
|---|
| name | string | This column contains the English names of the provinces. |
|---|
| namn | string | This column contains the Swedish names of the provinces. |
|---|
| nimi | string | This column contains the Finnish names of the provinces. |
|---|
| vuosi | long | This column contains the year that the data refers to. |
|---|
