Loading presentation...

Present Remotely

Send the link below via email or IM


Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.


Poverty Mapping

No description

Steffie Insigne

on 11 June 2017

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Poverty Mapping

Joining Layers
Loading Shapefiles
To transfer the processed data from CBMS StatSim Pro 6.0 into the CBMS-QGIS, follow these steps:
Importing Data from the StatSim into QGIS
Poverty Mapping
Poverty mapping is the spatial representation and analysis of well-being and poverty indicators
Poverty maps are powerful tools for presenting complex information in a visual format that can be easily understood by policy makers and stakeholders
As part of the Community-Based Monitoring System (CBMS), local government units (LGUs) are able to prepare poverty maps of CBMS data using the Quantum Geographic Information System (QGIS)
These maps show detailed data pertaining to the welfare of individuals in provinces, municipalities, villages, and even the location of poor households
The CBMS StatSim Pro 6.0 generates different tables that are ready for importing into a mapping software such as the QGIS
The tables contain CBMS data that have been processed and consolidated at all available geopolitical levels
When exported from Statsim 6, separate tables in comma-separated format (.csv) are created for each geopolitical level
The exported data containing the core indicators are stored automatically in:
See sample exported data in mun_coreind.csv, brgy_coreind.csv, purok_coreind.csv and hh_coreind.csv.
For easy file management, all data to be imported into QGIS should be saved in the data folder CBMS-QGIS found under the municipal or provincial folder following the Philippine Standard Geographical Code (PSGC)
Export the data. Go to C:\CBMSDatabase\System\Output and copy the exported core indicators data. See screen view sample below:
Go to the municipal folder for El Nido, Palawan. Following the PSGC, the file path would be C:\CBMSDatabase\17\53\12\CBMS-QGIS. Paste the core indicators data under the folder Data. Figure below shows a screen view sample:
Load the CBMS data as a layer in QGIS by following these steps:
In the Layer menu, select Add Delimited Text Layer or click the shortcut icon on the left side of the screen
In the Delimited text dialog box, click
Browse beside the File Name field and
select the file to be imported. Open the core indicators data for El Nido, Palawan in C:\CBMSDatabase\17\53\12\CBMS-QGIS\Data. For example, see below to open the barangay level core indicator data with file name brgy_coreind.csv
In the dialog box, select CSV as file format and No geometry (attribute table only) under Geometry definition, then click OK
To transfer the processed data from CBMS StatSim Pro 6.0 into the CBMS-QGIS, follow these steps (con't):
Note that the layer has been added to the map.
The delimited text file now behaves like any
other map layer in QGIS. To check that data
were loaded properly, right click on the brgy_
coreind layer and select Open Attribute Table.
Ensure that all data in the brgy_coreind.csv
are found in the attribute table. Follow steps 1
to 4 when importing data for other geopolitical
levels such as mun_coreind.csv or purok_
coreind.csv. Figure below shows a sample screen view.
For LGUs using the CBMS APP track, global positioning system (GPS) data such as location of households are included in the household-level data exported from StatsimPro 6.0
To import or load CBMS data with geopoints into QGIS, follow these steps:
Follow Steps 1 and 2. Open the household level core indicator data for Barangay 76 in Pasay City with file name hh_coreind.csv located in C:\CBMSDatabase 13\76\05\CBMS-QGIS. See sample screen view below:
In the dialog box, select CSV as file format. Under Geometry definition, select Point coordinates. Note that the X and Y fields are defined automatically. Click OK. See figure below:
In the Coordinate Reference System (CRS) Selector window, select WGS 84 (the most commonly used) from the list of CRS supported by QGIS. Click OK. See Figure 9.
Note that the layer is added to the list of layers and household locations are displayed in the map.
After loading the barangay core data, load the shapefile of all barangays in El Nido, Palawan by following these steps:
Click Layer and select Add Vector Layer, or
click on the icon on the right side of the
In the Add Vector Layer dialog box, select File and click Browse. Open the barangay shapefile for El Nido, Palawan in C:\CBMSDatabase\17\53\12\CBMS-QGIS\Shapefiles. See Figure below:
Click Open to load the shapefile into QGIS
In the Coordinate Reference System (CRS) Selector window, select WGS 84 (the commonly used system) from the list of CRS supported by QGIS. Click OK. Note that the barangay shapefile for El Nido, Palawan shows in the map
At this stage, two layers have been loaded: one layer contains the CBMS data in tabular form and the other layer is a shapefile containing the barangay
To generate the poverty maps, the CBMS data need to be merged with the shapefile containing the barangay boundaries using the Join Layer feature in QGIS
Before joining the layers, ensure that both the data and the shapefile share a field or column with matching values (in the same format such as a string or integer).
This could be a name or a code, and should be unique (one row per name or ID)
In the example in the next figure, the unique identifier is the Barangay ID or Barangay PSGC
To join the layers, follow these steps:
Right click on the barangay shapefile layer and select Properties to open the Layer Properties dialog box
Go to the Joins tab and click + to add a join
In the Add Vector Join dialog box, define the following as key columns
Join Layer – the layer to be linked with the target layer
Join Field – the unique identifier from the tabular data
Target Field – the unique identifier that will link the tabular data to the shapefile
In the example below, the Join Layer is brgy_coreind. The Join Field is brgyid and the Target field is BrgyPSGC. Click OK to accept the settings, then OK to create the Join
Joining Layers
Open the Shapefile attribute table to check that the two layers have been properly joined. Notice that the table now contains additional fields (see figure below). Join works by adding fields from the data table to the shapefile’s attribute table based on matching values found in the key columns.
Note that this join is temporary. To permanently save the joined shapefile, right click on the joined shapefile and click Save As
In the Save Vector Layer dialog box, select ESRI shapefile in the Format field, and Layer CRS in the CRS field. Click Browse beside Save As. Select the folder where the new shapefile will be saved. Enter the file name and click Save. Click OK. See screen view below
Thank you!!!
Partnership for Economic Policy (PEP) Asia
Community-based Monitoring System (CBMS) Network Office
DLSU 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 or 5238888 loc. 274
Fax Number: (632) 5262067
Website: http://pep-net.org
Email: cbms.network@gmail.com
Facebook Page: http://facebook.com/CBMSPhilippines
Facebook Interactive Group: https://www.facebook.com/groups/CBMSNetwork/

Loading shapefiles stored in spatialite database
If Spatialite Database is available, follow these steps to load the shapefiles:
1. Click Layer > Add Layer and select Add Spatialite Layer, or click on the icon on the right side of the screen
Loading shapefiles stored in spatialite database
2. In the Add Spatialite Layer dialog box, select New and click Browse. Open the spatailite database for El Nido, Palawan in C:\CBMSDatabase\17\53\12\CBMS-QGIS\Spatialite. See Figure below:

Loading shapefiles stored in spatialite database
3. Click Open to load the spatialite into QGIS
Loading shapefiles stored in spatialite database
4. Click connect. Different geopolitical levels will be shown under the table columns where the shapefiles for each geopolitical level are stored. Select the desired level. For our example, select barangay. Then click Add.
Loading shapefiles stored in spatialite database
Full transcript