Quiz 2 - Reviewing ArcGIS

Note: I got nitpicky and changed my color scheme to differentiate things better.


Part I [62 points]

1. Rank the order the ten most populous countries of the world. [6 points]

Go to ‘Select by Attributes’ > Layer: 'cntry02' > Choose 'POP_CNTRY' > Create expression “POP_CNTRY” >= 97228750 (because this is the 10th highest number) > Open Attribute Table for ‘cntry02’ > Show selected >Then ‘Sort Descending’ for 'POP_CNTRY'

ANSWER:

1)      China

2)      India

3)      United States

4)      Indonesia

5)      Russia

6)      Brazil

7)      Pakistan

8)      Japan

9)      Bangladesh

10)   Nigeria

2. How many rivers does the Amazon River System consist of? [6 points]

Go to ‘Select by Attributes’ > Layer: ‘rivers’ > Choose ‘SYSTEM’ > Create expression "SYSTEM" = 'Amazon' > Open Attribute Table for ‘rivers’ > Show Selected > Count

ANSWER: 15 Rivers

3. How many cities are within 500km of the Amu Darya and Syr Darya rivers? Attach a screen shot of a table for these cities. [8 points]

Go to 'Select by Attributes' for 'Amu Darya' > ‘Select by Location’ > Select features from: 'cities' > Source layer: 'rivers' > Check ‘Use selected features’ > ‘Target layer(s) have their centroid in the source layer feature’ > Check ‘Apply search distance of’ > Put ‘500’ and scroll down to ‘km’ > Open Attribute Table for ‘rivers’ > Choose selected > Do the same for 'Syr Darya'

ANSWER for Amu Darya: 52 (can see 52 out of 2533 selected on the attribute table)

ANSWER for Syr Darya: 37 (can see 37 out of 2533 selected on the attribute table)

4. To the nearest 100,000 what is the total population of countries within 300 kilometers of Iran (not including Iran)? [8 points]

Go to ‘Select by Attribute’ to find 'Iran' > ‘Select by Location’ to have countries that are ‘within the distance of’ 300 km from Iran > Open Attribute Table for 'cntry02' > Show Selected > Unselect 'Iran' > Use Statistics to see 'Sum'

I got 2 different answers for this because the ‘Select by Location’ tool would sometimes change the selected areas depending on whether “Ok” or “Apply” were clicked first. The first time I did it, the selection included a lot of countries in Europe and Africa. The second time I went through the procedure, the selection excluded many of these countries.

First ANSWER: exact number is 3,356,737,001 and rounded is 3,356,700,000

Second ANSWER: exact number is 452,297,220 and rounded is 452,300,000

5. Identify the most and least populous countries of the landlocked countries of the world. [6 points]

Go to 'Select by Attributess > Create expression "LANDLOCKED" = 'Y' > For Most: Sort Descending, For Least: Sort Ascending

ANSWER for MOST populous landlocked country: Ethiopia

 

ANSWER for LEAST populous landlocked country: Vatican City

6. Identify all countries within 300 kilometers of Veszprem, Hungary (not including Hungary). [10 points]

Go to ‘Select by Attributes’ to find 'Veszprem' > ‘Select by Location’ to find all countries within the distance of 300 km > Unselect Hungary from the list

ANSWER:

1)      Austria

2)      Bosnia & Herzegovina

3)      Croatia

4)      Czech Republic

5)      Poland

6)      Romania

7)      Slovakia

8)      Slovenia

9)      Yugoslavia

7. What countries border Chad? [8 points]

Go to ‘Select by Attributes’ to find 'Chad' > ‘Select by Location’ to find all countries 'touching the boundary' of 'Chad' > Open Attribute Table for 'cntry02'

ANSWER:

1)      Cameroon

2)      Central African Republic

3)      Libya

4)      Niger

5)      Nigeria

6)      Sudan

8. Rank order of the five countries that have the most cities based upon the data. And what is the city number for each? [10 points]

Using ArcToolbox to go ‘Analyst Tools’ > ‘Statistics’ > ‘Frequency’ > Input: ‘cities’ > Open Attribute Table

ANSWER:

1)      Russia (97)

2)      United States (93)

3)      Thailand (72)

4)      Turkey (67)

5)      Cote d'Ivory and Poland (tied at 50)

Part II [38 points + 5 bonus points]

9. Approximate the total length (km) of all river portions /segments flowing in the country of Sudan? [8 points]

Using ‘Draw’ tool > Trace the rivers within Sudan > View ‘Properties’ > View ‘Length’ > Add the total of the km together > 2023.5 + 1621 + 148 = 3792.5

ANSWER: 3792.5 km

OR Using ‘Measure’ tool > Trace the rivers within Sudan > Add the total of the km together > 2837 + 321.6 + 613.8 = 3772.4

ANSWER: 3772.4 km

10. Rank order of the five countries that have the most lakes in terms of number. And what is the lake number for each of the five countries? [10 points]

Using ArcToolbox to go ‘Analyst Tools’ > ‘Statistics’ > ‘Frequency’ > Input: ‘lakes’ > Open Attribute Table

ANSWER:

1)      Russia (1,516)

2)      Canada (1,340)

3)      United States (743)

4)      China (219)

5)      Sweden (168)

11. Rank order of the five countries that have the most lakes in terms of area. And what is the total lake area (square km) for each of the five countries? [10 points]

Open the Attribute Table for ‘lakes’ > Add Field: ‘AREA’ > ‘Calculate Geometry’ > Go to ‘Geoprocessing’ > ‘Dissolve’ > Input: ‘lakes’ > Output:’ dissolve_lakes’ > Dissolve_Field(s): ‘CNTRY_NAME’ > Open the Attribute Table for ‘dissolve_lakes’ > Add Field: ‘AREA’ > ‘Calculate Geometry’ > Under ‘AREA’ choose ‘Sort Descending’

ANSWER:

1)      Canada (443,517)

2)      United States (196,849)

3)      Russia (138,251)

4)      Kazakhstan (70,900)

5)      United Republic of Tanzania (53,530)

12. Produce the following map: a world country map of lake area per capita (area of lake surface per person). [15 points]

Open the Attribute Table for ‘dissolve_lakes’ > ‘Join and Relates’ > ‘Join..’ > Join ‘cntry02’ by ‘CNTRY_NAME’ > ‘Add Field’ > Type ‘AREA_PP’ > Choose ‘Float’ > Click on the new column and choose ‘Field Calculator’ > Create the expression [dissolve_lakes.AREA] / [cntry02.POP_CNTRY] > Under ‘AREA_PP’ choose ‘Sort Descending’ > Change the Symbology

Some information during the join did not relate and was presented as 'Null', therefore some countries are not displayed on the map. Here is my process/ANSWER: