Remaining SOP Items (updating as needed)

[KCI-Ablowers]

Collector, S123, ETL, Etc.

Currently in SOP

• [x] Guide for creating local copy, editing, and sync of feature service data - features

• [x] Note: Do not edit schema by adding or delete fields, altering field properties, etc.

• [x] Note about verifying inventory data when performing inspection

• [x] GPS Validation in S123 form.

• [x] Note: GPS Point validation in S123 shows red unless 1. a point is selected or 2. gps location not within threshold. Also note that it is currently not required to send the form.

• [x] Note: Red Star/asterisk = Required

• [x] Adding/Editing for Photos after submitting survey - Can not be done through S123, Would have to happen through the feature service.

• [x] Possible issue with WiFi Triangulation not catching location at first. (possible solution - bookmark bmps that will be inspected ahead of time in the webmap or my places)

• [x] Replace smart sketch section with standard camera and file upload description and walk-through

• [x] Navigate to the root and then search for “*.jpg”. copy photos to one folder

• [x] the ETL will also prefix photos with 'FACNOTFOUND' instead of a valid SWMFAC number

• [x] Don't cover up image features with text

• [X] add image guides?

• [x] Recommended fields in swmfac and table with recommended values from ETL3.

• [x] Downloading and storing photos

• [x] Change Georeferencing section to arcmap

• [X] Feature service editing workflow using arcmap

• [x] Photo upload from devices (Attachments)

• [x] Firms and use in Collector, Survey123, feature services, ETL1, 2, and 3

• [x] Note: Image attachments may not include GPS/Exif data

• [x] Running of ETLs

• [x] Web UI

• [x] Update editing in WAB with either "Smart Editor" and/or "Edit" widget #206

• [x] Inspection feature service wiped everytime data is pushed through ETL (Field to Source) 3 - based on firm

• [x] Note: Not editing in same area when performing field edits or edits to the feature service in general and an offline/disconnected copy for desktop editing.

• [x] Survey methods - Photos at time of inspection or take them on camera and attach (include note about 3,4, & 5 ratings)

• [x] Removing and rotating photos

• [x] All photos should be taken landscape

• [x] Replace field names with alias'

• [x] If adding new swmfac, number will need to be updated in production. notify SHA. SWMFAC_No - Given by SHA, left null, have to push through production if new BMP added in the office.

• [x] Mifi/internet connection, battery backup, 12v usb car charger.

• [x] inspections wiped (by firm) when ETL 3 is run and sent box on field devices should be cleared

• [x] extent of digitizing upstream and down stream - proposed = all, proposed to existing = flowing in and out, existing = verify and add if flowing in and out

• [x] Include link from S123 troubleshoot site about retrieving surveys and photos from device

• [x] AGS to AGOL transfer via NPDES FDM

• [x] Add note - To add more than 1 photo, you must hit the plus sign, otherwise, you will over write the photo taken in "spot 1 of 1"

• [x] NPDES FDM guide

• [x] Note about autofill

• [x] Note: Survey123 editing limited to submitted user via inbox and limits types of surveys (ones with 3,4,5 ratings) from being edited. All editing should most likely take place in sent box_

• [x] once submitted, inspections "firm" field will be marked with "Submitted_" and the Firm name. Ex: Submitted_KCI_1 so they are not caught by the sync and submit processes moving forward. This occurs during the "Submit updates for review" process

• [x] inbox user specific, sent box device specific (do not clear sent box til surveys are 100% and submitted, or at all)

• [x] Edits for surveys with required photos must happen in "sent" box - Do not wipe sent box until inspections are 100% complete and accurate in the feature service.

• [x] Note about auto snapping

• [x] Inspections must be synced via NPDES FDM after they are validated/QAQCd each time (? Check with John)

• [x] Contract, Owner, Metadata addition workflows #200 - Add record (offline), run UI with lookups, while reviewing ETL issues, update meta, contract, and owner. #235 (recheck the workflow described in Data management v1.4)

• [x] NPDES FDM to download and view inspection records and photos

• [X] Editing Criteria for existing features

• [x] NPDES FDM Delete function

• [x] SAVE button now present in editing widget for geo and attribute edits

• [x] Removing duplicate inspections and photos workflow. In field QC version?

• [x] Ditch conveyance work flow- multiple vertices will be removed during "Validate field changes" process - https://github.com/kcigeospatial/MDOT-SHA-NPDES-Next-Gen/issues/137

• [x] AirDrop suggestion in photo section https://github.com/kcigeospatial/MDOT-SHA-NPDES-Next-Gen/issues/221

• [x] Note: Surface condition and structure access condition in export BMP Inspections CSV from NPDES FDM should be blank if not performing an "Underground facility inspection".

• [x] Edit Mode

• [x] sent now/send later tip (wifi/signal, can be sent at any time). Include note about outbox pushing all surveys at once using send button in bottom right hand corner.

• [x] firm view

• [x] Firm based suvery

• [x] Full NPDES FDM walk through with screenshots for most recent version

• [x] Note: RSR_STRC = NPD, then _OPEN, _SEDI, _TRASH and _VALV will be blank in the export BMP Inspections CSV from NPDES FDM.

• [x] Check #127 and confirm updates made

• [x] add/delete photo workflow

• [x] Workflow (if possible) for editing subjects and comments of inspections photos via sent.

• [x] When adding a comment to 2A Swale (SWMFAC), the comment must be added AFTER the existing comment. DO NOT DELETE any status or type comment (including 2A swale).

• [x] #156

• [x] Viewing/editing surveys in desktop

• [x] add note about confirming the date of inspection when editing/updating or reentering inspections.

• [x] check/update description of flattened fields - Flattened table and populating related fields in structures/conveyance feature for use in ETL3.

• [x] Confirm geometry edits

• [x] QAQC workflow for inspection edits

• [x] Editing related tables - Structure Issues table

• [x] Add note that if a standard or advanced license isn't available for arcmap "offline" editing, it should be completed in either the editing webmap or collector.

IDDE & UG

• [ ] #119
• [ ] #117
• [ ] #160

In Progress or Not in SOP

Remaining Questions/ Need Verification

• [x] the ETL script writes 'XX' for a county code when it cannot find the corresponding SWMFAC in the database for a given BMP inspection
• [x] data that is removed, overwritten, etc. through each section of the ETL process.
• [x] SHA Standard for Submittal @brentreeves75 (Sub sends email to SHA(HHD) for ETL1 and data reviewer situation)
• [ ] Make a screenshot of the Photo SOP for the form (#74)
• [x] what is cleared out after the push to SHA and back around to field version (check with jogn)
• [x] Note for NPDES FDM Section - EMB and Dam Height ETL error can be ignored when processing in the NPDES FDM.
• [ ] QC Workflow - Inside "SHA Intranet" and Diagrams - Visio
• [x] Confirm Apps and Maps, naming, thumbnails, purpose, metadata, etc.

[talllguy]

Viewer apps are shut down, so you can remove those items from the SOP list.

[KCI-Ablowers]

Comment auto restart/downtime at 3 am everynight

[KCI-Ablowers]

Update Metadata, Contract, and Owner Table record section with workflow for adding new record, lagtime/feature service restart, and selecting record in drop down. Confirm note about "V_{FIRM VERSION}:" is in place.

[KCI-Ablowers]

Add large note about collector classic and collector

[KCI-Ablowers]

@johnshiu & @talllguy Can you guys think of any questions I have asked or things I have reached out to clarify over the last few months? I will be working on a new version of the Data Management guide to go along with the training in January. A couple things I have already made notes about or added:

• Metadata, Owner, and Contract new record entry, feature service restart, and "versioning" of added records in domains (ex. "V-KCI_1:")
• Note about collector and collector classic

[KCI-Ablowers]

Expand on NPDES FDM process, QC process, submittals, errors/correcting errors

[KCI-Ablowers]

Add note about running validate after syncing BMP inspections

[KCI-Ablowers]

Add note about not using true curves when editing in ArcMap (if they are accpeted on sync or not)

[KCI-Ablowers]

Add note about using Find tool not find/replace in ArcMap when doing offline and sync workflow

• visible layers to all layers

[KCI-Ablowers]

Add appendix for "new" collector with screen shots.

[KCI-Ablowers]

Add quickstart guide/hot tips page at the beginning.

[talllguy]

@KCI-Ablowers FYI I updated the create feature templates so that the various grouped types appear separately as their type. Before, you'd see five different "Manhole / Types" and now each one is listed:

[KCI-Ablowers]

https://github.com/kcigeospatial/MDOT-SHA-NPDES-Next-Gen/issues/298

[KCI-Ablowers]

I will be working on updating the Data Management guide to a new version before inspections begin.