Varmland Region Comprehensive Dataset Collection
Tables
-
Geographical Attributes and Characteristics CollectionTSV
The table in question is a part of a dataset collection, which houses a broad range of related data. These data points are neatly organized into rows and columns for ease of understanding and analysis. This particular table is distinctive because it contains two special columns that work in tandem to uniquely identify each row. One of these columns houses the date the data was extracted from the source, while the other contains the row number in that extracted data. The table is sourced from the 'Lantmäteriet' website based in Sweden. Lantmäteriet, or the Swedish Land Survey in English, is known for its extensive collection of geographic data. This particular table is no exception, with its geographic information initially in the shapefile format, a common format for storing geometric...
-
Geospatial and Attribute Data for Land Features in VärmlandTSV
The table in discussion is an organized collection of data, part of a larger dataset. This comprehensive table is sourced from Lantmäteriet (The Land Survey) in Sweden. It offers a wealth of information, with each row of data being uniquely identifiable by a combination of the extraction date and the row number, providing a snapshot of the data at a particular point in time. The data leverages geographic information, initially in shapefile format, which has been transformed to a more final geographic format. The geographic features can be represented by points, lines, or polygons (areas). The table also contains an array of other information, such as object identifiers, codes, area measurements in hectares, remarks, geometric information, and more. This table offers a multitude of...
-
Geospatial and Property Information of Varmland RegionTSV
The table under consideration is a comprehensive collection of geographic data from Sweden, sourced from the website of Lantmäteriet (The National Land Survey). It contains a wealth of information including specific object identifiers, area measurements in hectares, remarks or comments, and geometric information. Unique identifiers for each row are determined by a combination of the extraction date and the row number, ensuring each entry is distinctly identifiable. The geometric data, originally in shapefile format, includes details such as the length and area of geometric shapes, the centroid of the geometric shape, and the X and Y coordinates of the geometric center. These details can be represented by points, lines, or polygons, allowing for extensive geographic visualizations and...
-
Geospatial Characteristics and Area Measurements of Varmland RegionTSV
The table in question originates from the 'Lantmäteriet' (The Land Survey) in Sweden. It's a part of a larger dataset collection and is a valuable resource for geographic data analytics. The data organized in rows and columns includes various types of information, such as an object identifier, area in hectares, remarks, and various geometric parameters related to geographic features. Special attention should be given to two unique columns that provide the extract date and row number. This duo serves as a unique identifier for each row, providing a clear reference point for data extraction. The geographic information, initially in shapefile format, has been transformed into its final form for easier manipulation and analysis. The potential applications of this table are vast in the...
-
Geospatial Characteristics and Metrics of Land Parcels in Värmland RegionTSV
The table in question originates from the dataset collection of 'Varmland', and it contains a rich collection of geographic information. This information was primarily sourced from 'Lantmäteriet' (The National Land Survey) in Sweden. The table is made up of several columns that contain a variety of data types and data points. Two unique columns in the table are those that hold the extract date and the row number. Together, these two columns are used to uniquely identify each row of data. The extract date indicates when the data for that row was initially extracted from the source, while the row number refers to its position in the data extracted from the source on the specified extract date. The geographic data in the table was initially in the shapefile format, a simple, nontopological...
-
Geospatial Data Collection with Land Features, Area, and Geometric InformationTSV
This table is part of a dataset collection that originates from Sweden, specifically from the website of Lantmäteriet (the Land Survey). The table provides a wealth of information pertaining to geographical data, which has been transformed from its original shapefile format. This format is a ubiquitous standard in the field of geospatial vector data, and can represent geographical features as points, lines, or polygons. The data in this table is therefore highly versatile, and can be used to represent a wide array of geographical features. Unique identifiers are established for each row with a combination of the extraction date and the row number, ensuring that each piece of data can be precisely pinpointed and referenced. The table could be useful in various fields of data analytics....
-
Historical Record of Versioned Base Table Rows in Varmland CollectionTSV
The 'clc12_67d_so__history' table is a historical record of its base table, capturing the version history of each row. It is part of the 'varmland' dataset collection. This historical table is unique in that it contains two additional columns in comparison to its base table - these columns indicate the start and end dates for when a row was extracted from the data source. A unique identifier for each row is created through a combination of the row number and the start date. If the end date for a row is null, it signifies that the current row is the most recent version. The table also houses geographic information derived from a shapefile format, a common format for storing geometric location and attribute information of geographic features. These geographic features can be expressed as...
-
Historical Version Records of Varmland CollectionTSV
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...
-
Land Cover Classification and Geometric Data AnalysisTSV
The table in question is part of a larger dataset collection sourced from 'Lantmäteriet' in Sweden. This table is organized in a comprehensive manner, consisting of numerous columns and rows. Special emphasis is placed on two specific columns which denote the date of data extraction and the row number. These two columns combined provide a unique identifier for each row. The table includes geographical data transformed from shapefile format, a common format for storing geographical location and attribute information. This geographical data can be represented by points, lines, or polygons (areas). Potential applications for data analytics could include spatial analysis, where the geographical data could be used to map and analyze specific trends or patterns in the area of interest. For...
-
Land Cover Classification Data Collection for Värmland RegionTSV
The table is a part of a larger dataset collection which is sourced from the website of the 'Lantmäteriet' (The Land Survey) in Sweden. It contains a diverse range of data, with special emphasis on date of data extraction and row numbers that uniquely identify each row, providing a clear and specific tracking mechanism. It also includes a variety of geographic data, which have been converted into a more user-friendly format from the original shapefile format. Geographical features are represented by points, lines, or polygons (areas) in this dataset. In terms of data analytics, this table could be incredibly useful. For instance, the data could be used to study temporal trends by analyzing changes in the data over the extraction dates. The geographic data could be utilized to conduct...
-
Spatial Characteristics and Geometrical Data of Varmland RegionTSV
This table is a detailed collection of geographic data sourced from Lantmäteriet, Sweden's national land survey website. It contains a wealth of information related to geographic locations, captured in a tabular format with multiple columns and rows. Each row in the table is uniquely identified by a combination of the date when the data was extracted and the row number in the extracted data. The geographic information originates from a shapefile, a format that stores location and attribute details of geographic features. These features can be points, lines, or polygons (areas), and have been transformed from the shapefile format into the final geographic format in this dataset. The table is part of a larger dataset and can be highly beneficial in data analytics. For instance, it can be...
-
Version History of Base Table Rows in the Varmland Dataset CollectionTSV
The table under discussion is a historical record, sourced from 'Lantmäteriet' (the National Land Survey) in Sweden. As a history table, it contains a version history of its base table rows, enabling users to track changes over time. Two columns in the table, representing the extraction date and the row number, uniquely identify each row, providing a reliable method for tracking updates. When a row is updated, it registers the date when a new version of the row was extracted, enabling users to see when changes were made. If an end date is not provided, it signifies that the version is the most recent. The table also contains geographic information, which was originally in the shapefile format - a format used for storing geometric location and attribute information of geographic...
-
Version History of Base Table Rows in the Värmland Dataset CollectionTSV
This table is a historical record of geographical features sourced from 'Lantmäteriet' (The Land Survey of Sweden) website. It maintains a version history of its base table rows, with each row uniquely identified by a combination of a start date and a row number. The table contains information about when each row was extracted from the source data, along with the date when a new version of the row was extracted. If there is no end date, it indicates that the version of the row is the most recent. The table also includes geographical data, initially in the shapefile format, which has been transformed into the final geographic format. This format includes details such as the geometric location and attribute information of geographic features, which could be represented by points, lines,...
-
Version History of Base Table Rows in Varmland DatasetTSV
The table under discussion is a historical record, sourced from the website of Lantmäteriet (The Land Surveying Department) in Sweden. It keeps track of the version history of its base table rows, which is particularly useful for understanding the temporal changes in the data. Each row in the table can be uniquely identified by a specific combination of the date when the row was extracted from the data source and the number of the row in the raw data. The table also records the date when a new version of the row was extracted. If this date is not available, it indicates that the row is the most current version. The table also includes geographic information, transformed from the shapefile format. Shapefile is a standard format for storing geometric location and attribute information of...
-
Version History of Base Table Rows in Varmland DatasetTSV
The 'clc12_65d_nv__history' table is a historical data table belonging to the 'varmland' dataset collection. This table contains the version history of its base table rows, distinguishing it by the presence of two unique columns: the start date and the end date of the row extraction from the data source. The combination of the start date and row number uniquely identifies each row in this table. The table provides geographical data which initially was in the shapefile format. After transformation, this data now includes various geometric details such as location, area, length, and types of geographic features, which can be represented as points, lines, or polygons. The table also contains a unique object identifier, a remark, and a specific code for each entry. This table is sourced...
-
Version History of Base Table Rows in Varmland Dataset CollectionTSV
The table in focus is a historical table sourced from the web site of Lantmäteriet (The National Land Survey), based in Sweden. This history table serves a crucial purpose as it holds the version history of its primary table rows. This allows for the tracking of changes in data over time, from the point when the row was first extracted from the data source to the date when a newer version was sourced. The most recent version of the row can be identified if the end date is null. The rows in this table are uniquely identified by a combination of the start date and a specific row number. In addition to the base table, this history table has two extra columns that capture the start and end dates. One of the unique aspects of this table is its geographical data, initially in the shapefile...
-
Version History of Base Table Rows in Varmland Dataset CollectionTSV
The table under consideration is a history table that is part of a larger dataset collection. It originates from 'Lantmäteriet' (The National Land Survey), a website based in Sweden. This table contains a detailed record of the version history of its base table rows, making it immensely valuable for tracking changes over time. Each entry in the table is uniquely identified by a combination of the row number and the date the row data was extracted from the original source. The table includes additional columns, namely the start date and end date, which are not present in the base table. The start date refers to when the data was initially extracted, while the end date signifies when a new version of the row was introduced. A null value in the end date column indicates that the data in...
-
Version History of Geographic Features and Attributes in Värmland Dataset CollectionTSV
The 'clc12_65e_no__history' table is a historical dataset part of the 'varmland' collection. As a history table, it provides a record of the evolution of its associated base table over time. This is evidenced by the inclusion of two additional columns that track the start date and end date of each row's data extraction from the data source. The start date marks when a row was initially extracted, and the end date indicates when a new version of the row was extracted. When the end date is null, this signals that the row is the most recent version. Another unique aspect of this table is the '_row_number' column that provides the number of the row from the raw data, forming a unique identifier for each row in conjunction with the start date. This table also includes geographic data,...
Column Descriptions
Geospatial Characteristics and Area Measurements of Varmland Region
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It is one of the two columns that uniquely identify each row in the table. |
| _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. It is one of the two columns that uniquely identify each row in the table. |
| OBJECTID | long | This column contains the unique ID of the object. |
| ID | string | This column contains the identification number of the attribute. |
| CODE_12 | string | This column contains the 12-digit code of the attribute. |
| Area_Ha | double | This column represents the area of the attribute in hectares. |
| Remark | string | This column contains any additional remarks or notes related to the attribute. |
| Shape_Leng | double | This column represents the length of the shape of the attribute. |
| Shape_Area | double | This column represents the area of the shape of the attribute. |
| geom_geojson | string | This column contains the geometric shape of the attribute in GeoJSON format. |
| geom_geotext | string | This column contains the geometric shape of the attribute in text format. |
| geom_type | string | This column indicates the type of the geometric shape of the attribute. |
| geom_centroid | string | This column contains the centroid of the geometric shape of the attribute. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape of the attribute. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape of the attribute. |
Version History of Base Table Rows in Varmland Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | Contains the date when the row was extracted from the data source. Together with '_row_number', this column uniquely identifies each row in this history table. |
| _end_date | date | 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 | Represents the number of the row in the raw data extracted from the source. It forms a unique identifier for each row in conjunction with '_start_date'. |
| 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 the data entry. |
| Area_Ha | double | Represents the area of the geographical feature, measured in hectares. |
| Remark | string | A column for any additional observations or notes about the data entry. |
| Shape_Leng | double | The length of the shape of the geographical feature. |
| Shape_Area | double | The area of the shape of the geographical feature. |
| geom_geojson | string | Contains the geometric data of the geographical feature in GeoJSON format. |
| geom_geotext | string | Holds the geometric data of the geographical feature in a text format. |
| geom_type | string | Specifies the type of geometric data (for example, point, line, or polygon). |
| geom_centroid | string | Determines the geometric center (centroid) of the geographic feature. |
| geom_center_x | double | Represents the x-coordinate of the center of the geographic feature. |
| geom_center_y | double | Represents the y-coordinate of the center of the geographic feature. |
Geographical Attributes and Characteristics Collection
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It is one of the special columns in this table. |
| _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'. It is another special column in the table and in combination with '_extract_date', it uniquely identifies each row. |
| OBJECTID | long | This column represents the Object ID associated with each row of data. |
| ID | string | This column represents the unique identifier of each data entry. |
| CODE_12 | string | This column contains the 12-digit code associated with the data entry. |
| Area_Ha | double | This column represents the area in hectares for the data entry. |
| Remark | string | This column contains any additional remarks or comments regarding the data entry. |
| Shape_Leng | double | This column represents the length of the shape associated with the data entry. |
| Shape_Area | double | This column represents the area of the shape associated with the data entry. |
| geom_geojson | string | This column contains the GeoJSON geometry representation of the data entry. |
| geom_geotext | string | This column contains the text representation of the geographical data entry. |
| geom_type | string | This column represents the type of the geometry of the data entry. |
| geom_centroid | string | This column contains the centroid of the geometry of the data entry. |
| geom_center_x | double | This column represents the X coordinate of the center of the geometry of the data entry. |
| geom_center_y | double | This column represents the Y coordinate of the center of the geometry of the data entry. |
Version History of Base Table Rows in Varmland Dataset
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source, forming a unique combination with '_row_number' to identify 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. A null value indicates that the row is the latest version. |
| _row_number | long | The number of the row in the raw data extracted from the data source. It is combined with '_start_date' to uniquely identify each row in this version history table. |
| OBJECTID | long | The unique identifier of the object within the table. |
| ID | string | The unique identification number assigned to each row. |
| CODE_12 | string | The code associated with the data in the row. |
| Area_Ha | double | The area of the geographical object represented in the row, measured in hectares. |
| Remark | string | Any additional comments or notes associated with the row. |
| Shape_Leng | double | The length of the geographical object represented in the row. |
| Shape_Area | double | The area of the geographical object represented in the row. |
| geom_geojson | string | The geometric representation of the object in GeoJSON format. |
| geom_geotext | string | The geometric representation of the object in text format. |
| geom_type | string | The type of geometric shape that represents the object. |
| geom_centroid | string | The center point of the geometric shape that represents the object. |
| geom_center_x | double | The X coordinate of the center point of the geometric shape. |
| geom_center_y | double | The Y coordinate of the center point of the geometric shape. |
Geospatial Characteristics and Metrics of Land Parcels in Värmland Region
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It is part of a unique identifier for each row when combined with the '_row_number' column. |
| _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'. It forms part of a unique identifier for each row when combined with the '_extract_date' column. |
| OBJECTID | long | This column contains the object identification number. |
| ID | string | This column contains the identification number of the data row. |
| CODE_12 | string | This column contains the 12-digit code associated with the data row. |
| Area_Ha | double | This column represents the area of the geographical feature in hectares. |
| Remark | string | This column contains any remarks or comments associated with the data row. |
| Shape_Leng | double | This column represents the length of the shape or geographical feature. |
| Shape_Area | double | This column represents the area of the shape or geographical feature. |
| geom_geojson | string | This column contains the geographical data in GeoJSON format. |
| geom_geotext | string | This column contains the geographical data in a textual format. |
| geom_type | string | This column describes the type of the geographical feature, such as 'Point', 'LineString', 'Polygon', etc. |
| geom_centroid | string | This column contains the centroid of the geographical feature. |
| geom_center_x | double | This column represents the 'x' coordinate of the central point of the geographical feature. |
| geom_center_y | double | This column represents the 'y' coordinate of the central point of the geographical feature. |
Version History of Base Table Rows in the Värmland 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 the unique identifier for 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 source. It is part of the unique identifier for each row in this version history table. |
| OBJECTID | long | This column contains the unique identifier of the object in the table. |
| ID | string | This column holds an identification number associated with each object. |
| CODE_12 | string | This column contains specific codes associated with the objects in the table. |
| Area_Ha | double | This column represents the area of the object in hectares. |
| Remark | string | This column contains additional remarks or comments related to the object. |
| Shape_Leng | double | This column holds the length of the object's shape. |
| Shape_Area | double | This column holds the area of the object's shape. |
| geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of the object in text format. |
| geom_type | string | This column indicates the type of geometry used for representing the object. |
| geom_centroid | string | This column contains the centroid, or geometric center, of the object. |
| geom_center_x | double | This column holds the x-coordinate of the object's center. |
| geom_center_y | double | This column holds the y-coordinate of the object's center. |
Land Cover Classification and Geometric Data Analysis
| 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. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
| OBJECTID | long | This column represents a unique identifier for each object in the table. |
| ID | string | This column represents a unique identification number for each row in the table. |
| CODE_12 | string | This column represents a specific 12-digit code associated with each row. |
| Area_Ha | double | This column represents the area of the object, measured in hectares. |
| Remark | string | This column contains any additional remarks or comments related to the row. |
| Shape_Leng | double | This column represents the length of the shape of the object. |
| Shape_Area | double | This column represents the area of the shape of the object. |
| geom_geojson | string | This column contains the geometry of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the object as a text string. |
| geom_type | string | This column represents the type of the geometry of the object. |
| geom_centroid | string | This column represents the centroid of the geometry of the object. |
| geom_center_x | double | This column represents the x-coordinate of the center of the geometry of the object. |
| geom_center_y | double | This column represents the y-coordinate of the center of the geometry of the object. |
Version History of Geographic Features and Attributes in Värmland Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row was first extracted from the source data. 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 source data. 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 appears in the raw data extracted from the source. It is part of the combination that uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identification number for each record in the table. |
| CODE_12 | string | A code related to the 12th version of the data. The specific meaning of this code depends on the context of the data. |
| Area_Ha | double | The area of the geographical object described by the row, measured in hectares. |
| Remark | string | Any additional comments or observations about the data in the row. |
| Shape_Leng | double | The length of the shape of the geographical object described by the row. The specific unit of this measurement depends on the context of the data. |
| Shape_Area | double | The area of the shape of the geographical object described by the row. The specific unit of this measurement depends on the context of the data. |
| geom_geojson | string | The geographical data of the object described by the row, formatted in GeoJSON. |
| geom_geotext | string | The geographical data of the object described by the row, formatted as text. |
| geom_type | string | The type of the geographical object described by the row. |
| geom_centroid | string | The centroid, or geometric center, of the geographical object described by the row. |
| geom_center_x | double | The x-coordinate of the center of the geographical object described by the row. |
| geom_center_y | double | The y-coordinate of the center of the geographical object described by the row. |
Geospatial and Attribute Data for Land Features in Värmland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table 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 column '_extract_date'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row. |
| OBJECTID | long | This column contains the unique object identifier. |
| ID | string | This column contains the unique identification number. |
| CODE_12 | string | This column contains the 12-digit code associated with the data row. |
| Area_Ha | double | This column contains the area size in hectares. |
| Remark | string | This column contains any additional comments or remarks related to the data row. |
| Shape_Leng | double | This column contains the length of the shape represented by the data row. |
| Shape_Area | double | This column contains the area of the shape represented by the data row. |
| geom_geojson | string | This column contains the geometric data of the shape represented by the data row in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data of the shape represented by the data row in text format. |
| geom_type | string | This column specifies the type of the geometric data represented by the data row. |
| geom_centroid | string | This column contains the centroid of the geometric data represented by the data row. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric data represented by the data row. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric data represented by the data row. |
Version History of Base Table Rows in Varmland Dataset
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with the '_row_number' column, it forms a unique identifier for 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 indicates 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. Together with the '_start_date' column, it forms a unique identifier for each row in this version history table. |
| OBJECTID | long | This column contains the unique object identifier. |
| ID | string | This column contains the unique identifier. |
| CODE_12 | string | This column contains a specific code related to the data. |
| Area_Ha | double | This column contains the area measured in hectares. |
| Remark | string | This column contains any remarks or comments related to the row. |
| 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 geometric data in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data in text format. |
| geom_type | string | This column specifies the type of the geometric data. |
| geom_centroid | string | This column contains the centroid of the geometric shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape. |
Geospatial Data Collection with Land Features, Area, and Geometric Information
| 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. It works in combination with the '_extract_date' column to uniquely identify each row. |
| OBJECTID | long | This column holds the unique identifier for each object in the dataset. |
| ID | string | This column contains the identification number for each record in the dataset. |
| CODE_12 | string | This column contains specific codes that are associated with each record in the dataset. |
| Area_Ha | double | This column represents the area of each geographical feature in the dataset, measured in hectares. |
| Remark | string | This column contains any additional notes or comments related to each record in the dataset. |
| Shape_Leng | double | This column represents the length of each geographical feature in the dataset. |
| Shape_Area | double | This column represents the area of each geographical feature in the dataset. |
| geom_geojson | string | This column contains the geographical information for each record in the GeoJSON format. |
| geom_geotext | string | This column contains the geographical information for each record in text format. |
| geom_type | string | This column specifies the type of the geographical feature associated with each record (e.g., point, line, polygon). |
| geom_centroid | string | This column contains the geographical coordinates of the centroid (center point) for each geographical feature in the dataset. |
| geom_center_x | double | This column contains the x-coordinate of the center of each geographical feature in the dataset. |
| geom_center_y | double | This column contains the y-coordinate of the center of each geographical feature in the dataset. |
Historical Version Records of Varmland Collection
| Column | Type | Comment |
|---|---|---|
| _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. |
Spatial Characteristics and Geometrical Data of Varmland Region
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It is one of two columns that, in combination, uniquely identify each row. |
| _row_number | long | This column contains the row number in the data extracted from the source, corresponding to the extract date specified in the '_extract_date' column. It is one of two columns that, in combination, uniquely identify each row. |
| OBJECTID | long | This column contains the unique identifier for each object in the table. |
| ID | string | This column holds the ID for each entry in the table. |
| CODE_12 | string | This column contains the 12-digit code associated with each entry. |
| Area_Ha | double | This column represents the area of each entry in hectares. |
| Remark | string | This column contains any additional remarks or comments about each entry. |
| Shape_Leng | double | This column denotes the length of the shape associated with each entry. |
| Shape_Area | double | This column represents the area of the shape associated with each entry. |
| geom_geojson | string | This column contains the geometric data for each entry in GeoJSON format. |
| geom_geotext | string | This column holds the geometric data for each entry in a text format. |
| geom_type | string | This column specifies the type of geometric shape associated with each entry. |
| geom_centroid | string | This column contains the centroid of the geometric shape associated with each entry. |
| geom_center_x | double | This column indicates the X-coordinate of the center of the geometric shape associated with each entry. |
| geom_center_y | double | This column indicates the Y-coordinate of the center of the geometric shape associated with each entry. |
Historical Record of Versioned Base Table Rows in Varmland Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column indicates the date when the row was extracted from the data source. It is a critical field that, together with '_row_number', uniquely identifies each row in the version history table. |
| _end_date | date | This column represents the date when a new version of the row was extracted from the data source. If this field 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 appears in the raw data extracted from the data source. It is part of the unique identifier for each row in conjunction with '_start_date'. |
| OBJECTID | long | This column holds the unique identifier of the object in the data. |
| ID | string | This column contains the ID of the data entry. |
| CODE_12 | string | This column holds the 12-digit code associated with the data. |
| Area_Ha | double | This column represents the area in hectares. |
| Remark | string | This column contains any additional remarks or comments related to the data row. |
| Shape_Leng | double | This column stores the length of the shape. |
| Shape_Area | double | This column represents the area of the shape. |
| geom_geojson | string | This column contains the geographic data in GeoJSON format. |
| geom_geotext | string | This column contains geometric data in a text format. |
| geom_type | string | This column indicates the type of the geometric data. |
| geom_centroid | string | This column holds the centroid of the geometric data. |
| geom_center_x | double | This column stores the x-coordinate of the center of the geometric data. |
| geom_center_y | double | This column stores the y-coordinate of the center of the geometric data. |
Land Cover Classification Data Collection for Värmland Region
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the source. It is a special column that, in combination with the '_row_number' column, uniquely identifies each row. |
| _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. It is a special column that, in combination with the '_extract_date' column, uniquely identifies each row. |
| OBJECTID | long | This column contains the object identifier associated with each row of data. |
| ID | string | This column contains the unique identification number assigned to each data item. |
| CODE_12 | string | This column contains the 12-digit code associated with each object or data item. |
| Area_Ha | double | This column contains the area of the object or data item in hectares. |
| Remark | string | This column contains additional information or remarks about the object or data item. |
| Shape_Leng | double | This column contains the length of the shape or object represented by the data item. |
| Shape_Area | double | This column contains the area of the shape or object represented by the data item. |
| geom_geojson | string | This column contains the geometric representation of the object or data item in GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of the object or data item in a textual format. |
| geom_type | string | This column specifies the type of geometric shape associated with the object or data item. |
| geom_centroid | string | This column contains the centroid, or geometric center, of the object or data item. |
| geom_center_x | double | This column contains the x-coordinate of the geometric center of the object or data item. |
| geom_center_y | double | This column contains the y-coordinate of the geometric center of the object or data item. |
Version History of Base Table Rows in the Varmland Dataset 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 identifier in combination with the '_row_number' column. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. A null value indicates 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 identifier in combination with the '_start_date' column. |
| OBJECTID | long | This column contains the object identifier. |
| ID | string | This column contains the id of the object in the base table. |
| CODE_12 | string | This column contains a 12-digit code associated with the object. |
| Area_Ha | double | This column contains the area of the object in hectares. |
| Remark | string | This column contains any remarks associated with the object. |
| Shape_Leng | double | This column contains the length of the shape of the object. |
| Shape_Area | double | This column contains the area of the shape of the object. |
| geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of the object in a textual format. |
| geom_type | string | This column contains the type of the geometric representation of the object. |
| geom_centroid | string | This column contains the centroid of the geometric representation of the object. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometric representation of the object. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometric representation of the object. |
Geospatial and Property Information of Varmland Region
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column represents the date when the data in the row was extracted from the original data source. |
| _row_number | long | This column indicates the row number in the data extracted from the source on the specified extract date. This, in combination with '_extract_date', uniquely identifies each row. |
| OBJECTID | long | This column is reserved for the unique identifier of the object in the dataset. |
| ID | string | This column is used for storing the ID of the data point. |
| CODE_12 | string | This column is used for storing the 12-digit code associated with the data point. |
| Area_Ha | double | This column represents the area of the data point in hectares. |
| Remark | string | This column is used for storing any remarks or additional information about the data point. |
| Shape_Leng | double | This column represents the length of the shape of the data point. |
| Shape_Area | double | This column represents the area of the shape of the data point. |
| geom_geojson | string | This column stores the GeoJSON representation of the geographical location of the data point. |
| geom_geotext | string | This column stores the textual description of the geographical location of the data point. |
| geom_type | string | This column stores the type of geographical entity represented by the data point. |
| geom_centroid | string | This column stores the centroid of the geographical entity represented by the data point. |
| geom_center_x | double | This column represents the x-coordinate of the center of the geographical entity. |
| geom_center_y | double | This column represents the y-coordinate of the center of the geographical entity. |
Version History of Base Table Rows in Varmland Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for 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 indicates 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 identifier for each row in conjunction with '_start_date'. |
| OBJECTID | long | This column contains an object identifier, which is a unique identifier for the object. |
| ID | string | This column holds the ID of the object. |
| CODE_12 | string | This column contains a 12-digit code associated with the object. |
| Area_Ha | double | This column contains the area of the object in hectares. |
| Remark | string | This column includes any additional remarks or comments about the object. |
| Shape_Leng | double | This column contains the length of the shape of the object. |
| Shape_Area | double | This column holds the area of the shape of the object. |
| geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geometric representation of the object in geotext format. |
| geom_type | string | This column indicates the type of the geometric representation of the object. |
| geom_centroid | string | This column contains the centroid of the geometric representation of the object. |
| geom_center_x | double | This column contains the X-coordinate of the center of the geometric representation of the object. |
| geom_center_y | double | This column contains the Y-coordinate of the center of the geometric representation of the object. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | August 27, 2024 |