Historical Version Records of Norrbotten Dataset Table
Click here for a data sample
The table under discussion is a historical one, sourced from 'Lantmäteriet' (The Land Survey) website in Sweden. Being a historical table, it stores the version history of its base rows, allowing users to track changes over time. Each row in this table is uniquely identified by a combination of the extraction date and the row number from the original data source. If the end date for a row is null, it indicates that the version of the row is the most recent. In addition to the base table columns, this historical table has two additional columns to store the start and end dates of the row versions. The geographical information in this table, originally in the shapefile format, has been transformed into the final geographic format. The shapefile, a non-topological format, stores the geometric location and attribute information of geographic features, which can be points, lines, or polygons. With the rich historical and geographic data, this table can be utilized in a variety of data analytics applications. For instance, it could be used to track changes in land use over time, analyze trends in geographic feature attributes, or study the correlation between time and changes in geographic properties.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column contains the date when the row was extracted from the data source. It is a part of a unique identifier for each row in the 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 represents that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. It is a part of a unique identifier for each row in the version history table. |
|---|
| OBJECTID | long | This column contains the unique identifier for each object in the table. |
|---|
| ID | string | This column contains the unique identifier for each item in the table. |
|---|
| CODE_12 | string | This column contains specific codes associated with the items in the table. |
|---|
| Area_Ha | double | This column contains the area of the items, measured in hectares. |
|---|
| Remark | string | This column contains any additional comments or remarks about the items in the table. |
|---|
| Shape_Leng | double | This column contains the length of the shape of the items. |
|---|
| Shape_Area | double | This column contains the area of the shape of the items. |
|---|
| geom_geojson | string | This column contains the GeoJSON format of the geometric data of the items. |
|---|
| geom_geotext | string | This column contains the Geotext format of the geometric data of the items. |
|---|
| geom_type | string | This column contains the type of the geometric data of the items. |
|---|
| geom_centroid | string | This column contains the centroid of the geometric data of the items. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the center of the geometric data of the items. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the center of the geometric data of the items. |
|---|
