Version History of Regional Units 2015 (1:1 000 000)
The 'table__history' is a comprehensive historical data table within the 'tilastointialueet_seutukunta1000k_2015' dataset. It serves as a version history of its base table, which is essentially a presentation of regions in Finland for the year 2015 at a scale of 1:1 000 000. The table contains several unique columns that are key in data management and geospatial analytics.
The table assigns a unique identifier for each row, based on the row number in the raw data extracted from the data source. This, coupled with the start date of the row, forms a combination that uniquely identifies each row in this version history table. The start and end dates indicate the period during which a particular version of the row was active, with a null end date signifying that the row is the most recent version.
Geographic information is embedded in the columns starting with 'geom_', enabling geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude.
The table also includes additional data such as the names of the regions in different languages, and shape information that could be used in geographic data visualizations or to analyze regional shapes and their properties. The year column indicates the year the data was collected.
This table, sourced from the 'Statistical Centre' (Tilastokeskus) of Finland, could be utilized in various ways in data analytics. For example, it could be used to track changes in geographical data over time, to study the evolution of regions, and to perform spatial-temporal analysis. It could also be harnessed to create visual representations of the geographic data, such as maps indicating regions' shapes and sizes, and to perform geospatial analytics, such as determining the distance between different regions.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column records the date that each row was extracted from the data source, helping to track the version history of the base table rows. |
| _end_date | date | This column records the date when a new version of a row was extracted from the data source. 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 as it appears in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in the history table. |
| geom_geojson | string | This column stores the geographical data associated with each row in GeoJSON format, a widely-used format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains the geometrical data in text format, specifically in the form of MultiPolygons, which are used to represent a region with multiple boundaries. |
| geom_type | string | This column specifies the type of the geometry object associated with each row, in this case, 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the coordinates of the centroid (geometric center) of the geographical region represented by the row. |
| geom_center_x | double | This column contains the x-coordinate (longitude) of the geometric center of the geographical region associated with each row. |
| geom_center_y | double | This column contains the y-coordinate (latitude) of the geometric center of the geographical region associated with each row. |
| gml_id | string | This unique identifier is a string that represents a specific geographical region. |
| name | string | This column contains the English names of the geographical regions represented by each row. |
| namn | string | This column contains the names of the geographical regions in another language, providing multilingual support. |
| nimi | string | This column contains an alternative representation of the names of the geographical regions, providing further multilingual support. |
| seutukunta | string | This column contains a string representation of a specific geographical area. |
| shape_star | double | This column represents a real number associated with the geometrical shape of the region. |
| shape_stle | double | This column represents another real number associated with the geometrical shape of the region. |
| vuosi | double | This column contains a real number representation associated with each row, which might indicate a year or a similar time-related concept. |
No sample for this dataset
Additional Information
| Last updated | November 11, 2024 |
|---|---|
| Created | November 11, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | ab253fca-b74c-4662-8d72-333a0cf6264e |
| Package id | 1996c24f-800a-43a4-a7a8-1aa54c0d8faf |
| Position | 1 |
| Revision id | 3db616e0-abbb-481f-9030-86c4823b84e2 |
| State | active |
| Table | tilastointialueet_seutukunta1000k_2015__table__history |