Latest Contributions by JoeBorgione

Guys-  I'm an old gray-hair that's been working with ESRI products since 1990 and version 4.5 ArcInfo on a Unix box; there is always something to learn and share.  For the past 8 years or so I've been doing nothing but GIS/9-1-1 dispatch work because I saw a niche there, and I'm sure you know what I'm talking about. [A couple of weeks ago I got a call from a Police Captain saying he had just been to an ESRI presentation and wanted to know if we had the ability to map crime incidents.... Wow, that's a novel concept.... ] The ESRI forums in general are a great resource, and a specific user community like this one is a great place to come up with ideas, share them, and commiserate about problems. All the best- ... View more

Charles, Joe Please see here: http://resources.arcgis.com/gallery/file/geocoding/details?entryID=1A290038-1422-2418-88FC-098400376B88 Regards Nice!  thanks Bruce! ... View more

I am using 9.3.1; is this a tool in 10.x?  What 'brand' CAD are you using?  The two that I use (in different 9-1-1 centers) both provide utilities that check for address attribute errors. It would be a great tool for anyone who does a lot of geocoding. [Edited moments after initial post]  Just read your other post; I misunderstood that this was an older ArcInfo tool.  So, absolutely, an ArcMap version of the tool would be great.  Seems to me there is a users 'wish-list' forum or blog somewhere in ESRI-cyberland that accepts suggestions like this ... View more

This isn't much help, but here's a link to an even earlier thread: http://forums.esri.com/Thread.asp?c=158&f=2284&t=265675 Perhaps you need to log a bug with support? ... View more

Good for you!  Happy to help out. ... View more

There is a tool called Export Feature Attribute to ASCII that I just tried for the first time a moment ago.  You might look at that, and then see if you can figure out a way to automate importing that into access.  Certainly you could import it manually... Good Luck! ... View more

Joe- That does help a little bit. I already have an odbc connection to the access database. I actually use it in a model to geocode the addresses and output to a file geodatabase. I can't figure out how to geocode back to teh access database. Is there any documentation on that? Does it matter that I am using an access 2007 accdb? Sorry about that, I guess I read your post incorrectly.  I don't think you can directly write the results of geocoding to an Access database unless that DB was a personal geodatabase, and even then it would still be in form of a point feature class.  You would obviously have the Geocoding_Results attribute table there, for what it's worth. That is an interesting proposition though; somehow translate just those attributes in the gecoded results into a stand alone access db table... ... View more

So i have roughly 500K policies that I geocode monthly from an access database. The access database is populated from a Microstrategy report as I do not have direct access to the policy server. Most of the policies have previously been geocoded. The geocoded results are currently saved in a file geodatabase. I would like to create a workflow where I would only have to geocode new policies and not all policies every month. Any ideas? Can ArcCatalog geocode back to an access database? PS. I only have an ArcView license. Thanks in advance. Is it reasonable to create a realitionship between the monthly input records and those that have been geocoded already?  Perhaps through a unique identifier such as the policy number?  That way you could examine the incoming records against those already geocoded, and concetrate your efforts where they need to be.  Another approach may include modifying the Access schema by adding a field that indicates if a record has been geocoded or not. Can ArcCatalog geocode back to an access database?  The short answer is yes, you need to set up an odbc connection from ArcCatalog and your Access database. Hope this helps- ... View more

I am working on a project for the local police department.  When I open the excel file in arcgis9.3 all the information is correct.  However after the data has been geocoded the police identification number is not there.  The only part of the number that remains is the year, however the unique identification numbers have all turned to zeros.  I have tried to reformat the cell in arcgis to various number configurations under properties without success.  Any suggestions would be greatly appreciated. matt wittenberg university Do youself a favor and import your spread sheet into a table in some flavour of geodatabase and geocode that. Excel is for accountants. Database tables are for analysts. Let the flames begin. ... View more

I am sitting here trying to figure out "Why I didn't think of that!!!"   You are right, I should be able to create another table from the results of just the "UnMatched and the StreetCenterline Matches!"  And use those to re-geocode. Thank You! Sometimes all it takes is another set of eyes or ears.  Glad to help out. Good luck with it! ... View more

While I don't use version 10 as of yet, it does not surprise me that you are unable to review your addresses as you describe. Perhaps one of the ESRI folks can weigh on this. That said, is there a way to tease out just those records that you haven't yet reviewed and or fixed. If so you could just re- geocode those that need to be, rather than starting from scratch.  Deadlines not withstanding, I'd hate to see you start over as you would as well. ( I hope this posts correctly; I'm rattling down a commuter rail as I peck this on an iPhone) ... View more

I found this Geocoding Blog entry that talks about ramping up the performance of address locators. http://blogs.esri.com/dev/blogs/geocoding/archive/2011/02/09/tuning-a-locator-for-improved-performance.aspx I'm working towards this. I'll touch base again with the results. Keith- that's a great blog post; thanks for sharing it! ... View more

Perhaps Bruce H from ESRI will chime in;  he's the go to guy for v10 geocoding! ... View more

What version of Arc GIS are you guys using?  I'm still at 9.3, and I'm not sure I see what the problem is... ... View more