Comprehensive Collection of Related Tables for Advanced Data Analysis
Tables
-
Geographical and Geometrical Data Collection with Specific AttributesTSV
The table in focus is part of a larger dataset collection and contains geographical data from Sweden, specifically sourced from the website of Lantmäteriet, the Swedish mapping, cadastral and land registration authority. This table encapsulates a variety of information, including unique identifiers for each data entry, specific codes, area measurements in hectares, comments, and detailed geographic data transformed from the original shapefile format. The geographic data covers a range of attributes including geographic type, centroid, center coordinates, and geojson and geotext formats. Two distinctive columns in this table are the extract date and row number. The extract date indicates when the data for the specific row was collected from the source, and the row number is a unique...
-
Geographical Features and Area Calculation Data Table from SwedenTSV
The table in consideration is a comprehensive collection of geographic data, sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. This table is part of a larger dataset collection, housing one or multiple such tables. The table contains a variety of columns, each representing unique information about the geographical data in focus. Two special columns serve the purpose of data identification. These columns contain the date of data extraction and the row number of the extracted data, serving as a unique identifier for each row. Geographic information in the table is presented in a final geographic format which originated from a shapefile format, a common method for storing geometric location and attribute information of geographic features. This table could prove to be a...
-
Geometric and Area Analysis of Landscape ChangesTSV
The table in question is part of a larger dataset collection and originates from Lantmäteriet (The Land Survey of Sweden). This table provides a wealth of data, from identifiers and codes to remarks and geographic information. It features a unique system of identification for each row, using a combination of the date of data extraction and the row number from the original data source. This ensures each row is distinct and easily traceable back to its origin. The geographic data within the table was originally in shapefile format, a common geographical information system format, but has been transformed into a final geographic format for ease of use. The data in this table can be utilized in many ways. For instance, analysis of the change data could provide insights into geographical or...
-
Geospatial Characteristics and Area Details of Land ParcelsTSV
This table originates from the 'Lantmäteriet' website based in Sweden. It is a part of a larger dataset collection and is primarily organized around geographic information, which has been derived from a shapefile format, in line with the standard of storing geometric location and attribute information of geographic features. The table encompasses a variety of columns, each serving a distinct purpose in providing a comprehensive view of the data. Two special columns in the table offer a unique identification for each row, one containing the date of data extraction, and the other noting the row number from the extracted data. The table also contains geographic information, including details about specific objects, their area, remarks, and their geometric properties such as length, area,...
-
Historical Version Records of Base Table Rows CollectionTSV
The 'clc12_62f_sv__history' table is a historical record of associated base table rows, sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. This history table is a part of the 'kalmar' dataset collection and it carries additional temporal information in comparison with its base table, including the dates of extraction and subsequent updates for each row of data. A unique identifier for each row is formed by combining the extraction date and row number. If a row is the most recent version, it is denoted by a null value in the 'end date' column. The geographic information in this table, originally in shapefile format, has been transformed into a final geographic format. This allows for the representation of geographic features as points, lines, or polygons (areas). This...
-
Historical Versioning Records of Base Table Rows in Kalmar Dataset CollectionTSV
The 'cha_62fno__history' table is a history table, part of the 'kalmar' dataset collection. This history table captures the version history of its base table rows, providing a comprehensive timeline of changes over time. It records important information such as the date when a row was extracted from the data source and the date when a new version of the row was extracted. A special feature of this table is that it has two additional columns compared to its base table, which allow the tracking of the start and end dates of each row version. If an end date is not present, it indicates that the row is the most recent version. In terms of geographic data, this table includes information transformed from the shapefile format, a common format for storing geometric location and attribute...
-
Land Classification Information with Geometric DataTSV
The table in consideration is a comprehensive collection of geographical data, meticulously organized and obtained from 'Lantmäteriet' of Sweden. This table is a part of a larger dataset and is primarily focused on geographical information in the form of geographic features. The data within the table has been extracted from the original data source and transformed into a more usable format from the initial shapefile format. Each row of the table represents a unique set of data, distinguished by a specific extraction date and a row number. This combination serves as a unique identifier for each row, ensuring accuracy and consistency in data representation. The data within this table covers several aspects, such as object identification, area measurements, remarks, and geometric data....
-
Swedish Land Survey Data: Changes in Geospatial AttributesTSV
The 'cha_62fno' table is a detailed collection of geographic and related data, meticulously sourced from the 'Lantmäteriet' website in Sweden. The table features a multitude of columns that contain diverse information, all organized in a structured manner. Two key columns in this table include the extract date and the row number, both of which work in tandem to uniquely identify each row of data. This allows for precise tracking of data extraction and its source row, providing a reliable reference point for any subsequent data analysis. The table also encompasses geographic data transformed from shapefile format, a common format for storing geometric location and attribute information. This implies that the data stored can include a variety of geographic features represented by points,...
-
Swedish Land Survey Geospatial Dataset: An Extensive Collection of Attributes and Geometric PropertiesTSV
The table is a meticulously organized collection of data that has been sourced from the 'Lantmäteriet' website, based in Sweden. It contains a unique blend of information, including the extraction date for each data entry and the corresponding row number. These details, when combined, serve as a unique identifier for each row in the table. The data also includes geographical information, initially in the shapefile format, which has been transformed into the final geographic format. This geographic data can represent features as points, lines, or polygons (areas). The table is a part of a broader dataset collection, which could contain one or several similar tables. In terms of data analytics, this table can be instrumental in various ways. For instance, the geographic information can...
-
Version History of Base Table Rows in Kalmar Dataset CollectionTSV
The table in question is a history table, part of the 'Kalmar' dataset collection. It is a comprehensive record of changes made to the base table. Each row in this table is unique, distinguished by a combination of the date when the row was extracted and the row number from the raw data. This table also includes two extra columns compared to the base table, capturing the start and end date of each row version. If the end date is null, it indicates that the current row version is the most recent. This table also contains geographical location and attribute details of geographic features, transformed from the original shapefile format. The data is sourced from the website of 'Lantmäteriet' in Sweden. The data in this table can be utilized in numerous ways for data analytics. For example,...
-
Version History of Base Table Rows in Kalmar Dataset CollectionTSV
The table in consideration is a historical record, part of a dataset collection. It meticulously tracks the version history of its base table rows. Unique identifiers for each row in this version history table are composed of two elements: the date of extraction and the row number from the raw data. The table also indicates the date when a new version of the row was extracted. If there's no end date, it implies that the version of the row is the most recent one. The data within this table encompasses a wide range of information, including geographic specifics. These geographic details, originally in shapefile format, have been transformed into the final geographic format. Shapefiles, a standard for storing geographic location and attribute info, can represent features as points, lines,...
-
Version History of Base Table Rows in Swedish Dataset CollectionTSV
The 'clc12_62g_nv__history' table is a historical record of a set of geographic features, sourced from Sweden's Lantmäteriet website. This history table is part of the 'kalmar' dataset collection and it contains the version history of its base table rows. The table is uniquely organized by a combination of the start date and the row number. The start date indicates when the row was extracted from the data source, while the row number pertains to the position of the row in the raw data. The end date is also provided, showcasing when a new version of the row was extracted. If the end date is null, it implies that the current row is the most recent version. The table includes geographic information transformed from the shapefile format, which is a simple format for storing the geometric...
-
Version History of Base Table Rows in the Kalmar Dataset CollectionTSV
The 'cha_62fso__history' table is a significant component of the 'kalmar' dataset collection. It holds the version history of its base table rows, which is crucial for tracking changes over time. Each row in this table is uniquely identified by a specific combination of its row number and the date it was extracted from the data source. The table also includes the start and end dates of each row's validity. If the end date of a row is null, it indicates that the row's version is the most recent one. The table also contains additional geographic information, which has been transformed from the shapefile format into a more usable format. This geographic data provides detailed location and attribute information of geographic features which can be represented by points, lines, or polygons....
-
Version History Records of Base Table Rows in Kalmar CollectionTSV
The 'clc12_62f_nv__history' table is a historical data table, part of the 'kalmar' dataset collection, offering a version history of its base table rows. Each row in this table is unique, identified by a combination of the start date of data extraction and the row number from the raw data. This ensures an accurate record of changes over time. It chronicles the period from the date the row was first extracted from the data source, up until when a new version was extracted, represented by start and end dates. When the end date is null, it signifies that the row is the most recent version. The table also contains geographical information, which originates from a shapefile format and has been transformed into the final geographic format. This geographic data can be represented by points,...
Column Descriptions
Geographical Features and Area Calculation Data Table from Sweden
| 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 column '_extract_date'. It helps in uniquely identifying each row. |
| OBJECTID | long | This column contains the object identifiers. |
| ID | string | This column holds the unique identification number for each entry in the dataset. |
| CODE_12 | string | This column consists of the 12-digit codes. |
| Area_Ha | double | This column represents the area in hectares. |
| Remark | string | This column contains any additional comments or 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 holds the geographic data in GeoJSON format. |
| geom_geotext | string | This column holds the geographic data in Geotext format. |
| geom_type | string | This column describes the type of the geometry. |
| geom_centroid | string | This column contains the centroid of the geometry. |
| geom_center_x | double | This column holds the x-coordinate of the center of the geometry. |
| geom_center_y | double | This column holds the y-coordinate of the center of the geometry. |
Version History of Base Table Rows in Kalmar Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the row was extracted from the data source. This column, along with '_row_number', 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 of this column 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. This column, along with '_start_date', uniquely identifies each row in this version history table. |
| OBJECTID | long | The unique identifier of the object. |
| ID | string | The unique identifier of the data entry. |
| CODE_12 | string | A code associated with the data entry. |
| Area_Ha | double | Area of the geographical object in hectares. |
| Remark | string | A column for any remarks or notes related to the row. |
| Shape_Leng | double | The length of the geographical shape associated with the data entry. |
| Shape_Area | double | The area of the geographical shape associated with the data entry. |
| geom_geojson | string | The geographical shape associated with the data entry in GeoJSON format. |
| geom_geotext | string | The geographical shape associated with the data entry in geotext format. |
| geom_type | string | The type of the geographical shape associated with the data entry. |
| geom_centroid | string | The geographical center, or centroid, of the geographical shape associated with the data entry. |
| geom_center_x | double | The x-coordinate of the geographical center of the shape. |
| geom_center_y | double | The y-coordinate of the geographical center of the shape. |
Swedish Land Survey Data: Changes in Geospatial Attributes
| 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 specified by the column '_extract_date'. |
| ID | string | The unique identifier of the data row. |
| CODE_06 | string | The code 06 associated with the data row. |
| CODE_12 | string | The code 12 associated with the data row. |
| Change | string | The change status of the data row. |
| ChType | string | The type of the change status of the data row. |
| Remark | string | The remark or note associated with the data row. |
| Area_Ha | double | The area in hectares associated with the data row. |
| Shape_Leng | double | The length of the shape associated with the data row. |
| Shape_Area | double | The area of the shape associated with the data row. |
| geom_geojson | string | The geometric representation of the data row in GeoJSON format. |
| geom_geotext | string | The geometric representation of the data row in geotext format. |
| geom_type | string | The type of the geometric representation of the data row. |
| geom_centroid | string | The centroid of the geometric representation of the data row. |
| geom_center_x | double | The x-coordinate of the center of the geometric representation of the data row. |
| geom_center_y | double | The y-coordinate of the center of the geometric representation of the data row. |
Historical Versioning Records of Base Table Rows in Kalmar 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 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 of this column 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 that uniquely identifies each row in this version history table. |
| ID | string | This column contains the unique identifiers for the rows in the table. |
| CODE_06 | string | This column contains the CODE_06 values in the table. |
| CODE_12 | string | This column contains the CODE_12 values in the table. |
| Change | string | This column contains information about any changes in the table rows. |
| ChType | string | This column contains information about the type of changes in the table rows. |
| Remark | string | This column contains any remarks or comments regarding the table rows. |
| Area_Ha | double | This column contains data about the area (in hectares) relevant to the table rows. |
| Shape_Leng | double | This column contains information about the length of the shapes associated with the table rows. |
| Shape_Area | double | This column contains information about the area of the shapes associated with the table rows. |
| geom_geojson | string | This column contains the geometrical data in GeoJSON format. |
| geom_geotext | string | This column contains the geometrical data in text format. |
| geom_type | string | This column contains information about the type of the geometrical data. |
| geom_centroid | string | This column contains the centroid of the geometrical data. |
| geom_center_x | double | This column contains the X coordinate of the center of the geometrical data. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geometrical data. |
Geospatial Characteristics and Area Details of Land Parcels
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date on which the data in each row was extracted from the source. |
| _row_number | long | This column holds the row number in the data that was extracted from the source on the extraction date specified in the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row. |
| OBJECTID | long | This column contains the object ID. |
| ID | string | This column holds the ID. |
| CODE_12 | string | This column holds the 12th code. |
| Area_Ha | double | This column contains the area in hectares. |
| Remark | string | This column contains any 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 holds 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 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's center. |
| geom_center_y | double | This column contains the Y coordinate of the geometry's center. |
Historical Version Records of Base Table Rows Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was first extracted from the data source. Together with '_row_number', it uniquely identifies each row in this 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 the value of this column is null, it indicates 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 forms a unique identifier for each row in combination with '_start_date'. |
| OBJECTID | long | This column holds the object ID of the row. |
| ID | string | This column contains the ID of the row. |
| CODE_12 | string | This column contains the 12-digit code associated with the row. |
| Area_Ha | double | This column represents the area in hectares. |
| Remark | string | This column holds any remarks or comments related to the row. |
| Shape_Leng | double | This column contains the length of the shape associated with the row. |
| Shape_Area | double | This column represents the area of the shape associated with the row. |
| geom_geojson | string | This column holds the geometric data of the shape associated with the row in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data of the shape associated with the row in text format. |
| geom_type | string | This column describes the type of the geometric shape associated with the row. |
| geom_centroid | string | This column holds the centroid of the geometric shape associated with the row. |
| geom_center_x | double | This column contains the X-coordinate of the center of the geometric shape associated with the row. |
| geom_center_y | double | This column contains the Y-coordinate of the center of the geometric shape associated with the row. |
Geometric and Area Analysis of Landscape Changes
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column holds the date when the row data 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'. |
| ID | string | This column contains unique identifiers for each record in the table. |
| CODE_06 | string | This column holds specific codes that pertain to the data. The meaning and use of these codes can vary based on the context of the data. |
| CODE_12 | string | This column also contains different codes related to the data. As with 'CODE_06', the usage of these codes is context-dependent. |
| Change | string | This column indicates any changes that have been made to the record or data. |
| ChType | string | This column describes the type of changes that have been made to the record or data. |
| Remark | string | This column is for any additional comments or remarks about the record or data. |
| Area_Ha | double | This column indicates the area in hectares associated with the record or data. |
| Shape_Leng | double | This column contains the length of the shape associated with the record or data. |
| Shape_Area | double | This column indicates the area of the shape related to the record or data. |
| geom_geojson | string | This column contains the geometric data of the record in GeoJSON format. |
| geom_geotext | string | This column holds the textual representation of the geometric data related to the record. |
| geom_type | string | This column specifies the type of geometric data associated with the record. |
| geom_centroid | string | This column contains the centroid of the geometric data associated with the record. |
| geom_center_x | double | This column specifies the x-coordinate of the center of the geometric data related to the record. |
| geom_center_y | double | This column indicates the y-coordinate of the center of the geometric data related to the record. |
Version History of Base Table Rows in the Kalmar Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | Contains the date when the row data was extracted from the data source. It forms a unique identifier in combination with '_row_number'. |
| _end_date | date | Contains the date when a new version of the row data 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 data source. It forms a unique identifier in combination with '_start_date'. |
| ID | string | A unique identifier for each row in the table. |
| CODE_06 | string | A code value associated with the data row under the column 'CODE_06'. |
| CODE_12 | string | A code value associated with the data row under the column 'CODE_12'. |
| Change | string | Indicates the changes that have been made to the base table row version. |
| ChType | string | Represents the type of change that has been made to the base table row version. |
| Remark | string | Contains any additional remarks or comments about the data row. |
| Area_Ha | double | Specifies the area of the geographical feature represented in the data row, measured in hectares. |
| Shape_Leng | double | Indicates the length of the geographical shape associated with the data row. |
| Shape_Area | double | Specifies the area of the geographical shape associated with the data row. |
| geom_geojson | string | Contains the geographical data of the feature in GeoJSON format. |
| geom_geotext | string | Contains the geographical data of the feature in geotext format. |
| geom_type | string | Specifies the type of the geographical feature represented in the data row. |
| geom_centroid | string | Indicates the centroid of the geographical feature associated with the data row. |
| geom_center_x | double | Represents the X coordinate of the center of the geographical feature. |
| geom_center_y | double | Represents the Y coordinate of the center of the geographical feature. |
Swedish Land Survey Geospatial Dataset: An Extensive Collection of Attributes and Geometric Properties
| 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 unique identifiers for each object in the dataset. |
| ID | string | This column holds the identification number for each data entry. |
| CODE_12 | string | This column contains specific codes that are associated with the data entries. |
| Area_Ha | double | This column displays the area of the object in hectares. |
| Remark | string | This column contains any additional comments or notes about the data entry. |
| Shape_Leng | double | This column contains the calculated length of the geometric shape associated with the data entry. |
| Shape_Area | double | This column provides the calculated area of the geometric shape associated with the data entry. |
| geom_geojson | string | This column contains the GeoJSON representation of the geometric shape associated with the data entry. |
| geom_geotext | string | This column holds the textual representation of the geometric shape associated with the data entry. |
| geom_type | string | This column specifies the type of geometric shape associated with the data entry. |
| geom_centroid | string | This column contains the centroid of the geometric shape associated with the data entry. |
| geom_center_x | double | This column contains the X-coordinate of the geometric shape's center point. |
| geom_center_y | double | This column contains the Y-coordinate of the geometric shape's center point. |
Version History Records of Base Table Rows in Kalmar Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column records the date when the respective row was extracted from the data source. It is part of a unique identifier for each row in this version history table, in combination with the '_row_number' column. |
| _end_date | date | This column logs the date when a new version of the respective 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 as it appears in the raw data extracted from the data source. It forms a part of the unique identifier for each row in the table, in combination with the '_start_date' column. |
| OBJECTID | long | This column is likely to contain the unique identifier for each object in the dataset. |
| ID | string | This column is likely to contain an additional identification value for each row in the table. |
| CODE_12 | string | The purpose of this column is not fully clear without additional context, but it likely contains some form of classification or coding related to the data. |
| Area_Ha | double | This column presumably contains the area of an object or region, likely measured in hectares. |
| Remark | string | This column probably contains additional notes or comments related to the respective row. |
| Shape_Leng | double | This column probably records the length of the boundary of a geographical shape or area. |
| Shape_Area | double | This column is likely to contain the area of a geographical shape, probably in a specific unit of measurement. |
| geom_geojson | string | This column likely contains geographical data in the GeoJSON format, a common open standard format designed for representing simple geographical features. |
| geom_geotext | string | This column may contain geographical data in a text format. |
| geom_type | string | This column presumably identifies the type of the geographical object or shape, such as 'polygon' or 'point'. |
| geom_centroid | string | This column probably refers to the geographical coordinates of the centroid, or geometric center, of a shape or object. |
| geom_center_x | double | This column likely represents the X coordinate of the center of a geographical object or shape. |
| geom_center_y | double | This column likely represents the Y coordinate of the center of a geographical object or shape. |
Land Classification Information with Geometric Data
| 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 | An identifier for an object in the table. |
| ID | string | A unique identifier for each data entry in the table. |
| CODE_12 | string | A code associated with the data entry. |
| Area_Ha | double | The area associated with the data entry, measured in hectares. |
| Remark | string | Additional notes or comments on 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 representation of the data entry in GeoJSON format. |
| geom_geotext | string | The geometric representation of the data entry in text format. |
| geom_type | string | The type of geometric shape associated with the data entry. |
| geom_centroid | string | The centroid of the geometric shape associated with the data entry. |
| geom_center_x | double | The x-coordinate of the center of the geometric shape associated with the data entry. |
| geom_center_y | double | The y-coordinate of the center of the geometric shape associated with the data entry. |
Version History of Base Table Rows in Kalmar Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The date when the version of the row was extracted from the data source. |
| _end_date | date | The date when a new version of the row was extracted from the data source. If 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 '_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 | An identification number for each data entry. |
| CODE_12 | string | A code associated with the data. |
| Area_Ha | double | The area of the object, measured in hectares. |
| Remark | string | Any notes or comments associated with the data entry. |
| Shape_Leng | double | The length of the shape of the object. |
| Shape_Area | double | The area of the shape of the object. |
| 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 the geometric object. |
| geom_centroid | string | The centroid of the geometric object. |
| geom_center_x | double | The X coordinate of the center of the geometric object. |
| geom_center_y | double | The Y coordinate of the center of the geometric object. |
Geographical and Geometrical Data Collection with Specific Attributes
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column holds the date when the data on the row was extracted from the data source. |
| _row_number | long | This column holds the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
| OBJECTID | long | This column holds the unique identifier for each object in the table. |
| ID | string | This column holds the identification number for each row of data. |
| CODE_12 | string | This column holds the 12-digit code associated with each row of data. |
| Area_Ha | double | This column holds the area measurement of the geographical object, in hectares. |
| Remark | string | This column holds any additional remarks or comments about the data in the row. |
| Shape_Leng | double | This column holds the length of the geographical object's shape. |
| Shape_Area | double | This column holds the area of the geographical object's shape. |
| geom_geojson | string | This column holds the geographical object's shape in a GeoJSON format. |
| geom_geotext | string | This column holds the geographical object's shape in a textual format. |
| geom_type | string | This column holds the type of the geographical shape (e.g., point, line, polygon). |
| geom_centroid | string | This column holds the centroid of the geographical object's shape. |
| geom_center_x | double | This column holds the x-coordinate of the geographical object's center. |
| geom_center_y | double | This column holds the y-coordinate of the geographical object's center. |
Version History of Base Table Rows in Swedish 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 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 of this column 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 combination with '_start_date'. |
| OBJECTID | long | This column contains the object identifier for each row. |
| ID | string | This column contains the unique identification number for each row. |
| CODE_12 | string | This column contains a code associated with each row. |
| Area_Ha | double | This column contains the area measurement (in hectares) associated with each row. |
| Remark | string | This column contains any remarks or comments associated with each row. |
| Shape_Leng | double | This column contains the length of the shape associated with each row. |
| Shape_Area | double | This column contains the area of the shape associated with each row. |
| geom_geojson | string | This column contains the geometric data in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data in textual format. |
| geom_type | string | This column contains the type of geometry. |
| geom_centroid | string | This column contains the centroid (geometric center) of the shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | August 26, 2024 |