Jonkoping: A Comprehensive Collection of Interrelated Tables Sourced from a Renowned Swedish Website
Tables
-
Classification of Land Cover Table from Swedish Geospatial Dataset CollectionTSV
The table sourced from 'Lantmäteriet'(The Land Survey of Sweden) provides a collection of pertinent geographic information and other related data. It includes unique identifiers for each row, along with the exact date when the data was extracted. This ensures that every row is distinct and easily traceable back to its extraction date, which can be particularly useful for tracking changes over time. The table also contains geographical data, which was originally in shapefile format. This format is typically used for storing the geometric location and attribute information of geographic features, which can be represented by points, lines, or polygons. In this table, the geographic information has been converted into a more user-friendly format from the original shapefile format. This data...
-
Dataset Table: Geographic and Geometric Data CollectionTSV
The table in question is part of a dataset collection and provides a wide range of data, offering unique insights into specific aspects. This data is structured in a tabular format with defined columns and rows. Special attention should be given to two specific columns. One column indicates the date when the data row was extracted from the source, while the other column indicates the row number from the extraction data source. Combined, these two columns uniquely identify each row in the table. The information contained within this table is geographical in nature, sourced from 'Lantmäteriet', also known as the 'Land Survey' in Sweden. Originally represented in shapefile format, a method used for storing geographical location and attribute information, the data has since been transformed...
-
Geospatial and Object Related Data Collection for Land SurveyTSV
The table in question is part of a larger dataset collection and originates from the website of Lantmäteriet (The Land Survey) in Sweden. This table carries a rich variety of data organized in a structured manner across multiple columns and rows. The data within the table is uniquely identified by a combination of two special factors: the date of data extraction and the row number from the extracted data. This distinctive pairing ensures that each row of data can be precisely pinpointed and managed. One of the key features of this table is its geographic information, which initially comes in a shapefile format. Shapefiles are a straightforward method for storing the geometric location and attribute information of geographic features, with the ability to represent features as points,...
-
Geospatial Data Analysis of Land Properties in SwedenTSV
The table in question is a structured dataset, sourced from the 'Lantmäteriet' website, which is based in Sweden. This table is part of a larger collection of similar tables. It contains a variety of data, with each row uniquely identified by a combination of the date the data was extracted and the row number from the original data source. This unique identification method ensures that each row of data can be accurately traced back to its original source and extraction date. The table contains geographical data, initially in shapefile format, a commonly used format for storing the geometric location and attribute information of geographic features. This data has been transformed from its original format into a more versatile format for ease of use. Geographic features within the dataset...
-
Geospatial Feature Analysis Derived from Swedish National Land SurveyTSV
The table in question is a meticulously organized collection of related data, originating from the 'Lantmäteriet' website based in Sweden. This table is one integral part of a broader dataset collection. Each record within the table is accompanied by a unique identifier, which is a combination of the date of data extraction and the row number from the source data on that particular date. The geographic information on this table has been transformed from the shapefile format, a nontopological format for storing geometric location and attribute information of geographic features. Such features can be represented by points, lines, or polygons. Data from this table could be instrumental in various data analytics endeavors. For instance, urban planners could use this data to analyze the...
-
Historical Version Records of Base Table Rows from a Swedish Dataset CollectionTSV
This historical data table originates from the 'Lantmäteriet' (The Land Survey) website in Sweden. It is a comprehensive collection of information with a specific focus on maintaining the history of each row from its base table. This is achieved by the inclusion of starting and ending dates for each data extraction, creating a version history of the data over time. A unique identifier for each row is formed by combining the start date and row number. If the end date for a row is null, it signifies that the current version of the row is the most recent. Geographic information is a key feature of the dataset, originally sourced in shapefile format - a common format for storing geographic location and attribute information. This geographic data has been transformed from the shapefile...
-
History Table of Versioned Base Table Rows with Geometric DataTSV
This historical dataset is part of a larger collection sourced from the website of Lantmäteriet (The Swedish Land Survey) in Sweden. The table records the version history of a base table, including unique identifiers for each row version based on a combination of the extraction date and the row number in the raw data. This allows for tracking of changes over time. In addition to the standard data, two extra columns record the start and end dates of each row version. If the end date is null, that indicates the row is the most recent version. The data also includes geographic information, transformed from the original shapefile format into the final geographic format. The utility of this table is quite broad in the field of data analytics. For instance, one could use this table to perform...
-
Land Use and Geospatial Features Dataset TableTSV
This table, sourced from the Swedish website, Lantmäteriet, is a collection of organized data that is part of a larger dataset. It contains a variety of columns, some of which include specifics about the date and the row number of data extraction, allowing for each row to be uniquely identified. Furthermore, this table also contains geographical information, which has been transformed from the shapefile format. This format is a simple, non-topological format used for storing the geometric location and attribute information of geographic features, which can be represented by points, lines, or polygons (areas). The data in this table could be utilized in various ways in data analytics. For instance, the geographical information could be used to create detailed maps or to conduct spatial...
-
Spatial Geometric Data for Land Use ClassificationTSV
The table in question belongs to a dataset that originates from Lantmäteriet, a Swedish authority. This table is a rich compilation of data structured in a tabular format consisting of specific rows and columns. It maintains a unique identification system with each row distinguished by a combination of extraction date and row number. This system enables each data entry to be traced back to the exact date it was extracted from the source. The table is rich in geographic data, originally stored in the shapefile format, a popular geospatial vector data format. This geographic information has been transformed into the final geographic format from its original shapefile format. As such, it has potential applications in various geospatial and mapping projects. The data table could be...
-
Version History Details of Base Table Rows in Jonkoping Dataset CollectionTSV
The table in question holds a collection of historical data, maintaining a version history of its base table rows. This enables tracking the changes over time for each row. Essential elements such as the unique row number and start date form a combination that distinctly identifies each row in the version history. This table also records the dates of extraction and updates for each row, with the most recent version indicated by a null end date. The data in this table is geographic in nature, originally in shapefile format, which has been transformed into the final geographic format. This geographic information presents the geometric location and attribute data of geographic features, which can be points, lines, or polygons. Sourced from the 'Lantmäteriet' website in Sweden, this...
-
Version History of Base Table Rows in Jonkoping Dataset CollectionTSV
The table in focus forms part of a larger dataset collection and serves as a historical log, storing the version history of each data row in its base table. Unique identifiers for each row are established through a combination of the row's number and the date of extraction from the data source. Two additional columns, compared to its base table, hold information on these extraction dates, indicating when a row was initially pulled and when a new version was sourced. A null value in the latter column signifies the most recent version of that row. The data held in this table is of a geographic nature, originally presented in shapefile format - a common means of storing location and attribute information for geographic features. These features can be represented by points, lines, or...
-
Version History of Base Table Rows in Swedish Dataset CollectionTSV
The table under consideration is a history table that is a part of a dataset collection. It is sourced from the webpage of Lantmäteriet (The Land Survey) in Sweden. The main purpose of this table is to store the version history of its base table rows. It consists of several columns that store various types of information. For instance, it includes specific columns that record the date when the row was extracted from the data source and when a new version of the same row was extracted. If the latter is null, it signifies that the row is the most recent version. Additionally, it contains a column that records the number of the row in the raw data extracted from the data source. The combination of this column with the extraction date column uniquely identifies each row in this version...
-
Version History of Base Table Rows in Swedish Land Survey DatasetTSV
The table in question is a historical record, providing a version history of the rows in its base table. The table, part of a dataset collection, is sourced from the website of Lantmäteriet (The Land Survey) in Sweden. It offers a unique view into the evolution of data over time, with each row identified by a unique combination of its start date and row number. This allows for efficient tracking of changes over time. The start date indicates when the row was extracted from the data source, while the end date signifies when a new version of the row was extracted. A null value in the end date column indicates that the row is the most recent version. The table contains additional geographic information, originally in shapefile format but transformed into a final geographic format for this...
-
Version History Table of Land and Geographic Objects from Swedish National Land SurveyTSV
The 'clc12_63e_so__history' is a historical data table that is part of the 'jonkoping' dataset collection. As a history table, it contains the version history of its base table rows, which are uniquely identified by a combination of a start date and a row number. This table has two additional columns compared to its base table, namely a start date, which indicates when the row was extracted from the data source, and an end date, which signifies when a new version of the row was extracted. If the end date is null, it indicates that the row is the current version. The table also contains geographic information transformed from the shapefile format, which can represent geographic features as points, lines, or polygons (areas). The data for this table is sourced from the website of...
Column Descriptions
Classification of Land Cover Table from Swedish Geospatial Dataset Collection
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date when the specific row of data was extracted from the data source, which is the website of 'Lantmäteriet' (The National Land Survey) in Sweden. |
_row_number | long | This column denotes the row number in the data extracted from the source on the date specified by the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row. |
OBJECTID | long | This column contains the unique identifier for each object in the table. |
ID | string | This column contains an additional identifier for each object in the table. |
CODE_12 | string | This column holds a specific code associated with each object in the table. |
Area_Ha | double | This column indicates the area of the object in hectares. |
Remark | string | This column contains any additional remarks or notes related to the object. |
Shape_Leng | double | This column represents the length of the object's shape. |
Shape_Area | double | This column indicates the area of the object's shape. |
geom_geojson | string | This column contains the geometric data of the object in GeoJSON format. |
geom_geotext | string | This column contains a textual representation of the object's geometry. |
geom_type | string | This column specifies the type of geometric shape of the object. |
geom_centroid | string | This column indicates the centroid of the object's geometric shape. |
geom_center_x | double | This column represents the x-coordinate of the object's geometric center. |
geom_center_y | double | This column represents the y-coordinate of the object's geometric center. |
Version History of Base Table Rows in Swedish Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for 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 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 identifier for each row in the table. |
CODE_12 | string | This column contains a unique code associated with each row in the table. |
Area_Ha | double | This column contains the area of the object represented in the row, measured in hectares. |
Remark | string | This column may contain any additional comments or remarks about the object represented in the row. |
Shape_Leng | double | This column contains the length of the shape of the object represented in the row. |
Shape_Area | double | This column contains the area of the shape of the object represented in the row. |
geom_geojson | string | This column contains the geometry of the object represented in the row, formatted as GeoJSON. |
geom_geotext | string | This column contains the geometry of the object represented in the row, formatted as plain text. |
geom_type | string | This column contains the type of the geometry of the object represented in the row. |
geom_centroid | string | This column contains the centroid of the geometry of the object represented in the row. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometry of the object represented in the row. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometry of the object represented in the row. |
Geospatial and Object Related Data Collection for Land Survey
Column | Type | Comment |
---|---|---|
_extract_date | date | This column contains the date when the data of a specific row was extracted from the source data. It helps to track the data extraction history. |
_row_number | long | This column holds the row number from the data extracted from the source on the particular date specified in the '_extract_date' column. Together with '_extract_date', it uniquely identifies each row. |
OBJECTID | long | This column contains the unique identifier for each object in the table. |
ID | string | This column contains an ID that uniquely identifies each record in the table. |
CODE_12 | string | This column holds specific codes related to the data in each record. |
Area_Ha | double | This column contains the area measurement of each record in hectares. |
Remark | string | This column holds any additional remarks or comments related to each record. |
Shape_Leng | double | This column holds the length of the shape representing each record. |
Shape_Area | double | This column contains the area of the shape representing each record. |
geom_geojson | string | This column holds the GeoJSON representation of the geometry of each record. |
geom_geotext | string | This column contains a text representation of the geometry of each record. |
geom_type | string | This column specifies the type of the geometric shape associated with each record. |
geom_centroid | string | This column holds the centroid of the geometric shape associated with each record. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape associated with each record. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape associated with each record. |
History Table of Versioned Base Table Rows with Geometric Data
Column | Type | Comment |
---|---|---|
_start_date | date | This column contains the date when the row of data 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, the row is the most recent version. |
_row_number | long | This column contains the number of the row in the raw data as extracted from the data source. Together with '_start_date', it uniquely identifies each row in this history table. |
OBJECTID | long | This column contains the unique object identifier. |
ID | string | This column contains the unique ID of the data. |
CODE_12 | string | This column contains the 12-digit code associated with the data. |
Area_Ha | double | This column contains the area in hectares. |
Remark | string | This column contains any remarks or additional comments related to the data. |
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 specifies the type of geometry, such as point, line, polygon, etc. |
geom_centroid | string | This column contains the centroid of the geometric shape. |
geom_center_x | double | This column contains the X-coordinate of the geometric shape's center. |
geom_center_y | double | This column contains the Y-coordinate of the geometric shape's center. |
Spatial Geometric Data for Land Use Classification
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records 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 holds the object identifier. |
ID | string | This column contains the identification number. |
CODE_12 | string | This column stores the 12-digit code. |
Area_Ha | double | This column contains the area measured in hectares. |
Remark | string | This column is for any additional notes or comments. |
Shape_Leng | double | This column records the length of the shape. |
Shape_Area | double | This column stores the area of the shape. |
geom_geojson | string | This column contains the geometric data in GeoJSON format. |
geom_geotext | string | This column holds the geometric data in text format. |
geom_type | string | This column specifies the type of geometric data. |
geom_centroid | string | This column contains the centriod of the geometric shape. |
geom_center_x | double | This column records the X-coordinate of the geometric shape center. |
geom_center_y | double | This column records the Y-coordinate of the geometric shape center. |
Version History of Base Table Rows in Jonkoping Dataset Collection
Column | Type | Comment |
---|---|---|
_start_date | date | This column indicates the date when the particular row was extracted from the data source. It is a part of a unique identifier for each row in this version history table, together with '_row_number'. |
_end_date | date | This column represents the date when a new version of the particular row was extracted from the data source. If the value in this column is null, it implies 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. Together with '_start_date', it uniquely identifies each row in this version history table. |
OBJECTID | long | The column represents a unique identifier for each object in the table. |
ID | string | This column is an additional unique identifier for each row in the table. |
CODE_12 | string | This column contains a specific code associated with the row. |
Area_Ha | double | This column represents the area of the geographic feature, measured in hectares. |
Remark | string | This column is for any additional comments or remarks about the row. |
Shape_Leng | double | This column contains the length of the geographic shape associated with the row. |
Shape_Area | double | This column represents the area of the geographic shape associated with the row. |
geom_geojson | string | This column contains the geographic data in GeoJSON format. |
geom_geotext | string | This column contains the geographic data in a custom text format. |
geom_type | string | This column indicates the type of the geographic data. |
geom_centroid | string | This column contains the centroid of the geographic shape. |
geom_center_x | double | This column represents the X coordinate of the center of the geographic shape. |
geom_center_y | double | This column represents the Y coordinate of the center of the geographic shape. |
Geospatial Data Analysis of Land Properties in Sweden
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. The combination of _extract_date and _row_number uniquely identifies each row. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An additional identifier for each record. |
CODE_12 | string | A specific code associated with the record. |
Area_Ha | double | The area of the object or region represented by the record, measured in hectares. |
Remark | string | Any additional notes or comments about the record. |
Shape_Leng | double | The length of the shape or object represented by the record. |
Shape_Area | double | The area of the shape or object represented by the record. |
geom_geojson | string | The geometry of the object or region, represented in GeoJSON format. |
geom_geotext | string | The geometry of the object or region, represented in a textual format. |
geom_type | string | The type of geometry used to represent the object or region. |
geom_centroid | string | The centroid or the geometric center of the object or region. |
geom_center_x | double | The x-coordinate of the center of the object or region. |
geom_center_y | double | The y-coordinate of the center of the object or region. |
Historical Version Records of Base Table Rows from a Swedish 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 means that the row is the most recent version. |
_row_number | long | The number of the row in the raw data extracted from the data source. Together with '_start_date', it uniquely identifies each row in this version history table. |
OBJECTID | long | A unique identifier for the object represented by the row. |
ID | string | An identifier for the data entry. |
CODE_12 | string | A code representing specific information about the data entry. |
Area_Ha | double | The area of the object represented by the row, in hectares. |
Remark | string | Additional comments or remarks about the data entry. |
Shape_Leng | double | The length of the shape representing the object, in the same units as the coordinate system of the dataset. |
Shape_Area | double | The area of the shape representing the object, in the same units as the coordinate system of the dataset. |
geom_geojson | string | The geographical representation of the object in GeoJSON format. |
geom_geotext | string | The geographical representation of the object as text. |
geom_type | string | The type of the geographical object represented (e.g., point, line, polygon). |
geom_centroid | string | The centroid of the geographical object, a point representing its center. |
geom_center_x | double | The x-coordinate of the center of the geographical object. |
geom_center_y | double | The y-coordinate of the center of the geographical object. |
Land Use and Geospatial Features Dataset Table
Column | Type | Comment |
---|---|---|
_extract_date | date | This column records the date when the data on the row was extracted from the data source. |
_row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. |
OBJECTID | long | This column is likely to contain a unique identifier for each object or entry in the table. |
ID | string | This column typically contains a unique identifier for each record in the table. |
CODE_12 | string | This column likely contains specific codes related to the data source or the nature of data. |
Area_Ha | double | This column likely represents the area of a certain region or object in hectares. |
Remark | string | This column likely contains additional notes or comments about the data in the row. |
Shape_Leng | double | This column likely represents the length of a certain geographical shape or feature. |
Shape_Area | double | This column likely represents the area of a certain geographical shape or feature. |
geom_geojson | string | This column likely contains geospatial data in the GeoJSON format, a common format for encoding various geographic data structures. |
geom_geotext | string | This column likely contains geospatial data in textual form. |
geom_type | string | This column likely indicates the type of geospatial data (e.g., point, line, polygon) represented in the row. |
geom_centroid | string | This column likely contains the coordinates of the centroid, or the geometric center, of a geographical shape or feature. |
geom_center_x | double | This column likely contains the x-coordinate of the center of a geographical shape or feature. |
geom_center_y | double | This column likely contains the y-coordinate of the center of a geographical shape or feature. |
Version History Details of Base Table Rows in Jonkoping Dataset 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 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. It forms a unique identifier for each row in conjunction with the '_start_date' column. |
OBJECTID | long | This column serves as an object identifier. The specific function of this column may vary depending on the context of the table. |
ID | string | This column typically contains a unique identifier for each row or object in the table. |
CODE_12 | string | This column likely contains specific codes or identifiers related to the data. The exact meaning of these codes may be contingent on the context of the dataset. |
Area_Ha | double | This column contains area measurements, likely in hectares (Ha). The specific areas these measurements represent would be context-dependent. |
Remark | string | This column is likely to contain additional comments or notes related to each row or object in the table. |
Shape_Leng | double | This column probably contains the lengths of various shapes, potentially related to geographic or spatial data. The specific interpretation of these lengths would depend on the context. |
Shape_Area | double | This column likely contains measurements of the areas of various shapes, possibly related to geographic or spatial data. The specific areas these measurements represent would be context-dependent. |
geom_geojson | string | This column contains geometric data in the GeoJSON format, a common format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains geometric data in text format. The specific format and interpretation of this data would depend on the context of the dataset. |
geom_type | string | This column specifies the type of geometric data stored in the row. The type could refer to various forms of geometric shapes or structures. |
geom_centroid | string | This column contains the centroid of the geometric shape represented in the row. A centroid is the center point of a geometric shape. |
geom_center_x | double | This column contains the x-coordinate of the center of the geometric shape represented in the row. |
geom_center_y | double | This column contains the y-coordinate of the center of the geometric shape represented in the row. |
Dataset Table: Geographic and Geometric Data Collection
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 additional identifier for each object in the table. |
CODE_12 | string | A coded value that provides specific information about the object. |
Area_Ha | double | The area of the land object in hectares. |
Remark | string | Additional notes or comments relevant to the object. |
Shape_Leng | double | The length of the shape of the land object. |
Shape_Area | double | The area of the shape of the land object. |
geom_geojson | string | The geometric representation of the land object in GeoJSON format. |
geom_geotext | string | The geometric representation of the land object in text format. |
geom_type | string | The type of geometric shape of the land object. |
geom_centroid | string | The centroid of the geometric shape of the land object. |
geom_center_x | double | The x-coordinate of the center of the geometric shape of the land object. |
geom_center_y | double | The y-coordinate of the center of the geometric shape of the land object. |
Version History Table of Land and Geographic Objects from Swedish National Land Survey
Column | Type | Comment |
---|---|---|
_start_date | date | This column holds the date when the row was extracted from the data source. It is part of a combination with the '_row_number' column that uniquely identifies each row in this version history table. |
_end_date | date | This column holds 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 a unique identification number for each object in the table. |
ID | string | This column holds a unique identifier for each row. |
CODE_12 | string | This column holds a specific code related to the row's data. |
Area_Ha | double | This column records the area of the object in hectares. |
Remark | string | This column contains any additional comments or remarks related to the row's data. |
Shape_Leng | double | This column holds the length of the geographical shape associated with the row. |
Shape_Area | double | This column contains the area of the geographical shape associated with the row. |
geom_geojson | string | This column holds the geographical data in GeoJSON format. |
geom_geotext | string | This column contains the geographical data in plain text format. |
geom_type | string | This column specifies the type of geographical shape associated with the row. |
geom_centroid | string | This column contains the centroid or geometric center of the geographical shape associated with the row. |
geom_center_x | double | This column holds the X-coordinate for the center of the geographical shape associated with the row. |
geom_center_y | double | This column holds the Y-coordinate for the center of the geographical shape associated with the row. |
Geospatial Feature Analysis Derived from Swedish National Land Survey
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data on the row was extracted from the source. It is part of a unique identifier for each row when combined with '_row_number'. |
_row_number | long | The row number in the data extracted from the source on the extract date specified by the column '_extract_date'. It forms part of a unique identifier for each row when combined with '_extract_date'. |
OBJECTID | long | A unique identifier for each object in the table. |
ID | string | An identification code for each entry in the table. |
CODE_12 | string | A specific code associated with each entry, possibly indicating a classification or category. |
Area_Ha | double | The area of the geographical entity represented by the row, measured in hectares. |
Remark | string | Any additional notes or comments related to the entry. |
Shape_Leng | double | The length of the boundary of the geographical entity represented by the row. |
Shape_Area | double | The area of the geographical entity represented by the row, possibly in a unit different from 'Area_Ha'. |
geom_geojson | string | The geographical coordinates of the entity, represented in the GeoJSON format. |
geom_geotext | string | The geographical coordinates of the entity, represented in a textual format. |
geom_type | string | The type of the geographical entity represented by the row (e.g., polygon, point, line). |
geom_centroid | string | The coordinates of the centroid (geographical center) of the entity. |
geom_center_x | double | The X coordinate (longitude) of the center of the geographical entity. |
geom_center_y | double | The Y coordinate (latitude) of the center of the geographical entity. |
Version History of Base Table Rows in Swedish Land Survey 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 the unique identifier for 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 part of the unique identifier for each row in this table. |
OBJECTID | long | An identifier for the object represented in the row. |
ID | string | An additional identifier for the object represented in the row. |
CODE_12 | string | This is a code associated with the object represented in the row. |
Area_Ha | double | This column represents the area of the object in hectares. |
Remark | string | This column may contain additional remarks or comments about the object represented in 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 the geometric representation of the object in a textual format. |
geom_type | string | This column specifies 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. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | August 26, 2024 |