Rhok-philly is a project mainly written in PYTHON and PERL, it's free.
Code from Philadelphia's Random Hacks of Kindness
For more information on project goals, see the http://www.rhok.org website at: http://www.rhok.org/problems/real-time-climate-data-comparison-platform
Create the database and define tables: python import.py -c
Import ground station data: python import.py -g
Import satellite data: python import.py -s
Query functions and graphing functions are in analysis.py. Current usage requires specifying the graphs to generate via function calls at the bottom of analysis.py.
[ ] Investigate bugs in NASA importing (getting correct months?) [ ] Extend the range of graphing functions and abstract some of the query structure for flexibility. [ ] Change source of ground data to use ftp source. [ ] Create functions to update database with new weather data and automate checking ftp / online sources [ ] When graphing, handle -99 values from data sources that were not available in certain years.
Current solution requires deleting those values from the database. See CLEANUP for explanation. Proposed solution: a "cleanResults" function to remove stations & data from the query results [ ] Create an online CGI interface for specifying data to display. [ ] Overlay .png graphs on map image.
Proposal: Use Image Magick.