Västernorrland: A Versatile Collection of Related Dataset Tables
Tables
-
Geographical and Geometric Properties of Land Parcels in VästernorrlandTSV
This table originates from the 'Lantmäteriet' (The Land Survey) website, based in Sweden. It's a component of a larger dataset collection and holds a rich variety of data structured into rows and columns. Each row is uniquely identified by a combination of extraction date and row number, detailing when the data was sourced and its specific position within the extracted data. Geographic information is also included, transformed from its original shapefile format - a method used for storing geographical location and attribute information. This information can be represented as points, lines, or polygons (areas). This collection of data could be used in various data analytics applications. For instance, it can be utilized for geographical analysis, by leveraging the geographic information...
-
Geographical Data Analysis with Detailed Attributes in VästernorrlandTSV
The table in question forms part of a dataset collection sourced from the 'Lantmäteriet' website, located in Sweden. It contains a variety of data points, providing extensive insight into different geographic features. This is achieved through a sophisticated combination of unique identifiers, geographic data, and additional remarks. Each entry in the table has a specific extraction date and a unique row number, which together form a unique identifier for each data point. This ensures the traceability and integrity of the data, as each entry can be tracked back to its original extraction date. The geographic data in the table has been converted from the original shapefile format, a common format for storing geometric location and attribute information of geographic features. This...
-
Geospatial Analysis Data Collection: Detailed Land Classification and Geometry MetricsTSV
The table originates from the dataset collection sourced from the 'Lantmäteriet' website in Sweden. This table is an organized collection of related data, structured in rows and columns, and serves to provide a comprehensive set of information. It includes specific data extracted from the source on a particular date, with each row being uniquely identified by the combination of the extraction date and the row number. The table also contains geographical data, initially in shapefile format, which is a simple method for storing the geometric location and attribute information of geographical features. These features may be represented by points, lines, or polygons (areas), and have been transformed into the final geographic format. In terms of data analytics, this table offers a...
-
Geospatial Characteristics of Land Areas in VästernorrlandTSV
The table in question is a comprehensive collection of geographic data, originating from 'Lantmäteriet' (The Land Survey) in Sweden. It contains a range of information for each entry, including the date of data extraction and the row number for that extraction day, which together form a unique identifier for each row. Additional data includes an object ID, a code, an area in hectares, any remarks, as well as several columns dedicated to geographic information. The geographic data has been transformed from the shapefile format to a more suitable format for this dataset. This table is an integral part of a larger dataset, making it a valuable resource for numerous data analytics applications. For instance, the data could be used for environmental analysis, such as studying land usage...
-
Geospatial Data Analysis of Land Areas in Västernorrland, SwedenTSV
The table in question is part of a dataset collection, which is sourced from the website of Lantmäteriet (the National Land Survey) in Sweden. This table contains a variety of columns, each holding unique and important information. Two of these columns are special: one contains the date when the data was extracted, and the other contains the row number in the data extracted on that specific date. These two columns together uniquely identify each row in the table. The geographic information in the table originally comes in a shapefile format, a simple format for storing the geometric location and attribute information of geographic features. This has been transformed into the final geographic format for use in this table. This table could be utilized in several ways for data analytics....
-
Historical Version Records of Base Table Rows in Vasternorrland DatasetTSV
The 'clc12_69f_no__history' table is a historical dataset, part of the larger 'vasternorrland' dataset collection. As a history table, it stores the version history of its base table rows, allowing users to track changes over time. The unique identifiers for each row are a combination of the start date and the row number, providing a clear timeline of data changes. This table is particularly rich in geographic information, originally in the shapefile format which is a common format for storing the geometric location and attribute information of geographic features. This geographic data has been transformed into a final format from the original shapefile format, enabling users to analyze points, lines, or polygon-based areas. Sourced from the 'Lantmäteriet' (The Land Survey) website in...
-
History of Versioned Data in Vasternorrland CollectionTSV
The table in question is a historical dataset, belonging to a larger collection sourced from the Swedish website, Lantmäteriet. This historical table captures the evolution of its base table over time, by keeping track of each row's version history. It achieves this by uniquely identifying each row using a combination of the extraction date and the row number. Furthermore, whenever a new version of a row is extracted, the table records the date of this event. If a row is the most recent version, its end date will be left blank. In addition to the basic information from its base table, this history table includes geographical data, transformed from a shapefile format. A shapefile stores geographical features in a simple, non-topological format, which can represent these features as...
-
Land Classification Data with Geometric AttributesTSV
The table under consideration originates from the dataset collection linked to the 'Vasternorrland' region. It's an intriguing compilation of data, primarily focusing on geographic information which has been converted from the shapefile format. This format is a non-topological method for storing the geometric location and attribute information of geographic features, which can be represented by points, lines, or polygons (areas). This table has two special columns. One of them records the date when the data on the row was extracted from the source, while the other keeps track of the row number in the data extracted on the specified extract date. These two columns together uniquely identify each row, creating a traceable record of data extraction. The data source for this table is the...
-
Spatial and Geographical Data Analysis: Land Mapping and Area MeasurementTSV
The table in question is a rich source of geographic information, originating from the 'Lantmäteriet' website in Sweden. The dataset holds a wealth of information, with columns that encompass a wide array of data types. The data includes unique identifying information for each entry, specific geographic codes, area measurements, and remarks. Additionally, it contains several columns related to geographic details, which have been transformed from the shapefile format. Notably, two special columns, one indicating the date of data extraction and the other signifying the row number in the extracted data, uniquely identify each row. This table could prove useful in several data analytics scenarios. For instance, a geospatial data scientist could utilize the geographic information to study...
-
Version History of Base Table Rows in Vasternorrland Dataset CollectionTSV
The 'clc12_69e_so__history' table is a historical record table that is part of the 'vasternorrland' dataset collection. This table is a rich source of geographical data, with information transformed from the shapefile format. The shapefile is a format used for storing geographical location and attribute information of geographical features, which can be represented by points, lines, or polygons (areas). This table features data from the original table, along with the addition of two columns that provide a timeline for each row's entry and update in the data source. The unique identifiers for each row of data in this table are a combination of the start date of extraction and the row number in its raw form. The start date refers to when the data was first sourced, while the end date...
-
Version History of Base Table Rows in Vasternorrland Dataset CollectionTSV
This history table is a part of a dataset collection that contains intricate data about historical versions of its base table rows. The table is unique in its ability to track changes over time, as it includes two additional columns that record the start and end dates for when a row was extracted from the data source. A unique identifier for each row in this table is formed by the combination of the start date and a row number. If the end date column is null, it indicates that the row is the current version. The table also contains geographical information, which was originally in a simple, nontopological shapefile format and has been converted into a final geographic format. This geographic data could be represented by points, lines, or polygons. This valuable table has been sourced...
-
Version History of Base Table Rows in Vasternorrland Dataset from a Swedish SourceTSV
The 'clc12_71f_so__history' table is a history table that belongs to the 'vasternorrland' dataset collection. It meticulously maintains the version history of its base table rows, allowing for changes and modifications to be tracked over time. This table uniquely identifies each row using a combination of the row number and the date of extraction. It contains detailed data, including when a row was added and when it was updated. If a row is the most recent version, it will have a null end date. The data in the table is sourced from 'Lantmäteriet' website in Sweden. This table contains both attribute and geographic information derived from a shapefile, a widely-used data format for storing geometric location and attribute details of geographic features. The geographic data has been...
-
Version History of Base Table Rows in Västernorrland Dataset CollectionTSV
The 'clc12_69f_nv__history' is a history table that forms part of the 'vasternorrland' dataset collection. This table holds a detailed record of the version history of its base table rows, with each row uniquely identified by the combination of its start date and row number. The table contains a variety of columns including those that record the start and end dates of each row extraction from the data source. The addition of these two columns makes it different from its base table. The start date indicates when a row was extracted, while the end date signifies when a new version of the row was extracted. If the end date column contains a null value, this indicates that the row is the most recent version. Geographic information is also a key feature of this table, initially stored in...
-
Version History of Geospatial Attributes for Västernorrland Dataset CollectionTSV
The 'clc12_68g_nv__history' table is a history table that is part of the 'vasternorrland' dataset collection. It is a rich source of versioned data, capturing the changes over time in its base table. The table is characterized by unique identifiers for each row, which are composed of a combination of the date a row was extracted and the number of the row in the raw data. This unique identification system allows for precise tracking and referencing of each entry. The table not only tracks temporal changes but also contains a wealth of geographic information. This geographic data, initially in shapefile format, has been transformed into a final format suitable for this dataset. It represents geographic features such as points, lines, or polygons (areas), providing a detailed spatial...
Column Descriptions
Geographical Data Analysis with Detailed Attributes in Västernorrland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column records the date when the data on the row was extracted from the source. |
| _row_number | long | This column records the number of the row in the data extracted from the source on a given extract date. |
| OBJECTID | long | This column contains the object identifiers. |
| ID | string | This column contains the identifiers for different entries in the table. |
| CODE_12 | string | This column contains the code_12 values which could be unique identifiers or classification codes. |
| Area_Ha | double | This column records the area measurement of objects in hectares. |
| Remark | string | This column includes any additional comments or notes regarding the data entry. |
| Shape_Leng | double | This column contains the length of the geometrical shape representing the object. |
| Shape_Area | double | This column contains the area of the geometrical shape representing the object. |
| geom_geojson | string | This column holds the geometric representation of the object in GeoJSON format. |
| geom_geotext | string | This column holds a textual representation of the object's geometry. |
| geom_type | string | This column records the geometric type of the object. |
| geom_centroid | string | This column contains the centroid of the geometric object. |
| 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. |
History of Versioned Data in Vasternorrland Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. Together with the '_row_number' column, it helps in uniquely identifying 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 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 is used in combination with the '_start_date' column to uniquely identify each row in this version history table. |
| OBJECTID | long | This column contains the object identifier. |
| ID | string | This column contains the unique identification number. |
| CODE_12 | string | This column contains the 12-digit code. |
| Area_Ha | double | This column contains the area in hectares. |
| Remark | string | This column contains any 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 geometry of the feature in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the feature in a textual format. |
| geom_type | string | This column contains the type of the geometry. |
| geom_centroid | string | This column contains the centroid of the geometry. |
| geom_center_x | double | This column contains the x-coordinate of the geometry's center. |
| geom_center_y | double | This column contains the y-coordinate of the geometry's center. |
Geographical and Geometric Properties of Land Parcels in Västernorrland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column represents the date when the data on a particular row was extracted from the original data source. |
| _row_number | long | This column represents the specific row number in the data extracted from the source on the extract date indicated by the '_extract_date' column. Together with '_extract_date', this column uniquely identifies each row. |
| OBJECTID | long | This column contains an identifier for each object in the dataset. |
| ID | string | This column represents a unique identifier for each entry in the dataset. |
| CODE_12 | string | This column contains a specific code related to each entry in the dataset. |
| Area_Ha | double | This column represents the area of each entry, measured in hectares. |
| Remark | string | This column contains any additional remarks or notes for each entry in the dataset. |
| Shape_Leng | double | This column represents the length of the shape associated with each entry in the dataset. |
| Shape_Area | double | This column represents the area of the shape associated with each entry in the dataset. |
| geom_geojson | string | This column contains the GeoJSON representation of the geometry of each entry. |
| geom_geotext | string | This column contains a textual representation of the geometry of each entry. |
| geom_type | string | This column represents the type of geometry associated with each entry. |
| geom_centroid | string | This column contains the centroid of the geometry of each entry. |
| geom_center_x | double | This column represents the X coordinate of the center of the geometry associated with each entry. |
| geom_center_y | double | This column represents the Y coordinate of the center of the geometry associated with each entry. |
Version History of Geospatial Attributes for Västernorrland Dataset Collection
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It's part of a combination, along with '_row_number', that uniquely identifies each row in this history table. |
| _end_date | date | This column contains the date when a new version of the row was extracted from the data source. If the value 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's part of a combination, along with '_start_date', that uniquely identifies each row in this history table. |
| OBJECTID | long | This column contains an identification number for the object. |
| ID | string | This column contains the unique identifier for each row. |
| CODE_12 | string | This column contains a code related to the data in the row. |
| 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 row. |
| Shape_Leng | double | This column contains the length of the shape of the object. |
| Shape_Area | double | This column contains the area of the shape of the object. |
| geom_geojson | string | This column contains the geometric data of the object in GeoJSON format. |
| geom_geotext | string | This column contains the geometric data of the object in text format. |
| geom_type | string | This column contains the type of the geometric data of the object. |
| geom_centroid | string | This column contains the geographic center point of the object. |
| geom_center_x | double | This column contains the X-coordinate of the geographic center point of the object. |
| geom_center_y | double | This column contains the Y-coordinate of the geographic center point of the object. |
Spatial and Geographical Data Analysis: Land Mapping and Area Measurement
| 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'. |
| OBJECTID | long | This column holds the unique object identifier for each entry. |
| ID | string | This column contains the identification number for each entry. |
| CODE_12 | string | This column includes the specific 12-digit code associated with each entry. |
| Area_Ha | double | This column provides the area measurement of the data object in hectares. |
| Remark | string | This column contains any additional comments or remarks related to the entry. |
| Shape_Leng | double | This column contains the length of the shape geometry of the data object. |
| Shape_Area | double | This column provides the area of the shape geometry of the data object. |
| geom_geojson | string | This column contains the geometric representation of the data object in GeoJSON format. |
| geom_geotext | string | This column holds the geometric representation of the data object in plain text format. |
| geom_type | string | This column specifies the type of geometric representation used for the data object. |
| geom_centroid | string | This column contains the central point of the geometric representation of the data object. |
| geom_center_x | double | This column holds the X-coordinate of the center of the geometric representation of the data object. |
| geom_center_y | double | This column holds the Y-coordinate of the center of the geometric representation of the data object. |
Version History of Base Table Rows in Vasternorrland 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 is null, it indicates that the row is the most recent version. |
| _row_number | long | The number of the row in the raw data that was extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
| OBJECTID | long | A unique identifier for the object. |
| ID | string | A unique identifier for the entry. |
| CODE_12 | string | A code associated with the entry. |
| Area_Ha | double | The area of the entry, measured in hectares. |
| Remark | string | Any remarks or additional information about the entry. |
| Shape_Leng | double | The length of the shape associated with the entry. |
| Shape_Area | double | The area of the shape associated with the entry. |
| geom_geojson | string | The geometry of the shape in GeoJSON format. |
| geom_geotext | string | The geometry of the shape in plain text format. |
| geom_type | string | The type of the geometry of the shape. |
| geom_centroid | string | The centroid of the geometry of the shape. |
| geom_center_x | double | The X coordinate of the center of the geometry of the shape. |
| geom_center_y | double | The Y coordinate of the center of the geometry of the shape. |
Land Classification Data with Geometric Attributes
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data on the row was extracted from the source, Lantmäteriet (The Land Survey) in Sweden. This column forms part of the unique identifier for each row alongside '_row_number'. |
| _row_number | long | The row number in the data extracted from the source on the specified extract date. This column forms part of the unique identifier for each row alongside '_extract_date'. |
| OBJECTID | long | A unique identifier for each object in the dataset. |
| ID | string | Another unique identifier for each object in the dataset. |
| CODE_12 | string | The code assigned to the data object according to a specific classification system. |
| Area_Ha | double | The area of the geographical object represented in the dataset, measured in hectares. |
| Remark | string | Any additional comments or notes regarding the data object. |
| Shape_Leng | double | The length of the perimeter of the geographical object represented in the dataset. |
| Shape_Area | double | The area of the geographical object represented in the dataset, likely measured in a different unit than 'Area_Ha'. |
| geom_geojson | string | Geometry of the object in GeoJSON format, a type of open standard format designed for representing simple geographical features. |
| geom_geotext | string | Geometry of the object represented as text. |
| geom_type | string | Type of the geographical object's geometry, such as point, line, or polygon. |
| geom_centroid | string | Centroid of the geographical object's geometry. The centroid is the geometric center of a plane figure or shape. |
| geom_center_x | double | The X coordinate of the geographical object's center. |
| geom_center_y | double | The Y coordinate of the geographical object's center. |
Historical Version Records of Base Table Rows in Vasternorrland Dataset
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column contains the date when the row was extracted from the data source. It forms part of a unique identifier for each row in this version history table, together 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. Together with the '_start_date' column, it forms a unique identifier for 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 identification number for each row in the table. |
| CODE_12 | string | This column contains a coded value, possibly representing a certain category or type. |
| Area_Ha | double | This column contains the area of the object, measured 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 shape of the object. |
| Shape_Area | double | This column contains the area of the shape of the object. |
| geom_geojson | string | This column contains the geometric representation of the object in GeoJSON format. |
| geom_geotext | string | This column contains a textual representation 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 Analysis Data Collection: Detailed Land Classification and Geometry Metrics
| 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 date specified in the '_extract_date' column. The combination of '_extract_date' and '_row_number' columns uniquely identifies each row. |
| OBJECTID | long | This column contains the object identifier of the data. |
| ID | string | This column contains the unique identifier of the data. |
| CODE_12 | string | This column contains the code 12 of the data. |
| Area_Ha | double | This column contains the area of the data in hectares. |
| Remark | string | This column contains any remarks or comments about the data. |
| Shape_Leng | double | This column contains the length of the shape of the data. |
| Shape_Area | double | This column contains the area of the shape of the data. |
| geom_geojson | string | This column contains the geometrical data in GeoJSON format. |
| geom_geotext | string | This column contains the geometrical data in textual format. |
| geom_type | string | This column contains the type of the geometrical data. |
| geom_centroid | string | This column contains the centroid of the geometrical data. |
| geom_center_x | double | This column contains the X coordinate of the center of the geometrical data. |
| geom_center_y | double | This column contains the Y coordinate of the center of the geometrical data. |
Version History of Base Table Rows in Vasternorrland Dataset Collection
| 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 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 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 '_start_date' to identify each row in this version history table. |
| OBJECTID | long | This column contains the object identifier for each row. |
| ID | string | This column contains the unique identifier for each row. |
| CODE_12 | string | This column contains specific code associated with each row. |
| Area_Ha | double | This column represents the area measurement 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 shape. |
| Shape_Area | double | This column contains the area of the shape. |
| geom_geojson | string | This column contains the geometry of the area in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the area in plain text format. |
| geom_type | string | This column indicates the type of the geometry. |
| geom_centroid | string | This column contains the centroid of the geometry. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry. |
Geospatial Data Analysis of Land Areas in Västernorrland, Sweden
| 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 '_extract_date' column. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
| OBJECTID | long | This column contains a unique identifier for each object in the table. |
| ID | string | This column contains another unique identifier 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 in the table, measured in hectares. |
| Remark | string | This column contains any additional comments or remarks about each object in the table. |
| Shape_Leng | double | This column contains the length of the shape of each object in the table. |
| Shape_Area | double | This column contains the area of the shape of each object in the table. |
| geom_geojson | string | This column contains the GeoJSON representation of each object's geometry. |
| geom_geotext | string | This column contains a text representation of each object's geometry. |
| geom_type | string | This column indicates the type of each object's geometry. |
| 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. |
Version History of Base Table Rows in Västernorrland Dataset Collection
| 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 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 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. Together with '_start_date', it uniquely identifies each row in this version history table. |
| OBJECTID | long | This column contains unique identifiers for each object in the table. |
| ID | string | This column contains another set of unique identifiers for the entries in the table. |
| CODE_12 | string | This column contains specific codes associated with the entries in the table. |
| Area_Ha | double | This column contains the area measurement of the entries in the table, represented in hectares. |
| Remark | string | This column contains any additional comments or notes regarding the entries in the table. |
| Shape_Leng | double | This column contains the lengths of the shapes associated with the entries in the table. |
| Shape_Area | double | This column contains the area of the shapes associated with the entries in the table. |
| geom_geojson | string | This column contains the geometry of the entries in the table, represented in GeoJSON format. |
| geom_geotext | string | This column contains the geometry of the entries in the table, represented in plain text format. |
| geom_type | string | This column contains the type of geometry associated with the entries in the table. |
| geom_centroid | string | This column contains the centroid of the geometry associated with the entries in the table. |
| geom_center_x | double | This column contains the x-coordinate of the center of the geometry associated with the entries in the table. |
| geom_center_y | double | This column contains the y-coordinate of the center of the geometry associated with the entries in the table. |
Geospatial Characteristics of Land Areas in Västernorrland
| 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 specified by the column '_extract_date'. |
| 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 code that provides specific information or categorization for each entry in the table. |
| Area_Ha | double | The area of the object or location represented by the row in hectares. |
| Remark | string | Any additional comments or notes regarding the entry. |
| Shape_Leng | double | The length of the shape or object represented by the row. |
| Shape_Area | double | The area of the shape or object represented by the row. |
| geom_geojson | string | Geometric data for the object or location represented by the row, in GeoJSON format. |
| geom_geotext | string | Geometric data for the object or location represented by the row, in text format. |
| geom_type | string | The type of geometric data represented (e.g., point, line, polygon). |
| geom_centroid | string | The central point of the object or location represented by the row, in geometric data format. |
| geom_center_x | double | The x-coordinate of the center of the object or location represented by the row. |
| geom_center_y | double | The y-coordinate of the center of the object or location represented by the row. |
Version History of Base Table Rows in Vasternorrland Dataset from a Swedish Source
| 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 is null, it signifies 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, in combination with '_start_date', uniquely identifies each row in this version history table. |
| OBJECTID | long | An identifier for the object. |
| ID | string | A unique identifier for each entry. |
| CODE_12 | string | A code associated with the entry. |
| Area_Ha | double | The area of the entry in hectares. |
| Remark | string | Any additional comments or notes associated with the entry. |
| Shape_Leng | double | The length of the shape associated with the entry. |
| Shape_Area | double | The area of the shape associated with the entry. |
| geom_geojson | string | The geometric representation of the entry in GeoJSON format. |
| geom_geotext | string | The geometric representation of the entry in text format. |
| geom_type | string | The type of geometry associated with the entry. |
| geom_centroid | string | The centroid of the geometry associated with the entry. |
| geom_center_x | double | The x-coordinate of the geometric center of the entry. |
| geom_center_y | double | The y-coordinate of the geometric center of the entry. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | August 27, 2024 |