Name: Bridge Scupper - IDDE Inspection Form

Display Field: INSPECTOR

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• DATEINSPECT ( type: esriFieldTypeDate , alias: Inspection Date , length: 8 )
• INSPECTOR ( type: esriFieldTypeString , alias: Inspector Name , length: 30 )
• STRUCTUREFOUND ( type: esriFieldTypeString , alias: Structure Found , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• ACCESSIBLE ( type: esriFieldTypeString , alias: Accessible for Sampling , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• ACCESS_NOTES ( type: esriFieldTypeString , alias: Accessibility Notes , length: 250 )
• WEATHER ( type: esriFieldTypeString , alias: Weather Conditions , length: 15 , Coded Values: [Dry Weather: Dry Weather] , [Wet Weather: Wet Weather] )
• LASTRAIN ( type: esriFieldTypeDate , alias: Last Rain Event , length: 8 )
• RAINDURATION ( type: esriFieldTypeDouble , alias: Rain Event Duration (HRS) )
• RAINAMOUNT ( type: esriFieldTypeDouble , alias: Rain Event Amount (inches) )
• FLOW ( type: esriFieldTypeString , alias: Flow , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CLARITY ( type: esriFieldTypeString , alias: Clarity of Flow , length: 10 , Coded Values: [Clear: Clear] , [Cloudy: Cloudy] , [Opaque: Opaque] )
• ODOR ( type: esriFieldTypeString , alias: Odor , length: 15 , Coded Values: [Laundry: Laundry] , [None: None] , [Oil/gas: Oil/gas] , ...3 more... )
• COLOR ( type: esriFieldTypeString , alias: Color of Flow , length: 15 , Coded Values: [Brown: Brown] , [Green: Green] , [None: None] , ...4 more... )
• SEDIMENT ( type: esriFieldTypeString , alias: Sedimentation , length: 45 , Coded Values: [Failing - requires immediate action: Failing - requires immediate action] , [Poor - requires maintenance: Poor - requires maintenance] , [Good - inspect within 2 years: Good - inspect within 2 years] , ...1 more... )
• FLOATABLES ( type: esriFieldTypeString , alias: Floatables , length: 20 , Coded Values: [Laundry/Soap Suds: Laundry/Soap Suds] , [None: None] , [Oil Sheen: Oil Sheen] , ...2 more... )
• STAINING ( type: esriFieldTypeString , alias: Staining , length: 10 , Coded Values: [Black: Black] , [Brown: Brown] , [None: None] , ...4 more... )
• VISUALEVIDENCE ( type: esriFieldTypeString , alias: Visual Evidence of Illicit Discharge , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• NOTES ( type: esriFieldTypeString , alias: Notes , length: 1000 )
• FIELD_DUPLICATE ( type: esriFieldTypeString , alias: QA/QC Duplicate Field Sample , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• TEMP ( type: esriFieldTypeDouble , alias: Temperature (C) )
• TEMP_EXCEED ( type: esriFieldTypeString , alias: Temp abnormal , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_TEMP ( type: esriFieldTypeDouble , alias: dup Temperature (C) )
• DUP_TEMP_EXCEED ( type: esriFieldTypeString , alias: dup Temp abnormal , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CONDUCTIVITY ( type: esriFieldTypeDouble , alias: Conductivity (uS/cm) )
• CONDUCT_EXCEED ( type: esriFieldTypeString , alias: Conductivity >1000 uS/cm , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_CONDUCT ( type: esriFieldTypeDouble , alias: dup Conductivity (uS/cm) )
• DUP_CONDUCT_EXCEED ( type: esriFieldTypeString , alias: dup Conductivity >1000 uS/cm , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• PH ( type: esriFieldTypeDouble , alias: pH )
• PH_EXCEED ( type: esriFieldTypeString , alias: pH < 6 or pH > 8 , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_PH ( type: esriFieldTypeDouble , alias: dup pH )
• DUP_PH_EXCEED ( type: esriFieldTypeString , alias: dup pH < 6 or pH > 8 , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SALINITY ( type: esriFieldTypeDouble , alias: Salinity (ppt) )
• SALINITY_EXCEED ( type: esriFieldTypeString , alias: Salinity > 10 ppt , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_SALINITY ( type: esriFieldTypeDouble , alias: dup Salinity (ppt) )
• DUP_SALINITY_EXCEED ( type: esriFieldTypeString , alias: dup Salinity > 10 ppt , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• AMMONIA ( type: esriFieldTypeDouble , alias: Ammonia (mg/L) )
• AMMONIA_EXCEED ( type: esriFieldTypeString , alias: Ammonia => 0.5 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_AMMONIA ( type: esriFieldTypeDouble , alias: dup Ammonia (mg/L) )
• DUP_AMMONIA_EXCEED ( type: esriFieldTypeString , alias: dup Ammonia => 0.5 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• CHLORINE ( type: esriFieldTypeDouble , alias: Chlorine (mg/L) )
• CHLORINE_EXCEED ( type: esriFieldTypeString , alias: Chlorine > 0.02 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_CHLORINE ( type: esriFieldTypeDouble , alias: dup Chlorine (mg/L) )
• DUP_CHLORINE_EXCEED ( type: esriFieldTypeString , alias: dup Chlorine > 0.02 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• SURFACTANTS ( type: esriFieldTypeDouble , alias: Surfactants (mg/L) )
• SURFACTANTS_EXCEED ( type: esriFieldTypeString , alias: Surfactants => 0.25 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_SURFACTANTS ( type: esriFieldTypeDouble , alias: dup Surfactants (mg/L) )
• DUP_SURFACTANTS_EXCEED ( type: esriFieldTypeString , alias: dup Surfactants => 0.25 mg/L , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• FIELD_NOTES ( type: esriFieldTypeString , alias: Field Sampling Notes , length: 250 )
• BACTERIA_SAMPLE ( type: esriFieldTypeString , alias: Bacteria Sample Collected , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• BACTERIA_SAMPLE_DATE ( type: esriFieldTypeDate , alias: Bacteria Sample Date , length: 8 )
• LAB_DUPLICATE ( type: esriFieldTypeString , alias: QA/QC Duplicate Lab Sample , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• LAB_SAMPLE_NO ( type: esriFieldTypeString , alias: Lab Sample No. , length: 20 )
• DUP_LAB_SAMPLE_NO ( type: esriFieldTypeString , alias: dup Lab Sample No. , length: 20 )
• FECAL_COLIFORM ( type: esriFieldTypeDouble , alias: Fecal Coliform (CFU/100mL) )
• FC_EXCEED ( type: esriFieldTypeString , alias: FC Results > 400 CFU/100 mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_FC ( type: esriFieldTypeDouble , alias: dup Fecal Coliform (CFU/100mL) )
• DUP_FC_EXCEED ( type: esriFieldTypeString , alias: dup FC Results > 400 CFU/100 mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• ENTERO ( type: esriFieldTypeDouble , alias: Enterococci (CFU/100mL or MPN/100mL) )
• ENTERO_EXCEED ( type: esriFieldTypeString , alias: Entero Results >61 (Fresh) or >104 (marine) CFU/100 mL or MPN/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_ENTERO ( type: esriFieldTypeDouble , alias: dup Enterococci (CFU/100mL or MPN/100mL) )
• DUP_ENTERO_EXCEED ( type: esriFieldTypeString , alias: dup Entero Results >61 (Fresh) or >104 (marine) CFU/100 mL or MPN/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• COLIPHAGE ( type: esriFieldTypeDouble , alias: Coliphage (PFU/100mL) )
• COLIPHAGE_EXCEED ( type: esriFieldTypeString , alias: Coliphage Results => 50 PFU/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• DUP_COLIPHAGE ( type: esriFieldTypeDouble , alias: dup Coliphage (PFU/100mL) )
• DUP_COLIPHAGE_EXCEED ( type: esriFieldTypeString , alias: dup Coliphage Results => 50 PFU/100mL , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• LAB_NOTES ( type: esriFieldTypeString , alias: Analysis Notes , length: 200 )
• INVESTIGATION_NEEDED ( type: esriFieldTypeString , alias: Investigation NEEDED , length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Pending: Pending] )
• GUID ( type: esriFieldTypeGUID , alias: GUID , length: 38 )
• PIPEID ( type: esriFieldTypeString , alias: PipeID , length: 15 )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• created_user ( type: esriFieldTypeString , alias: created_user , length: 255 )
• created_date ( type: esriFieldTypeDate , alias: created_date , length: 8 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , length: 255 )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , length: 8 )
• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• LAB ( type: esriFieldTypeString , alias: Lab , length: 25 , Coded Values: [BAL: BAL] , [RIDOT: RIDOH] , [NETLab: NETLab] , ...6 more... )
• SURFACTANT_TEST_TYPE ( type: esriFieldTypeString , alias: Surfactant Test Type , length: 50 , Coded Values: [Optical Method: Optical Method] , [Singal Analyte Photometer: Single Analyte Photometer] )
• CONSULTANT ( type: esriFieldTypeString , alias: Consultant , length: 50 , Coded Values: [Beta Group, Inc.: Beta Group, Inc.] , [CDM Smith, Inc.: CDM Smith, Inc.] , [Crossman Engineering, Inc.: Crossman Engineering, Inc.] , ...16 more... )
• STRUCTUREID ( type: esriFieldTypeInteger , alias: Structure ID )
• QAQC_OVERRIDE ( type: esriFieldTypeString , alias: QAQC Override , length: 10 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• INSPECTION_REASON ( type: esriFieldTypeString , alias: Inspection Reason , length: 50 , Coded Values: [SCP Screening/Sampling: SCP Screening/Sampling] , [IDDE Investigation: IDDE Investigation] , [Monitoring: Monitoring] , ...3 more... )
• COTININE ( type: esriFieldTypeDouble , alias: Cotinine (ng/L) )
• ACETAMINOPHEN ( type: esriFieldTypeDouble , alias: Acetaminophen (ng/L) )
• PARAXANTHINE ( type: esriFieldTypeDouble , alias: Paraxanthine (ng/L) )
• ATENOLOL ( type: esriFieldTypeDouble , alias: Atenolol (ng/L) )
• CAFFEINE ( type: esriFieldTypeDouble , alias: Caffeine (ng/L) )
• METOPROLOL ( type: esriFieldTypeDouble , alias: Metoprolol (ng/L) )
• DIPHENHYDRAMINE ( type: esriFieldTypeDouble , alias: Diphenhydramine (ng/L) )
• CARBAMAZEPINE ( type: esriFieldTypeDouble , alias: Carbamazepine (ng/L) )
• PHARMA_EXCEED ( type: esriFieldTypeString , alias: Pharmaceutical Exceedance? , length: 3 , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )

Relationships:

• SWStructures (0) -- Related To: Bridge Scupper (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata