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, latitude longitude table, list coordinate, fusion table, mysql output table, mysql create table, mysql distance, mysql longitude latitude, distance table, list component, create attached table mysql, zipcode distance, create mysql table, city longitude, latitude query, coldfusion mysql, mysql range, create table, cfc, table create, distance latitude longitude, distance mysql, mysql latitude longitude

İş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