KCI-Ablowers
commented
4 years ago V1 of Materials and Quantities Prototype
HHD Pre-Remediation - Materials and Quantities Prototype.xlsx
Option 1 (Page 1)
Option 1 provides an example of user-entered materials and quantities at the question level. When "Remediation = Yes", the "Photographs and Remediation" repeat will display. This repeat contains two additional repeats - "Photo Repeat" and "Material and Quantity Repeat." The "Materials and Quantity Repeat" contains:
- End Treatment Category - Standards category list (currently has 700 & 900).
- End Treatment M1 (or M2) - Filtered based on Category above (700 = M1, 900 = M2). Select one option for user to pick material.
- Quantity - The user entered quantity value for the selected material.
- Unit - Select one list of units (Ton(s), Square Feet, Square Yard(s), and Feet).
Pros
- Allows remediation information to be collected per question
- Follows naming convention for question
Cons
- Users will enter one category and material per repeat.
- Could make the form schema extremely long if this information is entered per question.
- Usability Depends on the desired "to-be" workflow for determining materials/quantities in the field (or office).
Option 2 (Page 2)
Option 2 provides an example of user-entered materials and quantities at the "page" or "section" level. Users will run through all questions ("Embankment" in this case) determining if remediation is necessary. If "Remediation = Yes" for any of the questions, then materials and quantities repeat will display. The photographs repeat is unchanged and present for every question when "Remediation = Yes." The "Material and Quantity Repeat" contains:
- Remediation Options - List of all "questions" as an autocomplete select one list. This could be filtered based on which questions have "Remediation = Yes" but I was unsure how to do that with te choice filter.
- Category - Standards category list (currently has 700 & 900).
- Material - Filtered autocomplete select one list based on the selected category
- Quantity - The user entered quantity value for the selected material.
- Unit - Filtered autocomplete select one list based on the selected material.
Pros
- Allows remediation to be collected per "page" or "section" and materials/quantities associated with the desired question via the "remediation option."
- Follows standard naming convention ("EMB" = "Embankment")
- Simplifies the form schema by reducing the number of "material and quantity" related fields.
- Simplifies the potential "to-be" workflow for determining materials/quantities in the field (or office).
- It could be provided one time in the form with the options filtered by what is identified as needing remediation.
Cons
- Users will enter one category and material per repeat.
- Materials and Quantities will be associated with the naming convention, rather than the specific question via repeat like Option 1.
Option 3 (Page 3)
Option 3 utilizes the "geoshape" and "geotrace" functionality to allow user entered geometries (Polygon = Area & Line = Distance). The user will select the desired type of geometry (Area or Line) and be presented with the "map" icon, which when selected loads to the location of the device (by default I believe). For demonstration purposes, the area geometry uses the default "smart shape" and "trace" functionality and the line uses the "vertex" method. Once the geometry is confirmed, the user is returned to the form where the feature is presented in the map along with the default measurement units. The "{Area or Distance} Calculation" field shows the measurement calculated to either square meters or meters.
Once the geometry is entered, the user will populate the remediation option, category, material, quantity, and unit similar to Option 2. The only difference is how the options are displayed. The user can then either create another "Material and Quantity" record (via repeat) associated with the same geometry OR create a new repeat, enter a new geometry, and associated "Material and Quantity" attributes.
Pros
- Allows for the association of a feature and area to the remediation option.
- It could be provided one time in the form with the options filtered by what is identified as needing remediation.
- Can utilize the existing (or to- be existing) web map to display inventory features and tracing of imagery.
Cons
- It could be time-consuming and cumbersome on the user to create the geometries in the field (or office)
- Will require a web map to be added to the inspection form and configured so it functions appropriately when entering the geometries.
- The geoshape and geotrace features submit in the form of vertices ("rings" or "paths" ) which may display fine in the Survey123 form or web but may need some extra processing if needed outside of those platforms.
General Information / Problems
- I am unsure how we can calculate the quantities per unique material or remediation option across the form. From my extensive research (googling), there does not appear to be an "out of the box" way to do this in Survey123 without some major unique values or calculation fields being added. @talllguy, I'm hoping you may know how to do this or have some idea of how to get us there.
- The schema is already quite extensive and this will further inflate the form and increase load times.
- The number of categories and materials within the standards is massive. Without using external selects or pulldata (if possible) the performance of the form will be severally impacted if HHD chooses to go with any of these or other options for handling materials and quantities.
talllguy
Background
Develop a Survey123 form to demonstrate the potential solutions for Remediation Materials and Quantities
Options
Use domains (choices) or pull data function to populate dropdowns (select one) to present the user with categories that filter a secondary dropdown (select one or select multiple) containing the materials (or items) within that category. The user then populates the area or length manually for each material per remediation option (inflow erosion, embankment vegetation, etc.). All areas/lengths sum at the end of the form by name.
Use the geotrace and geoshape options to present the user with a map where they are able to:
https://doc.arcgis.com/en/survey123/desktop/create-surveys/geotracegeoshape.htm
Links
Tyler Bazan Sample Report Documents on Teams
Construction Standards and Materials Landing Page
2019 Standards and Specs - PDF
We should focus on "Category 900 - Materials" to start. It contains some general information about types of stone, pipes, etc. that will be easier for us to calculate.
Category Code Book This contains the standard quantities for a number of items - Each (EA), SF (Square Foot), SY (Square Yard), Ton, etc.