PRODUCT: ALL PRODUCTS
SUBJECT: Catalog
QUESTION: Do you have a catalog of your products and services that you offer?
ANSWER: Yes, we have a catalog that you can download.
URL: http://www.tpsnet.com/catalogs/tpscatalog.pdf
PRODUCT: ALL PRODUCTS
SUBJECT: Licensing Fees
QUESTION: Is there any extra licensing fees?
ANSWER: Only if you are using the database for a product that is distributed for resale. See our license agreement at the link below.
URL: http://www.tpsnet.com/download/files/txt/license.txt
PRODUCT: ALL PRODUCTS
SUBJECT: Methods of Payment
QUESTION: What methods of payment do you accept?
ANSWER: We accept AMEX, MasterCard, VISA and Discover charge cards or checks. We do not accept purchase orders or COD's.
URL:
PRODUCT: ALL PRODUCTS
SUBJECT: Ordering Information
QUESTION: How do I order?
ANSWER: The fastest way is to order by phone by dialing 800-546-1612. You can also order online at: http://www.tpsnet.com/html/mailme.html. or by fax at 916-663-5102. You can also send a check to: TPS Products and Services, Inc 8725 Ridge Road, Newcastle, CA 95658.
URL: http://www.zipcodedatabases.com
PRODUCT: ALL ZIP CODE DATABASES
SUBJECT: Sample Data
QUESTION: Where can I get sample data of your Zip Code databases?
ANSWER: Sample data is available at our file download website.
URL: http://www.tpsnet.com/html/zip.html
PRODUCT: TIGER ZIP
SUBJECT: Latitude and Longitude Fields
QUESTION: Do you have a database that has Latitude and Longitude at a Zip+4 level?
ANSWER: Yes, Tiger Zip has that information.
URL: http://www.tpsnet.com/html/tigerzip-specs.html
PRODUCT: ZIP CODE CANADA
SUBJECT: Canadian Postal Codes
QUESTION: Do you have a database that has Latitude and Longitude coordinates for Canadian Postal Codes?
ANSWER: Yes, Zip code Canada has that information.
URL: http://www.tpsnet.com/html/ZipCodeCanada.html
PRODUCT: ZIP CODE CORRECTOR / +4
SUBJECT: Street Level Databases
QUESTION: I have a address data that does not contain a Zip Code. Do you have a database that can be used for appending a Zip Code to this database?
ANSWER: Zip Code Corrector will append a 5 digit Zip Code. Zip Code Corrector +4 will append a 9 digit Zip Code.
URL: http://www.tpsnet.com/html/zipaddress.html
PRODUCT: ZIP CODE USA
SUBJECT: Accuracy of Area Codes
QUESTION: How accurate is the Area Codes in the Zip Code USA database and how do you update it?
ANSWER: The Area codes are matched against their respective Post Offices Area Code. This data is updated quarterly. Zip Codes and Area Codes do no always line up exactly. The problem areas are in Los Angeles, New York and Chicago. In some instances, we list multiple area codes for that Zip Code. We consider our Area Codes in Zip Code USA to be 95%+ accurate. The source for the most accurate area code database is from www.telcordia.com (the copyright owners of Area Codes), however thier data does not contain Zip Codes. We do not make any modifications to the Zip Code USA’s area code field without verification.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Accuracy of Zip Code Data
QUESTION: How accurate is the Zip Code Data in Zip Code USA?
ANSWER: Zip Codes are added and deleted on a monthly basis. Zip Code USA is as accurate as logically possible since the data comes directly from the USPS on a monthly basis. The USPS is ahead of us in data by 2 to 3 weeks. The data comes to us from USPS on the 20th and is released on the 1st. If you have any questions in regards to the accuracy with the data, check with USPS Customer Support at 800-642-2914. Zip Code USA is based on the USPS "City-State-County" file. TPS is a licensed reseller of this data.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Auto Data Entry
QUESTION: I want to use ZIP Code USA for "auto entry" of State and City in my customer database, how do I do this?
ANSWER: Zip Code USA can give you multiple "Cities" as a query result. This is because there are multiple Zip Codes in many cities. We recommend for you to use Zip Code Finder or Zip Code USA JR since there is only 1 city per Zip Code in these databases.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Cities
QUESTION: Can a Zip Code be in more than 1 City?
ANSWER: Yes. This can be seen in the field 5 (City State Name). However, the USPS has only 1 "Preferred Name". This would be found in the field 10 (Last Line City Name
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Cities
QUESTION: Why is there 2 "City" fields in the database and duplicate Zip Codes in the database?
ANSWER: The "City State Name" (Field #5) contains all cities, communities or postal identities. Field #10 (Last Line City) is the "Preferred" USPS city name. There is only 1 Last Line City name per ZIP Code. There can be multiple City State Names per ZIP Code. In Zip Code USA JR fields #5 and #10 are the same.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Cost of Database
QUESTION: How much does ZIP Code USA yearly subscription cost?
ANSWER: The yearly subscription fee is $150 (12 total file downloads).
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Counties
QUESTION: Can a Zip Code be in more than 1 County?
ANSWER: Yes. However, the USPS has only the predominate county listed.. We provide a separate "Zip Codes with Multiple Counties" database to Zip Code USA subscribers at no charge.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Custom Database
QUESTION: I do not need all the data in ZIP Code USA, can you produce a custom Zip Code Database for me?
ANSWER: Yes, custom databases start at $150. Contact TPS at 800-546-1612 for a price quote.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Demonstration of Database
QUESTION: Where can I see a working Web Site using Zip Code USA?
ANSWER: We have a demonstration at the link below.
URL: http://www.zipdatafiles.com/demos/zipdemo.asp
PRODUCT: ZIP CODE USA
SUBJECT: Downloading Instructions
QUESTION: I want immediate access the ZIP Code USA. What do I need to do?
ANSWER: First download the Zip Code USA database file version you want at http://www.download.at/area1. Then have your credit card ready and phone 800-546-1612. After your order is taken by phone, you will receive a keycode for "Unzipping" the downloaded file. Your invoice and additional keycodes will be available to be downloaded at http://www.zipdatafiles within 48 hours.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Excel Files
QUESTION: Why is the Excel file format of ZIP Code USA in 2 files?
ANSWER: Excel ’97 / 2000 can not accept all the records in ZIP Code USA in 1 file.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: File Formats
QUESTION: What file formats is available for ZIP Code USA?
ANSWER: The following formats are available for downloading: Comma Delimited ASCII, Fixed Length ASCII, Dbase, Access ’97, Excel ’97, FileMaker Pro Version 5. All file formats are included on purchased CD’S. EBCIDIC and Fixed Length ASCII are available on 9-Track tape.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: File Formats
QUESTION: What file formats do I use?
ANSWER: It depends on what database program you use. For Access, use Access (.MDB), for FoxPro, Paradox, dBase or Approach use Dbase (.DBF). ASCII files are considered "Universal". Check your owner’s manual.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Finding Missing Zip Codes
QUESTION: I have the Address, State and City, will ZIP Code USA find the missing Zip Code?
ANSWER: No. Zip Code USA is not a "street level" database. You will need our Address Corrector Database.
URL: http://www.tpsnet.com/html/zipaddress.html
PRODUCT: ZIP CODE USA
SUBJECT: FTP download area
QUESTION: Can I download our monthly subscription file by FTP?
ANSWER: Yes. Host Name: ftp.tpsnet.com User ID: tps Password: tps
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Key Codes / Passwords
QUESTION: How do the Keycodes (passwords) work?
ANSWER: When you use WinZip to "unzip" the .ZIP file a box will appear. You enter the keycode in the box. PKUNZIP for DOS requires the following command line syntax: PKUNZIP <filename> -sPASSWORD <drive:\ directory> Note: Other unzipping programs may differ. Note: The same monthly keycode works with all file formats.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Media
QUESTION: Is ZIP Code USA available on CD or 9-Track Tape?
ANSWER: Yes, CD’s contain all file formats. The charge is $10 + Shipping. 9-Track tapes are available in EBCIDIC and Fixed Length ASCII 6250 BPI. The charge is $25 + Shipping.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Nearest Dealer / Store Locator
QUESTION: I want to use ZIP Code USA in a web site application that will find the nearest dealer for a product we sell. Will it work?
ANSWER: Yes. By using the latitude/longitude fields in ZIP Code USA and "joining" your existing "Dealer database" by Zip Code, you can program a query in your database. We supply you with the distance calculation formulas, We also have available Zip Code USA DTK (Developer's Tool Kit) that can be used for this application. A template ASP (Active Server Page) is included.
URL: http://www.tpsnet.com/html/zipcodeusadtk.html
PRODUCT: ZIP CODE USA
SUBJECT: Records in Database
QUESTION: Does ZIP Code USA contain all the Cities, Counties and 5 digit ZIP Codes of the US including Puerto Rico, Guam and Military Addresses?
ANSWER: Yes, and it also includes businesses and government agencies that have their own 5-digit Zip Code.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Sample Data and Specifications
QUESTION: Where can I find the specifications, distance calculation formulas, and license agreement of ZIP Code USA?
ANSWER: All information and sample data is at our downloading area.
URL: http://www.tpsnet.com/html/zip.html.
PRODUCT: ZIP CODE USA
SUBJECT: States
QUESTION: Can a Zip Code be in more than 1 State?
ANSWER: Yes. Driggs, Idaho / Alta, Wyoming both share the same post office Zip Code 83422.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Unzipping Files
QUESTION: I downloaded the file with the extension .ZIP how do I "open" it?
ANSWER: You will need an unzipping program such as PKUNZIP or WinZip. The .ZIP file contains a compressed files of ZIP Code USA and includes documentation and license information. A keycode is required for unlocking and extracting these files.
URL:
PRODUCT: ZIP CODE USA
SUBJECT: Unzipping Files
QUESTION: I Do not have an "UnZipping" Program, where do you get one?
ANSWER: These programs are available at our downloading web page. There is no charge for the "shareware" programs.
URL: http://www.tpsnet.com/html/zip.html
PRODUCT: ZIP CODE USA DTK
SUBJECT: Nearest Dealer Locator
QUESTION: Do I need to purchase Zip Code USA DTK to create a store locator website?
ANSWER: No. Zip Code DTK is available to save developement time since it contains models, examples in Access and Excel, ASP, HTML and SQL code. Also included is code to generate maps.
URL:
© 2001 TPS Products and Services, Inc