Version History of Base Table Rows in Norrbotten Collection
Click here for a data sample
This table is a part of a dataset collection from the website of Lantmäteriet (The Land Survey) in Sweden. The table provides a historical record of geographic features for each row in the base table. Each row in the history table is uniquely identified by a combination of the date the row was extracted from the data source and the row number. The history table includes two additional columns not found in the base table which denote the start and end dates of data extraction. If the end date is null, it indicates that the row is the most recent version. The geographic information in this table, originally in shapefile format, has been transformed into the final geographic format. This format can represent geographic features by points, lines, or polygons (areas). The table also includes attributes such as area in hectares, identification codes, and remarks. Examples of how this data could be used in analytics include tracking changes in land use over time, identifying trends in geographic features, and analyzing spatial patterns.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column holds the date when the data row was extracted from the source. It is part of the combination that uniquely identifies each row in this version history table. |
|---|
| _end_date | date | This column contains the date when a new version of the data row was extracted from the 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 in the raw data extracted from the source. Combined with '_start_date', it uniquely identifies each row in this version history table. |
|---|
| OBJECTID | long | Unique identifier for each object in the dataset. |
|---|
| ID | string | This is a unique identifier prefixed with 'SE_' representing a specific data observation. |
|---|
| CODE_12 | string | This column contains a code representing a specific category or class in the dataset. |
|---|
| Area_Ha | double | This column represents the area of the geographical feature in hectares. |
|---|
| Remark | string | This column is reserved for any additional comments or annotations for each data row. |
|---|
| Shape_Leng | double | This column would normally contain the length of the geometric shape representing the geographic feature, but it appears to be null in this dataset. |
|---|
| Shape_Area | double | This column contains the area of the geometric shape representing the geographical feature. |
|---|
| geom_geojson | string | This column contains the geometric representation of the geographical feature in GeoJSON format. |
|---|
| geom_geotext | string | This column contains the geometric representation of the geographical feature as a text string. |
|---|
| geom_type | string | This column specifies the type of the geometric representation of the geographical feature. |
|---|
| geom_centroid | string | This column contains the geometric center or 'centroid' of the geographical feature as a point. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the geographical feature. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the geographical feature. |
|---|
