topic Geopoint placed from pulled choice list selection in ArcGIS Survey123 Questions

Geopoint placed from pulled choice list selection

AndrewPriest — Mon, 17 May 2021 22:24:17 GMT

Hi. Forgive me, I've seen threads with a similar question, however I'm still struggling. I'm on Survey123 3.12 and the survey if primarily accessed via a web browser. here's the gist of it.

Survey question:

Is this in a building?

If yes is selected a .CSV of building names, numbers, and it's location gets pulled:

pulldata('Building_pt_PH','BuildingNumber','Name_Building', ${BuildingNumber})

That .CSV also contains a location field in "+37.75722499_-122.4556317" format.

I want the geopoint to center at the location of the building selected.

If no is selected I want the normal geopoint behavior of the user clicking the location.

I know this is pretty basic stuff. I just can't get it functioning correctly. Thanks.

Re: Geopoint placed from pulled choice list selection

DougBrowning — Mon, 17 May 2021 22:55:46 GMT

See https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-working-with-uk-postcodes/ba-p/1038895

Re: Geopoint placed from pulled choice list selection

AndrewPriest — Tue, 18 May 2021 00:24:43 GMT

thanks, yeah, I looked at that and I'm still flummoxed. the "Lookup search against a local file" section is basically what I'm trying to do, but it's actually even more complicated with the concat Lat/Long calculation.

I've just need to pull one X_Y value based on a choice list calculation

Re: Geopoint placed from pulled choice list selection

DougBrowning — Tue, 18 May 2021 13:40:26 GMT

Based on the sample I think you need to use 2 columns. No real way to sperate strings in 123.

So have a lat column and a long column and pull them separately. Then use them in the calc of the geopoint. Just follow the image and it should work.

If you can post your form that will help.

Re: Geopoint placed from pulled choice list selection

AndrewPriest — Tue, 18 May 2021 16:09:50 GMT

thanks, Doug. I've attached my form. my media folder contains the"Building_pt_PH.csv" which has the building name, unique identifier (CAAN), and the lat/lons. I'm hoping to get the geopoint to center on the lat/longs of the CAAN selected. Cheers

Re: Geopoint placed from pulled choice list selection

DougBrowning — Tue, 18 May 2021 16:22:44 GMT

Attach the CSV also

Re: Geopoint placed from pulled choice list selection

AndrewPriest — Tue, 18 May 2021 16:41:53 GMT

right! thanks again, Doug. attached

Re: Geopoint placed from pulled choice list selection

DougBrowning — Tue, 18 May 2021 17:06:51 GMT

Here you are. I just followed the screen shot in the post so not sure what did not work for you. I had to change the csv also since you had no name or label columns. Need these for the Building name to populate.

Re: Geopoint placed from pulled choice list selection

AndrewPriest — Tue, 18 May 2021 19:50:28 GMT

that did it! thanks again