Version History of Large Areas (1:4 500 000)
Click here for a data sample
The table 'table__history' is a historical data table that forms part of a larger dataset collection. This table captures the version history of its base table rows in a detailed and organized manner. It includes data on large areas (1:4 500 000) and has been sourced from 'Tilastokeskus' (Statistics Finland), a reputable data provider in Finland. The data contained in this table is distinguished by the dates of extraction and updates from the source, as well as the unique row numbers, ensuring each row in the version history table can be accurately identified and tracked. The table also contains geographic data, allowing for geospatial analytics. This geographic information is presented using the WGS 84 coordinate reference system, with the axis order being longitude first, followed by latitude. Furthermore, the table includes various types of geographic data such as geotext and geojson, which can be used to generate detailed and interactive maps. The table also provides regional names in different languages, which can be crucial in international studies or multilingual projects. The history table can be leveraged in data analytics in numerous ways. For instance, it can be used to track changes in geographic data over time, analyze trends in regional development, or serve as a reference for multilingual data mapping. It could also be used in combination with other data to provide comprehensive regional analysis. For example, it could be combined with demographic or economic data to analyze the relationship between geographical changes and socio-economic factors. The possibilities for data analytics using this table are extensive and can provide valuable insights for various research and analytics projects.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique identifier for each row in the version history table in combination with the '_row_number' column. |
_end_date | date | This column contains the date when a new version of the row was extracted. 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 source. It forms a unique identifier for each row in the version history table in combination with the '_start_date' column. |
geom_geojson | string | This column contains the geometry of the area in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the area in text format. |
geom_type | string | This column specifies the type of the geometry data. |
geom_centroid | string | This column contains the centroid of the geographical area. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographical area. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographical area. |
gml_id | string | This column contains an ID that is unique for each row. |
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. |
suuralue | string | This column contains an identifier for the major region the area belongs to. |
vuosi | long | This column contains the year of the data. |