User`s Manual for Building the CBMS Database and Poverty
Contents
1. Building the CBMS Database and Poverty Mapping 17 Module 3 Training THE CBMS NETWORK COORDINATING TEAM DR CELIA M REYES CBMS Network Leader ANNE BERNADETTE E MANDAP JASMINDA A QUILITIS MARSMATH A BARIS JR ALELLIE B SOBREVINAS JEREMY L DE JESUS ERICA PAULA S SIOSON NOVEE LOR C LEYSO STEFFIE JOI I CALUBAYAN Research Staff Inquiries regarding this CBMS work may be sent to CBMS Network Coordinating Team Angelo King Institute for Economic and Business Studies 10th Floor Angelo King International Center Estrada Corner Arellano Avenue Malate Manila Philippines 1004 Tel No 632 5262067 632 524 8888 loc 274 Fax No 632 5262067 E mail coms benilde edu ph coms net gmail com Website www pep net org2. Import format is NRDB_ImportSpecs_Core nri IV Poverty Mapping and CBMS Data Results A Adding layers for the CBMS core indicators 1 Click on Map layers and click the button Add 2 At the barangay level select the following Under Feature select Barangay CBMS Core Indicators Under Name select the name of your barangay ex Brgy Burgos Under Display select Barangay boundaries polylines polygons Under Label select of HHs without access to safe water Click OK then Click Close to close the map layer window The map will be displayed Building the CBMS Database and Poverty Mapping 9 Module 3 Training 3 At the purok level select the following Under Feature select Purok CBMS Core Indicators Under Name select the purok names of your barangay Under Display select Purok boundaries polylines polygons Under Label select of HHs without access to safe water Click OK then Click Close to close the map layer window The map will be displayed File Edit Data Map Report Graph Window Help i 212 amp alal altulo Burgos SABLAYAN UNIVERSAL TRANSVERSE MERCATOR UTM Seale 1 276654 J 4 a 12 34 50 0 N 1211641 E 4 At the household level select the following Under Feature select Household CBMS Core Indicators Under Name select the id of all households in all puroks in the barangay Under Display select Household location coordinates Under Label select HHs without access to saf
3. Imported Definition Household CEMS Demograpk Imported features Household CEMS Demography Imported data Household CAMS Demography Imported Definition Household CEMS Core Indica Imported features Household CAMS Core Indicate Imported data Household CEMS Core Indicators Imported Definition Household CEMS Other Indic Imported features Household CAMS Other Indical Imported data Household CAMS Other Indicators Imported Definition Purok CEMS Demography Imported features Purok CEMS Demography Imported data Furok CEMS Demography Imported Definition Purok CEMS Core Indicators z Co D _ a N Please note that updating the data dictionary should only be done once lll Importing CBMS data from CBMS StatSim The CBMS StatSim generates tables ready for import into the CBMS database The tables contain CBMS data that has been processed and consolidated at all available geopolitical levels It is outputted with as a MS Access file with specific format compatible with the specifications of the CBMS NRDB The files nri are located in the folder C CBMSDatabase System Specs Building the CBMS Database and Poverty Mapping 3 Module 3 Training BMS The MS Access file that contains the indicators is located in C CBMSDatabase System Output with file name Ind _NRDB mdb This file contains the tables hh_coreind purok_coreind orgy _coreind mun_coreind orov_coreind and regn_coreind that conta
4. names of the household purok barangay and municipality matches the user will be prompted to enter the date Otherwise a window Select Feature Name will open For each feature name e g purok household found file being imported that does not match one already defined in the database the Select Feature Name dialog box is displayed Select Feature Name The following feature was not found in the database or ts not unique Please select or create the comesponding feature Building the CBMS Database and Poverty Mapping 8 Module 3 Training S PWNS N juopa CBMS The options are Create create a new name The Add Name will prompt you to type the name of the selected feature The default name of the feature is the name that you used and save that polygon while digitizing Create All automatically create names for all using the default names do not prompt Select if the spelling is different then the CBMS NADB will display the closest match Click on the Select button to accept the match or select one from the list Skip Do not import this feature 8 Follow steps III A 5 to 6 Below is a summary table for the tables in the Access file to be imported features where data will be placed and file import format that should be used table tobe imported to be table tobe imported Feature to hold data hh_coreind purok_coreind brgy_coreind mun_coreind Import format is NOT provided
5. of features should be carefully considered Municipality polygon PF None P Municipal CBMS Municipal CBMS foe Demography cecoccooooo Indicators numbers numbers Other relevant municipal data Roads schools etc polylines polygons coordinates Barangay ieeeeueees polygon PF e Barangay CBMS Barangay CBMS Municipality cece Demography ceccccccccs Indicators numbers numbers Other relevant barangay data Roads schools etc polylines polygons coordinates Purok CBMS Indicators numbers Purok errr a polygon PF Barangay LAES Purok CBMS Demography numbers Other relevant purok data Roads schools etc polylines polygons coordinates Household CBMS Indicators Boolean text Household CBMS Demography numbers Household coordinates eceoooooooooooo PF Purok Hierarchy Seer EESE One to one Building the CBMS Database and Poverty Mapping Module 3 Training Many to one ll Modifying the Data Dictionary to accommodate CBMS data The CBMS NRDB data dictionary provided to the municipalities during the training on digitizing needs to be updated to accommodate the data that will be imported into the database Additional features associated with the different geopolitical levels should be added to house the CBMS data generated by the CBMS Indicator Simulator To update the Data Dictionary From the file menu select Import Import File N
6. ranges c To add a range put the minimum value in the box beside Min and the maximum value in the box beside Max and click Add for every range d Select the Layer tab click on the drop down menu and select Colour Range You can now set your colour ranges Note the following ranges may only apply in the case of Brgy Burgos Sablayan Occidental Mindoro e Next double click on each of the boxes adjacent to the ranges to apply our color scheme Hue 160 Saturation 240 e 1st Range Lumens 120 e 2nd Range Lumens 180 e 3rd Range Lumens 210 e 4th Range Lumens 240 Map Layer Properties Layer Style Text Legend 25 6 lt n lt 100 Min Max Delete Cancel Apply Help Building the CBMS Database and Poverty Mapping 14 Module 3 Training CBM f The following map will be displayed Map 3 Proportion of households without access to safe water by purok Brgy Burgos Sablayan Occidental Mindoro 2009 2011 NRDB Pro SABLAYAN secu File Edit Data Map Report Graph Window Help x slal alk QH rye of HHs without access to safe water Burgos E O0 lt n lt 7 E 7 lt n lt 14 BM 14 lt n lt 25 6 OO 25 6 lt n lt 100 Burgos SABLAYAN UNIVERSAL TRANSVERSE MERCATOR UTM Scale 1 177059 o COO 12 44 18 4 N 121 09 43 3 E Source CBMS Census 2009 2011 3 Household level Household dots or coordinates use the green and red color scheme Green represents posi
7. De La Salle Uniwersicy CRDI 3 IDRC AKI User s M anual for Building the CBM S Database and Poverty M apping October 2011 Prepared by the CBM S Network Coordinating Team Angelo King Institute for Economic and Business Studies This work was carried out by the PEP CBM S Network Coordinating Team with the financial support of the Government of Canada provided through the International Development Research Centre IDRC and the Canadian International Development Agency CIDA User s M anual for Building the CBM S Database and Poverty M apping I Introduction This tutorial contains illustrated steps in preparing the CBMS NRDB for mapping CBMS indicators Data encoded using the CSPro based encoding system was processed using the CBMS StatSim originally developed by the CBMS Network Coordinating Team The Statsim generates data with specified format ready for import into the CBMS Database A Poverty Mapping What is Poverty Mapping Poverty mapping is the spatial representation and analysis of wellbeing and poverty indicators As part of the CBMS Database LGUs are able to prepare poverty maps using CBMS data that can show data not just across provinces municipalities and villages but they are also able to show location of poor households B Data Structure for a Municipal CBMS Database The data structure of the CBMS NRDB was customized for the needs of the LGUs implementing CBMS This structure is hierarchical so relationship
8. RDB Pro StaElena esi Edit Data Map Report Graph Wi Mew ea al g te aa Save As a H Data Source Convert The Open dialog is displayed Select the MDB file NRDBUpdateTemp mdb in the folder C CBMSDatabase System Specs and click on Open Look in Specs ga aj g E Leh NR DBL IpdateTemp File name NADBUpdateT emp Open D Files of type All Supported Files r Cancel The Import dialog will be displayed Check the box adjacent to the following Features to be updated Household CBMS Demography Household CBMS Core Indicators Household CBMS Other Indicators Purok CBMS Demography Purok CBMS Core Indicators Purok CBMS Other Indicators Barangay CBMS Demography Barangay CBMS Core Indicators Barangay CBMS Other Indicators Municipal CBMS Demography Municipal CBMS Core Indicators Municipal CBMS Other Indicators Provincial CBMS Demography Provincial CBMS Core Indicators Provincial CBMS Other Indicators Building the CBMS Database and Poverty Mapping 2 Module 3 Training Click the button Import to continue Data Source fables 7 Tables to import De Select All h Household CEMS Demography h Household CEMS Core Indicators LW Household CEMS Other Indicators h Purok CEMS Demography h Purok CEMS Core Indicators v Cancel A Converting From Universal Transverse Mercator Projection to UNIVERSAL TRANSVERSE MERCATOR UTM Import Status Importing
9. ate Default date is the current date Click the button Next to start the importing data The data pou are importing contains no date Please enter the date to be associated with the data Date E008 Default is today s date Building the CBMS Database and Poverty Mapping 5 Module 3 Training 6 After all the data has been imported the Import Status window will appear Click on the button Save to save the imported file import Status Importing Number of records imported 130 After importing the data you are now ready to use the data for maps reports and graphs B Importing data not included in the NRDB import format 1 Repeat steps in IIl A 1 to 3 2 Select a specific table to be imported example import demographic data from the Brgy _Corelnd table then click the button Define The Select feature dialog will be displayed Click the pull down list and select the Feature where the table must be imported in this case Barangay CBMS Demography Click the button Select Import brgy Corelnd Select feature to import data into B arangay CEMS Demography Baraga name Date q Municipality name brqy_totmem Province name brqy_totmem_male Total Females bray_totmem_female Total households brgy_hhwmemO05 v Total Males v Import Auto match match Import Cancel Next gt gt 3 The Import Columns contains the names of the headings variable name found in the table from the MS Access
10. e As the objective in CBMS poverty mapping is to show the problematic areas as compared to adjacent provinces municipalities villages or subvillages the standard CBMS poverty maps are divided into 4 ranges To determine the ranges in mapping the CBMS Core Indicators 1 Know the regional provincial municipal barangay data 2 Sort the data from lowest to highest 3 To determine the cut offs the formula below Is used ist Range A o B Brgy data min 2 min 2nd Range C B D Brgy data 3rd Range E Brgy data F max Brgy data 2 Brgy data 4th Range GE H 100 a Minimum for first range is always zero 0 while the maximum for the fourth range is always 100 b Brgy data is the barangay data for the specific indicator This could be regional provincial or municipal data depending on the geopolitical level that you will map c Min and Max refer to the lowest and highest data D Color Scheme 1 Regional and provincial maps use a green and red color scheme Green colored areas represent data that are above the regional provincial municipal average Light Green is used in mapping data just above the regional provincial municipal average data while a darker shade of Green is used for data that is significantly above the regional provincial municipal average data On the other hand Pink and Red are used for data that are below and significantly below the average Below is an example of this scheme on mapping the Proportion of hou
11. e nri Click Open button The nri file is the NRDB import format that saves the matching of the Import Columns and Attributes added in the last window Look in E Specs ct Eg NROB_T m p rt Specs Cor B mri File name NADE Import pecs Core Files of type NADE Import Format Cancel When the user highlights a specific table and click the button Define the import columns and attributes that were matched would be displayed To go back to the previous table click Next Import brgy Corelnd Select feature to import data into Barangay CMS Core Indicators x Import columns Attributes of employed of employed Female of employed Male bray_totmerm of HHs living in non makeshift house brgy_totmem_male of HHs who are formal settlers bray_totmem_female of HHs with access to safe water bray_hhwmem05 of HHs with access to sanitary toilet Import Province gt gt Province name A Add Barangay gt gt Barangay name bray_MemO05 gt gt of members 0 5 brqy_Mem05_Male gt gt of members 0 5 Male Delete brqy_ Mem05_Female gt gt of members 0 5 Female brqy_Maln05 gt gt of malnourished children Auto match bray MalnO5 Male gt gt of malnourished children Male Y _ Auto match Import Cancel Next gt gt 5 A window will appear asking for the date When all the names have been matched the Import window below will appear asking for the user to encode the d
12. e water Click OK then Click Close to close the map layer window The map will be displayed Building the CBMS Database and Poverty Mapping 10 Module 3 Training B Map Layer Properties The Map Layer Properties has four tabs Layer For data with TYPE Number use Color Range while for TYPE Boolean and Text data use Separate Colour A space is provided so that the default description can be revised Map Layer Properties Layer Style Text Legend General Auto style Style Modify the Line and Fill Styles for polygons and symbols for coordinates dots Map Layer Properties Layer style Text Legend m Style r Colour Line Style Fill Style 7 Symbols Size i 5 Arrange overlapping symbols E Building the CBMS Database and Poverty Mapping Module 3 Training Ais LAY CBMS Text Select None from the pulldown list so that the labels will not appear in the map Map Layer Properties Layer Stule Text Legend Positions lt N one Style Allow overlaping text Zoom text 4 symbols E Legend Use Title lt Municipality gt CBMS for all maps Map Layer Properties Layer Style Text Legend Tithe Magdiwang CEMS Databaze Font Legend M Display layer name HH with no access to safe water C Single font for all legend entries Make font same as labels Source Font cael 11 C Color Rang
13. file The Attributes contains the attributes belonging to Barangay CBMS Demography as defined in the data dictionary of the database Building the CBMS Database and Poverty Mapping 6 Module 3 Training os N peuoner CBMS 4 Highlight the matching variables in the mport Columns and Attributes For example the variable brgy_toth his matched with the Total Households in the Attributes box Click the button Add to add the matched import column and attribute items to the mport box Import brgy_Corelnd Select feature to import data into os ee Import columns Attributes brgyid region province brqy_hhwmem05 brqy_hhwmem05_prop bray_hhwmemO05d brqy_t tihem_male gt gt Total Males brqy_t tihem_female gt gt Total Females Delete barandak gt gt Barangay name municip ity gt gt Municipality name Auto match bray_hhwmemO05d_ppyp Import 6thh gt gt Total households Add E Import Cancel Next gt gt The following variables correspond Import Columns Attributes O o Total Females Barangay name Municipality Municipality name 5 Click the button next and select the next table example Purok_Corelnd and click Purok CBMS Demography to import data into Repeat steps 1 4 with the following specifications Import Columns Attributes o Purok name Barangay Barangay name Municipalit Municipalities name Do the same for the other tables such as hh_Co
14. he style tab choose lt None gt in the Fill Style Click OK and click Close Here is the prepared poverty map on proportion of households without access to safe water supply in Brgy Burgos Sablayan Building the CBMS Database and Poverty Mapping 16 Module 3 Training Map 5 Proportion and location of households without access to safe water by purok Brgy Burgos Sablayan Occidental Mindoro 2009 2011 NRDB Pro SABLAYAN sce F File Edit Data Map Report Graph Window Help e x S aR qH am m HH with no access to safe water 0 With access to safe water Without access to safe water of HHs without access to safe water Burgos E O0 lt n lt 7 UNIVERSAL TRANSVERSE MERCATOR UTM Scale 1 166168 o gt Source CBMS Census 2009 201 1 The map layouts can be saved to avoid repetition of specifications in the properties of the map layers Save the layout as nrm file by clicking File Save As After closing the program the layout can be opened again using the saved nrm file V Copying the output map to other programs From the menu bar click Edit Copy to copy the map view Go to the desired program i e powerpoint file or word document and right click paste to paste the map To copy the map layer highlight that area and click Edit Copy and paste it to the desired file NRDB Pro Guiguinto CEMS File f Data Map Report Grap a al copy alal E Se
15. in the CBMS core indicators plus other supplemental indicators for each geopolitical level Here are the steps in importing CBMS data A Using NRDB import Format 1 From the File menu select Import File NRDB Pro StaElena mie Edit Data Map Report Graph Wi ts Mew J 2 3 Opena z Save s Mal Export H Data Source Convert 2 The Open dialog will be displayed Select the MS Access file Ind _NRDB mdb in the folder C CBMSDatabase System Output and click on Open fa c Ei File name Ind_NRDB mdb Files of type All Supported Files Cancel 3 The mport dialog will be displayed It would show all the tables contained in the file The dialog will initially check all the tables to prepare for importing Import Data Source T ables to import De Select All Fa Format Define Save hi purok_Corelnd Load lF tregn_Corelnd cos Building the CBMS Database and Poverty Mapping Module 3 Training writ Base Wei a K OQ N feuone CBMS Tables with common appendage Corelnd are generated by the Simulator ready for import into the CBMS NRDB This contains the data processed and outputted at the different geopolitical levels household purok barangay municipal and provincial 4 Click the Load button and browse the folder C CBMSDatabase System Specs and select the file NRDB_ImportSpecs_Cor
16. relnd import data into Household CBMS Demography Import Columns Attributes O O Municipality Municipalities name Barangay name Brgy _TotHH Total Households Brgy _TotMem Total Members Brgy _TotMale Total Males Brgy _TotFemale Total Females Building the CBMS Database and Poverty Mapping Module 3 Training mun_Corelnd import data into Municipal CBMS Demography Municipality Municipalities name Import Columns Attributes OOS O Mun_TotHH Total Households Mun _TotMem Total Members Mun _TotMale Total Males Mun _TotFemale Total Females 6 After all the needed variables have been correctly matched the user has the option to save the import specifications as NRDB Import Format nri To do this click the button Next gt gt in the Import window and another Import window will appear Click the button Save Save as NRDB_ImportSpecs_Demog nri in the folder C CBMSDatabase System Specs Save fs Save ini E Specs d c Ej zA NRDE_Importspecs_Core nri File name MADE lmportS pecs Save as type NRDE Inport Format Cancel Note NRDB Import Specifications support multiple feature table specification hence a demography import specification can handle matching of columns for household purok etc To call the import format in future activities click on Load to get the import format 7 Click the button Import to start the import process If all the
17. seholds without access to safe water for Province of Occidental Mindoro The provincial average for this indicator is 17 8 Map 1 Proportion of households without access to safe water by municipality 2009 2011 E 29 100 N Source CBMS Census 2009 201 1 Building the CBMS Database and Poverty Mapping 12 Module 3 Training a INS CBMS For this example the provincial average is used to distinguish between shades of green or red In this example the ranges used are MA sy 2 Significantly below average 7 L m nH T m E T L E E EE E n an E o 12 1 ima 12 2 17 8 __ 17 9 28 9 B 29 100 N Source CBMS Census 2009 2011 The same color scheme is used at the municipal and barangay levels using available data 2 Purok level At the purok level a different color scheme is used Shades of blue color scheme is used in mapping purok level indicators Four shades of blue are used to differentiate data at the purok levels The darker the shade of blue the better the performance of the purok Building the CBMS Database and Poverty Mapping 13 Module 3 Training Map Layer Properties sule Text Legend Courres F E osen lt 7 P lt en lt 14 C J14 lt n lt 25 6 25 6 lt n lt 100 To specify the color scheme a Select the Layer tab click on the drop down menu and select Colour Range b Follow the steps discussed earlier in determining the
18. tive response for a particular indicator while red denotes the negative An example of an indicator is shown below To map the CBMS core indicators at the household level here are the steps a Add another layer with the following specifications i Under Feature select Household CBMS Core Indicators ll Under Name select only the Household IDs in the barangay currently being used iii Under Display select Household Location coordinates iv Under Label select HH with no access to safe water b Click OK The following map will now be displayed Map 4 Proportion and location of households without access to safe water by purok Brgy Burgos Sablayan Occidental Mindoro 2009 2011 NRDB Pro SABLAYAN Po eee H File Edit Data Map Report Graph Window Help ox sa S alal anju o HH with no access to safe water 000000 of HHs without access to safe water Burgos lt 7 Burgos SABLAYAN UNIVERSAL TRANSVERSE MERCATOR UTM Scale 1 276851 4 12 K m With access 6 With access to a ite g ae a Up A With access to safe ws S Pater FA ari With access to sai With access to safe water With access to safe water Source CBMS Census 2009 2011 Building the CBMS Database and Poverty Mapping 15 Module 3 Training c Double click on the map layer HH with no access to safe water and the map layer properties will now be displayed d Goto the Text tab click on the drop down men
19. u and select None Click OK e In order to show which households have access to safe water and which ones have no access we will adopt another color scheme e Green Dots e will represent households with access to safe water while e Red Dots e will represent households without access to safe water f The properties of the map layer will now be displayed Select the Layer tab and then select Separate Style g Next double click on the dot adjacent to the text With access to safe water Under Fill Style select the green color Click OK The following map will now be displayed Map Layer Properties Layer Style Text Legend General Auto Style o o Without access to safe water With access to safe water Style Scheme x gt h Double click on the dot adjacent to the text Without access to safe water Under Fill Style select the red color To emphasize the location of the households increase the size of the household dots to 3 BEIT Mo IBN IIIB BB E EE ESSEEN EE LJ Style Style Colour Basic colors Line Style lA el eee tet tT es EN BEE EES E EEE ee EEE ee iN Fill Style Symbols i Arrange overlapping symbols Define Custom Colors gt gt Cancel i Inthe Text tab choose lt None gt to remove the labels in the map then click OK and click Close j To show the name of the purok add another layer Purok In t
Download Pdf Manuals
Related Search