Main menu:
7. GIS for land use planning
7.8 Land Evaluation / Land Suitability
Level of expertise required for this Chapter: Advanced; specifically for LUPMIS @ TCPD
Planning requires ‘siting’ of specific land uses for the best available place taking into consideration essential factors such as safety, access, engineering feasibility, soil, economic, technical and environmental conditions etc.
In a more advanced interpretation it is possible to overlay the individual layers, which have an impact on planning, to assess the land showing suitable (and unsuitable) areas for a particular land use.
This process is called land evaluation, showing the land suitability, at GIS for land use planning also called ‘siting analysis’.
In the example below, there are four layers considered:
In a real planning scenario, there might be the need to consider more layers, such as ownership, agricultural suitability (soil, topography, climate, drainage), slope etc.
The general process is listed below:
- 1. Buffering, if necessary (in GIS, see Chapter 3.1)
Note: The buffer zone should have a style number greater than 0
- 2. Intersecting all layers (in GIS, see step 1.1 of Chapter 4.5)
- 3. Importing (‘indent’) attributes of the land of each layer (in GIS, see step 1.2-1.11 of Chapter 4.5)
- 4. Defining the interaction formulae between all layers (in spreadsheet, see Part 2 of Chapter 4.5 and explanations below)
- 5. Display the units, which are suitable (in GIS, see Part 3 of Chapter 4.5)
- - - -
The calculation in a spreadsheet like Excel might require some explanations:
If the precondition is met, that all covered areas, including buffer areas, have a style greater than 0, a 0 in the spreadsheet cell indicates, that this area is outside.
In the example above, row 2:
IF function in Excel
The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. It is written as:
=IF(logical_test, value_if_true, value_if_false)
For example: =IF(B2=0,true,false) will return True if B2 is equal to 0 and False if B2 is not equal to 0.
AND function in Excel
A common use for the AND function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE.
By using the AND function as the logical test argument of the IF function, you can test many different conditions instead of just one. It is written as:
AND (logical1, [logical2], ...)
e.g. ...AND(B2=0,C2=1,......)
To identify the area that meets the above mentioned criteria for siting an industrial area the formula would be:
=IF(AND(D2=0,E2=4,F2=1,G2=0),2,1)
Using this formula means:
IF (an object in D2 has a value of 0 {i.e. is not within the coast bufferand the object in E2 has a value of 4 (i.e. within the structure plan area) and in F2 has a value of 1(i.e. within the road buffer) and in G2 has a value of 0 (i.e. outside the river buffer), the result should be “1” otherwise “2”.
Save as XLS file.
For display in Map Maker, see Part 3 of Chapter 4.5. The green areas in the example below indicate the sites suitable for siting industrial activity.