Performing Spatial Query on feature layers in QGIS

Document1-001

A Spatial Query is a selection made on the spatial element of the database. Unlike Selection based on attributes, it is characterized by the topology (relationship with other objects in the same geographic extent) of the object that is queried.
Task
This demonstration illustrates the spatial query to be carried out to resolve customer complaints to a Utility Company. The Utility Company has a Tariff Map that delineates areas within a city into High, Medium and Low Tariff Blocks (red boxed).

1

Subsequently, Customer complaints from Parcels-543,435 and 378 (as seen above) have reached the Company Office about abnormally high utility bills. In order to save time and money, the Company GIS team will analyze the complaints so as to forward the viable complaints to the ground teams.
Steps
Three spatial queries were performed.
– Spatial query to know which Parcels fall within the Low Tariff Block.
– Spatial query to know which Parcels fall within the High Tariff Block.
– And a third Spatial query to ascertain whether there are Parcels that overlap between the Low and High Tariff Blocks.

Procedure
1. Go to Vector >Spatial Query >Spatial Query

2

2. In the Spatial Query dialog box, we first want to determine which parcels are completely within the Low Tariff Block especially in respect to the complaint from Parcel 543. We Select Source features- PARCELS that are WITHIN target or reference feature- LOW TARIFF BLOCK. Two parcels are highlighted- 302 and 304 but 543 is not highlighted but it falls within the Low Tariff Block. But also note that Parcels 435 and 378 are not highlighted.

3

3. Right Click on the Parcels layer >Open Attribute Table to see that the Selected Parcels were highlighted.

4

4. See the Selection of our Spatial Query highlighted in blue.

5

5. We run another spatial query to ascertain which Parcels are within the High Tariff Block. The result shows that Parcels- 435 and 378 fall within the High Tariff block. Parcel 543 again is not within the High Tariff Block.

6

6. To further filter the data, we run a third spatial query selecting the Parcels that overlap into the High Tariff Block. Viola! Parcel 543 is selected.

7

Results of the Spatial Query

  1. for Customer Complaints from Parcels- 543, 435 and 378. Read brown box.8
  2. Hope you enjoyed the post.
    Keep practicing so we can share your experience.
Advertisements

One response to “Performing Spatial Query on feature layers in QGIS

  1. Pingback: What’s New In GIS And Biological Research: 19 May 2015 | GIS In Ecology·

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s