Latest Contributions by ShanaBritt

It is possible to geocode a table of addresses using a single field that contains the full address/location or multiple fields with the components of the full address split across multiple fields when using a locator based on the US Address - Singlehouse locator style as well as other street address level locator styles (Dual Ranges, One Range, Singlehouse Subaddress, Street Name) . The table should be formatted as follows if you are going to use multiple fields, where the house number and street name are in a single field and city, state, zip code are in separate fields. If your existing table only has one field in it that contains the full address "380 South Valley Drive, Laguna, CA 92112" and no other fields and the address locator was created without city, state, zip mapped, this is the reason you only see one field when you select the Multiple Field radio button. If you create your locator with city, state, zip mapped, then you will see those zones listed in the Input address fields section of the locator properties. Locator input address fields properties—Help | ArcGIS Desktop  Is the address on "South Valley Drive" getting matched to the correct location when geocoded? ... View more

To add on to my previous response and relating it to the Python code and your Enterprise portal you would make the following changes using your federated server for server_url. #Create the ArcGIS Server connection file server_url = "https://gisserver.domain.com/server" conn_file_name = "arcgis_online_batch_geocoding.ags" conn_file = os.path.join(cwd, conn_file_name) username = "<your username>" password = "<your password>" arcpy.mapping.CreateGISServerConnectionFile("USE_GIS_SERVICES", cwd, conn_file_name, server_url, "ARCGIS_SERVER", username=username, password=password) ... View more

I would suggest using an ArcGIS Server Connection file in your python script to geocode using the ArcGIS World Geocoding Service, which is described in the following script.  Batch Geocoding using Python ... View more

Charles, If you were going to sign into your Enterprise organization's portal in ArcMap you would use the following URL, https://gisserver.domain.com/portal. More info about portal connections in ArcMap can be found at Manage ArcMap portal connections—Help | ArcGIS Desktop .Then in ArcMap you would be able to sign in with the Enterprise credentials and the World Geocoding Service will be available in the Geocoding toolbar. If you were going to make an ArcGIS Server connection (.ags file) you would use the following URL and include the Enterprise credentials, https://gisserver.domain.com/server . ... View more

Just curious, do you get the same unexpected behavior when the csv contains 15-20 record? It's possible that there might be a value in one of the fields after record 9 that is causing a problem with the csv geocoding the locations correctly. I also noticed that another field contained a space in the name "Area Code". I would suggest removing spaces from the column headers of all the fields in the csv, even those not used for geocoding to see if you get different results. ... View more

If you had spatial features that included the GIS PIN, you could build your own locator from it using the General - Gazetteer address locator style, where the place name would be mapped to the GIS PIN field. Then you could geocode the spreadsheet based on the value in the GIS PIN field to be able to place the location on a map. ... View more

Just an update on the status post 2018 User Conference... The ArcGIS Geocoding team is currently working on a solution for improving suggest results for locators organizations build from their own data.  We are targeting the solution for release for the first half of 2019.   ... View more

The following thread has more discussion about the behavior and what is happening, which is a limitation in the current address locator technology. Composite Locator Not Properly Locating Address Points The suggestion index for address locators created with your own data that have suggestions enabled behaves as described below: The suggest index does not store the house number for performance reasons, and so the best practice is to create a composite locator with at least a Street Address or Point Address locator and a Street Name locator. The reason for this is that if the house number doesn't exist in the Street Address or Point Address locator, you will still get a match to Street Name. You do not need different data to create the Street Name locator. A Street Name locator can be created from Street Address data because the Street Name style only uses a subset of the fields required by Point Address or Street Address. The ArcGIS Geocoding team is currently working on a solution for improving suggest results for locators organizations build from their own data.  We are targeting the solution for release for the first half of 2019.   ... View more

Lee: I was able to create a parcel and zip code locator and add them to a composite using ArcMap 10.6.1 and publish the composite using ArcMap to the federated server of a 10.6.1 Enterprise portal using the copy data option. I added the composite service as a utility service to the Enterprise portal and was successful in dragging and dropping a csv file onto the map and geocoding either the postal codes or parcel PINs. Since you do have Enterprise portal and it is federated, you can add the composite locator to ArcGIS Pro and share the locator directly to the Enterprise portal as an item. The item can then be added as a utility service to be able to use it in the map viewer or in ArcGIS Pro when signed with your Enterprise credentials. Does the behavior occur if you use ArcGIS Pro to publish the composite locator to Enterprise portal? These resources should help: About sharing your locator to your portal—ArcGIS Pro | ArcGIS Desktop  Publish a locator to your portal—ArcGIS Pro | ArcGIS Desktop  Set properties on locators shared to your portal—ArcGIS Pro | ArcGIS Desktop  ... View more

Lee: Is the data for the postal codes and parcel numbers in a single field in the csv or multiple fields in the csv? Are you able to provide a screenshot of the field mapping from the map viewer when using the composite? In ArcMap when you select the Data.csv table do you map both the 'Key' and 'ZipCode' fields to geocode the table? ... View more

ArcGIS Pro does not have an option to adjust the candidate and match scores at run time like you can in ArcMap. ArcGIS Pro does not have a locator properties dialog for geocode services. There really isn't a good solution if you don't have access to the locators that were published to server.  -Shana ... View more

Brian: The feature search behavior you described that includes joining an Excel spreadsheet to a feature class and not being able to set the feature class up as a layer provider to search for features is a bug, BUG-000114925, that I've added to our development backlog for review. If you are current on your maintenance I would suggest reaching out to Support to see about getting added to this bug so that you can follow it. We've made some improvements to the way feature search works in the Locate pane at version 2.2, which went live a few days ago. You can search for features without configuring layers in the map, similar to behavior found with the ArcMap Find tool. The workflow you described in this thread will not work with the improvements either, from my testing the feature class and the table need to be in the same workspace (file geodatabase or enterprise geodatabase aka sde) if joined together. Find a feature by searching all fields in all layers in the map using the Locate pane is new for ArcGIS Pro 2.2. Excel .xls tables can be used in ArcGIS Pro, but has limitations. -Shana ... View more

Monika: If Name, County are in a single field in the reference data, try creating a locator based on US Address—City State locator style and map the field to  Named Place. Then publish the locator. What are the results? Another locator style to consider is the General - Gazetteer to build the locator. Commonly used locator styles—ArcGIS Pro | ArcGIS Desktop   ... View more

Brian, Are you able to import the XLS into the SDE geodatabase, then use the imported table as the source of the join to the feature class. Then try to add the feature class as a layer provider.  ... View more