Disclaimer
The objective of this tutorial is to get familiar with the GIS software. The tutorial only covers some parts that are being done in a real analysis. The results that are being displayed in the tutorial can’t be compared with the results a real analysis would generate.
Introduction
In this exercise you are going to prepare a Needs Analysis Map which will look like this.
In Chapter 5, there are five attribute tables that can be used for the Needs Analysis:
NA01 Needs Analysis: Socio Services by Barangay;
NA02 Needs Analysis: Eco Services by Barangay;
NA03 Needs Analysis: Infrastructure provision by Barangay;
NA04 Needs Analysis: Socio Condition by Facility;
NA05 Needs Analysis: Infrastructure Condition by Utility
In this tutorial we are going to use NA01, however the same approach can be applied for the other tables.
The Metadata instructions for NA01 Table looks like this:
| 1 | Getting Started – Controlling the Attribute File |
| 1.1 | Start Excel. |
| 1.2 | Open the file NA01_2008.dbf in the folder C:\ \CLUP_EXERCISE_DATA\05_NA.
|
‘No’ indicates a ‘problem’ as explained in the Instructions sheet of the metadata for NA01 table. For example ‘No’ under Column ‘B_SCH’ for Barangay Payaad (yellow cell in the table above) will be found on the map as ‘Barangay with unacceptable net enrolment ratio in primary education’. |
|
| 1.3 | If you have made any changes in the file, observe that the file is saved as a dbf file. |
| 1.4 | Exit Excel |
| 2 | Getting Started in ArcMap |
| 2.1 | Open ArcMap, select a new empty map. You will now save the map file. Click on File>Save as… in the menu bar. Browse to the folder C:\\CLUP_EXERCISE_DATA\06_Workfolder and type ‘Needsanalysis_v1.mxd’. Click Save/OK. |
| 2.2 | Click on the add data button and browse to C:\ \CLUP_EXERCISE_DATA\00_BM and select the files: barangays_bndry Lake municipal_bndry Rivers Roads Click OK. Click on the add data button and browse to C:\ \CLUP_EXERCISE_DATA\05_NA and select the file: NA01_2008.dbf Click OK. |
| 3 | Joining the Attribute Table with the Barangay |
| 3.1 | In the table of content, right-click on the barangay, select Joins and Relates > Join… (see image below). |
| 3.2 | The Join Data window appears. In the first (un-numbered) list menu select Join attributes from a table. For the other list menus (number 1 to 3) select the following: 1: NAME 2: NA01 3: B_NM (Also refer to the image below.) Click OK.  |
| 4 | Improving (Cleaning) the Joined Table |
There are many columns in the attribute table and it is hard to interpret it. Several columns are of no interest for the socioeconomic analysis and some that are of interest are hard to understand. Therefore we will make the not needed columns invisible and add better alias for the columns of interest. Then, both the table itself and the map legend will be easier to understand. |
|
| 4.1 | Rename the Barangay layer to ‘Socio Services by Barangay’. (Go to the table of content, right-click and select Properties to open the Layer Properties window. Go to the General tab to rename the layer. Don’t close this window yet! |
| 4.2 | Open the attribute table. (Right-click on the layer in the table of content and select Open Attribute Table.) When the table appears note all the strangely named columns and the amount columns making it more difficult to interpet the table. |
| 4.3 | Go back to the Layer Properties window. Select the Fields tab. (Field indicates a table column.) |
| 4.4 | You will now choose which fields will be visible and assign a proper alias to them. Simply select the checkbox before the field name and type the alias in the Alias column. The following fields should be selected and assigned alias: barangays_bndry.Name – ‘Barangay Name’ |
| 4.5 | To make an alias type in the box for alias and to make a column invisible there should be no tic in the box for visible below. The result after the cleaning will look like this: |
| 4.6 | For better contrast, set the outline color of the Barangay Layer to white by double clicking on the layer symbol of the Table of Contents. |
| 5 | Making selection by attributes |
In order to display the different Needs for each barangay, we have to single out the sub sector needs of each barangay and create a new layer so that it can be displayed together with the other needs. |
|
| 5.1 | Open the selection menu >selection by attribute |
| 5.2 | The layer that we are making our selection from is ‘Socio Services by Barangay’. In the operator window type "NA01.B_ADM_" = 'No' Press the Apply button.
|
| 5.3 | In the list of contents right click on the layer, then > Selection >Create Layer From Selected Features. |
| 5.4 | We name the new layer “Barangay with no Barangay Hall/Office’ and change the symbology. Though the symbology would be dependent on how many criterias are to be evaluated, the idea for this example is to combine symbology that would not completely cover a previous layer. For this example, we use a single fill color.  |
| 5.5 | Do the same with the other examples applying these symbology: Making the symbology for the layer Barangay with unacceptable proportion of households with income less than poverty threshold can be at bit tricky. The easiest way to give the layer appropriate symbology is to click on the symbol in the list of contents. The Symbol Selector window will open. Click More symbols and select Forestry. To the left, search and select the T23 Pipeline 2 symbol. Choose width 9,00. Click OK |
 |
|
| 6 | Presentation |
The Layout format of this IP that can be used in a display or be inserted in a report will look like this. In order to prepare this and make a print out you need brush up your knowledge about the Layout View.
|
Ver 1.0
| Attachment | Size |
|---|---|
| 7.09 How to Create the Needs Analysis Layer (PDF) | 1013.74 KB |