Creating a Survey
Copyright © 2018 EarthSoft, Inc • Modified: 23 Nov 2018
To open the Alive Survey Definition Form:
1.Open EQuIS Professional and connect to the desired EQuIS Database (one that has the Alive Schema applied to it).
2.Activate an Alive license by clicking the licensing icon in the bottom-right corner of EQuIS Professional > Decision Support > Alive
3.Navigate to the Decision Support tab and select the Alive Survey Definition Form icon.
The Alive Survey Definition Form will look like the image below the first time it is opened without any information or parameters loaded.
•New Survey Type – Define a new survey.
•Delete Survey Type – Delete the currently selected survey.
•Save Survey Type – Save all changes made to the database, both for the survey and any shared lists/parameters.
•Cancel – Cancel any changes made to the survey or any shared lists/parameters.
•Status – Choose setting for RT_SURVEY_TYPE.STATUS_FLAG.
The Survey Type drop-down arrow lists surveys that are already defined in the database. To edit an existing survey, simply select it from the list, make edits, and click Save.
Click the New Survey button to define a new survey, or enter a new value in the Survey Type field, and enter the header information, which populates the following fields in RT_SURVEY_TYPE:
•DESCRIPTION (stored in RT_SURVEY_TYPE.SURVEY_DESC)
The Survey Fields tab displays information about the survey section of the survey or parameters/values that are to be recorded only once per survey. Use this tab to define which parameters should be recorded for the survey. See example image below:
The Observation Fields tab displays information about the observation section of the survey or parameter/values that are to be recorded with multiple observations per survey. Use this tab to define which parameters should be recorded for each observation made while performing the survey. The Survey Fields and Observation Fields tabs have the same basic layout. The differences are:
•The Survey Fields populate from DT_SURVEY.
•The Observation Fields populate from DT_SURVEY_OBSERV.
•The Custom Fields lists show those parameters associated at the survey or observation level on the respective tabs.
The Available Parameters are parameters that can be used or created when customizing new and existing surveys. When the survey is saved, the parameters for each survey are stored in RT_GROUP_MEMBER. The GROUP_CODE prefixes indicate survey section:
•ASPG: Survey Fields
•AOPG: Observation Fields
•AOTG: Surveyed Species
New parameters can be created by simply adding new rows at the bottom of the Available Parameters list (see example image below).
The following explains each column in the Available Parameters list. Note that red column names indicate that the fields are required.
•Code – The parameter's code is a shortened or abbreviated representation of what the parameter is used for. Entries for this field are stored in RT_PARAMETER.PARAMETER_CODE. This is a required field.
•Description – Allows for more in-depth explanation of the parameter, its purposes, and uses. Entries for this field are stored in RT_PARAMETER.PARAM_DESC. This is a required field.
•Type – Optional field intended to be filtered to make finding specific parameters easier. This field is a look-up to RT_PARAM_TYPE.PARAM_TYPE; any new PARAM_TYPE values must be entered in this reference table.
•Data Type – Defines what type of data should be entered into this parameter. The values will be restricted accordingly in both EDP and EDGE:
oText – Used for any textual value that includes letters and numbers.
oInteger – Whole numbers, both positive and negative.
oDecimal – Any number, with or without a decimal, whether positive or negative.
oPercent – Any number ranging from 0.00 to 100.00, restricted to two (2) decimal places.
oDate/Time – Any date, time, or date and time combination.
oT/F – True or False; recorded as 'Y' for yes or 'N' for no in the database.
•Lookup-List – When mousing-over the cells, a button will appear in the right side of the cell. Clicking it will open a pop-up window where a custom list can be created for the parameter, or a pre-existing list can be selected. Entries for this field are stored in RT_LOOKUP.
•Unit – Specifies what unit type values should be recorded. It can be helpful to append the unit to the parameter Code (e.g., WEIGHT_G, with the "G" standing for grams). This field is a look-up to RT_UNIT.
•Default Value – Sets the value the parameter should be if no other value is selected.
•Status – Setting the value to anything other than 'A' (aka Active) will disable the parameter so it no longer shows up in any surveys.
•Remark – Field for additional remarks or comments about the parameter.
Tip: When adding new parameters to the available parameters list, try to make them as generic as possible while still making them useful for the selected survey.
For example, if creating a Fish Survey that requires the recording of the weight of the fish, use 'WEIGHT' instead of 'FISH_WEIGHT' so that the parameter can be used in other surveys.
The Standard Fields section contains a list of pre-populated parameters included in the survey. The same list of Standard Fields will be found in every Survey Type. These parameters will be included as fields in the DT_SUBFACILITY, DT_SURVEY, and DT_SURVEY_OBSERV sections in the Alive format.
The optional and look-up Standard Fields can be set as required by right-clicking on the parameter name and selecting Required Parameter. This will make data entry required for that parameter, but only for the selected survey being edited.
When an optional or look-up Standard Field is made required, and the survey is saved, those parameters will populate the required_survey_fields and required_observ_fields in the RT_SURVEY_TYPE table (see image below). Note that the optional or look-up Standard Fields can also be made required by manually populating these fields in the rt_survey_type table (by replicating what is displayed in the image below), rather than selecting them from the Alive Survey Definition Form user interface.
The Custom Fields section is a toggle-able list that displays all the Available Parameters chosen for the currently selected survey. The custom fields come from the list of Available Parameters. The custom fields will be displayed in the order they appear on the list when the survey format is opened in EDP or EDGE.
The arrow buttons can be used to manipulate the list of custom fields:
1.Up – Moves the active row in the Custom Fields list up one place.
2.Right – Adds the selected rows from the Available Parameters list to the Custom Fields list.
3.Left – Removes the selected rows from the Custom Fields list.
4.Down – Moves the active row in the Custom Fields list down one place.
Any of the Custom Fields can be set as required by right-clicking on the parameter name and selecting Required Parameter. This will make data entry required for that parameter, but only for the selected survey being edited.
Observations made during a survey typically revolve around some species of flora or fauna. This list of species is contained in a hierarchical table, RT_TAXONOMY. The RT_TAXONOMY table is setup so that the species can be grouped together in a logical fashion. For a guide on setting up RT_TAXONOMY, please read here.
Any level of the taxonomy structure can be associated with a particular survey using the Surveyed Species tab. Simply move the TAXONOMY_CODE over to the right column, using the arrows, and the survey will include any child records for that TAXONOMY_CODE. For example, when setting up a bird survey, simply choose to include 'AVES' (Birds), and thus, any bird listed under 'AVES' would automatically be included for that survey. When the survey is exported as an EDGE Format, only those TAXONOMY_CODE(s) chosen for that survey will be included.
After the survey is setup, click the Save icon (upper-left) to save the survey.
Please see the EDGE Export article for instructions.
Once exported, the format can then be used in EDGE for field data collection. Please refer to links in the Data Collection article for more information.