Historical Version Records of Base Table Rows in Norrbotten Dataset
The history table is part of a dataset collection hailing from Norrbotten. It contains the version history of its base table rows, with unique identifiers being the combination of the row's start date and its position in the raw data sequence. Each row's history starts with the date it was extracted from the data source, and ends with the date a new version was extracted. If the end date is null, this indicates that the row is the most current version. Geographical data is translated from the shapefile format, which is a format for storing the geometric location and attribute information of geographic features, into the final geographic format. The table is sourced from 'Lantmäteriet' (The Land Survey of Sweden) in Sweden.
The data in this table can be leveraged in a variety of ways for data analytics. For instance, the version history can be used to track changes over time, which could be useful in understanding trends or patterns. The geographical data could be used to create visual maps or to conduct spatial analysis, such as determining the proximity of different points, or understanding patterns in the geographic distribution of the data. The row number and start date could potentially be used to debug data extraction issues or to monitor the data extraction process over time.
Field Descriptions
Name | Data type | Description |
---|---|---|
_start_date | date | This column holds the date when the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' |
_end_date | date | The '_end_date' 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 signifies that the row is the most recent version. |
_row_number | long | The '_row_number' column contains the number of the row as it appears in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date'. |
ID | string | The 'ID' column is used to store the unique identifier assigned to each row. |
CODE_06 | string | The 'CODE_06' column is used to represent specific code information related to the data row. |
Area_Ha | double | The 'Area_Ha' column represents the area in hectares. |
Remark | string | The 'Remark' column is used to store any additional notes or remarks related to the data row. |
Shape_Leng | double | The 'Shape_Leng' column represents the length of the shape. |
Shape_Area | double | The 'Shape_Area' column represents the area of the shape. |
geom_geojson | string | The 'geom_geojson' column stores the geometric data in GeoJSON format. |
geom_geotext | string | The 'geom_geotext' column stores the geometric data in text format. |
geom_type | string | The 'geom_type' column indicates the type of geometric data. |
geom_centroid | string | The 'geom_centroid' column contains the centroid of the geometric shape. |
geom_center_x | double | The 'geom_center_x' column represents the x-coordinate of the geometric shape's center. |
geom_center_y | double | The 'geom_center_y' column represents the y-coordinate of the geometric shape's center. |
No sample for this dataset
Additional Information
Last updated | August 27, 2024 |
---|---|
Created | August 27, 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 | 7c2a1a85-e383-4953-97b4-ba588c4c6362 |
Package id | aec689b3-8d6e-4322-88cd-6b96004c9ec7 |
Position | 41 |
Revision id | d5d96e86-63fa-4e70-a9c7-3d7e6236f06a |
State | active |
Table | norrbotten_zip__06_75fso__history |