[{"schema":{"name":"mdJson","version":"2.8.1"},"metadata":{"metadataInfo":{"metadataIdentifier":{"identifier":"fa75a936-fc2a-4d2a-b85d-b6cf381e114f","namespace":"urn:uuid"},"metadataStatus":"completed","defaultMetadataLocale":{"language":"eng","characterSet":"UTF-8","country":"USA"},"metadataContact":[{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"pointOfContact"},{"party":[{"contactId":"592430aa-88d4-4df1-b940-12bfc14fa7ae"}],"role":"author"},{"party":[{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612"}],"role":"publisher"}],"metadataDate":[{"date":"2024-07-25T00:00:00.000Z","dateType":"creation"},{"date":"2024-07-25T00:00:00.000Z","dateType":"lastUpdate"}]},"resourceInfo":{"resourceType":[{"type":"tabularDataset","name":"Boquet_River_Telemetry20200804.accdb"}],"status":["completed"],"citation":{"title":"Telemetry database","responsibleParty":[{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"pointOfContact"},{"party":[{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612"}],"role":"publisher"}],"date":[{"date":"2020-08-04T04:00:00.000Z","dateType":"creation"}],"onlineResource":[{"uri":"https://ecos.fws.gov/ServCat/Reference/Profile/168003","function":"fileAccess"}]},"abstract":"This database houses all data, with the exception of radio telemetry receiver downloads, collected in 2020 relating to a study on adult landlocked Atlantic salmon passage efficiency at the Willsboro cascades in the Boquet River, NY. This relational database contains information on salmon trapping, salmon radio telemetry tagging, radio telemetry stationary receiver site deployment, mobile tracking, and equipment used for the project. \n","defaultResourceLocale":{"language":"eng","characterSet":"UTF-8","country":"USA"},"extent":[{"description":"Boquet River, NY","geographicExtent":[{"boundingBox":{"northLatitude":44.37933052388131,"southLatitude":44.21420205653367,"eastLongitude":-73.34815979003906,"westLongitude":-73.56239318847655},"geographicElement":[{"type":"Feature","id":"4da5c6d7-1cf8-47f5-b39a-c7b4c45b4894","geometry":{"type":"Polygon","coordinates":[[[-73.56239318847655,44.21420205653367],[-73.56239318847655,44.37933052388131],[-73.34815979003906,44.37933052388131],[-73.34815979003906,44.21420205653367],[-73.56239318847655,44.21420205653367]]]},"properties":{"name":"New Polygon Feature"}}],"description":"Boquet River, NY"}]}],"pointOfContact":[{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"pointOfContact"},{"party":[{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612"}],"role":"administrator"},{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"custodian"},{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"originator"},{"party":[{"contactId":"8aa6cd83-fd34-4ff2-ae4e-91745af70096"}],"role":"owner"}],"constraint":[{"useLimitation":["Although these data have been processed successfully on a computer system at the U.S. Fish and Wildlife Service, no warranty expressed or implied is made regarding the display or utility of the data for other purposes, nor on all computer systems, nor shall the act of distribution constitute any such warranty."],"legal":{"accessConstraint":["licenceUnrestricted"],"useConstraint":["unrestricted"],"otherConstraint":["https://creativecommons.org/publicdomain/zero/1.0/"]},"security":{"classification":"unclassified"},"type":"use"}],"keyword":[{"keyword":[{"keyword":"landlocked Atlantic salmon"},{"keyword":"Boquet River"},{"keyword":"Anthropogenic barrier"},{"keyword":"salmon migration"},{"keyword":"fish passage"},{"keyword":"radio telemtry"},{"keyword":"database"}],"keywordType":"theme","thesaurus":{"identifier":[{"identifier":"custom"}],"title":"Keywords from Data Management Plan"},"fullPath":true},{"keyword":[{"identifier":"02d92216-70c6-437c-8c15-2b76f2132921","keyword":"Science Keywords > EARTH SCIENCE SERVICES > DATA MANAGEMENT/DATA HANDLING","path":["Science Keywords","EARTH SCIENCE SERVICES","DATA MANAGEMENT/DATA HANDLING"]}],"keywordType":"theme","thesaurus":{"date":[{"date":"2018-12-12","dateType":"revision"}],"description":"GCMD Science Keywords Example Description","title":"Global Change Master Directory (GCMD) Science Keywords","edition":"Version 8.6","onlineResource":[{"uri":"https://earthdata.nasa.gov/gcmd-forum"}],"identifier":[{"identifier":"1eb0ea0a-312c-4d74-8d42-6f1ad758f999"}]},"fullPath":true}],"timePeriod":{"startDateTime":"2020-08-04T04:00:00.000Z","description":"creation date"},"resourceMaintenance":[{"frequency":"notPlanned"}],"taxonomy":[{"taxonomicClassification":[{"taxonomicSystemId":"202423","taxonomicLevel":"Kingdom","taxonomicName":"Animalia","subClassification":[{"taxonomicSystemId":"914154","taxonomicLevel":"Subkingdom","taxonomicName":"Bilateria","subClassification":[{"taxonomicSystemId":"914156","taxonomicLevel":"Infrakingdom","taxonomicName":"Deuterostomia","subClassification":[{"taxonomicSystemId":"158852","taxonomicLevel":"Phylum","taxonomicName":"Chordata","subClassification":[{"taxonomicSystemId":"331030","taxonomicLevel":"Subphylum","taxonomicName":"Vertebrata","subClassification":[{"taxonomicSystemId":"914179","taxonomicLevel":"Infraphylum","taxonomicName":"Gnathostomata","subClassification":[{"taxonomicSystemId":"161061","taxonomicLevel":"Superclass","taxonomicName":"Actinopterygii","subClassification":[{"taxonomicSystemId":"161105","taxonomicLevel":"Class","taxonomicName":"Teleostei","subClassification":[{"taxonomicSystemId":"161928","taxonomicLevel":"Superorder","taxonomicName":"Protacanthopterygii","subClassification":[{"taxonomicSystemId":"161929","taxonomicLevel":"Order","taxonomicName":"Salmoniformes","subClassification":[{"taxonomicSystemId":"161931","taxonomicLevel":"Family","taxonomicName":"Salmonidae","subClassification":[{"taxonomicSystemId":"623286","taxonomicLevel":"Subfamily","taxonomicName":"Salmoninae","subClassification":[{"taxonomicSystemId":"161994","taxonomicLevel":"Genus","taxonomicName":"Salmo","subClassification":[{"taxonomicSystemId":"161996","taxonomicLevel":"Species","taxonomicName":"Salmo salar","commonName":["Atlantic salmon","saumon atlantique"],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"isITIS":true}],"taxonomicSystem":[{"citation":{"title":"Integrated Taxonomic Information System (ITIS)","date":[{"date":"2024-07-25","dateType":"transmitted","description":"Taxa imported from ITIS"},{"date":"2024-07-25","dateType":"transmitted","description":"Taxa imported from ITIS"},{"date":"2024-07-25","dateType":"transmitted","description":"Taxa imported from ITIS"}],"presentationForm":["webService","webSite"],"otherCitationDetails":["Retrieved from the Integrated Taxonomic Information System on-line database, https://www.itis.gov."],"onlineResource":[{"uri":"https://www.itis.gov","name":"ITIS website","protocol":"HTTPS","function":"information","description":"ITIS contains taxonomic information on plants, animals, fungi, and microbes of North America and the world."}],"graphic":[{"fileName":"itis_logo.jpg","fileType":"JPEG","fileUri":[{"uri":"https://itis.gov/Static/images/itis_logo.jpg"}]}]}}]}]},"resourceLineage":[{"statement":"Quality assurance: Variables within tables are restricted to domains established in the look up tables. \n\nQuality control: Data are manually reviewed and updated by the data steward."}],"associatedResource":[{"associationType":"parentProject","resourceCitation":{"date":[{"date":"2022-12-31T00:00:00.000Z","dateType":"end"},{"date":"2020-08-01T00:00:00.000Z","dateType":"start"}],"title":"Assessing upstream fish passage of adult landlocked Atlantic salmon Salmo salar in the Boquet River, New York following the removal of the Willsboro dam.","responsibleParty":[{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"pointOfContact"},{"party":[{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612"}],"role":"publisher"}],"onlineResource":[{"uri":"https://ecos.fws.gov/ServCat/Reference/Profile/167945","function":"information"}]},"metadataCitation":{"title":"Metadata for Assessing upstream fish passage of adult landlocked Atlantic salmon Salmo salar in the Boquet River, New York following the removal of the Willsboro dam.","responsibleParty":[{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"pointOfContact"},{"party":[{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5"}],"role":"author"},{"party":[{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612"}],"role":"publisher"}],"date":[{"date":"2024-07-25T00:00:00.000Z","dateType":"creation"},{"date":"2024-07-25T00:00:00.000Z","dateType":"lastUpdate"}],"identifier":[{"identifier":"4face1de-cbb2-4340-8ac8-f44687f72820","namespace":"urn:uuid"}]},"resourceType":[{"name":"Landlocked Atlantic salmon passage efficiency assessment at the Willsboro Cascades","type":"project"}]}],"resourceDistribution":[{"distributor":[{"contact":{"role":"distributor","party":[{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612"}]},"transferOption":[{"onlineOption":[{"uri":"https://ecos.fws.gov/ServCat/Reference/Profile/168003","function":"fileAccess"}],"transferSize":4.272}]}],"description":"USFWS ServCat"}]},"metadataRepository":[],"mdDictionary":["e1b2ea65-16d7-4670-9e9b-9acf2d960865"],"dataDictionary":[{"citation":{"title":"Telemetry database","date":[{"date":"2024-07-25T17:21:51.972Z","dateType":"creation"}]},"description":"Data dictionaries for tabular data contained with Microsoft Access relational database. Data housed within the database relate to equipment, catch, processing, and status of landlocked Atlantic salmon and radio telemetry used to monitor the upstream migration and fish passage over the Willsboro cascades located in Boquet River, NY in 2020. ","subject":["tabularDataset"],"responsibleParty":{"party":[{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612"}],"role":"administrator"},"entity":[{"entityId":"1cae84ec-3570-463a-b982-b552868c90ef","attribute":[{"allowNull":false,"codeName":"Trip_ID","dataType":"character varying","definition":"Unique ID of visit to Site (e.g. yyyy-mm-dd_001)"},{"allowNull":false,"codeName":"Site_ID","dataType":"character varying","definition":"Unique ID for where fish are sampled. Tributary_Reach_Site (e.g. BR_05_001)"},{"allowNull":false,"codeName":"Deploy_Date","dataType":"datetime","definition":"Time that gear starts fishing (yyyy-mm-dd hh:mm)"},{"allowNull":false,"codeName":"Retrieval_Date","dataType":"datetime","definition":"Time that gear ends fishing (yyyy-mm-dd hh:mm)"},{"allowNull":false,"codeName":"Crew","dataType":"character varying","definition":"All members that are fishing gear (e.g. J. Withers, W. Ardren)"},{"allowNull":false,"alias":["LCFWCO_HN","LCFWCO_HN_NYDEC_SN"],"codeName":"Gear_ID","dataType":"character varying","definition":"Owner and gear type (LCFWCO_HN_NYDEC_SN or LCFWCO_HN)"},{"allowNull":true,"codeName":"RiverFlow","dataType":"numeric","definition":"river flow in cubic feet per second"},{"allowNull":true,"codeName":"WaterTemp","dataType":"numeric","definition":"Measured water temperature at time of net deployment"},{"allowNull":false,"codeName":"Weather conditions","dataType":"character varying","definition":"current weather conditions during net deployment (Overcast, partly sunny, raining, snowing, etc.)"},{"allowNull":true,"codeName":"Est_WindSpeed","dataType":"integer","definition":"Estimated wind speed (km/h)","units":"kilometers per hour","unitsResolution":1},{"allowNull":false,"codeName":"Turbidity","dataType":"numeric","definition":"Measured with secchi disk or estimated (m)","units":"meters","unitsResolution":0.5},{"allowNull":false,"codeName":"WaterDepth","dataType":"numeric","definition":"Willsboro water height (m)","units":"meter","unitsResolution":0.5},{"allowNull":false,"codeName":"Comments","dataType":"character varying","definition":"any comments about the setting or retrieval of the net"}],"codeName":"tbl_Trip","definition":"data dictionary for tabular dataset containing information on hoopnet deployment and retrieval within the boquet river, ny in 2020"},{"entityId":"e713013c-37ec-4005-85bd-dc9f8ae608d9","attribute":[{"allowNull":false,"codeName":"Salmon_ID","dataType":"character varying","definition":"Unique ID of captured landlocked salmon, tributary, id (e.g. LLS_BR_001)"},{"allowNull":false,"codeName":"Trip_ID","dataType":"character varying","definition":"Unique ID of visit to sampling site (e.g. yyyy-mm-dd_001)"},{"allowNull":true,"codeName":"TL","dataType":"numeric","definition":"Total length (cm)","units":"centimeters","unitsResolution":0.1},{"allowNull":true,"codeName":"FL","dataType":"numeric","definition":"Total length (cm)","units":"centimeters","unitsResolution":0.1},{"allowNull":false,"codeName":"Sex","dataType":"character varying","definition":"Male, Female, Unknown (M, F, U, H)"},{"allowNull":true,"codeName":"Weight","dataType":"numeric","definition":"Total weight (kilograms)","units":"kilograms","unitsResolution":0.1},{"allowNull":true,"codeName":"Lamprey wounds","dataType":"character varying","definition":"Number and position of lamprey wounds"},{"allowNull":true,"codeName":"Fin_Clip_Observed","dataType":"character varying","definition":"Presence of fin clip (left ventral = LV, left pectoral = LP, adipose =AD)"},{"allowNull":true,"codeName":"Floy_Applied","dataType":"character varying","definition":"Floy tag color and ID (Pink_001)"},{"allowNull":true,"codeName":"Floy_Retained","dataType":"character varying","definition":"Floy tag color and ID (Pink_001)"},{"allowNull":true,"codeName":"Genetic_ID","dataType":"character varying","definition":"unique identifier to label tissue sample taken for genetic purposes (yyyy_001)"},{"allowNull":true,"codeName":"AgeScale_ID","dataType":"character varying","definition":"unique identifier to calcified structure taken for age assessment (yyyy_001)"},{"allowNull":true,"codeName":"Transmitter_Applied","dataType":"character varying","definition":"Unique ID for transmitter surgically implanted into a salmon. Use year, Frequency, and Code to create unique ID (e.g. yyyy_164.480 101)"},{"allowNull":true,"codeName":"Transmitter_Retained","dataType":"character varying","definition":"Unique ID for transmitter detected within a salmon. Use year, Frequency, and Code to create unique ID (e.g. yyyy_164.480 101)"},{"allowNull":false,"codeName":"Release_Time","dataType":"datetime","definition":"date and time when a salmon was released (yyyy-mm-dd hh:mm)"},{"allowNull":false,"codeName":"Site_ID","dataType":"character varying","definition":"Unique ID for where fish are sampled. Tributary_Reach_Site (e.g. BR_05_001)"},{"allowNull":true,"codeName":"Sedative","dataType":"character varying","definition":"Sedative used during surgery. (e.g., Aqui-S, MS-222, electronarcosis, none)"},{"allowNull":true,"codeName":"Concentration_Bath","dataType":"integer","definition":"Concentration of sedative bath (mg/L)","units":"milligrams per liter","unitsResolution":0.1},{"allowNull":true,"codeName":"Concentration_FlowThrough","dataType":"integer","definition":"mg/L (ppm)"},{"allowNull":true,"codeName":"Start_Sed","dataType":"time","definition":"Time when fish is first exposed to sedative"},{"allowNull":true,"codeName":"Sed_Duration","dataType":"time","definition":"Total time on sedative (hh:mm:ss)"},{"allowNull":true,"codeName":"Pre_OMPM","dataType":"integer","definition":"Number of times fish gilled per minute prior to surgery"},{"allowNull":true,"codeName":"Post_OMPM","dataType":"integer","definition":"Number of times fish gilled per minute prior to release"},{"allowNull":true,"codeName":"Start_Surg","dataType":"time","definition":"Time when surgery started"},{"allowNull":true,"codeName":"Surg_Duration","dataType":"time","definition":"Total surgery time (hh:mm:ss)"},{"allowNull":true,"codeName":"NumberOfSutures","dataType":"integer","definition":"Count of sutures"},{"allowNull":true,"codeName":"Comments","dataType":"character varying","definition":"Any comments about the fish, sea lamprey wounds, etc."},{"allowNull":false,"codeName":"Scribe","dataType":"character varying","definition":"First Initial and Last name of individual taking notes"},{"allowNull":false,"codeName":"Processors","dataType":"character varying","definition":"First Initial and Last name of individuals processing the salmon"},{"allowNull":true,"codeName":"Fatmeter_center_1","dataType":"numeric","definition":"Measurement of fat from center using fat meter"},{"allowNull":true,"codeName":"Fatmeter_center_2","dataType":"numeric","definition":"Measurement of fat from center using fat meter"},{"allowNull":false,"codeName":"Fatmeter_anterior_1","dataType":"numeric","definition":"Measurement of fat from anterior using fat meter"},{"allowNull":true,"codeName":"Fatmeter_anterior_2","dataType":"numeric","definition":"Measurement of fat from anterior using fat meter"},{"allowNull":true,"codeName":"Fatmeter_posterior_1","dataType":"numeric","definition":"Measurement of fat from posterior using fat meter"},{"allowNull":true,"codeName":"Fatmeter_posterior_2","dataType":"numeric","definition":"Measurement of fat from posterior using fat meter"},{"allowNull":true,"codeName":"Tag_Recovered_Date","dataType":"datetime","definition":"Date and time a radio transmitter was recovered (YYYY-MM-DD hh:mm)"},{"allowNull":true,"codeName":"Tag_Recovery_Comment","dataType":"character varying","definition":"Any detail details around the recovery of a transmitter"}],"codeName":"tbl_Salmon","definition":"data dictionary for tabular dataset containing information about measurements and radio transmitters surgically implanted within Atlantic salmon captured within the Boquet River, NY."},{"entityId":"ad4ea088-f3d3-4322-ab1e-2f71ffb39339","attribute":[{"allowNull":false,"codeName":"RecDownload_ID","dataType":"integer","definition":"Unique identifier for each download"},{"allowNull":false,"codeName":"Downloader","dataType":"character varying","definition":"Name of person who downloads (J. Withers)"},{"allowNull":false,"codeName":"Rec_Site_ID","dataType":"character varying","domainId":"ef44e07c-d2c5-46bc-95fb-ecc773a1b406","definition":"station where receiver was downloaded (Boquet River and then station number; e.g. BR_01)"},{"allowNull":false,"codeName":"OperationStatus","dataType":"character varying","definition":"Are the receiver's \"decoding\" and \"sampling\" lights blinking normally, quickly, are either of them solid? Is the low voltage red light on?"},{"allowNull":false,"codeName":"Rec_Downloaded","dataType":"boolean","definition":"whether or not the receiver was downloaded"},{"allowNull":false,"codeName":"File_BackedUp","dataType":"boolean","definition":"whether or not the downloaded file was backed up on a flashdrive"},{"allowNull":false,"codeName":"Rec_Erased","dataType":"boolean","definition":"whether or not the receiver's data was erased after it was downloaded"},{"allowNull":false,"codeName":"LocalTime","dataType":"datetime","definition":"Local date and time when receiver was downloaded"},{"allowNull":false,"codeName":"Rec_Time","dataType":"datetime","definition":"The time on the receiver clock when the receiver was downloaded"},{"allowNull":false,"codeName":"Rec_ClockSynced","dataType":"boolean","definition":"The difference between local time and receiver time when the receiver was downloaded"},{"allowNull":false,"codeName":"MorningStar_Downloaded","dataType":"boolean","definition":"whether or not the morningstar charger data was downloaded"},{"allowNull":false,"codeName":"MaxVolt","dataType":"numeric","definition":"maximum battery voltage observed on the morning start charger since the last download"},{"allowNull":false,"codeName":"MinVolt","dataType":"numeric","definition":"minimum battery voltage observed on the morning start charger since the last download"},{"allowNull":false,"codeName":"Present_Volt","dataType":"numeric","definition":"Current voltage displayed on the morningstar charger"},{"allowNull":false,"codeName":"Equipment_ChangeOut","dataType":"boolean","definition":"Whether or not equipment was changed out"},{"allowNull":true,"codeName":"Comments","dataType":"character varying","definition":"Any comments about the station or download"}],"codeName":"tbl_ReceiverDownload","definition":"data dictionary for tabular dataset containing information about radio telemetry Sigma Eight orion receiver downloads in 2020 within the Boquet River, NY."},{"entityId":"8f7ad4ca-faa8-4312-9591-e936f73ee8a8","attribute":[{"allowNull":false,"codeName":"Receiver_trip_ID","dataType":"integer","definition":"Unique identifier for each receiver deployment"},{"allowNull":false,"codeName":"Deploy_Date","dataType":"date","definition":"Date when the receiver was deployed within the field"},{"allowNull":true,"codeName":"Retrieval_Date","dataType":"date","definition":"Date when the receiver was removed from the field"},{"allowNull":false,"codeName":"Rec_Site_ID","dataType":"character varying","definition":"Location where receiver was deployed within the field"},{"allowNull":false,"codeName":"Receiver_ID","dataType":"character varying","definition":"Unique identifier of the receiver"},{"allowNull":false,"codeName":"Battery_ID","dataType":"character varying","definition":"Unique identified of the battery used to power the receiver"},{"allowNull":true,"codeName":"Beacon_ID","dataType":"character varying","definition":"Unique identified of the beacon deployed near the receiver"},{"allowNull":true,"codeName":"ChargeController_ID","dataType":"character varying","definition":"Unique identified of the charge controller deployed with the receiver"},{"allowNull":true,"codeName":"Panel_ID","dataType":"character varying","definition":"Unique identified of the solar panel deployed with the receiver"},{"allowNull":true,"codeName":"Panel_ID_2","dataType":"character varying","definition":"Unique identified of the second solar panel deployed with the receiver"},{"allowNull":false,"codeName":"Comments","dataType":"character varying","definition":"any comments about the deployment of the receiver or associated equipment"},{"allowNull":false,"codeName":"Crew","dataType":"character varying","definition":"Individuals who deployed equipment"},{"allowNull":false,"codeName":"Rec_Noise_Floor","dataType":"integer","definition":"Setting of receiver noise floor"},{"allowNull":true,"codeName":"Modem_ID","dataType":"character varying","definition":"Unique identifier of modem deployed at receiver site"}],"codeName":"tbl_ReceiverDeployments","definition":"data dictionary for tabular data containing information on when and where radio telemetry Sigma Eight Orion receivers were deployed within the field and what other equipment they were deployed with. "},{"entityId":"168af453-45fb-44db-b0ed-bdb97577ba32","attribute":[{"allowNull":false,"codeName":"TrackID","dataType":"integer","definition":"Autonumber to match with mobiletrack table"},{"allowNull":false,"codeName":"TagID","dataType":"character varying","definition":"Frequency and code of radio transmitter detected (eg. 164.480 122)"},{"allowNull":false,"codeName":"Power","dataType":"integer","definition":"Signal strength of radio telemetry transmitter detection on the mobile unit when taking the waypoint"},{"allowNull":false,"codeName":"Wpt","dataType":"character varying","definition":"Name of waypoint on handheld GPS when logging a detection (River YYMMDD-01; e.g., BR-YYMMDD-01)"},{"allowNull":false,"codeName":"Time","dataType":"time","definition":"Time when waypoint was taken"},{"allowNull":false,"codeName":"GPS_Lat","dataType":"numeric","definition":"Latitude where waypoint was taken"},{"allowNull":false,"codeName":"GPS_Long","dataType":"numeric","definition":"Longitude where waypoint was taken"},{"allowNull":false,"codeName":"Antenna","dataType":"character varying","definition":"Type of antenna used when taking waypoint"},{"allowNull":false,"codeName":"Comments","dataType":"character varying","definition":"Any comments about the detection"},{"allowNull":true,"codeName":"Recovered","dataType":"boolean","definition":"Whether or not the transmitter was found and recovered"}],"codeName":"tbl_MobileWaypoints","definition":"data dictionary for tabular dataset containing locations, times, and signal strength of radio telemetry transmitters detected within the Boquet River using mobile tracking in 2020."},{"entityId":"e9d53137-0e9a-4266-8d94-7205261a498b","attribute":[{"allowNull":false,"codeName":"TrackID","dataType":"integer","definition":"Unique identifier of tracks"},{"allowNull":false,"codeName":"TrackName","dataType":"character varying","definition":"Unique name of gps track created during mobile tracking. System-YYYYMMDD-track number (ex. BR-20201209-01)"},{"allowNull":false,"codeName":"TrackingDate","dataType":"date","definition":"date when mobile track was created"},{"allowNull":false,"codeName":"StartTime","dataType":"time","definition":"time when mobile track started"},{"allowNull":false,"codeName":"EndTime","dataType":"time","definition":"time when mobile track ended"},{"allowNull":false,"codeName":"StartLat","dataType":"numeric","definition":"Latitude where mobile track started","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001},{"allowNull":false,"codeName":"StartLong","dataType":"numeric","definition":"Longitude where mobile track started","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001},{"allowNull":false,"codeName":"ModeOfTransportation","dataType":"character varying","definition":"whether the tracking as done on foot or in a vehicle"},{"allowNull":false,"codeName":"Antenna","dataType":"character varying","definition":"type of antenna used (direction yagi or whip antenna_"},{"allowNull":false,"codeName":"MobileUnit","dataType":"character varying","definition":"the radio telemetry receiver unit used"},{"allowNull":false,"codeName":"EndLat","dataType":"numeric","definition":"Latitude where mobile track ended","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001},{"allowNull":false,"codeName":"EndLong","dataType":"numeric","definition":"Longitude where mobile track started","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001},{"allowNull":true,"codeName":"Crew","dataType":"character varying","definition":"individuals that did the mobile tracking (first initial. last name)"}],"codeName":"tbl_MobileTrack","definition":"data dictionary for tabular data detailing radio telemetry mobile tracking in the Boquet River in 2020 searching for tagged landlocked Atlantic salmon"},{"entityId":"9398ae91-d878-4425-8ff1-86b46cba2a3b","attribute":[{"allowNull":false,"codeName":"ByCatch_ID","dataType":"character varying","definition":"Unique ID of fish captured By, tributary, id (e.g. BY_BR_001)"},{"allowNull":false,"codeName":"Trip_ID","dataType":"character varying","definition":"Unique ID of visit to Site (e.g. yyyy-mm-dd_001)"},{"allowNull":false,"codeName":"Species","dataType":"character varying","definition":"Common name of fish"},{"allowNull":false,"codeName":"Count","dataType":"integer","definition":"Number of a species captured"}],"codeName":"tbl_Bycatch","definition":"data dictionary for tabular dataset containing information about bycatch caught during hoopnet sampling in the Boquet River, NY for landlocked Atlantic salmon in the fall of 2020"},{"entityId":"6c3b08bd-e562-4853-8fd9-60fc94fcffeb","attribute":[{"allowNull":false,"codeName":"Salmon_ID","dataType":"character varying","definition":"Unique ID of Salmon captured landlocked salmon, tributary, id (e.g. LLS_BR_001)"},{"allowNull":false,"codeName":"AngledTime","dataType":"datetime","definition":"date and time when salmon was captured by angler"},{"allowNull":false,"codeName":"LocationCaught","dataType":"character varying","definition":"General location where angler caught salmon"},{"allowNull":false,"codeName":"Kept","dataType":"boolean","definition":"Whether or not the angler harvested the salmon or released it"},{"allowNull":false,"codeName":"Floy_Retained","dataType":"character varying","definition":"The color and number of the floy tag attached to the salmon that was being reported (if applicable)"},{"allowNull":false,"codeName":"Anntenna","dataType":"boolean","definition":"Whether or not an antenna was visible to the angler"}],"codeName":"tbl_Angling","definition":"data dictionary for tabular data containing information on whether landlocked Atlantic salmon that were caught and processed by the US Fish and Wildlife Service in the fall of 2020 in the Boquet, River were recaptured and reported by anglers. "},{"entityId":"e46258a4-388b-4387-8a22-24a20279b2c2","attribute":[{"allowNull":false,"codeName":"Transmitter_ID","dataType":"character varying","definition":"Unique ID for transmitter within a year. Use year, Frequency, and Code to create unique ID (e.g. yyyy_164.480 101)"},{"allowNull":false,"codeName":"Serial_number","dataType":"character varying","definition":"Serial number of transmitter"},{"allowNull":false,"codeName":"DateOfPurchase","dataType":"date","definition":"date when transmitter was purchased"},{"allowNull":false,"codeName":"Make","dataType":"character varying","definition":"Make of transmitter (Lotek, sigma-eight)"},{"allowNull":false,"codeName":"Model","dataType":"character varying","definition":"Size of tag"},{"allowNull":false,"codeName":"Type","dataType":"character varying","definition":"Acoustic or radio"},{"allowNull":false,"codeName":"Freq","dataType":"numeric","definition":"Frequency transmitter is programmed to"},{"allowNull":false,"codeName":"Code","dataType":"integer","definition":"Code transmitter is programmed to"},{"allowNull":false,"codeName":"Nominal_Delay","dataType":"integer","definition":"Pulse rate"},{"allowNull":false,"codeName":"Min_Delay","dataType":"integer","definition":"Minimum pulse rate"},{"allowNull":false,"codeName":"Max_Delay","dataType":"integer","definition":"Maximum pulse rate"}],"codeName":"LookUpTbl_Transmitters","definition":"data dictionary for tabular dataset containing information of the radio telemetry transmitters (Sigma Eight) used in the landlocked Atlantic salmon migration study in the Boquet River in 2020."},{"entityId":"53afe2aa-43eb-4a63-9d80-10dae66a2b05","attribute":[{"allowNull":false,"codeName":"Panel_ID","dataType":"character varying","definition":"Unique ID for Solar Panels (Sol_001)"},{"allowNull":false,"codeName":"Serial_number","dataType":"character varying","definition":"Serial number of solar panel"},{"allowNull":false,"codeName":"Make","dataType":"character varying","definition":"Make of solar panel (AltE Store)"},{"allowNull":false,"codeName":"Model","dataType":"character varying","definition":"Model of solar panel"},{"allowNull":false,"codeName":"DateOfPurchase","dataType":"date","definition":"date when the solar panel was purchased"},{"allowNull":false,"codeName":"Watt","dataType":"integer","definition":"Power of solar panels (100 watts)"},{"allowNull":false,"codeName":"MaxVolts","dataType":"integer","definition":"Maximum voltage (e.g. 600)"},{"allowNull":false,"codeName":"VOC","dataType":"numeric","definition":"Volts of open circuit (e.g 44.8)"},{"allowNull":false,"codeName":"Model_Number","dataType":"character varying","definition":"Model number of solar panel"},{"allowNull":false,"codeName":"Owner","dataType":"character varying","definition":"who owns the solar panel"}],"codeName":"LookUpTbl_SolarPanel","definition":"data dictionary for tabular dataset containing information about solar panels owned by the USFWS Lake Champlain FWCO"},{"entityId":"a3ab7878-8e71-4823-84ea-1e18ae84a242","attribute":[{"allowNull":false,"codeName":"Site_ID","dataType":"character varying","definition":"Unique ID for where fish are sampled. Tributary_Reach_Site (e.g. BR_05_001)"},{"allowNull":false,"codeName":"Latitude","dataType":"numeric","definition":"Latitude in Decimal Degrees (DD.DDDDDD)","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001},{"allowNull":false,"codeName":"Longitude","dataType":"numeric","definition":"Longitude in Decimal Degrees (DD.DDDDDD)","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001}],"codeName":"LookUpTbl_Site","definition":"data dictionary for tabular dataset containing the name and coordinates of sampling sites for hoopnetting landlocked atlantic salmon within the Boquet River in 2020."},{"entityId":"9d04764b-c7b9-4f0c-be1a-0415fccfe5c2","attribute":[{"allowNull":false,"codeName":"Receiver_ID","dataType":"character varying","definition":"Unique ID for receiver (eg. Rec_001)"},{"allowNull":false,"codeName":"Serial_number","dataType":"integer","definition":"Serial number of receiver"},{"allowNull":false,"codeName":"DateOfPurchase","dataType":"date","definition":"Date when receiver was purchased"},{"allowNull":false,"codeName":"Make","dataType":"character varying","definition":"Make of receiver (Lotek, Sigma Eight, ATS, Vemco)"},{"allowNull":false,"codeName":"Model","dataType":"character varying","definition":"Model of receiver (Orion, Aries, etc.)"},{"allowNull":false,"codeName":"Type","dataType":"character varying","definition":"Radio or acoustic"},{"allowNull":false,"codeName":"Owner","dataType":"character varying","definition":"What office owns the receivers"},{"allowNull":false,"codeName":"DateTested","dataType":"date","definition":"Date when the receiver was last tested"},{"allowNull":false,"codeName":"Issue","dataType":"boolean","definition":"Whether or not there is an issue with the receiver"},{"allowNull":false,"codeName":"Issue_Details","dataType":"character varying","definition":"details on what the issue is with a receiver if it has one"}],"codeName":"LookUpTbl_Receivers","definition":"data dictionary for tabular dataset containing information on radio telemetry receivers (Sigma Eight Orion) used in the Boquet River, NY 2020"},{"entityId":"aa855fcb-b1fa-4728-88ec-b7b1a6b52645","attribute":[{"allowNull":false,"codeName":"Rec_Site_ID","dataType":"character varying","definition":"unique identifier of the receiver site location"},{"allowNull":false,"codeName":"Site name","dataType":"character varying","definition":"Description of the receiver site location"},{"allowNull":false,"codeName":"Rec_lat","dataType":"numeric","definition":"Site latitude","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001},{"allowNull":false,"codeName":"Rec_long","dataType":"numeric","definition":"Site longitude","units":"decimal degrees (datum WGS 1984)","unitsResolution":0.000001}],"definition":"data dictionary for tabular dataset detailing the site names and locations of radio telemetry receivers (Sigma Eight Orion) deployed within the Boquet River in 2020 to monitor landlocked Atlantic salmon movement.","codeName":"LookUpTbl_Rec_Site"},{"entityId":"830ac725-c17c-4087-9542-cfa6bda13d9b","attribute":[{"allowNull":false,"codeName":"Modem_SN","dataType":"character varying","definition":"Serial number of modem"},{"allowNull":false,"codeName":"Modem Code","dataType":"character varying","definition":"Code of modem"},{"allowNull":false,"codeName":"Owner","dataType":"character varying","definition":"Agency that owns the modem"},{"allowNull":false,"codeName":"Date of Purchase","dataType":"character varying","definition":"Date when modem was purchased"},{"allowNull":false,"codeName":"Manufacturer","dataType":"character varying","definition":"Manufacturer of modem"},{"allowNull":false,"codeName":"Make","dataType":"character varying","definition":"Make of the model"},{"allowNull":false,"codeName":"Model","dataType":"character varying","definition":"Model of the modem"},{"allowNull":false,"codeName":"IPv4","dataType":"character varying","definition":"IP address of modem"},{"allowNull":false,"codeName":"Phone No","dataType":"integer","definition":"Telephone number of the modem"},{"allowNull":false,"codeName":"Modem_ID","dataType":"integer","definition":"Unique ID of modem "}],"codeName":"LookUpTbl_Modems","definition":"data dictionary for tabular dataset containing information on modems owned by USGS Conte lab shared with the USFWS Lake Champlain FWCO"},{"entityId":"a2c49816-ed46-4520-9acc-639f650d9a91","attribute":[{"allowNull":false,"codeName":"Gear_ID","dataType":"character varying","definition":"Owner and gear type (NYDEC_TrapNet)"},{"allowNull":false,"codeName":"Type","dataType":"character varying","definition":"Trap net vs hoopnet"},{"allowNull":false,"codeName":"Mesh size","dataType":"integer","definition":"Stretched mesh length"},{"allowNull":false,"codeName":"Lead Line length","dataType":"integer","definition":"Length of lead line (meters)"},{"allowNull":false,"codeName":"Box size","dataType":"character varying","definition":"Size of the box if using a trap net"},{"allowNull":false,"codeName":"Mesh type","dataType":"character varying","definition":"Mono, twine, tar coated"}],"codeName":"LookUpTbl_Gear","definition":"data dictionary for tabular dataset containing information on nets for sampling landlocked Atlantic salmon within the Boquet River, NY in 2020"},{"entityId":"a11c8090-044a-4029-9a86-31ae4c8f01b8","attribute":[{"allowNull":false,"codeName":"ChargeController_ID","dataType":"character varying","definition":"Unique ID for charge controller (e.g. CC_001)"},{"allowNull":false,"codeName":"Serial_number","dataType":"integer","definition":"Serial number of charge controller"},{"allowNull":false,"codeName":"Make","dataType":"character varying","definition":"Make of charge controller (AltE Store)"},{"allowNull":false,"codeName":"Model","dataType":"character varying","definition":"Model of charge controller"},{"allowNull":false,"codeName":"DateOfPurchase","dataType":"date","definition":"date when charge controller was purchased"},{"allowNull":false,"codeName":"Key","dataType":"character varying","definition":"manufacturers designated key of the charge controller "},{"allowNull":false,"codeName":"Owner","dataType":"character varying","definition":"Office that owns the charge controller"},{"allowNull":false,"codeName":"Comments","dataType":"character varying","definition":"any additional information about the charge controller"}],"codeName":"LookUpTbl_ChargeControllers","definition":"data dictionary for tabular dataset detailing the charge controllers owned by the USFWS Lake Champlain FWCO"},{"entityId":"eea6779b-f4fd-4a95-8db5-c7773f75a353","attribute":[{"allowNull":false,"codeName":"Beacon_ID","dataType":"character varying","definition":"Unique ID of beacons (e.g. Beac_001)"},{"allowNull":false,"codeName":"Serial_number","dataType":"character varying","definition":"Serial number of beacon"},{"allowNull":false,"codeName":"DateOfPurchase","dataType":"date","definition":"date of purchase of beacon"},{"allowNull":false,"codeName":"Make","dataType":"character varying","definition":"make of beacon"},{"allowNull":false,"codeName":"Owner","dataType":"character varying","definition":"office that owns the beacon"},{"allowNull":false,"codeName":"DateTested","dataType":"date","definition":"Date when the beacon was last tested"},{"allowNull":true,"codeName":"Issue","dataType":"boolean","definition":"Whether of not the beacon has an issue"}],"codeName":"LookUpTbl_Beacon","definition":"data dictionary for tabular dataset pertaining to radio telemetry beacons used in the Boquet River, NY in 2020"},{"entityId":"ae6dc8ce-e7b4-4e4d-9de2-1166dc88c1ad","attribute":[{"allowNull":false,"codeName":"Battery_ID","dataType":"character varying","definition":"Unique identifier for batteries in the Boquet Telemetry project (e.g. BR_001)"},{"allowNull":false,"codeName":"DateOfPurchase","dataType":"date","definition":"date when battery was purchased"},{"allowNull":false,"codeName":"Make","dataType":"character varying","definition":"make of battery"},{"allowNull":false,"codeName":"Model","dataType":"character varying","definition":"model of battery"},{"allowNull":false,"codeName":"Type","dataType":"character varying","definition":"e.g. AGM, flooded, gel-cell"},{"allowNull":false,"codeName":"Voltage","dataType":"integer","definition":"Voltage of battery (Volts)","units":"Volts","unitsResolution":0.1},{"allowNull":false,"codeName":"Amperage","dataType":"integer","definition":"Ampergage of battery (Amps)","units":"amps","unitsResolution":1},{"allowNull":false,"codeName":"Serial_number","dataType":"character varying","definition":"serial number of battery"},{"allowNull":false,"codeName":"Model_number","dataType":"integer","definition":"model number of battery"},{"allowNull":false,"codeName":"Owner","dataType":"character varying","definition":"office that owns the battery"}],"codeName":"LookUpTbl_Batteries","definition":"data dictionary for 12v batteries used by the Lake Champlain FWCO in 2020 in the Boquet River radio telemetry project"}],"dictionaryIncludedWithResource":true}],"contact":[{"contactId":"23b9d60f-d181-4404-8262-18ae56bceab7","isOrganization":true,"name":"Conservation Genetics Lab","memberOfOrganization":["d6ff2454-c6fa-4e13-a424-366d91efa60f"],"phone":[{"service":["voice"],"phoneName":"Phone","phoneNumber":"(907) 786-3618"},{"service":["facsimile"],"phoneName":"Fax","phoneNumber":"(907) 786-3978"}],"address":[{"addressType":["mailing","physical"],"deliveryPoint":["1011 E. Tudor Road "],"city":"Anchorage","administrativeArea":"AK","postalCode":"99503","country":"USA"}],"electronicMailAddress":["ak_fisheries@fws.gov"],"onlineResource":[{"name":"Conservation Genetics Lab | Alaska Region","uri":"https://www.fws.gov/alaska/pages/locations/conservation-genetics-lab"}],"contactType":"federal"},{"contactId":"19aa1168-cab0-469b-94e9-eb2b68e8f612","isOrganization":true,"name":"U.S. Fish and Wildlife Service, Northeast region","memberOfOrganization":["f2d64d80-7641-4b87-b5a4-02250f27ad4a"],"onlineResource":[{"uri":"https://doimspp.sharepoint.com/sites/fws-FF05D00000"}],"contactType":"federal"},{"contactId":"f2d64d80-7641-4b87-b5a4-02250f27ad4a","isOrganization":true,"name":"U.S. Fish and Wildlife Service","logoGraphic":[{"fileUri":[{"name":"U.S. Fish & Wildlife Service Logo","uri":"https://fws.gov/themes/custom/fws_gov/logo.svg"}],"fileName":"FWS Logo","fileType":"svg"}],"onlineResource":[{"uri":"https://www.fws.gov/","name":"U.S. Fish and Wildlife Service Homepage"}],"contactType":"federal"},{"contactId":"960265ec-4fc7-47d6-a5b7-dcb346e2d8e5","isOrganization":false,"name":"Jonah Withers","memberOfOrganization":["23b9d60f-d181-4404-8262-18ae56bceab7"],"electronicMailAddress":["jonah_withers@fws.gov"],"contactType":"federal","positionName":"Data Manager"},{"contactId":"592430aa-88d4-4df1-b940-12bfc14fa7ae","isOrganization":false,"name":"Jonah Withers","memberOfOrganization":["nan"],"electronicMailAddress":["jonah_withers@fw.gov"]},{"contactId":"8aa6cd83-fd34-4ff2-ae4e-91745af70096","isOrganization":false,"name":"William Ardren","memberOfOrganization":["19aa1168-cab0-469b-94e9-eb2b68e8f612"],"electronicMailAddress":["william_ardren@fws.gov"],"positionName":"Fish Biologist","contactType":"federal"}]}]