Comprehensive Collection of Datasets Related to the Dalarna Region
Tables
-
Geographical Information and Object Details Table for the Dalarna Dataset CollectionTSV
The table under consideration is a diverse collection of data that has been sourced from Lantmäteriet, a web site based in Sweden. The table contains a wealth of information that captures a variety of data points. Key elements of the table include date of data extraction and the unique row number for each entry, which together serve to identify each row distinctly. The table also holds geographic data that has been transformed from the shapefile format, a popular method for storing geometric location and attribute information of geographic features. The data in this table could serve a multitude of purposes in data analytics. For instance, the geographic information could be used to perform spatial analysis, allowing for insightful interpretations related to location-based patterns or...
-
Geospatial Attributes and Features of Dalarna Region DatasetTSV
The table in question, a component of a larger dataset, was sourced from the website of Lantmäteriet (the Swedish Land Survey) in Sweden. It is an organized collection of related data presented in rows and columns. The table uniquely includes two special columns providing the extraction date and the row number from the original data source, ensuring each row can be distinctly identified. This table holds geographic information that was initially in shapefile format, a simple, nontopological format for storing the geometric location and attribute information of geographic features. This geographic data has since been transformed into the final geographic format. The table could serve several potential uses in data analytics. For instance, the geographic data could be used to analyze...
-
Geospatial Data Collection with Area Details and Geometry InformationTSV
The table in question is a part of a larger dataset collection. It consists of a variety of columns, each holding different kinds of data. Two special columns hold the extraction date and row number from the original data source. This unique combination of extraction date and row number identifies each specific row of data. The table includes geographic information which has been transformed from the shapefile format. The shapefile format is a way of storing the location and attribute information of geographic features. These features can be represented by points, lines, or polygons (areas). The data for this table is sourced from the website of Lantmäteriet, located in Sweden. This table could serve a multitude of purposes in data analytics. For instance, the geographic information...
-
Geospatial Data Table of Land Areas in Dalarna CollectionTSV
The table originates from the 'Lantmäteriet' website, located in Sweden. It carries a wealth of geographic data, organized in a structured table format, comprised of various columns and rows. Each row in the table is uniquely identified by the combination of two special columns: the date when the data was extracted, and the row number from the original data source. This guarantees an efficient tracking mechanism for each data point. The data in the table is sourced from geographic features, represented in shapefile format - a common method for storing geographic location data, including points, lines, and polygons (areas). The geographic data has been subsequently transformed into its final format from its original shapefile format. As the table carries an array of geographic data, it...
-
Historical Version Control Record of Base Table Rows in Dalarna Dataset CollectionTSV
The table under description is a historical record, part of a larger dataset collection. It specializes in maintaining the version history of its base table rows, providing a unique identifier for each row via a combination of a start date and a row number. The start date indicates when the row was initially extracted from the data source, while an end date signals when a new version of the row was extracted. If the end date value is null, this indicates that the row is the current, most recent version. The table also contains geographical information, originally stored in a shapefile format, a format widely used for storing the geometric location and attribute information of geographic features, such as points, lines, or polygons. This geographic information has been transformed into...
-
Land Classification Data with Geometric AttributesTSV
The table in question is part of a larger dataset collection, which is sourced from the 'Lantmäteriet' website, located in Sweden. This table contains a wealth of information relating to geographic features, with the data originally being in shapefile format - a common format for storing geometric location and attribute information of geographic features. Points, lines, or polygons (areas) can represent these features. The dataset has since been transformed from this original shapefile format into the final geographical format found in the table. Two distinct columns in this table are dedicated to data extraction specifics. One column houses the date that each data row was extracted, while the other contains the row number from the original extraction. Together, these two pieces of...
-
Swedish Historical Land Use Changes: Version HistoryTSV
The history table is part of the 'dalarna' dataset collection and it tracks the version history of its base table rows. It is designed to store detailed information on a variety of entities with a particular focus on geographic data. This table has several unique components that allow for in-depth analysis and tracking. Sourced from the 'Lantmäteriet' (The Swedish Mapping, Cadastral and Land Registration Authority) website in Sweden, it provides reliable and up-to-date information. One of the key features of this table is its ability to track changes over time. Each row in the table is assigned a unique identifier that combines the date of extraction and the row number from the raw data. This allows for precise tracking of when information was added or updated. If a row's end date is...
-
Swedish Land Survey Data Collection: Geometric Analysis and Object IdentificationTSV
The table in question originates from Lantmäteriet (The Swedish Land Survey) in Sweden, offering a multitude of relevant data. It contains information that was extracted on specific dates, with each row representing a unique data extraction, distinguished by the combination of the extraction date and the row number. Geographic data, transformed from the shapefile format, represents a significant portion of the table. This data includes the geometric location and attribute information of geographic features, which can be represented as points, lines, or polygons (areas). This table could prove invaluable in a variety of data analytics applications. For instance, it could be used in environmental studies to track changes in geographical features over time, by comparing data extracted on...
-
Version History of Base Table Rows from a Swedish Source in Dataset CollectionTSV
This history table is a part of a larger dataset collection. It maintains the version history of its base table rows, allowing for tracking of changes over time. Unique identifiers for each row are formed by a combination of a start date, indicating when the row was extracted from the data source, and a row number. In addition, an end date reflects when a new version of the row was added. If this end date is null, it indicates that the current row is the most recent version. The table has two additional columns for these dates compared to its base table, providing a clear timeline of data extraction and versioning. The data within the table includes various geographic details, originally in the shapefile format. This format, used for storing location and attribute information of...
-
Version History of Base Table Rows in Dalarna Dataset CollectionTSV
The 'clc12_66f_nv__history' table is a pivotal piece within the 'dalarna' dataset collection. Being a history table, it provides an extensive record of the version history of its base table rows, making it an invaluable tool for tracking changes over time. This table contains a unique identification system for each row using a combination of the start date and row number. It also includes start and end dates for when each row was extracted and subsequently updated or replaced. If an end date is null, this indicates that the current row represents the most recent version. The table also provides geographic information, translated from the shapefile format, which can be used to represent geographic features as points, lines, or polygons. This data comes from the Swedish website...
-
Version History of Base Table Rows in the Dalarna CollectionTSV
The table in question is a comprehensive history table sourced from the 'Lantmäteriet' (The Land Survey) website based in Sweden. It holds the version history of its base table rows, enabling the tracking of changes over time. This is achieved through two additional columns that signify the start and end dates of when each row was extracted from the data source. A unique characteristic of this table is that each row is distinctly identified by a combination of the start date and row number. The table also contains geographic information which was originally in shapefile format - a common format for storing geometric location and attribute information of geographic features. This information has since been transformed into a final format for use in this dataset. In terms of data...
-
Version History of Base Table Rows in the Dalarna Dataset CollectionTSV
The 'History' table is an integral part of the 'Dalarna' dataset collection. It maintains the version history of its base table rows, ensuring that changes over time can be tracked and analyzed. This unique feature is facilitated by two key columns that record the dates when a row was extracted from the data source and when a new version of the same row was added. This offers a comprehensive view of the row's lifecycle, with the latest version being identifiable by a null value in the column recording the date of the next version's extraction. The table also includes a column that serves as a unique identifier for each row in conjunction with the extraction date. This approach ensures that each version of a row is distinct and identifiable. Furthermore, the table contains geographical...
Column Descriptions
Geospatial Attributes and Features of Dalarna Region Dataset
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| OBJECTID | long | This column contains the object identifier associated with each entry in the table. |
| ID | string | This column contains the unique identification value for each entry in the table. |
| CODE_12 | string | This column contains the 12-digit code associated with each entry in the table. |
| Area_Ha | double | This column contains the area value in hectares for each entry in the table. |
| Remark | string | This column contains any remarks or additional information associated with each entry in the table. |
| Shape_Leng | double | This column contains the length value for the shape associated with each entry in the table. |
| Shape_Area | double | This column contains the area value for the shape associated with each entry in the table. |
| geom_geojson | string | This column contains the GeoJSON representation of the geometry associated with each entry in the table. |
| geom_geotext | string | This column contains the geotext representation of the geometry associated with each entry in the table. |
| geom_type | string | This column contains the type of geometry associated with each entry in the table. |
| geom_centroid | string | This column contains the centroid of the geometry associated with each entry in the table. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry associated with each entry in the table. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry associated with each entry in the table. |
Version History of Base Table Rows in the Dalarna Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' column to identify 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. A null value in this column 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 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 identifier of the object. |
| ID | string | This column contains a unique identifier. |
| CODE_12 | string | This column contains a specific code related to the data. |
| Area_Ha | double | This column represents the area measurement in hectares. |
| Remark | string | This column contains any remarks or additional information about the row. |
| Shape_Leng | double | This column represents the length of the shape. |
| Shape_Area | double | This column represents the area of the shape. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. |
| geom_geotext | string | This column contains the geographical data in text format. |
| geom_type | string | This column indicates the type of the geographical data. |
| geom_centroid | string | This column contains the centroid of the geographical data. |
| geom_center_x | double | This column represents the X coordinate of the geographical data's center. |
| geom_center_y | double | This column represents the Y coordinate of the geographical data's center. |
Land Classification Data with Geometric Attributes
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the information on this row was extracted from the data source. |
| _row_number | long | This column contains the row number in the data that was extracted from the source on the extract date specified by the column '_extract_date'. |
| OBJECTID | long | This column can be a unique identifier for an object within the dataset. |
| ID | string | This column is likely another unique identifier for an object within the dataset. |
| CODE_12 | string | This column might represent a specific code associated with the data on the row. |
| Area_Ha | double | This column likely represents the area of an object or location, possibly measured in hectares. |
| Remark | string | This column could contain any additional remarks or comments related to the data on the row. |
| Shape_Leng | double | This column likely represents the length of a specific shape, possibly related to the object or location. |
| Shape_Area | double | This column likely represents the area of a specific shape, possibly related to the object or location. |
| geom_geojson | string | This column likely contains geojson data, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column might contain geotext data, which could be a text representation of geographic data. |
| geom_type | string | This column likely specifies the type of the geographical data represented in the row. |
| geom_centroid | string | This column likely contains the centroid of a geographical shape or object. The centroid is the geometric center of a plane figure. |
| geom_center_x | double | This column likely represents the x-coordinate of the center of a geographical shape or object. |
| geom_center_y | double | This column likely represents the y-coordinate of the center of a geographical shape or object. |
Version History of Base Table Rows from a Swedish Source in Dataset Collection
| 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 records the row number as it appears in the raw data extracted from the source. It forms a unique identifier for each row in combination with '_start_date'. |
| OBJECTID | long | This column is likely to contain a unique identifier for each object in the table. |
| ID | string | This column is likely to contain another form of unique identifier for each row. |
| CODE_12 | string | The purpose of this column is unclear without additional context, but it likely holds some form of coded information. |
| Area_Ha | double | This column presumably contains area measurements of geographical features, measured in hectares. |
| Remark | string | This column likely contains additional notes or comments related to each row. |
| Shape_Leng | double | This column likely contains measurements related to the length of the shape of geographical features. |
| Shape_Area | double | This column likely contains measurements related to the area of the shape of geographical features. |
| geom_geojson | string | This column likely contains geographic data in the GeoJSON format, a type of open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column likely contains geographic data in a text format. |
| geom_type | string | This column likely indicates the type of geometric shape that represents each geographical feature. |
| geom_centroid | string | This column likely contains the centroid, or geometric center, of each geographical feature. |
| geom_center_x | double | This column likely contains the X-coordinate of the center point of each geographical feature. |
| geom_center_y | double | This column likely contains the Y-coordinate of the center point of each geographical feature. |
Swedish Land Survey Data Collection: Geometric Analysis and Object Identification
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
| OBJECTID | long | This column contains the unique identifier for each object in the table. |
| ID | string | This column contains the identification code of the data. |
| CODE_12 | string | This column contains a twelve-digit code associated with the data. |
| Area_Ha | double | This column contains the area of the geographical feature in hectares. |
| Remark | string | This column contains any additional comments or observations related to the data. |
| Shape_Leng | double | This column contains the length of the geographical feature's shape. |
| Shape_Area | double | This column contains the area of the geographical feature's shape. |
| geom_geojson | string | This column contains the geographical feature's geometry in GeoJSON format. |
| geom_geotext | string | This column contains the geographical feature's geometry in a textual format. |
| geom_type | string | This column contains the type of the geographical feature's geometry. |
| geom_centroid | string | This column contains the centroid of the geographical feature's geometry. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical feature's geometry. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical feature's geometry. |
Swedish Historical Land Use Changes: Version History
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. It forms a unique identifier for each row in combination with the '_row_number'. |
| _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 version of the row is the most recent. |
| _row_number | long | The number of the row in the raw data, extracted from the data source. It forms a unique identifier for each row in combination with the '_start_date'. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | A unique identifier for each row in the table. |
| CODE_12 | string | A code associated with the row, the meaning of which depends on the context. |
| Area_Ha | double | The area of the geographical entity related to the row, measured in hectares. |
| Remark | string | Remarks or comments associated with the row. |
| Shape_Leng | double | The length of the shape associated with the row. |
| Shape_Area | double | The area of the shape associated with the row. |
| geom_geojson | string | The geographical data associated with the row, in GeoJSON format. |
| geom_geotext | string | The geographical data associated with the row, in a text format. |
| geom_type | string | The type of the geographical data associated with the row. |
| geom_centroid | string | The centroid of the geographical data associated with the row. |
| geom_center_x | double | The x-coordinate of the center of the geographical data associated with the row. |
| geom_center_y | double | The y-coordinate of the center of the geographical data associated with the row. |
Geographical Information and Object Details Table for the Dalarna Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the data source. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. |
| OBJECTID | long | This column contains the unique identification number of the object. |
| ID | string | This column contains an additional identifier for the object, possibly used in other related tables or datasets. |
| CODE_12 | string | This column contains specific codes associated with the object, the meaning of which could be determined by the data source. |
| Area_Ha | double | This column represents the area of the object in hectares. |
| Remark | string | This column contains any additional remarks or comments about the object. |
| Shape_Leng | double | This column contains the length of the object's shape, possibly in a specific unit of measure. |
| Shape_Area | double | This column represents the area of the object's shape, possibly in a specific unit of measure. |
| geom_geojson | string | This column contains GeoJSON representation of the object's geometry. |
| geom_geotext | string | This column contains a textual description of the object's geometry. |
| geom_type | string | This column specifies the type of the object's geometry. |
| geom_centroid | string | This column contains the centroid of the object's geometry. |
| geom_center_x | double | This column contains the x-coordinate of the object's geometric center. |
| geom_center_y | double | This column contains the y-coordinate of the object's geometric center. |
Version History of Base Table Rows in Dalarna Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column records the date when the row's data was extracted from the source. It helps in tracking the version history of the base table rows. In combination with the '_row_number', it uniquely identifies each row in the history table. |
| _end_date | date | This column records the date when a newer version of the row was extracted from the source, marking the end of the validity of the data in the current row. If this column is null, it indicates that the current row is the most recent version in the history. |
| _row_number | long | This column contains the number of the row as it appears in the raw data sourced from 'Lantmäteriet' (The Land Survey) in Sweden. It is part of the unique identifier for each row in the history table, in combination with the '_start_date'. |
| OBJECTID | long | This column contains the object ID, a unique identifier assigned to each object or feature within the dataset. |
| ID | string | This column records the unique ID for each entry in the table. |
| CODE_12 | string | This column contains the code_12, a specific code related to the entry. |
| Area_Ha | double | This column records the area of the feature in hectares. |
| Remark | string | This column contains any additional notes or remarks associated with the row's data. |
| Shape_Leng | double | This column records the length of the feature's shape. |
| Shape_Area | double | This column records the area of the feature's shape. |
| geom_geojson | string | This column contains the geometric representation of the feature in GeoJSON format, a common format for encoding geographic data structures. |
| geom_geotext | string | This column contains the geometric representation of the feature in plain text. |
| geom_type | string | This column describes the type of geometry represented, such as 'Point', 'LineString', or 'Polygon'. |
| geom_centroid | string | This column contains the centroid of the feature's geometry, which is the geometric center of the shape. |
| geom_center_x | double | This column records the x-coordinate of the feature's geometric center. |
| geom_center_y | double | This column records the y-coordinate of the feature's geometric center. |
Geospatial Data Table of Land Areas in Dalarna Collection
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date on which the data row was extracted from the source. |
| _row_number | long | The row number in the data extracted from the source on the specified extract date. Along with '_extract_date', this column can be used to uniquely identify each row. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An additional identification column for the data row. |
| CODE_12 | string | A coded representation of certain characteristics of the data row. |
| Area_Ha | double | The area of the geographical object represented in the data row, measured in hectares. |
| Remark | string | A column for potential additional comments or notes regarding the data row. |
| Shape_Leng | double | The length of the shape of the geographic object represented in the data row. |
| Shape_Area | double | The area of the shape of the geographic object represented in the data row. |
| geom_geojson | string | The geometric representation of the geographic object in GeoJSON format. |
| geom_geotext | string | The geometric representation of the geographic object in a text format. |
| geom_type | string | The type of the geometric representation of the geographic object. |
| geom_centroid | string | The centroid, or geometric center, of the geographic object. |
| geom_center_x | double | The x-coordinate of the center of the geographic object. |
| geom_center_y | double | The y-coordinate of the center of the geographic object. |
Historical Version Control Record of Base Table Rows in Dalarna Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. Together with '_row_number', 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 its value is null, it means 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 '_start_date', it uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | A unique identifier for each entry in the table. |
| CODE_12 | string | A code associated with each row in the table. |
| Area_Ha | double | The area (in hectares) associated with each row in the table. |
| Remark | string | Any additional comments or observations associated with each row. |
| Shape_Leng | double | The length of the shape associated with each row. |
| Shape_Area | double | The area of the shape associated with each row. |
| geom_geojson | string | The geometric representation of the data in GeoJSON format. |
| geom_geotext | string | The geometric representation of the data in text format. |
| geom_type | string | The type of the geometric representation of the data. |
| geom_centroid | string | The centroid of the geometric representation of the data. |
| geom_center_x | double | The x-coordinate of the center of the geometric representation of the data. |
| geom_center_y | double | The y-coordinate of the center of the geometric representation of the data. |
Geospatial Data Collection with Area Details and Geometry Information
| 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 identification number assigned to each entry in the table. |
| CODE_12 | string | A code associated with the data entry. |
| Area_Ha | double | The area measurement of the data object, represented in hectares. |
| Remark | string | Any additional comments or remarks regarding the data entry. |
| Shape_Leng | double | The length of the shape of the data object. |
| Shape_Area | double | The area of the shape of the data object. |
| geom_geojson | string | The geographical location of the data object, represented in GeoJSON format. |
| geom_geotext | string | The geographical location of the data object, represented in a text format. |
| geom_type | string | The type of the geographical object associated with the data entry. |
| geom_centroid | string | The centroid or geometric center of the data object. |
| geom_center_x | double | The x-coordinate of the center of the data object. |
| geom_center_y | double | The y-coordinate of the center of the data object. |
Version History of Base Table Rows in the Dalarna Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row was first extracted from the data source. |
| _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 as it appeared in the raw data extracted from the data source. This, in combination with the '_start_date', uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object or entry in the table. |
| ID | string | An identification code for each entry in the table. |
| CODE_12 | string | A specific code associated with each entry in the table. |
| Area_Ha | double | The area of the object or entry, measured in hectares. |
| Remark | string | Any additional comments or notes regarding the entry. |
| Shape_Leng | double | The length of the perimeter of the object or area represented by the entry. |
| Shape_Area | double | The total area of the object or area represented by the entry. |
| geom_geojson | string | The geometric representation of the object or area, formatted as GeoJSON. |
| geom_geotext | string | The geometric representation of the object or area, formatted as plain text. |
| geom_type | string | The type of geometric shape used to represent the object or area. |
| geom_centroid | string | The central point of the geometric shape used to represent the object or area. |
| geom_center_x | double | The X coordinate of the center of the geometric shape used to represent the object or area. |
| geom_center_y | double | The Y coordinate of the center of the geometric shape used to represent the object or area. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | August 26, 2024 |