"My biggest struggle right now with AlignStar is that it is too easy to use. I have loaded (our) information to build a document and this took about 5 minutes. Way too short a time, scares me. No really, the product is excellent... OUTSTANDING...!!!" 2003B ZIP Code Map File Release Notes
TTG, Inc.
155 Middlesex Turnpike
Burlington, MA 01803
Phone: 781-272-8979
Fax: 781-272-8981
Email: support@alignstar.com
Internet: http://www.alignstar.com
This file contains information about the 2003B 5-digit ZIP Code map file release for TTG’s AlignStar software.
Last updated 09/08/2004.
- General information
- Opening AlignStar documents after installing new ZIP Code files
- Installed file set
- Changes to the ZIP Code roster
These map files generally reflect the U.S. Postal Service ZIP Code roster as of July, 2003 (ZIP Codes are continually created and eliminated as necessary by the USPS). Our next map file update will follow this release by approximately six months. The 2003A ZIP Code roster and map file set consisted of 41,931 ZIP codes. The 2003B release consists of 41,874 ZIP Codes after both the deletion of 91 old ZIP codes and the addition of 34 new ones, representing a net loss of 57 ZIP Codes. For a complete listing of additions and deletions, see section 4 of this file.
*Note: Deleted ZIP Codes are maintained in AlignStar's SmartZip table. If the SmartZip feature is enabled, data in linked files will be automatically associated with the new / current ZIP Code. For more information, please look in the AlignStar online help system under "SmartZip".
2) Opening AlignStar documents after installing new ZIP code files-
The first time you run AlignStar after installing a ZIP Code update, AlignStar may have to rebuild a geographic relationship table, referred to as a cross reference (or xref) table. This process can take anywhere from three to twenty minutes depending on the speed of your computer. AlignStar will only have to perform this function the first time it is opened after the update.
Given the deletions and additions in the ZIP Code roster, there will be both ZIP Codes and associated data which no longer exist in as well as new ZIPs which will initially appear as unassigned (gray) on your map. You may assign the new ZIPs to your sales hierarchy as appropriate (a convenient way of assigning units within AlignStar is to use the Auto Align feature found on the Alignment menu. For detailed info on how to use Auto Align, see your AlignStar online help system), however you will need a way of dealing with the ZIPs and associated data which will no longer link in AlignStar. There are several ways of dealing with these records:
- You can contact the U.S. Postal Service to find out what the new ZIPs for those locations are and assign hierarchy info to the new ZIPs as appropriate. (A good way to resolve ZIP Codes via the USPS is by using their website at www.usps.com, or http://www.usps.com/ncsc/lookups/lookup_ctystzip.html).
- You can ‘fold’ the data for the old ZIPs into adjacent ZIPs.
- If the SmartZip feature in AlignStar is enabled, most if not all of the data associated with old / deleted ZIPs will automatically be associated with the proper ZIP Code. Please see the AlignStar help system for more information on SmartZip.
- The Save Data Source feature provides a way of exporting a list of records updated by SmartZip. Please see the AlignStar help system for more information on Save Data Source.
The following files are installed by the ZIP Code update package:
| Filename | Date |
| US_Zip5.tmc | 10/14/2003 |
| US_Zip5.adj | 9/18/2003 |
| cartxref.tbl | 10/16/2003 |
| smartzip.tbl | 9/18/2003 |
The *.tmc file on the list contains the updated cartography set for AlignStar and is copied to your \AlignStar\maps subdirectory. The file that ends in “.adj” is an adjacency table required by the optimizer and is also copied to your \AlignStar\maps directory. The “cartxref.tbl” file is the AlignStar cross-reference table and is copied to your \AlignStar directory. Smartzip.tbl is used with the SmartZip feature, and is also copied to your \AlignStar directory.
4) Changes to the ZIP Code roster-
The following is a list of the ZIP Codes that existed in the AlignStar 2003A ZIP Code map file but do not exist in the 2003B map file (deletions).
| 03232 | EAST HEBRON |
| 04782 | STACYVILLE |
| 06337 | GLASGO |
| 14003 | ALABAMA |
| 14601 | ROCHESTER |
| 19370 | STEELVILLE |
| 22953 | MADISON MILLS |
| 24289 | TRAMMEL |
| 24373 | SEVEN MILE FORD |
| 24379 | VOLNEY |
| 24841 | HAVACO |
| 24877 | POWHATAN |
| 24883 | SKYGUSTY |
| 24889 | TWIN BRANCH |
| 25018 | BENTREE |
| 25095 | GRIMMS LANDING |
| 25182 | SHARON |
| 25519 | GLENHAYES |
| 25623 | HAMPDEN |
| 25645 | STIRRAT |
| 26328 | BLANDVILLE |
| 26350 | GILMER |
| 26375 | INDUSTRIAL |
| 26407 | MOUNTAIN |
| 26503 | MORGANTOWN |
| 26522 | BOOTH |
| 26533 | EVERETTVILLE |
| 26535 | HAZELTON |
| 36270 | NEWELL |
| 36431 | BURNT CORN |
| 36586 | WALKER SPRINGS |
| 36778 | SNOW HILL |
| 36779 | SPROTT |
| 41849 | SECO |
| 44238 | HUDSON |
| 44803 | AMSDEN |
| 45781 | TORCH |
| 51059 | TURIN |
| 52055 | LITTLEPORT |
| 54203 | BRANCH |
| 54444 | KEMPSTER |
| 56076 | OAKLAND |
| 57244 | HETLAND |
| 57358 | LANE |
| 57462 | MINA |
| 57557 | MISSION RIDGE |
| 57647 | PARADE |
| 57774 | PROVO |
| 60080 | SOLON MILLS |
| 62709 | SPRINGFIELD |
| 62720 | SPRINGFIELD |
| 62913 | CACHE |
| 63646 | GLOVER |
| 63753 | GRASSY |
| 63838 | CONRAN |
| 63871 | PASCOLA |
| 63947 | HIRAM |
| 64687 | WAKENDA |
| 64751 | HORTON |
| 65433 | BENDAVIS |
| 65540 | LECOMA |
| 65659 | GOODSON |
| 66450 | LOUISVILLE |
| 66727 | COYVILLE |
| 68737 | FOSTER |
| 68880 | WEISSERT |
| 69349 | HENRY |
| 72071 | HOWELL |
| 72610 | ALCO |
| 73177 | OKLAHOMA CITY |
| 73180 | OKLAHOMA CITY |
| 73575 | DUNCAN |
| 76555 | MAYSFIELD |
| 76677 | PERRY |
| 77462 | NEWGULF |
| 77839 | CLAY |
| 80254 | DENVER |
| 81013 | PUEBLO |
| 81014 | PUEBLO |
| 81015 | PUEBLO |
| 81074 | STARKVILLE |
| 83551 | SPALDING |
| 83620 | FRUITVALE |
| 83788 | BOISE |
| 83862 | SAMUELS |
| 88429 | MOUNT DORA |
| 91050 | PASADENA |
| 91051 | PASADENA |
| 92712 | SANTA ANA |
| 95931 | COLLEGE CITY |
| 96845 | HONOLULU |
The following is a list of the ZIP Codes that DID NOT exist in the AlignStar 2003A ZIP Code map file but do exist in the 2003B map file (additions).
| 03593 | RANDOLPH |
| 07390 | JERSEY CITY |
| 07699 | TETERBORO |
| 19195 | PHILADELPHIA |
| 20528 | WASHINGTON |
| 28312 | FAYETTEVILLE |
| 45025 | HAMILTON |
| 45026 | HAMILTON |
| 45950 | CINCINNATI |
| 48102 | ALLEN PARK |
| 53548 | JANESVILLE |
| 55199 | SAINT PAUL |
| 60491 | LOCKPORT |
| 60689 | CHICAGO |
| 72198 | WEST LITTLE ROCK |
| 74019 | CLAREMORE |
| 80113 | ENGLEWOOD |
| 89136 | LAS VEGAS |
| 92081 | VISTA |
| 93314 | BAKERSFIELD |
| 94158 | SAN FRANCISCO |
| 94199 | SAN FRANCISCO |
| 94875 | RICHMOND |
| 98077 | WOODINVILLE |
| 98089 | KENT |
| 98113 | SEATTLE |
| 98127 | SEATTLE |
| 98139 | SEATTLE |
| 98141 | SEATTLE |
| 98165 | SEATTLE |
| 98175 |