Uppsala Dataset Collection: Multi-Table Data Compilation
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 |