Version History of Geographic Features in Vastmanland Dataset
Click here for a data sample
The table in question is a historical record of geographic features, sourced from 'Lantmäteriet' (The Land Survey) in Sweden. As a history table, it provides a version history of its base table rows, capturing the evolution of data over time. This table is unique in that it consists of two additional columns compared to its base table, which represent the time frame during which each row was valid in the data source. A row in this table represents a geographic feature, with the date when it was first recorded and the date when a new version of the feature was recorded, if applicable. If the latter date is not available, it indicates that the feature is the most recent version. Each row in the table is uniquely identified by a combination of the date when it was first recorded and its row number. The data, originally in shapefile format, has been transformed into a final geographic format, capturing the geometric location and attribute information of geographic features, including points, lines, or polygons. Given the nature of the data, it could prove invaluable in a variety of data analytics applications. For instance, it could be used in environmental studies to track land use changes over time, in urban planning to understand how infrastructure has evolved, or in disaster management to analyze the impact of natural disasters on geography.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The date when the row was extracted from the data source. Together with '_row_number', this forms a unique identifier for 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 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. This, in combination with '_start_date', forms a unique identifier for each row in this version history table. |
|---|
| OBJECTID | long | A unique identifier for each object in the table. |
|---|
| ID | string | An identifier for each element in the table. |
|---|
| CODE_12 | string | A code that represents specific metadata associated with the row. |
|---|
| Area_Ha | double | The area, in hectares, represented by the row. |
|---|
| Remark | string | Additional notes or comments related to the row. |
|---|
| Shape_Leng | double | The length of the shape associated with the row. |
|---|
| Shape_Area | double | The area of the shape associated with the row. |
|---|
| geom_geojson | string | The geographic coordinates of the row's data in GeoJSON format. |
|---|
| geom_geotext | string | The geographic coordinates of the row's data in plain text format. |
|---|
| geom_type | string | The type of the geographic object associated with the row (e.g., point, line, polygon). |
|---|
| geom_centroid | string | The central point of the geographic object associated with the row. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geographic object associated with the row. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geographic object associated with the row. |
|---|
