NAME OF SYSTEM: ZIP Code Data Retrieval ORIGINATOR: National Education Association (NEA) 1201 16th Street, N.W., Washington, D.C. 20036 O B J E C T I V E . To evaluate and select a data retrieval system that will provide a fast and efficient method for looking up postal Z I P Codes so that they may be added to the mailing addresses of Association members. Also, to provide a simple, inexpensive method for updating data in the Z I P Code directory. B A C K G R O U N D . The National Education Association ( N E A ) represents the professional interests of about one million teachers in the United States. The advent of the Z I P Code and the requirement for bulk mailers to add geographical code elements to each mailing address created data retrieval problems for the N E A . Their initial need was to determine the best method for retrieving Z I P Code information for inclusion on the N E A master mailing list. The basic method for accomplishing this task was the Post Office Department's bulky, 1,800 page National Z I P Code Directory. Its page format comprises five columns of alphabetically arranged listings of States, cities, towns, and streets, with Z I P Codes shown for each entry. The manual Directory search routine consisted of finding the member's State, followed by an alphabetical rundown of the State's city or town, and finally the street address. The Z I P Code would then be noted on the member's master address card. To alleviate this tedious and time consuming method of finding and posting Z I P Codes for over a million members, the N E A study group recommended adoption of the Z I P Code Data Retrieval System employing microfilm strips. 148 T H E N E W M E T H O D . Initially, the N E A converted the Z I P Code Directory to a magnetic tape format and arranged for a commercial firm to convert the magnetic tape information into 16-mm. microfilm through use of COM (computer output microfilm) equipment. This action was taken in conjunction with a program to mechanize the overall mailing list operation. The 16-mm. rolls of microfilm were photographed and developed, and the film was spliced into 12-inch strips, each containing 12 pages of Z I P Code information. Film strips were then mounted on plastic strip holders measuring about 14 inches long and indexed to reflect the proper geographical area. A visual index label located on the front of each plastic strip holder indicates the State to which the contained microfilm information applies. Color coding is added for ease of identification when a States's listings overlap into additional strip holders. Located on the back of each strip holder is a second and more precise index listing showing city, town, and street information, which is only visible when the holder is removed from the data file. The full Z I P Code inventory comprises 200 visible strip holders housed in a 200 slot "honeycomb" file container easily accessible to the searcher and viewing equipment. A search of the Z I P Code data file aimed at finding the Z I P Code applicable to a known address would first involve selection of the State and particular city by noting the visual index information. The selected strip holder is then manually placed in a slotted keyway on the microstrip reader. The placement of the strip holder on the reader exposes the secondary index that lists more precise information concerning street identities and microfilm strip page numbers. W i t h the page number determined, a mechanical pointer within the system is manually positioned next to the proper page number. This action causes the page image to show on the reader screen and the searcher then matches the known street address with its proper Z I P Code identity. The search task is completed when the searcher records the Z I P Code next to the rest of the address. R E M A R K S . 1 This type system has been primarily used for storing and retrieving information and data contained in listings such as catalogs, directories, and inventory lists. The basic equipment is commercially marketed but is not compatible with other microform systems. The one-time conversion of original listings to microstrip form can be a costly operation, but it results in a greatly improved information updating and retrieval operation. In addition, there are frequently other reasons why it may be advantageous to convert such listings to machine-language format, and once this is accomplished, the microstrips can be produced at a relatively low cost through COM (computer output microfilm) equipment. In the case of Z I P Code information, the user can obtain and update the microstrips for a small monthly service charge. 1 The National Education Association found that the microfilm strip system provided its greatest benefits during the initial conversion of the mailing lists to include Z I P Code entries. 149 ZIP CODE DATA RETRIEVAL I N P U T PROCESSING STORAGE SEARCH AND RETRIEVAL Zip Code Directory Microstrip File Search Request Microfilm Strip Reader Film . Processor) 16-mm Roll Microfilm Microfilm Strips Microfilm Holders 1. D i r e c t o r y of 1,800 p a g e s is c o n v e r t e d to 16-mm r o l l m i c r o film t h r o u g h s e r i e s of p r o c e s s e s . 2. M i c r o f i l m r o l l s p l i c e d into 12inch s t r i p s and m o u n t e d on p l a s t i c holders. S t o r a g e file c o n t a i n s 200 f i l m s t r i p h o l d e r s , e a c h with v i s u a l index f e a t u r e s . 1. S e a r c h e r m a n u a l l y s e l e c t s appropriate filmstrip holder. 2. S e a r c h e r o r c l e r k using selector device projects proper page i m a g e on viewing s c r e e n . *r U. S. G O V E R N M E N T P R I N T I N G O F F I C E : 1071 O - 4 0 1 - 3 8 9