Historical Version Records of Varmland Collection
The table under consideration is a history table, which means it contains the version history of its base table rows. This is indicated by the presence of two unique columns: one capturing the date when a row is extracted from the data source, and another recording the date when a new version of the same row is sourced. If a row is the most recent version, the latter column will have a null value.
Another feature of this table is its unique identifier, which is a combination of the date of extraction and the row number from the raw data.
The table also contains geographical information, originally in shapefile format, which has been subsequently transformed into a final geographical format. This information can represent geographic features as points, lines, or polygons.
This table is sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden.
The data from this table could be utilized in various ways in data analytics. For example, it could be used to track changes in geographic features over time, offering insights into trends and patterns. It could also support predictive modeling by providing historical data for training machine learning algorithms. The unique identifier could be leveraged to integrate this data with other datasets, thereby enriching the analysis with additional dimensions.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. Together with the '_row_number' column, it uniquely identifies each row in this version history table. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. Together with the '_start_date' column, it uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identifier for each entry in the table. |
| CODE_12 | string | A code associated with each entry in the table. |
| Area_Ha | double | The area of the geographical feature represented by the entry, measured in hectares. |
| Remark | string | Any additional comments or remarks related to the entry. |
| Shape_Leng | double | The length of the shape representing the geographical feature, in the unit used by the data source. |
| Shape_Area | double | The area of the shape representing the geographical feature, in the unit used by the data source. |
| geom_geojson | string | The geometry of the geographical feature, represented in GeoJSON format. |
| geom_geotext | string | The geometry of the geographical feature, represented as text. |
| geom_type | string | The type of geometry used to represent the geographical feature. |
| geom_centroid | string | The centroid of the geographical feature, represented in the coordinate system used by the data source. |
| geom_center_x | double | The X-coordinate of the center of the geographical feature, in the coordinate system used by the data source. |
| geom_center_y | double | The Y-coordinate of the center of the geographical feature, in the coordinate system used by the data source. |
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 | de530dc3-819c-426b-97d4-f6ac1779d73e |
| Package id | bdfc37ab-2d87-436a-ba7b-6312fe00922e |
| Position | 11 |
| Revision id | a7ad9468-4e01-4b60-98f1-dfa1fa46456f |
| State | active |
| Table | varmland_zip__clc12_65e_sv__history |