Statewide Stormwater Field Maps Manual_v3.pdf

STATEWIDE STORMWATER MAINTENANCE APPLICATION

FIELD MAPS AND WEB APPLICATION MANUAL

STATEWIDE STORMWATER MAINTENANCE APPLICATION

Contents iOS

Online Editing

Map Features

Form Fields

Maintenance Inspections

Web Application (For Desktop Use)

Navigation within the Web App

Smart Editor

Filter Widgets

Structure/Conveyance Review Filter

Desktop Review Workflow

Export to CSV

Follow-Up Recommendation Review

Symbology

Reporting

IOS ONLINE EDITING

Online Editing

1. Once the ArcGIS Field Maps application is downloaded, you will choose the Sign In with ArcGIS

Online option on the app’s login page.

Click continue when “Field Maps” asks to use “arcgis.com” to Sign In.

2. The application will prompt you to sign in. Select Your ArcGIS organization’s URL and enter gdot into the box.

3. You will then sign in with the username and the password you created during registration.

4. In the Maps view, choose the

Statewide Stormwater Program group.

5. From the Statewide Stormwater

Program group, open the

Stormwater Maintenance

Inspections – Field User map.

6. When the map has loaded, zoom to

GDOT Right of Ways to select stormwater features and view their conditions.

Map Features

Layers - View and toggle layer visibility by clicking the layer icon on the top right corner of the screen.

The application contains inspections from both the DAII statewide program and the MS4 inspection program.

You have the ability to toggle layers based on each program.

Note: Only turn on and off the top Grouping name.

DAII and MS4 group layers on.

DAII and MS4 group layers turned off.

DAII layer group turned off.

MS4 layer group turned off.

ID Search – Search specific Structure or

Conveyance IDs by clicking the magnifying glass icon on the top right corner of the screen.

Navigate to Basemaps, Bookmarks, Map

Legend, Markup tool, Measuring tool, and

Share Map by clicking the three blue dots on the top right corner of the screen.

IOS FORM FIELDS

Form Fields

STRUCTURES FORM

Contractor: The contractor that mapped the structure.

Structure ID: The unique ID for the structure.

Installation Date: The date the feature was installed if applicable.

Structure Type: The structure type.

Structure Material: The material the structure is made of.

Invert Depth: The depth of the structure.

Throat Depth: The depth of the structures throat if applicable.

Inlet Type: The type of the inlet if structure type is inlet.

Outlet Type: The type of the outlet if structure type is outlet.

Headwall Type: The type of headwall is structure type is headwall.

Endwall Type: The type of endwall if structure type is endwall.

End Section Type: The type of end section is structure type is end section.

Catch Basin Type: The type of catch basin if the structure type is catch basin.

Junction Type: The type of junction if structure type is junction.

Manhole Type: The type of manhole if structure type is manhole.

Spillway Type: The type of spillway if structure type is spillway.

Flume Type: The type of flume if structure type is flume.

Miscellaneous Type: The type field for a structure that does not match any other type field.

Anti-Theft Device: Presence of anti-theft device (Y/N).

Outside Connection: If there is an outside stormwater connection intersecting into GDOT’s structure.

Latitude: The latitude of the structure.

Longitude: The longitude of the structure.

Active: Is the structure in use? (Y/N)

District: The GDOT district the structure is in.

District Area: The GDOT district area the structure is in.

County: The county the structure is in.

Route ID: The GDOT LRS ID the structure is located on.

Route: The route the structure is on.

Milepost: The milepost of the structure based on the GDOT LRS.

Google Link: A link to the structure on Google Maps.

Maintenance Status: The current maintenance status based on the most recent maintenance inspection.

Blockage: The blockage percentage recorded from the most recent inspection.

Condition: The condition recorded from the most recent inspection.

Follow Up Inspection Status: The status of the Inversa follow up inspection, if recommended.

Reported to District Before App: The date the structure was reported to the district before importing into the field maps app.

STRUCTURE INSPECTION FORM

Structure ID: The unique ID for the structure.

Inspection ID: The unique ID for the inspection.

Inspector: Name of Inspector.

Inspection Date: The date the inspection was performed on.

Active Status: Is the structure in use? (Y/N) Structure Blockage: The blockage recorded during inspection.

Structure Condition: The condition reported during inspection.

Structural Defects: The defect recorded during inspection.

Erosion Type: The type of erosion observed.

Inspection Notes: Text field for inspection remarks.

Corrective Action: The recommended maintenance action.

Corrective Action Notes: Text field for corrective action remarks.

Surface Area: The type of ground cover observed around structure.

Active Water: Active water running through structure (Y/N).

Illicit Discharge Present: (Y/N) Reported: Severe structural defect reported to GDOT District (Y/N).

Reported Date: The date the severe structural defect was reported Data Collection Method: The data collection method used.

CONVEYANCE FORM

Contractor: The contractor that mapped the conveyance.

Conveyance ID: The unique ID for the conveyance.

Upstream Structure ID: Unique ID of the upstream structure.

Downstream Structure ID: Unique ID of the downstream structure.

Installation Date: The date the feature was installed if applicable.

Conveyance Type: The conveyance type.

Conveyance Material: The material of the conveyance.

Conveyance Rise: The vertical measurement of the conveyance outlet.

Conveyance Span: The horizontal measurement of the conveyance outlet.

Liner Present: (Y/N) Number of Barrels: The number of conveyance barrels.

Latitude: The latitude of the conveyance.

Longitude: The longitude of the conveyance.

Active: Is the structure in use? (Y/N) District: The GDOT district the structure is in.

District Area: The GDOT district area the structure is in.

County: The county the conveyance is in.

Route ID: The GDOT LRS ID the structure is located on.

Route: The route the structure is on.

Milepost: The milepost closest to the conveyance.

Google Link: A link to the structure on Google Maps.

Biennial ID: The unique ID associated to the historic conveyance layer.

Maintenance Status: The current maintenance status based on the most recent maintenance inspection.

Blockage: The blockage percentage recorded from the most recent inspection.

Condition: The condition recorded from the most recent inspection.

Follow Up Inspection Status: The status of the Inversa follow up inspection, if recommended.

Reported to District Before App: The date the structure was reported to the district before importing into the field maps app.

CONVEYANCE INSPECTION FORM

Conveyance ID: The unique ID for the conveyance.

Inspection ID: The unique ID for the inspection.

Inspector: Name of Inspector.

Inspection Date: The date the inspection was performed on.

Active: Is the structure in use? (Y/N) Conveyance Water Level: Water level observed in conveyance at time of inspection.

Conveyance Blockage: The blockage recorded during the inspection.

Conveyance Condition: The condition reported during inspection.

Structural Defects for Conveyances: The defect recorded during inspection.

Erosion Type: The type of erosion observed.

Inspection Notes: The text field for inspection remarks.

Corrective Action Notes: Text field for corrective action remarks.

Corrective Action: The recommended maintenance action.

Reported: Severe structural defect reported to GDOT (Y/N).

Reported Date: The date reported.

Through-wall > 1 sqft: Inversa field noted for follow-up inspection.

Bolt-hole tears: Inversa field noted for follow-up inspection.

Joint visible material: Inversa field noted for follow-up inspection.

Reverse curvature: Inversa field noted for follow-up inspection.

Ovality > 15%: Inversa field noted for follow-up inspection.

Sinkhole above: Inversa field noted for follow-up inspection.

Road settlement: Inversa field noted for follow-up inspection.

Scour/undermine > 5ft: Inversa field noted for follow-up inspection.

Follow Up Inspection Recommendation: Type of follow up inspection needed.

MAINTENANCE INSPECTION FORMS

The Maintenance Inspection Form should be used for GDOT personnel to review a structure to determine work that is required at a later date or to log maintenance when maintenance is performed.

• Choose the Inspection Type being performed:

o Review: GDOT personnel reviewed the structure to determine maintenance that is required at a later date.

o Maintenance Performed: GDOT performed maintenance at the structure and is logging it.

o Inversa Follow-Up Wanted: GDOT is requesting an Inversa Level 2 or CCTV follow up inspection.

• If Review is selected:

o Select the Review Status:

▪ GDOT Not Responsible – Other

• If GDOT Not Responsible – Other is selected GDOT Not Responsible

Notes field is required explaining the reason GDOT is not responsible.

▪ In Active Construction Zone

▪ Structure Does Not Require Corrective Action

• If Structure Does Not Require Corrective Action is selected, Maintenance Not Needed Reason is required to indicate why Structure Does Not Require Corrective Action.

• If Maintenance Not Needed Reason Other is selected, Maintenance Not Needed Notes is Required indicating the reason maintenance is not needed.

▪ GDOT Not Responsible - Inside ROW, Responsibility of Others

▪ GDOT Not Responsible – Outside ROW

▪ GDOT Not Responsible – Private

▪ GDOT Not Responsible – Driveway Pipe

▪ Work Required – 400 – Manual Clean Drain St

▪ Work Required – 405 – Mechanical Clean Drain St

▪ Work Required – 410 – Clean/Restore Ditches

▪ Work Required – 415 – Pipe Install/Repair

▪ Work Required – 420 – Build/Repair Concrete

▪ Work Required – 550 – Erosion Control

▪ Work Required – 821 – Culvert Repair

▪ Work Required – 822 – Culvert Extension

▪ Work Required – Outside Department o Date: Select the Date the review was performed on.

o Completed By: Input the first initial and last name of the personnel who reviewed the structure/inspection (kdunlap).

o Maintenance Notes: Input any additional maintenance notes.

o Attach any additional photos if needed.

1. 2. 3.

4. 5.

• If Performing Maintenance is selected:

o Select the Maintenance Activity that was performed:

▪ 400 - Manual Clean Drain St

▪ 405 – Mechanical Clean Drain St

▪ 410 – Clean/Restore Ditches

▪ 415 – Pipe Install/Repair

▪ 420 – Build/Repair Concrete

▪ 550 – Erosion Control

▪ 821 – Culvert Repair

▪ 822 – Culvert Extension o Date: Select the Date the maintenance was performed on.

o Completed By: Input the first initial and last name of the personnel who performed the maintenance (kdunlap).

o Attach a photo showing the maintenance has been completed.

• If Inversa Follow-Up Wanted is selected:

o Select the Do you have specific follow-up technology request?: Yes/No

▪ If you do: Select the follow up technology you request

• Request inSight Lite (CMP) o Yes/No

• Request Ground Penetrating Radar (GPR) (Concrete) o Yes/No

• Request BCT (CMP and Slipline) o Yes/No

• Request CCTV (<30 in diameter) o Yes/No

▪ If you don’t, select No and a determination will be made by State Maintenance

Office.

o Follow-Up Specific Notes: Fill out specific notes on why you request a Follow-Up Level 2 or CCTV inspection.

o Date: Select the Date the maintenance was performed on.

o Completed By: Input the first initial and last name of the personnel who performed the maintenance (kdunlap).

o Attach a photo showing the maintenance has been completed.

CREATING MAINTENANCE INSPECTIONS

Maintenance Inspections

1. Click on a stormwater feature, scroll to the bottom of the attribute list, and select Maintenance Inspections.

2. Click Add when the maintenance form pops up.

3. The Maintenance Inspection will ask for the Inspection Type.

a. Review

b. Performing Maintenance

c. Inversa Follow-Up Wanted

4. Based on the Inspection Type the user will need to input the Review Status or the Maintenance Performed.

5. When all fields are populated, click

Submit to save the inspection.

6. The structures and conveyances in the app will get updated symbology based on their Maintenance Activity or

Review Status. Refer to page 39 and

40 of this document to review all status based symbology. In the first example, the structure’s symbology has changed to a blue ‘X’ based on an Initial

Inspection Review Status of ‘Work

Required – 405 – Mechanical Clean St.

In the second example, the structures symbology has changed to a green point based on the Performing Maintenance

Maintenance Activity indicating

Maintenance was completed.

7. Conveyance feature symbology will also be updated based on the Maintenance

Activity or Review Status chosen in the forms.

WEB APPLICATION

Web Application (For Desktop Use)

1. Navigate to the webpage below.

https://gdotmaintenance.maps.arcgis.co m/apps/webappviewer/index.html?id=

093ce56181344e92b27979ab12e3f2b7.

2. Then login using GDOT credentials.

3. After sign in, you will see the Stormwater

Maintenance Inspections Map in default extent.

https://gdotmaintenance.maps.arcgis.com/apps/webappviewer/index.html?id=093ce56181344e92b27979ab12e3f2b7 https://gdotmaintenance.maps.arcgis.com/apps/webappviewer/index.html?id=093ce56181344e92b27979ab12e3f2b7 https://gdotmaintenance.maps.arcgis.com/apps/webappviewer/index.html?id=093ce56181344e92b27979ab12e3f2b7

Click here to view the

Attribute Table.

Zoom in/Zoom out

Zoom to the default extent of the map.

Zoom to your current location.

View Legend and feature symbology.

Search structures and conveyances by their unique ID in the search bar.

View layers and toggle layer visibility.

Open the Smart Editor pane to create Maintenance Inspections and view feature attributes.

View Basemap

Gallery.

Map Features

Zoom In/Zoom Out – Click the plus or minus icons on the top left corner of the window to zoom in or zoom out.

Search Bar – Search for structures by inserting the unique structure or conveyance ID in the search bar on the top left corner of the window.

Default Extent – Return to your maps default extent by clicking the house icon on the top left corner of the window.

My Location – Add your computer’s location by clicking the circle on the top left side of the window.

Legend – View the map legend and all map symbology by clicking the first of the four icons on the top right corner of the window.

Layer List – View layers and toggle layer visibility by clicking the stacked squares icon on the top right corner of the window.

• You can turn MS4 and DAII specific layers on and off in the Layer List widget.

• Click the hamburger icon with a check mark on the layer group. Select Turn all layers on or turn all layers off.

Smart Editor – Open the Smart Editor by clicking the lightbulb and pencil icon on the top right corner of the window.

Basemap Gallery – View and change basemaps by clicking the four squares icon on the top right corner of the window.

Attribute Table – Open the attribute table by clicking on the up arrow on the bottom center of the screen. Here you can view attributes, select features, filter, zoom to features, and show related records. Minimize the attribute table by clicking the down arrow above the table.

Navigation within the Web App

1. Select stormwater features by clicking the feature in the map, searching the

Structure/Conveyance ID in the search box on the top left corner of the screen, or clicking the selection handle to the left of the feature’s row in the attribute table.

2. When a feature is clicked (selected), a pop up will appear showing the attributes. If multiple features are selected, click the arrow on the top right corner of the pop up to view them.

3. View related tables, structure/conveyance inspections, and maintenance inspections, by scrolling to the bottom of the pop up window and clicking the table name.

4. You can also Pan to, Add Marker, and

View in Attribute Table from this pop up by clicking the ellipses on the bottom right corner.

Smart Editor

The Smart Editor is used to add new

Maintenance Inspections to features in the app.

Feature attributes and existing inspections can also be viewed easily from the Smart Editor pane.

1. Open the Smart Editor by clicking the lightbulb and pencil icon on the top right corner of the window.

2. Select the feature that needs a

Maintenance Inspection and click

Related Table/Layer at the bottom of the

Smart Editor pane.

3. To add a Maintenance Inspection, click the Create new feature icon to the right of the maintenance inspection form.

4. Choose the Inspection Type being performed:

a. Review: GDOT personnel reviewed the structure to determine maintenance that is required at a later date.

b. Performing Maintenance:

GDOT performed maintenance at the structure and is logging it.

c. Inversa Follow-Up Wanted:

GDOT is requesting a follow-up

Inversa Level 2 or CCTV inspection based on review of inspection.

5. Save all Updates.

Filter Widgets

The Stormwater Maintenance Inspections – Office User web application contains filter widgets that help in desktop review of the surface level inspection findings for maintenance planning.

Structure

Review

Filter

Structure

Conveyance

Review

Filter

Follow-Up

Recommenda tion Review

Structure/Conveyance Review Filter

The Structure Review Filter allows you to filter structure inspections to only view structures in your District, District Area, Blockage, Condition and Maintenance Status. Using this in conjuction with the attribute table allows you to quickly access and review inspection information.

1. By entering District 5, the attribute table will now filter to only show District 5 structures.

2. By entering blockage of 51-75% and 76-100%, the attribute table will now filter to only show District 5 structures with blockage of 51-75% and 76-100%.

3. By entering Maintenance Status of Needs Review, the attribute table will now filter to only show District 5 structures with blockage of 51-75% and 76-100% that have not been reviewed or had maintenance performed on them.

Desktop Review Workflow

Now that the filter has been set you can open your attribute table to view all structures that fit the above criteria.

In the example above you can see that 73 structures fit the criteria of Maintenance Status of Needs

Review, the attribute table will now filter to only show District 5 structures with blockage of 51-

75% and 76-100% that have not been reviewed or had maintenance performed on them.

1. Open your Smart Editor widget.

2. Select the first structure in the attribute table and then select Zoom to.

3. This will then show the current selected structure in the attribute editor. Next scroll down in the attribute editor to review the Structure Inspection.

4. Scroll to the bottom of this form to review photos taken at the time of inspection.

5. Now use the back button to go back and add a Maintenenance Inspection based on your review of the structure inspection.

6. Click the document with a plus sign widget to add a new Maintenance Inspection. Close out of the Smart Editor widget and refresh the attribute table once the Maintenance Inspection has been completed. You will see that the remaining amount to review has gone down after reviewing the structure (73 above to 72). The symbology will also change depending on the

Review Status or Maintenance Activity applied.

Export to CSV

The final step that can be performed is to export a csv of Work Required activities that were flagged during the Maintenance Inspection Review to assign to Field Personnel.

1. Open up the Structure Review Filter and Select the District and the Maintenance Status of

Work Required – Maintenenance Activity flagged. In the example below, we selected District

5 and Maintenance Activity Status Work Required – 550 Erosion Control.

2. Open up the attribute table and Select Options then select Export all to CSV. This will download a CSV, which can be opened in excel showing the structures that can be assigned to field personnel to perform maintenance.

This will download a CSV, which can be opened in excel showing the structures that can be assigned to field personnel to perform maintenance.

Field Personnel can then open the Stormwater Maintenance Inspections – Field User map in Field

Maps and search the Structure ID to locate and perform maintenance and log a Performing

Maintenance Maintenance Inspection.

This same workflow can be performed on Conveyances using the Conveyance Review Filter.

Follow-Up Recommendation Review

The Follow-Up Recommendation Review filter allows you to filter conveyance inspections where

Inversa recommended a Level 2 Follow Up Inspection.

1. Input District and the type of Follow-Up Inspection Status recommended.

2. Open the attribute table and go to the Conveyances table to review conveyances recommended for Level 2 follow-up inspection.

3. Select Zoom to to review the location where Level 2 Follow-up Inspection was recommended.

SYMBOLOGY

Symbology To view symbology, navigate to the Legend by clicking on the three blue dots at the top right corner of the phone screen and choosing Legend.

Structures

Structures Follow-up Inspection Status

Structures – Maintenance Status

Structures – Blockage

Structures – Defect (Condition)

SYMBOLOGY

Conveyances

Conveyances – Follow-up Inspection

Conveyances – Maintenance Status

Conveyances – Blockage

Conveyances – Defect (Condition)

REPORTING

Reporting

DAII PROGRAM

The DAII PROGRAM Dashboard contains two dashboard pages: Structures and Conveyances.

Each page contains all Structure/Conveyance location and general information, each DAII

Inspection logged, and each GDOT Maintenance Inspection logged through the State Maintenance

Mapping applications by GDOT personnel:

DAII PROGRAM DASHBOARD LINK

TABLES

STRUCTURES/CONVEYANCE:

• Structure ID & App Link: Unique ID for the structure/conveyance. Hyperlink that directs you to the structure/conveyance in the Stormwater Maintenance Inspections Office User web application.

• Type: Structure/conveyance type.

• Subtype: Structure subtype.

• Material: Structure/conveyance material.

• Invert Depth: Depth or diameter of structure/conveyance.

• Throat Depth: Throat depth of structure.

• Outside Connection: If pipe connecting from out of right-of-way.

• Milepost: Milepost of structure.

• Route Scenario: Mapping scenario of structure.

o SR1: Cross pipe under state route.

o SR3: Closed system pipe connecting into cross pipe.

o L1: Cross pipe under intersecting local route.

https://app.powerbi.com/Redirect?action=OpenApp&appId=7083e8d6-8404-4632-aeb5-92d13f5ad740&ctid=7f90057d-3ea0-46fe-b07c-e0568627081b o L3: Closed system pipe connecting into intersecting local route cross pipe.

• Maint: Current maintenance status of structure.

• Coordinates and Map Location: Latitude and longitude of structure. Hyperlink to to googlemaps.com.

STRUCTURE/CONVEYANCE INSPECTIONS:

• Inspector: Inspector who performed the inspection.

• Insp Date: Date the inspection was performed.

• Active Water: Yes if structure is carrying an active stream.

• Illicit Discharge: Yes if illicit discharge is present.

• Blockage: Percentage of structure that is blocked.

• Condition: Overall condition of structure.

• Defect: Defect associated with the structure.

• Corrective Action: General corrective action provided for the structure.

• Program: Program the inspection was collected from: SMO, MS4

GDOT MAINTENANCE INSPECTIONS:

• Inspection Type: Review, Performing Maintenance, Inversa Follow-up Requested

• Review Status: If Review is selected: the Review Status.

• Maintenance Activity: If Performing Maintenance is selected, the maintenance activity recorded.

• Maintenance Notes: Any notes from the GDOT personnel.

• GDOT Not Responsible Notes: If a GDOT Not Responsible – Other , additional notes on the reason why GDOT is not responsible.

• Maintenance Not Needed: If Maintenance Not Needed selected, additional information on why maintenance is not needed.

• Maintenance Not Needed Notes: If Maintenance Not Needed is Other, additional notes on the reason why maintenance is not needed.

• Date: Date of Review or activity performed.

• Completed By: Personnel who logged the review or maintenance.

• Follow Up Request: If Inversa Follow Up Requested, was there a specific technology requested.

• inSight Lite (CMP): If specific technology requested was insight Lite.

• BCT: If specific technology requested was BCT.

• GPR: If specific technology requested was GPR.

• CCTV: If specific technology requested was CCTV.

FILTERS

• DISTRICT: Filter all tables by the District the structure or conveyance is in.

• COUNTY: Filter all tables by the County the structure or conveyance is in.

• ROUTE: Filter all tables by the route the structure or conveyance is on.

• BLOCKAGE: Filter all tables by the blockage level the inspection was logged at.

• CONDITION: Filter all tables by the condition level the inspection was logged at.

• MAINTENANCE: Filter all tables by the current maintenance status.

• STRUCTURE ID/CONVEYANCE ID: Search for a specific structure or conveyance ID.