Version History of Base Table Rows in Vasternorrland Dataset Collection
Click here for a data sample
This history table is a part of a dataset collection that contains intricate data about historical versions of its base table rows. The table is unique in its ability to track changes over time, as it includes two additional columns that record the start and end dates for when a row was extracted from the data source. A unique identifier for each row in this table is formed by the combination of the start date and a row number. If the end date column is null, it indicates that the row is the current version. The table also contains geographical information, which was originally in a simple, nontopological shapefile format and has been converted into a final geographic format. This geographic data could be represented by points, lines, or polygons. This valuable table has been sourced from Lantmäteriet, a website based in Sweden. In data analytics, this table could be used in several ways. For example, one could track the changes of specific rows over time by studying the start and end dates. The geographic data could be utilized to observe spatial trends or to visualize data changes on a map. Moreover, the unique identifier could be used to link this table with other tables in the data collection, creating a more comprehensive data analysis.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table. |
|---|
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it signifies 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 combination with '_start_date' to identify each row in this version history table. |
|---|
| OBJECTID | long | This column contains the object identifier for each row. |
|---|
| ID | string | This column contains the unique identifier for each row. |
|---|
| CODE_12 | string | This column contains specific code associated with each row. |
|---|
| Area_Ha | double | This column represents the area measurement in hectares. |
|---|
| Remark | string | This column contains any additional remarks or notes related to the row. |
|---|
| Shape_Leng | double | This column contains the length of the shape. |
|---|
| Shape_Area | double | This column contains the area of the shape. |
|---|
| 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 plain text format. |
|---|
| geom_type | string | This column indicates the type of the geometry. |
|---|
| geom_centroid | string | This column contains the centroid of the geometry. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry. |
|---|
