topic Re: Geocoding in 10.2.1 after upgrade from 10.1 in Data Management Questions

Geocoding in 10.2.1 after upgrade from 10.1

JamisonPeevyhouse — Thu, 06 Feb 2014 16:14:41 GMT

As thread title indicates, I've just upgraded from 10.1 to 10.2.1 and I am unable to geocode at all since doing so.

When going to "Geocode Adresses" I get the error: "Geocoding an address table with a definition query or selection set is not supported"

It hasnt even given me the option to select a table, etc. As soon as I click the button to bring up the dialog window it throws that error. I haven't been able to find anything on google relating to this issue, anyone have any thoughts?

Thanks!

Re: Geocoding in 10.2.1 after upgrade from 10.1

BradNiemand — Thu, 06 Feb 2014 21:07:48 GMT

It is something that we will be fixing soon but here is how to geocode the address table until we have a fix.

1. Click the mailbox button with a table added to ArcMap but also make sure you have the table selected in the TOC or you will get the same error.
2. Browse to the table in the Catalog window in ArcMap, right click on the table, and select �??Geocode Addresses�?��?�
3. Use the GeocodeAddresses GP tool

Brad

Re: Geocoding in 10.2.1 after upgrade from 10.1

JulianChen — Wed, 09 Apr 2014 18:45:53 GMT

I got the same problem

Re: Geocoding in 10.2.1 after upgrade from 10.1

JulianChen — Wed, 09 Apr 2014 18:55:59 GMT

It is something that we will be fixing soon but here is how to geocode the address table until we have a fix.

1. Click the mailbox button with a table added to ArcMap but also make sure you have the table selected in the TOC or you will get the same error.
2. Browse to the table in the Catalog window in ArcMap, right click on the table, and select �??Geocode Addresses�?��?�
3. Use the GeocodeAddresses GP tool

Brad

I got the same problem
and I dont quite understand what brad5993 said.
What do you mean "Click the mailbox button with a a table added to ArcMap ...?"
I am now just studying on the manual and using the PghStreets. And I dont know what you mean " with a table added to ArcMap ...?" Do you mean add a new table not the default one?
Sorry could you help me figure out this problem?
Many thanks!

Re: Geocoding in 10.2.1 after upgrade from 10.1

DanRose — Fri, 18 Apr 2014 16:45:27 GMT

powerjulianchen - he means to add the table to your .mxd just like you would a shapefile or feature class. When it's inserted, it will appear in the 'List By Source' part of your Table of Contents, not in your Layer tree. Then, you can right-click on the table and click geocode.

Re: Geocoding in 10.2.1 after upgrade from 10.1

JenniferMinnick — Fri, 16 May 2014 14:38:26 GMT

So before the upgrade we could click on the little mailbox and browse for the necessary table on our computer to geocode with no problems and post upgrade we have to add the table to mxd and then geocode?

That seems like a regression in functionality.

Also, the error implies that there is a query or selection set attached to our desired dataset when in fact we can't actually access our dataset (at least as we were used to doing). There is no dataset yet when we get this error.

Re: Geocoding in 10.2.1 after upgrade from 10.1

SatyaSamudrala — Tue, 03 Jun 2014 19:36:10 GMT

Same issue for me too..not sure how to fix this.. i've installed 10.2.2 from 10.2.1 . getting this error since i upgraded..can someone help on how to fix this

Re: Geocoding in 10.2.1 after upgrade from 10.1

DavidHunt1 — Wed, 11 Jun 2014 15:42:28 GMT

I'm in the same boat too. Recently upgraded to 10.2.2 and still get this error. You have to geocode through the toolbox until this bug is fixed.

Re: Geocoding in 10.2.1 after upgrade from 10.1

HalStringer — Wed, 06 Aug 2014 18:11:06 GMT

Brad,

Just upgraded to 10.2.2. and issue is still there. You said it was something that will be fixed soon. Any update on the fix?

Re: Geocoding in 10.2.1 after upgrade from 10.1

BradNiemand — Wed, 06 Aug 2014 18:40:46 GMT

This is not fixed for 10.2.2 and we target fixing it for 10.3 but there are multiple ways to batch geocode from within ArcMap to work around this issue:

1. Click the mailbox button with a table added to ArcMap (Drag and drop it into the TOC) but also make sure you have the table selected in the TOC or you will get the same error.

2. Browse to the table in the Catalog window in ArcMap, right click on the table, and select "Geocode Addresses"

3. Use the GeocodeAddresses GP tool under "Toolboxes">"System Toolboxes">"Geocoding Tools" in the Catalog window in ArcMap.

Brad

Re: Geocoding in 10.2.1 after upgrade from 10.1

HalStringer — Thu, 07 Aug 2014 12:44:33 GMT

Thanks Brad,

I’ve started using your option #2 below and it works fine. The only difference is I have to manually add in the geocoded feature class to the map after the matching is done – but not a huge inconvenience. I’m just glad I don’t have to go back to 10.2 or rebuild my locators!

Thanks for the info and have a good day.

Hal Stringer

Computing Support Manager

<http://www.tminc.com/> www.tminc.com

(407) 740-3023 - Phone

(407) 740-0613 - Fax