Is the drought over? no, The groundwater is one of the determining factor as noted below.
USGS 2017
Surface Water: Precipitation in water year 2017 has filled the majority of California's major reservoirs to above-historic average levels. Likewise, as the USGS streamgage network shows, flows in the majority of the streams have been at or above average for most of the last 4 months. This indicates that most of California's rivers, creeks, lakes and reservoirs are in good condition.
Snowpack: On average, the Sierra Nevada snowpack supplies about 30 percent of California’s water needs as it melts in the spring and summer. A series of back-to-back atmospheric river storms blanketed the Sierra Nevada in January 2017. As of February 21, 2017, statewide snow accumulation data indicate that snowpack in the Northern, Central, and Southern Sierra is 186 percent of normal for this date.
Groundwater: Groundwater aquifers recover much more slowly than surface water and are limited, amoung other things, by how much and how fast water can recharge. Unlike surface water, which can recover during a few days of heavy precipitation, groundwater aquifer recovery often takes years or decades. Groundwater systems are also relied upon more heavily during times of drought. In addition, in many areas of the state, groundwater systems have been depleted for long periods - even between droughts - that they have not recovered from. Excessive, long-term groundwater over-use resulting in groundwater depletion can cause subsidence and permanent loss of groundwater storage as well as water quality degradation and seawater intrusion. These long-term impacts on groundwater have not been remedied by the recent weather. If recovery is possible, it will likely take several to many years to accomplish.