PROCESS FLOW DIAGRAM
ArcGIS/QGIS
Provided with a Scanned Plan of Land Parcels, and a few sets of control Points,
Populating
Add Georeferenc Attribute
ing Digitizing
Data table
Queries
Decision
Making
Querying the table is what remains, its main purpose
Is to help in decision making….
We can look at a number of them…
Next Slide
SELECT * FROM
land_parcels WHERE gender = „F‟
Make A graph Showing Areas of Parcels
+
Prices
And Extending out the Largest Parcel
SELECT * FROMLand_parcels
WHERE Town = Nyeri
Make a Line Graph of Land values in Nyeri
AGAINST
Their Areas
Ubnormal Situation!!
Land Value decreases with increasing Areas
Subject to Further Analysis
SELECT * FROM landParcel
WHERE Value < 300000
Make a dot Distribution map
of the area against Value
Blue-less than 300,000
Orange-More than 300,000
Selection is still broad…
We refine by imposing further criterion
SELECT * FROM landParcels
WHERE value < 300,000
AND town = Nairobi
We Have 5 selections. To have a best deal…
One More Rule,
Perhaps the largest in area among the
selected
SELECT * FROMlandParcels
WHERE value < 300,000
AND town = Nairobi
AND SHAPE_Area > 350.00
FOUND THE LAND!
Contact Joel Maina:
Box Number: 34136 Nairobi,
Parcel Serial Number:448.
Land Area: 388.154m2
Land Value: 200,000
PERFORMING JOINS IN QGIS
QGIS
Add Add Join in the Query the
CSV doc delimite properties Table
d text window
Decision
Making
QUERIES IN QGIS
QGIS SELECT * FROM landParcels
"LandOwnersb_gender" = 'female'
STDM
For handling
Spatial Data
Populate Query
Create a Create Create A
The the table
database extension table
table
INSERT INTO SELECT *
CREATE TABLE landParcels(specif FROM
“CREATE EXTENSION
landParcels(Specify y target fields) landParcels
postgis”
fields and Constrains) VALUES(specify WHERE
values) gender = „F‟
SQL Command
QUERY STATEMENT