CityWorks Drainage Requests
Steps for Publishing CW Requests
Open MXD. 
It will add LCGCityworks.azteca.REQUEST SQL table from CityWorks PROD on LCGSQLPROD2.sde; Centerlines; and Event layer
Copy Definition Query From Table above
Create Event Layer PUT IN SAME QUERY.   RED=Closed;  GREEN=InProg And SAVE in FGDB on G:\Map Requests\2019_Map Request\CityWorksTESTING\CW_DrainageRequests.gdb as Requests2_12_19 layer name
Symbolize on STATUS and remove "Comp"
Remove all layers Except the Requests2_12_19; symbolized as above
PUBLISH OVERWRITE AliciaLcgMaps/CW_DrainageRequests  service  on LCGGISWEB1
None
[]
{'Title': '', 'Author': '', 'Comments': '', 'Subject': '', 'Category': '', 'AntialiasingMode': 'None', 'TextAntialiasingMode': 'Force', 'Keywords': 'requests'}
nan
nan