gavleborg
Tables
-
Comprehensive Data Collection on Geometric and Area PropertiesTSV
The table originates from 'Lantmäteriet' (The Land Survey of Sweden) website in Sweden. It is a meticulously organised collection of geographical data, arranged into rows and columns to provide detailed mapping information. Each row in the table is distinctively identified by a unique combination of extraction date and row number, indicating when the data was sourced and its position in the extraction sequence. This ensures accuracy and traceability of the data. The table includes geographic data transformed from shapefile format, which is a standard for storing geographical features and locations. This geographic information could take the form of points, lines, or polygons (areas). The table also includes additional columns that provide more specific details about the geographic data...
-
Geographical Data Collection with Object Identifiers, Area Measurements, and Geometrical AttributesTSV
The table under discussion is a part of a dataset collection and it provides a wealth of information that can be of immense interest to data analysts. It originates from 'Lantmäteriet' (The Land Survey), a website based in Sweden. The table is unique as it contains a blend of both temporal and geographic data. It provides information about the date when the data was extracted along with a unique row number for each extraction. This combination allows for each row to be uniquely identified, making it easy to track changes over time. One of the key features of this table is its geographical data, which was originally in the shapefile format. Shapefile is a popular format for storing geographic features, including points, lines, and polygons. However, in this table, the geographic data...
-
Geospatial Characteristics and Metrics of Land ParcelsTSV
The table in question originates from the 'Lantmäteriet' website, located in Sweden. This table forms part of a larger dataset collection. It provides a wide range of data in a structured format, organized into multiple rows and columns. The specifics of each row are uniquely identified by a combination of two key components: the date when the data was extracted and the row number corresponding to that extraction date. Both these columns contribute to the uniqueness of each row. The table holds geographic information, initially in the shapefile format, a common, straightforward format for storing geometric location and attribute information of geographic features. This information could be represented by points, lines, or polygons (areas). However, in this dataset, the geographic...
-
Geospatial Characteristics and Quantitative Data Collection from SwedenTSV
The table is a part of a larger dataset and contains a variety of information, all sourced from the Swedish website, Lantmäteriet. The data within this table is organized into several columns, each containing unique information. Two key columns are responsible for identifying each row of data, specifically the date the data was extracted and the row number from the original data source. This ensures that each row is uniquely identifiable. In addition, the table contains geographic information derived from geographic features which have been transformed from the shapefile format. These can be represented by points, lines, or polygons (areas). The data in this table can be put to a variety of uses in data analytics. For instance, the geographic information can be used in spatial...
-
Geospatial Data Analysis and Mapping CollectionTSV
The table under consideration is a detailed compilation of geographic features, obtained from the Swedish website, Lantmäteriet. It carries a wealth of information about various geographic attributes, including unique identifiers, area measurements, remarks, and several aspects of geographic geometry. The geometry data was initially in shapefile format - a standard for simple, non-topological geographic features - but has been processed into its final form in this dataset. Two special features of the table are the extraction date and row number. The extraction date tells us when each row of data was gathered from its source, while the row number indicates its position in the extracted data. These two columns work together to uniquely identify each row in the table. This table, with its...
-
Geospatial Data Analysis and Object Details from Swedish National Land SurveyTSV
The table is a rich collection of geographic data, meticulously organized into an informative structure. It is derived from the dataset found on the Lantmäteriet (The Swedish Land Survey) website in Sweden. Each row in the table is uniquely identified by a combination of two significant factors: the date when the data was extracted, and the row number on the extraction date. This makes each entry both unique and traceable back to its source extraction point. Moreover, the table contains geographic data, transformed from the shapefile format, which is a popular format for geospatial vector data. This geographic data can represent features as points, lines, or polygons. This table can be a valuable asset in various data analytics applications. For example, it can be used to analyze land...
-
Geospatial Data on Area and Object Identification from a Swedish SourceTSV
The table originates from the 'Lantmäteriet' website, based in Sweden. It carries a wealth of geographic and attribute information, transformed from a shapefile format, which is a common format for geographic data storage. It contains various columns representing different types of data, including object identification, specific codes, area measurements, remarks, shape length and area, and different components of geographic data, among others. Two special columns in the table are dedicated to data extraction details, providing the specific date of extraction and the row number, which together uniquely identify each row of data. This table offers a myriad of possibilities for data analytics applications. For instance, the data can be used to analyze geographic feature changes over time...
-
Geospatial Features and Attributes Data Table from Swedish DatabaseTSV
The table in question is a collection of related data sourced from Lantmäteriet (The Land Survey) in Sweden. It's a part of a larger dataset collection and includes a diverse array of columns that capture various aspects of the data set. Two special columns in the table are dedicated to keeping track of the date of data extraction and the row number from the source data, respectively. This ensures that each row is uniquely identified, allowing for precise tracking and referencing. Furthermore, the table includes geographic information that has been transformed from the shapefile format. The shapefile is a popular geospatial vector data format for geographic information system (GIS) software, and its inclusion in the table adds a geographical dimension to the data, making it ideal for...
-
Gävleborg Collection: Detailed Geographical Data TableTSV
The table originates from the 'Gävleborg' data collection and is a rich source of geographically related information. Sourced from the website of 'Lantmäteriet' (The Swedish National Land Survey) in Sweden, the table contains a variety of columns, each providing unique data points. A key aspect of this table is the presence of geographical data which has been transformed from the shapefile format. This includes information about the geometric location and attributes of geographic features, which can be represented by points, lines, or polygons. This information is found in various columns in the table, providing a comprehensive geographical data set. Additionally, the table has two special columns that contain the date of data extraction and the row number from the original data source...
-
History of Version Changes in Geospatial Data Attributes: A Swedish Dataset CollectionTSV
The table is a historical record sourced from the 'Lantmäteriet' website in Sweden. It is part of a larger dataset that tracks changes over time. It includes unique identifiers for each row, which are determined by a combination of the extraction date and row number from the original data source. This table also includes start and end dates for each row's version, allowing for the tracking of changes over time. If the end date is not present, it signifies that the version is the most recent one. The table also contains geographic data that has been transformed from shapefile format, a common format for geospatial vector data. This allows for the representation of geographical features such as points, lines, and polygons. Potential uses for this table in data analytics could include...
-
Land and Geographic Information Data CollectionTSV
The table is a structured collection of related spatial data, meticulously derived from 'Lantmäteriet' (The Land Survey), Sweden. The table is part of a larger dataset collection. It contains a variety of columns that hold specific, meaningful data. Two special columns hold the date of data extraction and the row number from the source data, which together form a unique identifier for each row. The geographic data, originally in shapefile format, has been transformed into its final format in this table. Shapefile is a popular geospatial vector data format for geographic information systems software, capable of storing points, lines, or polygons. In terms of data analytics, this table could provide valuable insights. For instance, an urban planner could use the geographic data to study...
-
Land Survey Data: Detailed Geographical Features and MetricsTSV
The table under consideration is a rich collection of geographic data sourced from 'Lantmäteriet' (The Land Survey) in Sweden. It forms a part of a larger dataset and provides detailed information about diverse geographic features, including their location, size, and shape. Two special columns in the table provide the date of data extraction and the row number that uniquely identifies each record, ensuring the accuracy and traceability of the data. The table is particularly valuable due to its transformation of geographic data from the widely-used shapefile format into a final geographic format. This means that it contains in-depth spatial data including the geometric location of geographic features, which can be represented by points, lines, or polygons (areas). This table can be...
-
Version History of Base Table Rows in a Dataset CollectionTSV
The table under discussion is a history table, which encapsulates the version history of its base table rows. This aspect makes it unique as it contains two additional columns that record the start and end date of each row. This feature allows for tracking the evolution of data over time as each row represents a unique version of the data extracted from the source. The start date signifies when the row was extracted from the data source while the end date indicates when a new version of the row was pulled. If the end date is null, it indicates that the version of the row is the most recent. The table also includes geospatial data, which was initially in the shapefile format. Shapefile is a standard format for storing geographical features and attributes. The geospatial information in...
-
Version History of Base Table Rows in Gavleborg DatasetTSV
The 'clc12_67g_sv__history' table is part of the 'gavleborg' dataset collection. This historical table provides a version history of its base table rows, containing two additional columns for recording the start and end dates of each row's extraction from the data source. This provides a unique identifier for each row, based on the combination of extraction date and row number. The table provides an array of data, including geographical information converted from the shapefile format, which could include points, lines, or polygons. This data, when combined with other columns in the table, offers a comprehensive view of each entry's historical data. Notably, if a row's end date is null, it signifies that the row is the most recent version. The data for this table comes from the...
-
Version History of Base Table Rows in Gavleborg Dataset CollectionTSV
The 'History' table is a fascinating compilation of data, sourced from the Swedish website, 'Lantmäteriet'. This table forms a crucial part of a larger dataset collection, playing the key role of preserving the version history of the base table rows. Each row in this table is uniquely identified by a combination of the date of extraction and the row number in the raw data. The table is enriched with timestamps indicating the start and end dates of each row's validity. An interesting feature is that if the end date of a row is null, it signifies that the row is the most recent version. This temporal dimension of the data offers a unique opportunity to track changes over time and understand the evolution of the data. Moreover, the table also stores geographic information, which has been...
-
Version History of Base Table Rows in the Gavleborg Dataset CollectionTSV
The 'clc12_66f_no__history' table is a historical record sourced from the official website of Lantmäteriet (The National Land Survey) in Sweden. It is part of the larger 'gavleborg' dataset collection. As a history table, it maintains the version history of its base table rows, allowing for tracking changes over time. This is achieved through two additional columns that record the date a row was extracted from the source and the date a new version of that row was extracted. Consequently, it provides a unique identifier for each row, based on the extraction date and the row number. The table also contains geographic information, which has been converted from the shapefile format, a common format for storing geographic location and attribute information. Potential applications of this...
-
Version History of Base Table Rows with Geographical Elements from a Swedish SourceTSV
The table under discussion is a history table sourced from the Lantmäteriet website in Sweden. It provides a version history of its base table rows, with each row being uniquely identifiable through a combination of specific date of extraction and row number. The table holds additional columns compared to its base: the date when the row was initially extracted and the date when a fresh version of the row was extracted. When the latter date is null, it indicates that the row is the most recent version. This table also contains geographic data, originally in shapefile format, which has been transformed into the final geographic format. This rich dataset can be instrumental for various data analytics applications. For instance, the temporal aspect of the data can be used to track changes...
-
Version History of Geospatial Records in Gavleborg CollectionTSV
The table in question is a historical record type, sourced from the 'Lantmäteriet' (The Land Survey) website, based in Sweden. It is a component of a larger dataset collection. This table is essentially a record of past versions of its corresponding base table. It includes specific columns for recording the dates of data extraction from the source, as well as the dates of any new versions of the data. The table uniquely identifies each row using a combination of the date of extraction and the row number from the original raw data. If a row is the most current version, the date of the new version will be left blank. This table also contains geographical information, originally in the shapefile format, which is a common format for storing geographical feature data. These features can be...
-
Version History Records of Base Table in Gävleborg Dataset CollectionTSV
The 'clc12_67g_so__history' table is a historical archive, storing the version history of its fundamental dataset. It provides a rich historical context for each row, marking changes over time with two additional columns compared to its base table. These columns track the date of extraction from the data source and indicate when a fresh version of the row was extracted. If the end date is null, it signifies that the row is the most recent version. The table has a unique identifier for each row, which is a combination of the start date and a row number that signifies the order of the row in the raw data pulled from the source. This combination allows for easy tracking of data modifications over time. The dataset is rich in geographical information, originally sourced in a shapefile...
-
Version History Table for Area Measurements and Geometric PropertiesTSV
The table in question is a historical record, which is part of a larger dataset collection. It is sourced from the 'Lantmäteriet' website, based in Sweden. The table holds version history for each of its base table rows, meaning it contains two additional columns compared to its base table to hold timestamps for when a row was extracted and when a new version was added. This feature makes this table unique as it allows for tracking changes over time, offering a timeline of the data evolution. The table includes a unique combination of a start date and row number to distinctly identify every row. It also captures the date a new version of a row was added. If the end date field is empty, it indicates that the current row is the most recent version. One of the notable aspects of this table...
-
Version History Table of Base Rows in Gavleborg Dataset CollectionTSV
The table in question is a historical dataset, sourced from Lantmäteriet (The National Land Survey) in Sweden. This table is part of a broader dataset collection, and it serves as the version history of its base table rows. Unique characteristics of this table include two additional columns compared to its base table, which track the start and end dates of each row. This feature allows users to see when a row was first extracted from the data source, and when a new version of the row was extracted. If the end date column is null, it indicates that the row is the most recent version. Another key aspect of this table is its incorporation of geographic information, transformed from the shapefile format - a common format for storing geometric location and attribute information of geographic...
Column Descriptions
Land Survey Data: Detailed Geographical Features and Metrics
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. This column, in combination with '_extract_date', uniquely identifies each row. |
OBJECTID | long | A unique identifier for the object. |
ID | string | An identifier for the data entry. |
CODE_12 | string | A code representing specific characteristics or attributes of the data entry. |
Area_Ha | double | The area of the object, represented in hectares. |
Remark | string | Additional comments or observations about the data entry. |
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 geometric shape of the object. |
geom_centroid | string | The central point of the geometric shape of the object. |
geom_center_x | double | The X coordinate of the center point of the geometric shape of the object. |
geom_center_y | double | The Y coordinate of the center point of the geometric shape of the object. |
Version History of Base Table Rows in the Gavleborg 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 of this column 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. 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 object ID. |
ID | string | This column contains the ID. |
CODE_12 | string | This column contains the code 12. |
Area_Ha | double | This column contains the area in hectares. |
Remark | string | This column contains additional remarks or comments. |
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 geometric data in GeoJSON format. |
geom_geotext | string | This column contains the geometric data in text format. |
geom_type | string | This column contains 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 data's center. |
geom_center_y | double | This column contains the Y-coordinate of the geometric data's center. |
Geospatial Data Analysis and Object Details from Swedish National Land Survey
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 column '_extract_date'. This column, in combination with '_extract_date', uniquely identifies each row. |
OBJECTID | long | This column represents the unique identifier for each object in the data. |
ID | string | This column provides an additional unique identifier for data entries. |
CODE_12 | string | This column contains specific codes related to the data entries. |
Area_Ha | double | This column provides the area of each data entry measured in hectares. |
Remark | string | This column includes any additional remarks or notes related to the data entry. |
Shape_Leng | double | This column provides the length of the shape of each data entry. |
Shape_Area | double | This column provides the area of the shape of each data entry. |
geom_geojson | string | This column contains the geometric representation of each data entry in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of each data entry in text format. |
geom_type | string | This column specifies the type of geometric shape each data entry has. |
geom_centroid | string | This column provides the centroid (geometric center) of each data entry. |
geom_center_x | double | This column provides the X-coordinate of the center of each geometric shape. |
geom_center_y | double | This column provides the Y-coordinate of the center of each geometric shape. |
Version History of Base Table Rows with Geographical Elements from a Swedish Source
Column | Type | Comment |
---|---|---|
_start_date | date | This column records the date when the row was extracted from the data source, forming part of the unique identifier for 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 part of the unique identifier for each row in conjunction with the _start_date column. |
OBJECTID | long | This column contains the unique identifier for each object in the table. |
ID | string | This column contains a unique identification number for each record in the table. |
CODE_12 | string | This column contains a specific code associated with each record. |
Area_Ha | double | This column records the area of each object in hectares. |
Remark | string | This column contains any additional comments or remarks related to each record. |
Shape_Leng | double | This column records the length of the shape of each object. |
Shape_Area | double | This column records the area of the shape of each object. |
geom_geojson | string | This column contains the geometric representation of each object in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of each object in text format. |
geom_type | string | This column specifies the type of geometric shape that each object represents. |
geom_centroid | string | This column contains the centroid of the geometric shape of each object. |
geom_center_x | double | This column records the x-coordinate of the center of the geometric shape of each object. |
geom_center_y | double | This column records the y-coordinate of the center of the geometric shape of each object. |
Geospatial Data Analysis and Mapping Collection
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. |
_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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row. |
OBJECTID | long | This column contains the unique identification number for each object in the data table. |
ID | string | This column contains an additional identification number for the objects in the data table. |
CODE_12 | string | This column contains the 12-digit code associated with the objects in the data table. |
Area_Ha | double | This column represents the area of the objects in the table, measured in hectares. |
Remark | string | This column contains any remarks or notes associated with the objects in the data table. |
Shape_Leng | double | This column represents the length of the geometric shape of the objects in the data table. |
Shape_Area | double | This column represents the area of the geometric shape of the objects in the data table. |
geom_geojson | string | This column contains the geographical data of the objects in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the objects in a text format. |
geom_type | string | This column specifies the type of the geometric shape of the objects. |
geom_centroid | string | This column contains the centroid coordinates of the geometric shape of the objects. |
geom_center_x | double | This column contains the x-coordinate of the geometric center of the objects. |
geom_center_y | double | This column contains the y-coordinate of the geometric center of the objects. |
Version History of Geospatial Records in Gavleborg Collection
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the row was extracted from the data source. This column forms a unique identifier in combination with the '_row_number'. |
_end_date | date | 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 number of the row in the raw data extracted from the data source. This column forms a unique identifier in combination with the '_start_date'. |
OBJECTID | long | A unique identifier of the object in the dataset. |
ID | string | A unique identifier of the entity in the dataset. |
CODE_12 | string | A code representing a specific attribute or characteristic of the entity. |
Area_Ha | double | The area of the entity in hectares. |
Remark | string | Any additional comments or remarks related to the entity. |
Shape_Leng | double | The length of the shape of the entity. |
Shape_Area | double | The area of the shape of the entity. |
geom_geojson | string | The geometry of the entity represented in GeoJSON format. |
geom_geotext | string | The geometry of the entity represented in text format. |
geom_type | string | The type of the geometry of the entity. |
geom_centroid | string | The centroid of the geometry of the entity. |
geom_center_x | double | The x-coordinate of the center of the geometry of the entity. |
geom_center_y | double | The y-coordinate of the center of the geometry of the entity. |
Geospatial Features and Attributes Data Table from Swedish 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 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 column '_extract_date'. |
OBJECTID | long | This is a unique identifier 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 that are relevant to the data in the table. |
Area_Ha | double | This column represents the area of the object in hectares. |
Remark | string | This column contains any additional comments or remarks about the data in the row. |
Shape_Leng | double | This column contains the length of the shape represented by the data in the row. |
Shape_Area | double | This column contains the area of the shape represented by the data in the row. |
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 a text format. |
geom_type | string | This column defines the type of the geometric object represented in the row. |
geom_centroid | string | This column contains the centroid of the geometric object represented in the row. |
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. |
Version History Table of Base Rows in Gavleborg 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. |
_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 for each object in the table. |
ID | string | This column contains the unique identification number for each record in the table. |
CODE_12 | string | This column contains specific codes related to the data in the table. |
Area_Ha | double | This column contains the area measurements for each record in the table, expressed in hectares. |
Remark | string | This column is for any additional comments or remarks related to each record in the table. |
Shape_Leng | double | This column contains the length of the shape associated with each record in the table. |
Shape_Area | double | This column contains the area of the shape associated with each record in the table. |
geom_geojson | string | This column contains the geographical data for each record in the table, in GeoJSON format. |
geom_geotext | string | This column contains the geographical data for each record in the table, in text format. |
geom_type | string | This column contains information about the type of geographical data associated with each record in the table. |
geom_centroid | string | This column contains the centroid of the geographical data associated with each record in the table. |
geom_center_x | double | This column contains the X-coordinate of the center of the geographical data associated with each record in the table. |
geom_center_y | double | This column contains the Y-coordinate of the center of the geographical data associated with each record in the table. |
Geospatial Characteristics and Metrics of Land Parcels
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date when the data on the row was extracted from the source, Lantmäteriet (The Land Survey of Sweden). |
_row_number | long | This column records the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
OBJECTID | long | This column contains the unique identifier of an object in the data. |
ID | string | This column contains another form of identification for the data row. |
CODE_12 | string | This column contains a code that has some specific meaning within the context of the dataset. |
Area_Ha | double | This column represents the area of an object or a geographic feature in hectares. |
Remark | string | This column is for any additional notes or comments about the data row. |
Shape_Leng | double | This column records the length of the outline of the geographic feature. |
Shape_Area | double | This column records the area of the geographic feature. |
geom_geojson | string | This column contains the geographical data of the object in GeoJSON format, which is a format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains the geographical data of the object in a text format. |
geom_type | string | This column specifies the type of the geographical feature. |
geom_centroid | string | This column contains the geographical coordinates of the centroid of the geographic feature. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographic feature. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographic feature. |
Version History of Base Table Rows in a 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 of this column is null, it indicates 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 identifier for each row in conjunction with '_start_date'. |
OBJECTID | long | A unique identifier for the object. |
ID | string | An identifier for the data entry. |
CODE_12 | string | A coded reference pertaining to the data entry. |
Area_Ha | double | The area of the object, measured in hectares. |
Remark | string | Any additional comments or observations regarding the data entry. |
Shape_Leng | double | The length of the object's shape. |
Shape_Area | double | The area of the object's shape. |
geom_geojson | string | The geometric representation of the object in GeoJSON format. |
geom_geotext | string | The geometric representation of the object in geotext format. |
geom_type | string | The type of geometric representation used for the object. |
geom_centroid | string | The geometric center or centroid of the object. |
geom_center_x | double | The x-coordinate of the object's geometric center. |
geom_center_y | double | The y-coordinate of the object's geometric center. |
Land and Geographic Information Data Collection
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 the unique identifier for each object in the table. |
ID | string | This column contains a unique identification number 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 geographical feature in hectares. |
Remark | string | This column contains any additional remarks or comments related to the data in the row. |
Shape_Leng | double | This column represents the length of the geographical feature. |
Shape_Area | double | This column represents the area of the geographical feature. |
geom_geojson | string | This column contains the geographical feature in GeoJSON format. |
geom_geotext | string | This column contains the geographical feature in a text-based geospatial format. |
geom_type | string | This column specifies the type of the geographical feature (e.g., point, line, polygon). |
geom_centroid | string | This column contains the centroid of the geographical feature. |
geom_center_x | double | This column contains the X coordinate of the center of the geographical feature. |
geom_center_y | double | This column contains the Y coordinate of the center of the geographical feature. |
Version History of Base Table Rows in Gavleborg Dataset
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 | 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 is part of a combination with '_start_date' that uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains an identification number assigned to the object. |
ID | string | This column contains a unique identification number for each row. |
CODE_12 | string | This column contains a specific code associated with the data. |
Area_Ha | double | This column represents the area of the data object in hectares. |
Remark | string | This column contains any additional comments or remarks related to the data row. |
Shape_Leng | double | This column contains the length of the shape of the data object. |
Shape_Area | double | This column contains the area of the shape of the data object. |
geom_geojson | string | This column contains the geometry of the data object in GeoJSON format. |
geom_geotext | string | This column contains the geometry of the data object in a textual format. |
geom_type | string | This column indicates the type of geometry of the data object. |
geom_centroid | string | This column contains the centroid of the geometry of the data object. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the data object. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometry of the data object. |
Geographical Data Collection with Object Identifiers, Area Measurements, and Geometrical Attributes
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the specific row's data was extracted from the source, which helps in tracking the data extraction process. |
_row_number | long | This column contains the row number from the data extracted on the specific extract date. This, in combination with the _extract_date, uniquely identifies each row. |
OBJECTID | long | This column contains unique identifiers for each object in the table. |
ID | string | This column represents the identification number of each entry within the table. |
CODE_12 | string | This column contains unique code values associated with the data entries. |
Area_Ha | double | This column represents the area measurement of the geographical entities in hectares. |
Remark | string | This column contains any additional comments or remarks related to 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 contains the area of the geographical shape associated with the data entry. |
geom_geojson | string | This column contains the geographical data in GeoJSON format. |
geom_geotext | string | This column contains the geographical data in geotext format. |
geom_type | string | This column specifies the type of the geographical data. |
geom_centroid | string | This column contains the centroid point of the geographical shape. |
geom_center_x | double | This column represents the X coordinate of the center point of the geographical shape. |
geom_center_y | double | This column represents the Y coordinate of the center point of the geographical shape. |
History of Version Changes in Geospatial Data Attributes: A Swedish Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | This column records the date when the row was first extracted from the data source. It forms a unique identifier in combination with the '_row_number' column. |
_end_date | date | This column records 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 appears in the raw data extracted from the data source. It forms a unique identifier in combination with the '_start_date' column. |
OBJECTID | long | This column contains the unique object ID for each row. |
ID | string | This column contains a unique identifier for each row. |
CODE_12 | string | This column contains a unique code associated with each row. |
Area_Ha | double | This column records the area in hectares. |
Remark | string | This column contains any additional remarks or comments related to the row. |
Shape_Leng | double | This column contains the length of the shape represented in the row. |
Shape_Area | double | This column contains the area of the shape represented in the row. |
geom_geojson | string | This column contains the geojson representation of the geometry of the shape. |
geom_geotext | string | This column contains the textual representation of the geometry of the shape. |
geom_type | string | This column specifies the type of the geometry of the shape. |
geom_centroid | string | This column contains the centroid of the geometry of the shape. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the shape. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometry of the shape. |
Comprehensive Data Collection on Geometric and Area Properties
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 represents the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
OBJECTID | long | This column represents a unique identifier for each object in the dataset. |
ID | string | This column is another unique identifier for each record in the dataset. |
CODE_12 | string | This column holds a specific code related to the record. |
Area_Ha | double | This column represents the area of the record in hectares. |
Remark | string | This column contains any additional comments or remarks related to the record. |
Shape_Leng | double | This column indicates the length of the shape of the object, most likely in geometric terms. |
Shape_Area | double | This column represents the area of the shape of the object, most likely in geometric terms. |
geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
geom_geotext | string | This column holds the geometric representation of the object in textual format. |
geom_type | string | This column describes the type of the geometric representation. |
geom_centroid | string | This column contains the geometric centroid of the object. |
geom_center_x | double | This column represents the X coordinate of the geometric center of the object. |
geom_center_y | double | This column represents the Y coordinate of the geometric center of the object. |
Version History of Base Table Rows in Gavleborg 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 of this column 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 forms a combination that uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains a unique ID for each record in the table. |
CODE_12 | string | This column contains a unique code assigned to each row. |
Area_Ha | double | This column contains the area of the geographical feature represented by the row in hectares. |
Remark | string | This column contains any additional remarks or notes related to the row. |
Shape_Leng | double | This column contains the length of the geographical shape represented by the row. |
Shape_Area | double | This column contains the area of the geographical shape represented by the row. |
geom_geojson | string | This column contains the geographical features of the row in GeoJSON format. |
geom_geotext | string | This column contains the geographical features of the row in text format. |
geom_type | string | This column identifies the type of geographical feature represented by the row, such as 'Point', 'Polygon', etc. |
geom_centroid | string | This column contains the centroid of the geographical shape represented by the row. |
geom_center_x | double | This column contains the x-coordinate of the center of the geographical shape represented by the row. |
geom_center_y | double | This column contains the y-coordinate of the center of the geographical shape represented by the row. |
Geospatial Data on Area and Object Identification from a Swedish Source
Column | Type | Comment |
---|---|---|
_extract_date | date | This column represents 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, in combination with the '_extract_date', uniquely identifies each row. |
OBJECTID | long | This column contains the unique identifier for the objects in the table. |
ID | string | This column holds the identification number for each record in the table. |
CODE_12 | string | This column contains unique codes associated with the records in the table. |
Area_Ha | double | This column represents the area of the geographic entities in hectares. |
Remark | string | This column contains any additional notes or comments related to the record. |
Shape_Leng | double | This column holds the length of the geographic shape associated with the record. |
Shape_Area | double | This column represents the area of the geographic shape associated with the record. |
geom_geojson | string | This column contains the geographic data in GeoJSON format. |
geom_geotext | string | This column holds the geographic data in a text format. |
geom_type | string | This column indicates the type of the geographic feature associated with the record. |
geom_centroid | string | This column contains the centroid of the geographic feature associated with the record. |
geom_center_x | double | This column holds the X coordinate of the center of the geographic feature. |
geom_center_y | double | This column holds the Y coordinate of the center of the geographic feature. |
Version History Records of Base Table in Gävleborg 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 | 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. It is part of a combination with '_start_date' that uniquely identifies each row in this version history table. |
OBJECTID | long | This column contains a unique identifier for each object in the table. |
ID | string | This column contains a unique identifier for each entry in the table. |
CODE_12 | string | This column contains specific codes that may be related to the characteristics of the data entries. |
Area_Ha | double | This column contains information about the area size in hectares. |
Remark | string | This column contains any additional notes or remarks about the data entry. |
Shape_Leng | double | This column contains the length of the shape of the area in question. |
Shape_Area | double | This column contains the total area of the shape in question. |
geom_geojson | string | This column contains the geographical data of the area in GeoJSON format. |
geom_geotext | string | This column contains the geographical data of the area in a text format. |
geom_type | string | This column indicates the type of geographical data represented (such as point, line, polygon etc.). |
geom_centroid | string | This column contains the geographical data of the centroid of the area. |
geom_center_x | double | This column contains the X coordinate of the center of the geographical data. |
geom_center_y | double | This column contains the Y coordinate of the center of the geographical data. |
Gävleborg Collection: Detailed Geographical Data Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date when the data for each 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 date specified by the _extract_date column. Together with the _extract_date, it uniquely identifies each row. |
OBJECTID | long | This column contains the unique identifier for each object in the dataset. |
ID | string | This column holds a unique identifier for each record. |
CODE_12 | string | This column contains a specific code that is associated with each record. |
Area_Ha | double | This column provides the area of the object/record in hectares. |
Remark | string | This column may include additional notes or remarks relevant to the record. |
Shape_Leng | double | This column records the length of the shape of the object/record. |
Shape_Area | double | This column records the area of the shape of the object/record. |
geom_geojson | string | This column contains the geometric representation of the object/record in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of the object/record in a textual format. |
geom_type | string | This column specifies the type of geometry used to represent the object/record. |
geom_centroid | string | This column provides the centroid of the geometry of the object/record. |
geom_center_x | double | This column provides the x-coordinate of the center of the geometry of the object/record. |
geom_center_y | double | This column provides the y-coordinate of the center of the geometry of the object/record. |
Geospatial Characteristics and Quantitative Data Collection from Sweden
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 holds the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
OBJECTID | long | This column represents a unique identifier for each object in the table. |
ID | string | This column is an identifier for each record in the table. |
CODE_12 | string | This column contains specific codes related to the data. |
Area_Ha | double | This column represents the area of the object or region in hectares. |
Remark | string | This column contains any additional comments or notes regarding the record. |
Shape_Leng | double | This column represents the length of the shape of the object or region. |
Shape_Area | double | This column represents the area of the shape of the object or region. |
geom_geojson | string | This column contains the geometric representation of the object or region in GeoJSON format. |
geom_geotext | string | This column contains the geometric representation of the object or region in text format. |
geom_type | string | This column specifies the type of the geometry of the object or region. |
geom_centroid | string | This column represents the centroid of the geometric shape of the object or region. |
geom_center_x | double | This column represents the X coordinate of the geometric center of the object or region. |
geom_center_y | double | This column represents the Y coordinate of the geometric center of the object or region. |
Version History Table for Area Measurements and Geometric Properties
Column | Type | Comment |
---|---|---|
_start_date | date | 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 | Contains the date when a new version of the row was extracted from the data source. If its value is null, it signifies 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 forms a unique pair with '_start_date' to identify each row in this version history table. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An identifier for each entry in the table. |
CODE_12 | string | A coded value representing a specific category or type of data. |
Area_Ha | double | The area of a geographical feature represented in hectares. |
Remark | string | Field for additional information or comments about the row. |
Shape_Leng | double | The length of the geographical shape represented. |
Shape_Area | double | The area of the geographical shape represented. |
geom_geojson | string | The geographical shape represented in GeoJSON format. |
geom_geotext | string | The geographical shape represented in geotext format. |
geom_type | string | The type of the geographical shape (for example, point, line, polygon). |
geom_centroid | string | The centroid of the geographical shape. |
geom_center_x | double | The x-coordinate of the center of the geographical shape. |
geom_center_y | double | The y-coordinate of the center of the geographical shape. |
Additional Info
Last Updated | September 23, 2024 |
---|---|
Created | August 26, 2024 |