Attachment JL.18 SOP Field Data Collection and Management.pdf

STANDARD OPERATING PROCEDURE

Vieques Electronic Data Entry SOP

I. Purpose This SOP provides general guidelines for entering field data into the hand-held electronic data collection devices utilized on Vieques during the munitions response site investigation and remediation activities; the devices are Apple iPad Minis that are commonly referred to as personal digital assistants (iPads).

II. Scope This is a general description of the data collection process using the ESRI’s Collector, Survey123, and Enterprise portal systems along with the associated forms developed and loaded to the data collection devices. Log books are needed to properly document all field activities in support of data evaluation and possible legal activities.

III. Equipment and Materials

• Apple iPad Mini with the ESRI’s Collector and Survey123 projects loaded

IV. Procedures and Guidelines The procedures for using the iPads will vary by user/team. The processes for each team are outlined below:

All Teams:

• If Collector and Survey123 are not already open on the PDA, go to the Home screen and tap the logos for both.

• Confirm that the maps and forms you need are included as “On Device” in Collector and in “My

Surveys” in Survey123 to have them operable in the field.

• All forms can be opened in Survey123 or by taping a 30 meter grid in the Collector map

• Enter the MEC Daily form:

o Tap Vieques Form 3A MEC Daily from the My Surveys list and then “Collect” at the bottom of the 3A details page o Enter in information about the team for the day o Tap the check mark at the bottom of the form when done; choose “Save this survey in the Outbox”

• Enter a MEC Operations form for each Grid:

o Tap Vieques Form 3B MEC Operations from the My Surveys list and then “Collect” at the bottom of the 3B details page o If 3B is launched from the Collector map, the Grid Cell will be auto-complete with the name of the grid that was tapped to show the form list o Select a Grid and enter the Operation type from the drop down list for the work to be performed and enter your Start Time o When work finishes in that grid, enter End Time and % Change o Tap the check mark at the bottom of the form when done; choose “Save this survey in the Outbox”

• Enter an Items Found form to enter items:

o Tap Vieques Form 3C Item Found from the My Surveys list and then “Collect” at the bottom of the 3C details page

Attributes collected for items are entered into the pre-loaded form. At the end of each day the data will be loaded into the Vieques MR database. The data attributes identified below are recorded through the forms and will appear in the database:

Surface MEC Data Attributes Date Grid Operation Type Team Name Item Group Item Class Item Category Type/Filler Description/Fuzing Quantity Depth Weight Inclination Orientation Demo Required Moved To Treatment Comments o The form uses the current GPS location of the iPad to record the coordinates of the item; the location can be adjusted inside the map at the bottom of the form o A photograph of the item can be saved to the database by tapping the camera icon at the bottom of the form o Tap the check mark at the bottom of the form when done; choose “Save this survey in the Outbox”

QC/QA :

• Enter a MEC Operations form for the Grid:

o See description above for the 3B MEC Operations form o Enter the appropriate QC or QC operation type from the list

• Enter a QC/QA Grid Form:

o Tap Vieques Form 3D QC/QA from the My Surveys list and then “Collect” at the bottom of the 3D details page o Enter QC/QA information into the form and choose Pass or Fail at the bottom o Tap the check mark at the bottom of the form when done; choose “Save this survey in the Outbox”

To edit data that has been entered:

• Tap on “Outbox” at the bottom of each form’s detail page

• Each form that has been completed since the iPad was last sync’d with the database will be listed

• Tap on a row to re-open a complete survey and edit

• Tap the trash can logo on the right side of the row to delete the completed survey