Historical Version Records of Land Classification in Jämtland Dataset Collection
Click here for a data sample
The table under discussion is a historical record table, hosted as part of a dataset collection. Originating from the Swedish website 'Lantmäteriet' (National Land Survey), it meticulously maintains the version history of its base table. Each row in this table is uniquely identifiable by a combination of its start date and row number, offering an insight into the chronological order of data extraction from the source. The table also records the end date for each row's version, which corresponds to when a new version of that row was extracted. If an end date is not present, it implies that the row represents the most recent version. Furthermore, this table incorporates two additional columns compared to its base table, namely the start and end dates. The geographical information in the table, originally in shapefile format, a popular format for storing geometric location and attribute information of geographic features, has been transformed into the final geographic format. The table could be of great value in data analytics, for instance, tracking the evolution of geographic features over time, analysing patterns in the version history of data rows, or even studying the frequency and nature of updates to the database.
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 part of a unique identifier for each version of a row in this history table when combined with the '_row_number' column. |
|---|
| _end_date | date | This column contains the date when a new version of the same 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 extracted from the raw data source. Combined with the '_start_date' column, it serves as a unique identifier for each row version in this history table. |
|---|
| OBJECTID | long | This column contains the unique object identifier for each row in the table. |
|---|
| ID | string | This column contains an additional unique identifier for each row in the table. |
|---|
| CODE_12 | string | This column contains a unique code associated with each row. |
|---|
| Area_Ha | double | This column contains the area in hectares of the geographic object represented in the row. |
|---|
| Remark | string | This column contains any remarks or additional notes associated with the row. |
|---|
| Shape_Leng | double | This column contains the length of the geographic shape associated with the row. |
|---|
| Shape_Area | double | This column contains the area of the geographic shape associated with the row. |
|---|
| geom_geojson | string | This column contains the GeoJSON representation of the geography of the object associated with the row. GeoJSON is a format for encoding geographic data structures. |
|---|
| geom_geotext | string | This column contains a textual representation of the geography of the object associated with the row. |
|---|
| geom_type | string | This column indicates the type of geographic object represented in the row, such as point, line, or polygon. |
|---|
| geom_centroid | string | This column contains the centroid of the geographical object associated with the row. The centroid is the geometric center of a shape. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical object associated with the row. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical object associated with the row. |
|---|
