...

...

1. On the Desktop, double-click the Computer icon > gisdata This PC > GISData (\\file-rnassmb.rdf.rice.edu\research\FondrenGDC) (RO:) >  > GDCTraining > 1_Short_Courses > > Mapping_XY_Data.
2. To create a personal copy of the tutorial data, drag the XY folder onto the Desktop.
3. Close all windows.

...

This Excel worksheet provides a list of cities whose mayors signed the U.S. Conference of Mayors Climate Protection Agreement as of September 12, 2011. This list was obtained from the Climate Protection Center website at http://www.usmayors.org/climateprotection/list.asp. Notice that the worksheet also contains the latitude and longitude of the cities in decimal degrees.

1. Close Excel.

...

Creating XY Data Feature Class

Now that you have examined the tabular data in Excel, it is time to display the XY data of city locations on a map.

...

1. In the Catalog pane, right-click the Sheet1$ worksheet table and select Add To New Map.
2. In the Contents pane on the left, right-click the Sheet1$ standalone table, hover over Create Points From Table, and selectDisplay XY DataTable to Point.

The Geoprocessing pane should open on the right in a new tab overlaying the Catalog pane. In the 'Make XY Event Layer' tool, notice that 'XY A new pop-up should appear titled XY Table To Point. Notice that 'Input Table' is already set to the the Sheet1$ table, since that was the table used to open the tool.

1. For ‘Output Feature Class’, rename the feature class from Sheet1_Features_CopyFeatures to “ClimateProtectionAgreementCities”.
2. For In the Geoprocessing pane, for ‘X Field’, ensure the Longitude field is selected.
3. For ‘Y Field’, ensure the Latitude field is selected.

Notice in the ‘Spatial Reference’ drop-down menu, it defaults to GCS_WGS_1984, which is the most commonly used geographic coordinate system for mapping latitude and longitude and happens to be the correct one to select in this case.

1. Ensure that your 'Copy FeaturesXY Table To Point' tool parameters match those shown below and click OK.
   Image Removed
   Image Added
   
   
2. Click Run.

The points should now appear on top of the United States and the map should automatically zoom to the extent of the points, since they were the first layer added.

Exporting XY Data

At this point, you are simply visualizing the data contained in the Excel spreadsheet, but you have not yet created a standalone point feature class. Since the points appear to be in reasonable locations (rather than in another country or the middle of the ocean), you will want to export them to a new feature class in your XY geodatabase.  Exporting to a feature class will allow you to reuse this points layer in other future maps without having to go through the display XY data process each time.

1. Right-click the Sheet1$_Layer and select Data > Export Features.

In the Geoprocessing pane, in the 'Copy Features' tool, notice that for 'Input Features' Sheet1$_Layer is already selected, since that was the table used to open the tool.

...

Since you now have a permanent feature class, you may remove your temporary Sheet1$ layer and the corresponding Excel table.

1. Right-click the Sheet1$_Layer layer and select Remove.
2. Right-click the Sheet1$ standalone table and select Remove.

If you’d like to get a better view of your points, use the navigate tools on the Map tab to zoom in to the continental United States. the map should automatically zoom to the extent of the points, since they were the first layer added. You have successfully mapped point locations using XY coordinates.

...

Converting Addresses to XY Coordinates

If all of your data already comes with a list of the latitudes and longitudes of the points you’d like to map, then you are ready to go straight into ArcGIS Pro, but what if you have a list of cities or addresses that you’d like to map, but you don’t know their corresponding coordinates? This section will show you one automated method of generating such coordinates based on address locations.

...

1. Ensure that the break lines in the ‘Data preview’ box are placed like those shown below and click Next >.
   
   
   In order to import this information into GIS, the columns without the degrees and minutes information should be excluded, and you can do this by using the Do not import (skip) command. 
   
   
2. In the ‘Data preview’ box, click the second column containing the apostrophes to select it.
3. In the ‘Column data format’ box, select Do not import column (skip).
   
   
   
   
4. Repeat steps 2 and 3 above with the fourth column containing the quotation marks and the fifth column containing the letter W.
5. Click Finish.

...