Distances is a function that that returns the top three weather stations from the list with the appropriate weighting factor.

FilterCCDryLand is a function that returns the dryland values of the coefficient of crops table by giving it a slice of CoeffCrop and a zone and crop.

GetAppEfficiency is a function that returns the application efficiency for use in calculations throughout the app.

GetCellAreas is a function to return the amount of area within each model cell that is covered by parcels of irrigated and dryland.

GetCells is a function to retrieve the model cells from the database and return a struct of ModelCell.

GetCellsIrr gets the cells that have irrigation within them and splits them by parcel.

GetCellsIrrPost97 a Post 97 version of this function that gets the cells that have irrigation within them and splits them by parcel.

GetCoeffCrops is a function that calls the database to get the list of coefficients for each crop and zone in the model and returns a slice of CoeffCrop.

GetDryCells is a function that returns a struct of cells with parcels that are within it including the crops and acres within each cell.

GetExternalWells is a function to query the external pumping from the database and returns a slice of ExtWell as well as includes handling the debug mode.

GetExtRecharge is a function to return a slice of ExtRch filled with the ext_recharge data from the database and used in the model to create the recharge values for the external non-NRD areas.

GetSqlite gets or sets the connection string for the sqlite3 results database.

GetSSAppEfficiency is a function that returns the application efficiency for use in calculations throughout the Steady State portion of the app, it is fixed and doesn't use the database.

GetSSCellAreas1 is a function for the Steady State Run to return the amount of area within each model cell for the first two stress periods.

GetSSCellAreas2 is a function to return the amount of area within each model cell that is covered by parcels of surface water irrigated and dryland parcels.

GetSSCellsIrr is a function to return the irrigated cells for 1953 only where there are surface water parcels.

GetSSWells is a function that gets the data from the postgres DB and returns a slice of SSWell and also includes a call to the SSWell.monthlyVolume() method to set the monthly data from the annual data that is in the database.

GetWeatherStations is a function to return a slice of WeatherStation that includes the weather station text id (code) and the X and Y coordinates of it's location.

GetWellNode is a function that gets the wellid, regno and node number of the well so that we can add a location to the well when it is written out along with the nrd.

GetWellParcels is a function that gets all the well parcel junction table values and creates one struct from them and also includes the year of the join as well as the nrd.

GetWellParcelsPost97 is a function that gets all the well parcel junction table values and creates one struct from them and also includes the year of the join as well as the nrd but replaces any GWO parcels with the 1997 GWO parcels.

InitializeDb creates the database results table if it doesn't exist, so the records of the transaction can be stored properly, also creates file_keys table for result file_type integer and a foreign key restriction to results table.

IrrResultDB is a function that returns the IrrDB struct setup to insert values into the results database for the Irrigated parcel functions.

NewSetup is an initialization function for the Setup struct that sets the initial database connections, logger, and stores the flags for excess flow and debug.

PgConnx is a function that returns the sql connection to the postgres database.

ResultsNoteDB is a function that returns a db struct that includes a sql connection, a insert statement, and buffer to add notes to the output database.

ResultsWelDB is a function that creates the WelDB struct and contains the SQL statement to insert the records, it also accepts a slice of WelResult used for the buffer.

WithSteadyState sets the Steady State Bool to true and also sets the years to SYear to 1893 and EYear to 1952.

go:embed sql/AggResultsNoExclude.sql.

go:embed sql/RchAggResultsNoExclude.sql.

go:embed sql/RchSingleResult.sql.

go:embed sql/WelSingleResult.sql.

DryCell is a struct that holds the data for each cell and the parcel data associated with it including crops and the amount of crop that is included.

IrrCell is a struct to hold the data of each cell and parcel intersect, it includes the cert, crops, and other characteristics important to the calculations.

WelAnnualResult is a struct that is used to construct the well result and includes a 12-month array.

WelDB is a struct for the sql database, statement and buffer that is used to save information in chunks.

WelResult is a struct for the final result to be saved to db that is a value per well, per month.

XyPoints is an interface that uses the GetXY method and is used by the Distances function to enable different structs to be able to input to the Distances function.