def sjr_sac(sjr_in, sac_in): calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file tw = prepro_window() sjr_path = calsim_path("C639") sjr_ret_path = calsim_path("R644") sjr_ref = findpath(f, sjr_path) if not sjr_ref: raise "San Joaquin path %s not found" % sjr_path sjr_ret_ref = findpath(f, sjr_ret_path) if not sjr_ret_ref: raise "San Joaquin return flow path %s not found" % sjr_ret_path sjr = DataReference.create(sjr_ref[0], tw).getData() sjr_ret = DataReference.create(sjr_ret_ref[0], tw).getData() sjr_in = sjr + sjr_ret sac_path = calsim_path("C169") frwa_div1_path = calsim_path("D168B") frwa_div2_path = calsim_path("D168C") sac_ref = findpath(f, sac_path) if not sac_ref: raise "Sacramento path %s not found" % sac_path frwa_div1_ref = findpath(f, frwa_div1_path) if not frwa_div1_ref: raise "Freeport Regional Water Authority Diversion path %s not found" % frwa_div1_path frwa_div2_ref = findpath(f, frwa_div2_path) if not frwa_div2_ref: raise "Freeport Regional Water Authority Diversion path %s not found" % frwa_div2_path sac = DataReference.create(sac_ref[0], tw).getData() frwa_div1 = DataReference.create(frwa_div1_ref[0], tw).getData() frwa_div2 = DataReference.create(frwa_div2_ref[0], tw).getData() sac_in = sac + frwa_div1 + frwa_div2 return
def dccOp(infile,outfile,inpath,outpath,allThirty=1,value=1.0, tw="01OCT1974 0000 - 01OCT1991 0000"): """ Converts Delta Cross Channel gate operation from a CALSIM file containing fraction of days open Args: infile CALSIM dss file specifying # days operating outfile output dss file readable by DSM2 inpath input path, e.g. /CALSIM/DXC/GATE-DAYS-OPEN//1MON// outpath output path, e.g. /CALSIM/DXC/GATE//IR-YEAR/fpart/ value time series value when gate is opened (must be 1.0 or 2.0), where 1.0 is used for gate ops and 2.0 is number gates operating. tw time window of output allThirty true if CALSIM input is hardwired to thirty day months """ from vutils import timewindow from vdss import opendss,findpath,writedss from vista.time import TimeWindow from vista.set import DataReference import types g=opendss(infile) if not (type(outfile) == types.StringType): raise TypeError("Argument outfile should be name of a dss file") if not isinstance(tw,TimeWindow): tw = timewindow(tw) if not (value==1.0 or value==2.0): raise "Output time series 'on' value should be 1.0 (gate op) or 2.0 (gates operating)" x=findpath(g,inpath)[0] dxcref = DataReference.create(findpath(g,inpath)[0],tw) dxc=dxcref.getData() if not dxc: raise "Cross channel data not found" dxcITS=daysPerMonthToITS(dxc,value,allThirty) writedss(outfile,outpath,dxcITS) return dxcITS
def moke_consumnes(): calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw = prepro_window() moke_us_path = calsim_path("I504") moke_ref = findpath(f, moke_us_path) if (moke_ref and len(moke_ref) > 0): print "Upstream mokelumne flow found, not calculated" consumnes_path = calsim_path("C501") moke_ds_path = calsim_path("C504") consumnes_ref = findpath(f, consumnes_path) if not consumnes_ref: raise "Consumnes path %s not found" % consumnes_path moke_ds_ref = findpath(f, moke_ds_path) if not moke_ds_ref: raise "Mokulemne downstream path %s not found" % moke_ds_path consumnes = DataReference.create(consumnes_ref[0], tw).getData() moke_ds = DataReference.create(moke_ds_ref[0], tw).getData() mf = calsim_study_fpart(modify=1) moke_us_path = calsim_path("I504", mf) moke_us = moke_ds - consumnes writedss(outfile, moke_us_path, moke_us) return
def moke_consumnes(): calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw = prepro_window() moke_us_path = calsim_path("I504") moke_ref = findpath(f, moke_us_path) if moke_ref and len(moke_ref) > 0: print "Upstream mokelumne flow found, not calculated" consumnes_path = calsim_path("C501") moke_ds_path = calsim_path("C504") consumnes_ref = findpath(f, consumnes_path) if not consumnes_ref: raise "Consumnes path %s not found" % consumnes_path moke_ds_ref = findpath(f, moke_ds_path) if not moke_ds_ref: raise "Mokulemne downstream path %s not found" % moke_ds_path consumnes = DataReference.create(consumnes_ref[0], tw).getData() moke_ds = DataReference.create(moke_ds_ref[0], tw).getData() mf = calsim_study_fpart(modify=1) moke_us_path = calsim_path("I504", mf) moke_us = moke_ds - consumnes writedss(outfile, moke_us_path, moke_us) return
def test_findpath(self): g=vdss.opendss(self.file1) gx=vdss.findpath(g, '/VISTA-EX1/////') self.assertTrue(len(gx) > 1) gx=vdss.findpath(g,'/EX1/////COS/',False) self.assertTrue(len(gx)==1) gx=vdss.findpath(g,'//////COS/',False) self.assertTrue(len(gx)==1) gx=vdss.findpath(g,'//////COS/',True) self.assertTrue(gx==None)
def get_ref(group, path, calculate_dts, pathname_maps, group_no): if calculate_dts==1: #FIXME: add expression parser to enable any expression vars = path.split('+') ref=None for varname in vars: pmap = get_pathmap_for_varname(varname, pathname_maps) if group_no==1: xref=get_ref(group, pmap.path1, 0, pathname_maps, group_no) elif group_no==2: xref=get_ref(group, pmap.path2, 0, pathname_maps, group_no) if ref==None: ref=xref else: ref=ref+xref return ref try: refs = vdss.findpath(group, path) if refs == None: print "No data found for %s and %s" % (group, path) else: return refs[0] except: print "Exception while trying to retrieve %s from %s"%(path, group) return None
def transfer_ec(): """ Unsmoothed transfer from CALSIM file to model input file. """ f=opendss(getAttr("CALSIMFILE")) # open CALSIM file outfile=getAttr("BOUNDARYFILE") process=getAttr("SJR_PROCESS") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw=prepro_window() calsimstudy=calsim_study_fpart(modify=0) calsimstudyout=calsim_study_fpart(modify=1) if not calsimstudy or calsimstudy=="": print "CALSIMSTUDY envvar not set" dsspath="/CALSIM.*/VERNWQFINAL/SALINITY-EC//1MON/%s/" % calsimstudy processedpath=dsspath.replace(".*","-"+process).replace( "1MON","1DAY").replace(calsimstudy,calsimstudyout) print processedpath refs=findpath(f,dsspath) if not refs or len(refs)> 1: raise "Vernalis EC path %s not found or not unique" % dsspath ref=DataReference.create(refs[0],tw) monthly=ref.getData() daily=interpolate(monthly,"1DAY") if daily: writedss(outfile,processedpath, daily) else: raise "Failure to find CALSIM input data for: " + calsimname return
def txfr_flow_day(nodes_to_txfr_day): """ Unsmoothed transfer from CALSIM file to model input file. """ calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw = prepro_window() for calsimname in nodes_to_txfr_day: # Extend the list as needed mf = calsim_study_fpart(modify=1) dsspath = calsim_path(calsimname) dsspath1 = calsim_path(calsimname, modified_fpart=mf) processedpath = dsspath1.replace("1MON", "1DAY") print dsspath print processedpath paths = findpath(f, dsspath) if not paths or len(paths) > 1: print "File: %s" % calsimfile raise "Path %s not found or not unique" % dsspath ref = DataReference.create(paths[0], tw) monthly = ref.getData() daily = interpolate(monthly, "1DAY") if daily: writedss(outfile, processedpath, daily) else: raise "Failure to find CALSIM input data for: " + calsimname
def transfer_flow(nodes_to_transfer): """ Unsmoothed transfer from CALSIM file to model input file. """ calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw = prepro_window() for calsimname in nodes_to_transfer: # Extend the list as needed, but please keep in mind the # limitations of the conservative spline, at least at present. # Mainly, input flows should be substantially greater than # zero at all times (yolo would be inappropriate, for instance) dsspath = calsim_path(calsimname) paths = findpath(f, dsspath) if not paths or len(paths) > 1: print "File: %s" % calsimfile raise "Path %s not found or not unique" % dsspath ref = DataReference.create(paths[0], tw) monthly = ref.getData() mf = calsim_study_fpart(modify=1) dsspath = calsim_path(calsimname, modified_fpart=mf) if monthly: writedss(outfile, dsspath, monthly) else: raise "Failure to find CALSIM input data for: " + calsimname
def extend_flow(nodes_to_extend): """ Copying WY1922 data to WY1921 for allowing to preprocessing and running DSM2 from 01Jan1921. """ calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw = timewindow("01OCT1921 0000 - 01OCT1922 0000") for calsimname in nodes_to_extend: print calsimname dsspath = calsim_path(calsimname) paths = findpath(f, dsspath) if not paths or len(paths) > 1: print "File: %s" % calsimfile raise "Path %s not found or not unique" % dsspath ref = DataReference.create(paths[0], tw) monthly = ref.getData() itr = monthly.getIterator() d = zeros(len(monthly), 'd') count = 0 while not itr.atEnd(): el = itr.getElement() d[count] = el.getY() count = count + 1 itr.advance() stime = "01OCT1920 0000" rts = RegularTimeSeries(monthly.getName(),stime, \ timeinterval("1MON").toString(), d, None, monthly.getAttributes()) writedss(calsimfile, ref.getPathname().toString(), rts)
def dss_retrieve_ts(file, path): f = opendss(file) g = findpath(f, path) if g == None or len(g) != 1: raise ValueError("Path %s in file s% does not exist or is not unique" % (path, file)) return g[0].getData()
def extend_flow(nodes_to_extend): """ Copying WY1922 data to WY1921 for allowing to preprocessing and running DSM2 from 01Jan1921. """ calsimfile=getAttr("CALSIMFILE") f=opendss(calsimfile) # open CALSIM file outfile=getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw=timewindow("01OCT1921 0000 - 01OCT1922 0000") for calsimname in nodes_to_extend: print calsimname dsspath = calsim_path(calsimname) paths = findpath(f,dsspath) if not paths or len(paths)>1: print "File: %s" % calsimfile raise "Path %s not found or not unique" % dsspath ref=DataReference.create(paths[0],tw) monthly=ref.getData() itr = monthly.getIterator() d=zeros(len(monthly),'d') count=0 while not itr.atEnd(): el = itr.getElement() d[count] = el.getY() count = count + 1 itr.advance() stime = "01OCT1920 0000" rts = RegularTimeSeries(monthly.getName(),stime, \ timeinterval("1MON").toString(), d, None, monthly.getAttributes()) writedss(calsimfile,ref.getPathname().toString(),rts)
def get_ref(group, path, calculate_dts=0): if calculate_dts==1: return None # TBD: refs = vdss.findpath(group, path) if refs == None: print "No data found for %s and %s" % (group, path) else: return refs[0]
def prep_ndo(calsimf, dss_step, dss_fpart, twstr): ndofile = opendss(calsimf) TWIND = timewindow(twstr) ndo = DataReference.create( findpath(ndofile, "/CALSIM/NDO/FLOW-NDO//" + dss_step + "/" + dss_fpart + "/")[0], TWIND).getData() ndo15 = conserve.conserveSpline(ndo, "15MIN") ndo15.getAttributes().setYUnits("CFS") ndo15.getAttributes().setYType("PER-AVER") writedss(calsimf, "/CALSIM/NDO/FLOW-NDO//15MIN/" + dss_fpart + "/", ndo15) return 0
def prep_dicu(infile, outfile, tw): from vdss import opendss, writedss, findpath if (not infile): raise TypeError("infile was None") if (not outfile): raise TypeError("outfile was None") if (not infile.endswith("dss") and outfile.endswith("dss")): raise "infile and outfile arguments must be a dss file" g = opendss(infile) all = findpath(g, "///DRAIN-EC////") for i in range(len(all)): ts = all[i].getData() s = expand_seasonal(ts, tw) writedss(outfile, all[i].getPathname().toString(), s)
def prep_dicu(infile,outfile,tw): from vdss import opendss,writedss,findpath if (not infile): raise TypeError("infile was None") if (not outfile): raise TypeError("outfile was None") if (not infile.endswith("dss") and outfile.endswith("dss")): raise "infile and outfile arguments must be a dss file" g=opendss(infile) all=findpath(g,"///DRAIN-EC////") for i in range(len(all)): ts=all[i].getData() s=expand_seasonal(ts,tw) writedss(outfile,all[i].getPathname().toString(),s)
def dccOp(infile, outfile, inpath, outpath, allThirty=1, value=1.0, tw="01OCT1974 0000 - 01OCT1991 0000"): """ Converts Delta Cross Channel gate operation from a CALSIM file containing fraction of days open Args: infile CALSIM dss file specifying # days operating outfile output dss file readable by DSM2 inpath input path, e.g. /CALSIM/DXC/GATE-DAYS-OPEN//1MON// outpath output path, e.g. /CALSIM/DXC/GATE//IR-YEAR/fpart/ value time series value when gate is opened (must be 1.0 or 2.0), where 1.0 is used for gate ops and 2.0 is number gates operating. tw time window of output allThirty true if CALSIM input is hardwired to thirty day months """ from vutils import timewindow from vdss import opendss, findpath, writedss from vista.time import TimeWindow from vista.set import DataReference import types g = opendss(infile) if not (type(outfile) == types.StringType): raise TypeError("Argument outfile should be name of a dss file") if not isinstance(tw, TimeWindow): tw = timewindow(tw) if not (value == 1.0 or value == 2.0): raise "Output time series 'on' value should be 1.0 (gate op) or 2.0 (gates operating)" x = findpath(g, inpath)[0] dxcref = DataReference.create(findpath(g, inpath)[0], tw) dxc = dxcref.getData() if not dxc: raise "Cross channel data not found" dxcITS = daysPerMonthToITS(dxc, value, allThirty) writedss(outfile, outpath, dxcITS) return dxcITS
def dss_retrieve_ts(file, path, *arg): f = opendss(file) g = findpath(f, path) if g == None or len(g) != 1: raise ValueError("Path %s in file s% does not exist or is not unique" % (path, file)) if len(arg) > 1: raise ValueError("usage: file, dss_path, time window") elif len(arg) == 1: twind = timewindow(arg[0]) return DataReference.create(g[0], twind).getData() else: return g[0].getData()
def calaveras(): calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw = prepro_window() cal_path = calsim_path("C508") cal_ret_path = calsim_path("R514") cal_ref = findpath(f, cal_path) if not cal_ref: raise "Calaveras path %s not found" % cal_path cal_ret_ref = findpath(f, cal_ret_path) if not cal_ret_ref: raise "Calaveras return flow path %s not found" % cal_ret_path cal = DataReference.create(cal_ref[0], tw).getData() cal_ret = DataReference.create(cal_ret_ref[0], tw).getData() mf = calsim_study_fpart(modify=1) cal_in_path = calsim_path("C508_R514", mf) cal_in = cal + cal_ret writedss(outfile, cal_in_path, cal_in) return
def copy_stage(): """ Unsmoothed transfer from DICU file to model input file. """ sourcefile = getAttr("STAGE_SOURCE_FILE") f = opendss(sourcefile) outfile = getAttr("STAGEFILE") stageversion = getAttr("STAGE_VERSION") dsspath = "/FILL\+CHAN/RSAC054/STAGE//15MIN/%s/" % stageversion if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw = prepro_window() ref = findpath(f, dsspath) if len(ref) != 1: raise "Stage path not found or not unique. Found refs: %s" % ref ref = DataReference.create(ref[0], tw) data = ref.getData() writedss(outfile, ref.getPathname().toString(), data)
def copy_stage(): """ Unsmoothed transfer from DICU file to model input file. """ sourcefile=getAttr("STAGE_SOURCE_FILE") f=opendss(sourcefile) outfile=getAttr("STAGEFILE") stageversion=getAttr("STAGE_VERSION") dsspath="/FILL\+CHAN/RSAC054/STAGE//15MIN/%s/" % stageversion if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" tw=prepro_window() ref = findpath(f,dsspath) if len(ref) != 1: raise "Stage path not found or not unique. Found refs: %s" % ref ref=DataReference.create(ref[0],tw) data=ref.getData() writedss(outfile,ref.getPathname().toString(), data)
def smooth_flow(nodes_to_smooth): """ A slightly smoothed version of monthly flows to avoid sharp transitions between months. Uses a tension spline. """ calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" fpart_mod = calsim_study_fpart(modify=1) tw = prepro_window() for calsimname in nodes_to_smooth: # Extend the list as needed, but please keep in mind the # limitations of the conservative spline, at least at present. # Mainly, input flows should be substantially greater than # zero at all times (yolo would be inappropriate, for instance) dsspath = calsim_path(calsimname) paths = findpath(f, dsspath) if not paths or len(paths) > 1: print "File: %s" % calsimfile raise "Path %s not found or not unique" % dsspath ref = DataReference.create(paths[0], tw) monthly = ref.getData() if monthly: if len(monthly) < 4: raise "Length of monthly data too short for smoothing. Wrong time window?" try: daily = conserve.conserveSpline(monthly, "1DAY") except: print "Failure to smooth path: %s over time window: %s" % ( paths[0], tw) raise daily.getAttributes().setYUnits(Units.CFS) writedss(outfile, "/CALSIM-SMOOTH/"+calsimname+"/FLOW/1DAY//" \ +fpart_mod+"/", daily) else: raise "Failure to find CALSIM input data for: " + calsimname
def smooth_flow(nodes_to_smooth): """ A slightly smoothed version of monthly flows to avoid sharp transitions between months. Uses a tension spline. """ calsimfile=getAttr("CALSIMFILE") f=opendss(calsimfile) # open CALSIM file outfile=getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" fpart_mod=calsim_study_fpart(modify=1) tw=prepro_window() for calsimname in nodes_to_smooth: # Extend the list as needed, but please keep in mind the # limitations of the conservative spline, at least at present. # Mainly, input flows should be substantially greater than # zero at all times (yolo would be inappropriate, for instance) dsspath = calsim_path(calsimname) paths=findpath(f,dsspath) if not paths or len(paths)>1: print "File: %s" % calsimfile raise "Path %s not found or not unique" % dsspath ref=DataReference.create(paths[0],tw) monthly=ref.getData() if monthly: if len(monthly) < 4: raise "Length of monthly data too short for smoothing. Wrong time window?" try: daily=conserve.conserveSpline(monthly,"1DAY") except: print "Failure to smooth path: %s over time window: %s" % (paths[0], tw) raise daily.getAttributes().setYUnits(Units.CFS) writedss(outfile, "/CALSIM-SMOOTH/"+calsimname+"/FLOW/1DAY//" \ +fpart_mod+"/", daily) else: raise "Failure to find CALSIM input data for: " + calsimname
def smooth_flow2(): """ A slightly smoothed version of monthly flows to avoid sharp transitions between months. Uses a tension spline. """ calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" fpart_mod = calsim_study_fpart(modify=1) tw = prepro_window() print "Preparing SAC and SJR Inflows" sjr_path = calsim_path("C639") sjr_ret_path = calsim_path("R644") sjr_ref = findpath(f, sjr_path) if not sjr_ref: raise "San Joaquin path %s not found" % sjr_path sjr_ret_ref = findpath(f, sjr_ret_path) if not sjr_ret_ref: raise "San Joaquin return flow path %s not found" % sjr_ret_path sjr = DataReference.create(sjr_ref[0], tw) #.getData() sjr_ret = DataReference.create(sjr_ret_ref[0], tw) #.getData() sjr_in = sjr + sjr_ret sac_path = calsim_path("C169") frwa_div1_path = calsim_path("D168B") frwa_div2_path = calsim_path("D168C") sac_ref = findpath(f, sac_path) if not sac_ref: raise "Sacramento path %s not found" % sac_path frwa_div1_ref = findpath(f, frwa_div1_path) if not frwa_div1_ref: raise "Freeport Regional Water Authority Diversion path %s not found" % frwa_div1_path frwa_div2_ref = findpath(f, frwa_div2_path) if not frwa_div2_ref: raise "Freeport Regional Water Authority Diversion path %s not found" % frwa_div2_path sac = DataReference.create(sac_ref[0], tw) #.getData() frwa_div1 = DataReference.create(frwa_div1_ref[0], tw) #.getData() frwa_div2 = DataReference.create(frwa_div2_ref[0], tw) #.getData() sac_in = sac + frwa_div1 + frwa_div2 # sjr_sac(sjr_inf,sac_inf) print "smoothing SAC" sac_mon = sac_in.getData() if sac_mon: if len(sac_mon) < 4: raise "Length of monthly data too short for smoothing. Wrong time window?" try: sac_day = conserve.conserveSpline(sac_mon, "1DAY") except: print "Failure to smooth path: %s over time window: %s" % ( "C169_D168B_D168C", tw) raise sac_day.getAttributes().setYUnits(Units.CFS) writedss(outfile, "/CALSIM-SMOOTH/C169_D168B_D168C/FLOW/1DAY//" \ +fpart_mod+"/",sac_day) else: raise "Failure to find monthly data for C169+D168B+D168C" print "smoothing SJR" sjr_mon = sjr_in.getData() if sjr_mon: if len(sjr_mon) < 4: raise "Length of monthly data too short for smoothing. Wrong time window?" try: sjr_day = conserve.conserveSpline(sjr_mon, "1DAY") except: print "Failure to smooth path: %s over time window: %s" % ( "C639_R644", tw) raise sjr_day.getAttributes().setYUnits(Units.CFS) writedss(outfile, "/CALSIM-SMOOTH/C639_R644/FLOW/1DAY//" \ +fpart_mod+"/",sjr_day) else: raise "Failure to find monthly data for C639+R644"
if int(sdate[5:]) < 1974: tw = prepro_window("82yr") else: tw = prepro_window("16yr") tws = str(tw) print "Using time window: %s (dcc processing may exceed your run dates)" % tws dcc.dccOp( getAttr('CALSIMFILE'), # CALSIM DSS file (input for DSM2) getAttr('GATEFILE'), # processed gate DSS file (will be input for DSM2) '/CALSIM/DXC/GATE-DAYS-OPEN//1MON//' + getAttr('CALSIMSTUDY') + '/', # CALSIM DXC pathname '/CALSIM-PROCESSED/DCC/OP//IR-YEAR/' + \ getAttr('CALSIMSTUDY') + '/', # processed cross channel pathname 0, # 0: CALSIM input is hardwired to 30-day months 1, # operate gate between 0 & 1 tws # time window ) print 'Copying gate ops for Clifton Court' path='/PLANNING\+GATE/CHWST000/OP-FROM-NODE//IR-YEAR/%s/' \ % getAttr("CLIFTONCT_GATEOP") f = vdss.opendss(getAttr('CLIFTONCT_GATEFILE')) g = vdss.findpath(f, path) if (not g or len(g) != 1): raise "Path not found or not unique: %s" % (path) ts = DataReference.create(g[0]).getData() vdss.writedss(getAttr('GATEFILE'), path.replace("\\", ""), ts) print "Finished with clifton court transfer" sys.exit(0) #
def planning_ec_mtz(): # MTZ = RSAC054 BC for the qual DEBUG = 0 OUTPUT=config.getAttr('QUALBOUNDARYFILE') calsimfile = config.getAttr('CALSIMFILE') vamp_corrected_dss = config.getAttr('CALSIM_VAMP') CALSIM=opendss(calsimfile) PLANNINGTIDE=opendss(config.getAttr('STAGE_SOURCE_FILE')) STEP=string.lower(config.getAttr('CALSIMSTEP')) SJR_PROCESS=config.getAttr("SJR_PROCESS") outputpath="/FILL+CHAN/RSAC054/EC//15MIN/"+config.getAttr("DSM2MODIFIER")+"/" if not(OUTPUT and os.path.exists(OUTPUT)): raise "Envvar QUALBOUNDARYFILE must exist as destination for EC" startyr=int(config.getAttr('START_DATE')[5:]) endyr=int(config.getAttr('END_DATE')[5:]) if (startyr < 1974 and endyr > 1991): # blocks= [ "01NOV1921 0000 - 01OCT1940 0000", blocks= [ "01FEB1921 0000 - 01OCT1940 0000", "01OCT1940 0000 - 01OCT1960 0000", "01OCT1960 0000 - 01OCT1974 0000", "01OCT1974 0000 - 01OCT1991 0000", "01OCT1991 0000 - 01OCT2003 0000" ] else: blocks = [ "01OCT1974 0000 - 01OCT1991 0000" ] # for memory reasons (year 2001). g0=5000. # initial value of g (antecedent outflow) for the beginning # of the first year. This is pretty arbitrary and makes little difference if DEBUG: g0_no_vamp = 5000. for twstr in blocks: TWIND=timewindow(twstr) # Actual period to be estimated print "Calculating boundary salinity for the period "+TWIND.toString() TWINDBUF=grow_window(TWIND,"1MON","1MON") # Conservative buffered period for retrieval # so that after prelimiary operations (e.g. time average) # time series will still span at least TWIND fpart=calsim_study_fpart(modify=0) ndo=DataReference.create(findpath(CALSIM,"/CALSIM/NDO/FLOW-NDO//"+STEP+"/" +fpart+"/")[0],TWIND).getData() ndo15=conserve.conserveSpline(ndo,"15MIN") ndo15_no_vamp = 0 if DEBUG: ndo15_no_vamp = ndo15 # removed since currently there is no difference between vamp and monthly average. # calc vamp caused ndo change # if (SJR_PROCESS.upper()=="SINGLE_STEP") or (SJR_PROCESS.upper()=="MULTI_STEP"): # fpart_modified=calsim_study_fpart(modify=1) # delta_ndo = vamp_ndo.calc_vamp_delta_ndo(calsimfile,vamp_corrected_dss,fpart,fpart_modified,SJR_PROCESS) # ndo15 = ndo15 + interpolate(delta_ndo, "15MIN") astro_stage_version = config.getAttr("ASTRO_STAGE_VERSION") mtzastro=DataReference.create(findpath(PLANNINGTIDE,"/FILL\+CHAN/RSAC054/STAGE//15MIN/"+astro_stage_version + "/")[0],TWINDBUF).getData() astrorms=godin((mtzastro*mtzastro)**0.5) # RMS energy of tide (used to predict filling and draining) dastrorms=( (astrorms-(astrorms>>1))*96. ).createSlice(TWIND) fifteenflo2=ndo15 - 40000*(dastrorms) # call to ec estimator. all parameters are included. g0 is an [mtzecest, g1]=ec_boundary.ECEst(mtzastro,fifteenflo2,beta=600,npow1=0.75,npow2=1,g0=g0,zrms=astrorms) if DEBUG: fifteenflo2_no_vamp = ndo15_no_vamp - 40000*(dastrorms) [mtzecest_no_vamp, g1_no_vamp]=ec_boundary.ECEst(mtzastro,fifteenflo2_no_vamp,beta=600,npow1=0.75,npow2=1,g0=g0_no_vamp,zrms=astrorms) g0_no_vamp = g1_no_vamp writedss("out_ec_check","/CALC/ndo_no_vamp/ndo////", ndo15_no_vamp) writedss("out_ec_check","/CALC/ndo_with_vamp/ndo////", ndo15) writedss("out_ec_check","/CALC/ndo_no_vamp/ec////", mtzecest_no_vamp) writedss("out_ec_check","/CALC/ndo_with_vamp/ec////", mtzecest) writedss(OUTPUT,outputpath,mtzecest) g0=g1 return 0
def planning_ec_mtz(): # MTZ = RSAC054 BC for the qual DEBUG = 0 OUTPUT=config.getAttr('QUALBOUNDARYFILE') calsimfile = config.getAttr('CALSIMFILE') vamp_corrected_dss = config.getAttr('CALSIM_VAMP') CALSIM=opendss(calsimfile) PLANNINGTIDE=opendss(config.getAttr('STAGE_SOURCE_FILE')) STEP=string.lower(config.getAttr('CALSIMSTEP')) SJR_PROCESS=config.getAttr("SJR_PROCESS") outputpath="/FILL+CHAN/RSAC054/EC//15MIN/"+config.getAttr("DSM2MODIFIER")+"/" if not(OUTPUT and os.path.exists(OUTPUT)): raise "Envvar QUALBOUNDARYFILE must exist as destination for EC" startyr=int(config.getAttr('START_DATE')[5:]) endyr=int(config.getAttr('END_DATE')[5:]) if (startyr < 1974 and endyr > 1991): blocks= [ "01NOV1921 0000 - 01OCT1940 0000", "01OCT1940 0000 - 01OCT1960 0000", "01OCT1960 0000 - 01OCT1974 0000", "01OCT1974 0000 - 01OCT1991 0000", "01OCT1991 0000 - 01OCT2003 0000" ] else: blocks = [ "01OCT1974 0000 - 01OCT1991 0000" ] # for memory reasons (year 2001). g0=5000. # initial value of g (antecedent outflow) for the beginning # of the first year. This is pretty arbitrary and makes little difference if DEBUG: g0_no_vamp = 5000. for twstr in blocks: TWIND=timewindow(twstr) # Actual period to be estimated print "Calculating boundary salinity for the period "+TWIND.toString() TWINDBUF=grow_window(TWIND,"1MON","1MON") # Conservative buffered period for retrieval # so that after prelimiary operations (e.g. time average) # time series will still span at least TWIND fpart=calsim_study_fpart(modify=0) ndo=DataReference.create(findpath(CALSIM,"/CALSIM/NDO/FLOW-NDO//"+STEP+"/" +fpart+"/")[0],TWIND).getData() ndo15=conserve.conserveSpline(ndo,"15MIN") ndo15_no_vamp = 0 if DEBUG: ndo15_no_vamp = ndo15 # calc vamp caused ndo change if (SJR_PROCESS.upper()=="SINGLE_STEP") or (SJR_PROCESS.upper()=="MULTI_STEP"): fpart_modified=calsim_study_fpart(modify=1) delta_ndo = vamp_ndo.calc_vamp_delta_ndo(calsimfile,vamp_corrected_dss,fpart,fpart_modified,SJR_PROCESS) ndo15 = ndo15 + interpolate(delta_ndo, "15MIN") astro_stage_version = config.getAttr("ASTRO_STAGE_VERSION") mtzastro=DataReference.create(findpath(PLANNINGTIDE,"/FILL\+CHAN/RSAC054/STAGE//15MIN/"+astro_stage_version + "/")[0],TWINDBUF).getData() astrorms=godin((mtzastro*mtzastro)**0.5) # RMS energy of tide (used to predict filling and draining) dastrorms=( (astrorms-(astrorms>>1))*96. ).createSlice(TWIND) fifteenflo2=ndo15 - 40000*(dastrorms) # call to ec estimator. all parameters are included. g0 is an [mtzecest, g1]=ec_boundary.ECEst(mtzastro,fifteenflo2,beta=600,npow1=0.75,npow2=1,g0=g0,zrms=astrorms) if DEBUG: fifteenflo2_no_vamp = ndo15_no_vamp - 40000*(dastrorms) [mtzecest_no_vamp, g1_no_vamp]=ec_boundary.ECEst(mtzastro,fifteenflo2_no_vamp,beta=600,npow1=0.75,npow2=1,g0=g0_no_vamp,zrms=astrorms) g0_no_vamp = g1_no_vamp writedss("out_ec_check","/CALC/ndo_no_vamp/ndo////", ndo15_no_vamp) writedss("out_ec_check","/CALC/ndo_with_vamp/ndo////", ndo15) writedss("out_ec_check","/CALC/ndo_no_vamp/ec////", mtzecest_no_vamp) writedss("out_ec_check","/CALC/ndo_with_vamp/ec////", mtzecest) writedss(OUTPUT,outputpath,mtzecest) g0=g1 return 0
else: tw = prepro_window("16yr") tws = str(tw) print "Using time window: %s (dcc processing may exceed your run dates)" % tws dcc.dccOp( getAttr('CALSIMFILE'), # CALSIM DSS file (input for DSM2) getAttr('GATEFILE'), # processed gate DSS file (will be input for DSM2) '/CALSIM/DXC/GATE-DAYS-OPEN//1MON//' + getAttr('CALSIMSTUDY') + '/', # CALSIM DXC pathname '/CALSIM-PROCESSED/DCC/OP//IR-YEAR/' + \ getAttr('CALSIMSTUDY') + '/', # processed cross channel pathname 0, # 0: CALSIM input is hardwired to 30-day months 1, # operate gate between 0 & 1 tws # time window ) print 'Copying gate ops for Clifton Court' path='/PLANNING\+GATE/CHWST000/OP-FROM-NODE//IR-YEAR/%s/' \ % getAttr("CLIFTONCT_GATEOP") f=vdss.opendss(getAttr('CLIFTONCT_GATEFILE')) g=vdss.findpath(f,path) if ( not g or len(g) != 1): raise "Path not found or not unique: %s" % (path) ts=DataReference.create(g[0]).getData() vdss.writedss(getAttr('GATEFILE'),path.replace("\\",""),ts) print "Finished with clifton court transfer" sys.exit(0) #
def smooth_flow2(): """ A slightly smoothed version of monthly flows to avoid sharp transitions between months. Uses a tension spline. """ calsimfile = getAttr("CALSIMFILE") f = opendss(calsimfile) # open CALSIM file outfile = getAttr("BOUNDARYFILE") if not outfile or outfile == "": raise "Config variable BOUNDARYFILE not set and needed for prepro output" fpart_mod = calsim_study_fpart(modify=1) tw = prepro_window() print "Preparing SAC and SJR Inflows" sjr_path = calsim_path("C639") sjr_ret_path = calsim_path("R644") sjr_ref = findpath(f, sjr_path) if not sjr_ref: raise "San Joaquin path %s not found" % sjr_path sjr_ret_ref = findpath(f, sjr_ret_path) if not sjr_ret_ref: raise "San Joaquin return flow path %s not found" % sjr_ret_path sjr = DataReference.create(sjr_ref[0], tw) # .getData() sjr_ret = DataReference.create(sjr_ret_ref[0], tw) # .getData() sjr_in = sjr + sjr_ret sac_path = calsim_path("C169") frwa_div1_path = calsim_path("D168B") frwa_div2_path = calsim_path("D168C") sac_ref = findpath(f, sac_path) if not sac_ref: raise "Sacramento path %s not found" % sac_path frwa_div1_ref = findpath(f, frwa_div1_path) if not frwa_div1_ref: raise "Freeport Regional Water Authority Diversion path %s not found" % frwa_div1_path frwa_div2_ref = findpath(f, frwa_div2_path) if not frwa_div2_ref: raise "Freeport Regional Water Authority Diversion path %s not found" % frwa_div2_path sac = DataReference.create(sac_ref[0], tw) # .getData() frwa_div1 = DataReference.create(frwa_div1_ref[0], tw) # .getData() frwa_div2 = DataReference.create(frwa_div2_ref[0], tw) # .getData() sac_in = sac + frwa_div1 + frwa_div2 # sjr_sac(sjr_inf,sac_inf) print "smoothing SAC" sac_mon = sac_in.getData() if sac_mon: if len(sac_mon) < 4: raise "Length of monthly data too short for smoothing. Wrong time window?" try: sac_day = conserve.conserveSpline(sac_mon, "1DAY") except: print "Failure to smooth path: %s over time window: %s" % ("C169_D168B_D168C", tw) raise sac_day.getAttributes().setYUnits(Units.CFS) writedss(outfile, "/CALSIM-SMOOTH/C169_D168B_D168C/FLOW/1DAY//" + fpart_mod + "/", sac_day) else: raise "Failure to find monthly data for C169+D168B+D168C" print "smoothing SJR" sjr_mon = sjr_in.getData() if sjr_mon: if len(sjr_mon) < 4: raise "Length of monthly data too short for smoothing. Wrong time window?" try: sjr_day = conserve.conserveSpline(sjr_mon, "1DAY") except: print "Failure to smooth path: %s over time window: %s" % ("C639_R644", tw) raise sjr_day.getAttributes().setYUnits(Units.CFS) writedss(outfile, "/CALSIM-SMOOTH/C639_R644/FLOW/1DAY//" + fpart_mod + "/", sjr_day) else: raise "Failure to find monthly data for C639+R644"
def planning_ec_mtz(): # MTZ = RSAC054 BC for the qual DEBUG = 0 OUTPUT = config.getAttr('QUALBOUNDARYFILE') calsimfile = config.getAttr('CALSIMFILE') CALSIM = opendss(calsimfile) PLANNINGTIDE = opendss(config.getAttr('STAGE_SOURCE_FILE')) outputpath = "/FILL+CHAN/RSAC054/EC//15MIN/" + config.getAttr( "DSM2MODIFIER") + "/" if not (OUTPUT and os.path.exists(OUTPUT)): raise "Envvar QUALBOUNDARYFILE must exist as destination for EC" startyr = int(config.getAttr('START_DATE')[5:]) endyr = int(config.getAttr('END_DATE')[5:]) if (startyr < 1974 and endyr > 1991): blocks = [ "01NOV1921 0000 - 01OCT1940 0000", "01OCT1940 0000 - 01OCT1960 0000", "01OCT1960 0000 - 01OCT1974 0000", "01OCT1974 0000 - 01OCT1991 0000", "01OCT1991 0000 - 01OCT2003 0000" ] # for memory reasons (year 2001). else: blocks = ["01OCT1974 0000 - 01OCT1991 0000"] g0 = 5000. # initial value of g (antecedent outflow) for the beginning # of the first year. This is pretty arbitrary and makes little difference for twstr in blocks: TWIND = timewindow(twstr) # Actual period to be estimated print "Calculating boundary salinity for the period " + TWIND.toString( ) TWINDBUF = grow_window( TWIND, "1MON", "1MON") # Conservative buffered period for retrieval # so that after prelimiary operations (e.g. time average) # time series will still span at least TWIND fpart = calsim_study_fpart(modify=0) ndo15 = DataReference.create( findpath(CALSIM, "/CALSIM/NDO/FLOW-NDO//15MIN/" + fpart + "/")[0], TWIND).getData() astro_stage_version = config.getAttr("ASTRO_STAGE_VERSION") mtzastro = DataReference.create( findpath( PLANNINGTIDE, "/FILL\+CHAN/RSAC054/STAGE//15MIN/" + astro_stage_version + "/")[0], TWINDBUF).getData() if 'NAVD' in astro_stage_version: mtzastro = mtzastro - 2.68 writedss( CALSIM, "/FILL\+CHAN/RSAC054/STAGE//15MIN/" + astro_stage_version.replace('NAVD', 'NGVD') + "/", mtzastro) astrorms = godin( (mtzastro * mtzastro)** 0.5) # RMS energy of tide (used to predict filling and draining) dastrorms = ((astrorms - (astrorms >> 1)) * 96.).createSlice(TWIND) fifteenflo2 = ndo15 - 53411.1 * (dastrorms) # call to ec estimator. all parameters are included. so, sb = 37196, 2328.1 c = [ -6.00E-05, 7.30E-05, -1.00E-05, -3.00E-05, 1.70E-06, -1.00E-04, 4.50E-05, -1.00E-04 ] [mtzecest, g1] = ec_boundary.ECEst(mtzastro, fifteenflo2, so, sb, beta=420.5205, npow1=0.7750588, npow2=1, g0=g0, zrms=astrorms, c=c) writedss(OUTPUT, outputpath, mtzecest) g0 = g1 return 0
from vtimeseries import time NaN=float('nan') def export_csv(ref,file): d = ref.data f=open(file,'w') for e in d: f.write("%s,%s\n"%(e.x, "" if e.y == -901.0 or e.y == -902.0 else e.y)) f.close() if __name__=='__main__': file='Z:/DSM2_v81_Beta_Release/studies/historical_qual_ec_v81/output/historical_v81.dss' from vutils import opendss import vdss ref = vdss.findpath(opendss(file),'//sltrm004/flow')[0] print 'Exporting ref: %s'%ref export_csv(ref,'Z:/temp/sltrm004_flow.csv')
import sys
def dss_retrieve_ts(file, path): f=opendss(file) g=findpath(f,path) if g==None or len(g) != 1: raise ValueError("Path %s in file s% does not exist or is not unique" % (path,file)) return g[0].getData()