Swedish Land Survey Dataset Collection
Tables
-
Geospatial and Attribute Information of Land Parcels in SkåneTSV
The table is a structured collection of geographic data, sourced from the Swedish website 'Lantmäteriet' (The Land Survey). It contains data which has been meticulously extracted, organised into rows and columns, and uniquely identified by the combination of extraction date and row number. The geographic information, originally in simple shapefile format, has been transformed into a final geographic format for ease of use and analysis. It includes information on the geometric location and attributes of geographic features, represented by points, lines, or polygons (areas). The table is part of a larger dataset collection, providing a rich and extensive resource for in-depth data analytics. For instance, the data could be used to track changes in land use over time, by comparing the...
-
Swedish Land Survey: Detailed Geographical Data CollectionTSV
The table in question is a part of a dataset collection, and it contains a rich array of data which is organized in a tabular format. This data is divided into several rows and columns, each serving a unique purpose. This table is unique in that it contains two special columns that help to identify each row uniquely - one column contains the date when the data on the row was extracted, and the other column contains the row number in the data extracted on that particular date. The geographic information in this table is noteworthy, as it has been transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features, into the final geographic format. This table has been sourced from the web site of Lantmäteriet, located in...
-
Version History of Base Table Rows in a Dataset Collection from a Swedish SourceTSV
The table in question is a historical log of data entries, sourced from the Lantmäteriet website in Sweden. It forms part of a larger dataset collection and serves as a detailed record of changes made to its base table. Each row in the table represents a unique version of a row from the base table, identifiable by a unique combination of start date and row number. The start date indicates when the row was originally extracted from the data source, while an accompanying end date indicates when a new version of that row was extracted. If an end date is not present, it signifies that the row is the most recent version. The table also contains geographical data, originally in the shapefile format, representing geographic features and locations. This geographic data has been transformed from...
-
Version History Table of Geographic and Geometric Data in Skane Dataset CollectionTSV
The table in question is a historical record, tracing the evolution of each row in its base table. It essentially serves as a version history log, tracking changes at the row level. Unique identifiers for each row are formed by the combination of the date of extraction and the raw row number from the data source. The table also records the date a new version of a row was extracted. If a row is the most recent version, this will be indicated by a null value in the 'end date' column. This table is particularly rich in geographic data, which has been transformed from the shapefile format. This format, commonly used for storing the geometric location and attribute information of geographic features, can represent features as points, lines, or polygons. The data for this table is sourced...
Column Descriptions
Geospatial and Attribute Information of Land Parcels in Skåne
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data on the row was extracted from the data source. |
_row_number | long | The row number in the data extracted from the source on the extract date. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An identifier for each data entry. |
CODE_12 | string | A code representing certain information about the data entry. |
Area_Ha | double | The area (in hectares) related to the data entry. |
Remark | string | A field for additional notes or comments about the data entry. |
Shape_Leng | double | The length of the shape associated with the data entry. |
Shape_Area | double | The area of the shape associated with the data entry. |
geom_geojson | string | The geometric data in GeoJSON format. |
geom_geotext | string | The geometric data in text format. |
geom_type | string | The type of the geometric data. |
geom_centroid | string | The centroid of the geometric data. |
geom_center_x | double | The x-coordinate of the center of the geometric data. |
geom_center_y | double | The y-coordinate of the center of the geometric data. |
Version History of Base Table Rows in a Dataset Collection from a Swedish Source
Column | Type | Comment |
---|---|---|
_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 | This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data extracted from the data source. It is part of a combination with '_start_date' that uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains technical identifiers for the objects in the table. |
ID | string | This column contains the unique identifiers for the data entries in the table. |
CODE_12 | string | This column contains specific codes associated with the data entries in the table. |
Area_Ha | double | This column contains the area data (in hectares) associated with the entries in the table. |
Remark | string | This column contains any remarks or additional information about the entries in the table. |
Shape_Leng | double | This column contains the length data of the shape associated with the entries in the table. |
Shape_Area | double | This column contains the area data of the shape associated with the entries in the table. |
geom_geojson | string | This column contains the geometry of the entries in the table in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the entries in the table in plain text format. |
geom_type | string | This column contains the type of the geometry associated with the entries in the table. |
geom_centroid | string | This column contains the centroid of the geometry associated with the entries in the table. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometry associated with the entries in the table. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometry associated with the entries in the table. |
Swedish Land Survey: Detailed Geographical Data Collection
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data in the row was extracted from the data source. |
_row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | A unique identifier for each record in the table. |
CODE_12 | string | A code representing specific data category for the record. |
Area_Ha | double | The area covered by the record, measured in hectares. |
Remark | string | Any additional notes or comments related to the record. |
Shape_Leng | double | The length of the shape representing the record. |
Shape_Area | double | The area of the shape representing the record. |
geom_geojson | string | The geographic data of the record formatted in GEOJSON. |
geom_geotext | string | The geographic data of the record formatted as text. |
geom_type | string | The type of geometric shape used to represent the record. |
geom_centroid | string | The geographical center point of the shape representing the record. |
geom_center_x | double | The x-coordinate of the center point of the shape representing the record. |
geom_center_y | double | The y-coordinate of the center point of the shape representing the record. |
Version History Table of Geographic and Geometric Data in Skane Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | This column delivers the date when the row was extracted from the database. It's part of the unique identifier for each row in this version history table, along with the '_row_number'. |
_end_date | date | This column provides the date when a new version of the row was extracted from the database. If the value is null, it signifies that the row is the most recent version. |
_row_number | long | This column contains the number of the row as it was in the raw data extracted from the data source. It's used in combination with '_start_date' to uniquely identify each row in this version history table. |
OBJECTID | long | This column contains the unique object identifier. |
ID | string | This column contains the unique ID. |
CODE_12 | string | This column contains the unique 12-digit code. |
Area_Ha | double | This column contains the area in hectares. |
Remark | string | This column contains any additional 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 GeoJSON representation of the geometry. |
geom_geotext | string | This column contains textual description of the geometry. |
geom_type | string | This column specifies the type of the geometry. |
geom_centroid | string | This column contains the centroid of the geometry. |
geom_center_x | double | This column contains the x-coordinate of the geometry center. |
geom_center_y | double | This column contains the y-coordinate of the geometry center. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |