History of Version Changes for Scan Date Records in National Elevation Model of Sweden
The 'skanningsdatum__history' table is a historical record of geographic data, which has been sourced from the Swedish mapping, cadastral and land registration authority, Lantmäteriet. Bearing a close relationship to the raw data, this table is in essence a version history record of the base table rows. Each row in this table is given a unique identifier, which is a combination of the row number and the date when the row was extracted from the source. This allows for tracking changes in the data over time. If a row has a null end date, it indicates that it is the most recent version.
The table includes geographic information, such as coordinates and geometry, which has been transformed from the original shapefile format. The geographic features could be points, lines or polygons, representing various geographical entities. There is also a date column providing information about the date of the data.
The data in this table could be used in various data analytics applications. For example, it could be utilized to study historical changes in geographical features over time. It could also be used in predictive modeling to forecast future changes based on historical trends. Additionally, the data could be incorporated in GIS applications for visualizing geographic patterns and changes. Furthermore, it could be used to validate or enhance other data sources by cross-referencing geographic details.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source, indicating the start of the version history for that particular row. |
_end_date | date | This column contains the date when a new version of the row was extracted from the data source, marking the end of the version history for a particular row. If the value of this column is null, it suggests 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 data source. In combination with the _start_date, it uniquely identifies each row in this version history table. |
DATUM | string | This column contains date values related to the data in the row, likely indicating when a particular event or change occurred in the data. |
geom_geojson | string | This column contains the geometric data of the row in GeoJSON format, a popular open standard format designed for representing simple geographical features, along with their non-spatial attributes. |
geom_geotext | string | This column contains the geometric data of the row in text format, providing a human-readable representation of the geometric data. |
geom_type | string | This column identifies the type of the geometric data present in the row, such as point, line, polygon etc. |
geom_centroid | string | This column contains the centroid of the geometric data, which is the central point of the geometric shape. It is represented as a point. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape. This point is not necessarily the centroid, but represents the center along the x-axis. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape. This point is not necessarily the centroid, but represents the center along the y-axis. |
No sample for this dataset
Additional Information
Last updated | September 4, 2024 |
---|---|
Created | September 4, 2024 |
License | No License Provided |
Geographic coverage | |
Geographic granularity | |
Temporal coverage from | |
Temporal coverage to | |
Temporal coverage to | |
Adapter | shapefile |
Country | se |
Database | se_lantmateriet |
Extract date | 2024-09-04 |
Id | 1be58e76-9a2d-48cf-bd87-cc6768896c14 |
Package id | ce984856-df42-4d7d-8a99-b006b95b7afa |
Position | 1 |
Revision id | 9233f035-23a9-42b0-b82f-d05327d07364 |
State | active |
Table | nh_skanningsdatum_sweref_99_tm_zip__skanningsdatum__history |