topic Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question? in ArcGIS Survey123 Questions

How can I calculate default coordinates for my geopoint question when it is not a relevant question?

JamesKelly4 — Sun, 12 Dec 2021 09:28:51 GMT

In my survey the geopoint question is relevant for all but 1 sample type. This is because county is the highest resolution location data that we get for this 1 sample type. However, I would like the default coordinates for this sample type to be the centroid of the selected county. I can get this functionality to work on all of the sample types that are relevant for this question with the following formula and by having a csv file (centroids) in the media folder with x,y coordinates for centroid of each county.

concat(number(pulldata('centroids','x','county', ${county}))," ",number(pulldata('centroids','y','county', ${county})))
‍

I was hoping it would still do the calculation for the sample type for which the geopoint question is not relevant, but it is not. It still returns x and y values of 0, placing the point off the coast of Africa.

Any help is appreciated! Survey123 Geonet‌ Survey123 (Admin)‌ Survey123 Survey‌ James Tedrick‌ Ismael Chivite‌

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

JamesKelly4 — Fri, 30 Aug 2019 12:51:45 GMT

Philip Wilson‌ - got anything for me on this one? Thanks in advance!

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

DougBrowning — Fri, 30 Aug 2019 14:17:02 GMT

When a relevant is hidden it will always be "" string. No way around that. (Except for the default values bug.)

You could use the hidden type or something maybe?

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

Anonymous User — Sun, 01 Sep 2019 10:46:08 GMT

Hi James,

Does the geopoint question ever become relevant, or always not relevant but you want to capture a position for it? Can you share your xlsx file?

Phil.

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

JamesKelly4 — Wed, 04 Sep 2019 14:30:11 GMT

Yes it becomes relevant for all other sample types. I'll try to attach xlsx spreadsheet.

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

JamesKelly4 — Wed, 04 Sep 2019 14:36:30 GMT

Not sure how to attach spreadsheet so here is a copy on my google drive.

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

Anonymous User — Wed, 04 Sep 2019 21:53:58 GMT

Hi James,

You can attach the xlsx file to the reply/post using the "Use advanced editor" option (top right corner of reply when open in new window/tab (not in Inbox).

Phil.

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

JamesKelly4 — Fri, 06 Sep 2019 20:29:51 GMT

10-4. Sorry for slow followup. Please see attached.

Re: How can I calculate default coordinates for my geopoint question when it is not a relevant question?

JamesTedrick — Tue, 10 Sep 2019 20:26:55 GMT

Hi James,

You calculation relies on a pull data with CSV - it would be helpful to attach that as well.

Another technique you could use to debug this form is to migrate the pulldata calculations to notes to make sure that it's being read properly, and calculate the geopoint based on the notes.

I'll also note that Survey123 expects a Latitude, Longitude (y,x) pair, not an x,y pair, which is what you apparently are trying to calculate.