Historical Version Records of Base Table Rows in Sodermanland Dataset Collection
The 'clc12_65f_so__history' table is a historical record originated from the dataset collection named 'sodermanland'. This historical record provides a version history of its base table rows, allowing users to track changes over time. Each row in the table is uniquely identified by a specific combination of its extraction date and its row number from the raw data.
The table includes a start date indicating when the row was first extracted, and an end date showing when a new version of the row was introduced. If the end date is null, it signifies that the row is the most recent version.
In addition to these time-related attributes, the table contains geographic information, which has been transformed from the original shapefile format. This geographic information can represent points, lines, or polygons (areas), offering a wealth of potential for spatial analysis.
Sourced from the 'Lantmäteriet' website in Sweden, this table offers valuable insights into the evolution of the data over time and space.
As for its use in data analytics, it could be utilized in several ways. For instance, the version history could be used to study trends and patterns over time, such as changes in area size or location. The geographic information could be used in spatial analysis, for example, to identify clusters or patterns in geographic distribution. Moreover, the version history information could enable auditing of the data, for example, to ensure data quality and consistency by identifying any anomalies or inconsistencies in the data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It is part of a combination with '_row_number' that uniquely identifies each row in this version history table. |
| _end_date | date | The '_end_date' column holds 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 '_row_number' column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier in conjunction with '_start_date' for each row in this version history table. |
| OBJECTID | long | The 'OBJECTID' column represents a unique identifier for each object in the table. |
| ID | string | The 'ID' column serves as a unique identifier for each entry in the dataset. |
| CODE_12 | string | The 'CODE_12' column holds specific codes associated with each entry in the table. |
| Area_Ha | double | The 'Area_Ha' column denotes the area of the geographical feature, measured in hectares. |
| Remark | string | The 'Remark' column contains any additional notes or remarks pertaining to the row. |
| Shape_Leng | double | The 'Shape_Leng' column indicates the length of the geographical shape associated with the row. |
| Shape_Area | double | The 'Shape_Area' column represents the total area of the geographical shape related to the row. |
| geom_geojson | string | The 'geom_geojson' column stores the geographical information of the feature in GeoJSON format. |
| geom_geotext | string | The 'geom_geotext' column holds the geographical information of the feature in a text format. |
| geom_type | string | The 'geom_type' column specifies the type of the geographical shape related to the row. |
| geom_centroid | string | The 'geom_centroid' column indicates the centroid of the geographical shape associated with the row. |
| geom_center_x | double | The 'geom_center_x' column represents the X-coordinate of the center of the geographical shape related to the row. |
| geom_center_y | double | The 'geom_center_y' column denotes the Y-coordinate of the center of the geographical shape related to the row. |
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 | d920b08f-454b-410d-a878-08a5b7641d82 |
| Package id | e88c5cab-003c-4619-92cb-135e8e103dc2 |
| Position | 5 |
| Revision id | 163f501a-8e8b-498a-bcb5-b081de5aa492 |
| State | active |
| Table | sodermanland_zip__clc12_65f_so__history |