Problem: Create a map that shows the distribution of the Hispanic population by county in North Carolina based on 1990 Census data. Procedure Log: Data: ArcView Shapefile provided by the NCSU Libraries GIS Data Collection CNTY_SHP.SHP, CNTY_SHP.SHX - Shapefiles of NC Counties (polygon) Dbase file provided by the NCSU Libraries GIS Data Collection CNTY_SHP.DBF - Database File pertaining to CNTY_SHP.SHP (database) NCBASIC.DBF - Database File of Census data for NC Counties (database) Map units for all shapefiles: Decimal Degrees Use Open Attribute Table to add a field named "HisPOP" to the NC Census Database which will contain converted values from the based on a ratio of the Total Hispanic Population to each county's Total County Population: Target layer: NCBASIC.DBF Method: Click the "Options" Icon Selection Option: Add Field Method: Enter "HisPOP" as the name of the Field Selection option: Float Result: New field added named "HisPOP" (precision and scale are preset to '0') Method: Right-click the "HisPOP" field Selection option: Calculate values Selection expression: [TOTALHISP] / [PERSONS] *100 Method: Click "OK" Result: "HisPOP" field is created with the percentage of Hispanics in each NC County. Use Joins and Relates to join the NC Census Database to the Map of North Carolina Counties: Method: Join attributes from a table Target layer: CNTY_SHP.SHP Method: Choose the field that the join will be based on Selection option: CNTY Method: Choose the table to join this layer Selector layer: NCBASIC.DBF Method: Choose the field in the table to base the join in Selection option: COUNTY_AV Method: Click the OK icon. Result: The NC Census Database (NCBASIC.DBF) is joined to the Map of North Carolina Counties (CNTY_SHP.SHP). Use the Layer Properties dialog to display the percent of Hispanic population across NC Counties in 3 categories using a Red-Green Color Ramp and 3 set "break values": Target layer: CNTY_SHP.shp Selection option: Symbology Tab Selection option: Categories-->Unique Values Method: Right-click Color Ramp Selection option: Properties Method: Left-click 1st Algorithmic Color Ramp Selection option: Color 1 = White Color 2 = Red Algorithm = CIE Lab Click the "OK" Icon Method: Left-Click 2nd Algorithmic Color Ramp Selection option: Color 1 = Red Color 2 = Green Algorithm = CIE Lab Click the "OK" Icon Method: Save the color ramp style by right-clicking on the color ramp Save the color ramp style with the name "whiteredgreen scheme (1)" Method: Value fields Selection option: NCBASIC.HisPOP Method: Click the "Add All Values" icon Selection option: Quantities-->Graduated Colors Method: Values Selection option: NCBASIC.HisPOP Method: Classes Selection option: 3 Method: Click the "Classify" icon. Click on each of the "break values" and set them to 1.0, 2.5 and 5.5, respectively. Click "OK" Method: Click the "Apply" icon. Result: The map scale is set to display the Hispanic population across NC Counties in 3 categories on the map of NC Counties with 3 set "break values". (Don't have to include the steps for creating the layout view in this procedure log.) Use the Open Dialog to find the Mean Total Population of the 5 NC Counties with the lowest total population in 1990: Target layer: NCBASIC.DBF Method: Right-click the top button that is labeled the name of the field "PERSONS". Selection option: Sort Ascending Method: Select the top 5 records of the field named "PERSONS" (by Ctl + Left Click) (FID = 14, 21, 37, 47, 88) Click the "Selected" Icon Right-click the top button in the field named "PERSONS" Selection option: Statistics Method: The Mean Total Population with the 5 NC Counties is located after the "Mean: " string Result: The Mean is 5904.40 Persons (Clear Selection for the NCBASIC.DBF layer before proceeding.) Use the Open Attribute Table to find the Mean Percent Hispanic Population of NC Counties with a 1990 total population greater than 100,000: Target layer: NCBASIC.DBF Method: Click the top button that is labeled the name of the field "PERSONS". Click the "Options" icon Selection option: Select by Attributes Selection option: Create a new selection Selection expression: "PERSONS" > 100000 Result: 18 records were selected from the NCBASIC.DBF Method: Click the "Selected" Icon Right-click the top button in the field named "HisPOP" Selection option: Statistics Method: The Mean Percent Hispanic Population of NC Counties with a 1990 total population greater than 100000 is 1.308528%. (Clear Selection for the NCBASIC.DBF layer before proceeding.) Use Select by Location to select Duplin County and the bordering counties: Target layer: CNTY_SHP.SHP Method: Click the record for Duplin County (CNTY_SHP.FID: 30) Choose Select by Location by Clicking Selection on the Menu Bar Selection option: Add to the currently selected features in Target layer: CNTY_SHP.SHP Selection option: that share a line segment with Selection layer: CNTY_SHP.SHP Result: 7 records selected from CNTY_SHP.SHP Use the Open Attribute Table to find the 1990 mean percent Hispanic Population of Duplin County and bordering counties: Target layer: CNTY_SHP.SHP Method: Click the "Selected" Icon Right-click the top button in the field named "NCBASIC.HisPOP" Selection option: Statistics Method: The Mean Percent Hispanic Population of NC Counties with a 1990 total population greater than 100000 is 1.864347%. Use Select by Attributes to find NC Counties with a Total Population greater than 75,000 and a total Hispanic population less than 1,000 in 1990: Target layer: NCBASIC.DBF Selection option: Create a new selection Selection expression: "PERSONS" > 75000 AND "TOTALHISP" < 1000 Result: 16 records selected from NCBASIC.DBF Use Select by Location to select Wake County and counties where at least part of it falls within 40 kilometers of Wake County: Target layer: CNTY_SHP.SHP Method: Click the record for Wake County (CNTY_SHP.FID: 92) Choose Select by Location by Clicking Selection on the Menu Bar Selection option: Add to the currently selected features in Target layer: CNTY_SHP.SHP Selection option: are within a distance of Selection layer: CNTY_SHP.SHP Method: Enter 40.0 Kilometers as the Buffer Result: 19 records selected from CNTY_SHP.SHP