School (type: esriFieldTypeString, alias: What is the name of your school?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Adams State University: Adams State University], [Alameda High School: Alameda High School], [Albertus Magnus College: Albertus Magnus College], ... 288 more ...)
field_1_other (type: esriFieldTypeString, alias: Other - What is the name of your school?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HSorUG (type: esriFieldTypeString, alias: Are you a high school student?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Dual enrollment: Dual enrollment])
Instructor (type: esriFieldTypeString, alias: What is the last name of your lab instructor?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
TeamName (type: esriFieldTypeString, alias: What is your team name?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SoilWater (type: esriFieldTypeString, alias: Did you sample soil or water?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Soil: Soil], [Water: Water])
Member1First (type: esriFieldTypeString, alias: Team Member #1 (first name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Member1Last (type: esriFieldTypeString, alias: Team Member #1 (Last name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Member2First (type: esriFieldTypeString, alias: Team Member #2 (First name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Member2Last (type: esriFieldTypeString, alias: Team Member #2 (Last name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Member3First (type: esriFieldTypeString, alias: Team Member #3 (First name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Member3Last (type: esriFieldTypeString, alias: Team Member #3 (Last name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Member4First (type: esriFieldTypeString, alias: Team Member #4 (First name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Member4Last (type: esriFieldTypeString, alias: Team Member #4 (Last name), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SoilDate (type: esriFieldTypeDate, alias: Date of Sample collection, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
siteDescription (type: esriFieldTypeString, alias: If there is anything unique or interesting about this collection site, let us know here., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
IDIntroCFUSurvey (type: esriFieldTypeString, alias: Before we can link this data to your existing sample site data, you need to provide the following information exactly as you did before., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
SchoolCFUSurvey (type: esriFieldTypeString, alias: What is the name of your school?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
InstructorCFUSurvey (type: esriFieldTypeString, alias: What is the last name of your lab instructor?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
TeamNameCFUSurvey (type: esriFieldTypeString, alias: What is your team name?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
WaterSoilSelection (type: esriFieldTypeString, alias: Did you sample soil or water?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true, Coded Values: [Water: Water], [Soil: Soil])
CFUIntro (type: esriFieldTypeString, alias: This is the section to add results about your colony counts on plates without antibiotic and with
tetracycline. You should have data from two plate sets matched to the sample ID in the
previous section., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
PlatingDate (type: esriFieldTypeDate, alias: Date of serial dilution and plating, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Tet30PS1dilutionInt (type: esriFieldTypeDate, alias: Date colonies were counted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
IncubTime (type: esriFieldTypeString, alias: Number of days plates were incubated, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [24: About 24 hours], [48: About 48 hours], [3days: About 3 days], ... 2 more ...)
GrowthMed (type: esriFieldTypeString, alias: What growth medium was used?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true, Coded Values: [Mac: MacConkey], [NBA: Nutrient Broth Agar], [R2A: R2A], ... 2 more ...)
IncubTem (type: esriFieldTypeString, alias: At what temperature did you incubate the plates?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [NoInc: No Incubator, just room temperature], [25: 25 degrees C], [28: 28 degrees C], ... 3 more ...)
PS1Intro (type: esriFieldTypeString, alias: Enter colony count data and calculations for Plate Set 1 here., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
PS1PlatingVol (type: esriFieldTypeString, alias: How much volume did you pipet onto each plate?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10: 100µl], [5: 200µl])
NAPS1dilutionMC (type: esriFieldTypeString, alias: Dilution: No Antibiotic Plates (Plate Set 1), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [1: No Dilution], [10: 1/10 dilution], [100: 1/100 dilution], ... 6 more ...)
NAPS1colonies (type: esriFieldTypeInteger, alias: How many colonies: No Antibiotic Plates (Plate Set 1), SQL Type: sqlTypeOther, nullable: true, editable: true)
NAPS1coloniesLess300 (type: esriFieldTypeInteger, alias: Is number of colonies less than 300?, SQL Type: sqlTypeOther, nullable: true, editable: true)
NAPS1CFUStudent (type: esriFieldTypeDouble, alias: CFUs: No Antibiotic Plates (Plate Set 1):, SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet3PS1colonies (type: esriFieldTypeInteger, alias: How many colonies: 3ug/ml tetracycline plates ( "Tet3") (Plate Set 1), SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet3PS1coloniesLess300 (type: esriFieldTypeInteger, alias: Is number of colonies less than 300?, SQL Type: sqlTypeOther, nullable: true, editable: true)
PercentTet3PS1Stud (type: esriFieldTypeDouble, alias: Percent Resistance: Percent of total CFU that are resistant to 3ug/ml tetracycline, SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet30PS1colonies (type: esriFieldTypeInteger, alias: How many colonies: 30ug/ml tetracycline plates ( "Tet30") (Plate Set 1):, SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet30PS1coloniesLess300 (type: esriFieldTypeInteger, alias: Is number of colonies less than 300?, SQL Type: sqlTypeOther, nullable: true, editable: true)
PercentTet30PS1Stud (type: esriFieldTypeDouble, alias: Percent Resistance: Percent of total CFU that are resistant to 30ug/ml tetracycline, SQL Type: sqlTypeOther, nullable: true, editable: true)
PS2Intro (type: esriFieldTypeString, alias: Enter colony count data and calculations for Plate Set 2 here., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
PS2PlatingVol (type: esriFieldTypeString, alias: How much volume did you pipet onto each plate?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [10: 100µl], [5: 200µl])
NAPS2dilutionMC (type: esriFieldTypeString, alias: Dilution: No Antibiotic Plates (Plate Set 2):, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [1: No Dilution], [10: 1/10 dilution], [100: 1/100 dilution], ... 6 more ...)
NAPS2colonies (type: esriFieldTypeInteger, alias: How many colonies: No Antibiotic Plates (Plate Set 2):, SQL Type: sqlTypeOther, nullable: true, editable: true)
NAPS2coloniesLess300 (type: esriFieldTypeInteger, alias: Is number of colonies less than 300?, SQL Type: sqlTypeOther, nullable: true, editable: true)
NAPS2CFUStudent (type: esriFieldTypeDouble, alias: CFUs: No Antibiotic Plates (Plate Set 2):, SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet3PS2colonies (type: esriFieldTypeInteger, alias: How many colonies: 3ug/ml tetracycline plates ( "Tet3") (Plate Set 2):, SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet3PS2coloniesLess300 (type: esriFieldTypeInteger, alias: Is number of colonies less than 300?, SQL Type: sqlTypeOther, nullable: true, editable: true)
PercentTet3PS2Stud (type: esriFieldTypeDouble, alias: Percent Resistance: Percent of total CFU that are resistant to 3ug/ml tetracycline, SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet30PS2colonies (type: esriFieldTypeInteger, alias: How many colonies: 30ug/ml tetracycline plates ( "Tet30") (Plate Set 2):, SQL Type: sqlTypeOther, nullable: true, editable: true)
Tet30PS2coloniesLess300 (type: esriFieldTypeInteger, alias: Is number of colonies less than 300?, SQL Type: sqlTypeOther, nullable: true, editable: true)
PercentTet30PS2Stud (type: esriFieldTypeDouble, alias: Percent Resistance: Percent of total CFU that are resistant to 30ug/ml tetracycline, SQL Type: sqlTypeOther, nullable: true, editable: true)
GeoMapNote (type: esriFieldTypeString, alias: This section includes calculations performed to determine if your entered tetracycline resistance data meet the standards to be displayed on the GeoMap, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
PS1LessThan100PercentTet3R (type: esriFieldTypeDouble, alias: Is PS1 Tet3 value over 100%?, SQL Type: sqlTypeOther, nullable: true, editable: true)
PS2LessThan100PercentTet3R (type: esriFieldTypeDouble, alias: Is PS2 Tet3 value over 100%?, SQL Type: sqlTypeOther, nullable: true, editable: true)
AbsValDiffPerTet3R (type: esriFieldTypeDouble, alias: 3ug/ml tetracycline percent resistance: Absolute value of the difference between Plate Set 1 and Plate Set 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
AvgTet3RElimDupValues (type: esriFieldTypeDouble, alias: This is to check whether both the PS1 and PS2 values are identical for No AB CFUs and Tet3 CFUs., SQL Type: sqlTypeOther, nullable: true, editable: true)
PercentDiffTet3 (type: esriFieldTypeDouble, alias: This calculates percent diff PS1 vs PS2 (Tet3) using the curated values, SQL Type: sqlTypeOther, nullable: true, editable: true)
AvgTet3ResistUsable (type: esriFieldTypeDouble, alias: You will see an average 3ug/ml tetracycline resistance value here if the data pass curation tests, SQL Type: sqlTypeOther, nullable: true, editable: true)
PS1LessThan100PercentTet30R (type: esriFieldTypeDouble, alias: Is PS1 Tet30 value over 100%?, SQL Type: sqlTypeOther, nullable: true, editable: true)
PS2LessThan100PercentTet30R (type: esriFieldTypeDouble, alias: Is PS2 Tet30 value over 100%?, SQL Type: sqlTypeOther, nullable: true, editable: true)
AbsValDiffPerTet30R (type: esriFieldTypeDouble, alias: 30ug/ml tetracycline percent resistance: Absolute value of the difference between Plate Set 1 and Plate Set 2, SQL Type: sqlTypeOther, nullable: true, editable: true)
AvgTet30ResistUsable (type: esriFieldTypeDouble, alias: You will see an average 30ug/ml tetracycline resistance value here if the data pass curation tests, SQL Type: sqlTypeOther, nullable: true, editable: true)
AvgTet30RElimDupValues (type: esriFieldTypeDouble, alias: This is to check whether both the PS1 and PS2 values are identical for No AB CFUs and Tet30 CFUs., SQL Type: sqlTypeOther, nullable: true, editable: true)
PercentDiffTet30 (type: esriFieldTypeDouble, alias: 30ug/ml tetracycline resistance: percent difference between PS1 vs PS2, SQL Type: sqlTypeOther, nullable: true, editable: true)