Bailey and Potter, CPA

TTG, Incorporated: Professional Territory Design Software Since 1988

News...

TTG announces new AlignStar Users Forum available to all AlignStar users (login required). Go to the Forum...

New International Map Sets Available for over 200 Countries. More...

Belgium Territories

Geocoding Services Available now in both the US and Canada. More...

2007C ZIP Codes now available for download. More...

18,000 Demographic data variables available for immediate delivery. More...

In the words of our clients...

arrow"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...!!!"   

arrow"This product is simply amazing!  Within 2 hours, AlignStar allowed me to accurately and equitably assign opportunity for our new segment. Without AlignStar, this task would have been practically impossible. We were so impressed with the product's ability to create equitable, contiguous territories that we decided to use it to first analyze and then redesign the entire territory layout."

arrow"I think that this program is great. I used (another product) and I know what it can do, but AlignStar can do all that and more, but a lot easier to operate." 

Join Our Growing List of Client Companies ...

ADT, Inc.
Akorn, Inc.
Alliance Bernstein
All-State Legal
American Express
American Greetings
Ameriprise Financial
AmeriSource Bergen
Animas Corporation
Apple Inc.
Applied Systems, Inc.
Astellas Pharma
Avaya
Azur Pharma, Inc.
Baxter Healthcare
Berchtold Corporation
bioMerieux, Inc.
Boehringer Ingelheim
Booz Allen Hamilton
Bradley Pharmaceuticals
Campbell Alliance
Caris Diagnostics
Caterpillar, Inc.
CCS Medical
CDW
Ceco Building Systems
Centrix Pharma
Choice Hotels Int'l
Christian Broadcasting
CIVCO Medical Solutions
Clean Harbors
Conmed Corporation
CooperSurgical
Coria Laboratories
Critical Therapeutics
Demdaco
DHL Worldwide, Inc.
DIGIKIDS, Inc.
Duro-Last Roofing, Inc.
DxTech
DynaVox Systems
ECR Pharmaceuticals
EKR Therapeutics, Inc.
EMC
EMC / Paradigm
EMD Serono, Inc.
Empi
Enerpac
Enzon Pharmaceuticals
Essilor
FAF Advisors
Fidelity Investments
GAF Materials Corp.
Gambro BCT, Inc.
Gas South, LLC
Genzyme Corporation
Gerber Coburn
Graceway Pharma
GreenPoint Mortgage
Guidant Corporation
Healthpoint, LTD
Henry F. Michell
Hill-Rom
Hologic
ImClone Systems
Instrumentation Labs
Intuitive Surgical, Inc.
Inverness Medical
JT International, Inc.
K Concepts, Inc.
Kensey Nash
Komatsu America, Inc.
Legg Mason, Inc.
LexisNexis
Liquid Capital Corp.
L'Oreal
Luxottica Group
Innovex
Matritech, Inc
Medicure Pharma
MedPointe Healthcare
Medrad, Inc.
Michelin Tire
Mitchell 1
Mohawk Finishing
Monogram Biosciences
Myriad Genetics, Inc.
Nestle Nutrition
NEUROMetrix, Inc.
New Balance, Inc.
Newquest
NIP Group
Novartis
OrthoNeutrogena
Oscient Pharmaceuticals
Otsuka Pharma
Ovation Pharma, Inc.
Pamlab, LLC
Paycor
PharmARC
Pharmion Corporation
PHH Mortgage
Publicis Selling Solutions
Purdue Pharma
Pyramis
Questcor Pharma, Inc.
Quidel
Reliant Pharmaceuticals
RIA Group
SalesForce.Com
Sanofi Pasteur for VaxServe
ServiceMaster
Siemens Medical Solutions Diagnostics
Simonds International
SirsiDynix
Smith & Nephew, Inc.
Smiths Medical
Springs Window Fashions
Stericycle, Inc.
Stryker Instruments
Sulzer Pumps, Inc.
Swiss Masai US
Synygy, Inc.
T.F. Hudgins, Inc.
TA Instruments
Temple-Inland
Tesa Tape Inc.
Thermage, Inc.
Thermo Fisher Scientific
Trinity Partners
Trulife
Tura L.P.
Tyco Healthcare
Uline
Welch Allyn, Inc.
Wireless Capital
Wolters Kluwer
Xerox Corp.

 

2007C 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 2007C 5-digit ZIP Code map file release for TTG’s AlignStar software. This release is available to clients with current AlignStar Enterprise or Corporate edition licenses.


Last updated 01/22/2008.

Contents:

  1. General information
  2. Opening AlignStar documents after installing new ZIP Code files
  3. Installed file set
  4. Changes to the ZIP Code roster
  5. Download

1) General information-

These map files generally reflect the U.S. Postal Service ZIP Code roster as of September, 2007 (ZIP Codes are continually created and eliminated as necessary by the USPS). The 2007B ZIP Code roster and map file set consisted of 41,688 ZIP codes. The 2007C release consists of 41,734 ZIP Codes after the addition of 47 new ZIP Codes and the deletion of 1 old ZIP Code. From the 2004B release to present, there have been 393 deletions and 259 additions. 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".

Back to top.

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.

Back to top.

3) Installed file set-

The following files are installed by the ZIP Code update package:

Filename Date
US_Zip5.tmc 1/17/2008
US_Zip5.adj 1/8/2008
cartxref.tbl 1/17/2008
smartzip.tbl 1/2/2008


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.

Back to top.

4) Changes to the ZIP Code roster-

The following is a list of the ZIP Codes that existed in the AlignStar 2007B ZIP Code map file but do not exist in the 2007C map file (deletions).

ZIP ZIP Name
85236 HIGLEY


The following is a list of the ZIP Codes that DID NOT exist in the AlignStar 2007B ZIP Code map file but do exist in the 2007C map file (additions).

ZIP ZIP Name
03285 THORNTON
03861 LEE
10065 NEW YORK
10075 NEW YORK
17202 CHAMBERSBURG
22551 SPOTSYLVANIA
29707 FORT MILL
32163 LADY LAKE
33449 LAKE WORTH
33472 BOYNTON BEACH
33473 BOYNTON BEACH
33545 WESLEY CHAPEL
33578 RIVERVIEW
33579 RIVERVIEW
33596 VALRICO
33646 TAMPA
33973 LEHIGH ACRES
33974 LEHIGH ACRES
33976 LEHIGH ACRES
34291 NORTH PORT
49037 BATTLE CREEK
55101 SAINT PAUL
73012 EDMOND
73025 EDMOND
78633 GEORGETOWN
78665 ROUND ROCK
80023 BROOMFIELD
80902 COLORADO SPRINGS
85083 PHOENIX
85238 MARICOPA
85240 QUEEN CREEK
85266 SCOTTSDALE
85286 CHANDLER
85293 CASA GRANDE
85294 CASA GRANDE
85295 GILBERT
85298 GILBERT
85392 AVONDALE
85395 GOODYEAR
85658 MARANA
89034 MESQUITE
89054 LAS VEGAS
89508 RENO
91008 DUARTE
92058 OCEANSIDE
94505 BYRON
95811 SACRAMENTO

 

5) Click here to visit your download page (login required).

 

Copyright 1990-2008 by TTG Inc., Burlington, MA, All Rights Reserved

Back to top.


AlignStar®, SalesAdvantage® and BatchMap® are trademarks of TTG, Incorporated. All other products mentioned are registered trademarks or trademarks of their respective companies.

Home | Contact Information | Webmaster

155 Middlesex Turnpike
Burlington, MA 01803
1-888-REALIGN