Geospatial Data Table for Stockholm Collection with Land Cover, Area Measurements, and Geometry Details
Click here for a data sample
The table is a part of a dataset from the 'Lantmäteriet' website, located in Sweden. It contains data organized into various categories. Each row in the table is uniquely identified by an extraction date and a row number, indicating when the data was pulled and its order in that extraction. The table also includes an 'OBJECTID' and an 'ID', both of which appear to be identifiers for the data entries. There's a 'CODE_12' column, which could represent a specific coding system related to the data, and an 'Area_Ha' that likely refers to a land area measurement in hectares. The 'Remark' column could contain additional notes or comments about the data. The table also holds geometric information about geographic features, originally sourced from a shapefile. This includes the length and area of the shape, represented in the 'Shape_Leng' and 'Shape_Area' columns, and the actual geometry of the shape in various formats, including GeoJSON and GeoText. The type of geometric shape, the centroid coordinates, and the center coordinates in the x and y axis are also included. All these geographic information help represent the data in a spatial context. For example, the data in this table could be used to perform spatial analysis or create geographic visualizations. The area measurements could be analyzed to understand land usage patterns, while the geometric data could be used to map these patterns visually. The 'CODE_12' column could also be used to categorize the data for further analysis.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column contains the date when the data in a particular row was extracted. It is part of a unique identifier for each row, along with the '_row_number' column. |
|---|
| _row_number | long | This column contains the row number in the data as it was extracted from the source. Along with the '_extract_date' column, it forms a unique identifier for each row. |
|---|
| OBJECTID | long | This column holds the unique object identifiers for the data objects in the table. |
|---|
| ID | string | This column provides an additional unique identifier for each entry, typically in a formatted string form. |
|---|
| CODE_12 | string | This column contains numerical codes, the meaning of which is dependent on the context of the dataset. |
|---|
| Area_Ha | double | This column represents the area of the corresponding data object, measured in hectares. |
|---|
| Remark | string | This column is reserved for any additional comments or notes related to a particular row. |
|---|
| Shape_Leng | double | This column is meant to contain information about the length of the shape represented by the data object. However, it appears to be unused in the current dataset. |
|---|
| Shape_Area | double | This column provides the calculated area of the shape represented by each data object. It is likely measured in a unit consistent with the dataset, such as square meters. |
|---|
| geom_geojson | string | This column contains the geometrical data of the shape represented by each data object, formatted as a GeoJSON, a type of JSON designed to represent geographical features. |
|---|
| geom_geotext | string | This column holds the geometrical data of the shape in a text format. This can be useful for visualizing the shape or for use with certain software. |
|---|
| geom_type | string | This column describes the geometrical type of the shape represented by each data object. In this dataset, they appear to all be polygons. |
|---|
| geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the shape represented by each data object. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the centroid of the shape represented by each data object. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the centroid of the shape represented by each data object. |
|---|
