Geocoding Issues

[DanielBirmingham]

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!

[JoeBorgione]

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.

[RebeccaSeel]

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!

[JoeBorgione]

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?!

[DanielBirmingham]

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.