NOTE: The JCSZip database, developer version, used in most functions in the site,
is NOT included with the subscription to the JCSPhone database, and must be licensed separately.
In April 2000, the JCSPhone database contains approximately 120,000 Area Code and Exchange records from the US and Canada. At the beginning of each month, the database is properly updated with any area code splits occuring that month, and a new version of the database is published. Each record contains sufficient information for full proximity calculations between Area Code/Exchanges, and allows integration of the phone numbering systems between the US and Canada.
The JCSPhone database is supplied as an ACCESS 97 database, and/or as a comma-delimited flat file. A new issue is available each month, and the database is available as an annual subscription only. At the end of the twelve months, the subscription must be renewed, or use discontinued.
The database has the following fields:
Country (US and Canada)
Latitude (in both degrees and radians)
Longitude (in both degrees and radians)
Recent split from Area Code
When coupled with the JCSZip Database, available separately, the JCSPhone database provides significant power for the following:
Area code conversion details, with the ability to KNOW what zip codes are valid as they are near.
Dealer locators by either Zip code or Area code/Exchange.
Sources to determine what Overlay Area Codes / Exchanges are assigned, and where.
Much more power / flexibility for assigning territories by either zip code or area code / exchange.
We use, as a basis for our database, the Melissa Data's Software "fone*data" File. We have purchased a subscription to their service, and purchased the ability to remarket the data to our customers, after we have formatted the information, and added our value added fields.
Because the file on which we base our database is only available as an annual subscription, we offer the same to our customers. Just as our subscription with Melissa Data expires at the end of one year, and must be renewed at the then prevailing rates, our subscriptions with our customers will, too.
We receive updates from Melissa Data quarterly, and we research area code/exchange information each month, and we apply appropriate changes to our value added data. We publish an updated version of the JCSPhone database each month, on about the 5th of the month.
Our database is implemented as an ACCESS 97 database, and the logic to access the system, calculate distances, and display results are contained in the ACCESS 97 database, and/or in the ASP pages supporting our web site, www.jcsm.com. If the ACCESS 97 option is not desirable to the subscriber, the ACCESS 97 information can be exported to comma delimited files, and reimplemented by subscriber personnel. Probably most easily implemented would be those who use Visual Basic, or similar systems, and those who use Microsoft based server systems. Of note, we supply all logic in source code form, and the customer personnel will not find portions of logic hidden from them, such that they will be locked to Jay Computer Services if they should want to change to another data source in the future.
The cost of an annual subscription is $299, if coupled with a subscription to the JCSZip database, developer's version, or $399 if subscribed to separately from JCSZip.
A simple subscription agreement can be downloaded here.
For your convenience, we have our own secure credit card ordering server. (Note that the first page displayed is the product catalog. This page is not secured, but, at the bottom of the page, the "Add to Shopping Cart" button will enter the secure server to protect both your information, and your credit card information). Subscribers may use Visa, MasterCard, Discover, or AMEX to order the following product "JCSPhone Database" when the subscriber clicks to link to the JCS secure ordering server. If you link to the secure server, and experience any problems, please call 952-469-5898, collect. We want to be sure that you have ample opportunity to order.
If you would like more information about the JCSPhone or JCS Area Code / Zip Code Database Subscription, click to send Email to Bud Jay.
For those customers who desire, Bud Jay will consider contracting with users for custom interfaces, further development, and assisted installation. Click to send email to Bud Jay for a quote on custom services.
If you like what you see on these pages,
We have a growing list of available products and options relating to the data displayed by these pages and the logic supporting the calculations. To see what is available, Click here.
We apologize for any inaccuracies.
Click to send us Email, or phone us at cell 952-210-4234.
All information © Jay Computer Services, 1998 through 2017