kcigeospatial / Inlet-Field-and-Web-App-Configuration

Tracker for the Inlet Cleaning app
https://arcg.is/1imOaC
0 stars 1 forks source link

Inlet Cleaning AGOL Schema update to v2.4.9 #61

Open talllguy opened 5 years ago

talllguy commented 5 years ago

Updating the form to v2.4.9 required some schema modifications to the AGOL-hosted cleaning data model. These modifications are detailed in other :octocat: issues or in ✉️ .

Status Name Type Length Alias Domain Description Issue Ref
INSPECTR string 11   None Field for inspector initials. The inlet program managers opted to forgo in lieu of relying on AGOL creator.  
CLEAN_STATUS_V2 string 40 Clean Status with Pipe None Updated cleaning status field with logic for pipe cleaning. This is an intermediate variable and should be ignored. #41
REL_MD_DISTRICT small integer   MDOT SHA District None District for the inlet, carried over from collector. May be null if source inlet has null district #49
QC_STATUS short   QC Status D_QC_STATUS (see #53) QA/QC Status field with a domain (picklist) #53
QC_STATUS_COM string 256 QC Status Comment None Additional QA/QC comments if desired #53
QC_STATUS_DATE date   QC Status Date None Date of last QA/QC check #53
QC_INITIALS string 5 QC'er Initials None Initials of QA/QC personnel #53
CLEAN_TEAM string 25 Team None Cleaning team for dashboard/auditing #48
⚠️ REL_MD_MSHOP small integer   MDOT SHA Maint. Shop Probably/TBD Pending new field for shops #59
talllguy commented 5 years ago

@johnshiu of all of these items, I'd say only CLEAN_TEAM should copy to the ICP