Week8 - Proportional Maps - Wine Consumption

Representing proportional information on a map just touches the surface of the actual data which it attempts to convey.  This form of mapping can be used to deceive in numerous ways. The maker is limited to the number of symbols the map can hold. Symbol placement is nearly arbitrary. It best used for generalizations.       How many liters were poured. According to the Wine Institute in the European Region I, for 2006, actual data shows as little as 16 in San Marino & as much as 3.4 million in France.

PART III: Process Summary Description

1)      Read Lab instructions through. Chose to obtain data first, used excel conversion that fellow student Andranio Baptista graciously converted from pdf to excel for us.  Thank you so much. Made remaining conversion edits as needed. Opened up wine2012.xls, labeled fields:2006_xls; Sq_rt; symbol_sz.

2)      Populated wine2012 with 2006 liter data, first created formula for sqrt, autofilled values. Sorted sqrt ascending with 16 as smallest value,  1842.53 as largest. Next created absolute scaling method by square root for values of my circle sizes.  Printed out results sorting by symbol size.

3)      Grouped data into classes by hand using natural breaks. Had seven divisions, narrowed to 5.

4)      Downloaded into new map  w_rldwinEuropean_Region. Made copy of base map for safekeeping. Saved as s:\week8_proportional-wine\proportional\ww-copy of worldwine consumption.

5)      Chose Mercator (world).prj for new projection.  Used arctools>data > management>projections>feature>project>select>projection coordinate system>world>Mercator (world)>

6)      Saved new map as wine_wgsworldmer. Closed arc, reopened new map added data new projected map  saved as

S:\week8_proportional_wine\proportional\wine_wgsworld.mxd.

7)      Printed out alphabetized list of Region I countries. Used this list with attribute table of new map to select countries. Made new layer of Region I list. (Did data>export>GCS same as layer. Named layer wine_countries. Did same with non-region countries, created separate layer for them named, Non_RegionI.  Created layer for countries with no data to show them in separate color.

8)      Determined base color for Region countries.  Created inset map for enlarged area to be used for proportional symbol placement.

9)      Added legend  for countries. Added basic essential elements.  Saved copy of map as wine_wgsworld1.mxd before exporting to Illustrator. Made sure that country labels were activated before moving map.

10)   Now in Illustrator.   Saved copy of La:  

a)      Layer 1- Data covers 16-7000 liters – use 0.04 inch circle, use 3000 as legend definition- 12 dots

b)      Layer 2- Data covers  10,400- 26,500 liters – use 0.10 inch circle, use 26,000 as definition – 10 dots

c)       Layer 3- Data covers 51,600- 86,900 liters – use 0.15 inch circle, use 55,000 as definition – 8 dots

d)      Layer 4- Data covers 118,000-470,000 liters- use 0.34 in circle, use 300,000 as definition – 12 dots

e)      Layer 5- Data covers 1,060,000 – 113,658,000 use 0.68 in circle, use 1 Million as definition – 3 dots

f)        Layer 6- Data covers 2,733,200-3,394,900 use 1.15 in circle, use 3.4 Million as definition 2 dots.

11)   Locked unnecessary layers, for each layer, turned on name labels of country for each country in layer.  With the ellipse tool, added circle to map in each labeled country. Sized circle with dialog. Chose a base color for the circles.

12)   Placed circles in best location for each layer. Turned off circles to keep one layer of circles visible at a time until all layers on map.    Grouped each circle size together.  Added one of each size to circle legend.   After each layer had their circles, I turned on all to see where overlaps occurred.  Used transparency to adjust as needed to insure each size of circle was visible.

13)   Added index to circle legend and adjusted items as needed.  Final map saved as s:\Cartography..\Week8Cart_wine_wgsworld.