How To: Determine which geocoding indexes go with which geocoding service
When a geocoding service is deleted, the index or indexes created are not removed automatically. Instructions provided describe how to determine which indexes coincide with which geocoding service.
The naming structure of the geocoding and Alternate Names indexes are based on two parts. This allows for multiple geocoding indexes to be created for the same feature class.
The geocoding index is described in steps 1 and 2, while the Alternate Names index is described in steps 3 and 4.
This article only refers to geocoding in ArcGIS 9.1 and older.
- The first part of the geocoding index is based on the style of locator that was used to create the geocoding service. These are outlined below:
Single Field GC_KS
US Alphanumeric Ranges GC_GR
US Alphanumeric Ranges Zone GC_GRZ
US Cities with State GC_CTS
US Hyphenated Ranges GC_HY
US Hyphenated Ranges Zone GC_HYZ
US One Address GC_SS
US One Address with Zone GC_SZS
US One Range GC_SS
US One Range with Zone GC_SZS
US Streets GC_SS
US Streets with Zone GC_SZS
World Cities with Country GC_CTS
- The second part of the name is the derived from the ID of the feature class in the GDB_Objectclasses table.
A geocoding index with the name SZS6 would mean that a geocoding style of 'US Streets with Zone' was used, and that the reference feature class had an ID value of 6 in the GDB_Objectclases table.
- Any geocoding service that has an alternate names table has an alternate Names index. This is named like the geocoding index described above but with a few minor differences.
The first part of the alternate names index is based on the style of locator that was used to create the geocoding service. These are outlined below:
US Alphanumeric Ranges (A) GC_ALGR
US Alphanumeric Ranges Zone(A) GC_ALGRZ
US Hyphenated Ranges (A) GC_ALHY
US Hyphenated Ranges Zone(A) GC_ALHYZ
US One Address (A) GC_ALSS
US One Address with Zone (A) GC_ALSZS
US One Range (A) GC_ALSS
US One Range with Zone (A) GC_ALSZS
US Streets (A) GC_ALSS
US Streets with Zone (A) GC_ALSZS
- The second part of the name is the derived from the ID of the alternate names table in the GDB_Objectclasses table.
An alternate names index with the name ALSZS7 would mean that a geocoding style of 'US Streets with Zone' was used, and that the reference table had an ID value of 7 in the GDB_Objectclases table.
- Find the geocoding index table for an ArcSDE Geocoding Service
- Enable geocoding error logging
- Troubleshoot common geocoding problems when using ArcSDE