1. Open the file BI04.xls located at C:\CLUP_TRAINING_DATA\00_BI\02_Demography\Tables\.
Notice the three tabs located at the bottom of your worksheet. They are:
- Be sure that GIStable tab is selected when we open the file. (See above image)
Your worksheet heading should look similar to the image below.
2. Next, open the file BrgyPop.xls located at C:\CLUP_TRAINING_DATA\00_BI\02_Demography\Tables\.
3. From this worksheet, highlight the data entries of field BRGY_ID, which is Barangay ID. Click Edit from the menu and then select Copy from dropdown menu.
(See image below)
4. Switch back to workbook BI04 by clicking the button, located at the bottom of your worksheet.
(See adjacent image)
5. Be sure to place the cursor in the second row of column B_ID, as shown in the image. Click Edit from the menu bar, then select Paste or press Enter.
6. Repeat Steps 3 and 4 to copy and paste the data entries of the following:
- BRGY NAME - B_NM
TOTAL POPULATION - B_POP_00
NO. OF HOUSEHOLDS - B_NO_HH
DENSITY - B_POPDEN
In the case of the field DENSITY in worksheet BrgyPop.xls, wherein the values are generated by formula, perform the following tasks otherwise it will display a different value in the target worksheet.
6.1 From worksheet BrgyPop.xls, highlight the data entries of field DENSITY. Click Edit from the menu then select Copy from dropdown menu.
(See image below)
6.2 Repeat Step 4. Place the cursor in the second row of column B_POPDEN, as shown in the image, then right click. Select Paste Special… from dropdown menu.
6.3 A Paste Special window will appear. Select the radio button of “Values”. Then, click OK button.
7. When you are done, save it to dbf format by highlighting the worksheet, as shown in the image. Click File from the menu then select Save As…
8. From Save As window, browse to the folder in Save in: list menu where you want to place the file, then type appropriate filename in the File name: list menu.
(e.g. BrgyPop_Dense) Select DBF 4 (dBASE IV) in the Save as type: list menu. (See image below)
- Click Save button. Then click OK and Yes respectively for the next two alert boxes that will appear.
9. Exit Excel.
10. Open ArcMap. A pop up window with three options will appear. They are:
- A new empty map
A template
An existing map
By default, A new empty map is selected. Click OK.
11. Select File from the menu, then choose Save As. . . from drop down menu.
12. From Save As window, click the Save in: list menu to browse to the folder where you want to place the file. Type appropriate file name (e.g. BrgyPop_Density) in File name: list menu. Then select ArcMap Documents in the Save as type: list menu.
- Click Save button.
13. Next, click File from the menu bar, then select Add Data in dropdown menu to add the layer bndbgy_pgon located at C:\Training\PopDensity\Shapefiles.
- Or click the icon Add Data in the toolbars menu. (See image below)
14. From Add Data window, click Look in: list menu then browse to the folder where the file is located. Click the layer to select, then click Add button to add the layer in your workspace.
15. In the Table of Contents, click to highlight the layer. Right click and select Label Features.
- Then, click to highlight the same layer. This time select Convert Labels to Annotation…
16. In Convert Labels to Annotation window, just select In the map option.
- Click Convert button.
17. Repeat Steps 13 & 14 to add a dbf file (BrgyPop_Dense.dbf) in the Table of Contents located in C:\Training\PopDensity\Tables.
18. In Table of Contents, click the dbf file to select, then right click. Choose Open in the pop up menu to open the table in Arcmap.
(See image)
19. Repeat step 18 to open the attribute table of the layer file (bndbgy_pgon). This time select Open Attribute Table in pop up menu, as shown in the image,
By comparing the two tables, they have an identical column in terms of data entries which are unique to both of them. They are BRGY_ID and B_ID fields respectively which are Barangay ID. (See image below)
20. Close both the tables. In the Table of Contents, click the bndbgy_pgon to select. Right click and select Joins and Relates then Join. . . respectively.
21. A Join Data window appears. Select Join attributes from a table in the first list menu. For the other numbered list menus (1-3), select the ff:
- 1. BRGY_ID
2. BrgyPop_Dense
3. B_ID
Click OK.
You will notice that nothing happens after you click the OK button. But when you open the attribute table of the layer, you see a lot of strangely named columns which is difficult to interpret due to the joining process.
22. The next step is to rename the layer. In the Table of Contents, click the layer to select, then right click. Choose Properties in the dropdown menu.
23. In Layer Properties window, select General tab. Type to rename the layer
(e.g. Population Density By Barangay) under Layer Name: box, as shown in the image below.
Don’t click Apply or OK yet!
24. In the same window, select Fields tab. You will now choose which fields will be visible and assign a proper alias to them, and which fields should be hidden, by simply clicking the checked box to uncheck it.
- To assign a proper alias to the field, simply click once over the field to select. Then, type to rename it (e.g. Barangay ID). (Refer to image below)
The following fields that should be selected and assigned proper alias are:
- bndbgy_pgon.BRGY_ID - Barangay ID
bndbgy_pgon.NAME - Barangay Name
BrgyPop_Dense.B_POP_00 - Population
BrgyPop_Dense.B_NO_HH - No. of Households
BrgyPop_Dense.B_POPDEN - Population Density
- Click Apply, then OK.
After cleaning and improving the joined table, the result should like this:
25. Close or minimize the attribute table.
The next step is to change the symbol of the layer “Population Density By Barangay” for a better presentation.
26. Right click the layer in the Table of Contents, then select Properties in dropdown menu.
27. From Layer Properties window, select Symbology tab. Then, do the following selection as shown in the image below:
- a. Select Graduated colors under “Quantities”
b. Choose Population Density from the list under “Value:”
c. Choose 3 from the list under “Classes:”
d. Click Classify button.
7.3.5 Step 27
28. A Classification window will appear. Click to mark a check under “Show Mean”.
Notice the dashed gray line that will appear which is the “Mean”. Click OK.
(Refer to image below)
29. Finally, click Apply and OK button when the Layer Properties window appears.
[listIf your workspace looks similar to the image below, you have done it successfully.
Congratulations!
Don’t forget to save your effort.