Test hydrocron Release 1.9.0 in UAT

[jamesfwood]

@davidcolemanjpl can you please test hydrocron release 1.9.0 in UAT?

Test:

• Service in general -- make sure everything works as expected and nothing broke during this release
• After ingest, it should fix the sword_version and collection_version. Maybe work with Simon to see he can ingest in UAT. I'm not sure if this is possible yet.
• Test the new 8 sos fields: sos_consensus_q, sos_hivdi_q, sos_metroman_q, sos_momma_q, sos_sad_q, sos_sic4dvar_q, sos_lakeflow_q, swot_discharge_reanalysis

So far I only ingested 19 reaches with sos data in UAT.

Example request:
https://soto.podaac.uat.earthdatacloud.nasa.gov/hydrocron/v1/timeseries?collection_name=SWOT_L2_HR_RiverSP_2.0&feature=Reach&feature_id=18180900091&start_time=2020-01-01T00:00:00%2b00:00&end_time=2025-10-30T00:00:00%2b00:00&output=csv&fields=reach_id,time_str,wse,sos_consensus_q,sos_hivdi_q,sos_metroman_q,sos_momma_q,sos_sad_q,sos_sic4dvar_q,sos_lakeflow_q,swot_discharge_reanalysis

You can use these reaches for testing:
18180900091
11410000021
11410000031
11430000041
11441100011
11441100021
11441100031
11441100051
11441100061
11441100071
11441100081
11441100091
11441100101
11441100111
11441100121
11441100131
11441100141
11441100151
11441100161

[jamesfwood]

Here is the data that SHOULD be loaded. And if it's not listed here then it should return the fill value

reach_id,range_start_time,columns
11410000021,2024-01-28T21:16:42Z,sos_consensus_q=635.8022502771125; sos_metroman_q=450.1986259893944; sos_momma_q=821.4058745648307; sos_sic4dvar_q=939.8137023402131
11410000021,2024-02-13T06:50:48Z,sos_consensus_q=1555.4904714534507; sos_momma_q=1555.4904714534507; sos_sic4dvar_q=1040.038010955885
11410000021,2024-02-18T18:01:47Z,sos_consensus_q=357.13040943655756; sos_metroman_q=309.5356602895065; sos_momma_q=404.7251585836086; sos_sic4dvar_q=995.3957636850599
11410000031,2024-01-28T21:16:42Z,sos_consensus_q=673.71719454168; sos_metroman_q=655.54299219831; sos_momma_q=691.89139688505; sos_sic4dvar_q=903.0305337782182
11410000031,2024-02-13T06:50:48Z,sos_consensus_q=2253.5843287888133; sos_momma_q=2253.5843287888133; sos_sic4dvar_q=952.7511441288185
11410000031,2024-02-18T18:01:47Z,sos_consensus_q=663.0531445231386; sos_metroman_q=363.109783672818; sos_momma_q=962.9965053734591; sos_sic4dvar_q=867.4388573601108
11430000041,2024-01-28T21:16:42Z,sos_consensus_q=667.0975318968137; sos_metroman_q=1009.2896863152693; sos_momma_q=324.9053774783583; sos_sic4dvar_q=761.4331292373811; sos_sad_q=1640.9191297674954
11430000041,2024-02-13T06:50:48Z,sos_sic4dvar_q=776.5870551655202; sos_sad_q=2571.8379478118354
11430000041,2024-02-18T18:01:47Z,sos_consensus_q=612.7039358075441; sos_metroman_q=839.6886052940005; sos_momma_q=385.71926632108773; sos_sic4dvar_q=714.1050792526291; sos_sad_q=2031.5791759583194
11441100011,2024-02-13T06:50:48Z,sos_sic4dvar_q=276.83248669276276
11441100021,2024-02-13T06:50:48Z,sos_sic4dvar_q=274.816538575724
11441100031,2024-02-13T06:50:48Z,sos_sic4dvar_q=382.04996943471576
11441100051,2024-02-13T06:50:48Z,sos_consensus_q=308.74907161284625; sos_sic4dvar_q=314.0909685636284; sos_sad_q=308.74907161284625
11441100061,2024-02-13T06:50:48Z,sos_consensus_q=709.9411359969312; sos_momma_q=709.9411359969312; sos_sic4dvar_q=307.46563233920153
11441100071,2024-02-13T06:50:48Z,sos_momma_q=572.7987390406369; sos_sic4dvar_q=325.1972678113027
11441100081,2024-02-13T06:50:48Z,sos_sic4dvar_q=302.5118843798105
11441100081,2024-02-18T18:01:47Z,sos_consensus_q=50.96550418374948; sos_momma_q=50.96550418374948; sos_sic4dvar_q=317.70671553190226
11441100091,2024-01-28T21:16:42Z,sos_sic4dvar_q=368.1191938609253
11441100091,2024-02-13T06:50:48Z,sos_sic4dvar_q=386.34485731468
11441100091,2024-02-18T18:01:47Z,sos_sic4dvar_q=370.9881699624274
11441100101,2024-01-28T21:16:42Z,sos_consensus_q=907.7596584088614; sos_metroman_q=907.7596584088614; sos_sic4dvar_q=342.5400713724762; sos_sad_q=180.80877038616526
11441100101,2024-02-18T18:01:47Z,sos_consensus_q=275.0973743773974; sos_metroman_q=275.0973743773974; sos_sic4dvar_q=344.76686256300917; sos_sad_q=177.61168619268415
11441100111,2024-01-28T21:16:42Z,sos_consensus_q=927.0161363020316; sos_metroman_q=927.0161363020316; sos_sic4dvar_q=380.20071442342606; sos_sad_q=1283.6555340801785
11441100111,2024-02-18T18:01:47Z,sos_consensus_q=222.24870876191162; sos_metroman_q=222.24870876191162; sos_sic4dvar_q=365.0298011265858; sos_sad_q=1293.190081383254
11441100121,2024-01-28T21:16:42Z,sos_consensus_q=315.4147804100312; sos_metroman_q=519.5720888833806; sos_sic4dvar_q=346.80407503445167; sos_sad_q=111.2574719366818
11441100121,2024-02-18T18:01:47Z,sos_consensus_q=143.16942475808239; sos_metroman_q=209.6114477827664; sos_sic4dvar_q=327.89373599258477; sos_sad_q=76.7274017333984
11441100131,2024-01-28T21:16:42Z,sos_consensus_q=482.8023911550413; sos_metroman_q=482.8023911550413; sos_sic4dvar_q=426.7865771226498
11441100131,2024-02-18T18:01:47Z,sos_consensus_q=207.13056374052388; sos_metroman_q=207.13056374052388; sos_sic4dvar_q=405.03149419618023
11441100141,2024-01-28T21:16:42Z,sos_consensus_q=432.5264214441694; sos_metroman_q=432.5264214441694; sos_sic4dvar_q=392.5322362395652
11441100141,2024-02-18T18:01:47Z,sos_consensus_q=224.22906336156646; sos_metroman_q=224.22906336156646; sos_sic4dvar_q=376.85719250064074
11441100151,2024-01-28T21:16:42Z,sos_metroman_q=402.2735963206507; sos_momma_q=422.350267447667; sos_sic4dvar_q=414.6450725191533
11441100151,2024-02-18T18:01:47Z,sos_metroman_q=229.36837373705106; sos_momma_q=693.4231984246445; sos_sic4dvar_q=397.3216985410891
11441100161,2024-01-28T21:16:42Z,sos_sic4dvar_q=414.8300073651532
11441100161,2024-02-18T18:01:47Z,sos_consensus_q=397.5263130646929; sos_metroman_q=297.9702238886341; sos_momma_q=497.0824022407517; sos_sic4dvar_q=396.5510983839021

[jamesfwood]

Also, swot_discharge_reanalysis is an alias for sos_consensus_q so those two should return the same value.

This release should fulfill this issue

[jamesfwood]

Here is the PR too

[davidcolemanjpl]

Per Dev, regarding Hydrocron validation, "...this is a ingestion test to make sure data populated right"

NOTE:
Our Legacy Cumulus UAT and SWOT UAT databases are currently "read-only" and frozen. 
Thus, we'll have to wait until we can test this during Consolidated-Cumulus UAT1 regression test for SWOT collections