StateDMI / Command / SetIrrigationPracticeTSFromList
Overview
The SetIrrigationPracticeTSFromList
command (for StateCU)
sets irrigation practice data for existing CU Locations by reading information from a delimited file.
New locations are not added. The command can be used to set values over a period of 1+ years as follows:
- If the
SetStart
andSetEnd
parameters are specified and the year column is not specified, then repeat the values from the file for each year in the set period. For example, this can be used to repeat efficiency values through the period. Or, it can be used to provide acreage data not in HydroBase, for a specific year (setSetStart
andSetEnd
to the same value). - If the year column is provided, use the year in the file to specify the year for the set.
In this case,
SetStart
andSetEnd
control the period of data that will be processed from the file.
HydroBase may not contain all irrigated lands data. For example, additional lands may have been identified after HydroBase was populated or acreage must be set for a model identifier that is not a structure WDID in HydroBase (e.g., out of state lands). In this case, the command can be used to provide additional data to supplement HydroBase.
It is typical that separate SetIrrigationPracticeTSFromList
commands are
used for different columns of data in the irrigation practice file.
For example, efficiencies may be set with one command and acreage with another command.
The information-only surface water total and groundwater total values will be updated to agree with the acreage parts.
However, no cascading adjustments will occur (as performed by
FillIrrigationPracticeTSInterpolate
and other commands).
Command Editor
The following dialog is used to edit the command and illustrates the syntax of the command for repeating values over the specified period, with the values being set as the command is processed (omitting the year would repeat the values in all years):
SetIrrigationPracticeTSFromList
Command Editor - Repeat Values (see also the full-size image)
Command Syntax
The command syntax is as follows:
SetIrrigationPracticeTSFromList(Parameter="Value",...)
Command Parameters
Parameter | Description | Default |
---|---|---|
ListFile required |
Path to the delimited list file to read. | None – must be specified. |
ID required |
A single CU location identifier to match or a pattern using wildcards (e.g., 20* ). |
None – must be specified. |
SetStart |
The first year to set data values. | If not specified, data are set for the full output period. |
SetEnd |
The last year to set data values. | If not specified, data are set for the full output period. |
YearCol |
The column number (1+) containing the year for data. | The file values are applied to each year in the data set. |
IDCol |
The column number (1+) containing the CU Location identifiers. These values are matched against CU Location identifiers in the existing irrigation practice data. | None – must be specified. |
SurfaceDelEffMaxCol |
The column number (1+) containing the surface water delivery efficiency maximum. | If not specified, the previous data values will remain. |
FloodAppEffMaxCol |
The column number (1+) containing the flood application efficiency maximum. | If not specified, the previous data values will remain. |
SprinklerAppEffMaxCol |
The column number (1+) containing the sprinkler application efficiency maximum. | If not specified, the previous data values will remain. |
AcresSWFloodCol |
The column number (1+) containing the surface water flood acres. | If not specified, the previous data values will remain. |
AcresSWSprinklerCol |
The column number (1+) containing the surface water sprinkler acres. | If not specified, the previous data values will remain. |
AcresGWFloodCol |
The column number (1+) containing the groundwater flood acres. | If not specified, the previous data values will remain. |
AcresGWSprinklerCol |
The column number (1+) containing the groundwater sprinkler acres. | If not specified, the previous data values will remain. |
AcresTotalCol |
The column number (1+) containing the total acres. | If not specified, the previous data values will remain. |
RecalculateTotal |
Indicate whether the total area values should be recalculated from the parts (False or True ). This can be used if area parts are set but total is not set. |
False |
PumpingMaxCol |
The column number (1+) containing the monthly maximum pumping rate. | If not specified, the previous data values will remain. |
GWModeCol |
The column number (1+) containing the groundwater mode value. | If not specified, the previous data values will remain. |
Examples
See the automated tests.
Data file lines starting with the #
character are treated as comments.
If the first line’s values are surrounded by double quotes, the line is assumed to indicate column headings.
An example list file for setting efficiencies is shown below (the year would be provided as a parameter and values would apply to all years):
200505,0.70,0.7,0.8
200511,0.82,0.7,0.8
200512,0.71,0.7,0.8
200513,0.73,0.7,0.8
20MS01,0.80,0.7,0.8
200517,0.71,0.7,0.8
200518,0.88,0.7,0.8
200528,0.71,0.7,0.8
... etc. ...
An example list file for specifying acreage data (not in HydroBase) is shown below (the year column would be specified as a parameter and values would apply to the year in the list file). Currently, supplemental acreage data can have only a single irrigation method and supply type.
# The following data provide acreage for structures that did not have GIS data
# and consequently no data in HydroBase. The data are specific to 1998 and are
# used to set the CDS and IPY acres. The crop is used to provide CDS data. The
# irrigation method and source are used to provide IPY data.
"ID","Crop","Acres","IrrigationMethod","SupplySource"
200500,GRASS_PASTURE,0,Flood,Surface
200506,GRASS_PASTURE,100,Flood,Surface
200507,GRASS_PASTURE,50,Flood,Surface
200508,GRASS_PASTURE,40,Flood,Surface
200522,GRASS_PASTURE,40,Flood,Surface
200523,GRASS_PASTURE,50,Flood,Surface
200526,GRASS_PASTURE,40,Flood,Surface
200529,GRASS_PASTURE,5,Flood,Surface
200530,GRASS_PASTURE,42,Flood,Surface
200532,GRASS_PASTURE,25,Flood,Surface
200533,GRASS_PASTURE,40,Flood,Surface
... etc...
Troubleshooting
See Also
FillIrrigationPracticeTSAcreageUsingWellRights
commandFillIrrigationPracticeTSInterpolate
commandFillIrrigationPracticeTSRepeat
commandSetIrrigationPracticeTS
commandSetIrrigationPracticeTSFromStateCU
commandSetIrrigationPracticeTSPumpingMaxUsingWellRights
commandSetIrrigationPracticeTSSprinklerAcreageFromList
commandSetIrrigationPracticeTSTotalAcreageToCropPatternTSTotalAcreage
command