Swedish Geographic Dataset Collection: Detailed Information on Gotland
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 |