Migrate District Monitoring spreadsheet content to Aquarius

[mmannion]

Note: As we find new Location properties in DM spreadsheet that need to be in model, update ticket #189

Mapping of District Monitoring Spreadsheet to Aquarius

• Tags
  • Assignee
  • Visit frequency
  • Data collection interval
• Location Notes
  • Priorities
• Extended Attributes
  • ?
• Not migrated
  • Last visit
  • Will derive this in ArcGIS reporting from most recently submitted survey

To Do

• [ ] @kprice-TLH @craignwf Test if tags are usable in the way we expect (i.e. easily report by tag)
• [ ] @kprice-TLH Move content from District Monitoring spreadsheet to Aquarius
• [ ] @craignwf Export asset management data (formerly from District Monitoring) from Aquarius to file
• [ ] @mmannion Update geodatabase data loader to read from Aquarius asset export instead of District Monitoring

[kprice-TLH]

Removed the following columns from the District Monitoring Spreadsheet

• AA: Blue Tag
• AB White Tag
• AC: Current Tag
• AF: Sensor Blue ID
• AG: Senor White Tag
• AH: Sensor Current Tag
• AK: T.B Blue ID
• AL: TB White ID
• AM: TB Current ID
• AN: Water Quality Sensor
• AO: WQ Serial #
• AP: WQ White ID
• AT: blank