How to do it...

1. Before you start ArcGIS Pro, you will need to examine the spreadsheet of inspections you will be geocoding. Open Windows File Explorer.

1. In File Explorer, expand Desktop and This PC or My Computer, depending on the version of Windows you are using, located in the area on the left side of File Explorer.
2. Click the C:\ Drive so you can see its contents in the area on the right. It may be labeled as OS or Local Drive:

1. In the area on the right that displays the contents of the C:\ drive, scroll down until you see the Student folder and double-click it.
2. Continue using that same process to navigate to C:\Student\ArcGISProCookbook\Chapter2. Once you get to the Chapter2 folder, you should see several files. One of them is Inspections.xls.
3. Double-click the Inspections.xls file to open it.

1. Review the spreadsheet you just opened. Note what information it contains:

This spreadsheet represents an export from a permitting and inspections system that is outside of your GIS. That system does not have the ability to display data on a map, but the City Manager wants to see where inspections have been completed within the city. As you can see, the spreadsheet does include the address where the inspection took place. You will use that to geocode the location of each inspection on to a map.

1. Start ArcGIS Pro and open the Geocoding.aprx project located in C:\Student\ArcGISProCookbook\Chapter2.
2. Expand Folders in the Catalog pane.
3. Expand the Chapter2 folder.

1. Expand the Inspections.xls spreadsheet and right-click the Inspections$ table. Select Add to Current Map, as shown in the following image:  

You have just added the spreadsheet you examined to your map so that you can geocode it. Before you geocode the data in the spreadsheet, you will first need to create a locator. Geocoding in ArcGIS Pro requires three components if you are using all your own data. You will need the table you want to geocode, reference data in your GIS that has address information, and a Locator.

Reference data is typically road centerlines, address points, or parcel polygons. Address points typically provide the greatest level of accuracy. This is followed by parcel polygons. The least accurate is road centerlines.

The Locator is the translator between your source data and the data you are trying to geocode. It provides basic settings and options required to geocode. There are several styles of locators that are dependent on your reference data and how the address information is formatted.

So, before you can create your locator, you must first identify your source data. This will be a GIS layer that already contains address information.

1. Since there is no address point layer in the Trippville geodatabase, you know that will not be your reference data. You do have parcel polygons, so right-click the Parcels layer in the Contents pane and select Attribute Table.
2. Examine the attribute table for the Parcels layer to determine whether it has address data.

The Parcels layer does include some address information. It has a street name, street number, and street suffix. However, not all parcels have complete information. Also, it is missing other information that is included in an address, such as zip code, city, and state. Since the information attached to the parcels is incomplete, it is not well-suited to be your reference layer. It's time to look at the street centerlines to see whether they have more complete address information.

1. Close the Parcels attribute table.
2. Right-click the Street Centerline layer and select Attribute Table.
3. Review the Attribute Table for the Street Centerline layer. You may need to scroll over to see all the data fields.

The Street Centerline layer does have more complete address information. It has address ranges for both the left and right sides of the road. It also has fields for the road name and type. In addition, it has fields for the zip code and city on the left and right sides of each road. This is enough information to create complete addresses. So the Street Centerlines layer is the best choice as your reference layer, even if it might not produce the most accurate data points. Now you are ready to create your locator.

1. Close the Attribute Table for the Street Centerlines layer.
2. Click the Analysis tab in the ribbon.
3. Click the Tools button to open the Geoprocessing window.
4. Click the Toolboxes tab at the top of the Geoprocessing pane.

1. Expand the Geocoding Tools toolbox and click the Create Address Locator tool:

1. In the Create Address Locator tool, set the Address Locator Style to US Addresses – Dual Ranges by selecting it from the drop-down list.

1. Under Reference data, select Street Centerlines from the drop-down list. It should automatically be set as your primary table.
2. The field map should automatically populate. Scroll through the list and verify that all those with a "*" next to the field name are associated with an Alias Name. The Alias Name is the name of an attribute field in the Street Centerlines table.
3. Click the Browse button to the right of the Output Address Locator.
4. In the area on the left of the Output Address Locator window, scroll down to C:\ under Computer.
5. Select C:\.
6. Scroll down and double-click the Student folder in the area on the right of the window.
7. Double-click the ArcGISProCookbook folder.
8. Double-click the MyProjects folder.
9. In the Name cell, type Trippville_Locator and click Save.
10. Verify that your Create Address Locator tool looks like the following image. If it does, click Run:

1. Close the Geoprocessing pane once the tool completes.

The locator you just created should appear in the Catalog pane in the Locators folder. That lets you know it was successfully created.

1. Right-click the Trippville_Locator you created in the Catalog pane. Select Locator Properties.
2. Select Geocoding options in the area on the left of the Locator Property window.
3. Scroll down to Side Offset and set it to 35. The side offset is how far off the centerline the geocoding process will create a new point. Since we know most of the street rights-of-way are between 50 and 60 feet, 35 should put the point on or close to the parcel it belongs on.
4. Set the Side Offset units to Feet from the drop-down list and click OK.
5. Right-click on the Inspections$ table in the Contents pane and select Geocode Table:

1. The Geoprocessing pane will open with the Geocode Addresses tool. The Input Table will automatically be set to the Inspections$ table. Set the Input Address Locator to Trippville_Locator.
2. Accept all other defaults and click Run:

1. When the Geocode Addresses tool is complete, a window will appear and a new layer will be added to the Contents pane with the result. Click Yes to start the rematch process.
2. You were lucky to only have one address that did not match.
3. In the Rematch Addresses pane, make sure Unmatched is selected at the top. In the Street or Intersection cell, you can see that Nature Pass has been misspelled. Click in the cell and correct the name to Nature Pass.
4. The map should automatically zoom to the best match, and a grid will appear at the bottom of the Rematch Addresses pane with the best match at the top. Other close matches will also be presented.
5. Select the top match, labeled A.
6. Click the small green check mark located at the top of the grid to match it to the selected match.
7. Close the Rematch Addresses and Geoprocessing panes.

1. Right-click the Inspections_GeocodeAddresses layer in the Contents pane and select Zoom to Layer:

1. Using the skills you have learned, open the Attribute Table for the Inspections_GeocodeAddresses layer.
2. Examine the table to see the fields that were created by the geocoding process.
3. Save your project and close ArcGIS Pro.