To download the data set, please sign up or log in

gavleborg

The dataset collection consists of several tables of related data, organized in rows and columns. These tables originate from the website of 'Lantmäteriet' (The Land Survey) in Sweden. Each table within the dataset collection represents a unique subset of data, making it a comprehensive resource for a wide range of analysis and research purposes.

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 13, 2024
Created August 26, 2024