Add Zip Code/Distance function to Find page
Posted: Sat Aug 13, 2011 9:21 am
Hello all,
I am looking to create a calculation function and a search function for my database, and ideally add it to the Find page (or, alternatively, to a separate page accessible via menu tabs).
First, I need to calculate the number of fire departments within a certain distance of a zipcode that have certain types of equipment. For instance, how many fire departments within 10 miles of zip code 07075 have a NIMS Type I Fire Engine? So, I would need to enter a central zip code, specify a search radius, match the zip code to coordinates, run the coordinates through an algorithm/function, and get the list of results.
I have what looks to be a great php function from Micah Carrick (http://www.micahcarrick.com/php-zip-cod ... ation.html); I also have a listing of US fire departments with zip codes and a listing of US zip codes with coordinates (both of which are already installed in my database). Perhaps someone has some experience in working with this?
Second, I need to figure out where within Xataface to incorporate this function.
Any thoughts on how to get started would be appreciated!
TYIA,
-manifold
I am looking to create a calculation function and a search function for my database, and ideally add it to the Find page (or, alternatively, to a separate page accessible via menu tabs).
First, I need to calculate the number of fire departments within a certain distance of a zipcode that have certain types of equipment. For instance, how many fire departments within 10 miles of zip code 07075 have a NIMS Type I Fire Engine? So, I would need to enter a central zip code, specify a search radius, match the zip code to coordinates, run the coordinates through an algorithm/function, and get the list of results.
I have what looks to be a great php function from Micah Carrick (http://www.micahcarrick.com/php-zip-cod ... ation.html); I also have a listing of US fire departments with zip codes and a listing of US zip codes with coordinates (both of which are already installed in my database). Perhaps someone has some experience in working with this?
Second, I need to figure out where within Xataface to incorporate this function.
Any thoughts on how to get started would be appreciated!
TYIA,
-manifold