Version History Table of Base Rows as Part of Gotland Dataset Collection Sourced from a Prominent Swedish Website
The table under consideration is a history table that forms a part of a dataset collection. This history table holds the version history of its base table rows, allowing for the tracking of changes over time. Each record in this table is uniquely identified by a combination of the extraction date and the row number in the original data source. The table also includes information about the start and end date of each version of a record, with a null end date indicating the most recent version.
The table includes geographic information that was originally in shapefile format, a common geographic information system (GIS) format, but has been transformed into a final geographic format. This geographic information can represent various geographic features such as points, lines, or polygons.
The data for the table is sourced from Lantmäteriet, the Swedish mapping, cadastral and land registration authority. The data housed in this table could be used in various ways in data analytics. For instance, the geographic information could be used to create visual representations of the data in GIS software. The version history could be utilized to analyze changes over time, potentially revealing trends or patterns. The row numbering could be used to examine the raw data extraction process and identify any potential issues or anomalies.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when a specific row was extracted from the data source. It is one of the two unique identifiers for each row in this history table. |
| _end_date | date | This column 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 | This column contains the number of the row as it appeared in the raw data extracted from the data source. It forms a unique combination with the _start_date column to identify each row in this version history table. |
| OBJECTID | long | This column contains the unique object identifier. |
| ID | string | This column contains an identification number. |
| CODE_12 | string | This column contains twelve-digit codes. |
| Area_Ha | double | This column contains data on the area in hectares. |
| Remark | string | This column contains any additional notes or remarks. |
| Shape_Leng | double | This column contains the length of the shape. |
| Shape_Area | double | This column contains the area of the shape. |
| geom_geojson | string | This column contains the geometry of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the object in text format. |
| geom_type | string | This column indicates the type of geometric figures. |
| geom_centroid | string | This column contains the centroid of the geometric figures. |
| geom_center_x | double | This column contains the x-coordinate of the geometric shape center. |
| geom_center_y | double | This column contains the y-coordinate of the geometric shape center. |
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 | 31f6fab9-ff1f-4298-a083-fd6123e388d4 |
| Package id | 67bd8d2b-d2f8-414f-83fd-4174021993d6 |
| Position | 1 |
| Revision id | e60ed2b0-72c9-4edd-9eae-86ea1a47f71b |
| State | active |
| Table | gotland_zip__clc12_63g_no__history |