ToDo

ToDo List

This list includes items predominantly related to the database that are pending and include a request data and a status. When items are solved they are moved to the DONE section.

Public web site

• Single login for the main web site and the phppsqladmin site (Wiki already shares the login) (april 2011, in progress)
• Guest account: we shoud have a guest account with password "guest" with very restricted access, but who can see for example birdview with the tracks of one or two ('donated') birds. (may 2011, in progress)

Data model, processing

• Adapt parser for new firmware (V 1.0.35) format (July 2011, high priority, in progress)

• Enable uploading tables to the database (for example to our personal schemas). For example, we would like to flag gps points with behaviour classes based on our accelerometer data and then store this information so that it can be reused (in short annotate data). Is there any way you can facilitate this process. Otherwise analysis has to be rerun locally every time, which is very time consuming. (april 2011, high priority)

• Add 2D speed to the speed calculates in the uva_tracking_speed view (rename speed to 3D_speed). (July 2011, low priority)

• Add direction to calculations in uva_tracking_speed view. (July 2011, low priority)

• Automated upload and import UvAGPS metadata which should include a web form and webservice(July 2011, low priority)

• Add function for computation of elevation (and perhaps azimuth) of sun above the horizon for each gps point. This would provide users with the possibility to determine whether a point is measured during the day, at twilight (elevation lets users decide if they want civil or nautical twilight) or at night. An example script can be found in the R script crepuscule.R which is part of the maptools toolbox and would extract the value “solarpos”. Michael Kemp can provide more information on script usage and examples (m.u.kemp@uva.nl) day start, day end to mark whether a data point is at night or during the day (June 2011, low priority)

• Verify whether there are still users using Irods (June 2011)

• Accelerometer data: based on the current data model, we cannot properly sort accelerometer measurements that are not coupled with a GPS fix, an extra field in the accelerometer table is probably needed. (march 2011, very low priority)

Administration

• List of access rights: user's rights must be set consistently to make sure that all users have the correct rights to see data (april 2011);
  • add a description of the user's rights fields, instead of the database names for rights (may 2011)
  • add a project data table; assign projects to users or users to projects; link bird access to projects
  • Note: this account should have very limited rights, and should not be able to change the own password (otherwise one guest could make it impossible for other guests to see the site)

BirdView (for Tijs de Kler)

• Initial view should be Waddenzee, not The Netherlands or Europe, icons should be updated(march 2011)

• Fix UvAGPS KMZ generator (color range, symbol selection) (november 2010)

Finished

• BirdView: I noticed that the upload option for kml files from a local directory includes kml only, can we extend the support to kml and kmz files? The http upload does actually support both. (solved July 2011)

• Data upload: Birds are starting to return from migration and we have a lot of new data to upload to the database from our various base stations. Currently data can still be uploaded manually via winSCP as we did last year. However we discussed that we need to automate this procedure. How should we handle the data upload now and in the coming period. Our new field season is also beginning. Will digital drop box work or do we use iRODS, please let me know what is best. If we need a separate short and long term solution that’s fine, but I really need this new data uploaded to the database. (26/04/2011) iRODS is currently running and being monitored by Lykle, is a temporary solution an replacement is being sought

• Student access: We have several students that need access to the flysafe server for their thesis projects, specifically to the GPS and ECMWF schemas. I think you mentioned that people with a user name and login can access the server from any of the IP addresses in IBED, is this still the case? Below are the student names, their e-mail address and the period they should be provided access. If you need any additional information let me know. I can distribute their user names and passwords to them if you like. (solved April 2011)

• Quality control: Users with write rights can flag data points manually in the database through pgAdmin. Data cannot be queried but must be viewed through the data viewer to edit. Currently data is manually flagged by J. Shamoun-Baranes (solved April 2011)

• QC & functions: When only a subset of data (say data approved from QC) is queried, the distance and direction functions work on the subset, there is an option to run these functions on all data - but not by default (april 2011)

• Metadata: Excel files are either sent to SARA and then uploaded to the database or uploaded manually (March 2011)

• List of user's rights: a script was written to quickly produce an overview of all users and their rights (12-05-2011)

• Make a readonly copy of Flysafe Wiki on public server (september 2010)
• Improve UvA GPS parser to log errors such as CRC8 in database (september 2010)

• Implement service to create graphs for UvAGPS devices according to Willem's Matlab scripts (october 2010)

• Import UvAGPS log files via standard storage facility (november 2010) Has been implemented using Dropbox

• Define and implement service to flag invalid GPS tracks (november 2010)

• Add accelerometer calibration factors to uva_device (september 2010)