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

Uppsala Dataset Collection: Multi-Table Data Compilation

The dataset collection comprises multiple tables, each containing related data that is structured in the form of rows and columns. The data housed in these tables originates from Lantmäteriet (The Land Survey), a website based in Sweden. The tables are diverse and encompass various categories, offering a broad scope of data for analysis.

Tables

  • Detailed Geographic and Geometric Data CollectionTSV

    The table is a part of a larger dataset sourced from Lantmäteriet, the National Land Survey of Sweden. It contains a wealth of information that has been meticulously organized into rows and columns for ease of analysis. This table is unique in its inclusion of two special columns that contain details about the extract date and the row number. These columns work in tandem to offer a unique identifier for each row of data. Information about geographical features, originally in the shapefile format, has also been transformed into a more convenient format for the users. In terms of data analytics, this table can be an invaluable resource. For instance, by utilizing the extract date and row number, analysts can track changes in the data over time, allowing for a dynamic analysis of trends...

  • Geospatial Analysis Data Table from Swedish National Land SurveyTSV

    The table in question is part of a larger dataset collection, sourced from the website of Lantmäteriet (The Swedish Land Survey) in Sweden. It contains a rich variety of information, including geographical data and several unique identifiers. Each row in the table represents unique data extracted on a specific date, with each row being numbered uniquely according to the date of extraction. This combination of extraction date and row number ensures that each row of data can be distinctly identified. The table also includes geographical information, which has been translated from its original shapefile format into a final geographic format. This geographic data can represent various geographic features such as points, lines, or polygons (areas). Potential applications of this data in...

  • Geospatial Data Table: Detailed Land Use Information from SwedenTSV

    The table in question is a valuable resource in the dataset collection sourced from 'Lantmäteriet' (The Swedish Mapping, Cadastral and Land Registration Authority) in Sweden. It contains a rich set of data, organized in a structured way. The table contains several columns with diverse data. Two of these columns are particularly important: one contains the date when the data was extracted from the source, and the other contains the row number in the data extracted on that date. The combination of these two columns uniquely identifies each row in the table. In addition to these, the table also includes geographic information. This information, originally in the shapefile format, has been transformed into the final geographic format. Geographic features can be represented by points,...

  • Historical Version Records of Uppsala Dataset TableTSV

    This historical dataset table is part of a larger collection sourced from 'Lantmäteriet' (The Swedish Mapping, Cadastral and Land Registration Authority) in Sweden. It provides a version history of its base table rows, tracking changes over time. Each row in this table is uniquely distinguished by a combination of the extraction date and the row number from the original raw data. The table records the date a row was extracted as well as the date when a new version of the same row was extracted. If the ending date is not specified, this indicates that the version of the row is the most recent. Additionally, the table contains columns that contain geographic information, which has been transformed from the original shapefile format. Shapefile is a format used to store the geometric...

  • Integrated Geographic and Object Data Table from a Swedish SourceTSV

    The table under discussion is a meticulously organized set of data, categorized in rows and columns, and is a part of a larger dataset collection. This table is unique in its structure as it contains two special columns that together serve to uniquely identify each row. One of these columns contains the date when the specific row of data was extracted from the original source, while the other contains the row number in the extracted data, corresponding to the extraction date. This table is particularly interesting as it contains geographic information that has been transformed from the shapefile format. Shapefile, a non-topological format, is typically used for storing the geometric location and attribute information of geographic features, which can be represented by points, lines, or...

  • Spatial Geometric Data and Characteristics of Land Objects in UppsalaTSV

    The table under discussion is a vital component of a larger dataset collection. This table contains several columns, each housing a different kind of data. Two noteworthy columns include one which stores the date of data extraction, and another that details the row number from the original data extraction. These two columns work in tandem to uniquely identify each row of data. This table has an emphasis on geographic information, which is originally sourced from a shapefile. Shapefile is a format typically used for storing the location and attribute details of geographic features, which can range from points and lines to polygons (areas). In this dataset, the geographic data from the shapefile has been transformed into its final form. The origin of the data is the website of...

  • Version History of Base Table Rows as Part of Uppsala Dataset Collection Sourced from Swedish WebsiteTSV

    The 'clc12_66g_so__history' is a historical data table that is part of the 'uppsala' dataset collection. This table stands out for its purpose of storing the version history of its base table rows, providing a timeline of changes to the data. Key features of this table include a unique identifier for each row, which is a combination of the date the data was extracted and the row number. This allows for effective tracking of data changes over time. A particularly interesting aspect of this table is the presence of start and end dates for each row. The start date indicates when the data was extracted while the end date signifies when a new version of the data was pulled. If the end date is null, this signifies that the current version of the data is the most recent. The table also...

  • Version History of Base Table Rows in the Uppsala Dataset CollectionTSV

    The table in question is a part of a dataset collection and serves as a history table, maintaining the version history of its base table rows. Originating from the 'Lantmäteriet' website based in Sweden, it includes various data points structured in a tabular format, consisting of columns and rows. Key features of the table involve entries, such as a unique row number and start date, which together uniquely identify each row in the version history. It also tracks the timeline of data extraction with a start and end date for each row. If the end date is null, it signifies that the row is the most current version. The table also contains geographic data transformed from the shapefile format, a standard for storing geometric location and attribute details of geographic features. These...

  • Version History of Base Table Rows in Uppsala Dataset CollectionTSV

    This table is a historical record of a dataset sourced from Lantmäteriet, the National Land Survey of Sweden. It provides a comprehensive version history of its base table rows, offering a unique combination of start date and row number to identify each row in this history table. The start date indicates when the row was extracted from the data source, while the end date shows when a new version of the row was extracted. If the end date is null, it signifies that the row is the most recent version. The table contains various geographic details, originally in shapefile format—a common standard for storing geometric location and attribute information of geographic features—which have been transformed into a final format. The geographic features could be represented by points, lines, or...

Column Descriptions

Detailed Geographic and Geometric Data Collection

Column Type Comment
_extract_date date This column contains the date on which the data for the specific row was extracted from the data source. It is one of two columns that together uniquely identify each row.
_row_number long This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It is one of two columns that together uniquely identify each row.
OBJECTID long This column represents a unique identifier for the object within the dataset.
ID string This column represents another unique identifier for the data record.
CODE_12 string This column holds a specific code associated with the data record.
Area_Ha double This column stores the area of the data object, measured in hectares.
Remark string This column contains any additional comments or remarks related to the data record.
Shape_Leng double This column contains the length of the shape represented by the data record.
Shape_Area double This column contains the area of the shape represented by the data record.
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 textual format.
geom_type string This column identifies the type of geometric shape that the data record represents.
geom_centroid string This column contains the centroid of the geometric shape that the data record represents.
geom_center_x double This column contains the x-coordinate of the center of the geometric shape that the data record represents.
geom_center_y double This column contains the y-coordinate of the center of the geometric shape that the data record represents.

Historical Version Records of Uppsala Dataset Table

Column Type Comment
_start_date date Contains the date when the row was extracted from the data source. Together with '_row_number', this forms a unique identifier for each row in this version history table.
_end_date date 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 Contains the number of the row in the raw data extracted from the data source. Together with '_start_date', this forms a unique identifier for each row in this version history table.
OBJECTID long Unique identifier for each object within this table.
ID string Unique identifier for each row within this table.
CODE_12 string Contains a coded value that represents a certain type of data or information within the row.
Area_Ha double The area of the geographical feature represented by the row, measured in hectares.
Remark string Contains any additional comments or observations associated with the data in the row.
Shape_Leng double The length of the shape represented by the row. This could be the length of a feature's border or perimeter, for example.
Shape_Area double The area of the shape represented by the row. This could be the area of a feature's surface, for example.
geom_geojson string Contains the geometric data of the row in GeoJSON format, a popular format for encoding a variety of geographic data structures.
geom_geotext string Contains the geometric data of the row in text form.
geom_type string Specifies the type of the geometric data represented in the row, such as 'Point', 'LineString', or 'Polygon'.
geom_centroid string The central point of the geometric shape represented by the row.
geom_center_x double The X-coordinate of the center of the geometric shape represented by the row.
geom_center_y double The Y-coordinate of the center of the geometric shape represented by the row.

Integrated Geographic and Object Data Table from a Swedish Source

Column Type Comment
_extract_date date This column records the date when the data on the row of the table was extracted from the source. It helps in tracking the timeline of data extraction.
_row_number long This column contains the row number in the data extracted from the source on the date specified by the column '_extract_date'. It helps in uniquely identifying each row along with '_extract_date'.
OBJECTID long This is an identification column that provides a unique ID for each object or entry in the table.
ID string This is another identification column that provides a unique ID for each entry in the table.
CODE_12 string This column contains specific codes related to the data entries.
Area_Ha double This column records the area of the geographical object or region related to the data entry, measured in hectares.
Remark string This column is for any additional comments, notes or observations regarding the data entry.
Shape_Leng double This column records the length of the shape of the geographical object or region related to the data entry.
Shape_Area double This column records the area of the shape of the geographical object or region related to the data entry.
geom_geojson string This column contains the geographical data of the object or region in GeoJSON format, a type of JSON designed for geographical data.
geom_geotext string This column contains textual representation of the geographical data of the object or region.
geom_type string This column defines the type of geometry of the geographical object or region related to the data entry, such as point, line, polygon etc.
geom_centroid string This column contains the geographical coordinates of the centroid, or geometric center, of the object or region.
geom_center_x double This column contains the X coordinate of the center of the geographical object or region.
geom_center_y double This column contains the Y coordinate of the center of the geographical object or region.

Geospatial Data Table: Detailed Land Use Information from Sweden

Column Type Comment
_extract_date date This column stores the date when the data on the current row was extracted from the original data source.
_row_number long This column holds the row number in the data extracted from the source on the extraction date specified by the _extract_date column. The combination of _extract_date and _row_number uniquely identifies each row.
OBJECTID long This column contains a unique identifier for each object in the table.
ID string This column holds an identification number for each record in the table.
CODE_12 string This column stores a specific code associated with each record.
Area_Ha double This column represents the area of a particular object, measured in hectares.
Remark string This column contains additional comments or notes related to each record.
Shape_Leng double This column keeps track of the length of the shape of the object.
Shape_Area double This column measures the area of the shape of the object.
geom_geojson string This column stores the geometric representation of the object in GeoJSON format, a format for encoding geographic data structures.
geom_geotext string This column keeps the textual representation of the object's geometry.
geom_type string This column indicates the type of the geometric shape of the object.
geom_centroid string This column contains the centroid of the geometric shape of the object. The centroid is the geometric center of a plane figure.
geom_center_x double This column holds the X coordinate of the center of the geometry of the object.
geom_center_y double This column stores the Y coordinate of the center of the geometry of the object.

Version History of Base Table Rows in Uppsala Dataset Collection

Column Type Comment
_start_date date This column contains the date when the row was extracted from the data source. This column, in combination with '_row_number', uniquely identifies each row in this history table.
_end_date date This column contains the date when a new version of the row was extracted from the data source. If the value is null, it means 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 forms a unique identifier for each row in this version history table.
OBJECTID long This column contains the object identifier.
ID string This column contains the identifier of the object.
CODE_12 string This column contains the 12-digit code of the object.
Area_Ha double This column contains the area of the object in hectares.
Remark string This column contains any additional remarks or notes about the object.
Shape_Leng double This column contains the length of the shape of the object.
Shape_Area double This column contains the area of the shape of the object.
geom_geojson string This column contains the geometry of the object in GeoJSON format.
geom_geotext string This column contains the geometry of the object in geotext format.
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.

Spatial Geometric Data and Characteristics of Land Objects in Uppsala

Column Type Comment
_extract_date date This column contains the date when the data on the row was extracted from the data source.
_row_number long This column contains the row number in the data extracted from the source on the extract date specified by the _extract_date column. The combination of _extract_date and _row_number uniquely identifies each row.
OBJECTID long This column represents the unique identifier assigned to each object in the data.
ID string This column is another identifier assigned to each data entry.
CODE_12 string This column contains specific codes related to the data entries.
Area_Ha double This column represents the area of the data object in hectares.
Remark string This column may contain additional notes or comments related to the data entry.
Shape_Leng double This column represents the length of the shape of the data object.
Shape_Area double This column represents the area of the shape of 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 plain text format.
geom_type string This column indicates the type of geometric representation used for the data object.
geom_centroid string This column contains the centroid of the geometric representation of the data object.
geom_center_x double This column contains the x-coordinate of the center of the geometric representation of the data object.
geom_center_y double This column contains the y-coordinate of the center of the geometric representation of the data object.

Version History of Base Table Rows as Part of Uppsala Dataset Collection Sourced from Swedish Website

Column Type Comment
_start_date date This column records the date when each specific row was extracted from the data source. In conjunction with '_row_number', it uniquely identifies each row.
_end_date date This column holds the date when a new version of the row was extracted from the source. If this column is null, the row is the most current version.
_row_number long This column contains the row number from the raw data extracted from the source. It works with '_start_date' to uniquely identify each row.
OBJECTID long A column that likely contains a unique identifier for each object or entry within the table.
ID string This column typically holds an identification number or code for the records in the table.
CODE_12 string This column likely contains specific codes related to the data in the table.
Area_Ha double This column probably carries data relevant to a certain area, potentially measured in hectares.
Remark string This column potentially includes any additional comments, notes, or observations about the records.
Shape_Leng double This column likely contains data related to the length of a shape, presumably related to geographic features.
Shape_Area double This column likely holds data related to the area of a shape, presumably related to geographic features.
geom_geojson string This column likely contains geographic data in the GeoJSON format.
geom_geotext string This column likely contains geographic data in text format.
geom_type string This column likely describes the type of geometric data represented (e.g., point, line, polygon).
geom_centroid string This column presumably contains the centroid (geographic center) of a geometric feature.
geom_center_x double This column likely represents the x-coordinate of the geometric feature's center.
geom_center_y double This column likely represents the y-coordinate of the geometric feature's center.

Geospatial Analysis Data Table from Swedish National Land Survey

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'. Each row is uniquely identified through the combination of '_extract_date' and '_row_number'.
OBJECTID long This column represents the object identifier.
ID string This column represents the unique identifier of the object.
CODE_12 string This column represents a specific code related to the object.
Area_Ha double This column represents the area of the object in hectares.
Remark string This column contains any additional comments or remarks related to the object.
Shape_Leng double This column represents the length of the shape of the object.
Shape_Area double This column represents the area of the shape of the object.
geom_geojson string This column contains the GeoJSON representation of the object's geometry.
geom_geotext string This column contains the geometric attributes of the object in text format.
geom_type string This column represents the type of the object's geometry.
geom_centroid string This column represents the centroid of the object's geometry.
geom_center_x double This column represents the X coordinate of the object's geometry center.
geom_center_y double This column represents the Y coordinate of the object's geometry center.

Version History of Base Table Rows in the Uppsala Dataset Collection

Column Type Comment
_start_date date This column contains the date when the specific row was extracted from the data source. It is used in combination with the '_row_number' column to uniquely identify each row in this history table.
_end_date date This column contains the date when a new version of the specific row was extracted from the data source. If the value of this column is null, it indicates that the row is the most recent version.
_row_number long This column contains the number of the row in the raw data extracted from the data source. It is used in combination with the '_start_date' column to uniquely identify each row in this history table.
OBJECTID long This column contains an identification number for each object in the dataset. It is typically a unique identifier.
ID string This column contains an identification number or code, usually unique, associated with each record in the table.
CODE_12 string This column contains specific codes related to the data in the table. The meaning of these codes is usually defined by the data provider.
Area_Ha double This column contains information about the area of each data item, measured in hectares.
Remark string This column is reserved for any notes or additional information about the data in the row.
Shape_Leng double This column contains the length of the shape associated with each data item.
Shape_Area double This column contains the area of the shape associated with each data item.
geom_geojson string This column contains the geometric data in GeoJSON format, a popular format for encoding geographic data structures.
geom_geotext string This column contains the geometric data in plain text format.
geom_type string This column indicates the type of the geometric data (e.g., point, line, polygon).
geom_centroid string This column contains the centroid of the geometric data. The centroid is the geometric center of a plane figure or shape.
geom_center_x double This column contains the x-coordinate of the geometric center of a shape.
geom_center_y double This column contains the y-coordinate of the geometric center of a shape.

Additional Info

Last Updated September 13, 2024
Created August 26, 2024