How to use pulldata from external source to set default geoshape?

Question

I have a survey which pulls data from an external csv which has the centroids and extents of counties. It has a geopoint linked to the survey and a geoshape in a repeat. I am pulling the coords for the centroid of the selected county to set the initial geopoint, which works, but when I try to concatenate the coords from the extent to set the geoshape, nothing happens. I have verified by setting the calcs to decimal and text questions that everything is populating and I don't see anything wrong with it, but it just doesn't work. I've tried it inside and outside of the repeat. Can someone please tell me what I'm missing here? Survey folder attached. Thanks, cob

South Georgia Landscape Restoration Cost-Share Form Update.zip

IanMackenzie · Answer

I was able to get something like this to work by passing a coordinate attribute in from the feature class from which my survey is launched... see custom attribute display screen shot below.

The coordinates in the feature class "Coordinates" text field look like this (minus the quotes):

"53.5386769 -113.2948011 ; 53.5346850 -113.2949250 ; 53.5373088 -113.2865969"

[Note i did not need the apostrophe that would be required when entering directly into the spreadsheet]

The Survey123 spreadsheet is formatted as per the second screenshot below. If you don't actually want to write those coordinates into the Survey feature class, i.e., field doesn't exist in the survey feature class, then need to set bind ESRI Field Type to null.

Ultimately I did not go with this approach as most of my polygons have too many vertices and exceed the maximum field size  (may revisit this with Blob type).

GeomaticsPublisher · Answer

hi I've also experienced the same issue. Have you found any solutions?

I can also successfully pull the geometry string in to a text field (called Geometry), but when I then use that field as the calculation for the geoshape it fails.

If i put exactly the same string into the default column it draws the geoshape correctly som the geometry is ok but not being successfully used in the calculation. Any help much appreciated.

DataOfficer · Answer

Hi @IsmaelChivite,

I am trying to use a pulldata function to pull in the geometry for a geoshape question, based on a select_one choice. Note that this is in a repeat. The geometry is moderately complex (up to 52 sets of coordinates to build the geometry string). Therefore, I have opted to store the geometry string as a single field in an external csv (e.g. 51.0718794880673 -0.832585294109184; 51.0716407642081 -0.833096529055853; 51.0713819551087 -0.833697778802456 ...).

I can successfully pull the geometry string in to a text field (called Geometry), but when I then use that field as the calculation for the geoshape it fails. I have tried the following in the calculation field:

* ${Geometry} - fails with the attached error message
* string(${Geometry}) - fails with the attached error message
* number({Geometry}) - doesn't fail loading in Connect, but the Geometry does not appear in the Geoshape question.

Is there a way to get this to work in the way I am doing it? Or will I need to have (52) separate columns in the csv being used by the pulldata and concatenate them as I would for a Geopoint question?

Capture.JPG