Enhancing Spatial Data Analysis in QGIS
Explore the integration of relational databases with QGIS to facilitate efficient spatial data analysis. Discover the importance of recognizing spatial relationships within data sets and the solutions to enhance QGIS for relational datasets. Overcome challenges and delve into the intersection and subsets of relational datasets for effective decision-making and management. Embrace a comprehensive approach to handling spatial data efficiently.
Uploaded on Sep 19, 2024 | 0 Views
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
E N D
Presentation Transcript
A QGIS attribute table plugin to describe shapes By Philip Whitten Supervisor James O Brien
A large store of data accumulated from a wide range of sources wide range of sources within a company and used to guide management decisions* Data Warehouse A database structured to recognize relations between stored items of information* relations Relational database Specifies how some object is located in space in relation relation to some reference object+ Spatial Relation *Oxford Living Dictionaries, Oxford University Press +Wikipedia
Problem I get a lot of spatial data sets from a lot of sources that I store in relational databases. I spend a lot of time looking for spatial relations with relational databases, and, I have found that graphical user interfaces like QGIS or ArcMap occasionally inhibit the study of spatial relationships.
Solution Make QGIS more receptive to relational databases Relational Datasets QGIS Problems Progress Conference
Relational Datasets Spatial Datasets - Sets
Relational Datasets Spatial Datasets - Relationships
Relational Datasets Sets The subset ? = ?,? of the universal set ? = ?,?,?,?,? A B a i o u e ??????? = ??????,??????,?????? ?????? ?? ??????? ??? = 1,2,3
Relational Datasets Set Intersection h ?,?,?,?,? ,?,?,?,?,?,? = ?,? a l e o u i g p ?,?,?,?,? ?,?,? = a l e o f u i y = empty set
???? ? ???? ? = ? ????????????? ????? (2,1) ???? ? ???? ? = ? ????????????? ???? ? ???? ? = ? ????????????? ????? 1,1 ,(3,1) Empty shapes occur whenever the set operation or topology means that no geometry exists Relational Datasets
Many GIS datasets are constrained to a single shape column You can t show a spatial relationship in a single dataset without multiple shape columns! Relational Datasets
Empty shapes enable spatial relationships in a single dataset Square Squares (shape) ?????? ???? ?????? ??? ? Left square Right square Point Type Points (shape) ?????????? ?1,?2,?4 ?????????? ?3 Blue crosses Red circles ?????? ??????? Point Type Blue crosses Red circles Blue crosses Square Left square Left square Right square Shape Multi????? ?1,?2 ?????????? ?3 ?????????? ?4 Point Type Left square (shape) Multi????? ?1,?2 ?????????? ?3 Right square (shape) ?????????? ?4 ?????????? Relational Datasets Blue crosses Red circles
Relational Datasets Set variables Let x be an element of ? = ?,?,?,?,? A a i o Hence, x = ? , x = ? , x = ? , x = ? , or, x = ? Unknown elements of a set can t be shown on a Venn diagram Unknown elements of a set are denoted as null in most databases. u e
Relational Datasets null s in datasets = unknown Road Id Rd1 Rd2 Rd3 Rd4 Road Name Picton null Appin Road Type Road Lane Lane null Road Id Rd1 Rd2 Rd3 Rd4 Road Id Rd1 Rd2 Rd4 Road Name Picton Appin Road Id Rd1 Rd2 Rd3 Road Type Road Lane Lane
nulls are always about Road Id Rd1 Rd2 Rd3 Rd4 Road Name Picton null Appin Road Type Road Lane Lane null Line null ???? ((2,0),(2,2)) ???? ((1,1),(1,3)) ???? ((0,2),(3,2)) Road Id Rd1 Rd2 Rd3 Rd4 Road Name Picton null Appin Road Type Road Lane Lane null Road Id Rd2 Rd3 Rd4 Line ???? ((2,0),(2,2)) ???? ((1,1),(1,3)) ???? ((0,2),(3,2))
QGIS QGIS: a user interface for spatial datasets
WITHOUT CONFIGURATION PARAMETERS, INDEXES OR CONSTRAINTS!!!! QGIS
QGIS The attribute table in QGIS hides the Shape attribute! ?
The Attribute Table Shows Records That Dont Have a Shape!! QGIS
Problems Identified Problems 1. Null and empty shapes are passed differently by different QGIS data providers 2. There isn t a published QGIS plugin that highlights those records that have null or empty shapes 3. Many GIS professionals don t anticipate or check for null or empty shapes 4. Empty shapes were excluded from the original QGIS and GDAL specifications 5. The QGIS attribute table hides the shape column/s.
Proposed Attribute Table Contains regular attributes Uses icons to represent number of features for multipart features. Identifies Empty and null features Performs rudimentary validation checks Attributes depend on shape type (e.g. LineString, CircularString) Includes summary table Key Name Shape Number of Points Valid 1 Blue Crosses 3 2 Red Circles 1 3 Green Stars Empty 0 4 Yellow Triangles null null Type Empty or null All Valid Number of records Number of parts Dataprovider MultiPoint Yes Yes 4 4 mssql Progress
Progress Progress Create model line datasets in QGIS, Microsoft SQL Server and PostGIS Inspect model datasets using script in the QGIS Python Console. Learn how to make a QGIS plugin (Python v3.x) Learn how to make tables and windows with PyQT5 Create and populate attribute table via plugin and PyQT5 Present at conference Submit final report
Passing of empty and null well known text shapes to QGIS Geometry Postgis Sql Server QGIS is unable to instantiate empty Point shapes Empty null Empty null Point Invalid null Invalid null Line Empty null null null Polygon Empty null null null CurvePolygon ? ? No No Progress
Conference Free and Open Source Free and Open Source Software for Geospatial Software for Geospatial (FOSS4G) (FOSS4G) "Open Source for Sustainable Development December 2-5, 2018
