You have chosen to sponsor your bid up to a maximum amount of .
Looking for assistance in creating a simple Google Earth API template.
The Google Earth application will need to simulate a "live feed" look of placemarks appearing on the map marking points in time of when something happens. We have an existing file that includes lat, long, date/time, and placemark type. It is in the following format (This is a sample only):
TYPE OPEN_DATE LATITUDE LONGITUDE
placemarkType1 10/23/2011 20:18 35.1842 -80.761
placemarkType2 10/23/2011 20:21 30.3063 -89.2712
placemarkType3 10/23/2011 16:56 27.393 -80.9859
placemarkType1 10/24/2011 20:10 35.4499 -97.4065
placemarkType2 10/24/2011 13:40 41.463 -81.4607
placemarkType3 10/24/2011 15:30 39.7632 -89.6072
placemarkType1 10/24/2011 9:07 43.0934 -77.8863
placemarkType2 10/24/2011 9:07 41.3789 -104.8708
placemarkType3 10/24/2011 1:26 38.1816 -84.5298
placemarkType1 10/25/2011 17:33 40.4528 -80.1651
placemarkType2 10/25/2011 17:33 45.3919 -65.9679
placemarkType3 10/26/2011 22:55 39.4616 -80.2526
placemarkType1 10/26/2011 22:57 37.359 -120.5828
placemarkType2 10/26/2011 22:57 28.022 -80.5797
placemarkType1 10/27/2011 15:44 33.0844 -96.8471
placemarkType2 10/27/2011 15:47 32.8162 -96.6841
placemarkType3 10/27/2011 16:30 30.303 -97.7385
placemarkType1 10/28/2011 16:24 35.6281 -79.1829
placemarkType2 10/28/2011 15:53 42.216 -83.493
placemarkType3 10/28/2011 17:08 37.3977 -87.2774
placemarkType1 10/28/2011 23:24 33.4515 -111.7361
placemarkType1 10/28/2011 23:24 31.2683 -94.7415
This data extends for one full week. Unlike the above sample data, there will be many more records. There will be approximately 160,000 records per day - or about 1.1 million records for the full week. This data can be placed in a MySQL database and outputted via PHP as needed. We would need you to write that PHP code if implemented that way.
For example, if a user calls up the web page on Friday November 18th at 16:35, it begins to display Friday's records (in the case of the sample data above, 10/28/2011 data - there is only 1 week of data) and shows records starting at 16:35 on that day and then continually querying and showing records from that point forward as the application is running... 16:36 adding new records one by one... simulating as if these incidents are happening now. This webpage is intended to be running virtually all day on a computer screen. Essentially replaying 10/28/2011 data as if it were happening today in real time.
The placemark icon should also be different based on the "type" field in the above data (for now, you can make it any placeholder... we can modify the actual URL later)
In a private message with you bid, please describe in general how you would handle the "feed" of placemarks to the Google Earth API instance (for example, a query every minute to a KML output generated by a PHP script from a MySQL database... or however you recommend to do it to accomplish the goal and maximize performance if the user interacted with the interface to "fly into" a particular region on the map)