7.05 Socio-economic Sector Tutorial

7.05.01 Education

 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 The Output map of this tutorial is a map showing the physical condition of the schools in the area and a 1000 meters buffer around the schools, illustrating the schools catchments area. All map layers are presumed to have been digitized, projected and georeferenced before proceeding to this tutorial.
1 Getting started
1.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\ and type ‘Educational_v1.mxd’. Click Save/OK.
1.2 Add the files………. . Click on the add data button and browse to C:\CLUP_EXERCISE_DATA\00_BI and select the files. Barangay_bndry Lakes Municipal_bndry Roads Rivers Click OK. Click on the add data button and browse to C:\CLUP_EXERCISE_DATA\01_SE and select the files. SE19_SchTp2007 SE20_SchCap2007 Click OK. (See image below.)
2 Joining the tables
  We are now going to join the table containing the schools (SE19) with the table containing the physical condition of the schools (SE20). Both these tables have one column in common and that is the SCH_ID column. We are joining these two tables based on this.
2.1 In the layer menu right click on the school layer, select Joins and Relates>Join… In the field “What do you want to join to this layer?”, mark Join attributes from a table
2.2 In the field “Choose the field in this layer that the join will be based on”, mark SCH_ID
2.3 In the field “Choose the table to join to this layer, or load the table from disk”, mark SchCapYr1
2.4 In the field “Choose the field in the table to base the join on:”, mark SCH_ID
2.5 Press the Ok button
2.6 Open up the attribute table of the school layer to see if the two tables have joined correctly. If they have done this, your attribute table should look like the one below.
3 Making selection by attributes
 In this example we are analyzing the following aspects of the educational sector: Schools in fair, poor or critical condition.
 The schools physical condition Since none of the schools in the area are in critical condition, we only have to make two layers. One that contains schools in fair physical condition, and a second layer that contains schools in poor physical condition. To do this you have to do the following query.
3.1 Open the selection menu >selection by attribute
3.2 The layer that we are making our selection from is the school layer. In the operator window type "SchCapYr1.SCH_CON" = 'Poor'
3.3 Press the Apply button
3.4 In the layer menu right click on the school layer, then > Selection >Create Layer From Selected Features.
3.5 Rename the newly created layer Schools in poor physical condition. The symbol for the new layer should be a yellow square
3.6 Repeat step 1-5 but change the operator window to "SchCapYr1.SCH_CON" = 'fair' in number 2. The symbol for schools in fair physical condition should be a green square When you have created the two new layers your screen should look like the one below.
4 Buffering
 In this example we assume that the catchments areas of the schools are 1000 meters and therefore we create a circular buffer around the schools with a radius of 1000 meters.
4.1 Open the Buffer Wizard >The features of a layer.
4.2 The selected layer is SE19_SchTp2007
4.3 Press the next button.
4.4 Set the distance units to Meters.
4.5 Set the distance to 1000 meters in the bullet “At a specified distance
4.6 Press the next button
4.7 In the “buffer output type” mark yes to the question “Dissolve barriers between”.
4.8 In the bullet “specify output shapefile or feature class” as C:\ CLUP_EXERCISE_DATA\01_SE _1000meter_buffer_of _schools
4.9 Press the Finish button
5 Presentation
 The final step is to present the results of the analysis. The final products should be effectively communicating the findings to your audience. In most cases, the results of the GIS analysis can best be shown on a map. Charts and reports of selected data are two other ways of presenting the results. Charts and reports can be printed separately, be embedded in the CLUP narrative text or be placed on a map. The education analysis layers will be put on top of the Base Map. As recommended in Volume two, it is be overlaid with the population density map to show distribution of schools with respect to the number of people residing within an area: A zoomed screenshot of the map.
Ver 1.0