PHP Classes

File: ZipCodesTableDoc.txt

Recommend this page to a friend!
  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: 20 years ago
Size: 946 bytes
 

Contents

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. (http://www.census.gov/geo/www/gazetteer/places.html) 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.