It seems that Survey123 is putting two points in the wrong location. Perhaps the most interesting piece of this puzzle is that of the 8 surveys assigned to this point, 6 are in the correct location and two are not. Also interesting is that the two mis-placed sites are not exactly on top of each other; they are placed about 53 feet apart.
Our survey does not have a visible map where a user can place a point for the survey. Instead, a user is required to select a ‘Site Name’. Once the site name is selected, we use the pulldata() function to pull the lat/lon of the selected site from a csv file (IPM_Sites.csv). Once that info is available, the point for the survey is calculated based on the lat/lon pulled.
This works as expected except for one site two times - River Island. For some reason, the map point is placed about 40 miles southwest of the actual location (see screen cap below). I am unable to figure out why that is happening.
The screen cap below is from the Choices worksheet. You can see that when ‘River Island’ is selected, the site id value is 10107. I have verified that within the ipmSiteList that there is only one record with a label of River Island and only one instance of the name/siteid 10107
The next screen cap is from the csv file that the pulldata() function hits. Siteid 10107 should return the correct/expected lat/lon. I have verified that in the csv file there is only one record with a siteid 10107
Instead of putting the point at the River Island lat/lon, Survey123 is putting it at 44.97, -122.98 (screen cap below is from the ‘individual response report’ on the data tab of survey123 web site).
Any thoughts about what’s going on with those two surveys?
Accepted Solutions
