Version History of Base Table Rows in the Norrbotten Dataset Collection
Click here for a data sample
The table is part of a dataset collection from the Swedish Mapping, Cadastral and Land Registration Authority (Lantmäteriet) in Sweden. As a history table, it captures the version history of its base table rows, represented by unique combinations of start dates and row numbers. This allows for tracking changes in the data over time, as each row in the table contains a start date marking its extraction from the data source, and an end date marking when a new version of the row was extracted. Rows with null end dates indicate the most recent versions. The table contains geographic data in a transformed format from the original shapefile, which is a popular format for storing geographic location and attribute information. The geographic features can be represented as points, lines, or polygons (areas). The data within this table could be used in a variety of data analytics applications. For example, the area data could be used in spatial analyses to study changes in land use over time. The geographic data could also be used in mapping applications to visualize these changes spatially. Furthermore, the history aspect of the table allows for trend analysis over time, which can be valuable in predictive modeling and forecasting.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row was extracted from the data source. This, in combination with '_row_number', uniquely identifies each row in this version history table. |
|---|
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value of this column is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | The number of the row in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table. |
|---|
| OBJECTID | long | A unique identifier for each object in the table. |
|---|
| ID | string | An ID tag for each entry in the table, starting with 'SE_' prefix, indicating that the data originates from Sweden. |
|---|
| CODE_12 | string | A code indicating the specific type or category of data each row represents. |
|---|
| Area_Ha | double | The area of the region represented by the row, measured in hectares. |
|---|
| Remark | string | Additional comments or information about the data in the row. This column is often left blank, indicated by 'None'. |
|---|
| Shape_Leng | double | The length of the shape that represents the geographical area in the row. This field might be left blank in some cases. |
|---|
| Shape_Area | double | The area of the shape that represents the geographical area in the row. |
|---|
| geom_geojson | string | The geographical data of the area in the row, formatted as a GeoJSON polygon. |
|---|
| geom_geotext | string | The geographical data of the area in the row, formatted as text in the form of a POLYGON object. |
|---|
| geom_type | string | The type of geometric data used to represent the area in the row, typically a polygon. |
|---|
| geom_centroid | string | The geographical point that represents the centroid, or geometric center, of the area in the row. |
|---|
| geom_center_x | double | The x-coordinate of the geometric center of the area in the row. |
|---|
| geom_center_y | double | The y-coordinate of the geometric center of the area in the row. |
|---|
