Historical Version Records of Base Table Rows in Gotland Dataset Collection
The 'clc12_64h_sv__history' table is a historical data table that belongs to the 'gotland' dataset collection. This historical table stores the version history of the base table rows, making it a valuable resource for tracking changes over time. Each row in the table is uniquely identified by a combination of a start date and a row number, with the start date marking when the row was extracted from the data source, and the row number indicating its position in the raw data. There is also an end date for each row, which signifies when a new version of the row was extracted. If the end date is null, this indicates that the row is the most recent version.
The data within the table includes a variety of geographical information, transformed from the shapefile format, which is a format used for storing geometric location and attribute information of geographic features. These features can be represented by points, lines, or polygons.
The table originates from the Lantmäteriet website, based in Sweden.
As for its utilization in data analytics, the table's historical records could be leveraged to understand trends and patterns over time. For instance, analysts could track changes in the geographical features, or use the historical data to predict future changes. Moreover, the geographical information could be used to create visual maps and models for various studies or projects.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column holds the date when the specific row was extracted from the data source. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version. |
| _row_number | long | This column contains the number of the row as it appears in the raw data extracted from the data source. This number, combined with the start date, uniquely identifies each row in this version history table. |
| OBJECTID | long | This column contains unique identifiers for the objects in the table. |
| ID | string | This column represents the unique ID of each entity in the table. |
| CODE_12 | string | This column contains specific codes associated with the rows. |
| Area_Ha | double | This column represents the area of the entities, measured in hectares. |
| Remark | string | This column contains any additional remarks or comments related to the entities. |
| Shape_Leng | double | This column represents the length of the shape of the entities. |
| Shape_Area | double | This column represents the area of the shape of the entities. |
| geom_geojson | string | This column contains the geographical data of the entities in GeoJSON format. |
| geom_geotext | string | This column contains the geographical data of the entities in text format. |
| geom_type | string | This column specifies the type of the geographical data. |
| geom_centroid | string | This column contains the centroid of the geographical entities. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical entities. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical entities. |
No sample for this dataset
Additional Information
| Last updated | August 26, 2024 |
|---|---|
| Created | August 26, 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-08-26 |
| Id | 0429f228-d7c7-4be5-8566-4d1a9e413509 |
| Package id | 67bd8d2b-d2f8-414f-83fd-4174021993d6 |
| Position | 3 |
| Revision id | 038006b0-934a-4aee-81e6-81d315b9209f |
| State | active |
| Table | gotland_zip__clc12_64h_sv__history |