iPhone App for plotting tornadoes on Google Map

Please see included PowerPoint file for proposed screens. iPhone app to plot severe weather data on a google map with latitude and longitude values. - Will need some server side scripting (PHP) to send data to iPhone app when requested. Data will come from server side database (MySQL or other) - Overlay KML and KMZ files on Google Map (iPhone) ## Deliverables Server Side (Lynx): -Open to suggestions on technical solution. 1. PHP script to download a comma separated file (CSV) from: [login to view URL] 1.a. This file contains severe weather reports over the past 3 hours. 1.b. The PHP script will download this file every 30 minutes and parse the data within the file and insert the data into a MySQL database. No repeated data. (this is database 1 of 2). Database name: current_severe 2. PHP script to upload a file from me. (CSV format). 2.a. This file will be parsed and input into a separate MySQL database. Database name: historical_severe 2.b. Files to be imported: <[login to view URL]> 2.c. The reason for the upload php script is for me to upload the data files as they are updated from the above website. 3. Output in XML format queried data from iPhone app. iPhone and iPad app: 1. iPhone/iPad app will be used to query the 2 above MySQL databases and plot/display the data on Google map within iPhone/iPad. 1.a. The query from the iPhone/iPad will be customization by date range, storm report type, affected state, magnitude (tornado EF scale, hail size, wind speed). Option to include origin point or a track across the map based on start point and end point). Point are in latitude and longitude format. If a line track is selected, the line will be color coded based on magnitude. (see sample maps at link provided in 2.b.) 1.b. Storm plot symbols will be provided. (tornado, funnel cloud, hail, wind damage. 1.c. If user touches a storm symbol (plotted data), the text storm report will be displayed and also show distance from user's GPS location. 2. Display user's current GPS location (if user allows). 3. Option to display additional KML/KMZ files. These files are static files which will be displayed at user's request. 3.a. [login to view URL] 3.b. [login to view URL] 3.c. [login to view URL] 3.d. [login to view URL] 3.e. [login to view URL] 3.f. [login to view URL] 3.g. [login to view URL] 3.h. [login to view URL] Overall, this should be a pretty easy app (I hope). It will basically query the server, server returns data. Data is plotted on Google Map. Additionally, user may display any of the above KML/KMZ products above. Once a bidder is selected, I'll give you access to the server for the minor scripting and MySQL work. The iPhone/iPad app must be able to pass Apples guidelines for the App Store. Buyer retains all rights to the developed code and applications. * * *This broadcast message was sent to all bidders on Sunday Jul 3, 2011 1:16:17 PM: I have modified to the project to add a PowerPoint presentation which show screen layout proposals. Thanks! Bryan