Collection of Geographical Data Tables from Sweden

The dataset collection in focus consists of five distinct tables. These tables are sourced from the website of Lantmäteriet (The Land Survey) in Sweden. Each table is a collection of related data, organized in a structured format featuring columns and rows. The data within these tables pertain to different attributes, as indicated by their technical names. However, a common theme across all tables can be observed, suggesting a focus on geographical or land-related data, likely specific to the region of Södermanland in Sweden. Thus, this dataset collection may serve as a valuable resource for research or analysis centered around geography, land use, or environmental studies in the specified region.

Tables

Geo-Spatial Data Analysis of Sodermanland RegionTSV
The table in question is a well-structured collection of related data, sourced from the 'Lantmäteriet' website, based in Sweden. This comprehensive table is part of a larger dataset collection and is uniquely organized into rows and columns. Each row is distinctively identified by a combination of its extraction date and row number, indicating when the data was extracted and its order in the extraction sequence. The table, rich in geographical data, originally had information in the shapefile format—a common method for storing geometric and attribute data of geographic features. This data has since been transformed into its final geographic format from the shapefile format, making it easier to analyse and interpret. The table contains a wealth of information such as object...
Geographical Information and Object Details of SödermanlandTSV
The table, which is part of a larger dataset, offers a rich collection of geographically-oriented details. It contains various data fields that include unique identifiers, codes, area measurements, remarks, and extensive geographic information. All of this data is sourced from 'Lantmäteriet' (The Land Survey) in Sweden. An important feature of this table is the presence of two special columns that include the date of data extraction and row number from the source, which together uniquely identify each row. The geographic information included in the table is initially in the shapefile format - a common geospatial vector data format for geographic information system software. It is noteworthy that this geographic data has been transformed into a final format from the initial shapefile...
Geospatial and Area Analysis Data for Sodermanland RegionTSV
The table in question is a valuable collection of geographic data, sourced from the 'Lantmäteriet' website in Sweden. It is a part of a larger dataset collection, emphasizing on data that has a spatial or geographical aspect. It contains a variety of columns, two of which are special: the extract date and the row number. The extract date indicates when the specific row of data was gathered from the source, and the row number represents the specific order in the extracted data, based on the extraction date. These two columns work together to uniquely identify each row of data. The data in this table is particularly unique because it was originally in a shapefile format, a common type of format for storing geographic location and attribute information. This format can represent...
Geospatial Information and Characteristics of Land ParcelsTSV
The table is a component of a dataset collection that originates from the 'Lantmäteriet' website, which is located in Sweden. It contains various types of information, including data pertaining to specific objects, identifiers, codes, remarks, and area measurements in hectares. Geographic details about these objects are also stored in this table. The geographic information was initially in the shapefile format, a common geographic data format, but has been converted to a final geographic format for this table. This table also includes two unique columns that contain information about the date on which data was extracted and the row number of the extracted data, ensuring that each row can be distinctly identified. In terms of data analytics, this table could be used in various ways. For...
Historical Version Records of Base Table Rows in Sodermanland Dataset CollectionTSV
The 'clc12_65f_so__history' table is a historical record originated from the dataset collection named 'sodermanland'. This historical record provides a version history of its base table rows, allowing users to track changes over time. Each row in the table is uniquely identified by a specific combination of its extraction date and its row number from the raw data. The table includes a start date indicating when the row was first extracted, and an end date showing when a new version of the row was introduced. If the end date is null, it signifies that the row is the most recent version. In addition to these time-related attributes, the table contains geographic information, which has been transformed from the original shapefile format. This geographic information can represent points,...
Sodermanland: Version History of Base Table RowsTSV
The history table is part of a dataset from Sweden, specifically sourced from the website of Lantmäteriet (The Land Survey). It maintains the version history of its base table rows, allowing for a comprehensive understanding of how the data has evolved over time. Each row in the table is uniquely identified by a combination of the extraction date and the raw row number from the original data source. The table also includes an end date for each row, indicating when a new version of the row was extracted. If the end date for a row is null, it signifies that this row is the most recent version. The table contains geographic information which has been transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features....
Spatial and Geometric Data Collection for Sodermanland RegionTSV
The table sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden forms part of a larger dataset. This table is a comprehensive collection of geographic information that has been transformed from the shapefile format, which is a common method of storing geometric location and attribute information of geographic features. These features can be represented by points, lines, or polygons (areas). The table includes unique identifiers for each row, which are established by a combination of the date the data was extracted and the row number for that specific extraction. These identifiers ensure that each piece of data can be accurately tracked and referenced. The table also includes various geographic attributes such as area, length, and the geographic center of the data. The...
Version History Data of Base Table Rows in Sodermanland CollectionTSV
This history table is an integral part of a dataset collection, which traces the version history of base table rows. The table allows for precise tracking of data changes over time, with specific columns indicating the date a row was extracted from the source, as well as the date when a new version of the row was obtained. If the latter column is null, this indicates that the current row is the most recent version. A unique identifier for each row in this version history table is formed by combining information on the extraction date and the raw data row number. The table also includes geographic information, originally in the shapefile format, which has been transformed into the final geographic format. This means that geographic features in the dataset can be represented by points,...
Version History of Base Table Rows in Sodermanland Dataset CollectionTSV
The table is a history table that forms an integral part of a larger dataset collection. It is responsible for tracking the version history of its base table rows, representing a dynamic record of changes over time. Each row in the table is uniquely identified by a combination of its extraction date and its original row number from the raw data. This table also includes start and end dates for each row version, giving a clear timeline of changes. If a row's end date is null, this indicates that it's the most recent version. The table was sourced from Lantmäteriet's website, located in Sweden. The table is enriched with a substantial amount of geographic information, which is represented in a final geographic format transformed from the original shapefile format. Shapefile is a widely...
Version History of Geospatial Data Elements in Södermanland Dataset CollectionTSV
The 'clc12_65f_no__history' table is a comprehensive history table that forms part of the 'sodermanland' dataset collection. As a history table, it holds the version history for each of its base table rows, allowing for the tracking of changes over time. This table boasts unique identifiers for each row, which are formed by a combination of the row's start date and its number in the raw data. This table contains key date columns that provide valuable insights into the data's timeline. For instance, it has a start date column indicating when each row was extracted from the data source, and an end date column marking when a new version of the row was extracted. If the end date column shows a null value, it signifies that the row is the most current version. Geographical information is...

Column Descriptions

Geographical Information and Object Details of Södermanland

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the data source.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column.
OBJECTID	long	This column represents an identifier for the object.
ID	string	This column is an ID that is unique to each object.
CODE_12	string	This column contains a code that is 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 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 a textual format.
geom_type	string	This column indicates 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 indicates the X-coordinate of the center of the geometry of the object.
geom_center_y	double	This column indicates the Y-coordinate of the center of the geometry of the object.

Sodermanland: Version History of Base Table Rows

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. It is used in combination with '_start_date' to uniquely identify each row in the version history table.
OBJECTID	long	A unique identifier for each object in the table.
ID	string	An identifier for each row in the table.
CODE_12	string	A specific code associated with each row.
Area_Ha	double	The area of the object in hectares.
Remark	string	Additional notes or comments associated with each row.
Shape_Leng	double	The length of the shape representing the object.
Shape_Area	double	The area of the shape representing the object.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in text format.
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 and Area Analysis Data for Sodermanland Region

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'.
OBJECTID	long	A unique identifier for each object in the table.
ID	string	An additional identifier for each row in the table.
CODE_12	string	A coded value representing a certain attribute or category associated with the row.
Area_Ha	double	The area, in hectares, associated with the row.
Remark	string	A column for additional notes or comments regarding the row.
Shape_Leng	double	The length of the shape associated with the row.
Shape_Area	double	The area of the shape associated with the row.
geom_geojson	string	The geometrical representation of the row in GeoJSON format.
geom_geotext	string	The geometrical representation of the row as text.
geom_type	string	The type of geometry represented in the row.
geom_centroid	string	The centroid, or geometric center, of the shape associated with the row.
geom_center_x	double	The X-coordinate of the center of the shape associated with the row.
geom_center_y	double	The Y-coordinate of the center of the shape associated with the row.

Version History of Geospatial Data Elements in Södermanland Dataset Collection

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source. It is part of a combination that uniquely identifies each row in this version history table.
_end_date	date	This column indicates the date when a new version of the row was extracted from the data source. If the value is null, it signifies that the row is the most recent version.
_row_number	long	This column contains the number of the row in the raw data extracted from the data source. Together with '_start_date', it forms a combination that 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 an identification value for the object.
CODE_12	string	This column contains a specific code associated with the object.
Area_Ha	double	This column represents the area of the object in hectares.
Remark	string	This column may contain additional comments or remarks about the object.
Shape_Leng	double	This column indicates 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 geographical data of the object in GeoJSON format.
geom_geotext	string	This column contains the geographical data of the object in plain text format.
geom_type	string	This column indicates the type of the geographical data of the object.
geom_centroid	string	This column contains the centroid of the geographical data of the object.
geom_center_x	double	This column contains the x-coordinate of the center of the geographical data of the object.
geom_center_y	double	This column contains the y-coordinate of the center of the geographical data of the object.

Geo-Spatial Data Analysis of Sodermanland Region

Column	Type	Comment
_extract_date	date	The date when the data on the row was extracted from the data 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	Another unique identifier for each object. It may be different from the OBJECTID.
CODE_12	string	A code associated with the object. The meaning of this code is specific to the dataset collection.
Area_Ha	double	The area of the object, in hectares.
Remark	string	Any additional information or remarks about the object.
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, in a textual format.
geom_type	string	The type of the geometry of the object (e.g., point, line, polygon).
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.

Historical Version Records of Base Table Rows in Sodermanland Dataset Collection

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 combination with '_row_number' that uniquely identifies each row in this version history table.
_end_date	date	The '_end_date' column holds the date when a new version of the row was extracted from the data source. If the value is null, it indicates that the row is the most recent version.
_row_number	long	The '_row_number' column contains the number of the row in the raw data extracted from the data source. It forms a unique identifier in conjunction with '_start_date' for each row in this version history table.
OBJECTID	long	The 'OBJECTID' column represents a unique identifier for each object in the table.
ID	string	The 'ID' column serves as a unique identifier for each entry in the dataset.
CODE_12	string	The 'CODE_12' column holds specific codes associated with each entry in the table.
Area_Ha	double	The 'Area_Ha' column denotes the area of the geographical feature, measured in hectares.
Remark	string	The 'Remark' column contains any additional notes or remarks pertaining to the row.
Shape_Leng	double	The 'Shape_Leng' column indicates the length of the geographical shape associated with the row.
Shape_Area	double	The 'Shape_Area' column represents the total area of the geographical shape related to the row.
geom_geojson	string	The 'geom_geojson' column stores the geographical information of the feature in GeoJSON format.
geom_geotext	string	The 'geom_geotext' column holds the geographical information of the feature in a text format.
geom_type	string	The 'geom_type' column specifies the type of the geographical shape related to the row.
geom_centroid	string	The 'geom_centroid' column indicates the centroid of the geographical shape associated with the row.
geom_center_x	double	The 'geom_center_x' column represents the X-coordinate of the center of the geographical shape related to the row.
geom_center_y	double	The 'geom_center_y' column denotes the Y-coordinate of the center of the geographical shape related to the row.

Spatial and Geometric Data Collection for Sodermanland Region

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. It plays a key role in identifying each row together with '_row_number'.
_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. Combined with '_extract_date', it uniquely identifies each row.
OBJECTID	long	This column contains unique identifiers for each object in the table.
ID	string	This column contains additional unique identifiers for the data entries.
CODE_12	string	This column holds specific codes associated with the data entries.
Area_Ha	double	This column represents the area of the geographical entity in hectares.
Remark	string	This column contains any additional remarks or comments about the data entries.
Shape_Leng	double	This column represents the length of the geographical shape associated with the data entry.
Shape_Area	double	This column represents the area of the geographical shape associated with the data entry.
geom_geojson	string	This column contains the geographical information of the data entry in GeoJSON format.
geom_geotext	string	This column contains the geographical information of the data entry in text format.
geom_type	string	This column categorizes the geometric type of the data entry.
geom_centroid	string	This column contains the centroid point of the geographical shape associated with the data entry.
geom_center_x	double	This column contains the X coordinate of the center point of the geographical shape associated with the data entry.
geom_center_y	double	This column contains the Y coordinate of the center point of the geographical shape associated with the data entry.

Version History of Base Table Rows in Sodermanland Dataset Collection

Column	Type	Comment
_start_date	date	The date when the row was extracted from the data source. Together with '_row_number', it uniquely identifies each row in this version history table.
_end_date	date	The date when a new version of the row was extracted from the data source. If the value is null, it means that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source. It forms a unique pair with '_start_date' for each row.
OBJECTID	long	A unique identifier for each object in the table.
ID	string	An identification number assigned to each entry in the table.
CODE_12	string	A specific code associated with each entry in the table.
Area_Ha	double	The area of the object represented by each row, measured in hectares.
Remark	string	A column for additional comments or notes pertaining to each entry.
Shape_Leng	double	The length of the shape or boundary of the object represented by each row.
Shape_Area	double	The area of the shape of the object represented by each row.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in a textual format.
geom_type	string	The type of the geometry of the object.
geom_centroid	string	The centroid or geometric center of the object.
geom_center_x	double	The x-coordinate of the center of the object.
geom_center_y	double	The y-coordinate of the center of the object.

Geospatial Information and Characteristics of Land Parcels

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. This, combined with the '_extract_date', uniquely identifies each row.
OBJECTID	long	An identifier for the object.
ID	string	The ID of the object.
CODE_12	string	A code associated with the object.
Area_Ha	double	The area of the object in hectares.
Remark	string	Any additional remarks or comments regarding the object.
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 geometric representation of the object in GeoJSON format.
geom_geotext	string	The geometric representation of the object in text format.
geom_type	string	The type of the geometric representation of the object.
geom_centroid	string	The centroid of the geometric representation of the object.
geom_center_x	double	The x-coordinate of the center of the geometric representation of the object.
geom_center_y	double	The y-coordinate of the center of the geometric representation of the object.

Version History Data of Base Table Rows in Sodermanland Collection

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from the data source. It helps to track the version history of the data along 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 row number from the raw data extracted from the source. Along with '_start_date', it uniquely identifies each row in this version history.
OBJECTID	long	This column contains unique identifiers for each object in the table.
ID	string	This column contains unique identifiers for each entry in the table.
CODE_12	string	This column contains specific codes associated with each row of data.
Area_Ha	double	This column contains data regarding the area in hectares for each entry.
Remark	string	This column contains any additional remarks or notes associated with each row.
Shape_Leng	double	This column contains information about the length of the shape associated with each entry.
Shape_Area	double	This column contains information about the area of the shape associated with each entry.
geom_geojson	string	This column contains the GeoJSON representation of the geometry of the area.
geom_geotext	string	This column contains textual description of the geometry in geographical terms.
geom_type	string	This column describes the type of the geometry used in the row.
geom_centroid	string	This column contains the geographical centroid of the shape associated with each entry.
geom_center_x	double	This column contains the x-coordinate of the center of the geometry.
geom_center_y	double	This column contains the y-coordinate of the center of the geometry.

Additional Info

Last Updated	September 13, 2024
Created	August 27, 2024