Land Contours Data from the Swedish 'sve_20milj_sweref_99_tm_shape' Collection
Click here for a data sample
The 'land20l' table is part of a dataset collection that includes geographic data related to land contours in Sweden. The data in this table includes information about the coastline and national boundaries, represented in the form of line strings. The table provides geographic information in both the GeoJSON and GeoText formats, as well as the type of the geometric feature (in this case, a line string), and the centroid of the geometric feature. The table also includes the geographic coordinates (x and y) of the geometric center of the feature. To ensure unique identification of each row, the table includes two special columns that denote the date of data extraction and the row number in the data extracted. The data is sourced from the website of Lantmäteriet (The Swedish Mapping, Cadastral and Land Registration Authority) in Sweden. As for potential utilization in data analytics, the information in this table could be used to create detailed maps of Sweden's coastline and national boundaries, to analyze changes in these boundaries over time, or to support studies in environmental science, urban planning, or real estate development.
Field Descriptions
Name |
Data type |
Description |
_extract_date | date | This column records the date on which the data in each row was extracted from the source. It helps to keep track of the data extraction history and maintain data integrity. |
_row_number | long | This column contains the row number in the data that was extracted from the source on the specific extract date. Combining this column with the '_extract_date' column provides a unique identifier for each row of data. |
KKOD | string | This column contains category code. It is a type of data classification that helps in understanding and organizing the data. |
geom_geojson | string | This column holds the geographic data in GeoJSON format, a common format for encoding a variety of geographic data structures. |
geom_geotext | string | This column contains the geographic data in text format. It presents the geographic coordinates of the data in a readable format. |
geom_type | string | This column describes the geometric type of the data, for example, whether it's a 'line', 'point', 'polygon', etc. |
geom_centroid | string | This column contains the centroid of the geometric data. The centroid is the geometric center of a two-dimensional shape. |
geom_center_x | double | This column records the x-coordinate of the geometric center or centroid of the data. It helps in locating the data on a map. |
geom_center_y | double | This column records the y-coordinate of the geometric center or centroid of the data. It, along with the 'geom_center_x' column, helps in precisely locating the data on a map. |