nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Using Definition Query on a table to be used for Geocoder

LorindaGilbert

Hi All,

I'm looking to see if using a feature class with both expired and current addresses (and streets) can be used with a definition query for a geocoder. We have one data consumer group that requires both sets of addresses to be available, but another data consumer group that only requires the current addresses. Our solution right now is to have two feature classes. The one group is pushing hard to have one feature class. I have on older versions tested this scenario of having both sets of data on the same feature class and using a def query but the geocoder seems to be an all or nothing type of thing. Or is this something that ArcPro can handle? We are slowly migrating to ArcPro.

Thanks,

Lorinda

Encuentra más publicaciones etiquetadas con

Geodatabase

Desktop

Accepted answers

ShanaBritt

Lorinda:

The Create Locator tool in ArcGIS Pro allows you to build locators based on definition queries, selected features, use feature services as the reference data. This is not supported by the Create Address Locator tool in ArcMap or Pro 2.6 and earlier. Here is a basic overview of creating a locator with the tool https://pro.arcgis.com/en/pro-app/2.8/help/data/geocoding/create-a-locator.htm. We've added 3 new tutorials for building locators with the Create Locator tool, which will be available once Pro 2.9 is live.

All comments

ShanaBritt

@ShaundaDevenport The definition query is done at the layer level in the layer properties of the reference data used to build the locator. It may be beneficial to do this in a model so that you can keep track of the query used when building the locator.

1. Create the definition query in the layer properties

2. Create the locator with the Create Locator tool in ArcGIS Pro. The definition query details are not part of the locator properties.

-Shana

ShaundaDevenport

Were you able to accomplish this? I am trying to build a locator with a definition query and do not see any where to apply the definition query to the table in the locator properties.

LorindaGilbert

Cool! I'm glad to hear that the def query is being used to the fullest extent. I guess the next question would be if it can be used as a geocoding service that is published. I'm guessing that it can, which will work for two of our data consumption users, but not the other - however, they are on an older version of ArcGIS Server and we have to write the data to their SDE anyway, so FME to to the rescue! I will definitely check out the locators in ArcPro (using 2.8.x right now)!

And since we are moving our addresses to ArcPro with Attribute Rules, we will have to be using ArcPro in the future for this layer.

Thanks,

Lorinda

ShanaBritt

Lorinda:

LorindaGilbert

Actually, I'm trying to figure out if it still ignores the definition query in the latest version of ArcMap and/or in ArcPro. I'm still learning ArcPro and haven't had an opportunity to learn that as of yet. I've just recently installed 10.8.1 and also have not had an opportunity to test it.

Too many other projects on the plate right now. Mainly learning attribute rules in ArcPro for migration of data from one database method to another. (Moving stored procedures in Oracle to Attribute Rules in SQL Server SDE).

MikeVolz

Are you saying that the geooder ignores a definition query in ArcMap as well as in Pro?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.