Classify Zip Code Text For Free

A ZIP+4 Code or 9-Digit-ZIP Code is a 4-digit code added to the end of a 5-digit ZIP Code. The last 4 digits of each 9-digit ZIP Code indicate specific delivery routes of roughly 1-20 mailboxes, and the five digits before the +4 Code indicate the destination post office or delivery area.

As of 1963, zip codes' numbers are determined by a few factors: the area, the regional postal facility and the local zone. The first number of the five-digit code signifies the region which the address is located in, a number that grows from the east coast to the west.

ZIP code mapping is a method of analyzing data in relation to ZIP codes. It is usually used in comparison analysis and territory definition. As the most granular boundary dataset, it allows a more exact analysis of business data.

ZIP Codes are numbered with the first digit representing a certain group of U.S. states, the second and third digits together representing a region in that group (or perhaps a large city) and the fourth and fifth digits representing a group of delivery addresses within that region.

Zip codes are always 5 characters, hence you would need a CHAR datatype, rather than VARCHAR. The first takes 5 bytes per zip code. The second takes only 3 bytes per zip code. The ZEROFILL option is necessary for zip codes with leading zeros.

There are four primary types of ZIP codes: PO Box, Unique, Military, and Standard. PO boxes are located at the post office itself; unique codes refer to individual addresses; US military bases overseas have a domestic mailing address; and standard codes designate everything else (i.e. the normal ones).

A ZIP+4 code uses the basic five-digit code plus four additional digits to identify a geographic segment within the five-digit delivery area, such as a city block, a group of apartments, an individual high-volume receiver of mail, a post office box, or a specific delivery route meaning the actual path the mail truck