Geospatial Data Analysis of Land Areas and Objects
Click here for a data sample
The table under consideration is a part of a dataset collection and is sourced from the website of Lantmäteriet, a Swedish agency. The table contains a variety of data columns, each holding specific information. Two special columns in the table provide the date of data extraction and the row number in the extracted data, effectively serving as unique identifiers for each row. Additionally, the table contains geospatial data, originally in shapefile format, representing geographic features as points, lines, or polygons. The data in this table could be very useful in data analytics. For instance, by analyzing the geospatial data, one could identify patterns or trends related to specific geographic locations. The extraction date could be used to track changes over time, providing insights into temporal trends. The row number could be used in data quality management, such as identifying missing or duplicate data.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column holds 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. The combination of this column and '_extract_date' uniquely identifies each row. |
|---|
| OBJECTID | long | This column contains a unique identifier for each object in the table. |
|---|
| ID | string | This column holds another form of unique identifier for each object in the table. |
|---|
| CODE_12 | string | This column holds a specific code associated with each record in the table. |
|---|
| Area_Ha | double | This column contains the area of the object, measured in hectares. |
|---|
| Remark | string | This column holds any additional comments or remarks about the object. |
|---|
| 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 geometry of the object in GeoJSON format. |
|---|
| geom_geotext | string | This column holds the geometry of the object in a text-readable format. |
|---|
| geom_type | string | This column specifies the type of the geometrical object. |
|---|
| geom_centroid | string | This column contains the centroid of the geometrical object. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the center of the geometrical object. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the center of the geometrical object. |
|---|
