Version History of Base Table Rows in Stockholm Dataset Collection

The table is a historical data collection from the 'Lantmäteriet' (The Swedish Land Survey) in Sweden. The table is part of a larger data collection focused on geographic and environmental data. It contains historical versions of rows from its base table, essentially providing a version history for each row. Each row in this table is uniquely identified by a combination of the date of data extraction and the row number from the original data source. The table has additional date columns representing the start and end dates of each version of a row. If the end date is null, it indicates that the version of the row is the most recent.

The table contains various columns with geographic and attribute information of geographic features. Some of these features include elements like the area in hectares, specific codes, and identification numbers. Unique identification codes are attached to each geographical feature, represented in this table as 'ID'.

The geographic information is originally in the shapefile format which is a commonly used geospatial vector data format. In the table, this information has been transformed into a final geographic format. The geographic features in the dataset can be represented by points, lines, or polygons (areas). For instance, the shape of a geographic feature is stored as a polygon in columns such as 'geom_geojson' and 'geom_geotext'.

The data in this table could be utilized in various data analytics applications. For example, it could be used to analyze land use changes over time by tracking the changes in the 'Area_Ha' column. The geographic data could be used in spatial analysis, such as determining the proximity of certain features to each other or calculating the area of particular regions. The historical data allows for time series analysis, enabling the tracking of geographical changes over time.