38 | | - knpa to add 2010 and 2013/14 values to web portal. |
39 | | - 2d graph needed. |
| 41 | The area/time selection tool uses information from a postgres database. |
| 42 | |
| 43 | This database holds the same information as the CSV files, which were read in with the following script: |
| 44 | ~knpa/grimm/input_file.csv |
| 45 | |
| 46 | The database is currently on knpa's machine (knpa to remember to change before he goes). |
| 47 | |
| 48 | I wrote down what I needed to do to create the database and configure it. In case this is needed again (you may need the command to restart it if the server goes down for example), this information is here:[[BR]] |
| 49 | [wiki:settingUpPostgresDB How to set up an configure a postgres database] |
| 50 | |
| 51 | |
| 52 | |
| 53 | === Other scripts === |
| 54 | |
| 55 | Phil's script to create the CSV files in real time: |
| 56 | |
| 57 | A script I wrote to extract "vertical profiles" from the data: |
| 58 | |
| 59 | === Things to be fixed/improved === |
| 60 | |
| 61 | - Improve speed of area/date search |
| 62 | - Return area/date search results in a way that can be easily downloaded |
| 63 | - add 2010 and 2013/14 values to web portal. |
| 64 | - 2d graph needed |