Latest Contributions by AdamBourque

‎06-30-2021

I also would very much so benefit from contingent values to be allowed on Collector / Field Maps, and I think I can speak for most water utilities using GIS.

‎09-02-2020

Hi Xander, I tried your suggestion and hit "test" end up giving the wrong coordinates, or not in WGS1984 anyways which I would like to keep. Anyways, the arcade expression generates the correct coordinates (assuming &center= is valid) ; however, it does not automatically generate those coordinates for the Survey submission, instead it uses my current location. The survey successfully works via URL incorporated in the pop-up rather than using Arcade expression, but the Arcade expression fails to pass the latitude/longitude even though the "Test" works. I have tried on both COLLECTOR and AGOL Appreciate the attempted help Xander Bakker

‎09-01-2020

Hello all, I was very excited to see this update that Collector supports Arcade expressions. I am trying to pass the existing feature service coordinates to the survey feature service layer using this article How To: Launch and populate a Survey123 for ArcGIS survey from Collector for ArcGIS using XY coordinates and attributes … I still pass the Facility ID value through the popup which works arcgis-survey123://?itemID=82f592fb0cf2454f93a757705b3d50dc&field:FacilityID={FACILITYID}{expression/expr0} but the location won't pass to my survey with this arcade expression implemented on AGOL feature layer: (it works during the "test" button but does not pass the values. function MetersToLatLon(x, y) { // Converts XY point from Spherical Mercator EPSG:3857(Web Mercator Auxiliary Sphere) to lat/lon in WGS84 Datum (EPSG:4326). // Source: http://www.maptiler.org/google-maps-coordinates-tile-bounds-projection/ var originShift = 2.0 * PI * 6378137.0 / 2.0; var lon = (x / originShift) * 180.0; var lat = (y / originShift) * 180.0; lat = 180.0 / PI * (2.0 * Atan( Exp( lat * PI / 180.0)) - PI / 2.0); return [lat, lon]; } function CreateURLSurvey(lat, lon) { var url = "&center=" + lat + "," + lon;// This is the line that defines the location Console(url); return url; } var latlon = MetersToLatLon(Geometry($feature).X, Geometry($feature).Y); var url = CreateURLSurvey(latlon[0], latlon[1]); return url; Furthermore, do I need a geopoint field in the survey? (I've tried both and still no success, unless there's something specific in calculcation or something I am missing). Thank you all!

‎05-14-2020

Thanks Doug, when I get the chance I will try it out. I'm in same boat of dealing with older people not even using smartphones, glad to hear somebody faces the same challenge of easing workflow!

‎05-12-2020

Hey Doug can you elaborate more on this process? I only messed with making a relationship class and not repeats and I end up getting duplicate features (duplicate ASSET IDS even with Global ID, it would just create a new point every time using pop-up). So in my situation, are you saying you built a "main form" or "hydrant flushing form" that is essentially is a separate feature class that repeats the values back to the main actual hydrant feature? (do points still appear? -- I don't want that if so) Thank you. I know I've asked you related workflows before, sorry for any redundancy.

‎05-12-2020

Awesome thank you James, I will register for sure. Do you have a recommendation as far as if I should hold tight with using the inbox method & tell field workers they will continue to have to "type in asset ID in survey123 from what they see in the Collector pop-up" OR Fight the challenges involved with using related table for Survey123? I see benefits of having "Inspection or Flushing" forms as a related table instead of built into the hydrant itself, but also see the benefits of having it all in one feature. (The issue I had was using the ASSET ID for the connection between the related table & feature, Survey123 with the pop-up would create a new feature entirely with the same ASSET ID instead of modifying the existing feature data. I was using global ID's. ** I might try Doug's workflow to "have the main form be the repeat and the header is a separate FC. Then relationship class the two together." if i properly figure out what he is saying & there's not drawbacks. (Going to wait for a response on his end) Thank you all for the help. Furthermore James, I know you probably don't have a say in this but would love to be able to utilize the feature report setup with Survey123 if it weren't for the cost (Reduce Excessive Credit Cost of Survey123 Feature Reports ) ; seems there is no consideration from *survey designed with minimal field data, but lots of records to *surveys designed that may have lots of fields but few records.

‎05-05-2020

Is there any update on this? I am currently using the inbox method for hydrant flushing and valve exercising, & have to do the same workflow, instead of utilizing pop-up method from water line to water-break.

‎04-27-2020

Hey Jennifer, so I am also using Survey123 to get images to web feature layer. The attachments are popping up as URL's but I am unable to use this Arcade expression method because I am using sync for offline use. You say the new map viewer allows attachments to be shown instead of URL now? Will this be the norm for viewing AGOL map? In other words should I even mess with all this? I was just hoping for an easy toggle or code option to embedded the picture in pop-up without doing all these loops (that which in my case did not work unfortunately) when viewing webmap on ArcGIS Online. Thank you!

‎04-13-2020

Hey Ismael, The If function worked great, I couldn't get the Coalesce to work with my calculation for some reason (probably did something wrong, will probably try that again separately just for fun). Thanks for everything you and James Tedrick‌ do; really been liking incorporating Survey123 with Collector

‎04-07-2020

Hey everybody, Background: I feel like I am always trying to push the limitations of Survey123, what a fun time. Anyways, I have created a Survey form for recording Water Breaks (Leaks). I have used "Constraints" to allow certain variables for the calculations I need to appear based on the type of water break (hole, rectangular, circular are my 3 options). So if the field worker clicks rectangular break, then they will have the option to enter in the length, width etc.. needed to perform the calculcation. My question: I have one field for the "Area" of the water leak break needed for me to do calculate water loss. All 3 water break types share this value, but use different calculations to achieve this value. Is there a way I can put multiple equations in the field but only using the desired equation (say IF "Rectangular_Break" is chosen use this equation OR IF "Circular_Break" is chosen use this equation. Possible Solution My only thought, which is not ideal, but is it use multiple "Area" fields based on the break type, but then for my next calculations I would have to make multiple "Water loss calculations" etc.. based on the break type. If that makes sense. I was thinking if Repeats or IF statement etc.. can be used with calculations could create a work around? Thank you all, if you need anything to help figure out what I am trying to achieve please comment. I am attaching the water breaks equations that I am basing my survey123 off of (you can see they share variables etc..). I can share my survey too but would prefer to DM. Appreciate it!

‎01-10-2020

Hey James I see what you're saying; I will use the inbox solution thanks for your help. However, I will note that the thing I like about the URL is it autopopulates the ASSET ID from the collector webmap where I am utilizing them most out of the pop-up. So now, my field workers have to open up survey123 app and search for each ASSET ID. I know there is the map function in Survey123 but you can't categorize symbology based on the answered values (yes/no hydrant flushed example) right? Lastly, my map function isn't even working in Survey123 to begin with, is that because you have to enable geopoint question or is it because I'm using a related table? The map function would use existing feature coordinates and not location based on where you took the survey correct? Thanks, sorry for the bombardment of questions, just trying to get clarity of my limitations.

‎01-06-2020

Thanks James I did discover the web map capability. Is there absolutely no way to use the field app? I am helping places in rural Kentucky that don't have access to Internet all the time/want to be able to use this workflow offline. I may be in denial but what is the purpose in have the bind GUID field option? There's absolutely no workaround using relationship tables or if need be as a desperate attempt to autopopulate the "new point" at the existing location of the feature?

‎01-03-2020

Hey Doug, So I got everything working from survey123 integration to webmap. However, all I want to do is edit the existing attribute information with new attribute information of the Fire Hydrants. Instead, Survey123 creates a new point using the same ASSET ID I have autopopulating from the pop-up configuration. Is there a way to avoid this? Thanks.

‎01-03-2020

Hi John, can you edit existing feature layer points without creating new points? I have my ASSET ID to autopopulate in the survey, but the problem is it ends up just creating another point with that same ASSET ID with a new point location. I am just trying to modify the attributes using Survey123 instead of Collector for several reasons. Is this something you have to use the GUID or some kind of relation class (haven't found out how to if so)? I am getting data from Survey123 to this feature, just like I said as new points instead of existing the current point data (not trying to edit existing surveys). Thank you for the help, been at this all week.

‎01-02-2020

Any luck?

Online Status	Offline
Date Last Visited	‎12-06-2023 08:38 AM

My Ideas

Latest Contributions by AdamBourque

Re: Support for Contingent Values in ArcGIS Online

Re: Trouble with passing XY coordinates Collector via Arcade Expression

Trouble with passing XY coordinates Collector via Arcade Expression

Re: Link to Survey123 Field App Inbox Existing Feature

Re: Link to Survey123 Field App Inbox Existing Feature

Re: Link to Survey123 Field App Inbox Existing Feature

Re: Link to Survey123 Field App Inbox Existing Feature

Re: Show Attachments in Pop-ups with Arcade Expressions

Re: Multiple Calculation Options for one Field Survey123?

Multiple Calculation Options for one Field Survey123?

Re: Edit existing records using Survey123

Re: Edit existing records using Survey123

Re: Avoid collecting existing item in Survey123

Re: Edit existing records using Survey123

Re: Is there any way to export a symbol icon from ArcGIS Pro?

Re: Edit existing records using Survey123

Re: Multiple Calculation Options for one Field Sur...

Re: Getting 0 for Calculation

Re: How to create Animation based off Range