topic Re: ArcGIS Pro Locate tool does not work with certain Feature Classes in ArcGIS Pro Questions

ArcGIS Pro Locate tool does not work with certain Feature Classes

Clayton-Cooley — Thu, 27 Jan 2022 17:05:07 GMT

Hi,

I'm trying to create a mobile map package for Navigator for ArcGIS. In the process of setting up my Locator tool to search for features within the map, I noticed that the Locate tool in ArcGIS Pro will not work with some of my feature classes. I've gone through the process of going to Provider Settings, Configure for Locate, Selecting a layer, then selecting the field I want to search, and choosing Contains for the Search Mode. I've also added an Index to the layer using the field of interest but that hasn't helped.

A few things to note:

1) This layer is a feature class in our Enterprise SDE

2) The locate tool works with other features classes, but not all.

3) The SDE is being hosted on an AWS server, if that matters.

This post from 2018 Solved: Locate not working - Esri Community is marked as solved, but the solution did not seem to help me.

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

Robert_LeClair — Fri, 28 Jan 2022 16:38:39 GMT

Let's try a few tests. Export your eGDB feature class to a shapefile and a file geodatabase feature class and set up the feature class for the Locate tool. Does it behave as expected? Copy/paste the feature class as new feature class in your eGDB and attempt the workflow again. Does it behave as expected? By chance is the layer a Database View? You can also run the Repair Geometry tool on the Feature Class to see if that helps as well.

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

ShanaBritt — Fri, 28 Jan 2022 20:12:51 GMT

What version of ArcGIS Pro are you using? What version of Enterprise SDE are you working with?

When you say that it doesn't work, do you mean you do not get any results when searching for a string in one of the fields you configured?

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

Clayton-Cooley — Tue, 01 Feb 2022 15:14:11 GMT

Working with Pro 2.9.

Correct, it doesn't display any results when I search for a string.

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

Clayton-Cooley — Tue, 01 Feb 2022 15:17:09 GMT

Works fine when I export to a shapefile or file geodatabase. No, it is not a database view. Haven't tried the repair geometry tool but I'll give it a shot. Thanks!

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

RandyKreuziger1 — Wed, 31 Aug 2022 17:40:30 GMT

My users are running into this too. We have a layer that is an XY Event Layer on a SQL Server table view. The locate works in ArcMap but does not work with Pro. Is this bug being worked on?

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

ShanaBritt — Thu, 15 Sep 2022 20:12:58 GMT

@RandyKreuziger1 @Clayton-Cooley I think the issue is that database views do not have ObjectIDs and there are limitations to what you can do with data that do not have ObjectIDs such as selections and queries. Try creating a query layer and specify a virtual ObjectId or use an existing field for the ID.

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/what-is-a-query-layer-.htm

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/creating-a-query-layer.htm

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/modifying-a-query-layer.htm

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

RandyKreuziger1 — Thu, 15 Sep 2022 21:05:36 GMT

@ShanaBritt but the same XY Event (same excel file) works in ArcMap with the FIND function. Is Locate in Pro the same as Find in ArcMap?

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

ShanaBritt — Tue, 20 Sep 2022 17:16:25 GMT

@RandyKreuziger1 In ArcGIS Pro how did you create the XY Event from the Excel file? Did you use the https://desktop.arcgis.com/en/arcmap/latest/tools/data-management-toolbox/make-xy-event-layer.htm in ArcGIS Pro or the XY Table To Point (Data Management)—ArcGIS Pro | Documentation tool?

In ArcGIS Pro 2.9 I can create a layer from an Excel spreadsheet using the Make XY Event Layer tool and configure fields in the layer for search and get results returned. I also get results returned when searching all layers in the map, https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/find-places-on-the-map.htm#ESRI_SECTION1_086B92BF080B46B1A414A9A98D4346E3. https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/introduction-to-finding-places-on-a-map.htm

The Locate pane in ArcGIS Pro can be used to search for features either in specific configured layers or tables, all layers in the Contents pane, or addresses and locations using locators, or coordinates. It is not the same code as the Find tool in ArcMap.

Can you give me more specifics on your workflow?

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

RandyKreuziger1 — Tue, 11 Oct 2022 22:03:17 GMT

I opened a ticket with ESRI for the issue "Locate tool does not work in ArcGIS Pro with xy event source." The tech was going to submit an enhancement request but I argued that it's really a bug given that this functionality exists in ArcMap. It's #BUG-000152919 but I don't know if anything will come of it, however, if this bug is affecting other users please add you name/agency to this bug to increase the chance of it ever being fixed. FYI, you can only do this if your agency is on maintenance.

https://my.esri.com/#/support/bugs/BUG-000152919

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

ShanaBritt — Wed, 12 Oct 2022 02:46:32 GMT

@RandyKreuziger1 Do you only encounter the behavior with an event layer created from a SQL Server table view? I re-tested and was able to reproduce with a csv table. Is using the XY Table to Point tool a viable workaround for you?

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

RandyKreuziger1 — Wed, 12 Oct 2022 16:22:30 GMT

@ShanaBritt we have lots of XY data stored in non-spatial SQL databases (both tables and database views) that we get to through layer files. Using layer files users don't need to know where the data is and therefore the data is always up to date. The data is used daily by maybe a dozen users. Using the XY Table to Point tool would require each user to turn it into a table everyday just for one table so this is not an option.

The Locate in Pro is the equivalent of Find in ArcMap. This issue is going to delay out migration to Pro.

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

ShanaBritt — Fri, 14 Oct 2022 06:13:34 GMT

Thanks for the additional info Randy.

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

ShanaBritt — Tue, 08 Nov 2022 23:34:28 GMT

@RandyKreuziger1 I had additional questions for you about your workflow. Are your users searching for features or just attributes in a non-spatial table? What do the users do with the result in the Find tool in ArcMap? Are the users able to search the table and database views w/o creating the in-meomory XY Event Layer?

-Shana

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

RandyKreuziger1 — Wed, 09 Nov 2022 17:02:04 GMT

@ShanaBritt , The data is not in a spatial table but contains x,y values. Once the user creates the XY Event the data displays in the map, however, the identify function doesn't work nor the locate. User use the Find in ArcMap to zoom to a record/point based on the ID or other field. There are several hundred point locations so when they need to go to the point Find in AM works. The Locate in Pro, which is supposed to replace the Find, doesn't do anything with XY Event Sources breaking the entire workflow for these datasources.

The workaround ESRI added to the ESRI bug says to have the user convert the data into a point feature class but this does not replace the functionality. We have around 20 users who use this data each day and the data is updated daily. The workaround would require this table, and others, to be converted to a feature class on a daily basis. Not doable.

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

Y_Chau — Sun, 05 Mar 2023 13:22:49 GMT

I found this post when searching for the problem I am facing. I am doing the exact same thing as @Clayton-Cooley except that my layers are in a GDB. I face this issue with one layer only. I exported the layer to a new FC and the problem disappeared. After one year, any progress on why this happens?

Sincerely

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

Y_Chau — Sun, 05 Mar 2023 14:09:17 GMT

On further testing I found why this is happening to me, I am not sure about others though. I added a new field to the feature class while it was being used in locate. After that I could not use locate function on that layer. Probably changing the schema while the layer was in locate confused it. After this nothing can make it work except exporting to a new FC.

Update: Even after exporting if I rename the layer to the original FC name, it refuses to work in Locate. That's a series of bugs, not one.

Sincerely

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

RandyKreuziger1 — Mon, 20 Mar 2023 23:08:05 GMT

To anyone experiencing this issue, the first word from ESRI was that it was too late to get it into Pro 3.0 but that it would be included in 3.1. Now that 3.1 has been released without this bug fixed, the word is that there is no plan to fix it in Pro 3.2. Very disappointing!

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

Robert_LeClair — Tue, 21 Mar 2023 13:48:27 GMT

Randy - I did look into BUG-000152919 to determine its status. It's marked "In Product Plan" to fix the bug but it does not state when. I realize this is not what you're looking for rather just an update for you.

Re: ArcGIS Pro Locate tool does not work with certain Feature Classes

ShanaBritt — Fri, 24 Mar 2023 19:28:37 GMT

Are there any warnings or error messages in the case where you have renamed the exported layer? What version of ArcGIS Pro are you finding this behavior in? In your workflow is your layer configured and you are using the Locate tab of the Locate pane or are you using the Layer Search tab of the Locate pane?

-Shana