Devam Ediyor

522698 Create Coldfusion Component to get nearby zipcodes

I have a mySQL table full of zipcodes and their related latitude and longitude. I need a cfc/query to find zipcodes within X (#range#) miles from a given latitude and longitude coordinate.

The output should be a list of zipcodes (ie. 92110,92115,92116,92118) within a defined distance.

table: zipcodes

|ZIPCODE|CITY|STATECODE|STATENAME|LATITUDE|LONGITUDE|

Attached is a small section of the "zipcodes" table.

Beceriler: Her şey Kabul, ColdFusion, MySQL

Daha fazlasını görün: range query, coldfusion list, zipcode city, list coordinate, fusion table, mysql output table, mysql create table, mysql distance, distance table, list component, create attached table mysql, zipcode distance, create mysql table, city longitude, coldfusion mysql, mysql range, create table, cfc, table create, distance mysql, mysql distance longitude, fusion cfc, create city, distance city, coldfusion table

İşveren Hakkında:
( 3 değerlendirme ) San Diego, United States

Proje NO: #2268636

Seçilen:

kabirchy

lets do it. can help you get this done. Thanks

2 gün içinde 100$ USD
(929 Değerlendirme)
8.4