Content in GeoNet, The Esri Community | GIS and Geospatial Professional Community

2020 Esri Water GIS Conference

geonet@esri.com — Thu, 25 Jun 2020 19:14:42 GMT

REGISTRATION IS OPEN!
https://www.esri.com/en-us/about/events/water-conference/overview

The 2020 Esri Water Conference will be held virtually September 23 - 25.

Join the Esri Water team for a water-centric conference experience with exciting industry updates. You'll learn about the latest GIS solutions, get hands-on training from Esri experts, connect with peers, and return to work with new tools to help your organization.

https://www.esri.com/en-us/about/events/water-conference/overview

Understanding Survey123 Feature Reports

geonet@esri.com — Thu, 25 Jun 2020 03:32:04 GMT

Survey123 includes out of the box functionality to help you generate high quality documents out of submitted surveys. This is extremely useful when you need to present your survey123 data following strict formatting guidelines, for example when mimicking legacy paper forms or to comply with legal documents.

In this blog post I will describe how you can configure this feature report functionality against your own surveys, defining the content and look & feel of your own feature reports.

A bit of context: Survey123 feature reports vs summary reports

Before we get into the details, I want to provide some context up-front about what exactly I mean by feature reports.

Generally, the word report is associated with summary reports where data is aggregated to help identify trends. Survey123 includes basic summary report capabilities, but these are not the focus here. This discussion is about feature reports. A feature report presents data from a single survey record.

Say for example you use Survey123 to support asset inspections and you want to generate one document, as proof-of-work, for each inspection performed. For that you use feature reports. Say Survey123 is used to document city code violations and you want to generate and mail individual tickets for violations observed... For that you use feature reports too. The purpose of a feature report is not to aggregate data across multiple surveys. The purpose is to represent the data a single submitted survey.

In a way, the Survey123 feature report capability is about bringing your survey data back into a form format, except that in this case, you want the form to present data, as opposed to using the form to collect data.

Creating a feature report from the Survey123 website

The following animation shows how you would generate a report from the Survey123 website. Note that the feature report is triggered from the Data tab in the Survey123 website. The Data tab is designed to help you explore and drill down into individual survey records (features). Using the map or the table views you can select a particular survey record and generate a report for it. That is, of course, assuming that you have previously configured your survey with a template. You will learn shortly about creating your own report templates.

Feature reports can be generated for one or multiple records at once. You can use filters or manually select multiple records using the shift key. If you create a single report, you will be able to open the document right away from your browser. If you create reports in bulk (from a selection), then the outputs will be stored in your ArcGIS account.

The Survey123 feature report service will always create a single document for every record you select. That is, reports from multiple records will not be merged into a single document. If you select 200 survey records and you trigger feature reports for them, then Survey123 will create one document for each record: 200 separate documents.

Creating a Sample Report Template

To get started on your own, you need first a report template to create feature reports. This is how you create one:

In the Survey123 website, go to the Data tab of your survey.
Select one record from the table or the map.
Click on Feature Report in the top bar
In the Feature Report panel that just open on the left side, click on the Manage Templates link.
Create a new sample template as shown in the animation below and close the dialog.
Generate a report.

Now that you have a template, click on the Generate Report button and open the resulting output document. The sample template is generated automatically, and as such, will not create the most beautiful results, but it is a great starting point for you to refine it.

Feature report templates are stored along with your survey in your ArcGIS account. If you navigate to the directory of your survey within your ArcGIS content, you will find your feature report Microsoft Word template in there. You can associate one or more templates with a single survey.

All templates you associate with your survey will be available to any user that has Viewer access to your survey. That is, anyone who has been granted Viewer access to your survey, will also be able to generate reports using the templates you define for that survey.

Getting started with custom feature report templates

Going back to the Manage Templates link you will be able to download the sample template to your computer. Once you download the template, you will realize that it is a simple Microsoft Word document. This is what the sample template for my Water Violation v2 survey looks like:

You can see right away how templates work: A series of placeholders for questions in your form are included in the template. The most basic syntax for the placeholders looks like ${question_name}. All you need to do is to make your Microsoft Word template document look the way you want and insert the Survey123 feature report placeholders accordingly.

Once you are happy with your report template, you can upload it using the Manage Templates link. Until you get familiar with the placeholder syntax, I suggest you start easy: Start by rearranging text within the document and copying and pasting the placeholders from the sample template. Change the color and style of the text, arrange existing placeholders within tables, etc.

Generate a report again with your updated template to see the effect.

Using advanced feature report syntax

Survey123 feature report syntax can get a bit more sophisticated than just a generic ${question_name}. For example, note in the example below how extra parameters are used to format dates, to control the size of a photo or signature and even to define the scale and contents of a map.

This is what the final output of the template above looks like when the report has been generated.

When working on your template, you first need to understand how to uniquely reference questions within your survey. Downloading the sample template is the easiest way to get a complete list of placeholders, but you can also get the complete list from the feature report template dialog as shown below. This dialog also lets you explore some more advanced syntax for your placeholders.

You can insert a | sign after your question name (aka: field code) and include some extra parameters to either format the value written to the report, or extract other information from your survey question.

Feature Report Syntax	Description
${myQuestion}	Inserts in your report the value stored in the specified survey question.
${myDateQuestion \| format:"DD/MM HH:mm"}	Date questions are tricky, because they will not come pretty unless you format them properly. The format parameter is your friend. For a complete reference look for the Formatting Dates section in our Formulas—Survey123 for ArcGIS \| ArcGIS help topic.
${myPhoto \| size:300:0}	When working with image questions, you can set the exact size in pixels that the image will have in the output report document. The first value defines the width and the second the height. If you set the height to 0, then the width will be applied and the height will be dynamically set so your image aspect ratio is preserved.
${myPhoto \| getValue:"name"} ${myPhoto \| getValue:"date"} ${myPhoto \| getValue:"time"}	Also for image questions, you can add to your report the photo filename using the getValue:"name" parameter. Similarly, you can also extract the date and time when the photo was taken and have it written in your report. That, of course, assuming that the EXIF of the photo includes that info.
${myLocat \| size:400:400}	The size parameter is valid for map questions too. In this case, we will add in the report map with a size of 400x400 pixels.
${myLocat \| mapSettings:"6712da572":5000} ${myLocat \| mapSettings:"":5000}	Use the mapSettings parameter to describe the exact webmap you want to draw and the map scale. First you pass the webmap item id and then, separated by a colon, the map scale. If you do not know how to get the webmap item id, have a look at Lisa Berry's Where can I find the item ID for an ArcGIS Online item? blog post. If you pass an empty webmap item id, then the report will use a default webmap.
${myChoiceQuestion \| selected:"yes"} Yes	When working with choice questions you can use the selected parameter to output a checkbox. The expression on the left will output Yes if the option selected is yes. This works well with both checklists (select_multiple) and single choice and dropdown questions (select_one).

Combining your mastery of the syntax above and a bit of good taste applying layouts and formatting in Microsoft Word will go a long way. You can pretty much do anything you want with your Microsoft Word document. For example, you can change the size and orientation of the page, use tables to arrange content, set the alignment and justification of text, its color, size, etc. You can also include Survey123 placeholders in headers, footers or anywhere in the body of your document.

As you get started with the feature report syntax, I suggest that you start slowly, making small incremental changes against the sample template and you let your confidence grow progressively. You will need to upload your template again and again until things look they way you want. Every time you upload the template, the syntax of your report template will be validated. You will get errors when you add an incorrect number of parameters on your placeholders, when you reference field codes that do not exist in your feature service or when you do not open or close the brackets correctly. Also be careful making sure parameters are set with the right casing and honor the necessary spaces.

On top of including photos, signatures and maps in your Survey123 feature report templates, you can also handle related records (repeats) and even define conditional visibility statements. The complete reference for the feature report syntax is included in our Feature report templates—Survey123 for ArcGIS | ArcGIS help topic.

ArcGIS Online support and credit consumption

Survey123 feature reports are generated through an ArcGIS Online premium service. At this moment, the use of this service does not consume ArcGIS Online credits, but it will starting with our next update to ArcGIS Online.

The feature report service will consume ArcGIS Online credits at a rate of 2.5 credits per document generated starting with the ArcGIS Online release in October of 2019.

In the event that a user sees the Feature Report functionality disabled in the Survey123 website, an administrator of the ArcGIS Online organization can enable the Feature report functionality for that user as shown in the animation below.

ArcGIS Enterprise support

The Survey123 feature report service is at this moment hosted in ArcGIS Online and it is designed to work with surveys hosted in ArcGIS Online. However, with some limitations, this service can also be used with surveys hosted in your own ArcGIS Enterprise 10.5 or newer.

Your ArcGIS Enterprise instance must be accessible to the Survey123 ArcGIS Online Feature report service. That is, you must configure your ArcGIS Enterprise web adaptor to expose access to your Enterprise instance from the internet. Please note that portals with Integrated Windows Authentication will not work with the report service.
The inclusion of any type of feature service attachments (photo, signature, annotated images...) is not supported when your data is hosted in ArcGIS Enterprise. This is a limitation listed in the backlog of ArcGIS Enterprise as ENH-000125371: Support keyword attachment columns into ArcGIS Enterprise so that survey photo attachments can be printed when generating reports from an ArcGIS Enterprise feature service.

As a workaround to include photos in your report now, then you can use this syntax in your report:

${#$attachment}
${$file}
${/}

Make sure you the above as three separate lines in your template. This expression will basically show all attachments found in your feature.

ENH-000125371: Is planned to be addressed in ArcGIS Enterprise 10.8.1 for hosted feature layers.

Bearing the limitations above, the use of the ArcGIS Online Feature Report service from your ArcGIS Enterprise instance will not incur into any ArcGIS Online credit costs.

Automation

You can automate the generation of Survey123 feature reports through Integromat and the ArcGIS Python API.

Integromat: You can the Survey123 module in Integromat to automate the generation of feature reports when a new survey is submitted. Even better, with Integromat, you can also take that feature report document and include it as an e-mail attachment, or upload it into cloud storage. You can learn the basics of automating report generation with Integromat in this brief video-tutorial:

ArcGIS Python API: The ArcGIS Python API is ideal if you want to generate reports in bulk in an automated way. For example, in case that you want to automatically generate reports for all surveys submitted daily or weekly. Refer to our ArcGIS Python API developer documentation for details.

Attribute Assistant - generate unique id based on domain value in another field

geonet@esri.com — Thu, 25 Jun 2020 02:28:56 GMT

I have parcels with different landuse classes: Business, Residential, etc. I would like to generate a unique id when the parcel is being split. However, I need to generate a different id and counter depending on the landuse class. If Business, then generate B1, B2, B3, etc. If Residential, then generate R1, R2, R3, etc.

This is my progress.

Table Name	Field Name	Value Method	Value Info	On Create
Parcel	PLOT_ID	GENERATE_ID	COUNTER_B	TRUE
Parcel	PLOT_ID	GENERATE_ID	COUNTER_R	TRUE
Parcel	PLOT_ID	EXPRESSION	IIf([TYPE]="Business","B" & [PLOT_ID],"")	TRUE
Parcel	PLOT_ID	EXPRESSION	IIf([TYPE]="Residential","R" & [PLOT_ID],"")	TRUE

I could not figure out how to trigger it. Any help would be appreciated.

Water Geometric Network Editing and Analysis solution

geonet@esri.com — Wed, 24 Jun 2020 19:37:42 GMT

Hello everyone!

I’m a new user for the Water Geometric Network Editing and Analysis tool, and I have some questions about it.

First, I am using ArcMap 10.8, and I built a geometry network as some online guides explain, although the process produced a 30-line error table for me, the net is as good as I checked. I've been trying to update the rules of the network, and I think that's fine too. But, when I get to run the tool options, like valves isolation, it didn't work at all. After searching the web and forums, I realized that I needed to configure the configuration file to fit the network I built, based on the entities I have.

After the configuration I did, things got better, he didn't throw an error message, but now he's running the tool, but nothing comes out.

From what I understand, I obviously have to define which layer is the valves, lines, etc.

Is there a way to do this without the configuration file?

What am I doing wrong?

I would greatly appreciate any help in this matter, it is a very important issue for my company.

I'm attaching the GDB with the layers and the network, the configuration file, and the error table, in the hope that it will help.

Thank you all!

Water and Sewer utility Networks in the same enterprise gdb

geonet@esri.com — Tue, 23 Jun 2020 22:38:24 GMT

We are trying to run 2 utility networks in same sde: 1 water distribution 1 sewer.

We created the unowner account and used it to deploy for water distribution but when we run the apply asset package tool for sewer network this is the error we are getting:

Running script AssetPackageToUtilityNetwork...

ArcGIS Pro 2.5.1.22081

untools 2.5.1

Executing from ArcGIS Pro, 3 map(s), activeMap = True

Asset Package schema version: 2.4

ERROR 001400: Only the data owner may execute these tools.

Failed to execute (AssetPackageToUtilityNetwork).


We were able ti run stage network to for sewer with unowner account. Our enterprise gdb is on a sql server

Looking for Dangles

geonet@esri.com — Tue, 23 Jun 2020 16:31:01 GMT

Wondering how to find dangles in ArcPRO? I've found info on using Data Reviewer in ArcMap with Polyline Checks>Find Dangles Check, but so far unable to figure out in ArcPro. Thanks! -Dillon

Survey123 Tricks of the Trade: Embedding a survey in an ArcGIS Dashboard

geonet@esri.com — Mon, 22 Jun 2020 04:37:56 GMT

In this post you will find step by step instructions to help you embed a survey within an ArcGIS Dashboard. This is a commonly used used to support QA/QC and review workflows. The animation below illustrates what this could look like. In this dashboard, a list of mosquito spray exclusion requests is shown in the left panel. These requests are added through a separate online survey open to the public. A request review survey has been embedded in the right panel. As requests from the list are selected, the survey is automatically populated so the request can be reviewed and updated.

The above example provides a compact user experience for browsing and updating existing data. This same idea can be applied to many workflows, where one survey is used to submit jobs or requests of some sort, and a dashboard with an embedded survey is used to review the incoming information.

If you would like to give the above sample application a go, you can try it live:

Start by opening this form to request a new mosquito spray exclusion.
Then, open the request review dashboard to see and update your new request.

In this scenario, you need two surveys targeting the same feature layer. One survey is used to submit requests, and the other to review them. The surveys share a common set of questions, but they are not exactly the same: the request review survey, for example, has an extra section to approve or deny the request. Generally, the surveys are also shared differently: the one to submit requests is shared with a group of people, even with the public, whereas the survey to review requests is shared with a smaller group.

Assuming that you already have the survey you want to embed into your dashboard ready to go, and that you are somewhat familiar with ArcGIS Dashboards, here is a step by step guide to get you going:

Before we start, make sure your dashboard has a Map element and that the web map in it has a refresh rate set.
In your ArcGIS dashboard, add a List element and configure it to target your survey layer. You can apply a filter to this list in case there are survey records you do not want to show. In our example above, a filter could help us hide any request that has been already been approved and closed. You can also use the sorting options in the List element to present the most relevant records at top of the list.
Next, add an Embedded Content element.
- In the Data Options panel, first set the Type to Features and target your survey feature layer.
- Paste the URL of your survey web form into the URL property.
- Set the Maximum Features Displayed property to 1.

At this moment, a preview of your survey should be shown in the right panel. Next, we are going to modify the URL with some extra parameters to load content and adjust the look and feel. If you are not familiar with the Survey123 web app parameters, check out Survey123 Tricks of the Trade: Web form URL parameters and Survey123 Tricks of the Trade: Editing records in a web form

Right at the end of the URL you just pasted, add the following:
- ?mode=edit&globalId= If using a survey from ArcGIS Online
- &mode=edit&globalId= If using a survey from ArcGIS Enterprise.
Use the fields collection to add the GlobalID variable into your URL.
Optionally, add the following parameters to hide the navigation bar and footer: &hide=footer,navbar

The following animation shows the last three steps.

Save your changes and go back into the dashboard design.

At this moment you have the List, Map and Embedded Content elements in your dashboard, but they do not talk to each other. We are going to configure actions to make them work together.

Open the List element configuration dialog and add a new filter action targeting the Embedded Content element

Optionally, you can also configure actions in the List element to zoom to and flash the selected record.
From the design preview, select an element from your list and wait for the embedded survey to load the corresponding record. Now you can make changes to the record and submit!

Limitations

The filter action in the Embedded Content element can also be triggered from a selection in the map. However, it is not possible to configure your dashboard to trigger the filter from both the Map and List elements. That is, you need to choose either to load a survey from a selection in the list or from a selection in the map, but you cannot do both.

The Survey123 web app does not support editing surveys with repeats. You will get an error when attempting to initialize the form if it includes a repeat.

Creating surface area of water body by DTM and water level gauge

geonet@esri.com — Fri, 19 Jun 2020 19:47:18 GMT

Hi folks,
do you know whether its possible to derrive/create surface area of a water body by applying only DTM and

water level gauge in GIS?

The attachment illustrates the DTM for the water reservoir , red lined the described aim, to create a surface ( or even polyline) by appying water gauge level.

Are further data required for that task?

Thanks for your comments.

surftrial

Trouble with Census Data

geonet@esri.com — Fri, 19 Jun 2020 18:56:32 GMT

I am doing project calculating displacement due to sea level rise (SLR). I am doing so by using intersecting the SLR polygons with census tracts for each state and then running zonal statistics as table with the intersect shapefile and a Gridded Population raster. However, when I run the zonal stats as table tool, I get higher rates of displacement than is reasonable. For example, one census tract has a total population of ~8,000 but the calculated displacement for that tract is ~12,000. Is there a reason for why I am getting higher rates of displacement than I should be? Or is there a better method I should use? Thanks

Webinar Series - Part 2: Digitizing and Mobilizing Field Operations

geonet@esri.com — Fri, 19 Jun 2020 15:53:40 GMT

I am searching for the registration on this webinar.

Where can I find it?