Select to view content in your preferred language

Query Address Locator using LIKE % Selection Statements

5764
12
Jump to solution
02-02-2016 06:02 AM
JeremyMullins4
Deactivated User

Is it possible to bring back a list of addresses using the address locators styles within ArcMap? I need to be able to create a locator using customer street and point data that can perform SQL statements, basically.

Here is an example. I want to take to be able to take the following address:

1234 Main St, Anywheretown, USA 12345

When I start to type the address:

1234 M

I want the returned list to come back as:

1234 Main St, Anywheretown, USA, 12345

1234 Malorie Dr, Anywheresville, USA, 12365

1234 Mitten Ct, Anywhere City, USA 12355

Basically, I want the search of 1234 M to basically act like a sql statement of ADDRESS LIKE '1234 M%'

I hope this makes sense. Thanks for any and all suggestions.

0 Kudos
12 Replies
ShanaBritt
Esri Regular Contributor

Jeremy:

You can now get the World Geocoder for ArcGIS.

World Geocoder: Put Addresses and Places on a Map

-Shana

JoeBorgione
MVP Emeritus

Shana-  will this capabilty only be be available to those using the World Geocoding Service?  I ask because I work in 9-1-1 and we use our own data and locators.

That should just about do it....
0 Kudos
ShanaBritt
Esri Regular Contributor

Joe:

Since it's going to be a licenced product package, it is separate from ArcGIS Online and will have different pricing. The World Geocoder for ArcGIS is not limited to those who currently use the World Geocoding Service that is included with the ArcGIS Online Organization subscription.

-Shana

0 Kudos