Select to view content in your preferred language

Composites work/Singles don't...except for ZIP singles

465
2
05-17-2011 10:44 AM
AndrewDecker
Emerging Contributor
...I have a composite locator build on 7 single locators, all address points.  Each of the single locators breaks down an address point dataset by the first two digits of the zip code and then a query is applied in the composite to point the input to the right single locator.  The goal is to reduce the search from 8 million points down to something more reasonable and generally works well.

The composite works and geocodes fine including the locator output field which is attributed with the correct single locator.

All of a sudden, I can't run my datasets on the singles.  They were working fine the other day.  I am having some issues with SP2 and just reinstalled from the website along with the geocode patch for composite memory leaks. 

The really quirky thing also is that I can't run my datasets on a single streets locator either (dual range), same error.  But I can run my single zip code locators.

This is all on the same input dataset.    It will geocode on the composite but not the singles (except zips).  I have tried removing nulls where some address parts are missing and I have left them. 

However a different dataset will geocode on everything, no problem.  I've been using my problem datasets fine for weeks.

I've gone back and recreated everything fresh twice now.  It's not rocket science.

Sorry to sound so confusing but welcome to my world.  I can't make this stuff up.

To summarize:
How can a dataset (with or without nulls) geocode through a composite okay, but none of the particpating single locators, NOR geocode through a single streets locator, BUT will geocode through a single zip locator?
Tags (2)
0 Kudos
2 Replies
AndrewDecker
Emerging Contributor
UPDATE:

I've traced the issue back to my source tables.  The tables that don't work started their life as .csv's.  They made their way into tables of the same schema, but only those don't work.  I've tried making NULLS into blanks (there are some missing attributes-but that shouldn't matter) but that didn't matter.

So to summarize:
my standalone fGBD tables that originated from .csv fail to geocode at a certain consistent record (I don't see anything erroneous about any of the data) in the single locators that are referenced in a composite locator, but DO work IN the composite.  The non-.csv original source tables that in the identical schema in the fGDB standalone tables work fine in all singles and all composites.  The tables that fail in the single locators only fail in single house and streets locators.  My single zip locators run the tables fine.

...something in .csv formatting that the singles don't like (except for my single ZIPs) but the composite does....something about how the composite translates or standardizes the input differently from the singles...
0 Kudos
AndrewDecker
Emerging Contributor
UPDATE:

I just ran a few tests of the same datasets that were erring out previously on a machine with 10 on it (no SP's) and it ran fine.  While this test did not have SP1 on it, SP1 did work also.  It was the install o SP2.  Beware Geocoders....
0 Kudos