Version History of Geographical Features in Norrbotten Dataset Collection
Click here for a data sample
The table in question is a history table belonging to the 'Norrbotten' dataset collection, sourced from the Lantmäteriet (The Land Survey of Sweden) website. This history table is unique as it contains the version history of its base table rows, which allows for tracking of changes over time. Each row in this table is uniquely identified by a combination of a start date and a row number, providing a precise snapshot of the data at a specific point in time. The table also includes an end date, which signifies when a new version of the row was extracted. If the end date is null, it indicates that the row is the most recent version. The data includes geographical information, which has been transformed from the original shapefile format into a more usable geographic format. The geographic features in the data can be represented by points, lines, or polygons (areas). This table is a crucial tool for understanding trends and patterns, supporting a wide range of data analytics applications. For instance, it can be used to track land usage changes over time, analyze geographical feature modifications, or study population movement patterns in Sweden.
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 the '_row_number', this column helps in uniquely identifying 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 is stored in this column. If the value 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 source is stored in this column. It helps in uniquely identifying each row along with '_start_date'. |
|---|
| OBJECTID | long | This column contains a unique identifier for each object in the table. |
|---|
| ID | string | This column contains unique identifiers for the data entries. |
|---|
| CODE_12 | string | This column contains specific codes associated with the data entries. |
|---|
| Area_Ha | double | This column contains the measurement of the area in hectares. |
|---|
| Remark | string | Any additional remarks or notes associated with the data entries are stored in this column. |
|---|
| Shape_Leng | double | This column contains the length of the shape of the data entries. |
|---|
| Shape_Area | double | The area of the shape of the data entries is stored in this column. |
|---|
| geom_geojson | string | This column contains the geometrical representation of the data entries in GeoJSON format. |
|---|
| geom_geotext | string | The geometrical representation of the data entries in text format is stored in this column. |
|---|
| geom_type | string | This column specifies the type of geometry associated with the data entries. |
|---|
| geom_centroid | string | The centroid or geometric center of a plane figure or shape is stored in this column. |
|---|
| geom_center_x | double | This column contains the X coordinate of the geometric center of a data entry. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the geometric center of a data entry. |
|---|
