Architeture

Planing Meetings and Architure - 4 hrs

Database - 8 hrs

The database will be replaced with Azure Table and blob storage.

Instead of a run based system that we have had in the past it will be a network/ river basin based system each new spill from a client will overwrite the last spill and it's results.

We will likely not want to put flows data into the Azure table or blob storage. It may be easier to query the Flows DB that we already use.

The partition key and Row Key are required for Azure blob storage the rest of the data are part of the grab bag of the azure storage and are not techicly required.

The Partition key should be the user if we are using a client log in. this is the same funtionality we have had in NSWC and if we are not ready for client log in then it can be one user id for everyone. The row key should be the river basin / network we are using for the spill.

Spill and sim params will of course be part of the grab bag.

The results CXPLT and CTPLT Results should be brought back as Blob Storage. Simillarly to how SWMM results are brought back.

Django API - 15 hrs

Since we are changing the database and the front end and changing from C# to Python Django it will likely take less time to just create the new API from Scratch. That being said the Old API calls

React Front End - 20 hrs since we will likely be changing and adding to what I have below.

This will have at least 3 pages so far. Spills Page - User inputs spill params and can modify the sim params. then make a run. Map Page - Map of the spill. (plume and flows if we are getting data from Flows page posibly more info? velocity...) Graph page - CXPTL and CTPLT graphs.

Funtion app - 20 hrs

Take the current RSMS Run and turn it into a Funtion app. What does the RSMS engine need. What part of RSMS needs to be put into the Funtion app.

NOTE: I am not including the Setup on the azure part of the funtion app.

NOTE: This is not using up all my time I am keeping more to what the ideal would be but I imagine that at some points there is going to be over and some under. Currently I have 67 hrs accounted of the 80 accounted for.

I am sure you can tell that the Database is the part of the project I keep thinking about.