Ostergotland: Comprehensive Collection of Interrelated Tables Sourced from a Renowned Swedish Web Resource

The dataset collection in focus comprises several tables, all of which are organized in a clear, easy-to-understand format of rows and columns. These tables are all interconnected and have been sourced from Lantmäteriet, a renowned Swedish website. Each table within the collection presents a unique set of data, offering a diverse range of information. This variety makes the dataset collection a rich resource for analysis and research.

Tables

Geospatial Analysis Data Table for Ostergotland Dataset CollectionTSV
The table under consideration forms part of a wider dataset collection and is sourced from Lantmäteriet, a reputable entity based in Sweden. It is structured with a range of columns, each serving a specific purpose. Two of these columns play a pivotal role in identifying each row of data. One contains the exact date when the data was extracted, and the other keeps track of the row number in the data extracted. This duo uniquely identifies each row. A significant feature of this table is the inclusion of geographic information, which has been transformed from the shapefile format - a standard for storing geometric location and attribute details of geographic features. This data could take the form of points, lines, or polygons. In the realm of data analytics, the table’s data can be...
Geospatial Characteristics and Attributes of Ostergotland RegionTSV
The table in question is a collection of related data that forms part of a larger dataset. This data originates from the website of Lantmäteriet (The Land Survey) in Sweden. The table contains multiple columns, each detailing a specific aspect of the data. Two notable columns contain information about the date the data was extracted and the row number in the extracted data, forming a unique identifier for each row. The geographic information in this dataset has been transformed from the shapefile format, which is a common format for storing geographic features such as points, lines, or areas. This table could be used in data analytics to analyze geographic trends over time, as each row is timestamped. For example, one could track changes in land use by examining the geographic features...
Geospatial Features and Attributes Dataset for Ostergotland RegionTSV
The table in question is a significant component of a larger dataset collection, sourced from the Swedish website, Lantmäteriet. This particular table is designed to organize data in a structured manner, consisting of rows and columns. Each row represents a unique record, while the columns contain specific attributes pertaining to those records. Uniquely, two of the columns provide a combination of extraction date and row number, offering a method to uniquely identify each entry. The table also contains geographical data, originally in shapefile format, which has since been transformed into its final format. This geographical information can represent geographic features as points, lines, or polygons. Given the nature of the data, potential applications in data analytics could include...
Historical Version Record of Base Table EntriesTSV
The table in question belongs to a dataset collection that is part of a version history system. This system includes a base table and, in this case, a history table that tracks the changes made to the rows in the base table over time. The distinction of this table is that it tracks the version history of its base table rows, providing a unique perspective on the data. This table contains several key components. Firstly, it has a column that holds the extraction date for each row, indicating when the data was sourced. Another column tracks the date when a new version of that row was extracted. When the latter column shows a null value, it indicates that this version of the row is the most recent one. Unique identifiers for each row are formed through a combination of the extraction date...
Historical Version Records of Base Table for Ostergotland DatasetTSV
This table is a significant part of the dataset collection related to historical geographical features. It is sourced from the Swedish website Lantmäteriet, which provides a wide range of geographical data. The table is unique as it contains historical versions of its base table rows, meaning it gives a comprehensive record of changes over time. These changes are marked by start and end dates, indicating when a particular version of a row was extracted and when it was updated or replaced by a new version. Rows with no end date are considered the most recent version. The table also includes a row number that, in combination with the start date, uniquely identifies each row version. The data in this table includes geographical information which has been transformed from a shapefile...
Historical Version Records of Geographical Data in Ostergotland DatasetTSV
The table in question is a historical data table that forms part of a larger dataset collection. It's a history table that stores the version history of its base table rows. This means it holds records of different versions of each row, tracking changes over time. Each row is uniquely identified by a combination of the extraction date and the row number from the raw data source. The table has two additional columns compared to its base table which hold the start and end dates. The start date indicates when the row was extracted from the source, while the end date indicates when a new version of the row was extracted. If the end date is null, this indicates that the row is the most recent version. One of the main features of this table is its geographic information, originally in the...
Historical Versioning of Land Structure DataTSV
The table under discussion is a historical record sourced from 'Lantmäteriet' (The Land Survey) website, based in Sweden. It is part of a larger dataset that encompasses related tables, reflecting an organized collection of data. This particular table is unique as it maintains the version history of its base table rows, providing an invaluable chronological perspective of data evolution. Each row in this table is uniquely identified by a combination of the date when the row data was extracted and its raw data row number. The table also indicates the date when a new version of the row was extracted. This allows for tracking the changes in data over time. If there is no 'end date' specified for a row, it signifies that the version of the row is the most recent one. Additionally, this...
History Version of Base Table Rows With Geographical AttributesTSV
This historical table, originating from the dataset collection 'ostergotland', has been sourced from 'Lantmäteriet' (The Land Survey) website in Sweden. This database table provides a detailed version history of its base table rows, displaying data from when it was first extracted from the data source to the most recent extraction. Each row in the table is unique and can be identified by a combination of the date of extraction and the row number. Therefore, if the same data have been extracted multiple times, each extraction will have its own unique entry in the table, allowing for a comprehensive chronological tracking of changes. If a row does not have an end date, this indicates that it is the most recent version of the data. Geographic information is also included in the table,...
Land Classification Data Table from a Swedish SourceTSV
The table in question is a comprehensive collection of geographic data, sourced from 'Lantmäteriet' (The Land Survey) in Sweden. It houses a variety of information, including specific identifiers, area measurements, remarks, as well as a wealth of geographic details. Two integral columns hold the date of data extraction and the row number from the source, which together uniquely identify each entry. The geographic features in the dataset have been converted from a shapefile format, which is a simple format used to store geometric location and attribute information. It includes points, lines, and polygons representing geographic features. This rich dataset could be utilized in numerous ways for data analytics. For instance, it could be used for spatial analysis, examining patterns and...
Land Survey Data Analysis in Sweden: A Comprehensive OverviewTSV
The table is a comprehensive collection of data that originates from the 'Lantmäteriet' website in Sweden. It's part of a larger dataset collection and contains a range of data fields, including specific identifiers, area measurements, and various geographic details. The table is organized in a manner that allows each row to be uniquely identified by a combination of the extraction date and the row number, outlining when the data was sourced and its position in the extraction sequence. The table's content also includes geographic data that was initially in a shapefile format, a widely used format for storing geometric location and attributes of geographic features, and has been transformed into its final form in the dataset. The data in this table can be utilized in a variety of ways in...
Ostergotland Collection: Geospatial and Metadata Attributes of clc12_64e_noTSV
The table under discussion is a comprehensive collection of data originating from the country of Sweden, specifically from the website of 'Lantmäteriet' (The Land Survey). The table is a key component of a larger dataset collection and it contains a variety of interconnected data points, structured into rows and columns for efficient organization and retrieval. The data in the table is uniquely identified through a combination of extraction date and row number, enabling precise tracking and analysis of each data entry. The table contains geographic data which has been transformed from the simple, non-topological shapefile format. Shapefiles store the geometric location and attribute information of geographic features which can be represented as points, lines, or polygons (areas). On...
Version History of Base Table Records in Ostergotland Dataset CollectionTSV
The 'clc12_64e_no__history' table is a historical dataset, part of the 'ostergotland' collection, sourced from the website of the Swedish Land Survey (Lantmäteriet in Swedish). This historical table keeps a record of different versions of its base table rows, allowing users to track changes over time. Each row in the table is uniquely identified through a combination of the row's extraction date and its raw row number from the data source. When a new version of a row is extracted from the data source, the table records the date of this new extraction. If a row's end date is null, it signifies that it is the most recent version of the row. In addition to these temporal aspects, the table also contains geographical data. Originating from a shapefile format - a common format for storing...

Column Descriptions

Ostergotland Collection: Geospatial and Metadata Attributes of clc12_64e_no

Column	Type	Comment
_extract_date	date	The date when the data in the row was extracted from the source.
_row_number	long	The row number in the data extracted from the source on the extract date.
OBJECTID	long	A unique identifier for each object in the table.
ID	string	A unique identifier for each row in the table.
CODE_12	string	A code associated with the data in the row.
Area_Ha	double	The area of the geospatial feature in hectares.
Remark	string	Additional notes or comments on the data in the row.
Shape_Leng	double	The length of the geospatial feature's shape.
Shape_Area	double	The area of the geospatial feature's shape.
geom_geojson	string	The geospatial data of the feature in GeoJSON format.
geom_geotext	string	The geospatial data of the feature in a text format.
geom_type	string	The type of the geospatial feature.
geom_centroid	string	The centroid of the geospatial feature.
geom_center_x	double	The x-coordinate of the geospatial feature's center.
geom_center_y	double	The y-coordinate of the geospatial feature's center.

Version History of Base Table Records in Ostergotland Dataset Collection

Column	Type	Comment
_start_date	date	This column contains the date when a row was extracted from the data source. Along with '_row_number', it uniquely identifies each row in the version history table.
_end_date	date	This column holds the date when a new version of a row was extracted from the data source. If this column's 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 works in combination with '_start_date' to uniquely identify each row in this version history table.
OBJECTID	long	This column is a unique identifier for each row in the table.
ID	string	This column represents another form of identification for each data entry.
CODE_12	string	This column holds specific codes related to the data.
Area_Ha	double	This column represents the area in hectares for the corresponding data entry.
Remark	string	This column is meant for any additional comments or remarks about the data in the row.
Shape_Leng	double	This column stores the length of the shape related to the data entry.
Shape_Area	double	This column holds the area of the shape associated with the data entry.
geom_geojson	string	This column contains the geometric data of the row in GeoJSON format.
geom_geotext	string	This column holds the geometric data of the row in textual format.
geom_type	string	This column indicates the type of geometric data associated with the row.
geom_centroid	string	This column contains the centroid of the geometric data.
geom_center_x	double	This column represents the x-coordinate of the center of the geometry.
geom_center_y	double	This column represents the y-coordinate of the center of the geometry.

Land Survey Data Analysis in Sweden: A Comprehensive Overview

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It is one of the special columns that help in uniquely identifying 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 '_extract_date' column. It is another special column that helps in uniquely identifying each row.
OBJECTID	long	This column contains object identifiers.
ID	string	This column contains unique identifiers.
CODE_12	string	This column contains special 12-digit codes.
Area_Ha	double	This column contains data on the area of the object in hectares.
Remark	string	This column contains any additional remarks or notes related to the object.
Shape_Leng	double	This column contains information about the length of the shape of the object.
Shape_Area	double	This column contains information about the area of the shape of the object.
geom_geojson	string	This column contains the geometric representation of the object in GeoJSON format.
geom_geotext	string	This column contains the geometric representation 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 object's geometry.
geom_center_x	double	This column contains the x-coordinate of the center of the object's geometry.
geom_center_y	double	This column contains the y-coordinate of the center of the object's geometry.

Historical Version Records of Geographical Data in Ostergotland Dataset

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. This column, in combination with '_row_number', is used to uniquely identify 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. A null value in this column 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. This column, in combination with '_start_date', is used to uniquely identify each row in this version history table.
OBJECTID	long	A unique identifier for each object in the table.
ID	string	An identification number for each entry in the table.
CODE_12	string	A code associated with each row of data.
Area_Ha	double	The area, in hectares, associated with each row of data.
Remark	string	Any additional comments or notes about a given row of data.
Shape_Leng	double	The length of the shape associated with each row of data.
Shape_Area	double	The area of the shape associated with each row of data.
geom_geojson	string	The geometric representation of the data in GeoJSON format.
geom_geotext	string	The geometric representation of the data in plain text format.
geom_type	string	The type of geometric representation used for the data.
geom_centroid	string	The geometric center point of the shape associated with each row of data.
geom_center_x	double	The X-coordinate of the geometric center point of the shape associated with each row of data.
geom_center_y	double	The Y-coordinate of the geometric center point of the shape associated with each row of data.

Geospatial Features and Attributes Dataset for Ostergotland Region

Column	Type	Comment
_extract_date	date	This column shows 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 column '_extract_date'.
OBJECTID	long	Unique identifier for each object in the table.
ID	string	Unique identifier for each row in the table.
CODE_12	string	Code number associated with the data.
Area_Ha	double	The area of the object/feature represented in the row, measured in hectares.
Remark	string	Notes or comments associated with the data in the row.
Shape_Leng	double	The length of the shape or object represented in the row.
Shape_Area	double	The area of the shape or object represented in the row.
geom_geojson	string	Geospatial data of the object in GeoJSON format.
geom_geotext	string	Geospatial data of the object in plain text.
geom_type	string	The type of the geometrical figure representing the object.
geom_centroid	string	The centroid of the geometrical figure representing the object.
geom_center_x	double	The x-coordinate of the center of the geometrical figure representing the object.
geom_center_y	double	The y-coordinate of the center of the geometrical figure representing the object.

Historical Version Record of Base Table Entries

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 in combination with the '_row_number' column for 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 identifier in combination with the '_start_date' column for each row in this version history table.
OBJECTID	long	Unique identifier of the object in the table.
ID	string	Identifier of the object in the original data source from 'Lantmäteriet' (The Land Survey of Sweden).
CODE_12	string	A code representing specific category or type associated with the row.
Area_Ha	double	The area of the object, measured in hectares.
Remark	string	Any additional comments or remarks about the row.
Shape_Leng	double	The length of the shape of the object.
Shape_Area	double	The area of the shape of the object.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object, represented as text.
geom_type	string	The type of the geometry of the object.
geom_centroid	string	The centroid of the geometry of the object.
geom_center_x	double	The x-coordinate of the center of the geometry of the object.
geom_center_y	double	The y-coordinate of the center of the geometry of the object.

Geospatial Analysis Data Table for Ostergotland Dataset Collection

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table 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 column '_extract_date'. This column along with '_extract_date' uniquely identifies each row.
OBJECTID	long	The object identifier, a unique identifier for each item in the table.
ID	string	The identification number of the data record.
CODE_12	string	The code 12, a specific code related to the data record.
Area_Ha	double	The area of the data record, measured in hectares.
Remark	string	Any additional remarks or comments related to the data record.
Shape_Leng	double	The length of the shape associated with the data record.
Shape_Area	double	The area of the shape associated with the data record.
geom_geojson	string	The GeoJSON representation of the geometry of the data record.
geom_geotext	string	The text representation of the geometry of the data record.
geom_type	string	The type of the geometry of the data record.
geom_centroid	string	The centroid of the geometry of the data record.
geom_center_x	double	The x-coordinate of the center of the geometry of the data record.
geom_center_y	double	The y-coordinate of the center of the geometry of the data record.

Historical Versioning of Land Structure Data

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 forms a unique identifier for 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 part of a unique identifier for each row when combined with '_start_date'.
OBJECTID	long	This column contains a unique identifier for each object in the table.
ID	string	This column contains an identification code for each row in the table.
CODE_12	string	This column contains a specific code associated with each row in the table.
Area_Ha	double	This column contains the area measurement of the object, measured in hectares.
Remark	string	This column contains any additional comments or remarks related to the 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 geometric representation of the object in GeoJSON format.
geom_geotext	string	This column contains the geometric representation of the object in text format.
geom_type	string	This column indicates the type of geometric object associated with each row.
geom_centroid	string	This column contains the centroid of the geometric object associated with each row.
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.

Land Classification Data Table from a Swedish Source

Column	Type	Comment
_extract_date	date	This column specifies 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 contains the unique object identifier.
ID	string	This column contains the unique identification number for each entry in the table.
CODE_12	string	This column contains the 12-digit code associated with each entry.
Area_Ha	double	This column represents the area of each entry, measured in hectares.
Remark	string	This column may include any additional remarks or comments about each entry.
Shape_Leng	double	This column represents the length of the shape of each entry.
Shape_Area	double	This column represents the area of the shape of each entry.
geom_geojson	string	This column contains the GeoJSON representation of each entry's geometry.
geom_geotext	string	This column contains the geotext representation of each entry's geometry.
geom_type	string	This column identifies the type of geometry for each entry (e.g., Point, LineString, Polygon).
geom_centroid	string	This column contains the centroid of each entry's geometry.
geom_center_x	double	This column contains the x-coordinate of the center of each entry's geometry.
geom_center_y	double	This column contains the y-coordinate of the center of each entry's geometry.

Historical Version Records of Base Table for Ostergotland 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 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 uniquely identifies each row in combination with '_start_date'.
OBJECTID	long	This column contains the object's identifier.
ID	string	This column contains the unique ID of the object.
CODE_12	string	This column contains a specific code associated with the object.
Area_Ha	double	This column contains the area of the object in hectares.
Remark	string	This column contains any remarks or additional information about the object.
Shape_Leng	double	This column contains the length of the object's shape.
Shape_Area	double	This column contains the area of the object's shape.
geom_geojson	string	This column contains the geometric representation of the object in GeoJSON format.
geom_geotext	string	This column contains the geometric representation of the object in text format.
geom_type	string	This column contains the type of the geometric representation of the object.
geom_centroid	string	This column contains the centroid of the geometric representation of the object.
geom_center_x	double	This column contains the X-coordinate of the center of the geometric representation of the object.
geom_center_y	double	This column contains the Y-coordinate of the center of the geometric representation of the object.

Geospatial Characteristics and Attributes of Ostergotland Region

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, helping in tracking the timeline of the data.
_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', uniquely identifying each row.
OBJECTID	long	This column represents a unique identifier for each object in the data.
ID	string	This column represents an additional unique identifier for the data.
CODE_12	string	This column contains specific codes associated with the data.
Area_Ha	double	This column represents the area of the data objects, measured in hectares.
Remark	string	This column may contain any additional remarks or comments about the data.
Shape_Leng	double	This column represents the length of the shape of the data objects.
Shape_Area	double	This column represents the area of the shape of the data objects.
geom_geojson	string	This column contains the geographical data of the objects in GeoJSON format.
geom_geotext	string	This column contains the geographical data of the objects in geotext format.
geom_type	string	This column represents the type of the geographical data of the objects.
geom_centroid	string	This column contains the centroid of the geographical data of the objects.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical data of the objects.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical data of the objects.

History Version of Base Table Rows With Geographical Attributes

Column	Type	Comment
_start_date	date	This column records the date when the data row was extracted from the data source. Along with '_row_number', it helps to uniquely identify each row in this version history table.
_end_date	date	This column records the date when 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 row number as it appears in the raw data extracted from the data source. It is used in conjunction with '_start_date' to uniquely identify each row in this version history table.
OBJECTID	long	This column assigns a unique object identifier to each row in the table.
ID	string	This column contains the unique identification number for each data entry.
CODE_12	string	This column holds a unique code that corresponds to specific data entries.
Area_Ha	double	This column records the area of the geographical feature in hectares.
Remark	string	This column contains any additional comments or notes regarding the data entry.
Shape_Leng	double	This column records the length of the shape of the geographical feature.
Shape_Area	double	This column records the area of the shape of the geographical feature.
geom_geojson	string	This column holds the geographical feature in GeoJSON format, a widely used open standard format designed for representing simple geographical features.
geom_geotext	string	This column holds the geographical feature in a textual format.
geom_type	string	This column states the type of the geographical feature.
geom_centroid	string	This column contains the centroid, or the geometric center, of the geographical feature.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical feature.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical feature.

Additional Info

Last Updated	September 13, 2024
Created	August 27, 2024