Collection of Geographical and Environmental Tables for Halland
Tables
-
Geospatial Characteristics and Land Classification DataTSV
The table under discussion is a collection of related data that has been sourced from 'Lantmäteriet' (The Land Survey) in Sweden. It is part of a larger dataset collection and holds a wealth of information. The table consists of a series of columns that each provide unique information. Two special columns contain the exact date the data was extracted and the row number that identifies its position in the extracted data. This combination allows each row in the table to be uniquely identified. Geographic information contained within the table was originally in a shapefile format - a format used to store location and attribute information of geographic features. This data has been transformed from this original format into a more final geographic format for use in the table. The data in...
-
Geospatial Data Analysis Table with Object Identifying and Geometric InformationTSV
The table in question is a comprehensive collection of geographic data sourced from Lantmäteriet, also known as the Swedish National Land Survey, in Sweden. It consists of a wide range of columns containing various data points. Notably, there are two special columns that contain the date of data extraction and the sequential row number from the extraction. These two columns together create a unique identifier for each row, thereby ensuring data integrity and traceability. While the geographic information in the original data source was in shapefile format, it has been transformed into a final format suitable for this dataset. In the realm of data analytics, this table can be leveraged in numerous ways. For instance, the geographic data can be used to analyze the spatial distribution of...
-
Geospatial Data Table on Land Use ClassificationTSV
The table is a structured collection of data, meticulously organized into rows and columns for easy comprehension and manipulation. It is part of a larger dataset collection, an integral segment in a broad ensemble of interconnected tables. This specific table originates from the 'Lantmäteriet' website, based in Sweden. The table captures a variety of data points. Two distinctive columns record the date of data extraction and the unique row number corresponding to that extraction. This combination serves as a unique identifier for each row, ensuring precise tracking and accurate data retrieval. The table also contains geographical information, which has been converted from the original shapefile format. Shapefiles, commonly used to store geographical features, can capture a variety of...
-
Historical Version Archive of Geospatial Elements in Sweden DatasetTSV
The table under consideration forms part of a larger dataset collection and serves as a history table, maintaining a comprehensive record of the version history of its base table rows. This table has been enriched with two additional columns that capture the date of extraction from the data source and the date at which a new version of the row was extracted. These dates are utilised in conjunction to form a unique identifier for each row in this version history table. Additionally, the table includes a column that enumerates the rows as they appear in the raw data from the data source. This table houses geographic information, originally in the shapefile format, which has been transformed into its final format. The geographic features are represented in various forms such as points,...
-
History Version Details of Base Table Rows in Dataset CollectionTSV
The table in consideration is a historical record table, capturing the version history of its base data. It is part of a dataset collection sourced from 'Lantmäteriet' (The Land Survey) in Sweden. This unique table tracks the changes in data over time, with specific columns indicating the date a row was extracted from the data source, and when a new version of the row was extracted. If the end date column has no entry, it signifies that the row is the most recent version. The table also houses a row number column, which in conjunction with the start date, uniquely identifies each row in this table. This table not only tracks historical changes, but also contains geographical data. The geographical information, originally in shapefile format, has been transformed into a final geographic...
-
Land Parcel Data with Geometric Attributes and RemarksTSV
The table is a well-structured collection of data that belongs to a larger dataset collection. It includes several columns, each representing distinct pieces of data, and rows, each signifying unique instances of these data points. Two special columns in the table signify the date of data extraction and the row number, together serving to uniquely identify each row. The data in this table originates from a shapefile, a type of file storing geographic location and attribute information of geographic features. This geographic information has been transformed from its original shapefile format to a final geographic format. The table is sourced from the website of 'Lantmäteriet', a Swedish organization. As for its potential applications, this table could be used in a wide range of data...
-
Version History of Base Table Rows in Swedish Dataset CollectionTSV
The table titled 'clc12_62d_so__history' is a historical record from the 'halland' dataset collection. This history table has been designed to keep track of the version history of its base table rows. It has additional columns that record the start and end dates of when each row was extracted from the data source. This unique feature allows each row in this version history table to be distinctly identified, with the combination of the starting date and the row number. If the end date for a row is null, it signifies that the row is the most recent version. The table also includes geographic data, transformed from the shapefile format into the final geographic format. This table was sourced from the 'Lantmäteriet' website, based in Sweden. The information held within this table can be...
-
Version History Records of Base Table Rows in the Halland Dataset CollectionTSV
The table under discussion is a history table, storing the version history of its base table rows. It is part of a dataset collection from Lantmäteriet (The Land Survey of Sweden), which is a significant source of geographic data in Sweden. This table is unique as it contains two additional columns for tracking the version history of its base table rows. These columns record the dates when a row was extracted from the data source and when a new version of the same row was extracted. If the latter date is null, it signifies that the row is the most current version. The table contains a mix of data types including geographical data. The geographical data, originally in shapefile format, was transformed into a final geographic format for easier use. The shapefile format is a popular...
Column Descriptions
Land Parcel Data with Geometric Attributes and Remarks
| 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. This, in combination with '_extract_date', uniquely identifies each row. |
| OBJECTID | long | This column contains the object identifier. It is a unique identifier assigned to each object in the table. |
| ID | string | This column contains the unique identification number associated with each entry in the table. |
| CODE_12 | string | This column contains a unique code assigned to each entry in the table. |
| Area_Ha | double | This column represents the area of a particular object in hectares. |
| Remark | string | This column contains any additional remarks or notes related to the specific entry. |
| Shape_Leng | double | This column signifies 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 geojson geometry of the object. GeoJSON is a format for encoding geographic data structures. |
| geom_geotext | string | This column contains the geotext representation of the object's geometry. |
| geom_type | string | This column specifies the type of the geometric object. |
| geom_centroid | string | This column contains the centroid of the geometric object. The centroid is a geometric center of a plane figure. |
| geom_center_x | double | This column represents the X coordinate of the center of the geometric object. |
| geom_center_y | double | This column represents the Y coordinate of the center of the geometric object. |
Version History Records of Base Table Rows in the Halland 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 unique identifier for each row in the version history table, when combined 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 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 part of a unique identifier for each row in the version history table, when combined with the '_start_date' column. |
| OBJECTID | long | This is a unique identifier for each object in the table. |
| ID | string | This column contains the ID of the object. |
| CODE_12 | string | This column contains a specific code related to the object. |
| Area_Ha | double | This column represents 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 textual geometric information about the object. |
| geom_type | string | This column indicates the type of geometric shape of the object. |
| geom_centroid | string | This column contains the centroid of the object's geometric shape. |
| geom_center_x | double | This column contains the x-coordinate of the center of the object's geometric shape. |
| geom_center_y | double | This column contains the y-coordinate of the center of the object's geometric shape. |
Geospatial Characteristics and Land Classification Data
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row 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 '_extract_date' column. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
| OBJECTID | long | This column contains the unique identifier of the object in the dataset. |
| ID | string | This column contains the identification number of the object. |
| CODE_12 | string | This column contains the 12-digit 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 comments related to 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 textual format. |
| geom_type | string | This column contains the type of geometric object (such as point, line, polygon, etc.). |
| geom_centroid | string | This column contains the centroid of the geometric object. |
| 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. |
Historical Version Archive of Geospatial Elements in Sweden 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', 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 of this column 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. This column, in combination with '_start_date', uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for each object in the table. |
| ID | string | An identifier for each element in the table. |
| CODE_12 | string | A code associated with each row in the table. |
| Area_Ha | double | The area measurement of the element in hectares. |
| Remark | string | An additional comment or note about the row. |
| Shape_Leng | double | The length of the shape represented by the row. |
| Shape_Area | double | The area of the shape represented by the row. |
| geom_geojson | string | The geometric representation of the element in GeoJSON format. |
| geom_geotext | string | The geometric representation of the element in text format. |
| geom_type | string | The type of the geometric element. |
| geom_centroid | string | The centroid of the geometric element. |
| geom_center_x | double | The x-coordinate of the center of the geometric element. |
| geom_center_y | double | The y-coordinate of the center of the geometric element. |
Geospatial Data Table on Land Use Classification
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column records the date when the data for that particular row was extracted from the source, in this case, the 'Lantmäteriet' website in Sweden. |
| _row_number | long | This column denotes 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 the unique identifier for each object in the table. |
| ID | string | This column holds the ID value associated with each row, typically serving as another unique identifier. |
| CODE_12 | string | This column stores a specific code associated with the data in the row, the purpose and meaning of which would be defined by the data source. |
| Area_Ha | double | This column holds the area of the object or feature, measured in hectares. |
| Remark | string | This column contains any additional notes or remarks about the data in the row. |
| Shape_Leng | double | This column records the length of the shape representing the object or feature, the unit of which would be defined by the data source. |
| Shape_Area | double | This column holds the area of the shape representing the object or feature, the unit of which would be defined by the data source. |
| geom_geojson | string | This column contains the geometric representation of the object or feature in GeoJSON format, a common format for encoding geographic data structures. |
| geom_geotext | string | This column holds the geometric representation of the object or feature in text format. |
| geom_type | string | This column denotes the type of the geometric representation of the object or feature. |
| geom_centroid | string | This column contains the centroid, or geometric center, of the object or feature. |
| geom_center_x | double | This column holds the X coordinate of the center of the geometric representation of the object or feature. |
| geom_center_y | double | This column records the Y coordinate of the center of the geometric representation of the object or feature. |
Version History of Base Table Rows in Swedish Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms a unique combination with the '_row_number' column to identify 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 as extracted from the data source. It forms a unique combination with the '_start_date' column to identify each row in the version history table. |
| OBJECTID | long | This column contains unique identifiers for each object in the table. |
| ID | string | This column contains unique identifiers for each row in the table. |
| CODE_12 | string | This column contains specific codes associated with each row. |
| Area_Ha | double | This column represents the area of the object, measured in hectares. |
| Remark | string | This column contains any additional remarks or comments related to the row. |
| Shape_Leng | double | This column represents 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 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 geometry 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 Data Analysis Table with Object Identifying 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 extract date. This column together with '_extract_date' uniquely identifies each row. |
| OBJECTID | long | This column contains a unique identifier for each object in the table. |
| ID | string | This column represents another unique identifier for each row in the table. |
| CODE_12 | string | This column contains specific codes related to the data in the row. |
| Area_Ha | double | This column represents the area of the object in hectares. |
| Remark | string | This column includes any additional notes or comments associated with the row. |
| Shape_Leng | double | This column holds the length of the shape representing the object. |
| Shape_Area | double | This column stores the area of the shape representing the object. |
| geom_geojson | string | This column contains the GeoJSON representation of the geographical object. |
| geom_geotext | string | This column includes the textual representation of the geographical object. |
| 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 represents the X coordinate of the geographical object's center. |
| geom_center_y | double | This column represents the Y coordinate of the geographical object's center. |
History Version Details of Base Table Rows in Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | Contains 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 | 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 | 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 | Unique identifier for each object in the table. |
| ID | string | Unique identification number for each row in the base table. |
| CODE_12 | string | Code that classifies the object based on a specific classification system. |
| Area_Ha | double | The area of the object in hectares. |
| Remark | string | Column for additional comments or remarks related to the object. |
| Shape_Leng | double | The length of the object shape's perimeter. |
| Shape_Area | double | The area of the object shape. |
| 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 object. |
| geom_centroid | string | The centroid of the geometric object. |
| geom_center_x | double | The x-coordinate of the geometric object's center. |
| geom_center_y | double | The y-coordinate of the geometric object's center. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | August 26, 2024 |