Layer: Outlet IDDE Inspection Form (ID:15)

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:

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:

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