topic Dynamic Geocoding won't update. in Data Management Questions

Dynamic Geocoding won't update.

IanBailey — Fri, 21 Oct 2011 21:24:43 GMT

I created a dynamic geocode in a file geodatabase, but when I append new records to the original table in the file nothing happens to the dynamic geocode point file. I tried it both outside and inside an editing session. And neither works. Am I missing a step?

Re: Dynamic Geocoding won't update.

BradNiemand — Fri, 21 Oct 2011 22:45:00 GMT

Where does your table exist, in the fgdb as well?

Brad

Re: Dynamic Geocoding won't update.

IanBailey — Tue, 25 Oct 2011 15:12:47 GMT

Yes the table and the Geo-coded points feature class are in the same File Geo-database.

Re: Dynamic Geocoding won't update.

BradNiemand — Tue, 25 Oct 2011 16:19:13 GMT

What version of ArcGIS are you using and what type of locator?

Brad

Re: Dynamic Geocoding won't update.

IanBailey — Tue, 25 Oct 2011 16:57:49 GMT

I'm using ArcGIS 10 SP2, and a composite locator with a General - Single field locator for parcel addresses, combined with 2 US Address - Dual Range locators, for street center line data.

Re: Dynamic Geocoding won't update.

BradNiemand — Tue, 25 Oct 2011 21:33:54 GMT

I do confess that I am doing this in 10.0 SP3 but I can't reproduce this. If possible you can try to upgrade to 10.0 SP3? If not, can you send me your data and I can see if I can reproduce it.

Brad

Re: Dynamic Geocoding won't update.

IanBailey — Fri, 28 Oct 2011 15:52:49 GMT

I upgraded to SP3 and tried another dynamic geocode and it's still not updating when I add a new record to the table. Do you want me to send you my file geodatabase that I'm using?

Re: Dynamic Geocoding won't update.

BradNiemand — Tue, 01 Nov 2011 19:25:38 GMT

Sure. You can send it to me here:

bniemand@esri.com

Brad

Re: Dynamic Geocoding won't update.

IanBailey — Thu, 03 Nov 2011 20:04:26 GMT

Apparently I had an address locator that was looking for a zone field. I didn't have a zone field in my table and I assumed I could just leave the zone field empty and it would ignore that when geocoding. It did work to geocode but was stopping the dynamic functionality. I added a zone field and set it for a blank space so it wasn't NULL and that fixed the problem. Thanks Brad.

Re: Dynamic Geocoding won't update.

Mtclimber03 — Fri, 06 Jan 2012 16:49:14 GMT

I'm having similar issues trying to use a dynamic geocode. Is it possible to do this with the following work flow?

SQL Table --> Linked in Personal Geodatabase (through Access) --> Geocode Service --> Output feature class (in same mdb)

Based on what I've read it seems that in theory it would function but I am not having success in seeing updates reflected to the feature class upon adding or editing the SQL Table.

Re: Dynamic Geocoding won't update.

ToddSmith — Tue, 21 Feb 2012 14:20:43 GMT

Charlie, did you ever get this working? I am trying to do something similar and I am not able to register the linked SQL Server table with the Personal Geodatabase.
Thanks,
Todd

Re: Dynamic Geocoding won't update.

Mtclimber03 — Mon, 27 Feb 2012 13:13:34 GMT

Todd,

I was not ever able to get this to work. Based on more reading and research it seems apparent that this is not possible. The best I can understand is that it provides one more reason for us to use sde. My next step is to try this with a stored procedure inserting new data into a table on the underlying SQL on the sde database. I'm about 99.9% sure this method will work.

-C

Re: Dynamic Geocoding won't update.

ToddSmith — Mon, 05 Mar 2012 14:04:50 GMT

Thanks Charlie, based on the research I have done I don't think it is possible either. It is too bad because most database tables that organizations want to geocode reside in other systems/databases and not in GIS.

Re: Dynamic Geocoding won't update.

LakshmiSankaran — Fri, 23 Mar 2012 13:58:55 GMT

Has this been successful - automated geocoding of a SQL db via SDE? We are in version 10 SP1. Thanks

Re: Dynamic Geocoding won't update.

NancyGnanicys — Fri, 16 Nov 2012 18:31:01 GMT

I found this posting which may explain why adding new records to the table via SQL/Access Linked table may not be working. It appears that the table's new records must be added in through arcgis rather than front end access according to my findings in the forum.

I am trying to do the same thing with a table in Arcsde 10.0 sp 5, I have established a linked table connection to it through MS Access 2003. Anytime a record is updated or added/deleted in Access, it reflects the changes immediately in Arcmap's table (upon refresh in Arcmap). I ran 'dynamically geocode table' and stored it within the same sde geodatabase but the table does not geocode when new features are added of course since they are added in Access.

Since arcgis needs to append the new information to the table in order for dynamically geocoded table relationships to work, what tool/or idea could I use so that only the new records that are added in get appended to my table with the dynamic geocoding relationship? Even better is if this could be automated. I haven't done much python scripting or code programming so if it's possible, could someone point me down the right path to start this? The existing table records are not edited, just new records need appended then geocoded automatically so a web application can just push it out to users.

http://forums.arcgis.com/threads/23303-How-to-geocode-addresses-dynamically?highlight=dynamic+geocoding

Re: Dynamic Geocoding won't update.

AllisonPlummer — Fri, 18 Jan 2013 18:59:26 GMT

Apparently I had an address locator that was looking for a zone field. I didn't have a zone field in my table and I assumed I could just leave the zone field empty and it would ignore that when geocoding. It did work to geocode but was stopping the dynamic functionality. I added a zone field and set it for a blank space so it wasn't NULL and that fixed the problem. Thanks Brad.

I had this problem also. My address locator wanted Address, City, State and Zip. I did not have a state field, which was fine to just geocode, but did not work dynamically. Once I added the State field, it started working (also after hitting the refresh button). For anyone troubleshooting this issue, it seems like having a field for all critera of the address locator might be a good first step.

Re: Dynamic Geocoding won't update.

Mtclimber03 — Thu, 03 Oct 2013 12:17:25 GMT

Hey guys,

The way I finally resolved this issue was to build a model that would essentially copy a native SQL table to a standalone SDE table that is connected to a dynamic geocoding service. Apparently ArcGIS needs the table to be registered with the geodatabase in order for the dynamic "eye" watching the table to see changes. My model first "deletes rows" then runs an "append" of the SQL native table to the SDE table. With this model exported to python script I was able to build a nightly task in windows task scheduler. This is what dumps the new data over from the native SQL table, then activates the dynamic geocoder, and finally updates the associated feature class.

Hope this has been helpful for you guys out there looking for an answer to similar problems of having live data from another DB connected to dynamic geocode.