Workflow: Geotrace, Public Works, Lateral Launch, Trailing Zeroes - SOLVED!

JoshConrad1

I am the GIS Coordinator for the Public Works Department of my organization, assisting workflows for our field crews. I was faced with the task of creating a “Sewer Lateral Launch” field app that can easily track where, how, why, when, etc.

The below documentation shows the steps I took to complete the success of this task, as well as explaining some additional workflows that were be achieved in the process:

• Creating general template for Public Works Sewer Lateral Launch field application within Survey123 (using Geotrace) and integrated with FieldMaps
• Plot a Geotrace line using distance (manual entry), coordinates (precalculated), and bearings (precalculated)
• Calculated necessary trailing zeroes to verify precision of Latitude/Longitude coordinates

I attached a PDF with my methodology (apologies if it is long-winded), as well as Survey123 Connect excel document for reference. I am not an advanced Survey123 Connect user, so I am well aware that the hidden-dummy fields in the form could probably be consolidated, however thru a full day of testing: it works. I also am providing all my sources that I referenced to help design the form (infinite amount of thank-yous to all contributors on this site):

Primary Sources used:

* https://stackoverflow.com/questions/2187657/calculate-second-point-knowing-the-starting-point-and-distance

* https://www.fcc.gov/media/radio/find-terminal-coordinates

* https://community.esri.com/t5/arcgis-survey123-blog/what-s-new-in-arcgis-survey123-february-2021/ba-p/1030586

* https://community.esri.com/t5/arcgis-survey123-questions/survey123-how-to-maintain-trailing-zeros-in/td-p/865486

* https://community.esri.com/t5/arcgis-survey123-questions/survey123-leading-zeros-for-integer/td-p/806983

Other Sources Used:

* https://gis.stackexchange.com/questions/463758/survey123-submit-survey-as-geopoint-geotrace-or-geoshape

* https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/calculate-geometry-attributes.htm

* https://community.esri.com/t5/arcgis-pro-ideas/calculate-the-bearing-of-a-line/idi-p/973006

* https://pro.arcgis.com/en/pro-app/latest/help/editing/create-point-features-along-a-line.htm

* https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_BB97985CAFB740EE8AEF99EFD6E238E3

* https://doc.arcgis.com/en/survey123/desktop/create-surveys/geotracegeoshape.htm

* https://www.youtube.com/watch?v=IVz4f36xwUs

* https://community.esri.com/t5/arcgis-survey123-questions/create-a-line-feature-from-two-geopoint-collection/m-p/1279330#M48625

* https://community.esri.com/t5/arcgis-survey123-questions/points-to-line-in-survey123-web-form/td-p/1280388

* https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-pulldata-quot-layer/ba-p/1224415

* https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-xlsform-functions/ba-p/893567

* https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata/ba-p/896889

* https://community.esri.com/t5/arcgis-survey123-blog/work-with-csv-data-in-arcgis-survey123/ba-p/1157642

Hope this helps somebody.

@DougBrowning 
@IsmaelChivite 

@abureaux 

@Katie_Clark 

@ZacharySutherby 
@TylerGraham2 

@JamesTedrick 

Lateral Launch Methodology.pdf

Lateral Launch Report.xlsx

rlyding_1-1729876834122.png

rlyding_0-1729876681250.png

TylerGraham2

Pretty cool!  One thing you should consider doing looking at using the pulldata("@geometry") on your features to get the full lat/long. That might eliminate your issue with trailing 0s.  Another thing is to is set the type to 'hidden' or 'calculate' instead of 'text' for all of them. Then you'd want to use the bind::type and bind::esri:fieldType columns to set the type which will affect how the fields behave, including with calculations. bind::type will affect how the survey handles the particular field and bind::esri:fieldType will set the field type in the feature service, if publishing from scratch using Connect, or tell the survey what field type to expect if the survey is pointing to an existing hosted feature service. 

We had a similar problem with marine mammal sighting data entry during in-water construction work. The Survey123 maps are clumsy and getting a user to accurately place an animal sighting on a map with no scale or bearing was very time consuming and took away from their jobs of watching for marine mammals. I've included a sample section of our marine mammal sightings form that takes the geopoint of the monitor's location using GPS and, based on the distance and bearing to the animal the monitor enters, it applies a calculation that creates a point in another geopoint field (has to be stored in a repeat) to place the animal's observed location. The cool thing is it is all done on the fly and if you type in an incorrect value, you can re-enter the correct one and it updates the second geopoint.  I used the Destination point given distance and bearing from start point section outlined in this page to develop my calculation in Survey123.

I did have to set the bind::type and bind::esri:FieldType for the lat/long values to 'decimal' and 'esriFieldTypeDouble' respectively otherwise the calculations would come out wrong.  Types matter and you might be able to consolidate your form a bit if the types are set properly and you can nest calculations that will work correctly. 

toggle test.xlsx