|
|
 Cities
| Postal Codes
| Structures
| Water
| Land
North American US ZIP Codes Database
Professional Edition
Available licensing:
COMMERCIAL, Non-Profit, Redistribution
| Pricing |  |
 Professional Edition
Commercial Server | For 1 database server
in a commercial environment
with multiple connected clients
located at a single company location
| | Commercial Server, June 2010: | | Commercial Server Professional Edition | $ 129.95 Buy Now |
| with Quarterly updates* | $ 194.95 Buy Now |
| with Monthly updates* | $ 259.95 Buy Now |
Upgrades for previous versions: | | Commercial Server Professional Edition | $ 77.95 Buy Now |
| with Quarterly updates* | $ 116.95 Buy Now |
| with Monthly updates* | $ 155.95 Buy Now |
|  Professional Edition
Commercial Site | For unlimited database servers
in a commercial environment
with multiple connected clients
located at a single company location | | Commercial Site, June 2010: | | Commercial Site Professional Edition | $ 194.95 Buy Now |
| with Quarterly updates* | $ 292.45 Buy Now |
| with Monthly updates* | $ 389.95 Buy Now |
Upgrades for previous versions: | | Commercial Site Professional Edition | $ 116.95 Buy Now |
| with Quarterly updates* | $ 175.45 Buy Now |
| with Monthly updates* | $ 233.95 Buy Now |
|  Professional Edition
Commercial Enterprise | For unlimited database servers
in a commercial environment
with multiple connected clients
located across multiple company locations | | Commercial Enterprise, June 2010: | | Commercial Enterprise Professional Edition | $ 389.95 Buy Now |
| with Quarterly updates* | $ 584.95 Buy Now |
| with Monthly updates* | $ 779.95 Buy Now |
Upgrades for previous versions: | | Commercial Enterprise Professional Edition | $ 233.95 Buy Now |
| with Quarterly updates* | $ 350.95 Buy Now |
| with Monthly updates* | $ 467.95 Buy Now |
|
|
Need Non-Profit licensing?
Need Redistribution licensing?
*One time cost for a 1 year subscription
Product Overview | |
| Geo-enabled enhanced database of US ZIP Codes with latitude/longitude coordinates. Perfect solution for any application requiring distance calculation of US ZIP Codes, finding a list of US ZIP Codes within a specific radius from a central point, or to place points of US ZIP Codes in a custom mapping solution. |
|
| Product Summary | | North American US ZIP Codes database - Professional edition - June 2010 release. Database contains 80,295 entries with ZIPs, cities, counties, states and lat/lon coordinates. |
|
| Product Detail | | - Updated monthly
- Subscriptions plans available
- Discounted update pricing available
- Most accurate and timely source of data
- Comprehensive list of US ZIP Codes and related items: 80,295 entries
- Streamline user input - create standardized lists of us zip codes
- Complete list of every active and official US postal code
- All entries geo-coded with latitude / longitude coordinates
- Calculate global distances between US ZIP Codes, you and your customers
- Find the nearest US ZIP Code to your location
- Locate all US ZIP Codes within a specified radius from a central point
- Place points of US ZIP Codes in a custom mapping solution
- Also included: a custom Microsoft Windows DLL component that calculates the global distance between any two us zip codes with latitude longitude coordinates. Easy to install and simple to use, it works with all Windows-based programming languages. A $49.95 value included for FREE!
|
|
Product Features
The us zip codes database is comprised of the types of features listed below:| Feature type | # of
entries | Description | | US ZIP codes | 79,738 | all official United States postal codes, 5-digit ZIP codes |
| Total | 79,738 | |
|
| Product requirements | | - 447 KB free disk space for compressed file
- 1,059 KB free disk space for uncompressed data files
- WinZIP or other similar PKZip archive extraction utility
- SQL Server, Oracle, MySQL, PostgrSQL or other database software application capable of importing 80,295 records from a standard tab-delimited ASCII text file.
- Sufficient free disk space for database software application to import the data files and create necessary supporting index files (varies depending upon software).
|
|
North American country summary breakout
[ display full breakout ]
# of
entries | Region | # of
countries | | 79,738 | North America | 1 |
| 79,738 | Totals | 1 |
|
Database fields available in the Professional Edition| Zipcode table | | Field | Data type | Field description | | ZIPCode |
char(5) |
Zone Improvement Plan code. A 5-digit U.S. Postal Service code that identifies a specific geographic delivery area. ZIP Codes can represent an area within a state, an area that crosses state boundaries (unusual condition), or a single building or company that has a very high mail volume. |
| CityName |
char(28) |
Name of a city, USPS entity (such as a post office or station), community, municipality, urbanization (Puerto Rico only), or local alias name. |
| Lat |
numeric |
Latitude in decimal degrees of approximate center of zip code area. Latitude will be 0.0 for military and over seas post office boxes (where CityName=APO, FPO). |
| Lon |
numeric |
Longitude in decimal degrees of approximate center of zip code area. Longitude will be 0.0 for military and over seas post office boxes (where CityName=APO, FPO). |
| PreferredCityName |
char(28) |
The preferred USPS city name used for mailings. |
| CountyName |
char(25) |
The name of the county or parish in which the 5-digit ZIP Code resides. If APO/FPO, then the county name will be blank. |
| StateCode |
char(2) |
A 2-character abbreviation for the name of a state, U.S. territory, or armed forces ZIP Code designation. If APO/FPO, then the state abbreviation will be AA, AE, or AP. |
| ZIPCodeType |
char(1) |
Specifies the type of ZIP code.
M = military ZIP Code
P = ZIP Code having only post office boxes
U = Unique ZIP Code, ZIP assigned to a single organization
Blank = Standard ZIP code with many addresses assigned to it. |
| CityNameType |
char(1) |
Specifies whether the CityName field contains the organization name for a unique ZIP Code.
Y = The CityName field is an organization name
Blank = Standard CityName field. |
| PreferredCityNameType |
char(1) |
Specifies whether or not the CityName field can be used for mailing.
Y = CityName is a USPS-approved mailing name
N = CityName is not approved for mailing purposes. |
| AreaType |
char(1) |
The type of locale identified in the CityName field. The facility may be a USPS facility, such as a post office, station, or branch, or it may be a non-postal place name.
B = Branch
C = Community post office (CPO)
N = Non-postal community name, former USPS facility, or place name
P = Post office
S = Station
U = Urbanization |
| CarrierRouteSortType |
char(1) |
Identifies where automation Carrier Route rates are available and where the comingling of automation and non-automation mail, including Enhanced Carrier Routes and 5 digit presort, on the same pallet or in the same container is allowed.
A = Carrier Route rates are available (Y) and merging is permitted (Y).
B = Carrier Route rates are available (Y) and merging is not permitted (N).
C = Carrier Route rates are not available (N) and merging is permitted (Y).
D = Carrier Route rates are not available (N) and merging is not permitted (N). |
| CarrierRouteDeliveryType |
char(1) |
Specifies whether or not a post office has city-delivery carrier routes:
Y = Office has city delivery carrier routes
N = Office does not have city-delivery carrier routes. |
| CountyFIPS |
char(3) |
The Federal Information Processing Standard (FIPS) code assigned to a given county or parish within a state. In Alaska, it identifies a region within the state. |
| |
|
|
Data products that improve your business!
Meridian World Data offers geographical databases, lists and gazetteers of world-wide features and global locations containing officially recognized place
names, latitude/longitude coordinates, administrative regions, countries and distance calculations.
7.1+ million geographic features and ZIP codes. 270+ countries and
territories. Comprehensive global listings.
Put Meridian World Data to work for your business - custom datasets and applications to meet your company's needs.
--The world is now within your grasp!
|
