Comprehensive Collection of Related Tables Sourced from Sweden
Tables
-
Geographical and Geometrical Data Collection for Land Survey AnalysisTSV
The table in question is a geographically rich dataset that originates from 'Lantmäteriet' (The Land Survey) in Sweden. It contains a variety of columns that store data extracted from a data source, each identified uniquely by a combination of extraction date and row number. The geographic information it holds, initially in shapefile format, has been transformed into a final geographic format, allowing it to represent geographic features as points, lines, or polygons (areas). This dataset offers a plethora of possibilities for data analytics. For instance, you could use the geographic data to analyze spatial patterns, trends, or anomalies over time, or make use of the extraction date and row number to track changes in the dataset or identify discrepancies. The table's detailed...
-
Geographical and Geometrical Data Collection in SwedenTSV
The table is a structured collection of data, originating from 'Lantmäteriet' (The Land Survey of Sweden). It contains a variety of information, including unique identifiers, codes, area measurements in hectares, remarks, and substantial geographic data. The geographic data was originally in shapefile format, a format used for storing the geometric location and attribute information of geographic features, and has been transformed into its final format for this dataset. Each row in the table is uniquely identified by a combination of extraction date and row number, indicating when the data was obtained and its position in the original extraction. As for its application in data analytics, this table could be used in numerous ways. For example, the area measurements could be analyzed in...
-
Geographical and Geometrical Information Analysis DataTSV
The table under discussion is a rich collection of geographical data, sourced from Lantmäteriet (The Land Survey), a website based in Sweden. The data in this table is organized meticulously with several columns, each containing unique information. Two key columns in the table provide the date of data extraction and the row number from the original data source, together forming a unique identifier for each row. This table also includes geographic information transformed from the shapefile format, which is a standard for storing geographical location and attribute information. The geographic data can represent various features such as points, lines, or polygons (areas). Given the nature of the data, there are several potential applications for data analytics. For instance, the data...
-
Geospatial Data Analysis of Land Objects in SwedenTSV
The table under discussion is a compendium of related data sourced from the Swedish website, 'Lantmäteriet' (The Land Survey). It is organized in a structured format comprising rows and columns. The table is a constituent of a larger dataset collection and is distinctively identified by a combination of two special columns: 'Extract Date' and 'Row Number'. The 'Extract Date' column contains the date the data on the row was extracted from the source while the 'Row Number' is indicative of the row's number in the data extracted on a specific date. The unique combination of these two columns serves to uniquely identify each row in the table. The data within this table is rich in geographic information, having been transformed from the shapefile format. This format is a simple,...
-
Geospatial Data Collection with Area Metrics, Identification Codes and Geometric FeaturesTSV
This table is a key component of a larger dataset, sourced from the Swedish website 'Lantmäteriet' (National Land Survey). It hosts a variety of data, organized in a structured manner across multiple columns and rows. Each row of data is distinct and can be uniquely identified using a combination of the extraction date and the row number from the original source. This ensures that each data entry can be traced back to the specific date of extraction, thus maintaining the integrity and traceability of the data. The table incorporates a significant amount of geographic information that has been converted from the shapefile format, a standard for storing geographical features and their attributes. This geographic data is represented in various ways, including points, lines, or polygons...
-
Geospatial Data with Area, Shape and Object DetailsTSV
The table under discussion is part of a dataset collection and is obtained from 'Lantmäteriet' (The Land Survey), a website based in Sweden. This table contains a wealth of information, including geographical data that has been converted from the shapefile format, a format used for storing the geometric location and attribute information of geographic features. Two key aspects of this table are the extract date and the row number. The extract date indicates when the data for that particular row was extracted from the source, while the row number pertains to the position of the data in the extracted source. The combination of these two elements uniquely identifies each row in the table. In the realm of data analytics, there are numerous ways this table could be used. For instance, by...
-
Historical Versioning Data of Base Table Rows in Orebro Dataset CollectionTSV
The table under consideration is a history table that belongs to a dataset collection. It serves as a comprehensive record of version histories for each data row, allowing for easy tracking of changes over time. The unique identifier for each row in the table is a combination of the date of extraction and the row number from the raw data. This table provides a rich source of data for temporal analyses and can be particularly useful for examining how specific data points have evolved. The table possesses additional columns for tracking the start and end dates of each row's extraction from the data source. If a row's end date is null, this indicates that the row is the most recent version. The table also contains geographical data, which has been transformed from the shapefile format....
-
History of Version Changes in Land Classification RecordsTSV
The table in question is a historical record that tracks the evolution of its base table over time. Each row within the table is uniquely identified by a combination of a start date and a row number, which denotes the number of the row in the raw data from the data source. The table is equipped with a start and end date for each row, indicating when the data was extracted and when a new version of the row was pulled from the source. If the end date is null, it indicates that the row is the most recent version. Geographic information is also included in the table, originally sourced in shapefile format - a common system for storing geographic location and feature data. This information has been transformed into a final geographic format from its original shapefile state. The data for...
-
Land Classification and Geometric Data - Orebro CollectionTSV
The table under consideration is a structured collection of related data, organized into rows and columns. This table is part of a larger dataset. It is sourced from the website of Lantmäteriet (The National Land Survey) in Sweden. It encompasses various aspects including an object's identity, its specific code, the area it covers in hectares, any remarks about it, the length of its shape, and the area of its shape. The table also contains geographical information, which has been converted from the shapefile format to a final geographical format. Two special columns in the table record the date of data extraction and corresponding row number, which together uniquely identify each row. This table could be leveraged in several ways for data analytics. For instance, the area-related data...
-
Land Classification and Geometric Information Dataset Table from SwedenTSV
This table comes from the 'Lantmäteriet' website, located in Sweden. It features a wide range of data, each row of which is uniquely identified by a combination of the extract date and row number from the original data source. This ensures the data's integrity and traceability. The table contains various geographic information, transformed from the shapefile format, which is a standard for storing geometric location and attribute information of geographic features. These features can be represented by points, lines, or polygons (areas). This is particularly useful for any analysis that requires spatial data or geographic coordinates. For example, the data in this table could be used in spatial analytics to understand geographical patterns and trends. It could also be used in...
-
Version History of Base Table Rows from a Swedish Geospatial Dataset CollectionTSV
The table in focus is a historical record of a base table, providing a version history of all its rows. It originates from the 'Lantmäteriet' (Land Survey) website in Sweden. This table carries additional features compared to its base table - the introduction of a start date and an end date. The start date denotes when a row was initially extracted from the data source, while the end date signifies when a newer version of that row was extracted. If the end date is not specified, it indicates that the row is the most recent version. The table includes unique identifiers for each row, formed by combining the start date and the row number from the raw data. It also hosts geographic information, originally in shapefile format, but has since been transformed into a final geographic format....
-
Version History of Base Table Rows in Orebro Dataset CollectionTSV
The 'clc12_65f_sv__history' table is a significant part of the 'orebro' dataset collection. It is a history table, which means it contains the version history of its base table rows. This table is unique due to its ability to track changes over time, through the use of two additional columns compared to its base table. These columns represent the start and end date of when each row was extracted from the data source. This allows for the identification of the most recent version of a row, which can be identified if the end date column has a null value. Another distinguishing feature of this table is its usage of the row number from the raw data extracted from the data source, which in combination with the start date, uniquely identifies each row in this version history table. The table...
-
Version History of Base Table Rows in Orebro Dataset from a Swedish SourceTSV
The 'clc12_65e_so__history' table is part of the 'orebro' dataset collection. This is a historical table that maintains the version history of its base table rows. It contains data on the geographic features of a particular region, sourced from the website of 'Lantmäteriet' (The Land Survey) in Sweden. The data is organized into various columns that capture specific attributes of each entry. Two of these columns, one containing the date the row was extracted from the source and the other containing the row number, form a unique identifier for each row in this history table. Another column indicates the date when a new version of the row was extracted from the source. If this column's value is null, it means that the row is the most recent version. The table also features several...
-
Version History of Base Table Rows in Örebro Dataset CollectionTSV
The 'clc12_66e_so__history' table is a historical table that forms part of the 'orebro' dataset collection. It originates from the 'Lantmäteriet' website, based in Sweden. This table is unique in that it contains the version history of its base table rows. This is made possible by two additional columns that record the start and end dates of each row's extraction from the data source. A unique identifier for each row is created through the combination of the start date and the row number. If the end date of a row is null, it signifies that this is the most recent version of the row. The table also contains geographic data, initially in shapefile format, which has been transformed into a final geographic format. Shapefile is a format for storing the location and attribute information of...
-
Version History of Base Table Rows in Örebro Dataset CollectionTSV
The table under consideration is a history table, part of a dataset collection, which maintains the version history of its base table rows. The table is unique in its ability to track changes over time, serving as an important resource for data analysts who need to understand how data evolves. Each row in the table is uniquely identified by a combination of a start date and a row number, offering a precise way to track individual records. This table contains a wide range of data, including geographic information transformed from the shapefile format. A shapefile is a popular method for storing geographic features such as points, lines, or polygons. Therefore, the geographic data in this table can be extensive and complex, capable of representing a variety of geographic features. The...
-
Version History Table of Geographic Data from SwedenTSV
This historical table is part of a dataset that originates from the 'Lantmäteriet' website in Sweden. It is a record of version history for the base table rows, providing a chronological overview of each version's lifespan by capturing the date when a version was extracted and when it was replaced by a new version. The most recent version of a row can be identified by a null value in the end date column. A unique identifier for each row in the table is formed by the combination of the start date and row number. The table also contains geographical data which was originally in shapefile format and has been converted to a more final geographic format. This geographical data can represent points, lines, or polygons. In terms of data analytics, this table is a valuable resource. For...
Column Descriptions
Geospatial Data Analysis of Land Objects in Sweden
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, which is the website of Lantmäteriet (the National Land Survey) in Sweden. |
_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 '_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 is an additional identifier for each row of data. |
CODE_12 | string | This column contains specific codes 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. |
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 geometric data of the object in GeoJSON format. |
geom_geotext | string | This column contains the geometric data of the object in text format. |
geom_type | string | This column specifies the type of the geometry of the object. |
geom_centroid | string | This column contains the centroid of the geometric object. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometric object. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometric object. |
Version History of Base Table Rows in Orebro Dataset from a Swedish Source
Column | Type | Comment |
---|---|---|
_start_date | date | This column represents the date when the row data was extracted from the source. It is part of a unique identifier for each row in the version history table, in combination with '_row_number'. |
_end_date | date | This column indicates the date when a new version of the row data was extracted from the source. If the value is null, it signifies that the row is the most recent version. |
_row_number | long | This column contains the number of the row as it appears in the raw data extracted from the source. In combination with '_start_date', it forms a unique identifier for each row in the version history table. |
OBJECTID | long | This column contains the unique ID of the object associated with the row. |
ID | string | This column represents the unique identification number of the data entry. |
CODE_12 | string | This column holds a specific code associated with the data entry. |
Area_Ha | double | This column quantifies the area associated with the data entry, measured in hectares. |
Remark | string | This column contains any additional comments or notes regarding the data entry. |
Shape_Leng | double | This column describes the length of the shape associated with the data entry. |
Shape_Area | double | This column indicates the area of the shape associated with the data entry. |
geom_geojson | string | This column contains the geometric representation of the data entry in GeoJSON format. |
geom_geotext | string | This column holds the geometric representation of the data entry in textual format. |
geom_type | string | This column specifies the type of geometric figure associated with the data entry. |
geom_centroid | string | This column provides information about the geometric center, or centroid, of the shape associated with the data entry. |
geom_center_x | double | This column gives the x-coordinate of the center of the geometric figure associated with the data entry. |
geom_center_y | double | This column gives the y-coordinate of the center of the geometric figure associated with the data entry. |
Geospatial Data with Area, Shape and Object Details
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 identifier for each object in the table. |
ID | string | This column contains a unique ID associated with each row in the table. |
CODE_12 | string | This column contains a 12-digit code related to the data in each row. |
Area_Ha | double | This column contains the area size in hectares. |
Remark | string | This column contains any additional remark or comment related to the row data. |
Shape_Leng | double | This column contains the length of the shape associated with the data in each row. |
Shape_Area | double | This column contains the area of the shape associated with the data in each row. |
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 data. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometric data. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometric data. |
Version History Table of Geographic Data from Sweden
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date on which the row was extracted from the data source. It forms a unique identifier in combination with the '_row_number' column for each row in this version history table. |
_end_date | date | This column contains the date on which a new version of the row was extracted from the data source. If the value in 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 in combination with the '_start_date' column for each row in this version history table. |
OBJECTID | long | This column contains the unique identifier for each object in the table. |
ID | string | This column contains an identification number for each row in the table. |
CODE_12 | string | This column contains a code related to the data in the row. |
Area_Ha | double | This column contains information about the area in hectares. |
Remark | string | This column contains any additional comments or notes related to the row. |
Shape_Leng | double | This column contains the length of the shape represented in the row. |
Shape_Area | double | This column contains the area of the shape represented in the row. |
geom_geojson | string | This column contains the geometry of the shape represented in the row, formatted as GeoJSON. |
geom_geotext | string | This column contains the geometry of the shape represented in the row, formatted as text. |
geom_type | string | This column contains the type of geometry for the shape represented in the row. |
geom_centroid | string | This column contains the centroid of the shape represented in the row. |
geom_center_x | double | This column contains the X-coordinate of the center of the shape represented in the row. |
geom_center_y | double | This column contains the Y-coordinate of the center of the shape represented in the row. |
Land Classification and Geometric Information Dataset Table from Sweden
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data on the row was extracted from the source. |
_row_number | long | The row number in the data extracted from the source on the extract date specified by the '_extract_date' column. This column helps to uniquely identify each row along with '_extract_date'. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An identifier for each data entry. |
CODE_12 | string | A 12-digit code associated with the data entry. |
Area_Ha | double | The area of the object or region in hectares. |
Remark | string | Notations or comments associated with the data entry. |
Shape_Leng | double | The length of the shape or boundary of the object or region. |
Shape_Area | double | The area of the shape or boundary of the object or region. |
geom_geojson | string | The geometry of the object or region in GeoJSON format. |
geom_geotext | string | The geometry of the object or region in text format. |
geom_type | string | The type of geometry of the object or region. |
geom_centroid | string | The centroid or geometric center of the object or region. |
geom_center_x | double | The x-coordinate of the center of the object or region. |
geom_center_y | double | The y-coordinate of the center of the object or region. |
Version History of Base Table Rows in Orebro Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | 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 | 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. It forms a unique identifier for each row when combined with '_start_date'. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An identifier for the item. |
CODE_12 | string | A specific code associated with the item. |
Area_Ha | double | The area of the object measured in hectares. |
Remark | string | Additional notes or comments about the object. |
Shape_Leng | double | The length of the object's shape. |
Shape_Area | double | The area of the object's shape. |
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 representation of the object. |
geom_centroid | string | The centroid of the geometric representation of the object. |
geom_center_x | double | The X-coordinate of the center of the geometric representation of the object. |
geom_center_y | double | The Y-coordinate of the center of the geometric representation of the object. |
Geospatial Data Collection with Area Metrics, Identification Codes and Geometric Features
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 represents an unique object identifier. |
ID | string | This column represents an identification number associated with each record. |
CODE_12 | string | This column contains specific codes associated with the data. |
Area_Ha | double | This column provides the area of the geographical object in hectares. |
Remark | string | This column contains any additional information or remarks regarding the record. |
Shape_Leng | double | This column represents the length of the shape of the geographical object. |
Shape_Area | double | This column represents the area of the shape of the geographical object. |
geom_geojson | string | This column contains the GeoJSON representation of the geographical object. |
geom_geotext | string | This column contains a textual representation of the geographical object. |
geom_type | string | This column specifies the type of the geographical object. |
geom_centroid | string | This column contains the centroid of the geographical object. |
geom_center_x | double | This column contains the X-coordinate of the center point of the geographical object. |
geom_center_y | double | This column contains the Y-coordinate of the center point of the geographical object. |
Historical Versioning Data of Base Table Rows in Orebro 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 for each row 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. 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', it uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains the unique identifier for each object in the table. |
ID | string | This column contains another unique identifier for each object in the table. |
CODE_12 | string | This column contains a code associated with each row of the table. |
Area_Ha | double | This column contains the area measurement of each object in the table, in hectares. |
Remark | string | This column contains any remarks or notes associated with each row of the table. |
Shape_Leng | double | This column contains the length of the shape of each object in the table. |
Shape_Area | double | This column contains the area of the shape of each object in the table. |
geom_geojson | string | This column contains the GeoJSON representation of each object's geometry. |
geom_geotext | string | This column contains the textual representation of each object's geometry. |
geom_type | string | This column contains the type of each object's geometry, such as point, line or polygon. |
geom_centroid | string | This column contains the centroid of each object's geometry. |
geom_center_x | double | This column contains the x-coordinate of the center of each object's geometry. |
geom_center_y | double | This column contains the y-coordinate of the center of each object's geometry. |
Geographical and Geometrical Data Collection for Land Survey 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 stores the unique identifier of the object. |
ID | string | This column represents the ID of the data entry. |
CODE_12 | string | This column contains a 12-digit code associated with the data entry. |
Area_Ha | double | This column represents the area of the data entry in hectares. |
Remark | string | This column can contain any additional comments or remarks about the data entry. |
Shape_Leng | double | This column provides a measure of the length of the shape associated with the data entry. |
Shape_Area | double | This column provides a measure of the area of the shape associated with the data entry. |
geom_geojson | string | This column contains the geometry of the data entry in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the data entry in a textual format. |
geom_type | string | This column contains the type of the geometry associated with the data entry. |
geom_centroid | string | This column contains the centroid of the geometry associated with the data entry. |
geom_center_x | double | This column contains the X-coordinate of the center of the geometry associated with the data entry. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geometry associated with the data entry. |
Version History of Base Table Rows in Örebro Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the row was extracted from the data source, marking the beginning of a specific version of the row. |
_end_date | date | The date when a new version of the row was extracted from the data source, marking the end of a specific version. If null, it signifies 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 data source. It is used in combination with '_start_date' to uniquely identify each row in this version history table. |
OBJECTID | long | A unique identifier assigned to each object in the table. |
ID | string | A unique identifier for each record. |
CODE_12 | string | A code associated with each record. |
Area_Ha | double | The area of the geographical object in hectares. |
Remark | string | Additional notes or comments associated with each record. |
Shape_Leng | double | The length of the geographical object shape. |
Shape_Area | double | The area of the geographical object shape. |
geom_geojson | string | The geographical object represented in GeoJSON format. |
geom_geotext | string | The geographical object represented in GEOTEXT format. |
geom_type | string | The type of the geographical object. |
geom_centroid | string | The centroid of the geographical object. |
geom_center_x | double | The x-coordinate of the center of the geographical object. |
geom_center_y | double | The y-coordinate of the center of the geographical object. |
Land Classification and Geometric Data - Orebro Collection
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data of the corresponding 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 contains the object identifier. |
ID | string | This column contains the identification number. |
CODE_12 | string | This column contains a specific code related to the data. |
Area_Ha | double | This column contains the area measurement in hectares. |
Remark | string | This column contains any additional remarks or comments related to the row data. |
Shape_Leng | double | This column contains the length of the shape represented by the data in the row. |
Shape_Area | double | This column contains the area of the shape represented by the data in the row. |
geom_geojson | string | This column contains the geometric data in GeoJSON format. |
geom_geotext | string | This column contains the geometric data in a text format. |
geom_type | string | This column contains the type of the geometric data. |
geom_centroid | string | This column contains the centroid of the geometric data. |
geom_center_x | double | This column contains the x-coordinate of the geometric center. |
geom_center_y | double | This column contains the y-coordinate of the geometric center. |
Version History of Base Table Rows in Örebro 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 combination with '_row_number' 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. 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 combination with '_start_date' to identify each row in this version history table. |
OBJECTID | long | This column serves as a unique identifier for each object in the table. |
ID | string | This column is an additional unique identifier for each entry in the table. |
CODE_12 | string | This column contains specific codes associated with each row of data. |
Area_Ha | double | This column represents the area of an object or region, measured in hectares. |
Remark | string | This column contains additional comments or notes about each row. |
Shape_Leng | double | This column contains the length of the shape of the object or region. |
Shape_Area | double | This column contains the area of the shape of the object or region. |
geom_geojson | string | This column contains the geometric representation of the object or region in the GeoJSON format. |
geom_geotext | string | This column contains the geometric description of the object or region in text format. |
geom_type | string | This column indicates the type of the geometric shape of the object or region. |
geom_centroid | string | This column contains the geometric center (centroid) of the object or region. |
geom_center_x | double | This column contains the X-coordinate of the geometric center of the object or region. |
geom_center_y | double | This column contains the Y-coordinate of the geometric center of the object or region. |
Geographical and Geometrical Data Collection in Sweden
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. |
_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. Together with '_extract_date', this column uniquely identifies each row. |
OBJECTID | long | This column contains unique identifiers for the objects in the dataset. |
ID | string | This column contains additional identifiers for the objects in the dataset. |
CODE_12 | string | This column contains specific codes associated with the objects in the dataset. |
Area_Ha | double | This column indicates the area of the objects in the dataset, measured in hectares. |
Remark | string | This column contains any additional remarks or comments about the objects in the dataset. |
Shape_Leng | double | This column indicates the length of the objects in the dataset. |
Shape_Area | double | This column indicates the area of the objects in the dataset. |
geom_geojson | string | This column contains the geometry of the objects in the dataset, represented in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the objects in the dataset, represented in text format. |
geom_type | string | This column indicates the type of geometry used to represent the objects in the dataset. |
geom_centroid | string | This column contains the centroid of the geometry of the objects in the dataset. |
geom_center_x | double | This column indicates the X coordinate of the center of the geometry of the objects in the dataset. |
geom_center_y | double | This column indicates the Y coordinate of the center of the geometry of the objects in the dataset. |
Version History of Base Table Rows from a Swedish Geospatial Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the row data was extracted from the data source. |
_end_date | date | The date when a new version of the row data was extracted from the data source. A null value 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 data source. This, in combination with the '_start_date' column, uniquely identifies each row in the history table. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An identification number assigned to each data entry. |
CODE_12 | string | A specific code associated with the data entry. |
Area_Ha | double | The area measurement of the data entry, represented in hectares. |
Remark | string | Any additional comments or notes regarding the data entry. |
Shape_Leng | double | The length of the shape associated with the data entry. |
Shape_Area | double | The area of the shape associated with the data entry. |
geom_geojson | string | The geometric data of the shape associated with the data entry, represented in GeoJSON format. |
geom_geotext | string | The geometric data of the shape associated with the data entry, represented in geotext format. |
geom_type | string | The type of geometric shape associated with the data entry. |
geom_centroid | string | The central point 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. |
Geographical and Geometrical Information Analysis Data
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the row data was extracted from the data source. |
_row_number | long | The row number in the data extracted from the source on the specific extract date. Together with '_extract_date', it uniquely identifies each row. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | A unique identifier for the data record. |
CODE_12 | string | The code associated with the data record in the format of 12 digits. |
Area_Ha | double | The area of the geographical object represented by the data record, measured in hectares. |
Remark | string | Additional notes or comments related to the data record. |
Shape_Leng | double | The length of the shape representing the geographical object, possibly measured in a specific unit of length. |
Shape_Area | double | The area of the shape representing the geographical object, possibly measured in a specific unit of area. |
geom_geojson | string | The geographical object associated with the data record, represented in GeoJSON format. |
geom_geotext | string | The geographical object associated with the data record, represented in a text format. |
geom_type | string | The type of the geographical object associated with the data record. |
geom_centroid | string | The centroid of the geographical object associated with the data record. |
geom_center_x | double | The x-coordinate of the center of the geographical object associated with the data record. |
geom_center_y | double | The y-coordinate of the center of the geographical object associated with the data record. |
History of Version Changes in Land Classification Records
Column | Type | Comment |
---|---|---|
_start_date | date | This column indicates the date when the row was extracted from the data source. It is part of an unique identifier for each row in this version history table, together with '_row_number'. |
_end_date | date | This column signifies 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 as it appears in the raw data extracted from the data source. It is part of an unique identifier for each row in this version history table, together with '_start_date'. |
OBJECTID | long | This column represents the object identifier. |
ID | string | This column contains the unique identification for each record. |
CODE_12 | string | This column holds specific code values related to the dataset. |
Area_Ha | double | This column indicates the area of the geographical object represented by the row, measured in hectares. |
Remark | string | This column contains any additional comments or remarks related to the record. |
Shape_Leng | double | This column denotes the length of the shape of the geographical object. |
Shape_Area | double | This column indicates the area of the shape of the geographical object. |
geom_geojson | string | This column stores the geographical data of the object in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the object in a text format. |
geom_type | string | This column specifies the type of the geographical object (for example, point, line, polygon etc.). |
geom_centroid | string | This column contains the centroid of the geographical object. |
geom_center_x | double | This column indicates the x-coordinate of the center of the geographical object. |
geom_center_y | double | This column denotes the y-coordinate of the center of the geographical object. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |