Can data be exported to Excel from the Wetland – Stakeout app?

“I understand that the Wetland Stakeout App can export determination or custom forms to PDF, but can the App export data to excel?”

The wetland determination forms is made up of many different components, so is a custom form.

The completed report can be exported to PDF.

The data in the Sheet component (in spreadsheet format) can be exported in CSV format, which is compatible with Excel.


How do I switch to Alaska Region data form from the Arid West that is default?

You want to make sure you start a new Job in the Wetland – Stakeout app before switching to a new form template. To do so, select Job – Open Job then tap the New button. Enter the Job name or accept the one provided then tap on OK.

From the Main Menu, select Report then select Import from Template. The forms for the various Regions are provided as templates. Please select the appropriate one to import into a Job to use.

How to automatically assign indicator code to plant species in Wetland & Stakeout

“Have you folks thought of a way to link the plant indicator status (FAC, FACW, OBL, etc.) to the species name? That way when you pick a species from the list it automatically lists the indicator status. I was looking at your Design Report and was thinking there probably is a way to do it but is beyond my knowledge. — After two different field trips to sites in central PA I find the APP to work as advertised. I like it and as I use it I will keep you posted on my questions and observations.”

Nice question.

For the Indicator field, you could enter a formula to tie the displayed result to the species name.

For example:

IF SpeciesName== “Acer rubrum”

Then whenever you select “Acer rubrum” in the Tree Stratum, “FAC” will be displayed as the indicator code.

To try this functionality, you could save one of your projects under a “Test Job” name, then select Design Report in the app.

Tap on the Tree Stratum form and see its name highlighted on the right side. Tap the lock button to unlock it for editing then tap the “>” button.

Tap on the “Fields” tab then tap on “Indicator”.

Tap on the Edit button then mark the check box of “Has Formula
Now you can enter the above lines to tell the app what to do when you select Acer rubrum as the species.

To facilitate the formula entry, the Name button lists the available field names for the Tree Stratum and the Command button lets you pick the commands rather than having to key in each letter.

You could use the logic operator OR to specify a few species on the same line for the same indicator status. This method can get tedious if you have a long species list to work with. We will look into the feasibility of providing a more efficient way to achieve the desired result.

(Same user suggested to add the ability to search another table to get the indicator status for the species of interest. We are working on this enhancement.)

Is the Prevalence Index automatically calculated in Wetland & Stakeout?

Following are a few recent Q&A’s concerning the Wetland & Stakeout app:

1. Can the APP be set-up on a project basis so that each data form for the project has all background information filled in only once (information on the top third of page one of each form)?

You could fill in the information for a project then save it as a template with the name of the project. To do a new data form, call up the template then save it with a unique name for the data form.

2. Is the APP created with the various Corps Regional Supplement areas in mind such that it can be used in any region of
the U.S.? (Your screenshot is of the Arid West Region so I am wondering if it is practical to use in the eastern U.S. because we require more spaces/lines for listing vegetation species).

The app comes with templates for all the US Army Corps regions.

You can edit the vegetation species list according to your needs.

3. Is the Prevalence Index automatically calculated (screenshot shows Dominance Test is automatically calculated)?

Yes, the formulas are built in.

4. In what format are forms exported?

The forms are exported as PDF files.

How to add a new species to the Wetland & Stakeout app

You can add new records to the Wetland Species list.
For Example:

1) Select Wetland from Menu\Job\Open Job.
2) Select Design Report from Menu bar\Utilities.
3) Tap on the records of Tree Stratum to select TreeStratum.
4) Unlock this record (by tapping on the Lock icon)
5) Tap on the “>” icon to edit it
6) Select “Fields” tag and select “SpeciesName” record
7) Tap “Edit” button to edit it.
8) The “Text Length” is 40, so the first 40 characters are for the scientific name, other characters are for an optional hint(common name). The format is:

Acer saccharinum – Silver Maple

If “Text Length” were set to 20, then the correct format would be:form
Acer saccharinum – Silver Maple

Tap the “Append” button to add a new record.

The quick way to add multiple records is to use the “Import” button to import a formatted text file.

Wetland & Stakeout provides customizable data input form on the iPad

“Is the mobile app (to be run on an iPad) standalone??? Or, does it require a desktop version or license to set up the job and input forms? . . . Is the mobile app really customizable within itself, or is the setup done on the desktop?”

Yes, the Wetland & Stakeout mobile app is standalone and you can set up the Jobs within the app.

The app is a data input form design app incorporating the wetland delineation data entry forms as an application. The wetland delineation input forms are built-in templates that you can call up and save under the names that you specify. You can modify the form within the app, and you can also design your own data entry form within the app.

Each “Job” in the app is focused on collecting data at one sample point although your site layout can include other map shapes.