To download the data set, please sign up or log in

Comprehensive Collection of Related Tables Sourced from Sweden

The dataset collection consists of several tables, each containing related data organized in a structured format of rows and columns. These tables are sourced from the website of Lantmäteriet (The Land Survey) in Sweden. The data stored in these tables are crucial for a variety of analytical and research purposes. Each table follows a specific naming convention, which aids in easy identification and usage. Overall, the dataset collection is a robust and rich source of data meticulously gathered from a reputable source.

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