Ipm pipe training may 14 th 2007
This presentation is the property of its rightful owner.
Sponsored Links
1 / 74

IPM PIPE Training May 14 th , 2007 PowerPoint PPT Presentation


  • 93 Views
  • Uploaded on
  • Presentation posted in: General

IPM PIPE Training May 14 th , 2007. PIPE DATA ENTRY: How to enter data into PIPE for new data entry users (observers) Julie Golod IPM PIPE- Penn State University. Focus of This Module. PIPE Data Entry for New Users Topics that will be Covered The two step data entry process

Download Presentation

IPM PIPE Training May 14 th , 2007

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Ipm pipe training may 14 th 2007

IPM PIPE Training May 14th, 2007

PIPE DATA ENTRY:

How to enter data into PIPE for new data entry users

(observers)

Julie Golod

IPM PIPE- Penn State University


Focus of this module

Focus of This Module

PIPE Data Entry for New Users

Topics that will be Covered

  • The two step data entry process

  • Using On-line and Excel forms

  • Soybean Rust, Soybean Aphid, Viruses, Other Diseases, and Other Insects Data Forms

  • Copy Locations Tool – Copying Location from 2006 for Use in 2007

  • Checking Uploaded Data


Ipm pipe training may 14 th 2007

Entry Screen


Ipm pipe training may 14 th 2007

Entry Screen


Ipm pipe training may 14 th 2007

Main Screen – Restricted Access Website


Ipm pipe training may 14 th 2007

Main Screen – Restricted Access Website


Data entry steps

Data Entry Steps

There are two distinct parts to data entry

  • First, recording site information in the setup form; including assigning the site a unique location name, providing location and host information,

  • Then, uploading observational data for that location


Step 1 location setup form

Step 1. Location Setup Form


Location setup fields

LocationSetup Fields

  • Location Type: The type of location

  • Required

  • Acceptable values:

    • Sentinel - any site that is monitored on a regular basis, according with the sentinel protocol specific to the host and/or organism being monitored and to the region.  A sentinel site can be planted early, or not; can have multiple or single maturity groups or hosts; can be planted specifically for the sentinel network or be located in a research or commercial field.

    • Single Observation - can represent any type of location: production field (commercial), research station, etc, and is monitored only once, or the expectation is that the site will be monitored once.

    • Repeated Observation - can be any location where the monitoring is expected to occur on a some type of a regular basis, be it weekly, bi-weekly or monthly.


Ipm pipe training may 14 th 2007

Location Setup Fields

  • Location Setting: Clarifies the location type and indicates the host and/or setting location.

  • Required

  • Acceptable Values

    • Commercial - a grower/production field

    • Research - research or experimental station

    • Kudzu/wild legumes - a location with kudzu or another non-planted legume species as the host

    • Stand alone (sentinel only) - a site planted especially for the sentinel network

    • Volunteer legumes- Legumes that are not planted, but may have been planted at some earlier point in time.

    • Other/unknown - when the location of the site does not fit into any of the other location setting or is unknown. However, the host must be known

    • Ad-Hoc (aphid only) - This is a site that is sampled weekly during the season, at least .5 acres in size, and aphid severity values are always established via count and not an estimate. This is a also a site where only aphid monitoring is occurring (not disease or virus )


Ipm pipe training may 14 th 2007

Location Setup Fields

  • Location Name: A unique name assigned to each location; and if more than one cultivar/host/planting date is present at that location, each one gets a unique name

  • Required

  • Acceptable Values- alpha numeric w/no spaces


Location naming protocol

Location Naming Protocol

Sentinel site: STNAME”ST”NN_CC

Any other: STNAMENN_CC

  • ST = state postal code (2 letter abbrev)

  • NAME= County (preferred), but nearest city or another convenient name is also acceptable. Maximum number of characters is 10, no spaces.

  • **If it is a sentinel site include the following letters “ST” after name

  • NN = counter separating one location from another with the same state and name. (sequence starts over at 01 for new state/name). Maximum number of characters is 2.

  • _ = underscore, a separation between the counters; not needed if the second counter is not used

  • CC = an alpha counter (sequence starts at “a”) or name of the cultivar/host when more than one of the following is present at a site: cultivar, host, or planting date. Maximum number of characters is 8 and no spaces are permitted. This counter can be ignored if the site has only one host/cultivar/or planting date.

  • The location names are case-insensitive.


How to assign a location name

How to assign a location name

  • ST = MI

  • NAME= Kalamazoo

  • ** “ST”= ST

  • NN = 01

  • _ = _

  • CC = a

    Location names are case-insensitive

    Complete site name = MIKalamazooST01_a


Location setup fields1

Location Setup Fields

  • Country - Required

  • State/Province- Required

  • County – Required; County where the site is located

  • Main Contact Name – Optional; person to contact if there is a question about the site

  • City - Optional

  • Address 1- Optional; can be any type of address: actual physical address, intersection, location in relation to a physical landmark

  • Address 2 - Optional


Location setup fields2

Location Setup Fields

  • Latitude and Longitude : the coordinate data that identifies the physical location of the site

  • Optional

  • Acceptable values: decimal degrees.

    • Latitude ranges from -90 to 90 degrees with the southern hemisphere being negative.

    • Longitude ranges from -180 to 180 with the western hemisphere being negative


Location setup fields3

Location Setup Fields

  • Approximate Plot Size – Optional. Size of the site

    • Units – Conditional. Required if the size is provided. Units for reporting the size of the site. Values: acres, hectares, sq.feet, sg.meters

  • Irrigated-Optional.Is the site irrigated. (yes/no)

  • Buckthorn Near- Optional. Specific to aphid monitoring. (yes/no)

  • Soil Type – Optional.A text field to indicate soil type

  • Funding Source - Optional; The entity that provided the funds for establishment and monitoring of the sentinel site. Only applicable for sentinel locations. Acceptable Values:NCSRP, USDA, State Soybean Boards, University, Other


Ipm pipe training may 14 th 2007

Location Setup Fields

  • Removal/Destruction Date – Optional; If a site was destroyed (not harvested) for any reason, indicate the date that occurred.

    • accepted values (yyyymmdd)

  • Moved to a Different Site – Optional; If monitoring was moved to a nearby field for any reason .

    • Date – When the nearby site began to be monitored. accepted values: (yyyymmdd)

    • New Location Name - The location name given to the new site

      accepted values: alpha numeric


Location setup fields4

Location Setup Fields

  • Host Name – Required;The host observed/planted at that site. Only one allowed per location name.Acceptable values:selected from a pre-defined list.

  • Cultivar/Variety - Optional; This is a text field where the cultivar/variety can be indicated. Only one allowed per location name.

  • Maturity Group - Optional;This is a text field where the maturity can be indicated. Only one allowed per locationname

  • Planting Date - Optional; This is a field for providing the planting date, when applicable. Only one allowed per location name. Acceptable values(yyyymmdd)

  • Planting Density - Optional; A text field

  • Row Spacing - Optional;A text field


Step 2 observation forms

Step 2. Observation Forms

Host/Site Information

Pest Information


Observation host site fields

Observation Host/Site Fields

  • Observation Date – Required.The date observation was made. Acceptable values: (yyyymmdd)

  • Plant Height – Optional.Average height of the canopy in inches.

  • Canopy Closure – Optional. Canopy cover represented in 25 percent increments. Acceptable values: 0,25,50,75,100

  • Drought Stressed – Optional.A way to indicate if the site is drought stressed.Acceptable values: yes/no


Observation host site fields1

Observation Host/Site Fields

  • Plant Stage – The average vegetative and reproductive( when applicable) growth stage of the host

  • Conditional. Required for planted legumes and soybeans.

    • Vegetative : Acceptable values are P,VC,VE,V1,V2,V(x), or V(x.x). Ranges, ex.V1-V2, are also acceptable.

    • Reproductive: Acceptable values are R1, R2, R(x), or R(x.x). Ranges, ex. R1-R2, are also acceptable.


Observation host site fields2

Observation Host/Site Fields

  • Greening - Conditional. Required for over-wintering kudzu survey. Used to indicate the percent of kudzu that is exhibiting greening at the site. Can also be used to record greening for other hosts.Acceptable values numeric represented as percent .

  • Dieback - Conditional. Required for over-wintering kudzu survey. Used to indicate the percent of kudzu that has experience dieback due to cold weather. Can also be used to record dieback for other hosts, doesn’t have to be weather related.Acceptable values:numeric represented as percent .


Observation pest fields

Observation Pest Fields

  • Presence - This field is used to record the status of the organism as determined by field scouting and/or lab confirmation.

  • Required (if the field is present on the data entry form)

  • Acceptable Values : yes, no, maybe, no longer found – which is specific to soybean rust.


Observation pest fields1

Observation Pest Fields

  • Observation Unit - Conditional.This field captures the sample type.Acceptable values :plants, leaves, pods, stems.

  • Number of Units Examined – Conditional.The number of the units examined to make the status or count determination.Acceptable Values:numeric

  • Number of Positive Units – Conditional.The number of units that were tested or were observed to be positive for the organism in question.Acceptable values:numeric


Observation pest fields2

Observation Pest Fields

  • Severity – Proportion (indicated in percent) of plant area that is affected based on a straight scale. Severity of soybean rust infection is to be assessed based on the visual severity scale provided by Dr. Monte Miles; available on the restricted site under menu option.

  • Optional. Only used for diseases.

  • Acceptable Values: numeric values in percent


Observation pest fields3

Observation Pest Fields

  • Insects per Unit – Conditional.Only applicable for insect survey. The insect count averaged over the number of examined units.Acceptable Values: numeric.

  • Count/Estimate. Conditional.Only applicable for soybean aphid survey. A way to indicate if the insect “count” was based on an actual count or estimate.Acceptable values:count, estimate.

  • Severity Rating – Conditional.Only applicable for soybean aphid survey. When the “counts” are high, a user can select to use severity rating instead of indicating a count.


Observation pest fields4

Observation Pest Fields

  • Confirmation Method – How was the presence or absence of the organism confirmed.

  • Conditional. Required in certain situations.

  • Acceptable values:This is a multi-select field and confirmation methods may differ by organism type. Values are selected from a pre-defined list.


Observation pest fields5

Observation Pest Fields

  • Sample Submitted to NPDN Diag Lab – Optional. This field is used to indicate if a sample was submitted to the a NPDN lab for processing. Acceptable values: yes/no

  • Diagnostic Lab Sample ID – Optional. This field is only applicable if a sample was submitted to a NPDN lab for analysis. If you know the full NPDN unique identifier, which is comprised of lab id, sample id, diagnosis number, please provide all those values separate by a space in this field. If not, provide as much of that information as you have (for example, lab sample id). This is an optional field that will help us confirm that our linkage of the lab and scout portion of a records is correct.


Observation pest fields6

Observation Pest Fields

  • Site Management – Optional. A way to document if a control measure was undertaken for the organism in question. AcceptableValues : chemical, mechanical, other, none . This is a multi field selection.

    • Control Type – The type of chemical or mechanical means used.Values:select from a pre-defined list

    • Control Name - Name of the control measure; such as the name of the chemical applied. Values: Text field

    • Percent of Site-percent of site to which the control measure was applied. Values: numeric represented in percent.


Data entry methods

Data Entry Methods

  • On-Line Forms (Web based forms)

  • Excel Forms

  • PDA (will not be covered today)

    You can enter data using any method that you prefer. You can enter setup data and observational data using different methods


Step 1 location setup on line form creating a new location

Step 1: Location Setup On-line Form Creating a New Location


Location setup on line form

Location Setup On-line Form


Location setup on line form1

Location Setup On-line Form


Location setup on line form2

Location Setup On-line Form


Location setup on line form3

Location Setup On-line Form


Location setup on line form4

Location Setup On-line Form


On line form entry location names

On-line Form Entry – Location Names


Step 2 observation on line form host site

Step 2. Observation On-line Form - Host/Site


Step 2 observation on line form

Observation On-line Form - Host/Site

Step 2. Observation On-line Form


Step 2 observation on line form1

Observation On-line Form - Host/Site

Step 2. Observation On-line Form


Step 2 observation on line form2

Observation On-line Form - Host/Site

Step 2. Observation On-line Form


Step 2 observation on line form3

Observation On-line Form - Pest

Step 2. Observation On-line Form


Ipm pipe training may 14 th 2007

Observation On-line Form - Soybean Rust


Ipm pipe training may 14 th 2007

Observation On-line Form - Soybean Rust


Ipm pipe training may 14 th 2007

Observation On-line Form Soybean Rust Sentinel Post-Detection


Ipm pipe training may 14 th 2007

Observation On-line Form - Other Diseases


Ipm pipe training may 14 th 2007

Step 2. Observation On-line Form - Pest

Observation On-line Form - Other Diseases


Ipm pipe training may 14 th 2007

Observation On-line Form - Soybean Aphid


Ipm pipe training may 14 th 2007

Observation On-line Form - Soybean Aphid


Ipm pipe training may 14 th 2007

Observation On-line Form - Soybean Aphid


Ipm pipe training may 14 th 2007

Observation On-line Form – ‘Other’ Insects


Ipm pipe training may 14 th 2007

Observation On-line Form – ‘Other’ Insects


Ipm pipe training may 14 th 2007

Observation On-line Form - Viruses


Ipm pipe training may 14 th 2007

Observation On-line Form - Viruses


Downloading excel forms

Downloading Excel Forms


Step 1 location setup excel form

Step 1. Location Setup Excel Form


Location setup excel form

Location Setup Excel Form


Location setup excel form1

Location Setup Excel Form


Location setup excel form2

Location Setup Excel Form


Uploading an excel form

Uploading an Excel Form


Uploading an excel set up form

Uploading an Excel Set Up Form


Observation standard excel form

Observation Standard Excel Form


Observation standard excel form1

Observation Standard Excel Form


Observation aphid excel form

Observation Aphid Excel Form


Observation aphid excel form1

Observation Aphid Excel Form


Uploading an excel form1

Uploading an Excel Form


Uploading an excel observation form

Uploading an Excel Observation Form


New tool the copy locations tool

New Tool – The Copy Locations Tool


New tool the copy locations tool1

New Tool – The Copy Locations Tool


New tool the copy locations tool2

New Tool – The Copy Locations Tool


New tool the copy locations tool3

New Tool – The Copy Locations Tool


Edit tool

Edit Tool


Checking your data

Checking Your Data


Ipm pipe training may 14 th 2007

Contact Information

If you have any follow up questions,

please contact me either via e-mail at [email protected] or at [email protected], or by phone at 814-441-6070


  • Login