Because of the complex (messy?) ways that zip/postal codes map to actual towns should we look at some kind of in db structure that allows for duplication of zips that can map to multiple townships and scope them by org unit? Then, once the org unit the patron is registered for is entered it will map the zip/postal against those valid for that org unit.
E.g. we have one zip code that maps to two different townships in different adjacent counties (which happen to be our second level org units since we're county libraries).
Because of the complex (messy?) ways that zip/postal codes map to actual towns should we look at some kind of in db structure that allows for duplication of zips that can map to multiple townships and scope them by org unit? Then, once the org unit the patron is registered for is entered it will map the zip/postal against those valid for that org unit.
E.g. we have one zip code that maps to two different townships in different adjacent counties (which happen to be our second level org units since we're county libraries).