topic Re: Survey 123 feature report - filter map using global id in ArcGIS Survey123 Questions

Survey 123 feature report - filter map using global id

RABConsultants — Thu, 27 Aug 2020 11:40:36 GMT

I have a survey which surveyors use to complete property flood measure surveys. One part of the survey is a repeat that includes a geopoint question where the surveyor marks the location of each measure to be applied to the property. Usually each property will have 10+ measures. This all works as intended.

I am having trouble creating a map within the feature report that shows each properties measures but not the measures of the nearby properties. I have added in the feature layer and saved it as a webmap and called that within the feature report. Is there a way to filter the webmap within the feature report to only include the measures that relate to that survey? Perhaps some filter using the global ID can make this possible?

Re: Survey 123 feature report - filter map using global id

ZhifangWang — Thu, 10 Sep 2020 14:34:03 GMT

Hi RAB Consultants‌,

Currently, it is not possible to apply a filter a web map that is used in a geopoint/map question in the feature report.

For example, if the surveyor worked on a property A and had 10 measurements around the property, e.g. 1,2,3,4,5... can you please confirm that your requirement is to print a map that only includes the 10 measurements (but not includes any measurements for other properties) in the feature report?

Re: Survey 123 feature report - filter map using global id

RABConsultants — Mon, 05 Oct 2020 14:42:40 GMT

HI Zhifang Wang‌, what you describe is exactly what i want to be able to do. Is this in the road map, or is there a workaround using python?

thanks

Rob

Re: Survey 123 feature report - filter map using global id

RABConsultants — Mon, 05 Oct 2020 14:43:54 GMT

Zhifang Wang‌

Re: Survey 123 feature report - filter map using global id

ZhifangWang — Tue, 08 Dec 2020 17:46:58 GMT

Hi @RABConsultants ,

Yes, the capability to aggregate multiple geometries on one map is in our road map, I've added your use case in our backlog. However, there is no fixed plan for the implementation yet.

For the workaround of printing a single web map in the report to include multiple geometries (measures of a property in your case), it could work if you only need to generate a few reports. In this case, you can manually change the filter of the layer in the web map before each printing. Otherwise, in theory, you can use scripts to change the filter in the web map and invoke the Survey123 Report REST API to generate multiple reports.

If this is important to you, please feel free to raise an enhancement to Esri Support Service to prioritize this.

Re: Survey 123 feature report - filter map using global id

DarraghOSullivan — Fri, 06 Aug 2021 03:42:25 GMT

Hi Zhifang,

I have a similar scenario and just want to check if it is actually the same as this one, and whether a solution is coming soon...

We carry out inspections on walking trails and use Survey123 to identify and locate issues along the route. We generate a separate report for each individual trail, including all the issues identified for that trail. The Web Map used in the report contains all trails and the problem is, when trails overlap, it can be a little cluttered and confusing. Ideally we would be able to filter the Web Map to only show the relevant trail route for that report.

Any ideas, or info on whether and when this might be possible?

Thanks.

Re: Survey 123 feature report - filter map using global id

FionaBarry — Tue, 24 Aug 2021 17:54:13 GMT

Hi Darragh

In a feature report, to draw a line/route on a map, connecting the issues for an individual [survey] record, I used a geotrace field.

The geotrace field sums up the [repeat] points and generates a line joining them together.

e.g. In the XLS form, create a field:

Type = geotrace

Name = route

Label = Route:

Calculation = sum(${location}) .... where ${location} is the geopoint field name in the repeat

body::esri:style = method=vertex

In the report template, the code used is:

${route|mapSettings:"c03a526d94704bfb839445e80de95495":5000}

-> this generates a map in your report, displaying a line connecting all the repeat issue locations, for that record only.

Of course, you can change the map type ("c03a526d94704bfb839445e80de95495") and scale (5000) according to your preferences.

One thing to note: The [geotrace] line drawn is generated chronologically from the repeat geopoints. Unless the issues (repeats) are collected in a linear fashion, the line drawn could display as zig-zagged.

Hope this helps you!

Re: Survey 123 feature report - filter map using global id

DarraghOSullivan — Wed, 25 Aug 2021 04:35:42 GMT

Hi Fiona, thank for this. From my understanding, this will just create straight line connections between the issues, is that right? If so, it won't suit our needs unfortunately. We need to accurately display the full trail route in the report, so straight lines won't do. Hopefully the GPS Streaming idea will be implemented soon and that might solve it. Thanks again

Re: Survey 123 feature report - filter map using global id

DerrickWestoby — Thu, 13 Jan 2022 19:17:48 GMT

I just came here to post this idea too. Just to make sure I'm asking for the same thing, here's the general idea:

This is currently possible with the feature report syntax:

${ proj_extents_geoshape | drawingInfo:"currentLayer"| mapSettings:" b2519fd7a45647a0946f50b0535b6ddd" | size:175:250:0:0}

and I would like something like this available in the feature report:

{ proj_extents_geoshape | drawingInfo:"currentLayer"| mapSettings:" b2519fd7a45647a0946f50b0535b6ddd" where:ParentGlobalID=${pguid} | size:175:250:0:0}

Currently, I have the referenced basemap set up to filter points (geopoints contained inside a repeat) to only be displayed if they have been edited in the last 15 minutes. This works well enough for most submissions when the report is generated automatically via the integromat process. If I have to generate reports manually (such as someone submitting a partial survey, then editing it and resubmitting later), first I need to open the web map and change the filter to filter all points to the layer 0 record's GUID. There's other use cases I can think of where URL parameters being available in the feature report would be very helpful, but this seems like the most common one.

Re: Survey 123 feature report - filter map using global id

ZhifangWang — Tue, 18 Jan 2022 08:01:04 GMT

Hi @DerrickWestoby ,

Printing multiple records on a single map is now available to test on the Survey123 beta website and will be supported in the coming 3.14 release in late February/early March. Please see this EAC doc for the detailed syntax.

Thanks again for your feedback!

Re: Survey 123 feature report - filter map using global id

DougBrowning — Thu, 11 Aug 2022 17:35:53 GMT

Did you ever get this to go. I am also trying a query but I get a error.

Re: Survey 123 feature report - filter map using global id

Sharouff — Tue, 09 Jan 2024 14:01:40 GMT

I am also looking for this functionality of multiple repeat geopoints in a 2nd feature report map map filtered by a parent general location point, if anyone has a solution?

Re: Survey 123 feature report - filter map using global id

RABConsultants — Thu, 18 Apr 2024 13:42:34 GMT

Any update on this??

Re: Survey 123 feature report - filter map using global id

j-bromp — Wed, 22 May 2024 03:19:54 GMT

Is there an update on this? tried to access the doc linked by @ZhifangWang but it said unavailable.

I am looking to produce a report containing a map which displays multiple geopoints (contained in a repeat) however each reported map must only display the points captured in that submission.

Re: Survey 123 feature report - filter map using global id

SusanPollard — Mon, 17 Jun 2024 05:40:02 GMT

Same as above I too need an update on this syntax using a 'where' clause where the repeat name is SiteData and the parent is myforms or should it be mainLayer ? The normal text below currently zooms to all the geopoints inside the repeat of a selected parent record but it also draws other unwanted survey geopoints that I want to filter out of the map. AuditSiteLocation is the geopoint question inside the repeat.

${SiteData.AuditSiteLocation|where: SiteData.ParentGlobalID = SelectedParentRecord's???.GlobalID |mapSettings:"itemID"|size:600:800|drawingInfo:"currentLayer"}

Re: Survey 123 feature report - filter map using global id

Melissa — Wed, 26 Jun 2024 18:58:19 GMT

Same as the above. I need to show a summary map with all shapes in a repeat, ideally with the parent poly boundary + child points, lines and polys. Thank you @SusanPollard -- your posting above got me the closest to reaching that so far!

Re: Survey 123 feature report - filter map using global id

MichaelHeilen — Thu, 27 Jun 2024 15:05:36 GMT

I have a similar need as @SusanPollard and have attempted to use the 'where' clause without success to filter a map so that it only shows the feature recorded for the main layer for that particular survey response. In my case, each survey response corresponds to an individual project area that is recorded in the survey as a geoshape in the main layer. I want to show in a map in the report for that survey response only the project area recorded for the survey response and not project areas recorded by other survey responses. For this survey, many project areas overlap in space. Showing them all in a map is confusing and unhelpful and basically renders this essential but straightforward map useless.

The survey also contains a series of repeats for recording the location of different activities occurring within the project area. Sometimes, these activities can also overlap. I would like to generate additional maps in the report where each map shows the location of an individual activity recorded in a repeat, but not all the other activities recorded for that repeat.

It seems like filtering a map in a survey 123 report in this manner should be doable. Is this possible to do using a 'where' clause (or something else) and if so, what is the appropriate syntax?

Re: Survey 123 feature report - filter map using global id

CodaRain23 — Thu, 18 Jul 2024 20:52:04 GMT

Put me down for this as well. Our needs are pretty simple; I'm just getting started and have a whole lot to learn so it's hard to tell if a feature is not available or if I just don't know how to do it.

We have a survey recording geopoints with photos using repeats and multiline photos, so there are multiple geopoints recorded for each survey submission. I am trying to generate a report with a summary map with all the geopoints at the top of the report, and the photos listed after. I only need the points from the single survey submission, but seems like I get all the points in all the survey records. How can I limit the points to only the one submission?

${photo_location | where:"1=1 !important" | orderByFields:"objectid DESC" | resultRecordCount:12 | drawingInfo:"currentLayer"}

This is what I've been using, it's just the example in the quick reference. Like I said, I'm only just starting to work with S123.

Re: Survey 123 feature report - filter map using global id

DietrichEppSchmidt — Tue, 06 Aug 2024 19:30:32 GMT

Any update on this? can this be done in the S123 field app yet?

Re: Survey 123 feature report - filter map using global id

j-bromp — Tue, 20 Aug 2024 23:45:32 GMT

Just updating this thread, you can achieve this using python by removing all layers from the webmap then re-add your required features. if the features are held within a repeat you can query the feature layer to find the parent row with the most recent global id, then find all repeat features that share the same parent row id and re add them back to the webmap. this will show only the features relevant to your most recent submission. you then trigger this by survey submission.