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

Swedish Geographic Dataset Collection: Detailed Information on Gotland

The 'Gotland' dataset collection comprises of multiple tables. These tables contain related data, which is organised in a consistent format of columns and rows for ease of analysis. The data for these tables is sourced from Lantmäteriet (The Land Survey), a website based in Sweden. Each table in the collection provides unique insights and can be used for various analytical purposes.

Tables

  • Geographical and Geometrical Descriptions of Land Types in GotlandTSV

    The table in question is a comprehensive collection of geographic data, hailing from the 'Lantmäteriet' (The Land Survey) website in Sweden. This table is a subset of a larger dataset collection, providing a wide array of information organized across numerous columns and rows. This table is unique in its inclusion of two special columns, which together form a unique identifier for each row. One of these columns contains the date when the data on the row was extracted, and the other contains the row number in the data extracted from the source on that specific date. The data within this table is primarily geographic, having originally been in the shapefile format - a format commonly used for storing geographic location and attribute information. The geographic features can be...

  • Geographical Information and Features of Gotland RegionTSV

    The table in question is a comprehensive collection of geographic and attribute data, sourced from the Swedish website 'Lantmäteriet'. While maintaining a detailed account of various geographic features, it offers a unique identifier for each row through a combination of extract date and row number. This ensures that each piece of data can be traced back to its original extraction date, providing a clear and reliable timeline for reference. The table contains a wide array of data categories, including specific object identification, area measurements in hectares, and comments or remarks pertinent to the data. It also features specific geographic data, transformed from the original shapefile format into a more accessible schema. This geographical information includes location and...

  • Historical Version Records of Base Table Rows in Gotland Dataset CollectionTSV

    The 'clc12_64h_sv__history' table is a historical data table that belongs to the 'gotland' dataset collection. This historical table stores the version history of the base table rows, making it a valuable resource for tracking changes over time. Each row in the table is uniquely identified by a combination of a start date and a row number, with the start date marking when the row was extracted from the data source, and the row number indicating its position in the raw data. There is also an end date for each row, which signifies 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. The data within the table includes a variety of geographical information, transformed from the shapefile format, which is a format used...

  • Version History Table of Base Rows as Part of Gotland Dataset Collection Sourced from a Prominent Swedish WebsiteTSV

    The table under consideration is a history table that forms a part of a dataset collection. This history table holds the version history of its base table rows, allowing for the tracking of changes over time. Each record in this table is uniquely identified by a combination of the extraction date and the row number in the original data source. The table also includes information about the start and end date of each version of a record, with a null end date indicating the most recent version. The table includes geographic information that was originally in shapefile format, a common geographic information system (GIS) format, but has been transformed into a final geographic format. This geographic information can represent various geographic features such as points, lines, or polygons....

Column Descriptions

Geographical Information and Features of Gotland Region

Column Type Comment
_extract_date date This column contains the date when the data on a particular row was extracted from the source. It helps in tracking when the specific set of data was retrieved.
_row_number long This column holds the row number in the data extracted from the source. This, in combination with the '_extract_date', uniquely identifies each row.
OBJECTID long This column contains the unique identifier for each object in the table.
ID string This column holds the ID associated with each row of data in the table.
CODE_12 string This column contains the 12-digit code associated with each row of data.
Area_Ha double This column represents the area (in hectares) associated with each row of data.
Remark string This column holds any additional comments or remarks related to the data in each row.
Shape_Leng double This column contains information about the length of the shape associated with each row of data.
Shape_Area double This column represents the area of the shape associated with each row of data.
geom_geojson string This column contains the geometric data of each row in GeoJSON format, which is a format for encoding a variety of geographic data structures.
geom_geotext string This column contains the geometric data in text format.
geom_type string This column specifies the type of geometric data associated with each row.
geom_centroid string This column contains the centroid of the geometric data associated with each row.
geom_center_x double This column holds the X-coordinate of the geometric center for each row of data.
geom_center_y double This column holds the Y-coordinate of the geometric center for each row of data.

Version History Table of Base Rows as Part of Gotland Dataset Collection Sourced from a Prominent Swedish Website

Column Type Comment
_start_date date This column contains the date when a specific row was extracted from the data source. It is one of the two unique identifiers for 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 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 as it appeared in the raw data extracted from the data source. It forms a unique combination with the _start_date column to identify each row in this version history table.
OBJECTID long This column contains the unique object identifier.
ID string This column contains an identification number.
CODE_12 string This column contains twelve-digit codes.
Area_Ha double This column contains data on the area in hectares.
Remark string This column contains any additional notes or remarks.
Shape_Leng double This column contains the length of the shape.
Shape_Area double This column contains the area of the shape.
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 text format.
geom_type string This column indicates the type of geometric figures.
geom_centroid string This column contains the centroid of the geometric figures.
geom_center_x double This column contains the x-coordinate of the geometric shape center.
geom_center_y double This column contains the y-coordinate of the geometric shape center.

Geographical and Geometrical Descriptions of Land Types in Gotland

Column Type Comment
_extract_date date This column contains the date when the data on the row was extracted from the data source, found on the website of Lantmäteriet (The Land Survey) in Sweden.
_row_number long This column contains the row number in the data extracted from the source on the date specified by the _extract_date column. It helps in uniquely identifying 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.
CODE_12 string This column contains special codes related to the data.
Area_Ha double This column contains the area of the object in hectares.
Remark string This column contains any additional remarks or comments related to the data.
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 geometric data of the object in GeoJSON format.
geom_geotext string This column contains the geometric data of the object in textual format.
geom_type string This column contains the type of geometry used for the object.
geom_centroid string This column contains the geometric center (centroid) of the object.
geom_center_x double This column contains the X-coordinate of the geometric center of the object.
geom_center_y double This column contains the Y-coordinate of the geometric center of the object.

Historical Version Records of Base Table Rows in Gotland Dataset Collection

Column Type Comment
_start_date date This column holds the date when the specific row was extracted from the data source.
_end_date date This column contains the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version.
_row_number long This column contains the number of the row as it appears in the raw data extracted from the data source. This number, combined with the start date, uniquely identifies each row in this version history table.
OBJECTID long This column contains unique identifiers for the objects in the table.
ID string This column represents the unique ID of each entity in the table.
CODE_12 string This column contains specific codes associated with the rows.
Area_Ha double This column represents the area of the entities, measured in hectares.
Remark string This column contains any additional remarks or comments related to the entities.
Shape_Leng double This column represents the length of the shape of the entities.
Shape_Area double This column represents the area of the shape of the entities.
geom_geojson string This column contains the geographical data of the entities in GeoJSON format.
geom_geotext string This column contains the geographical data of the entities in text format.
geom_type string This column specifies the type of the geographical data.
geom_centroid string This column contains the centroid of the geographical entities.
geom_center_x double This column contains the x-coordinate of the center of the geographical entities.
geom_center_y double This column contains the y-coordinate of the center of the geographical entities.

Additional Info

Last Updated September 18, 2024
Created August 26, 2024