Home

300dpi pdf - California Fish Tracking Consortium

Contents

1. Workbook Views J Show Zoom Window Macros F7499 X fe A B c D E F G 1 receiver_code location xistart_date end_date latitude longitude j owner_r jme 2413 VR2 7671 SR_Freeport 2012 07 26 17 54 08 00 00 2012 11 08 20 12 22 00 00 38 45557 121 5022 A Peter Klimley 7103 VR2W 121348 SR_Freeport 2013 07 02 23 35 00 00 0 38 45557 121 5022 A Peter Klimley 7104 VR2W 121348 SR_Freeport 2012 11 13 20 28 50 00 00 2013 03 28 18 46 05 00 00 38 45557 121 50229 A Peter Klimley 7105 VR2W 121348 SR_Freeport 2013 03 28 18 59 18 00 00 2013 07 02 23 23 50 00 00 38 45557 121 50229 A Peter Klimley 7498 UC Davis Biotelemetry Laboratory 24 Hydra Frequently Asked Questions and User Guide Since know that a receiver that owned was included in the uploaded JONHYDRA LOGOUT ABOUT RESEARCHERS MMMA USERGUIDE NEWSREVENTS FU Receiver Deployment file with no end i DataDownloas date want to make sure that this To download previous detections see your Download List detection record of that specific ta z Use the options below to specify the data you wish to download Select as many as are necessary Tag Data does not end up being orphaned V My tags V Tags shared withme V Public tags C Duplicate tags Only detections of these tags A69 1303 52414 2 A DAs Only detections for this study All studies t To check this queried for one specific n nimal Data tag A69 1303 52414 in Hydra and FE 1 1 PET
2. x ll 7 tags dup_tags Read Only Microsoft Excel o Home Insert Page Layout Formulas Data Review View Acrobat A Oo ps y Cut E mo FK ey gt AutoSum Ay oa i l v v av Wrap Text l v 4 emm i F Fa B 3a Copy Calibri 11 A gt g Wrap Te Genera Fa HA E S g a ae a Paste B Z U amp Ar 5 a Merge amp Center 7 9 0 00 Conditional Format Cell Insert Delete Format Sot amp Find amp v J Format Painter ae ay oe FEE ba i ee Formatting as Table Styles gt v lt Clear 7 Filter Select 7 Clipboard Font Alignment Number Styles Cells Editing D21 v fe Oncorhynchus tshawytscha A B c M F G H l K L M 1 tag_code study_name tagging _date species_name animal_weight animal_length_total animal_length_fork depth gender capture_method location owner_name 11 A69 1303 1259 NapaRiverStudy 4 15 2011 Steelhead_Cc 0 06 U Rotary_Screw_Trap Napa_Rive Thomas Keegan 12 A69 1303 1260 NapaRiverStudy 4 15 2011 Steelhead_CC 0 05 15 7 U Rotary_Screw_Trap Napa_Rive Thomas Keegan 13 A69 1303 33782 USACE LFC 04 1 31 2010 Oncorhynchus tshawytscha 0 0678 19 3 U Hatchery SacElkLan A Peter Klimley 14 A69 1303 33791 USACE LFC 04 1 31 2010 Oncorhynchus tshawytscha 0 0919 19 3 U Hatchery SacElkLan A Peter Klimley 15 A69 1303 34008 USACE LFC 04 2 6 2010 Oncorhynchus tshawytscha 0 054 17 U Hatchery SacElkLan A Peter Klimley 16 A69 1303 34008 GS UCD ACE SFBay 2012 4 19 2012 Acipenser medirostris 117 105
3. All species a Minimum length No minimun Maximum length No maximum Micropterus punctulatus Micropterus salmoides A Minimum weight No minimum Maximum weight No minimun Ameiurus catus se Date Data Start date Example 2012 12 01 Enddate Example 2012 12 31 Download Type E Tags amp Tagging AF Receiver Deployments ri Tag Detections Download Note that in the example shown below the location name is SR_Freeport and that the latitude and longitudes are the same as previous records that are in Hydra Ensuring that your current latitudes longitudes and metadata match historical records will make querying data much easier in the future Uploading a complete Receiver Deployment time period including a Start_Date and End_Date makes it easier to facilitate Receiver Deployment edits in the future and gives a better record of when receivers were in and out of the water x Ei 7 deployments 1 Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat ry JED PE FD 5 Qs Connections 4 BA Ny WK Clear gt 5 ere hE a T i 2 7 rtie 2 Z A EEE a o EP TE AE amp Reapply From From From From Other Existing Refresh z Sort Y Textto Remove Data Consolidate What If Group Ungroup Subtotal Access Web Text Sources Connections Ally cat Lint Advanced Columns Duplicates Validation Analysis 7 Z X Get External Data Connections Sort amp Filter Data Tools Outline C7511 v fe
4. UC Davis Biotelemetry Laboratory Hydra Frequently Asked Questions and User Guide A guide to preparing your acoustic tags receiver deployments and detection data Prepared by Ryan Battleson UC Davis Biotelemetry Laboratory University of California Davis UC DAVIS One Shields Avenue 1332 Academic Surge UNIVERSITY OF CALIFORNIA Davis CA 95618 530 752 1156 rbattleson ucdavis edu UC Davis Biotelemetry Laboratory 1 Hydra Frequently Asked Questions and User Guide What s this Hydra and acoustic telemetry thing all about Many researchers along the Pacific Coast use Vemco LLC brand acoustic tags and acoustic receivers and hydrophones to track the movements of aquatic organisms Part of using this technology is learning how to properly manage the acoustic detections of tagged organisms which are collected by using automated acoustic receivers and hydrophones This user guide walks the reader through how to set up field protocols and create data directories for their data storage that may be helpful when it comes time to upload those data to a database In the examples show in the following pages refer to getting your data into Hydra Hydra is a community of researchers that use an open source database to manage automated acoustic receiver deployments detections of acoustic tags and tagging metadata This user guide is an attempt to help standardize the data that is put into hydra This effort is designed to ensure that what i
5. VR2W 109540 2013 04 25 19 22 07 A69 1303 56497 A69 1303 56497 VR2W 109542 GG4 n that do not fit the map will be discarded Times pre in e VR2W 109542 2013 04 25 23 01 55 69 1303 56402 A69 1303 56402 VR2W 109542 GG4 VR2W 112534 2013 04 25 23 06 19 A69 1303 56402 A69 1303 56402 VR2W 109542 GG4 MAP 110 69 kHz e VR2W 112537 2013 04 25 23 09 48 69 1303 56402 A69 1303 56402 VR2W 109542 GG4 P saa 2013 04 27 08 35 12 69 1303 34020 A69 1303 34020 VR2W 109542 GG4 aan 8 es aa 56 2013 04 28 10 05 18 A69 1303 34020 A69 1303 34020 VR2W 109542 GG4 Calibrated sensor values b 4 Stations 9 2013 04 28 10 06 41 A69 1303 34020 A69 1303 34020 VR2W 109542 GG4 Raw sensor values b 2 Imported Log Files 9 2013 04 28 10 07 52 A69 1303 34020 A69 1303 34020 VR2W 109542 GG4 Y Detection Filters 0 2013 04 28 10 08 41 A69 1303 34020 A69 1303 34020 VR2W 109542 GG4 2013 04 28 10 09 46 A69 1303 34020 A69 1303 34020 VR2W 109542 GG4 Make sure to change the output file s name and destination directory i F m GoldenGate rray 2013_Tri3_GoldenGate 2013_Tri3_GoldenGateDniftCorrected f Search 2013 Tn3_GoldenGoteDnft Organize _ Open Burn New folder _ a Ji 2012 Tri 3 z Name Date modified Type 2013 Tri 1 E E 2013_0Q3_GoldenGate_Drift wdb 12 5 2013 11 39 AM VDE File iT Th p An Al Tns _GG_DriftCorrected_HydraReady 12 4 2013 10 54 AM Microsoft Excel W Tri p AATE F r me VR2W_106501_201
6. UC Davis Biotelemetry Laboratory 25 Hydra Frequently Asked Questions and User Guide Re uploading an old Receiver Deployment file to include an End_ Date Remember that at some time you need to include an End_ Date which includes time column header for this Receiver Deployment file You can re upload your original Receiver Deployment file but just include the End_ Date column and the record should update properly It is good practice to upload complete Start and End date Receiver Deployment files with their associated Detection Files It may be easy to forget that you need to upload additional data to that record in the future particularly if the Receiver Deployment changes locations Below I ve re uploaded the same Receiver Deployment for SR_Freeport but now included an end date and time Nothing else has changed This would be very useful if you had a large amount of receiver deployments with no End_Date or are concluding a study Just make sure you know what you are uploading and whether or not there are incomplete records 7 FreeportReceiverDeployment Compatibility Mode Microsoft Excel Home Insert Page Layout Formulas Data Review View Acrobat d Cut Calibri 1l1 v iA aw D Wrap Text v re Norma Bad Good a 4a Copy 7 hee ee en mee dae a A E 2 2 e Clipboard Font x Alignment Number Styles Cells G2 v amp X v fe 10 17 2013 11 20 52 PM A B C D E F H 1 Locat
7. 11 21 VR2W_106501_20131121_1 edited vrl z a i 18 12 25 2013 11 21 15 39 59 VR2W_107554 20131121_1 vrl 13 21 09 04 2013 11 21 20 11 21 VR2W_ 107554 20131121_1_edited vr 2013 08 08 21 09 04 2015 11 21 20 1252 VR2W_ 107555 20131121 ivi i 2013 08 08 22 53 15 2013 11 21 19 10 51 nao tare click the Auto Correct button which applies a linear function of When importing a VRL data set that already exists in the database o Says a a a eas clock drift to your existing detection data and transforms them to a O Keep the existing data set do not import VRL Replace the existing data set Replace the existing data set only if the VRL is newer the 2013 Q3 GoldenGate_Drift vdb VUE database new edited version This edited version is what will import to UC Davis Biotelemetry Laboratory 35 Hydra Frequently Asked Questions and User Guide Now all my imported and time drift corrected files in my 2013_Q3_GoldenGate_Drift vdb database 2013 08 Sobel Deft ince e Home Detections Events Z Shared Projects 69kHzArray R VUE_Export csv iP sea G we m Detections Files Filters Stations Transmitters E Al Detections ER a Receivers 9 Date Time CodeSpace ID Transmitter Receiver Station aian ris minh bln eso Tann i bania 2013 04 25 17 32 59 A69 1303 62897 A69 1303 62897 VR2W 109542 GG4 E e VR2W 107555 2013 04 25 17 33 05 A69 1303 62897 A69 1303 62897 VR2W 109542 GG4 EEE E ER
8. 11 21 2013 1 34 PM 12 4 2013 11 01 AM 11 21 2013 7 40 AM 11 21 2013 7 40 AM 11 21 2013 12 13 11 21 2013 12 13 11 21 2013 11 13 11 21 2013 11 13 11 21 2013 10 23 11 21 2013 10 23 11 21 2013 9 56 AM Type File folder VDE File Microsoft Excel W Microsoft Excel C VRL File Microsoft Excel C VRL File Microsoft Excel C VRL File Microsoft Excel C VRL File Microsoft Excel C 4 ul Database Close Database f J f Tools o About VUE Organize New folder A 2012 Tri J 2012 Tri3 J 2013 Tril U 2013 Tri2 J 2013 Tri3 dJi 2013 Tril ACE bridges flats and marinas di GoldenGateArray 2013_Tri3_GoldenGate 2013_Tri3_GoldenGateDriftCorrected Ji Master Array Database dJi Miscellaneous lab recervers di Monitor Data from Gabe up to 2012_Tril Options af Exit VUE Name _ 2013_Q3_GoldenGate_Driftwdb 4 wT Date modified Filename 2013 03 GoldenGate_Drift wdb 12 5 2015 10 56 AM Type VDE File UC Davis Biotelemetry Laboratory 32 Hydra Frequently Asked Questions and User Guide I now have my new VUE database ready to import drift corrected detection files to 218 8 creme O H Home Detections Ewents a A SS ERR A Detections Files Filters Stations Transmitters All Detections 0 detections Receivers 0 gt Transmitt
9. A B P D E F G H 1 receiver code location x Start_date end_date latitude longitude owner_r me 2409 VR2 7671 SR_Freeport 2010 10 26 16 15 10 00 00 2011 07 25 15 50 17 00 00 38 4556 121 5022 A Peter Klimley 2410 VR2 7671 SR_Freeport 2011 07 25 16 04 53 00 00 2012 03 02 11 21 31 00 00 38 4556 121 5022 A Peter Klimley 2411 VR2 7671 SR_Freeport 2012 03 02 23 37 12 00 00 2012 07 26 17 38 22 00 00 38 4556 121 5022 A Peter Klimley 2412 VR2 7671 SR_Freeport 2012 07 26 17 54 08 00 00 2012 11 08 20 12 22 00 00 38 4556 121 5022 A Peter Klimley 2413 VR2 7671 SR_Freeport 2012 11 08 22 21 05 00 00 2012 11 13 20 05 55 00 00 38 4556 121 5022 A Peter Klimley 7112 VR2W 121348 SR_Freeport 2012 11 13 20 28 50 00 00 2013 03 28 18 46 05 00 00 38 4556 121 5022 A Peter Klimley 7113 VR2W 121348 SR_Freeport 2013 03 28 18 59 18 00 00 2013 07 02 23 23 50 00 00 38 4556 121 5022 A Peter Klimley 7114 VR2W 121348 SR_Freeport 2013 07 02 23 35 00 00 00 2013 10 17 23 20 52 00 00 38 4556 121 5022 A Peter Klimley UC Davis Biotelemetry Laboratory 21 Hydra Frequently Asked Questions and User Guide If your upload failed you might get an email like this Your upload at Hydra failed 2012_Tri2_Deployment s UCDavis UTC xls DB inbox x a Fal hydra sound data com Your upload into Hydra of file 2012_Tri2_Deployme Jan 10 4 older messages hydra sound data com Error in processing file 2012 Tn2 Deployments UC Jan 10 hydra sound data co
10. Insert Page Layout Formulas Data Review View Acrobat i CS i E Split QQ View Side by Side m ia Z a V Formula Bar 4 P H ry E rade o Page Page Break Custom Full V Gridlines V Headings Zoom 100 Zoomto New Arrange Freeze Save Switch Macros Layout Preview Views Screen Selection Window All Panes Workspace Windows sd Workbook Views Show Zoom Window Macros F29855 X fe A B c D e F 6G H J K L M N 1 Date and Time UTC Receiver Transmitter Transmitter Name TransmitteSensor Value Sensor Unit Station Name Latitude Longitude 29844 10 17 2013 21 10 VR2W 121A69 1303 62916 Freeport 38 45544 121 5024 29845 10 17 2013 21 24 VR2W 121A69 1303 62901 Freeport 38 45544 121 5024 29846 10 17 2013 21 39 VR2W 121 A69 1303 62901 Freeport 38 45544 121 5024 29847 10 17 2013 21 40 VR2W 121A69 1303 62901 Freeport 38 45544 121 5024 29848 10 17 2013 21 41 VR2W 121 A69 1303 62901 Freeport 38 45544 121 5024 29849 10 17 2013 21 42 VR2W 121A69 1303 62901 Freeport 38 45544 121 5024 29850 10 17 2013 21 43 VR2W 121A69 1303 62901 Freeport 38 45544 121 5024 29851 10 17 2013 21 52 VR2W 121 A69 1303 62901 Freeport 38 45544 121 5024 29852 10 17 2013 21 56 VR2W 121 A69 1303 62901 Freeport 38 45544 121 5024 29853 10 17 2013 22 21 VR2W 121A69 1303 62901 Freeport 38 45544 121 5024 29854 10 17 2013 22 31 VR2W 121A69 1303 62901 Freeport 38 45544 121 5024 29855 10 17 2013 23 00 VR2W 121 A69 1303 62901 l Freeport 38 45544 121 5024 29856 10 17 2013 23 09
11. Jiboom Street VR2W 112930 GS UCD B Acipenser medirostr 195 182 M gill net 3 A69 1303 52414 2013 08 03 11 41 47 00 00 38 45557 121 5022 SR_Freeport VR2W 121348 GS UCD B Acipenser medirostr 195 182 M gill net 4 A69 1303 52414 2013 08 03 11 43 16 00 00 38 45557 121 5022 SR_Freeport VR2W 121348 GS UCD B Acipenser medirostr 195 182 M gill net 5 A69 1303 52414 2013 08 03 11 44 39 00 00 38 45557 121 5022 SR_Freeport VR2W 121348 GS UCD B Acipenser medirostr 195 182 M gill net 6 A69 1303 52414 2013 08 03 11 45 51 00 00 38 45557 121 5022 SR_Freeport VR2W 121348 GS UCD B Acipenser medirostr 195 182 M gill net 7 A69 1303 52414 2013 08 03 11 48 16 00 00 38 45557 121 5022 SR_Freeport VR2W 121348 GS UCD B Acipenser medirostr 195 182 M gill net ra A69 1303 52414 2013 08 03 11 50 32 00 00 38 45557 121 5022 SR_Freeport VR2W 121348 GS UCD B Acipenser medirostr 195 182 M gill net This is just proof that you don t have to initially include an End_Date in a Receiver Deployment upload however you should include an End Date the time that the receiver was removed from the water at some point Often a researcher will end up just pulling a receiver from the field uploading their most recent detection record and forgetting to add an End_Date to their old deployment record Thus that record misleads other researchers into believing that there is still an active deployment of that receiver in the field
12. U CDFG Tramme Net San Pablo A Peter Klimley 17 A69 1303 34009 USACE LFC 04 2 6 2010 Oncorhynchus tshawytscha 0 0815 17 9 U Hatchery SacElkLan A Peter Klimley an arn 29nn 2 42nnnN Pr rem Ar PrN se WMA 42414 M1AMNAN Aciawwwee woe diane whale aan aan it Pee Aalia A Nadan WI oI n Note above Thomas Keegan has shared a tag with A Peter Klimley that is duplicated with another researcher somewhere Also A Peter Klimley has 2 duplicate tags owned by him A download of duplicate tags shows both records of A Peter Klimleys but only the shared record from Thomas Keegan There is a feature being developed on Hydra to have a master tag list available to anyone associated with Hydra This master tag list will just show tag_code and owner_name and contact information This would allow hydra users to get in contact with those researchers who own a particular tag and let them decide whether or not to share with that user UC Davis Biotelemetry Laboratory 11 Hydra Frequently Asked Questions and User Guide Sharing Tags with other researchers Sharing data is one of the benefits of Hydra It allows users to share their tags and tagging metadata with researchers all along the Pacific coast of North America Many users are tagging species in other watersheds and also maintaining arrays of automated acoustic receivers that can detect not only their tags but also tags that belong to other researchers Hydra automatically shares tags with users that
13. VR2W 121 A69 1303 62901 Freeport 38 45544 121 5024 29857 10 17 2013 23 11 VR2W 121A69 1303 62901 Freeport 38 45544 121 5024 29858 29259 For example if my battery was dead upon retrieval in the above record would use a corrected End_Date of 10 17 2013 23 11 01 for my deployment record It s difficult to determine at what point a receiver s battery died and thus ceased listening for detections By following this practice you help other researchers who wish to know when a detection could have been received by your monitors in the field UC Davis Biotelemetry Laboratory 23 Hydra Frequently Asked Questions and User Guide What if want to upload a Deployment file and not include an End Date This is recognized as an Active Deployment however caution is advised If the receiver is ever re deployed and a previous deployment is not closed Hydra may not be able to properly assign subsequent detection events especially if you move the receiver to a new location Below is a file could have uploaded to Hydra rrom rrom rrom rrom Utner CXISTING Ketresn re gt ON riter T Text TO Kemove vata LOnsolaate wynat n Group ungroup SUDTOTaI Access Web Text Sources Connections All Cait Link wf Advanced Columns Duplicates Validation Analysis v z Get External Data Connections Sort amp Filter Data Tools Outline G2 v fe A B c D E F mam H 1 Location Receiver_Type Serial_Number Latitude Longitude Start_Date En
14. and User Guide Tags and Tagging How to upload new tags and tagging files The following is excepted from http hydra3 sound data com user_guide data_overview html prepareTagFile Files to be uploaded to Hydra must be either comma delimited value files or Excel files of type Xls xlsx files are not currently supported All files must have a single header row which identifies the columns of the table If an Excel file contains multiple sheets all sheets are ingested For Tagging files the following column headers are required files without these capitalization and punctuation sensitive headers will be rejected e Tag _ ID the tag ID a number like 12345 e Code_Space the tag s code space like A69 1303 or A69 1206 e Tagging Date the tagging date in the format MM DD YYYY in Excel xls files any legal date or date time format is acceptable The following fields are ingested by Hydra if present but are optional e Researcher the name of the researcher This must exactly match the name of the Hydra user if these taggings are to be matched to that researcher e Species the formal SCIENTIFIC latin name of the animal Genus and species e Animal Weight the weight of the animal in kilograms this is a floating point decimal number e Animal Length Total The total length of the animal in centimeters this is a floating point decimal number e Animal Length Fork The fork length of the ani
15. by many months years which would result in thousands of orphaned detections for a given receiver serial number It is helpful to have the detection file open when comparing your Receiver Deployment record since you can narrow down if you ve been off by a few seconds with your End_ Date or Start_Date x Home Insert Page Layout Formulas Data Review View Acrobat UC Davis Biotelemetry Laboratory 28 Hydra Frequently Asked Questions and User Guide How can I fix my orphaned tag detections Download your tags and tagging files first before ever downloading detections Look at duplicate tags see what tags are shared with you and see what tags you ve uploaded Additionally maybe you ve forgotten to upload tags or a study might be misnamed Download all deployments so that you know what is out there This will help if you are getting Orphaned Detections by helping you track down the owners of a given receiver serial number as well as the times when a given receiver was deployed Often some of these orphaned detections occur only a few seconds after a monitor was pulled the field team may have written the wrong End Time down and that mistake ended up getting carried forward through the Receiver Deployments upload process If you own a receiver with an incorrect deployment file Start and End Dates are wrong you have the capability to change this using the Edit Deployment function If you do not own those receivers downloading a
16. do Cell Styles Hal Format G Filter Select Clipboard Ma Font P Alignment Number Styles Cells Editing D2 i A B c E F G H l 1 Location Tag Type Serial Number Start Date End Date Latitude Longitude Researcher E BayBr12B VR2W 102138 2013 10 31 19 07 00 00 00 12013 0102 18 05 514 00 00 37 80072 122 37471 A Peter Klimley 3 A The New receiver deployment record File Home Insert Page Layout Formulas Data Review View Acrobat a Gf x ae Z B HP Genera f Conditional Formatting q Insert 7 da Calibri u AY a E daj Conditional Formatting gq Inser EJ A JA ar E E vg 9 E Format as Table F Delete g Faste 3 BE Z U B A la ee TR 50t Find amp E i iE y oo 0 Cell Styles Hal Format Filter Select Clipboard Ta Font m Alignment Number Styles Cells Editing D2 h OF bel A B c E F G H l 1 Location Tag Type Serial Number Start Date End Date Latitude Longitude Researcher E BayBr12B VR2W 102138 2011 10 31 19 07 00 00 00 2013 01 02 18 05 514 00 00 37 80072 122 37471 A Peter Klimley a A F made sure to go back and manually enter this correction into Hydra for this receiver JOINHYDRA LOGOUT ABOUT Edit Data VR2W 102138 View your recewer deployment data Upload Location BayBr12B Location BayBr1 2B Download Start date i RS OSHC Ab Start date Zi E 10 31 19 07 00 Edit End date 2013 01 02 18 05 51 End date 2013 01 02 18 05 51 Map Latitude 37 80072 Latitude 37 800
17. e Latitude the latitude of the deployment in degrees as a decimal number e Longitude the latitude of the deployment in degrees as a decimal number The following fields are ingested by Hydra if present but are optional e End_ Date the end date of the deployment If this is absent or blank the deployment will be considered still in service See Start_Date for details e Location the human readable location of the deployment e Researcher the name of the researcher This must exactly match the name of the Hydra user if these deployments are to be matched to that researcher would STRONGLY suggest including these optional fields They give you a more complete Receiver Deployment record one which you can track your deployment records and make changes as needed UC Davis Biotelemetry Laboratory 17 Hydra Frequently Asked Questions and User Guide Special notes for Receiver Deployment Files IT IS STRONGLY RECOMMENDED THAT THE OPTIONAL FIELDS ARE INCLUDED IN EVERY RECEIVER DEPLOYMENT UPLOAD Do not just simply make up names for receivers use already established names as appropriate Location Latitude and Longitude should remain constant if a receiver is repeatedly downloaded over multiple deployment periods at the same deployment site This will make organizing both deployment and detection data much more user friendly think of filtering data within Microsoft Excel or the program R when you go to a
18. m Aug 5 2013 10 44 p m 37 94207 12247545 VR2W 102148 SR_AbvGCID March 27 2013 7 29 p m July 1 2013 10 39 p m 39 80614 122 05830 VR2W 104723 Berkeley_Marina Jan 25 2013 7 36 p m Aug 6 2013 9 21 p m 37 86649 122 31712 VR2W 102138 BayBr12B Oct 31 2011 7 07 p m Jan 2 2013 6 05 p m 37 80072 122 37471 VR2W 102164 SR_MeridianBr2 June 17 2011 9 34 p m Oct 24 2011 10 09 p m 39 14157 121 92220 VRQW 121348 SR_Freeport July 2 2013 11 35 p m None 3845557 121 50220 If you don t want to re upload the same file you can use the Edit JOIN HYDRA LOG OUT ABOUT RESEARCHERS USER GUIDE function and add the appropriate Fdit Data VR2W 121348 corrections This can be cumbersome eee since you have to sift through all of Location SR_Freeport Start date 2013 07 02 23 35 00 End date WATIE TAN y Latitude 338 45557 Longitude 121 50220 Save Receiver Deployment at a time your deployments However just like editing tags within the Hydra user interface you can only edit one How do you update Owners to a Receiver Perhaps you ve uploaded a Receiver Deployment file without a Researcher column Users should be able to re upload the same basal information with the correct owner researchers name added The file name shouldn t matter and if everything else stays the same e g Start_ Date Latitude Longitude Serial_Number Receiver_Type the receiver record will be
19. updated Note that when a Receiver Deployment is paired with a Researcher column in a Hydra upload that assigned Researcher is the only account from which an edit is accepted This could be a problem if you are working under your own user account but assign a Receiver Deployment file to another user during the upload e g your supervisor s account Once the file is uploaded you would need to make changes under the specific user s account where the Receiver Deployment or Tags and Tagging file is now assigned If you ve misspelled the researchers name it is best to contact Hydra personnel and have them remove the upload A good rule of thumb is that all Receiver Deployment and Tags and Tagging files should be uploaded from one master account for each institution in order to facilitate edits and track data uploads UC Davis Biotelemetry Laboratory 27 Hydra Frequently Asked Questions and User Guide Don t Orphan Detections by uploading incomplete Deployment Files Also every Receiver Deployment file should be associated with a corresponding Detection file Receiver Deployments and their associated Detection files should be uploaded together In other words for a given deployment period there should be a corresponding detection file Don t create orphaned detections within the Hydra database To ensure data completeness all of a receiver s detections should fall within its Start Date Time and its End Date Time Refer to h
20. 1121_1 wrl VR2W_107 Receiver Log Files wrl Above You can select multiple vrl files to import to your VUE database via the VRL File Editor option under the Tools section in VUE like to do this because you can doa large batch of clock time drift corrections at once UC Davis Biotelemetry Laboratory 34 Hydra Frequently Asked Questions and User Guide Edit and Import VRL Files VRL File Editing Options VR2W_ 106501 20131121 _i vrl 2013 08 08 18 12 25 2013 11 21 15 36 28 VR2W_ 106501 20131121 1 edited vl UTI 2013 08 08 18 1225 2013 11 21 15 36 28 VR2W_107554_20131121_1 vwrl JT 2013 08 08 210 04 2013 11 21 20 11 21 VR2W_ 107554 20131121 1 edited vrl UTE 2013 08 08 21 0 04 2013 11 21 20 11 21 VR2W_107555_20131121_1 vrl IT 2013 08 08 22 53 15 2013 11 21 19 10 51 ha Corea like to replace the existing data set when importing into a new VUE When importing a VRL data set that already exists in the database database Make sure you are operating under the new VUE database that Keep the existing data set do not import VRL you made for the drift corrections In my case l Il be importing these to SLE Se aes my 2013 _Q3_GoldenGate_Drift vdb file and not the original VUE Replace the existing data set only if the VRL is newer ae database that used to initially download the receivers Edit and Import VRL Files VRL File Editing Options 2013
21. 31121 1_edited 12 4 2013 10 42 AM VRL File i Iri ACE bridges tats and marinas p EEEE J zl EH VR2W 107554 20131171 1 edited 12 4 2013 10 49 AM Microsoft Excel C GoldenGateArr p PPDP X oe _ WR2W_107554_ 20131121 1 edited vrl 12 4 2013 10 42 AM VRL File 1s ns_boldenwvate p mn z ain z EH VR2W_ 107555 20131171 _1_editeg 12 4 2013 10 49 AM Microsoft Excel C ris_boldenbateDriit_orrecte ae _ VR2W_107555_ 20131121 1 edited vrl 12 4 2013 10 42 AM VRL File volo oes SS S VR2W_106501_20131121 1 edited vrl Date modified 12 4 2013 10 42 AM Date credted 12 4 2013 10 42 AM WRL File Size 15 7 KB Offline availability Not available It s a good Idea to have the destination directory open and copy and paste the file name excluding the vrl extension as the new name for the output file and save as a csv file Holding shift right clicking and selecting Copy as Path is also a viable way to obtain the file name under windows 7 8 Export File JON i GoldenGateArray 2013_Tri3_GoldenQGate 2013_Tri3_GoldenGateDriftCorrected Organize v New folder d 2013 Tri 2 Name i Date modified Type Size aa PINN l E vR2W_107554_20131121 1 edited 12 4 2013 10 49 AM Microsoft Excel C 17 KB See aaa flats and marina SO VR2W 107555_20131121 1 edited 12 4 2013 10 49 AM Microsoft Excel C 36 KB E vR2W_109540_20131121 1 edited 12 4 2013 10 50 AM Microsoft Excel C 50 KB b e E VR2W 109542 _20131121_1_edited 12
22. 4 2013 10 50 AM Microsoft Excel C 90 KB _ 2013_Tri3_GoldenGateDriftCorrecte E vR2W_112534_20131121 1 edited 12 4 2013 10 50 AM Microsoft Excel C 14 KB b Eaa E VR2W_112537 20131121 1 edited 12 4 2013 10 51 AM Microsoft Excel C 23 KB A ee E vR2W_112541 20131121 1 edited 12 4 2013 10 51 AM Microsoft Excel C 45 KB Aa RAPA E E vR2W_113471_20131121 1 edited 12 4 2013 10 51 AM_ Microsoft Excel C 48 KB File name SUSU OE BETTI V Save as type Comma Separated Value csv Hide Folders UC Davis Biotelemetry Laboratory 36 Hydra Frequently Asked Questions and User Guide GoldenGateArray 2013_Tri3_GoldenGate 2013_Tri3_GoldenGateDriftCorrected v gt Organize v New folder di 2013 Tri 2 Name Date modified Type 2013 Tri3 _ 2013 Tril ACE bridges flats and marina di GoldenGateArray GL VR2W_107554_20131121 1 edited 12 4 2013 10 49 AM Microsoft Excel C GL VR2W_107555_20131121 1 edited 12 4 2013 10 49 AM Microsoft Excel C an GL VR2W_109540_20131121 1 edited 12 4 2013 10 50 AM Microsoft Excel C J 2013_Tri3_GoldenGate N i Bi i GL VR2W_109542_20131121 1 edited 12 4 2013 10 50 AM Microsoft Excel C di 2013_Tri3_GoldenGateDriftCorrecte E ae 7 vR2W_112534_20131121_1 edited 12 4 2013 10 50 AM Microsoft Excel C d Master Array Database ae i ms GL VR2W_112537_20131121_1 edited 12 4 2013 10 51 AM Microsoft Excel C di Miscellaneous lab receivers _ GL VR2W_112541_20131121_1
23. 41 A Peter Klimley 3 VR2W 107554 8 8 2013 21 36 00 11 21 2013 20 06 00 37 82794 122 46168 A Peter Klimley 4 VR2W 107555 8 8 2013 22 54 00 11 21 2013 18 56 00 37 81856 122 45764 A Peter Klimley 5 VR2W 109540 8 8 2013 17 05 00 11 21 2013 18 09 00 37 81129 122 46666 A Peter Klimley 6 VR2W 109542 8 8 2013 17 26 00 11 21 2013 17 34 00 37 81615 122 46799 A Peter Klimley 7 VR2W 112534 8 8 2013 18 15 00 11 21 2013 17 15 00 37 82215 122 46622 A Peter Klimley 8 VR2W 112537 8 8 2013 22 08 00 11 21 2013 19 25 00 37 82542 122 45993 A Peter Klimley 9 VR2W 112541 8 8 2013 23 12 00 11 21 2013 18 35 00 37 81305 122 45598 A Peter Klimley 10 VR2W 113471 8 8 2013 20 20 00 11 21 2013 21 26 00 37 83393 122 46794 A Peter Klimley 11 Above The Receiver Deployment file that will upload to Hydra Below check each associated detection file to make sure that the detections fall within my given Receiver Deployment time period This will help to avoid orphaned detections within the Hydra database Here I m checking the csv detection file for receiver VR2W 106501 x H iz VR2W_106501_20131121_1 edited Microsoft Excel Home Insert Page Layout Formulas Data Review Acrobat 5 5 t 4 d Zoom t e Arrange ez gt i i Switch R All Pane It g Reset rosition pace Windows 7 Workbook Views Window Macros 1 Date and Time UTC Receiver Transmitter Transmitte Transmitte Sensor Va Sensor Un Station Na Latitude Longitude 2 8 11 2013 5 42 48 A
24. 49 AM Microsoft Excel C anne VR2W_107555_20131121 1 edited vrl 12 4 2013 10 42 AM VRL File a i 5 VR2W_109540_20131121 1 edited 12 4 2013 10 50 AM Microsoft Excel C A Ryan Corrections to H T WR2W 109540 20131121 1 edited vrl 13 4 2013 10 42AM VRLFile v di Status After 2012 Tria mT j File name VR2W_109540_20131121_1 edited 2013_Tri3_GG_DriftCorrected Hy UC Davis Biotelemetry Laboratory 40 Hydra Frequently Asked Questions and User Guide Rejoice received my email confirmation and all my files were JOINHYORA LOGOUT ABOUT RESEARCH USERGUIDE NEWS8 accepted This concludes this session of acoustic receiver downloads and their processing Upload Results and uploading to Hydra Status of uploaded files File 2013 Tri3_GG_ DrittCorrected Hydrakeady xls accepted for processing File VR2W 106501 20131121 1 edited csy accepted for processing File VRZW 107554 20131121 1 edited csv accepted for processing File VR2W 107555 20131171 1 edited csv accepted for processing read through this user manual and File VR2W 109540 20131121 1 edited csy accepted for processing lea rning how to process your data File VR2W 112534 20131121 1 edited csv accepted for processing File VR2W_112537 20131121 1 edited csv accepted for processing correctly The entire community of File VR2W_ 112541 20131121 1 edited csv accepted for processing researchers will benefit incl uding File VR2W 113471 20131171 1 edited csv accepted fo
25. 7 16 00 00 VR2W 102164 Klimley changed start D B 5 6 2011 Acipenser mediro A69 1303 818 2012 03 07 01 41 23 00 00 VR2W 104411 seein ue D A 9 8 2011 Acipenser mediro A69 1303 34023 2012 08 29 04 00 44 00 00 VR2W 104420 Ss D A 5 6 2012 Acipenser mediro A69 1303 16241 2011 10 07 16 33 51 00 00 VR2W 104431 GS UCD A 9 6 2011 Acipenser mediro A69 1303 34022 2012 05 08 18 12 21 00 00 VR2W 104454 GS UCD A 5 3 2012 Acipenser mediro Above are detections that were considered orphaned filtered for the first orphaned detection of a given tag_code to help me narrow down my search of which receiver had incomplete data Thus had a manageable dataset to begin my corrections UC Davis Biotelemetry Laboratory 29 Hydra Frequently Asked Questions and User Guide Here searched for the deployment record for VR2W 100149 This was an easy fix because quickly noticed that had included 2013 10 31 19 07 00 as the start date when in fact it was supposed to be 2011 10 31 19 07 00 chose to manually do the correction using the edit function in Hydra The old receiver deployment record File Home Insert Page Layout Formulas Data Review View Acrobat a pp s gt senera z Ta Conditional Formatting 7a Insert A f P3 aa a la a FF sener a Conditional Formatting q Insert E A py yr gt a B Format as Table Delete ae Paste en ree P T aoe x Sort amp Find amp F BiU cS E Sy
26. 72 Longitude 122 37471 Longitude 122 37471 3065 receiver deployments Save UC Davis Biotelemetry Laboratory 30 Hydra Frequently Asked Questions and User Guide Tag Detections Things to consider before you upload a detection file to Hydra Make sure that your computer has been recently synchronized to internet time before going into the field to download acoustic receivers VRAW 107469 A Is the PC clock correct The time and time zone of the PC clock will be used to sek the YRZ clock The current local time is 2013 03 18 10 39 UTC 08 00 The corresponding UTC time will be used 2013 03 15 16 39 UTC Hide this warning in Future Make sure that you have the current version of Vemco s VUE software loaded onto your computer You can download the current version at http vemco com downloads axel Transmitters VLJ 2 0 6 20130212 Phome L900 450 1 Copyright AMIRIX Systems Inc You can open old vrl files with the newest version of VUE software so if you haven t uploaded detection files to Hydra in a while don t fret It is important that the header data in a detection file output csv file match the header fields that are accepted by Hydra Those header columns can be found below in the How do I upload a detection file within Hydra section Hopefully you have your vrl detection files in one file directory If you do this will make correcting your detection
27. 9 FreeportRecenerleploymment Microsoft Evoa Heme Insert Page Layout Formulas Data Review Vitw Acrobat Bet mn A GY Nome Jos Gee Se GE EMO Paste olf Format Pointer E FU 2 iy a Ea TE EE RH Mere A Center 7 He OE Acai Mena Neutral a Calculation Insert Delete Format DO Cliptnard Font Alignmerd 7 Humber Skyla Cells Fiat D4 i A B C E F G H 1 Location Receiver Type Serial Number Latitude Longitude Start Date End Date Researcher 2 SK_Freeport VAZW 171348 38 45557 171 50279 7 2 2701 3 23 35 00 10 1 7 201 3 24 20 57 A Peter Klimley i Remember to save your file as a xls file because Hydra will not accept xlsx files You have to select Excel 97 2003 file extensions JOIN HYDRA LOG OUT ABOUT RESEARCHERS USER GUIDE NEWS amp EVENTS Data Uploads x Save As Add files to the Hydra database G er Desktop gt v Search Desktop s WY E 2 Browse FreeportReceiverDeployment xis Uploac Organize v New folder t X Microsoft Excel E FA System Folder You can include more than one acoustic l Ryan Battleson K Favorites E System Folder E Desktop m Downloads Computer t Recent Places z System Folder C Libraries Network E Tanani System Folder a Music Pictures F Videos oxi receiver s metadata in a Receiver Deployment upload Since the UC Davis Biotelemetry Lab downloads its monitors every 3 4 months include all of my Missing TempDataForCyril Fil
28. 9 23 vr Filename 2013Tri3_PanasonicT oughbook vdb v Database Files vdb g o l E ftm G a Shared gt Projects 69kHzArray Receiver Downloads 2013 Tri3 2013Tri3_PanasonicToughbook Thi S folder will end up housing Organize v Burn New folder K Favorites Name Date modified Type Size 1 Receiver Deployment datasheet E Desktop a 2013Tri3_PanasonicToughbook 972013 11 45 Microsoft Access 1 420 KB fil m Downloads F _ 2013Tri3_PanasonicToughbook vdb 1 25 2013 4 23 PM VDB File 114 669 KB access or exce l e i Recent Places l 2013Tri3Begin_exportl 10 22 2013 7 58 Att Miczosoft Excel W 34 KB 2013Tri3Begin_export2 11 19 2013 12 02 Microsoft Excel W KB 3 Libraries GL vR2W_101174_20131016_1 10 16 2013 10 47 Microsoft Excel C 7 KB 2 VUE database vdb file Documents _ VR2W_101174_20131016_1 vrl iL 10 16 2013 I0 47 YVABL Eile 7 KB Music VR2W_101174_20131016_1_edited vrl 10 22 2013 12 57 VRL File 3 aies ea 3 Detection files from the acoustic t Pictures L VR2W_101175_20131014 1 10 14 2013 5 35PM Microsoft Excel C 4 KB amp Videos _ __ L VR2W_101175_20131014_1 vrl 10 14 2013 5 35PM VRL File 7x8 receivers csv and vrl files Offline availability Not available 243 items Offline status Online UC Davis Biotelemetry Laboratory 15 Hydra Frequently Asked Questions and User Guide Make sure that your detection files are being s
29. FED STH 05 a A69 1303 40638 DWR SB CL 01 mee A69 1303 40647 GS Juv UCD BOR 2010 3894 tags U public tags A69 1303 40643 GS Juv UCD BOR 2011 D Step 3 Click to share and you re done Thanks for sharing T UC Davis Biotelemetry Laboratory 12 Hydra Frequently Asked Questions and User Guide You can see who you are sharing tags with by navigating to the Your Data Overview page gt Studies tab JOIN HYDRA LOG OUT ABOUT RESEARCHERS USER GUIDE NEWS amp EVENTS FUNDERS This page provides a summary of your Hydra data holdings cay your tags amp tagging data Upload Download Edit Share View your receiver deployment data View your tag detection data Upload e Upload Download e Download Edit e Map Map 9860729 tag detections 3056 receiver deployments 3894 tags 0 public tags Who you share data with Arnold Ammann Bill Poytress Christopher Schmidt Eric Chapman on fF WN fF Gabriel Singer This just gives you the overview of what tags has been shared with individual researchers and the number of tags JOIN HYDRA LOG OUT Your Studies Who shares data with you Alicia Seesholtz Emily Miller Phillip Dionne Robert Chase no fF WA N F Thomas Keegan y ABOUT RESEARCHERS DATA USER GUIDE NEWS amp EVENTS FUNDERS Study Name CALFED STH 01 CALFED STH 02 CALFED STH 03 CALFED STH 04 CALFED STH 05 DWR SB CL 01 GS Juv UCD BOR 2010 GS Ju
30. Important P to me Sent Mail Your upload into Hydra of file VR2W_106501_20131121_1_edited csv is now complete pes The results of the import were Circle diii VR WW _106501_20131121_1_edited csv processed successfully Detection File 649 rows 0 rejected 2013 Tri 1 and Midd If processing was successful your data can now be viewed at the Hydra site depending on the sharing settings of the dati AE D T ET a You can reply to this email if you have encountered any unexpected errors during the import process 2013 Tri 2 River and Enver an Thank you for using Hydra
31. M VR2W 106501 A69 1303 59110 GG1 i 8 11 2013 8 02 VR2W 106501 A69 1303 59110 GG1 8 11 2013 8 10 VR2W 106501 A69 1303 59110 GG1 8 12 2013 14 46 VR2W 106501 A69 1303 62927 GG1 O lAa JANAINA AA A ADAAL ANCE AA ALN ANAND 490A VR2W_106501_20131121_1_ edited Microsoft Excel Arrange eze ave Switch All Dane L Un e 2 eset Position ace Windows Home Insert Page Layout Formulas Data Review V Acrobat Workbook Views A650 X v f BEPEIPOER PERE Window Macros 1 Date and Time UTC Receiver Transmitter Transmitt TransmitteSensor Va Sensor Un Station Na Latitude Longitude 644 11 18 2013 9 19 VR2W 106501 A69 1303 816 GG1 645 11 18 2013 9 20 VR2W 106501 A69 1303 816 GG1 646 11 18 2013 9 21 VR2W 106501 A69 1303 816 GG1 647 11 18 2013 9 23 VR2W 106501 A69 1303 816 GG1 648 11 18 2013 9 24 VR2W 106501 A69 1303 816 GG1 649 11 18 2013 9 26 VR2W 106501 A69 1303 816 GG1 650 11 18 2013 9 29 58 AM VR2W 106501 A69 1303 816 GG1 651 UC Davis Biotelemetry Laboratory 39 Hydra Frequently Asked Questions and User Guide will now upload my time drift corrected Detection files and my Receiver Deployment file that has been converted to UTC time hydra3 sound data com data_overview vail Email from G Ocean Ecosystem In New Tab Hydra Hydrophone Online Conversion 2 FishAmerica Founda A M LOG OUT ABOUT RESEARCHERS DATA USER GUIDE NEWS amp EVENTS FUNDERS Jata Overview e provides a summary
32. T Minimum length No minimum aximum len No maximun then checked the Detections icon nicopenspuneuats aj en ee a ee ea Re Minimum weight No minimum Maximum weight No minimum then clicked download Date Data Start date Example 2012 12 01 End date Example 2012 12 31 Download Type Tags amp Tagging wb Receiver Deployments ri Tag Detections Download Below is the output for a detection file of the monitor that didn t have an End_Date associated with it Note that Latitude and Longitude and Deployment_Location are present in this output and there are no orphaned detections which is a good thing x lf 7 detections 515 Read Only Microsoft Excel J Fie Home Insert Page Layout Formulas Data Review View Acrobat a 2 BE i m oem rE r a E A ie A He A i AJ BR d Da Be Pe EP g A aE f From From From From Other Existing Refresh Z Sort Filter Vv Text to Remove Data Consolidate What If Group Ungroup Subtotal Access Web Text Sources Connections Ally 2 Advanced Columns Duplicates Validation Analysis 7 v Get External Data Connections Sort amp Filter Data Tools Outline c9 M fe A B oe os o E F G H i J K L M N o p Q 1 tag code detection_date latitude longitude deployment_location deployment_serial sensor_vasensor_urstudy_nartagging d species _nanimal_w animal_le animal_le depth gender capture 2 A69 1303 52414 2013 08 03 04 43 05 00 00 38 59985 121 50653
33. a Frequently Asked Questions and User Guide Selecting tag query by species name There are lots of names for Steelhead How do I know what to choose e Use the formal SCIENTIFIC name Genus is capitalized species epithet is lower cased How do edit a Tag Did you misspell your species name or give it a common name Currently Hydra allows free form species entry This means that some species do not match There are a couple workarounds for this 1 Researchers need to update their tags to match the name that is correct PLEASE USE THE SCIENTIFIC NAME AND DOUBLE CHECK THAT IT S SPELLED CORRECTLY This can be done by using the edit function in hydra or re uploading the file with corrections See explanation on How to make tag corrections starting on page 6 2 When downloading data ensure that you include any alternate names of species that other researchers may have used mistakingly the user interface currently has a multi select control click to select multiple species Note that there are 2 entries JOINHYDRA LOGOUT ABOUT RESEARCHERS USERGUIDE NEWS amp EVENTS FUNDERS for white sturgeon Acipenser Transmontanus and Acipenser transmontanus The latter is Data Downloads To download previous detections see your Download List correct however there may Use the options below to specify the data you wish to download Select as many as are necessary be a few tags in Hydra with a Tag Data capitol T in the speci
34. are a part of the same agency tribe company or research group For example a researcher with California Department of Fish and Wildlife will have access to tags that were uploaded by another researcher within the CDFW If you do not wish for other researchers within your agency to have access to your tags you must let Hydra personnel know this and they will keep your tags private until you share with individuals To share navigate to the Your Data Overview section gt Click Share gt then make selections from each Step 1 2 and Options A or B You can select multiple Individuals Tags or Studies by holding down CTRL while making selections using your mouse JOIN HYDRA LOG OUT ABOUT RESEARCHERS USER GUIDE NEWS amp EVENTS FUNDERS Your Data Overview Sharing Data in 3 Steps Tie paoe pes ASUMAN aea TA aA E aka aAa aaae TAKAA a AEE Ue ARE akaaka MaE AKERA Rusu Wala tua AAAA H Sharing your data is what makes Hydra a unique and valuable project Step 1 Please choose with whom you wish to share your data Select the individuals with whom you wish to share Share with public corliamd click to select multiples Share your data publicly View your tags amp tageing data Step 2 Select which tags you wish to share Download Fdit Select the tags you wish to share Select all the tags that belong to a study ctryemd click to select multiples carlfamd click to select multiples Share AG9 1303 40651 CAL
35. ase VRL File Editor transformed into drift corrected files Since gt have the original non drift corrected detection files the from the Golden Gate array from rowe Quarter 3 l Il start there Options s Exit VUE Edit Files i F di Receiver Downloads GoldenGateArray 2013_Tri3_GoldenGate Search 013 Tn3_GoldenGate Organize New folder di GoldenGateArray Name Date modified 2013_Tri3_GoldenGate di Master Array Database di Miscellaneous lab receivers m Monitor Data from Gabe up to 2012_Tril di Ryan Corrections to Hydra and CFTC dJi Status After 2012 Tri 3 _ VR2W_106501_20131121_1 vrl 11 21 2013 7 40 AM VRL File _ VR2W_107554_20131121_1 vrl 11 21 2013 12 13 VRL File VR2W_107555_20131121 1 wrl 11 21 2013 11 13 VRL File WR2W_109540_20131121_1 vrl 11 21 2013 10 23 WRI File wR2W_109542_20131121_1 vrl 11 21 2013 9 56 AM VRL File VR2W_112534_20131121_1 vrl 11 21 2013 9 26AM VRL File D D L J vr2w 105846_Tri2_Tri3_2012 4 2013 Tri 2 m di ACE Sacramento_Sturgeon_EmilyNameProperly ACE SF Dredging VR2W_112537_20131121 _1 wrl 11 21 2013 11 35 VRL File VR2W_112541 20131121 _1 wrl 11 21 2013 10 42 VRL File VR W 113471 20131121 _1 wrl 117 2172013 1 34 PM VRL File VR2W RLD_106501_20131121 1 vrl 11 21 2013 7 40 AM VRL File Ji Calfed Steelhead 4 Tl File name VR2W_113471_20131121_1vrl VR2W 106501 _2013
36. ata you wish to download Select as many as are necessary to download multiple specific tags Tag Data Mytags E Tags shared with me E Public tags V Duplicate tags Here downloaded 2 specific tags Only detections of these tags A69 1206 890 A69 1303 Only detections for this study All studies I A69 1206 890 and A69 1303 818 Space between Tags The output is a csv file with both tags and their associated metadata Note that output column headers are changed to lower case in a data download from Hydra Paste My A t SE kad Merge amp Center 9 g 393 Conditional Format Cell Insert Delete Format _ Sot amp Find amp sJ Format Painter F F o gt Formatting as Table Styles 7 x lt 2 Clear 7 Filter Select Clipboard Alignment Number Styles Cells Editing cs al a Poe ft or le Pf Peek te 1 tag_code study_name tagging date species name animal_weight animal_length_to animal_length depth gender capture_method location owner_name 2 A69 1206 890 GS UCDavis Heublein 4 18 2004 Acipenser medirostris 139 5 127 4 U San Pablo A Peter Klimley 3 A69 1303 818 GS UCD ACE SFBay 2011 9 8 2011 Acipenser medirostris 62 56 U CDFG Trammel Gill Net Suisun Ba A Peter Klimley A UC Davis Biotelemetry Laboratory 9 Hydra Frequently Asked Questions and User Guide Duplicate Tags How does Hydra deal with duplicate tags 1 Hydra will assign detections to a single fish for any time point prior to the tagging dat
37. aved in the folder that VUE database is in 2013778 _PanasorieToughbookvdb H Home Detections Events F L b A ill 2 es S we Detections Files Filters Stations Transmitters VR2W 106087 29856 detections s VR2W 106094 Date Time Code Space ID Transmitter Station Data i VR2W 108503 e VR2W 108504 2013 07 02 23 44 18 A69 1303 62901 A69 1303 62901 Freeport amp VR2W 108506 2013 07 02 23 54 05 A69 1303 62901 A69 1303 62901 Freeport e VR2W 108507 2013 07 02 23 55 25 A69 1303 62901 A69 1303 62901 Freeport R2W 108508 2013 07 02 2259 0 2 VR2W 108596 o1 Opti gt orang Display Offload Export Devices Other VR2W 108516 e VR2W 108518 201 Receiver Offload Storage Folder S Sane Z Shared Projects 69kHzArray Receiver Downloads 201 2013Tri3_Combined Change VR2W 108522 201 V Copy imported VRL files into this folder e VR2W 108523 201 lt VR2W 108524 En Offload File Format o VR2W 108525 VRL files only amp VR2W 108526 201 e VR2W 108527 201 VRL files and CSV files VR2W 108528 201 VRL files and legacy VR2 files e VR2W 108529 201 vo e VR2W 108532 z V Additionally offload raw data file from VR2W receivers RLD VR2W 108534 e VR2W 108537 e VR2W 108538 201 VR2W 108539 fa remma aannras i ane 201 Select Receiver Log Folder Click the Options tab gt Offload Then set the directory folder with
38. ccount http hydra3 sound data com join hydra Full rama Ryan Battleson rbattleson ucdavis edu Verify ama thattleson ucdavis edu Send us a message Howdy please add me as a user Changed your mind Return to home A Sound Data Management Project Report a problem Using different web browsers Google Chrome Seems to be the best All pages fit without having a scroll bar at the bottom Firefox Depending on your screen s resolution and your browser window size you may have a scrollbar dead space and or a compacted view with the Tag Detection category below the other categories on the Data tab Internet Explorer Seems to work May be a bit less responsive than Google Chrome Changing Passwords boered mas peler Change Password Log Ol oo MITTENT Se Upon joining Hydra a user is given a username and randomized password The password is usually difficult to remember but you may paste it from the e mail message that Hydra has sent to you You will need to log in at least once with this password Then you may change your password once logged in Or if you ve forgotten your password click the Reset Password link and supply the email address that is associated with your Hydra account e g that you used to initially register for Hydra An email should be sent to you with instructions on how to change your password 4 UC Davis Biotelemetry Laboratory Hydra Frequently Asked Questions
39. d_Date Researcher SR_Freeport VR2W 121348 38 45557 121 5022 7 2 2013 23 35 00 Ja Peter Klimley 3 To the left then downloaded all Deployments Note that the Receiver Deployments tab is clicked at the bottom JOIN HYDRA LOG OUT ABOUT RESEARCHERS DATA USER GUIDE NEWS amp EVENTS FUNDER Data Downloads To download previous detections see your Download List Below This is the output from the Use the options below to specify the data you wish to download Select as many as are necessary Tee Date Receiver Deployments download filtered V My tags V Tags shared withme V Public tags Duplicate tags for SR_Freeport Note that the end date Only detections of these tags Enter tag codes here Only detections for this study All studies m iS missing This can signify an active Animal Data receiver deployment You must Species g All species a Mini No minimum Pee remember to go back and include an Micropterus punctulatus 53 inimum length No minimum Maximum length No maximum Micropterus salmoides Minimum weight No minimum Maximum weight No minimum end date since this could turn into an ae incomplete record in the future if you ate Uata E aT remove the deployment or change Start date Example 2012 12 0 End date Example 2012 12 23 j Hlowntoad Iype locations amp Tags amp Tagging AF Receiver Deployments fej Tag Detections eee a
40. e of the most recently tagged and released fish with the duplicate ID including codespace Detections that occur after the tagging date of the most recently released fish will be assigned to this most recently released fish 2 Hydra is operating under the assumption that an oldest version of a duplicate tag ID is no longer operating This is the same assumption that Vemco presumably made prior to reissuing the duplicate taglID 3 Still a researcher and those they share their tags with need to know the tag s metadata and operate under common sense assumptions For example detections of a tag cannot occur until that tag is put in a fish and released into the watershed bc sound data com data download The screen shot to the left shows Data Downloads Tag Data Duplicate Tags is checked To download previous detections see your Download List Animal Data All Species is checked Use the options below to specify the data you wish to download Select as many as are necessary Tag Data Date Data Not necessary but if you My tags Tags shared with me Public tags Rie em elt Only detections of these tags Enter tag want to narrow your search enter dates in the proper YYYY MM DDformat note this is different from the expected Only detections for this study All studies Animal Data Species Minimum length No minimum Maximum length No maximun MM DD YYYY for CSV upload Micropterus punctulatus Microp
41. e folder Filename FreeportReceiverDeployment Save as type Excel 97 2003 Workbook x Authors Ryan Battleson Tags Add a tag acoustic receivers approx 200 in one E Save Thumbnail Receiver Deployment upload to Hydra a Hide Folders Looped in as peter Change Password Lo JOIN HYDRA LOG OUT ABOUT RESEARCH DATA USER GUIDE NEWS amp EVENTS FUNDERS Upload Results Status of uploaded files File FreeportReceiverDeployment xls accepted for processing Your upload has been queued for processing You ll receive an email from Hydra when the data has been imported into the Hydra system Thank you for using Hydra Return to Uploads page UC Davis Biotelemetry Laboratory 20 Hydra Frequently Asked Questions and User Guide It is then always a good idea to download all deployments to verify that your upload processed successfully To the left then downloaded all JOINHYORA LOGOUT ABOUT RESEARCHERS MMMM USERGUIDE NEWS amp EVENTS Deployments Note that the Receiver Deployments tab is clicked Data Downloads at the bottom To download previous detections see your Download List Use the options below to specify the data you wish to download Select as many as are necessary Tag Data V My tags V Tags shared with me V Public tags C Duplicate tags Only detections of these tags Enter tag codes here Only detections for this study All studies v Animal Data Species
42. e time you choose to use for collecting field data remember to note it in your C 4 05 11 PM field notes so that you can properly transform your deployment data into UTC Time zone ti m e UTC 08 00 Pacific Time US amp Canada Change time zone Syncing to internet time For a desktop computer that is attached to a network Daylight Saving Time begins on Sunday March 09 2014 at 2 00 AM The A and set to internet time you should not have to manually sync to internet 4 Notify me when the clock changes si Sea time However laptops need to periodically have their clocks synced with internet time if they haven t recently been connected to the internet How do I set the clock and time zone ox cancel Set up a VUE database for each computer that will be responsible for downloading acoustic receivers Open or Create a new database Se m Shared Projects 69kHzArray Receiver Downloads 2013 Tri3 2013Tri3_PanasonicToughbook Organize v New folder E Videos Name Date modified Type Size L 2013713 PanasonicToughbookvdb 11 25 2013 4 23PM VDB File 4660 KB Sometimes there are multiple crews jM Computer amp Local Disk C that might download acoustic receivers ca OS D LaCie in the field would suggest having a G2 LAWR L G METRO M z VUE database for each computer that SG ETOX N GP WECB 0 downloads any acoustic receivers G2 klimley 16
43. edited 12 4 2013 10 51 AM Microsoft Excel C di Monitor Data from Gabe up to 2012_Tr i a i l i GL VR2W_113471_20131121_1 edited 12 4 2013 10 51 AM Microsoft Excel C db Ryan Corrections to Hydra and CFTC Filename WMU ges srs Save as type Comma Separated Value csv a Hide Folders Make sure Comma Separated Value CSV Z Shared VR2W_106501_20131121_1_edited csv Change is checked and the Raw sensor values is checked Click ok and your csv files will go Comma Separated Value CSV a ee are eae to the directory you specified window Main Menu gt Options gt Export C Legacy VR2 Format Data will be converted to conform with the selected map and any detections that do not fit the map will be discarded Times are in UTC MAP 110 69 kHz Sensor Format Calibrated sensor values Raw sensor values UC Davis Biotelemetry Laboratory 37 Hydra Frequently Asked Questions and User Guide How do upload a detection file within Hydra Below is an excerpt from the Hydra User Guide It is the outline of what Hydra accepts as header columns for Detection files My example above pp 26 32 should help this make more sense A csv export from VUE gives these column headers as the output VUE also exports your detections in UTC time so there should be no need for further conversions http hydra3 sound data com user_guide prepareReceiverFile The ideal form for detection u
44. er Deployment files this is one of the most important data uploads If procedures are followed properly this upload process should result in fewer headaches for any data analysis after downloading Tag Detections data Below is an excerpt from the Hydra User Guide for preparing Receiver Deployment files http hydra3 sound data com user guide prepareReceiverFile Files to be uploaded to Hydra must be either comma delimited value files or Excel files of type xls xlsx files are not currently supported All files must have a single header row which identifies the columns of the table If an Excel file contains multiple sheets all sheets are ingested For Receiver Deployment files the following column headers are required files without these headers including capitalization will be rejected e Start_Date the deployment start date in format MM DD YYYY or YYYY MM DD HH MM SS in Excel files any legal date or date time format is acceptable Note that in order to be a valid date format Excel must parse the field as a date Excel will right align properly formatted dates but will left justify improperly entered dates if you have not manually altered the cell column formatting If your text is left aligned your date format may have problems All times will be assumed to be in UTC e Receiver_Type the receiver type as a text string like VR2W e Serial Number the receiver serial number as a text string like 102169
45. ers 56 a RG SE SR bto Stations 9 SS Imported Log Files 0 T Detection Filters 0 Make sure that you will be offloading your drift corrected detection files into the proper directory In my case want to import my transformed files into the Select Receiver Log Folder 2013 _Tri3_GoldenGateDriftCorrected folder a Raw Data Benicia Carquinez May 2013 Downlo Receiver Downloads TO m gt fy 2012 Tri2 gt 2012 Tri3 Display Offload Export Devices Other pra Receiver Offload Storage Folder di 2013 Tri 2 B 2013 Tri3 i di 2013 Tril ACE bridges flats and marinas 4 GoldenGateArray Offload File Format a 2013_Tri3_GoldenGate 2013_Tri3_GoldenGateDriftCorrected od Master Array Database Z Shared Projects 69kHzArray Receive 2013_Tri3_GoldenGateDriftCorrected V Copy imported VRL files into this folder C VRL files only VRL files and CSV files VRL files and legacy VR2 files di Miscellaneous lab receivers i di Monitor Data from Gabe up to 2012_Tril V Additionally offload raw data file from VR2W receivers RLD E Rvan Corrections to Hvdra and CFTC p a UC Davis Biotelemetry Laboratory 33 Hydra Frequently Asked Questions and User Guide New VRL File Inspector a EA Database Display VRL files details Now lIl begin importing vrl files that want gj oem Multiple files may be selected Datab
46. es J My tags V Tags shared with me V Public tags Duplicate tags epithet Those tags should be Only detections of these tags Enter tag codes here Only detections for this study All studies edited Animal Data Species Ar rie p rri A EA EUTG Minimum length Nc mur Maximum length No maxii Coho juv Oncorhynchus tsawytscha Minimum weight No minimun Maximum weight No minimul Acipenser Transmontanus Bg 3 Ifyou have a large number of tags in Hydra that need correction ask the Hydra personnel to PURGE those tags and resubmit the corrected files once the purge is complete If you have not heard back from Hydra staff within 2 buisness days please contact them again Often one email is not enough Otherwise the edit function should suffice Jennifer Scheuerell jennifer sound data com Mike Knox mikeknox sound data com UC Davis Biotelemetry Laboratory 14 Hydra Frequently Asked Questions and User Guide Preparedness before servicing acoustic receivers in the field Sync your computers to internet time before you leave your office to perform downloads of acoustic receivers Date and Time Time Zones For Pacific Coast researchers it s a good idea to always have your computer set to Pacific Standard Time note the text which reads the clock is Date and Time Additional Clocks E A euP ON not set to adjust for daylight savings time or UTC GMT Regardless of what 4 F EF tim
47. esseceecescsseeceecsseseeeeeeseeees 17 o Editing receiver assigning owner of receiVefS sssesseesessereseseserressrerereseses 17 24 26 e Converting receiver deployment times to UTC esssesessessessesrersseresrerreessesesrereeeseeseereeesee 18 19 e Uploading receiver deployment files to Hydra eeseeoseeseseeresesesreresssesreesessereseseresesssreressseseeee 19 e Downloading receiver deployment files from Hydra esesseeeesesoeeeseseseeresseeseseseseeessesereseesseee 20 o Checking historical records of receiver deploymMentS sesseesesseesesseeseseereseseeresseeee 20 e Failed uploads and error message EMAIIS cccsceceecesssnsecescesseceecesceeeeceecsssaeeeecesseeaeeces cess 21 UC Davis Biotelemetry Laboratory Hydra Frequently Asked Questions and User Guide Uploading Receiver Deployments with no time STAMPS ccccccccccccssssesseeceeceseesseeeeceeceecs 22 o How Hydra assumes assigns times for Start_Date and End_Dates Receiver Deployments Continued Page Uploading Receiver Deployments with no End_Date Active Deployments 23 o What does one of these uploaded files look LiKe oo ccc ceeeeceececeeeeeeeceeeeeeeees 23 o What does one of these downloaded files look liK eee cece ceseceeeeeeeeeeeeeeeees 24 Re uploading a Receiver Deployment file With COrrectiONS ccccccessesssssseseeceeeesesseeeeees 25 Using Edit function to update a receiver s End Date cccccscccc
48. files for clock drift much easier See above explanation on page 11 Preparedness before servicing your receivers in the field UC Davis Biotelemetry Laboratory 31 Hydra Frequently Asked Questions and User Guide Correcting for an acoustic receiver s internal clock s time drift make sure to nest my drift corrected folder within the appropriate quarter or trimester s directory folder g i 69kHzArray Receiver Downloads GoldenGateArray 2013_Tri3_GoldenGate gt v s Burn New folder Organize v i Projects a 4 69kHzArray Raw Data Benicia Carquinez May 2013 Download a Receiver Downloads gt J 2012 Tri2 gt 2012 Tri3 gt 2013 Tril gt bb 2013 Tri2 gt J 2013 Tri3 gt 2013 Tril ACE bridges flats and marinas 2 GoldenGateArray pi 2013_Tri3_GoldenGate _ 2013_Tri3_GoldenGateDriftCorrected ad Master Array Database m N 22 itame I like to make a brand new VUE database that I will use for making time drift corrections to my detection files Name ad 2013_Tri3_GoldenGateDriftCorrected _ 2013Tri3_Q3_GoldenGate vdb E Copy of GG Deployments GL VR2W_106501_20131121 1 _ VR2W_106501_20131121 _1 vrl GL VR2W_107554_20131121 1 _ VR2W_107554_20131121 1 vrl GL VR2W_107555_20131121 1 _ VR2W_107555_20131121_1 vrl GL VR2W_109540_20131121 1 _ VR2W_109540_20131121 1 vrl GL VR2W_109542_20131121 1 Date modified 12 5 2013 10 56 AM
49. ift corrected detection file Hydra assumes that your detections have already been corrected for Clock Drift It is up to you to follow the steps outlined above in order to accomplish this task If you ve already uploaded non drift corrected data DO NOT RE UPLOAD TIME DRIFT CORRECTED DATA If you do this you will have twice as many detections per Receiver Deployment than expected If you accidentally re upload the exact same detection data do not worry Hydra only keeps a single copy of time matched data UC Davis Biotelemetry Laboratory 38 Hydra Frequently Asked Questions and User Guide It s a good practice to upload Receiver Deployment and Detection files during the same Hydra session and day For quality control you should make sure that the detections in a csv file fall within your Receiver Deployment s start and end dates Ci E 2013_Tri3_GG_DriftCorrected_HydraReady Microsoft Excel o xP X Home Insert Page Layout Formulas Data Review View Acrobat a o pi ig ae Calibri Ju Aw s y E Wepre General i E E57 gy o FK i i o Ay ES gt roomat inter B 4 W Q Aj WF eB isterescenter s ad A Eondon Forme can mest Delete Format a Gear Faunce moda Clipboard A Font 3 Alignment i Number 3 Styles Cells Editing B2 X fe VR2W a ss ea sco es ee seas a ss a 1 Receiver_Type Serial_Number j Start_Date End_Date Latitude Longitude Researcher 2 106501 8 8 2013 18 47 00 11 21 2013 15 30 00 37 82898 122 47
50. in VUE gt m Boats Ji Lablnfo i 4 di Projects anii 4 m 69kHzArray Display Officad Export Devices Other J Raw Data Benicia Carquinez May 2013 4 m Receiver Downloads gt 2012 Tri2 Z Shared Projects 69kHzArray Receiver Downloads 2013Tri3_DellToughbook y di 2012 Tri 3 Receiver Offload Storage Folder r F Copy imported VRL files into this folder 2013 Tril gt J 2013 Tri2 a 2013 Tri3 2013Tri3_Combined 2013Tri3_DellToughbook di 2013Tri3_Panasonic Toughbook V Additionally offload raw data file from VR2W receivers RLD D DellToughbook m Offload File Format VRL files only VRL files and CSV files 5 VRL files and legacy VR2 files You now have a consistant organizational structure for your data all of your detection data and deployment data are in one place for a round of downloads This allows the preparation of data for Hydra to be more straightforward and of higher integrety Proceed to download your acoustic receivers in your given study area and feel confident that your data is organized for future work UC Davis Biotelemetry Laboratory 16 Hydra Frequently Asked Questions and User Guide Preparing Receiver Deployment Files for Hydra From my experience the preparations of these files are where the majority of mistakes are made when entering one s Receiver Deployment data into Hydra Because detection files are associated with Receiv
51. ion Receiver_Type Serial_ Number Latixide Longitude Start_Date End_Date 121348 38 45557 121 5022 7 2 2013 23 35 00 ABOUT RESEARCHERS DATA USER GUIDE NEWS LOG OUT JOIN HYDRA JOINHYDRA LOGOUT ABOUT RESEARCH USERGUIDE NE Data Uploads Add files to the Hfdra database Browse FreeportReceiverDeployment xis U p load Upload Results Status of uploaded files File FreeportReceiverDeployment xls accepted for processing Your upload has been queued for processing You ll receive an email fre Return to Uploads page Your upload at Hydra is complete FreeportReceiverDeployment xls D Inbox x hydra sound data com 10 44 AM 1 minute ago to mep Your upload into Hydra of file FreeportReceiverDeployment xls is now complete The results of the import were FreeportReceiverDeployment xls Sheet1 processed successfully Deployment File 1 rows 0 rejected If processing was successful your data can now be viewed at the Hydra site depending on the sharing settings of the data You can reply to this email if you have encountered any unexpected errors during the import process Thank you for using Hydral UC Davis Biotelemetry Laboratory 26 Hydra Frequently Asked Questions and User Guide Using Edit Function to update a Receiver Deployment VR2W 107015 RichBr_28 2009 Jan 8 2013 9 09 p m Aug 5 2013 10 50 p m 37 94161 12247368 VR2W 107009 RichBr_29_ 2009 Jan 8 2013 9 25 p
52. m Jan 10 ia to me Your upload into Hydra of file 2012_Tri _ Deployments UCDavis UTC xls is now complete The results of the import were Error in processing file 2072 In2 Deployments UCDavis UTC xls Unable to parse end date Date string was 7 27 2012 4 329 16 PM and did not match YYYY MM DD HH MM 5 or MM DD YY YYY unconverted data remains 4 329 16 PM The emails will usually give you a hint as to why your upload failed The above file had an incorrect time under my End_Date column had to go back and look at the time columns Turns out that had incorrectly entered a time for an end date Remember that times will to automatically be right justified within Microsoft Excel software if properly formatted Acell is likely not recognized as a Date or Time unless it is right justified Perhaps there was a bad file extention Using the xls file extention fixed this upload below Your upload at Hydra is complete 2013 Tri 2 Miscellaneous amp Deployments xlsx Inbox x hydra sound data com Sep 11 A 7 to me Your upload into Hydra of file 2013 Tri 2 Miscellaneous Deployments xlsx is now complete The results of the import were 2013 Tri 2 Miscellaneous Deployments xlsx has an unknown extension and was not processed If processing was successful your data can now be viewed at the Hydra site depending on the sharing settings of the data You can reply to this email if you have encountered any unexpected err
53. mal in centimeters this is a floating point decimal number e Gender the gender of the animal one of M F U or blank e Collection Method the method of collection or capture e Tagging Location A name for where the fish was tagged and or released e Study_Name a unique identifiable study name for a group of tags This study must be created through the Hydra web interface first see below and the name used verbatium copy and paste in the data sheet From my personal experience would STRONGLY recommend that a Study_Name is included in this Tagging file It is much more difficult to retroactively assign a Study_ Name to a particular tag However you can assign a study name to a tag if the tag is already in Hydra and does not already have a study name assigned to it A tag can only have ONE study name assigned to it and this name cannot be modified by the end user once set 5 UC Davis Biotelemetry Laboratory 6 Hydra Frequently Asked Questions and User Guide How to make Tags and Tagging Corrections How I create a new Study_Name OR What if I didn t include a Study_Name column in my original Hydra upload of a tags and tagging file To assign a new tag to a study name you must go to the Studies tab under the Your Data Overview section and click Add New Study at the bottom of the Studies page 4 SIAM b ei Hydra insur rhattiescn gmail OD oi sound datacom date_ectt freta stomaticaly pend
54. mat Cells 3 mE Number Alignment Font Border Fil Protection eee Make sure to format date columns to verify that Gomera gj Samet Excel recognizes the value in the cell as being a time com 10 17 2013 23 20 52 o Accounting Tie Clicking on Custom then inputting a full style of Date m d yyyy h mm ss e e i 1 a eae ma A yyyy mm dd hh mm ss is highly recommended as Fraction d h r Scent this format will be compatible with Hydra in both ex mmi ss 0 Crem fm xls and csv format and all cells should have uniform 7 0_ _ 0 _ tas gt 0_ _ 0 _ 6 7 length This process assists with visual verification of AS 440 00 J _ 4 0 00 _ 6 77 J z E ol theme he a the validity of the data At the very least please edit _ Delete the time portion of the field to be hh mm ss This Type the number format code using one of the existing codes as a starting point allows for the additional display of seconds as well as forces excel to use a 24 hour clock rather than an EE AM PM style o cae The Start and End Times have been updated to UTC You should then copy all of the columns shown with header fields in red into a new blank Microsoft Excel spreadsheet UC Davis Biotelemetry Laboratory 19 Hydra Frequently Asked Questions and User Guide Below is my Receiver Deployment File FreeportReceiverDeployment xls ready for Hydra x Iid
55. mber references be Getting Started Page Getting a AY Gla ACCOUNT eaii T E eitucams a et eee 4 amp CHOOSING a WED DOW S Eranosian E 4 CAINS ASS WON OS marsta nein E E A dane 4 Tags and Tagging e HOW lO UplOaG lt a tae COA Ci aonan R T E 5 o Word of caution in uploading tags and tagging fil S cecsssseceecessseeeecesessteeceeens 7 e How to make corrections to a tag within hydra o Editine making a study MANIC nrinn e edad caiceoainielaieiuok aed aM 6 G FARNE TASS Metadaten TEE A oan 7 13 Downloading atag INHydi aerieni aE T r 8 Duplicate Tass i Hyarane E A 9 Example OF d plicate tag rECON Six ns ccrssadissiandedsadicasaahvassresuvtedicaeasiedaeauasheesivsadsdindededs 10 e Sharing tags with other researche ccsccccssssssecesssssseseecescsseeceecssessseecesesesueeescessaeaeeeeseseaeeeees 11 Selecting tae Query DY SDEGCIES nane erain A A 13 Preparedness before servicing acoustic receivers in the field SVMS COMM UCC COCK era a es Gusseoh sce ora suecwaauateuceeacuaeneus A a ucaves 14 SOUS Ula VUE Cat aS E anete e E A A EN E 14 o Setting your export directory for detection files in VUE sssssssssersseressesreserersesseeee 15 Receiver Deployments e Preparing receiver deployment files for Hydra cccccccssssssecescesseceecesessaeecescssesseeesessaeanees 16 Special notestorrecever deployment Szrensen A TA 17 o Naming receivers and moving FECEIVESS csssccsecessssscecesc
56. nalyze detection data Hydra will accept both 180 kHz and 69 kHz Receiver Deployments and Detections records You do not have to specify this I e DO NOT upload a file as VR2W69 xxxxx or VR2W180 xxxxx Please note that VR2W 121348 is not the same as VR2W69 121348 Monitor models before the hyphen are either VR2 VR2W VR3 etc A receiver named SR_Freeport is not treated the same as either Freeport or sr_ Freeport Note that Hydra is case sensitive Moving Receiver Deployments If you download an acoustic receiver but then decide to move the receiver s deployment site significantly use your own discretion for a significant move e g more than 5 rKm then the receiver should receive a new Location name as well as Latitude and Longitude Please use the proper Location Latitude and Longitude for the completed deployment for a receiver rather than in the event of a move where it is currently deployed A Receiver Deployment file should reflect where a receiver was when it was deployed Include a Researcher column in your upload How should the Researcher Owners be formatted in an upload Mel UWislivus WuUCUSaVIS 2uuU Michael Thomas Researchers mjthomas ucdavis edu Alex Hearn Fisheries Researcher arhearn ucdavis edu Pl Researcher urdavichintelametmiahMomail ram UC Davis Biotelemetry Laboratory 18 Hydra Frequently Asked Questions and User Guide Please match the name in Hydra e g
57. of your Hydra data holdings P L ki You can upload files by navigating to the Data tab then clicking Upload under either the Receiver Deployment or Tag Detection icons Both will take gs amp tagging data View your receiver deployment data View your tag detection dfta you to the same upload page Upload Download e Download Data Uploads Add files to the Hydra database Choose Files Na file chosen Unload Search 2013 Tri3_GoldenGate p chose the xls file extension Excel 97 2003 worksheet for my Receiver Deployment file Name Date modified Type Size 2013_Q2andQ3_GoldenGate_VR2W_109542 12 6 2013 11 08 AM Microsoft Excel 97 _ 2013_Q3 GoldenGate_Drift vdb 12 6 2015 10 00 AM WDE File I3_66_DriftCorected_HydraReady 12 6 2013 11 08 AM Microsoft Excel 97 c 4013_Tn3_G6_DriftCorrected_HydraRea Type Microsoft Excel 97 2005 Worksheet j k eee Sinh 12 6 2013 11 08 AM T WROW_ 106501 20131121 a edited wil pebrina also uploaded all the associated Detection files by holding the Mm CTRL key and selecting my detection csv MES p 2013_Tri3_GoldenGa VR2W_107554_20131171_1 edited 12 4 2013 10 49 AM Microsoft Excel C b 2013 _Tri3_Golden _ VR2W_107554_20131121 1 edited vrl 12 4 2013 10 42 AM VRL File i ais Garo Sa VR2W_107555_20131121 1 edited 12 4 2013 10
58. ors during the import process Thank you for using Hydral UC Davis Biotelemetry Laboratory 22 Hydra Frequently Asked Questions and User Guide What happens when you have a deployment that does not have an associated Start Date or End Date Hydra assumes if there is no time stamp for the Start_ Date that the time is midnight of that day 00 00 00 This may be ok for your purposes unless you moved that particular monitor from an old location on the same day In this case you need to have the appropriate times associated with each deployment period and subsequent detection records If a deployment record is missing a time stamp in the End_Date column Hydra assumes that the time is 23 59 59 This will help ensure that any detections that were present on that day are paired with that deployment record However the previously discussed scenario exists if a monitor is moved within the same day You run the risk of deployment metadata not being paired correctly with detection data It s best to include hours and minutes in your deployment files If a receiver dies e g dead battery or improper detection of a tester tag prior to the retrieval process rather than leaving an open ended deployment record or setting the deployment end time to the retrieval end time it is better to set the deployment end time to one second after the last valid detection IZ E VR2W_121348_20131017_1 edited Microsoft Excel Fie Home
59. ow Hydra assigns times to start dates and end dates if they do not include a time stamp bottom of page 22 Orphaned Tag Detections in a Detection download What is an orphaned tag detection OR get detections of my tag but no latitude longitude or receiver serial number are listed for a detection My tags seem to be orphaned 1 An orphaned detection is a detection of one of your tags that only includes the tag ID date and time of tag detection and the associated tagging metadata of that tag species tagging date location where fish was tagged sex weight owner of tag etc It is generally lacking the latitude and longitude and location of where the tag was detected but does include the serial number of the receiver that detected the tag 2 There can be only a few orphaned detections on a particular receiver serial number or there can be thousands If a tag has orphaned detections on a particular serial number there could be 2 possible reasons 1 A researcher who owns that particular receiver has either NOT uploaded a deployment file for that receiver but uploaded detections files to Hydra for the relevant time period or 2 The deployment file of that serial number does not have an adequate Start_ Date and time and End_Date and time that encompasses the detections that are in Hydra The end date and time may be only off by a few minutes or seconds which would result in only a few orphaned detections or it could be off
60. ploads is direct export from the VUE software as CSV Any other files will be processed as a best effort If at all possible export CSV directly from VUE to be uploaded Otherwise files to be uploaded to Hydra must be either comma delimited value files or Excel files of type xls xlsx files are not currently supported All files must have a single header row which identifies the columns of the table If an Excel file contains multiple sheets all sheets are ingested For Tag Detection files the following column headers are required files without these headers including capitalization will be rejected e Date and Time UTC The detection time in format YYYY MM DD HH MM SS in Excel files any legal date time format is acceptable All date time values must be in UTC and corrected for time drift e Receiver The identifier for the receiving station like VR2W 102153 e Transmitter The tag which was detected like A69 1303 4325 The following fields are ingested by Hydra if present but are optional although some combinations are required please note the details e Sensor Value The sensor value of the detection Must be a number e Sensor Unit The sensor unit of the detection Typically something like ADC When exporting data please ensure you corrected for time drift and choose the Raw Sensor Data option instead of the Calibrated Data option It is important to know that you should only upload the Clock Dr
61. r processing Thank you for taking the time to you When the future you begin Your upload has been queued for processing You ll receive an email from your analysis they will surely thank Return to Uploads page the past and present you Click here to enable desktop notifications for Gmail Learn more Hide Gmail COMPOSE P Social Mikky T Google Google team Inbox 255 hydra Your upload at Hydra is complete VR2VWV_113471_20131121_1_edited csv Your upload int starred Important hydra Your upload at Hydra is complete VR2W_112541_ 20131121 _1_edited csv Your upload inti Sent Mail hydra Your upload at Hydra is complete VR2W_112537_ 20131121 1_edited csv Your upload int Drafts hydra Your upload at Hydra is complete VRAW _112534_20131121_1_edited csv Your upload int Circles 2013 Tri 1 and Midd hydra Your upload at Hydra is complete VR2W_109540 20131121 1 edited csv Your upload int 2013 Tri 1 River and hydra Your upload at Hydra is complete VR2VWV_107555_20131121_1_edited csv Your upload inti 2013 Tri 2 River and RonF hydra Your upload at Hydra is complete VR2VWV_107554_ 20131121 1_edited csv Your upload inti W hydra Your upload at Hydra is complete VR2W _106501_20131121_1_edited cswv Your upload inti search people EM Sean Hayes NO hydra Your upload at Hydra is complete 2013 Tri3_GG_DriftCorrected_HydraReady xls Your u ILAT eu hydra sound data com
62. record or deployments gives you the capability of making contact with the researcher who does own the receiver or making an educated assumption of that receivers whereabouts Lat Longs If the download of a Receiver Deployment record fails to give you an owner of a particular receiver you can always contact Vemco and they will usually get you in contact with the owner of a the unknown receiver kd 9 E RyanDatabaseCorrections_Oct2013 Microsoft Excel Cut PE H I ae O ao Calibri 11 Ma XY Bi Wrap Text General H i E om K m lt 2 Copy 7 ES i B Z U lt b fadMerge amp Center gt 9 lt 9 00 Conditional Format Cell Insert Delete Format F Format Painter iii ko Formatting 7 as Table Styles 7 z z z Clipboard Font Alignment Number Styles Cells f A69 1303 5451 M B c p E A T E 2 3 4 z 6 7 8 9 an Oo ay tag_code detection_date latitude longitude deployment_location deployment_serial sensor_vasensor_urstudy_nartagging date species nanimal_ A69 1303 48423 2010 05 06 04 49 45 00 00 VR2 3475 GS UCD B 5 3 2010 Acipenser mediro A69 1303 16243 2011 09 23 18 34 40 00 00 VR2 6286 GS UCD A 9 12 2011 Acipenser mediro A69 1303 48419 2010 04 05 20 43 29 00 00 VR2 7685 GS UCD B 5 3 2010 Acipenser mediro A69 9001 31504 2012 11 29 06 11 16 00 00 VR2W 100149 Stur 9 1 2011 Acipenser mediro A69 1303 16241 2011 12 01 21 47 32 00 00 VR2W 102138 e D A 9 6 2011 Acipenser mediro A69 1303 48421 2011 06 19 04 3
63. s again to see if they were properly updated sound daiacam dat Data Downloads i Tt is always a good Idea to download your To download previous detections see your Download List tags as we As ny tags th at are s h 4 red R ne below to specify the data you wish to download Select as many a3 are necessary wi th you be fo re you begi na ny ki n d o f My taps lags shared wath ime Publst taps Duplicate taps Dete cti O n q u e ry O r d n d lys i S If fo r SO m e Dily detections of thase taps nter tag Only detections for this study GS UCD ACE SFBay 2012 reason your tags have not been updated Animal Data contact Hydra personnel Continue to Species contact them until the issue is resolved Minimum length Mo mo Masnmum length M Mliios punctulabus Mrcropterus salmordes Minatum weight M Maimam weight H Amawus catus Dias eee ee eee el od Jennifer Scheuerell Date Data jennifer sound data com Stan date Exe 2012 1 l End tate Exe Download Type a lags kt lapgmng aby Recevre Deployants ki lag Detectors Download A Sound Data Management Project Report a problem Use the proper format to download a specific tag or multiple tags Data Downloads Note the complete Tag ID including a E EE E EEEE E EEE EEE EEEE EEEE code space is included You can also To download previous detections see your Download List aa put a space between Tags if you d like Use the options below to specify the d
64. s some data to Mops po that we can improve your epenence If you have already uploaded the Tagging file you will need to go back and individually assign tags that are already in Hydra to that new study JOIN HYDRA LOG OUT ABOUT Nite tee RESEARCHERS CREATE A NEW STUDY Soudy Mame Apps M Gmaik Email from G gt Hydra Hydrophone 2 Onlir 5 Ocean Ecosystem In New Tab JOIN HYDRA LOGOUT ABOUT RESEARCHERS USER GUIDE NEWS Edit Data A69 1206 890 GS UCDavis Heublein 2004 04 18 Acipenser medirostris Tagging date Species Animal weight Animal length 139 5 Animal length fork 127 4 Depth Gender Capture method Unknown FUNDERS USER GUIDE NEWS amp EVENTS A69 1206 890 A69 1206 891 A69 1206 892 A59 1206 893 A59 1206 8394 A69 1206 895 A59 1206 896 A69 1206 897 A69 1206 898 A69 1206 899 A59 1206 903 A69 1206 300 A69 1206 901 Tag Code Tagging Date April 18 2004 April 19 2004 April 20 2004 April 21 2004 April 24 2004 April 27 2004 April 28 2004 May 8 2004 May 15 2004 May 16 2004 May 17 2004 May 17 2004 May 17 2004 Species Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris Acipenser medirostris UC Davis Bioteleme
65. s then downloaded is correct and easy to use data given the existing framework capabilities of Hydra Perhaps you re a new user of Hydra or Vemco acoustic telemetry equipment Perhaps you ve already been using Hydra and uploading your data to Hydra When was the last time you checked if the data you re uploading was in Hydra Have you tried using Hydra in the past but became frustrated Have you looked at the Tag IDs that have been shared with you from that nice researcher in the other watershed over or up the coast Is their stuff in Hydra correctly Is it up to date Maybe you should take another look This user guide is a good place to reference in order to help address these concerns By no means is every potential problem or scenario listed in this user guide however by following it the user should be able to educate themselves on proper data collection storage transformation and uploading and downloading this data using Hydra as a management and collaborative tool to aid in investigations of aquatic organisms movements This guide was written from the perspective of a Microsoft Windows end user If non Windows OSes are being employed by a researcher adjustments will have to be made as appropriate UC Davis Biotelemetry Laboratory 2 Hydra Frequently Asked Questions and User Guide Table of Contents Note to reader these page numbers may not be precisely accurate for this revision of this document nor may all internal page nu
66. sccssessesseeceecescesseeseeeeeeeeens 26 Importance of including a Researcher or Owner Of a r C IVES cccccccecsecessesssrseeeseeeeeees 26 o Where to get the Researcher name o Importance of working under user profile that matches owner of tag Orphaned detections from incomplete Receiver Deployment fIl S ccecessseeeeeeees 27 FIXING orphaned tag GELCCUONS ri aar a E cera A A AA 28 Tag Detection files Things to consider before uploading Detection file to Hydra ccececesssssseeecessseseeeeseeees 30 Correcting for acoustic receiver s internal clock s time drift sesssssessesereeserrrrerrsesss 31 32 o Make new VUE database for clock time drift o Assign appropriate directory for transformed edited files Editing and importing time drift transformed files to new VUE database 06 33 34 Exporting transformed detection files from VUE ccccsccesesseecessseceecsssseeesceaeeesssseeeees 35 36 Uploading a DETECTION TIlE WNIM AY Gla viccetaccscacvasctcaransiweateetacsia A 37 o Accepted headers and file formats o DoNOT re upload duplicate detection data Uploading Detection and Deployment files together in Hydra eceseseecessteeeeeeeees 38 39 Email confirmation of successful data UPlOAS ccccscessseccecescssseecessseseeeescesseeaeecesesaeeceees 40 3 UC Davis Biotelemetry Laboratory Hydra Frequently Asked Questions and User Guide Getting Started Sign up for a Hydra a
67. tedtags1 xls is now complete Circles The results of the import were 2012 65 UCD ACE SFbay_ommittedtags1 xls Sheet1 processed successfully Tagging File 4 rows rejected Sean Ha AA If processing was successful your data can now be viewed at the Hydra site depending on the sharing mo settings of the data You can reply to this email if you have encountered any unexpected errors during the import process Thank you for using Hydra A word of caution for users that are uploading Tags and Tagging files Once a tag is assigned to a specific researcher only that researcher s account can make corrections to a Tags and Tagging file If for example was working under my own user account but uploaded a Tag that had my supervisor s name A Peter Klimley under the Researcher column could not make corrections to that tag unless was logged into Hydra under A Peter Klimley s user account It is therefore good practice to only upload data to Hydra via the user account which ultimately you want the tag assigned This could be particularly relevant if a research lab has seasonal workers or students working on a project who might not be participating for the entire duration of a study 7 UC Davis Biotelemetry Laboratory 8 Hydra Frequently Asked Questions and User Guide Downloading Tags and Tagging records After making any corrections or before starting an analysis it is a good Idea to download your tag
68. terus salmoides Ameiurus catus i NDanaoarhimahua Tabauataanha Minimum weight No minimum Maximum weight No minimun Download Type Tags and Tagging is Date Data toggled Start date Example 2012 12 01 End date Example 2012 12 31 Download your data Download Type Tags amp Tagging Lh Receiver Deployments ri Tag Detections Download A Sound Data Management Project Report a problem UC Davis Biotelemetry Laboratory 10 Hydra Frequently Asked Questions and User Guide I ve noticed that have detections for a fish that is prior to my tagging date Is there a duplicate tag somewhere 1 Itis also a good idea to check if you have any duplicate tags or if there are any duplicate tags shared with you would recommend doing this before even looking to see if you have detections 2 By opting to download all duplicate tags the results will be include tags owned by you or that are shared with you that have a duplicate record in the database along with limited metadata corresponding with the other tagged fish with that same tag ID a If you are the owner of both duplicate tags Hydra will show you both records rows 15 16 in below screenshot b If you just see one record of a given tag and one species then another researcher has that same duplicate tag but you do not have access to have it shared with you thus you don t see the other duplicate tag and its associated metadata row 12 in below screenshot
69. try Laboratory Hydra Frequently Asked Questions and User Guide As this process can be tedious and as mentioned earlier in this guide recommend including a study name that makes sense to you before you upload the initial tags and tagging file to Hydra What if have a large quantity of tags to make corrections to If you want to edit a field or add data to a tag that was not previously included in a Tags and Tagging upload you must enter the Tag_ID Code_Space and Tagging Date exactly as it was first entered and then add whatever fields you want to update to that tag record Researcher Weight Animal_ Length Total Animal_ Length Fork etc and upload the data file again The new data will overwrite the previous record However if the Tagging Date is altered in this upload then the old record will remain in Hydra and you will now also have a new record with much of the same data You will get an email when your Tags and Tagging file is complete It will be sent to the email address associated with your Hydra account j B nn 7 wegkcom T r 7 i El Google ram mail i EI o E thaws ta inben hians 3 COMPOSE UNC MBA UNC Top ranked UNC Kenan Flagler offers an MBA online to fit your lifestyle Inbox 245 Your upload at Hydra is complete 2012_GS_UCD_ACE SFbay_ommitted Starred tags1 xs o Important hydra sound data com Mar 18 m sent Mail to me Drafts Your upload into Hydra of file 2012_GS_UCD_ACE SFbay_ommit
70. use A Peter Klimley instead of just Pete Klimley It is a good idea to copy and paste the exact name into your Researcher column in order to avoid misspellings which could assign your Receiver Deployment file to a non existent researcher Preparing Deployment Files Continued When the UC Davis Biotelemetry Lab downloads our receivers we have our laptops set to Pacific Standard Time PST and never PDT daylight savings Hydra assumes that times for a Receiver Deployment file must be in Greenwich Mean Time GMT aka Coordinated Universal Time UTC To convert a date from PST not PDT to UTC you can implement PST cell 8 24 as a formula in a new column labeled as appropriate for Hydra e g End_Date Verify that the original date time column is not improperly set to the Hydra accepted label In the following screenshot the header columns highlighted in red are what will end up being input into Hydra FA H gt Bookl Microsoft File Home Insert Page Layout Formulas Data Review View Acrobat Conve rting PST to UTC time for your d amp Cut SS ita Copy Rita acceptable Hydra End Date E U S SUM xX v fe H2 8 24 A B c L E F G H ee 7 J 1 Location Receiver Type Serial Number Latitude Longitude Start date PST Start_Date End date PST End Date Researcher 2 SR_Freeport VR2W 121348 38 45543 121 50229 7 2 2013 3 35 00 PM 7 2 2013 23 35 00 10 17 2013 3 20 52PM __ H2 8 24 a Peter klimley 3 4 A L For
71. v UCD BOR 2011 GS UCD ACE SFBay 2010 GS UCD ACE SFBay 2011 GS UCD ACE SFBay 2012 Number of Tags Shared With Oo O oOo 2 oe 2 O 200 300 300 300 300 99 10 30 2 researcher Jamilynn Poletto Ryan Battleson 4 researcher Ryan Battleson Ryan Battleson Ryan Battleson Jamilynn Poletto 1 researcher Jamilynn Poletto 2 researcher Jamilynn Poletto Ryan Battleson 1 researcher Ryan Battleson 7 researcher Ryan Battleson Myfanwy Johnston Ryan Battleson Jamilynn Poletto Ryan Battleson Christopher Schmidt Ryan Battleson 6 researcher Ryan Battleson Ryan Battleson Josh Israel Michael Thomas Ryan Battleson Jamilynn Poletto 2 researcher Eric Chapman Ryan Battleson 2 researcher Eric Chapman Ryan Battleson 2 researcher Eric Chapman Ryan Battleson 3 researcher Ryan Battleson Eric Chapman Gabriel Singer 2 researcher Eric Chapman Ryan Battleson 0 researcher 7 researcher Ryan Battleson Eric Chapman Robert Chase Robert Chase Josh Israel John Payne Phillip Dionne 7 researcher Ryan Battleson Eric Chapman Robert Chase Robert Chase Josh Israel John Payne Phillip Dionne 4 researcher Ryan Battleson Eric Chapman John Payne Phillip Dionne 4 researcher Ryan Battleson Eric Chapman John Payne Phillip Dionne 5 researcher Ryan Battleson Eric Chapman Arnold Ammann John Payne Phillip Dionne Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Delete Edit Edit Edit Edit Edit UC Davis Biotelemetry Laboratory 13 Hydr

Download Pdf Manuals

Related Search

Related Contents

MANUAL DO USUÁRIO DE REDE  HP 15 15-d054ee  取付説明書  MANUAL DE UTILIZAÇÃO SISTEMA DE CADASTRO  Samsung 275T+ Uživatelská přiručka  Chauvet Scuba Diving Equipment 2 User's Manual  Haier 1.1 Cu. Ft. 1000W  

Copyright © All rights reserved.

• https://telegra.ph/Calculat-Wire-Area-From-Voltage-Drop-5e17900c-11-16
• https://telegra.ph/Calculate-Wire-Resistor-from-Voltage-Drop-bfecea9c-11-16
• https://telegra.ph/Concrete-Volume-Calculator-for-Steps-81a06ad9-11-13
• https://telegra.ph/Calculate-Current-from-Voltage-Drop-849f7b31-11-18
• https://telegra.ph/Calculate-Wire-Resistor-from-Voltage-Drop-5fe485a1-11-18
• https://telegra.ph/AC-Single-phase-Voltage-Drop-Calculator-1cfa136c-11-18
• https://telegra.ph/Calculate-Length-from-Voltage-Drop-bff15e9a-11-18
• https://telegra.ph/Calculate-Wire-Resistor-from-Voltage-Drop-f600a4e3-11-18
• https://telegra.ph/Calculate-Wire-Resistor-from-Voltage-Drop-140bd69a-11-18
• https://telegra.ph/AC-Single-phase-Voltage-Drop-Calculator-1e3d99e8-11-18