ZIP/postal code lookup table should be moved to the database

Bug #1365073 reported by Galen Charlton
20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Evergreen
New
Wishlist
Unassigned

Bug Description

It would be handy if the table used for the patron address-auto-populate by ZIP/postal code were stored in the database rather than in a text file on the app server -- and if there were a staff-accessible UI for updating it.

If this change were made, additional blue sky ideas to consider at the same time:

[1] For cases where a postal code is used by more than one city, adding a way for circ staff to select the appropriate one during patron registration.
[2] Adding scoping of the postal code table by OU, to control the visibility of selected entries and to allow libraries and systems to override the cities returned for a given ZIP code.

Another relevant bug for revamping this feature is bug 1196393.

Evergreen master

Tags: admin-pages
Revision history for this message
Rogan Hamby (rogan-hamby) wrote :

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).

Revision history for this message
Garry Collum (gcollum) wrote :

To point out how messy the ZIP/postal codes map to actual towns take a look a this: https://tools.usps.com/go/ZipLookupResultsAction!input.action?resultMode=2&postalCode=41017

A structure in which we could map multiple ZIPs to towns would be desirable.

Revision history for this message
Rogan Hamby (rogan-hamby) wrote :

Unless someone else has designs I'm going to take a stab at this.

tags: added: admin-pages
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.