FALSE 1.0 ESMGDB.PGCSW.IDDE 002 ESMGDB.PGCSW.IDDE_StormDrainStructures Relationship 20220111 13533900 20220104 11003200 20220104 11003200 IDDE Illicit Discharge Detection and Elimination X-Ray NaN NaN NaN NaN OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. AIR_TEMP Air Temperature Double 8 38 8 Air Temperature MDE_GDB_ID MDE GDB ID String 13 0 0 MDE_GDB_ID_Outfall MDE_GDB_ID of Outfall String 13 0 0 ALGAEGROW Algae Growth Observed String 1 0 0 Algae Growth Observed CFS_FLOW Flow rate in cubic feet per second (CFS) Double 8 38 8 Flow rate in cubic feet per second (CFS) CHEM_TEST Chemical test String 1 0 0 Chemical test CHLORINE Chlorine Double 8 38 8 Chlorine CLARITY Clarity String 3 0 0 Clarity COLOR Color String 3 0 0 Color COMPLA_NUM Is screening complaint driven? String 1 0 0 Is screening complaint driven? COPPER Copper Double 8 38 8 Copper created_date Date created Date 8 0 0 Date created created_user Created by String 255 0 0 Created by DEPOSITS Deposits in outfall area String 3 0 0 Deposits in outfall area DETERGENTS Detergents Double 8 38 8 Detergents DISCHARGE_SOURCE Discharge Source String 3 0 0 Discharge Source EROSION Erosion String 1 0 0 Erosion FLOATABLES Floatables present in discharge String 3 0 0 Floatables present in discharge GEN_COMMENTS General comments String 255 0 0 General comments ILLICIT_ELIM Status of the illicit discharge String 1 0 0 What is the status of the illicit discharge ILLICIT_Q Was the discharge illicit String 1 0 0 Was the discharge illicit? last_edited_date Last edited date Date 8 0 0 Last edited date last_edited_user Last edited by String 255 0 0 Last edited by LAST_RAIN Date of last rain Date 8 0 0 Date of last rain OBSERV_FLOW Was flow observed String 1 0 0 Was flow observed ODOR Describe odor String 3 0 0 Describe odor pH pH Double 8 38 8 pH PHENOL Phenol Double 8 38 8 Phenol REPORTING_YEAR Reporting Year String 4 0 0 Reporting Year SCREEN_DATE Screen Date Date 8 0 0 Screen Date SCREEN_TIME Screen Time String 8 0 0 Screen Time Str_ID Structure ID Integer 4 10 0 Str_ID STRUCT_COND Structure Condition String 3 0 0 Structure Condition InspectorName Inspector Name String 2 0 0 Access Access String 1 0 0 TEST_NUM Inspection Type SmallInteger 2 5 0 Test Number VEG_COND Vegetative condition in outfall area String 3 0 0 Vegetative condition in outfall area WATER_TEMP Water Temperature Double 8 38 8 Water Temperature YEAR_ELIM Year illicit discharge was eliminated String 4 0 0 Year illicit discharge was eliminated ESMGDB.PGCSW.IDDE Table 0 GlobalID GlobalID GlobalID 38 0 0 Esri ArcGIS 12.9.0.32739 ESMGDB.PGCSW.IDDE Enterprise Geodatabase Table dataset 20220104