iPhone GPS to MySql Database


Center pivot irrigation machine, the machine is ¼ mile long. It revolves around a center pivot.

This pivot is a fixed known location, such as [url removed, login to view] -118.7816W.

I desire to place iPhone 4 (or newer) in a controls box, at end of machine, known as the ‘End Tower’. It will communicate via wireless powerline Ethernet adapter, back to the pivot, where there is Ethernet. The iPhone will not be carrier active on a data plan. It will be WiFi only.

I desire an iPhone app, which runs un-attended, the iPhone will be AC powered 24/7 (not dependent on battery), communicating its GPS data.

The app needs to have an interface (plain as can be, no graphics needed), to enter a device name, such as “Pivot #2”, enter the center pivots GPS location, enter server and MySql database credentials, how frequently to send its data, to the remote server database. It then needs to calculate the iPhones current compass heading, from the pivot, using the ‘Haversine Formula’. So if the end tower (and the iPhone) was due east, it would calculate that its current compass heading is 90 degrees. Straight south, it would be 180 degrees, and so forth. The calculations would be rounded to the nearest degree, 0-360.

I will use my server for this operation. Once I have this data recorded, I will extract it from the DB to utilize it as I need. I can provide you the database to use for development, or you can use yours. As you desire.

Thus the data to be sent and required fields would be

• Index number

• Device or units name, such as “Pivot #2”

• Unix Timestamp

• Time in MySql text format (it makes it easy for me to see the records time, when manually looking at database)

• The pivot latitude

• The pivot longitude

• The pivot altitude

• The iPhone/end tower latitude

• The iPhone/end tower longitude

• The iPhone/end tower altitude

• The calculated compass heading, such as “45”

Skills: GPS, iPhone, MySQL

See more: iphone gps mysql, mysql latitude longitude heading, mysql calculate heading gps, yours-24, mysql database server, looking for gps location, it degrees, i need gps, easy wireless, gps mysql, compass, iphone gps database, iphone 4, remote app for iphone, need gps, mysql iphone, mysql index, mysql database , irrigation, iphone gps app, gps name, gps location, Ethernet, database calculations, c# gps

About the Employer:
( 1 review ) Odessa, United States

Project ID: #2511958

Awarded to:


Dear Please check the PMB.

$200 USD in 5 days
(4 Reviews)

4 freelancers are bidding on average $206 for this job


Hi. Please see PMB.

$250 USD in 5 days
(48 Reviews)

Hello Respected Client, I have Read your requirements and we are very experience in this concept. Please check Message Board for more details. Thank you !

$200 USD in 4 days
(7 Reviews)

Hi, Let me know for iPhone app development.

$200 USD in 5 days
(2 Reviews)

hi, i have great expertise in iPhone and all the other mobile platform also. and also i manage a big team of mobile developers. pls see the pm. thanks

$225 USD in 6 days
(0 Reviews)