Collection of Tables Sourced from a Swedish Web Site Focusing on Vastra Gotaland Region
Tables
-
Geographical and Statistical Data Table of Vastra GotalandTSV
This table is an integral part of a larger dataset collection. It is compiled with diverse types of data, each type represented in its own column, and each row representing a unique data entry. Notably, two columns serve as the backbone of the table structure, holding the date of data extraction and the row number of each entry, respectively. This combination ensures the unique identification of each row, providing a stable structure for data analysis. The table also carries geographic information, initially stored in a shapefile format known for its simplicity and versatility in storing geographic features, which could be points, lines, or areas. This geographic data has been converted into a final format from the original shapefile format. The data for this table is gathered from...
-
Geographical Information and Property Details Sourced from a Swedish Web DatabaseTSV
The table in question is a part of a dataset collection that is organized in a structured format with columns and rows. It contains a variety of data including geographic information and unique identifying features. Two notable columns contain data about the extraction date and the row number, which can be used together to uniquely identify each row. The geographic information originally comes in the shapefile format, a commonly used format for storing the geometric location and attribute information of geographic features. This data could have been represented by points, lines, or polygons in the original shapefile format, but it has been transformed into the final format for use in this table. This table is sourced from the website of 'Lantmäteriet' (The Swedish Land Survey) in...
-
Geospatial Characteristics and Attributes of Land AreasTSV
The table is a collection of related data hailing from the dataset collection 'vastra_gotaland'. It comprises a variety of columns that carry essential information regarding each data entry. Among these columns are two special ones: one that records the date when the data was extracted from the source, and another that indicates the row number in the data extracted from the source on that particular date. These two columns together uniquely identify each row in the table. Additionally, the table includes geographic information that originated in the shapefile format, a format used for storing the geometric location and attribute information of geographic features. This geographic information has since been transformed into its final format from the shapefile format. The table's data...
-
Geospatial Data Table with Object Details and Geometric InformationTSV
The table is a component of a larger dataset collection and contains a variety of data types. One of the distinguishing features of this table is the inclusion of two special columns. These indicate the date the row's data was extracted and the row's number in the original extraction, with the combination of these two values providing a unique identification for each row. This table also includes geographical information, which has been transformed from a shapefile format. Shapefiles are used to store geographical feature data, including the location and attributes of these features, which can be represented as points, lines, or polygons. The table is sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. In terms of data analytics, the information from this table could...
-
Geospatial Data Table with Object Identification, Area, and Geometric AttributesTSV
The table in focus is part of a dataset collection, hailing from Vastra Gotaland. It comprises of a multitude of columns, each holding specific data. Two distinctive columns contain data regarding the date of extraction and the row number from the original data source. These two, in combination, serve as unique identifiers for each row. The table also carries geographic information, which has been transformed from the shapefile format, a format used for storing geometric location and attribute information of geographic features. This geographic data can represent points, lines, or polygons, thus providing a robust understanding of the spatial aspects of the data. The data for this table is sourced from the website of Lantmäteriet (The Land Survey of Sweden) in Sweden. As for its...
-
Historical Versions of Land Classification Data in Västra Götaland RegionTSV
The history table under consideration is a part of a dataset collection and provides an extensive track of version history of its base table rows. It maintains a unique identification for each row using a combination of the date when the row was extracted and the row number. The table also maintains the date when a new version of the row was extracted, assisting in identifying the most recent version of a row. The table provides detailed geographic information transformed from the shapefile format, a format used for storing the geometric location and attribute information of geographic features. This geographic information can include points, lines, or polygons (areas). The table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey). The information in this table could...
-
Version History of Base Table Rows - History Table (Sourced from a Swedish Website)TSV
The table under consideration is a historical record that forms part of a larger dataset from the region of Västra Götaland. It serves as a log of changes made to its corresponding base table, with two additional fields that mark the start and end dates for each row entry. This setup allows for the tracking of the complete life cycle of each row, from when it was first pulled from the source to when it was last updated. If the end date for a row is not specified, it signifies that the version in question is the most recent. The data in the table is sourced from the Swedish website 'Lantmäteriet' (The Land Survey). The table also includes geographic data, transformed from the shapefile format, typically used to store geometric location and attribute information of geographical features....
-
Version History of Base Table Rows From the Vastra Gotaland Dataset CollectionTSV
The 'clc12_63d_nv__history' table belongs to the 'vastra_gotaland' dataset collection. As a history table, it keeps a record of the version history of its base table rows. It has two additional columns to its base table, which mark the start and end dates of each version of a row. If the end date is null, it represents the most recent version of the row. Each row also has a unique identifier formed by a combination of the start date and the row number. The data also includes geographic information, originally in the shapefile format, which stores the geometric location and attribute information of geographic features, and has been transformed into the final geographic format. The table is sourced from the 'Lantmäteriet' (The Land Survey) website in Sweden. The data in this table could...
-
Version History of Base Table Rows in Vastra Gotaland DatasetTSV
The 'clc12_63d_no__history' table is a history table that is part of the 'vastra_gotaland' dataset collection. It maintains a version history of its base table rows, making it an invaluable resource for tracking changes over time. This table's row data is uniquely identified by a combination of the extraction date and the row number. The table provides an additional layer of information compared to its base table by including the start and end dates of each row's extraction from the data source. If a row's end date is null, it signifies that the row is the most recent version. The table is sourced from the Swedish website, 'Lantmäteriet' (The Land Survey). The table incorporates geographic data, which is initially in the shapefile format - a format used for storing the geometric...
-
Version History of Base Table Rows in Vastra Gotaland Dataset CollectionTSV
The 'clc12_63d_so__history' table is a historical table sourced from the Swedish website 'Lantmäteriet' (The Land Survey). It is part of the 'vastra_gotaland' data collection. This table records the version history of its base table rows, which makes it especially valuable for tracking changes over time. It consists of several columns, each providing unique and valuable information. For example, each row in this table can be uniquely identified by a combination of the row's unique number and the date it was extracted from the data source. The table includes two special columns that record the start and end dates of each row's existence in the data source. If the end date is null, this indicates that the current version of a row is the most recent. This feature is particularly useful...
Column Descriptions
Geospatial Characteristics and Attributes of Land Areas
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. It helps in tracing the origin of the data. |
_row_number | long | This column contains the unique row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It assists in uniquely identifying each row. |
OBJECTID | long | This column represents the unique identifier for each object in the table. |
ID | string | This column contains individual identification numbers for each row in the data. |
CODE_12 | string | This column contains specific codes associated with each row of the data. |
Area_Ha | double | This column represents the area of the geographic object, measured in hectares. |
Remark | string | This column contains any additional notes or comments about the data in the row. |
Shape_Leng | double | This column provides the length of the geographical shape represented by the data in the row. |
Shape_Area | double | This column represents the area of the geographical shape represented by the data in the row. |
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 text format. |
geom_type | string | This column specifies the type of the geographical object represented in the row. |
geom_centroid | string | This column provides the geographical center of the object using the centroid method. |
geom_center_x | double | This column provides the X coordinate of the geographical center of the object. |
geom_center_y | double | This column provides the Y coordinate of the geographical center of the object. |
Version History of Base Table Rows in Vastra Gotaland 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 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 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 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 a unique identifier associated with the data row. |
CODE_12 | string | This column contains specific codes related to the data row. |
Area_Ha | double | This column represents the area measurement in hectares associated with the data row. |
Remark | string | This column contains any remarks or additional information related to the data row. |
Shape_Leng | double | This column represents the length of the shape associated with the data row. |
Shape_Area | double | This column represents the area of the shape associated with the data row. |
geom_geojson | string | This column contains the GeoJSON representation of the geometry associated with the data row. |
geom_geotext | string | This column contains the text representation of the geometry associated with the data row. |
geom_type | string | This column indicates the type of the geometry associated with the data row. |
geom_centroid | string | This column contains the centroid of the geometry associated with the data row. |
geom_center_x | double | This column contains the X coordinate of the center of the geometry associated with the data row. |
geom_center_y | double | This column contains the Y coordinate of the center of the geometry associated with the data row. |
Geographical and Statistical Data Table of Vastra Gotaland
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 contains the object identifier. |
ID | string | This column contains the identification code. |
CODE_12 | string | This column contains the 12-digit code. |
Area_Ha | double | This column represents the area in hectares. |
Remark | string | This column contains any additional remarks or notes. |
Shape_Leng | double | This column represents the length of the shape. |
Shape_Area | double | This column represents the area of the shape. |
geom_geojson | string | This column contains the geometric data in GeoJSON format. |
geom_geotext | string | This column contains the geometric data in text format. |
geom_type | string | This column describes the type of the geometric data. |
geom_centroid | string | This column contains the centroid of the geometric data. |
geom_center_x | double | This column contains the x-coordinate of the geometric center. |
geom_center_y | double | This column contains the y-coordinate of the geometric center. |
Historical Versions of Land Classification Data in Västra Götaland Region
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was initially extracted from the data source. It forms a unique identifier for each row in combination 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 means that the row is the most recent version. |
_row_number | long | This column contains the number of the row as it was in the raw data extracted from the data source. It forms a unique identifier for each row in combination with '_start_date'. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains a unique ID for each object in the table. |
CODE_12 | string | This column contains a code associated with each object in the table. |
Area_Ha | double | This column contains the area of each object, measured in hectares. |
Remark | string | This column contains any remarks or additional information about each object. |
Shape_Leng | double | This column contains the length of the shape of each object. |
Shape_Area | double | This column contains the area of the shape of each object. |
geom_geojson | string | This column contains the GeoJSON representation of each object's geometry. |
geom_geotext | string | This column contains a textual representation of each object's geometry. |
geom_type | string | This column contains the type of geometry for each object. |
geom_centroid | string | This column contains the centroid of each object's geometry. |
geom_center_x | double | This column contains the x-coordinate of the center of each object's geometry. |
geom_center_y | double | This column contains the y-coordinate of the center of each object's geometry. |
Geographical Information and Property Details Sourced from a Swedish Web Database
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. |
_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 | This column contains a unique identifier for each object in the table. |
ID | string | This column contains an additional unique identification code for each row of the table. |
CODE_12 | string | This column contains a code associated with the data in the row. |
Area_Ha | double | This column contains the area measurement of the data object, represented in hectares. |
Remark | string | This column may contain any additional notes or remarks related to the data in the row. |
Shape_Leng | double | This column contains the length of the shape associated with the data object. |
Shape_Area | double | This column contains the area of the shape associated with 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 a text format. |
geom_type | string | This column indicates the type of geometric representation used for the data object (e.g., point, line, polygon). |
geom_centroid | string | This column contains the centroid (geometric center) of the data object. |
geom_center_x | double | This column contains the x-coordinate of the geometric center of the data object. |
geom_center_y | double | This column contains the y-coordinate of the geometric center of the data object. |
Version History of Base Table Rows From the Vastra Gotaland Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. It forms part of the unique identifier for each row in this version history table, when combined 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 number of the row in the raw data extracted from the data source. It forms part of the unique identifier for each row in this version history table, when combined with '_start_date'. |
OBJECTID | long | This column contains the object ID associated with each row. |
ID | string | This column contains the ID value associated with each row. |
CODE_12 | string | This column contains the 12-digit code associated with each row. |
Area_Ha | double | This column contains the area size in hectares associated with each row. |
Remark | string | This column contains any remarks or comments associated with each 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 geometry of the row in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the row in text format. |
geom_type | string | This column contains the type of geometry associated with each row. |
geom_centroid | string | This column contains the centroid of the geometry associated with each row. |
geom_center_x | double | This column contains the X coordinate of the center of the geometry associated with each row. |
geom_center_y | double | This column contains the Y coordinate of the center of the geometry associated with each row. |
Geospatial Data Table with Object Identification, Area, and Geometric Attributes
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data on a particular row was extracted from the source. |
_row_number | long | This column contains the row number in the data that was extracted from the source on the extract date specified by the column '_extract_date'. |
OBJECTID | long | This column contains the unique identifier for each object in the table. |
ID | string | This column contains a unique identifier for each row in the table. |
CODE_12 | string | This column contains specific codes related to the data in the table. |
Area_Ha | double | This column indicates the area of the geographical object in hectares. |
Remark | string | This column is for any additional comments or observations regarding the data. |
Shape_Leng | double | This column contains the length of the geographical object's shape. |
Shape_Area | double | This column contains the area of the geographical object's shape. |
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 text format. |
geom_type | string | This column specifies the type of the geographical object. |
geom_centroid | string | This column contains the centroid of the geographical object. |
geom_center_x | double | This column contains the X coordinate of the geographical object's center. |
geom_center_y | double | This column contains the Y coordinate of the geographical object's center. |
Version History of Base Table Rows - History Table (Sourced from a Swedish Website)
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 unique identifier for each row in this version history table, along with the '_row_number' column. |
_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 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 in this version history table, combined with the '_start_date' column. |
OBJECTID | long | This column contains an object identifier. |
ID | string | This column contains an identification number. |
CODE_12 | string | This column contains a 12-character code. |
Area_Ha | double | This column contains the area of the object in hectares. |
Remark | string | This column contains remarks or comments related to the row. |
Shape_Leng | double | This column contains the length of the shape in the row. |
Shape_Area | double | This column contains the area of the shape in the row. |
geom_geojson | string | This column contains the geojson format of the geometry of the object. |
geom_geotext | string | This column contains the geotext format of the geometry of the object. |
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. |
Geospatial Data Table with Object Details and Geometric Information
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 specified extract date. |
OBJECTID | long | The unique identifier for each object in the table. |
ID | string | The unique identification number assigned to each row in the table. |
CODE_12 | string | The unique code assigned to each data item in the table. |
Area_Ha | double | This column represents the area of physical or geographical features recorded in hectares. |
Remark | string | This column contains any additional comments or notes related to the data entry. |
Shape_Leng | double | This column represents the length of the geographical or physical shape. |
Shape_Area | double | This column represents the area of the geographical or physical shape. |
geom_geojson | string | This column contains the geographical data in GeoJSON format. |
geom_geotext | string | This column contains the geographical data in text format. |
geom_type | string | This column describes the type of geographical data, such as point, line, or polygon. |
geom_centroid | string | This column represents the centroid of the geographical shape. |
geom_center_x | double | This column represents the x-coordinate of the center of the geographical shape. |
geom_center_y | double | This column represents the y-coordinate of the center of the geographical shape. |
Version History of Base Table Rows in Vastra Gotaland Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the 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. If the value is null, it means that the row is the most recent version of the row. |
_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 uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains an object identifier. |
ID | string | This column contains an identification value. |
CODE_12 | string | This column contains a coded value. |
Area_Ha | double | This column contains data related to the area in hectares. |
Remark | string | This column contains any remarks or comments related to the row. |
Shape_Leng | double | This column contains information about the length of the shape. |
Shape_Area | double | This column contains information about the area of the shape. |
geom_geojson | string | This column contains the geometric data in GeoJSON format. |
geom_geotext | string | This column contains the geometric data in text format. |
geom_type | string | This column specifies the type of geometry. |
geom_centroid | string | This column contains the centroid or geometric center of a shape. |
geom_center_x | double | This column contains the x-coordinate of the geometric center. |
geom_center_y | double | This column contains the y-coordinate of the geometric center. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 27, 2024 |