topic Re: Geocoding Issues in Data Management Questions

Geocoding Issues

DanielBirmingham — Sat, 05 Mar 2011 22:35:54 GMT

Hello;

I am using ArcGIS 9.3 and am having trouble geo-coding. I am trying to geo-code entire states at one time. I am using 2010 TIGER files as my reference data, which are projected to NAD83. My addresses are in a Excel .xlsx file that I added to ArcMap. With the address locator created from the reference data, I try to geocode the addresses for that state.

I am immediately getting an error that says "Create Feature Class: There was an error trying to process this table."

This error is very vague and frustrating, please help!

Re: Geocoding Issues

JoeBorgione — Sun, 06 Mar 2011 02:27:42 GMT

Take a look at the field names in the spreadsheet. If there are any special characters or spaces in the field names it'll choke.

Re: Geocoding Issues

RebeccaSeel — Wed, 09 Mar 2011 15:41:45 GMT

Did you figure out the problem, and/or the solution? I am having the same issue and believe there is a better way than individually reviewing 100,000+ addresses. If you would, plaease share how you are working around this problem.

Good luck!

Hello;

I am using ArcGIS 9.3 and am having trouble geo-coding. I am trying to geo-code entire states at one time. I am using 2010 TIGER files as my reference data, which are projected to NAD83. My addresses are in a Excel .xlsx file that I added to ArcMap. With the address locator created from the reference data, I try to geocode the addresses for that state.

I am immediately getting an error that says "Create Feature Class: There was an error trying to process this table."

This error is very vague and frustrating, please help!

Re: Geocoding Issues

JoeBorgione — Wed, 09 Mar 2011 21:06:03 GMT

I'm not suggesting to look at each record, just the field names of the address table. However, you may also want to look for <null> values within the actual records. I don't like using spreadsheets for address tables; I'd rather upload them into some flavour of geodatabase. The select tool is good for listing all the values in any field including <null>; you let the machine do the work, right?!

Re: Geocoding Issues

DanielBirmingham — Sun, 13 Mar 2011 00:35:56 GMT

Hello, I solved the issue. Joe was right. It was the field name headings that were an issue. Knowing this previously, I took all special characters and spaces out of the names and replaced them with underscores. This was still crashing the geo-coder. To fix this, I removed all the fields except for address, city, zip, and state. The geo-coder ran after this fix. I will add these fields back in after I am finished geo-coding. Good luck.