Layer: Pare_SamplePCR_Join__NewApril2024

View In: Map Viewer

Name: Pare_SamplePCR_Join__NewApril2024_JoinView

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Sources

Description: AttributeJoin

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Pare Sample Survey - New April 2024","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectId

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Banner (type: esriFieldTypeString, alias: Banner, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
SurveyIntro (type: esriFieldTypeString, alias: Welcome, student scientists! Thank you for participating in the Prevalence of Antibiotic Resistance in the Environment (PARE) project. The data you've collected will help us understand and combat the spread of antibiotic resistance in our environment. Because the data you enter here will be used in a real scientific study, please ensure that all information is accurate and complete to the best of your ability. Please make only one entry per sample. Work with your team members to reach answers that you all agree with., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
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], ... 184 more ...)
SchoolOther (type: esriFieldTypeString, alias: If your school is not in the drop-down menu, write it in the space below., 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], [DualEnroll: 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)
IDInstructions (type: esriFieldTypeString, alias: In order to add additional information about this sample later, you will need to give this sample a unique ID. You must remember this ID for the next time you enter data about this sample., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SoilID (type: esriFieldTypeString, alias: Sample ID, 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])
MemberNote (type: esriFieldTypeString, alias: What are the names of your team members? They will appear in the database exactly how you write them here., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
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)
soilThanks (type: esriFieldTypeString, alias: Thanks! That's all we need for now. Be sure to click "Submit" to record your data. Later, you will need to remember the EXACT spelling of your sample ID (based on your team name and teacher last name)., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
globalid_1712780036967 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Banner_1712780036967 (type: esriFieldTypeString, alias: Banner, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
SurveyIntroPCRSurvey (type: esriFieldTypeString, alias: Welcome, student scientists! Thank you for participating in the Prevalence of Antibiotic Resistance in the Environment (PARE) project. The data you've collected will help us understand and combat the spread of antibiotic resistance in our environment. Because the data you enter here will be used in a real scientific study, please ensure that all information is accurate and complete to the best of your ability., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
SchoolName (type: esriFieldTypeString, alias: What is the name of your school?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true, Coded Values: [Adams State University: Adams State University], [Alameda High School: Alameda High School], [Albertus Magnus College: Albertus Magnus College], ... 184 more ...)
SchoolOtherPCRSurvey (type: esriFieldTypeString, alias: If your school is not in the drop-down menu, write it in the space below., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
InstructorPCRSurvey (type: esriFieldTypeString, alias: What is the last name of your lab instructor?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
TeamNamePCRSurvey (type: esriFieldTypeString, alias: What is your team name?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
SoilIDPCRSurvey (type: esriFieldTypeString, alias: Sample ID, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
WaterorSoil (type: esriFieldTypeString, alias: Did you sample soil or water?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true, Coded Values: [soil: Soil], [water: Water])
eDNAvsColony (type: esriFieldTypeString, alias: Did you perform PCR on DNA extracted from a colony or DNA extracted directly from soil or water?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true, Coded Values: [soil: Soil], [water: Water], [Colony: Colony])
PCRGene (type: esriFieldTypeString, alias: For this DNA sample, what antimicrobial resistance genes did you detect as a band on a gel?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
OtherGenesDetectPos (type: esriFieldTypeString, alias: If you detected other genes not on the list, please name them below., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
PCRGeneNeg (type: esriFieldTypeString, alias: Original Data ONLY QUESTION:For this soil sample, what antimicrobial resistance genes did you test for, but saw a clear negative result (gene not present)?, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
OtherGenesDetectNeg (type: esriFieldTypeString, alias: Original Data ONLY QUESTION: If you saw a negative results for other genes not on the list, please name them below., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
ImageNote (type: esriFieldTypeString, alias: You will need to upload a labeled image of a positive band on a gel to document evidence that the gene(s) are present in your DNA sample., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
PCRGeneFail (type: esriFieldTypeString, alias: Original Data Only: If some or all of your PCR results were not conclusive or were difficult to interpret, please indicate below., SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
CreationDate_1712780036967 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator_1712780036967 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate_1712780036967 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor_1712780036967 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/3/2024 2:14:32 PM

Schema Last Edit Date: 4/10/2024 8:13:59 PM

Data Last Edit Date: 4/10/2024 8:03:14 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Pare_SamplePCR_Join__NewApril2024_JoinView (ID:0)