home | gmsts.org | directory | data depot | faq | news | contact us | search | cooperators | site map
 
 
2003 Data Validations

QUAD-BASED TRAP PLACEMENT DATA

Error Message

Validation

No site data found

A record exists with predetermined info for each site

Quad abbreviation missing
Quad abbreviation/code invalid

Quad code is present and valid

Site number missing
Site number is zero

Site number is present and greater than zero

Placement date missing
Invalid date

Trap placement date is present and valid

Trapper's initials missing
Invalid initials for agency

Trapper initials are present and valid within the agency responsible for the site

Trap type missing
Trap type invalid

Trap type is one of the following: D, M, O (delta, milk carton, omit)

Omit reason missing
Omit reason invalid

A valid reason is included for each omitted site: H, L, O, W, R, V, S, X, B

Duplicate site in quad

Each record has a unique quad code and site number

Duplicate UTMs
Duplicate gridnode UTMs

UTM coordinates are unique within the UTM zone
Each record corresponds to a unique predeterimed grinode

COUNTY-BASED TRAP PLACEMENT DATA

Error Message

Validation

No site data found

A record exists with predetermined info for each site

County code missing
Invalid state and/or county

County code is present and valid

Site number missing
Site number is zero

Site number is present and greater than zero

Placement date missing
Invalid date

Trap placement date is present and valid

Trapper's initials missing
Invalid initials for agency

Trapper initials are present and valid within the agency responsible for the site

Trap type missing
Trap type invalid

Trap type is one of the following: D, M, O (delta, milk carton, omit)

Omit reason missing
Omit reason invalid

A valid reason is included for each omitted site: H, L, O, W, R, V, S, X, B

Duplicate site in county/block

Each record has a unique county code, block_id, and site number

Duplicate UTMs
Duplicate gridnode UTMs

UTM coordinates are unique within the UTM zone
Each record corresponds to a unique predeterimed grinode

QUAD-BASED TRAP INSPECTION DATA

Error Message

Validation

Quad abbreviation missing
Quad abbreviation/code invalid

Quad code is present and valid

Site number missing
Site number is zero

Site number is present and greater than zero

No trap placement record match

A trap placement record exists for this quad and site

Inspection at omitted site

Inspections should be performed on placed traps

Trapper's initials missing
Invalid initials for agency

Trapper initials are present and valid within agency responsible for site

Duplicate inspection

Each record has a unique quad, site, date, and inspection type

(One routine trap inspection and one passing or failing QC inspection are allowed on the same date. A trapper should visit a site only one time in a day.)

Final visit before midseason

All midseason inspection dates are earlier than final inspections

Trap condition missing
Trap condition invalid

Trap condition is one of the following: D, G, I, M
(damaged, good, inaccessible, missing)

Catch value missing

If trap condition is D or G, trap catch must be greater than or equal to zero

Catch Present, Trap Missing/Inaccessible

If trap condition is I or M, trap catch should be blank

QC Field Check code invalid

Field check entry, if present, is either a P or F to indicate a quality control inspection

QC Fail code missing or invalid

If field check entry is F, a valid quality control failure code must be entered (A, C, D, G, I, R, T, U, X, M)

Trap check missing or invalid

Trap check is either M or F (midseason or final)

Duplicate final visit

Only one final routine inspection may be reported for a site
(Supervisors may also report a final QC inspection.)

COUNTY-BASED TRAP INSPECTION DATA

Error Message

Validation

County code missing
Invalid state and/or county

County code is present and valid

Site number missing
Site number is zero

Site number is present and greater than zero

No trap placement record match

A trap placement record exists for this county, block_id, and site

Inspection at omitted site

Inspections should be performed on placed traps

Trapper's initials missing
Invalid initials for agency

Trapper initials are present and valid within agency responsible for site

Duplicate inspection

Each record has a unique county, block_id, site, date, and inspection type

(One routine trap inspection and one passing or failing QC inspection are allowed on the same date. A trapper should visit a site only one time in a day.)

Final visit before midseason

All midseason inspection dates are earlier than final inspections

Trap condition missing
Trap condition invalid

Trap condition is one of the following: D, G, I, M
(damaged, good, inaccessible, missing)

Catch value missing

If trap condition is D or G, trap catch must be greater than or equal to zero

Catch Present, Trap Missing/Inaccessible

If trap condition is I or M, trap catch should be blank

QC Field Check code invalid

Field check entry, if present, is either a P or F to indicate a quality control inspection

QC Fail code missing or invalid

If field check entry is F, a valid quality control failure code must be entered (A, C, D, G, I, R, T, U, X, M)

Trap check missing or invalid

Trap check is either M or F (midseason or final)

Duplicate final visit

Only one final routine inspection may be reported for a site
(Supervisors may also report a final QC inspection.)

 
home | gmsts.org | directory | data depot | faq | news | contact us | search | cooperators | site map
2007 © Copyright GMSTS Fondation, Inc. All rights reserved. Read Disclaimer Statement.