CTANS+Prototype+Database

We are investigating the data management needs of the CT DEP with respect to Aquatic Nuisance Species Early Detection, Reporting and Management Information.

 In addition to investigating the currently available databases online, we are developing a prototype database with the help of an undergraduate student, Vlad Alexandrescu working on an independent study project.

The purpose of Vlad’s project, relative to our work, is to help us flush out our information needs. While we are not proposing at this point that CT use Vlad’s database, we are hoping that in the process of developing this prototype database specifically to meet CT needs as best we can, that the resulting discussion will at a minimum help us more clearly identify those needs and see whether or not existing databases like EDDMapS can meet them.

Vlad is working on 4 main tasks: 1) Creating data entry forms for Early Detection and Reporting and for Management Actions 2) Capturing data from those forms and storing it in a database over the web 3) Developing a draft database design (schema) that would be eventually be compatible with EDDMapS and IPANE 4) Generating sample queries and reports related to management actions and their associated costs

So far Vlad has two draft forms up on the web and has had some success in getting data from the forms into a database. We’re going to be cleaning them up in the next few days, and would like to share them with you after that. They are just meant as “conversation starters” and not intended to be the final word on any of this. They are not yet “pretty” and are just bare bones, graphically. We don’t want to spend a lot of time on the details of layout, color, etc. and are mainly focusing on the pieces of information needed.


 * LINKS TO THE PROTOTYPE DATABASE **

Links to Vlad's work in progress can be found on the CTIWR project web page at: []