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

Collection of Tables Sourced from a Swedish Web Site Focusing on Vastra Gotaland Region

This dataset collection is a detailed compilation of tables sourced from Sweden's 'Lantmäteriet' (National Land Survey) website. It comprises several tables that hold related data, all organized in a structured format of columns and rows. The collection provides a broad range of data, offering extensive insights and detailed information that can be used for various analytical purposes. Please note, each table in the collection holds unique data, which can be cross-referenced with the other tables in this collection for a more comprehensive analysis.

Tables

  • Geographical and Statistical Data Table of Vastra GotalandTSV

    This table is an integral part of a larger dataset collection. It is compiled with diverse types of data, each type represented in its own column, and each row representing a unique data entry. Notably, two columns serve as the backbone of the table structure, holding the date of data extraction and the row number of each entry, respectively. This combination ensures the unique identification of each row, providing a stable structure for data analysis. The table also carries geographic information, initially stored in a shapefile format known for its simplicity and versatility in storing geographic features, which could be points, lines, or areas. This geographic data has been converted into a final format from the original shapefile format. The data for this table is gathered from...

  • Geographical Information and Property Details Sourced from a Swedish Web DatabaseTSV

    The table in question is a part of a dataset collection that is organized in a structured format with columns and rows. It contains a variety of data including geographic information and unique identifying features. Two notable columns contain data about the extraction date and the row number, which can be used together to uniquely identify each row. The geographic information originally comes in the shapefile format, a commonly used format for storing the geometric location and attribute information of geographic features. This data could have been represented by points, lines, or polygons in the original shapefile format, but it has been transformed into the final format for use in this table. This table is sourced from the website of 'Lantmäteriet' (The Swedish Land Survey) in...

  • Geospatial Characteristics and Attributes of Land AreasTSV

    The table is a collection of related data hailing from the dataset collection 'vastra_gotaland'. It comprises a variety of columns that carry essential information regarding each data entry. Among these columns are two special ones: one that records the date when the data was extracted from the source, and another that indicates the row number in the data extracted from the source on that particular date. These two columns together uniquely identify each row in the table. Additionally, the table includes geographic information that originated in the shapefile format, a format used for storing the geometric location and attribute information of geographic features. This geographic information has since been transformed into its final format from the shapefile format. The table's data...

  • Geospatial Data Table with Object Details and Geometric InformationTSV

    The table is a component of a larger dataset collection and contains a variety of data types. One of the distinguishing features of this table is the inclusion of two special columns. These indicate the date the row's data was extracted and the row's number in the original extraction, with the combination of these two values providing a unique identification for each row. This table also includes geographical information, which has been transformed from a shapefile format. Shapefiles are used to store geographical feature data, including the location and attributes of these features, which can be represented as points, lines, or polygons. The table is sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. In terms of data analytics, the information from this table could...

  • Geospatial Data Table with Object Identification, Area, and Geometric AttributesTSV

    The table in focus is part of a dataset collection, hailing from Vastra Gotaland. It comprises of a multitude of columns, each holding specific data. Two distinctive columns contain data regarding the date of extraction and the row number from the original data source. These two, in combination, serve as unique identifiers for each row. The table also carries geographic information, which has been transformed from the shapefile format, a format used for storing geometric location and attribute information of geographic features. This geographic data can represent points, lines, or polygons, thus providing a robust understanding of the spatial aspects of the data. The data for this table is sourced from the website of Lantmäteriet (The Land Survey of Sweden) in Sweden. As for its...

  • Historical Versions of Land Classification Data in Västra Götaland RegionTSV

    The history table under consideration is a part of a dataset collection and provides an extensive track of version history of its base table rows. It maintains a unique identification for each row using a combination of the date when the row was extracted and the row number. The table also maintains the date when a new version of the row was extracted, assisting in identifying the most recent version of a row. The table provides detailed geographic information transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features. This geographic information can include points, lines, or polygons (areas). The table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey). The information in this table could...

  • Version History of Base Table Rows - History Table (Sourced from a Swedish Website)TSV

    The table under consideration is a historical record that forms part of a larger dataset from the region of Västra Götaland. It serves as a log of changes made to its corresponding base table, with two additional fields that mark the start and end dates for each row entry. This setup allows for the tracking of the complete life cycle of each row, from when it was first pulled from the source to when it was last updated. If the end date for a row is not specified, it signifies that the version in question is the most recent. The data in the table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey). The table also includes geographic data, transformed from the shapefile format, typically used to store geometric location and attribute information of geographical features....

  • Version History of Base Table Rows From the Vastra Gotaland Dataset CollectionTSV

    The 'clc12_63d_nv__history' table belongs to the 'vastra_gotaland' dataset collection. As a history table, it keeps a record of the version history of its base table rows. It has two additional columns to its base table, which mark the start and end dates of each version of a row. If the end date is null, it represents the most recent version of the row. Each row also has a unique identifier formed by a combination of the start date and the row number. The data also includes geographic information, originally in the shapefile format, which stores the geometric location and attribute information of geographic features, and has been transformed into the final geographic format. The table is sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. The data in this table could...

  • Version History of Base Table Rows in Vastra Gotaland DatasetTSV

    The 'clc12_63d_no__history' table is a history table that is part of the 'vastra_gotaland' dataset collection. It maintains a version history of its base table rows, making it an invaluable resource for tracking changes over time. This table's row data is uniquely identified by a combination of the extraction date and the row number. The table provides an additional layer of information compared to its base table by including the start and end dates of each row's extraction from the data source. If a row's end date is null, it signifies that the row is the most recent version. The table is sourced from the Swedish website, 'Lantmäteriet' (The Land Survey). The table incorporates geographic data, which is initially in the shapefile format - a format used for storing the geometric...

  • Version History of Base Table Rows in Vastra Gotaland Dataset CollectionTSV

    The 'clc12_63d_so__history' table is a historical table sourced from the Swedish website 'Lantmäteriet' (The Land Survey). It is part of the 'vastra_gotaland' data collection. This table records the version history of its base table rows, which makes it especially valuable for tracking changes over time. It consists of several columns, each providing unique and valuable information. For example, each row in this table can be uniquely identified by a combination of the row's unique number and the date it was extracted from the data source. The table includes two special columns that record the start and end dates of each row's existence in the data source. If the end date is null, this indicates that the current version of a row is the most recent. This feature is particularly useful...

Column Descriptions

Geospatial Characteristics and Attributes of Land Areas

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. It helps in tracing the origin of the data.
_row_number long This column contains the unique row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It assists in uniquely identifying each row.
OBJECTID long This column represents the unique identifier for each object in the table.
ID string This column contains individual identification numbers for each row in the data.
CODE_12 string This column contains specific codes associated with each row of the data.
Area_Ha double This column represents the area of the geographic object, measured in hectares.
Remark string This column contains any additional notes or comments about the data in the row.
Shape_Leng double This column provides the length of the geographical shape represented by the data in the row.
Shape_Area double This column represents the area of the geographical shape represented by the data in the row.
geom_geojson string This column contains the geographical data of the object in GeoJSON format.
geom_geotext string This column contains the geographical data of the object in text format.
geom_type string This column specifies the type of the geographical object represented in the row.
geom_centroid string This column provides the geographical center of the object using the centroid method.
geom_center_x double This column provides the X coordinate of the geographical center of the object.
geom_center_y double This column provides the Y coordinate of the geographical center of the object.

Version History of Base Table Rows in Vastra Gotaland Dataset

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in the table.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version.
_row_number long This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table.
OBJECTID long This column contains the unique identifier of the object in the table.
ID string This column contains a unique identifier associated with the data row.
CODE_12 string This column contains specific codes related to the data row.
Area_Ha double This column represents the area measurement in hectares associated with the data row.
Remark string This column contains any remarks or additional information related to the data row.
Shape_Leng double This column represents the length of the shape associated with the data row.
Shape_Area double This column represents the area of the shape associated with the data row.
geom_geojson string This column contains the GeoJSON representation of the geometry associated with the data row.
geom_geotext string This column contains the text representation of the geometry associated with the data row.
geom_type string This column indicates the type of the geometry associated with the data row.
geom_centroid string This column contains the centroid of the geometry associated with the data row.
geom_center_x double This column contains the X coordinate of the center of the geometry associated with the data row.
geom_center_y double This column contains the Y coordinate of the center of the geometry associated with the data row.

Geographical and Statistical Data Table of Vastra Gotaland

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 contains the object identifier.
ID string This column contains the identification code.
CODE_12 string This column contains the 12-digit code.
Area_Ha double This column represents the area in hectares.
Remark string This column contains any additional remarks or notes.
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 in GeoJSON format.
geom_geotext string This column contains the geometric data in text format.
geom_type string This column describes 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.

Historical Versions of Land Classification Data in Västra Götaland Region

Column Type Comment
_start_date date This column contains the date when the row was initially extracted from the data source. It forms a unique identifier for each row in combination with '_row_number'.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version.
_row_number long This column contains the number of the row as it was 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 a unique identifier for each object in the table.
ID string This column contains a unique ID for each object in the table.
CODE_12 string This column contains a code associated with each object in the table.
Area_Ha double This column contains the area of each object, measured in hectares.
Remark string This column contains any remarks or additional information about each object.
Shape_Leng double This column contains the length of the shape of each object.
Shape_Area double This column contains the area of the shape of each object.
geom_geojson string This column contains the GeoJSON representation of each object's geometry.
geom_geotext string This column contains a textual representation of each object's geometry.
geom_type string This column contains the type of geometry for each object.
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 Information and Property Details Sourced from a Swedish Web Database

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 column '_extract_date'.
OBJECTID long This column contains a unique identifier for each object in the table.
ID string This column contains an additional unique identification code for each row of the table.
CODE_12 string This column contains a code associated with the data in the row.
Area_Ha double This column contains the area measurement of the data object, represented in hectares.
Remark string This column may contain any additional notes or remarks related to the data in the row.
Shape_Leng double This column contains the length of the shape associated with the data object.
Shape_Area double This column contains the area of the shape associated with the data object.
geom_geojson string This column contains the geometric representation of the data object in GeoJSON format.
geom_geotext string This column contains the geometric representation of the data object in a text format.
geom_type string This column indicates the type of geometric representation used for the data object (e.g., point, line, polygon).
geom_centroid string This column contains the centroid (geometric center) of the data object.
geom_center_x double This column contains the x-coordinate of the geometric center of the data object.
geom_center_y double This column contains the y-coordinate of the geometric center of the data object.

Version History of Base Table Rows From the Vastra Gotaland Dataset Collection

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. It forms part of the unique identifier for each row in this version history table, when combined with '_row_number'.
_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 part of the unique identifier for each row in this version history table, when combined with '_start_date'.
OBJECTID long This column contains the object ID associated with each row.
ID string This column contains the ID value associated with each row.
CODE_12 string This column contains the 12-digit code associated with each row.
Area_Ha double This column contains the area size 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 geometry of the row in GeoJSON format.
geom_geotext string This column contains the geometry of the row in text format.
geom_type string This column contains the type of geometry associated with each row.
geom_centroid string This column contains the centroid of the geometry associated with each row.
geom_center_x double This column contains the X coordinate of the center of the geometry associated with each row.
geom_center_y double This column contains the Y coordinate of the center of the geometry associated with each row.

Geospatial Data Table with Object Identification, Area, and Geometric Attributes

Column Type Comment
_extract_date date This column contains the date when the data on a particular row was extracted from the 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 unique identifier for each object in the table.
ID string This column contains a unique identifier for each row in the table.
CODE_12 string This column contains specific codes related to the data in the table.
Area_Ha double This column indicates the area of the geographical object in hectares.
Remark string This column is for any additional comments or observations regarding the data.
Shape_Leng double This column contains the length of the geographical object's shape.
Shape_Area double This column contains the area of the geographical object's shape.
geom_geojson string This column contains the geographical data of the object in GeoJSON format.
geom_geotext string This column contains the geographical data of the object in text format.
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 geographical object's center.
geom_center_y double This column contains the Y coordinate of the geographical object's center.

Version History of Base Table Rows - History Table (Sourced from a Swedish Website)

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 unique identifier for each row in this version history table, along 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 means that the row is the most recent version.
_row_number long This column contains the number of the row in the raw data extracted from the data source. It forms part of a unique identifier for each row in this version history table, combined with the '_start_date' column.
OBJECTID long This column contains an object identifier.
ID string This column contains an identification number.
CODE_12 string This column contains a 12-character code.
Area_Ha double This column contains the area of the object in hectares.
Remark string This column contains remarks or comments related to the row.
Shape_Leng double This column contains the length of the shape in the row.
Shape_Area double This column contains the area of the shape in the row.
geom_geojson string This column contains the geojson format of the geometry of the object.
geom_geotext string This column contains the geotext format of the geometry of the object.
geom_type string This column contains the type of the geometry of the object.
geom_centroid string This column contains the centroid of the geometry of the object.
geom_center_x double This column contains the x-coordinate of the center of the geometry of the object.
geom_center_y double This column contains the y-coordinate of the center of the geometry of the object.

Geospatial Data Table with Object Details and Geometric Information

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 specified extract date.
OBJECTID long The unique identifier for each object in the table.
ID string The unique identification number assigned to each row in the table.
CODE_12 string The unique code assigned to each data item in the table.
Area_Ha double This column represents the area of physical or geographical features recorded in hectares.
Remark string This column contains any additional comments or notes related to the data entry.
Shape_Leng double This column represents the length of the geographical or physical shape.
Shape_Area double This column represents the area of the geographical or physical shape.
geom_geojson string This column contains the geographical data in GeoJSON format.
geom_geotext string This column contains the geographical data in text format.
geom_type string This column describes the type of geographical data, such as point, line, or polygon.
geom_centroid string This column represents the centroid of the geographical shape.
geom_center_x double This column represents the x-coordinate of the center of the geographical shape.
geom_center_y double This column represents the y-coordinate of the center of the geographical shape.

Version History of Base Table Rows in Vastra Gotaland Dataset Collection

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version of the row.
_row_number long This column contains 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 This column contains an object identifier.
ID string This column contains an identification value.
CODE_12 string This column contains a coded value.
Area_Ha double This column contains data related to the area in hectares.
Remark string This column contains any remarks or comments related to the row.
Shape_Leng double This column contains information about the length of the shape.
Shape_Area double This column contains information about the area of the shape.
geom_geojson string This column contains the geometric data in GeoJSON format.
geom_geotext string This column contains the geometric data in text format.
geom_type string This column specifies the type of geometry.
geom_centroid string This column contains the centroid or geometric center of a shape.
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.

Additional Info

Last Updated September 13, 2024
Created August 27, 2024