Name: Outlet IDDE Inspection Form
Display Field: DATE_VISIT
Type: Table
Description:
Copyright Text:
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- DATESTORM (type: esriFieldTypeDate, alias: Date of Last Storm, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- DATE_VISIT (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ASSETGUID (type: esriFieldTypeGUID, alias: Asset Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- INSPECTOR (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- INSPECT_TYPE (type: esriFieldTypeString, alias: Type of Inspection, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Condition Only: Condition Only], [Maintenance Only: Maintenance Only], [Maintenance and Condition: Maintenance and Condition], ... 2 more ...)
- STRUCTURE_FOUND (type: esriFieldTypeString, alias: Structure Found?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- STRUCTURE (type: esriFieldTypeString, alias: Structure Condition, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [0: Poor- requires maintenance], [1: Failing- requires immediate action], [2: Good- inspect within 2 years], ... 4 more ...)
- DEPTH_OF_SEDIMENT (type: esriFieldTypeString, alias: Depth of Sediment, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [No sediment: No sediment], [Sump less than half full: Sump less than half full], [Sump half full: Sump half full], ... 2 more ...)
- DRY_WEATHER_FLOW (type: esriFieldTypeString, alias: Flow?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- CNOTES (type: esriFieldTypeString, alias: Condition Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- NEEDS_SERVICE (type: esriFieldTypeString, alias: Needs Repair, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- NEEDS_CLEANING (type: esriFieldTypeString, alias: Needs Cleaning, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- BROKEN_PIPE (type: esriFieldTypeString, alias: Pipe Broken, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- FNOTES (type: esriFieldTypeString, alias: Follow up Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- COLOR (type: esriFieldTypeString, alias: Color of Flow, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [N/A: N/A], [Clear: Clear], [Tea/Coffee: Tea/Coffee], ... 11 more ...)
- CLARITY (type: esriFieldTypeString, alias: Clarity of Flow, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Clear: Clear], [Cloudy: Cloudy], [Opaque: Opaque])
- FLOATABLES (type: esriFieldTypeString, alias: Floatables, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- ODOR (type: esriFieldTypeString, alias: Odor, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [None: None], [Rotten eggs/hydrogen sulfide: Rotten eggs/hydrogen sulfide], [Musty odor: Musty odor], ... 5 more ...)
- FOAMFILM (type: esriFieldTypeString, alias: Sewage, Sheens and Scum, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- TEMPCELSIUS (type: esriFieldTypeDouble, alias: Temperature (deg F), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 100])
- CONDUCTIVITY (type: esriFieldTypeDouble, alias: Conductivity (micro-Siemens/cm), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 20000])
- PH (type: esriFieldTypeDouble, alias: pH, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 14])
- SALINITYPPM (type: esriFieldTypeDouble, alias: Salinity (ppm), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 20000])
- AMMONIA (type: esriFieldTypeDouble, alias: Ammonia (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 10])
- CHLORINE (type: esriFieldTypeDouble, alias: Chlorine (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 2])
- SURFACTANTS (type: esriFieldTypeDouble, alias: Surfactants (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 3])
- ADDTLPARAMETERS (type: esriFieldTypeString, alias: Additional Parameters Screened, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- IDDECLASS (type: esriFieldTypeString, alias: IDDE Classification, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Potential: Potential], [Obvious: Obvious], [Unlikely: Unlikely], ... 1 more ...)
- REASONILLICIT (type: esriFieldTypeString, alias: IDDE Classification Notes, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- LABSMPLCOLLECTED (type: esriFieldTypeString, alias: Sample for Lab Collected?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- LABSAMPLE1 (type: esriFieldTypeString, alias: 1. Lab Sample Test, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Aluminum, Total: Aluminum, Total], [Ammonia - Nitrogen: Ammonia - Nitrogen], [Arsenic, Total: Arsenic, Total], ... 20 more ...)
- LABRESULTS1 (type: esriFieldTypeString, alias: 1. Lab Sample Results, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LABSAMPLE2 (type: esriFieldTypeString, alias: 2. Lab Sample Test, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Aluminum, Total: Aluminum, Total], [Ammonia - Nitrogen: Ammonia - Nitrogen], [Arsenic, Total: Arsenic, Total], ... 20 more ...)
- LABRESULTS2 (type: esriFieldTypeString, alias: 2. Lab Sample Results, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LABSAMPLE3 (type: esriFieldTypeString, alias: 3. Lab Sample Test, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Aluminum, Total: Aluminum, Total], [Ammonia - Nitrogen: Ammonia - Nitrogen], [Arsenic, Total: Arsenic, Total], ... 20 more ...)
- LABRESULTS3 (type: esriFieldTypeString, alias: 3. Lab Sample Results, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- LABSAMPLE4 (type: esriFieldTypeString, alias: 4. Lab Sample Test, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- INVESTIIGATION_STATUS (type: esriFieldTypeString, alias: Investigation Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0: Complete], [1: Follow-up needed], [2: Not complete], ... 2 more ...)
- OBSERVED_DUMPING (type: esriFieldTypeString, alias: Observed Signs of Dumping?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- OBSERVED_DUMPING_NOTES (type: esriFieldTypeString, alias: Dumping Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- OBSERVED_WEATHER (type: esriFieldTypeString, alias: Observed Weather, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- FLOW_INTENSITY (type: esriFieldTypeString, alias: Flow Intensity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Low: Low], [Moderate: Moderate], [Heavy: Heavy])
- STRUCTURE_ACCESSIBLE (type: esriFieldTypeString, alias: Structure Accessible?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- STAINING (type: esriFieldTypeString, alias: Signs of Staining?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- SCOUR (type: esriFieldTypeString, alias: Signs of Scour?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- STAINING_SCOUR_NOTES (type: esriFieldTypeString, alias: Staining/Scour Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- LABRESULTS4 (type: esriFieldTypeString, alias: 4. Lab Sample Results, SQL Type: sqlTypeOther, length: 50, 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)
- StructureID (type: esriFieldTypeString, alias: Structure ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- STRUCTURE_ACCESSIBLE_NOTES (type: esriFieldTypeString, alias: Next upstream structure visited?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- POT_PRIV_OWN (type: esriFieldTypeString, alias: Potentially Privately Owned?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Not Entered: Not Entered], [Yes: Yes], [No: No])
- PRIV_OWN_NOTES (type: esriFieldTypeString, alias: Privately Owned Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
- STAND_WATER (type: esriFieldTypeString, alias: Standing Water Observed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- PIPE_SUMBERGED (type: esriFieldTypeString, alias: Pipe Submerged?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- STAND_SUMBERGE_NOTES (type: esriFieldTypeString, alias: Standing Water/Submerged Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Outlet IDDE Inspection Form
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
- Outlets (0) -- Related To: Outlets (4)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/29/2023 1:43:28 AM
Schema Last Edit Date: 7/29/2023 1:43:28 AM
Data Last Edit Date: 7/29/2023 1:39:48 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat