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; } } }

Survey 123 feature report - filter map using global id

RABConsultants

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?

Trouver plus de publications taguées avec

Accepted answers

All comments

ZhifangWang

Hi @RABConsultants ,

There is a new method mapFilters in report template to filter out features in a layer in web map. Please see https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-print-web-maps-in/ba-p/1537166 and let me know if this could help with your workflow.

RABConsultants

Any update on how to show all the geopoints inside the repeat of a selected parent record without showing other unwanted survey geopoints that need to be filtered out of the map?

So far my map settings just show all points related to the parent layer. How would I change this to work:

mapSettings: “ec336c1b4e8b4e7a83f22969ad751eca”:425 | size:700:450}

ZhifangWang

Hi @DerrickWestoby ,

Filtering feature dynamically is now available in the Survey123 Beta website, please refer to Solved: Re: Survey 123 feature report - filter map using g... - Page 3 - Esri Community for more details.

ZhifangWang

Hi all,
The new `$map` keyword, which allows you to print a web map without referencing a survey question, and the `mapFilters` method, which filters features in operational layers in a web map, are now available on the Survey123 Beta website. For more details, please refer to this EAC document. As this is currently a beta feature, any feedback would be greatly appreciated via the forum on EAC.

j-bromp

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.

DietrichEppSchmidt

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

CodaRain23

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.

MichaelHeilen

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?

Melissa

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!

SusanPollard

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"}

j-bromp

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.

RABConsultants

Any update on this??

Sharouff

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?

dougbrowning

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

ZhifangWang

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!

DerrickWestoby

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.

DarraghOSullivan

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

FionaBarry

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!

DarraghOSullivan

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.

ZhifangWang

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.

RABConsultants

Zhifang Wang‌

RABConsultants

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

ZhifangWang

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?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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