...

1. In the Contents pane, right-click the US_States layer and select Remove.
2. Right-click the US_States_WithCityCounts and select Symbology.
3. In the Symbology pane, in the Symbology drop-down menu, select Graduated Colors.
4. In the ‘Fields’ drop-down menu, select the Join_Count field.

You can now easily tell which states have the largest number of participating cities, though this display does not take into consideration things such as city density and population density or the percentage of the total state population participating.

1. On the toolbar at the top of the Map Window, click Save.
2. Close ArcGIS Pro.

Optional Exercise: Converting Addresses to XY Coordinates

...

1. Under ‘3. Geocode simple tabular data’, click the link to the text/GPX conversion utility.
2. Return to the Excel spreadsheet.
3. Click the Select All button in the top left corner of the spreadsheet.

...

1. Return to GPSVisualizer.
2. In the ‘Or paste your data here:’ box, delete all existing text.
3. Right-click in the ‘Or paste your data here:’ box and select Paste to copy in the city data from your Excel worksheet.
4. Click Convert.

Once the website is finished geocoding your cities, the latitudes and longitudes will be displayed.

...

1. At the bottom of the worksheet click the Insert Worksheet button.

1. Click the Data tab.
2. Under the ‘Get External Data’ section, click From Text.
3. Navigate to select your saved LatLongMayors text file (Desktop > XYTutorialData > LatLongMayors) and click Import.
4. In the ‘Text ImportWizard’ window, ensure that Delimited is selected and click Next >.

A delimiter is simply a character, such as a tab, space, or comma that tells Excel when to move the text into the next column.

1. In the ‘Delimiters’ box, ensure that Tab is checked and that the column break lines appear in the correct locations in the ‘Data preview’ box, as shown below, and click Next >.

1. Click Finish.
2. In the Import Data window, click OK.

You could now delete any unnecessary columns and save this Excel worksheet to map the XY coordinates just like you did in the first exercise.

...

1. On the desktop, double-click the XY folder.
2. Double-click Flower Garden Banks NMS Buoy Locations to open the file with Excel.

...

1. Ensure that the break lines in the ‘Data preview’ box are placed like those shown below and click Next >.

1. In the ‘Data preview’ box, click the second column containing the apostrophes to select it.
2. In the ‘Column data format’ box, select Do not import column (skip).

1. Repeat steps 7 and 8 with the fourth column containing the quotation marks and the fifth column containing the letter W.
2. Click Finish.

...