PHP Classes

File: ZipCodesTableDoc.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Classes of Scott Mattocks  >  Zip Codes Range  >  ZipCodesTableDoc.txt  >  Download  
File: ZipCodesTableDoc.txt
Role: Documentation
Content type: text/plain
Description: Database Documentation
Class: Zip Codes Range
Finds zip codes within distance of other zip code
Author: By
Last change:
Date: 10 years ago
Size: 946 bytes


Class file image Download
The zip code table must contain at least three columns, one each for the zip code, the longitude,
and the latitude.  Other columns in the table are not used.  The default column names are zip,
lon, and lat.  Different column names may be used by calling the setZipColumn, setLonColumn, and
setLatColumn methods.  The name of the table defaults to zips but may also be changed using the
setTableName method.  The data needed for this class to operate properly can be obtained for free
from several sources on the internet. One such source is the U.S. government census bureau.
(  This class was tested using the 1990 zip
code file as the 2000 ZCTA file was not available when work started.  The 2000 ZCTA file has a 
different format (represents longitude and latitude as +/-) which may have unexpected results.
For help creating the database table see the documentation for your RDBMS.