Version History of Land Contours Data in Sweden's 20 Million Scale Map
Click here for a data sample
The 'land20l__history' table is a historical record of geographical data pertaining to land contours such as coastlines and national boundaries in Sweden. This table is maintained by 'Lantmäteriet' (The Swedish Land Survey) in Sweden. The table holds significant details including the dates when rows of data were extracted and updated, providing a version history of the data. It also includes a unique identifier for each row, ensuring traceability of data. Geographical data in this table has been transformed from the shapefile format into a final geographical format, supporting a variety of geospatial analyses. The data includes specific geographical features represented in geojson and geotext formats, along with their geometrical type and the geographical coordinates of their center point. This historical data can be utilized in various ways in data analytics. For example, it could support environmental research to study the change in land contours over time, or in urban planning to understand how the landscape has evolved, informing future development plans. Another use could be in disaster management, where understanding changes in coastlines could be crucial for planning and prevention of natural disasters such as flooding.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Contains the date when the row was extracted from the data source. This column, in combination with the '_row_number', uniquely identifies each row in this version history table. |
|---|
| _end_date | date | Contains the date when a new version of the row was extracted from the data source. If the value of this column is null, it indicates that the row is the most recent version. |
|---|
| _row_number | long | Contains the number of the row as it appears in the raw data extracted from the data source. This column, in combination with the '_start_date', uniquely identifies each row. |
|---|
| KKOD | string | Refers to the category code of the land feature. It is used to classify features within the data source. |
|---|
| geom_geojson | string | Contains the geographical data of the land feature in GeoJSON format. This format is used to encode a variety of geographic data structures. |
|---|
| geom_geotext | string | Holds the geographical data of the land feature as text. This provides a human-readable representation of the geographical data. |
|---|
| geom_type | string | Specifies the type of geometry of the land feature. It describes the shape and nature of the geographical data. |
|---|
| geom_centroid | string | Contains the centroid of the geographical feature. The centroid is the geometric center of a shape. |
|---|
| geom_center_x | double | Specifies the X coordinate of the geometric center of the land feature. It is part of the spatial data stored in the table. |
|---|
| geom_center_y | double | Specifies the Y coordinate of the geometric center of the land feature. It is another part of the spatial data stored in the table. |
|---|
