nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

JamesKelly4

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.

<SPAN class="token function">concat</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">number</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">pulldata</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'centroids'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'x'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'county'</SPAN><SPAN class="punctuation token">,</SPAN> $<SPAN class="punctuation token">{</SPAN>county<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">" "</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="token function">number</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="token function">pulldata</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'centroids'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'y'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'county'</SPAN><SPAN class="punctuation token">,</SPAN> $<SPAN class="punctuation token">{</SPAN>county<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

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‌

Encontre mais publicações marcadas com

Accepted answers

All comments

JamesKelly4

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

JamesKelly4

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

Anonymous User

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.

dougbrowning

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?

JamesKelly4

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.