36253 MRVTAGEVENT Entity Published / External 27490 Coastal Shark Bottom Longline Survey Data Set Completed View of committed events including tag information (use to query tags) Loaded by batch 9650, 01-12-2017 16:31 Data View Yes MRDBS View of committed events including tag information (use to query tags) 1 FISHERY VARCHAR2 2 Yes No Active Fishery Code, a two character fishery identification code. See support table MRFISHERY for codes and descriptions. VARCHAR2 2 TAG_TYPE VARCHAR2 2 Yes No Active Style of tag, see support table MRTAGTYPES for descriptions. (Note: For yellowtail, data storage tags were migrated to tag type 40 in MRDBS, before migration, they were tag type 03) VARCHAR2 3 TAG_COLOR VARCHAR2 2 Yes No Active Color of tag, see support table MRTAGCOLORS for descriptions. VARCHAR2 4 TAG_NUMBER VARCHAR2 6 Yes No Active Tag identification number. VARCHAR2 5 TAG_SUFFIX VARCHAR2 1 Yes No Active Tag suffix, for yellowtail, suffix A or B were used for transcription errors when recording tag or tag was removed from a poor condition fish and reused. VARCHAR2 6 TAG_REWARD VARCHAR2 2 No No Active Reward for tag release or recapture, see support table MRTAGREWARDS for descriptions. VARCHAR2 7 TAG_FATE VARCHAR2 2 No No Active Fate of tag, see support table MRTAGFATES for descriptions. VARCHAR2 8 TAG_CONDITION VARCHAR2 2 No No Active Condition of tag, see support table MRTAGCONDITIONS for descriptions. VARCHAR2 9 TAG_SITE VARCHAR2 2 No No Active Area of tag at recapture, see support table MRTAGSITE for descriptions. VARCHAR2 10 TAG_LOCONFISH VARCHAR2 2 No No Active Location on fish where tag is attached, see support table MRTAGLOCONFISH for descriptions. VARCHAR2 11 TRIPID VARCHAR2 8 No No Active Trip identification code, for yellowtail tagging, trip id consists of YT[year]-[sequential number of trip within year]. VARCHAR2 12 HAULNUM VARCHAR2 4 No No Active Ordinal number of the haul within the trip, set number for shark cruises. VARCHAR2 13 ANIMALID VARCHAR2 14 Yes No Active Animal identification code, animal id will be a concatenation of fishery, original tag type, color, number, and suffix. VARCHAR2 14 EVENTNUM NUMBER 22 Yes No 3 0 Active Event occurrence of animal (ie: initial release = 1, 1st recapture of animal = 2, 2nd recapture of animal = 3, 3rd recapture of animal = 4, etc.) NUMBER 15 EV_TYPE VARCHAR2 2 No No Active Event type, see support table MREVENTTYPES for descriptions. VARCHAR2 16 EV_MONTH VARCHAR2 2 No No Active Month of event. VARCHAR2 17 EV_DAY VARCHAR2 2 No No Active Day of event. VARCHAR2 18 EV_YEAR VARCHAR2 4 No No Active Year of event. VARCHAR2 19 EV_DATE VARCHAR2 10 No No Active Date of Event. VARCHAR2 20 EV_DATEQUAL VARCHAR2 2 No No Active Date quality, see support table MRDATE_QUALITY for descriptions. VARCHAR2 21 EV_COMMENTS VARCHAR2 200 No No Active Comments or remarks. VARCHAR2 22 EV_STATAREA VARCHAR2 3 No No Active Statistical area calculated from latitude and longitude, note: stat area 551, 552 are in Canadian water. VARCHAR2 23 EV_MILES NUMBER 22 No No 4 0 Active Miles from reported location (used for location calculation). (redacted) NUMBER 24 EV_DIRECTION VARCHAR2 5 No No Active Direction from reported location (used for location calculation). (redacted) VARCHAR2 25 EV_LATDEG VARCHAR2 2 No No Active Event latitude degrees. (redacted) VARCHAR2 26 EV_LATMIN VARCHAR2 2 No No Active Event latitude minutes. (redacted) VARCHAR2 27 EV_LATSEC VARCHAR2 2 No No Active Event latitude seconds. (redacted) VARCHAR2 28 EV_NOS VARCHAR2 1 No No Active North or south. (redacted) VARCHAR2 29 EV_DECLAT VARCHAR2 9 No No Active Latitude in decimal degrees. (redacted) VARCHAR2 30 EV_LONDEG VARCHAR2 3 No No Active Event longitude degrees. (redacted) VARCHAR2 31 EV_LONMIN VARCHAR2 2 No No Active Event longitude minutes. (redacted) VARCHAR2 32 EV_LONSEC VARCHAR2 2 No No Active Event longitude seconds. (redacted) VARCHAR2 33 EV_EOW VARCHAR2 1 No No Active East or west. (redacted) VARCHAR2 34 EV_DECLON VARCHAR2 10 No No Active Longitude in decimal degrees. (redacted) VARCHAR2 35 EV_LOCQUAL VARCHAR2 2 No No Active Data quality code for location, see MRLOC_QUALITY for descriptions. VARCHAR2 36 EV_DEPTH NUMBER 22 No No 4 0 Active Depth. NUMBER 37 EV_DEPTHUOM VARCHAR2 2 No No Active Unit of measure used for depth (FM, FT, M). VARCHAR2 38 EV_DEPTH_FM NUMBER 22 No No 38 Active Depth in Fathoms. NUMBER 39 EV_DAYSFREE NUMBER 22 No No 5 0 Active Days free for recapture only. NUMBER 40 EV_DISTTRAVEL NUMBER 22 No No 5 0 Active Distance traveled in nautical miles for recapture only, distance traveled is calculated with great circle formula. NUMBER 41 EV_TRAVELDEG NUMBER 22 No No 4 1 Active Travel direction for recapture only, see MRDIRECTIONS for descriptions. NUMBER 42 EV_TRAVELDIR VARCHAR2 2 No No Active Calculated angle for direction traveled, rounded to 1 decimal position. For ytf, bsb, and scup, angle is calculated using magnetic north, shark angle is calculated using polar north.. VARCHAR2 43 EV_SPECIES_ITIS VARCHAR2 11 No No Active Itis species code, see support table MRSPECIES for descriptions, corresponding survey and shark species codes also in MRSPECIES. VARCHAR2 44 EV_SEX VARCHAR2 1 No No Active Sex ( 0 = male, 1 = female). VARCHAR2 45 EV_LENGTH NUMBER 22 No No 6 2 Active Length, for sharks: fork length in centimeters . NUMBER 46 EV_LENUOM VARCHAR2 3 No No Active Unit of measure for length (CM, IN). VARCHAR2 47 EV_LENQUAL VARCHAR2 2 No No Active Data quality code for length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 48 EV_LENTYPE VARCHAR2 2 No No Active Length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 49 EV_LENDET VARCHAR2 2 No No Active Length determination code, see support table MRLENGTH_DETERMINATION for descriptions. VARCHAR2 50 EV_RPTLENGTH NUMBER 22 No No 6 2 Active Reported length measurement. NUMBER 51 EV_RPTLENUOM VARCHAR2 3 No No Active Unit of measure for reported length (CM, IN). VARCHAR2 52 EV_RPTLENQUAL VARCHAR2 2 No No Active Data quality code for reported length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 53 EV_RPTLENTYPE VARCHAR2 2 No No Active Reported length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 54 EV_OTHLENGTH NUMBER 22 No No 6 2 Active Other length measurement. NUMBER 55 EV_OTHLENUOM VARCHAR2 3 No No Active Unit of measure for other length (CM, IN). VARCHAR2 56 EV_OTHLENQUAL VARCHAR2 2 No No Active Data quality code for other length, see support table MRLENGTH_QUALITY for descriptions. VARCHAR2 57 EV_OTHLENTYPE VARCHAR2 2 No No Active Other length type code, see support table MRLENGTH_TYPES for descriptions. VARCHAR2 58 EV_WEIGHT NUMBER 22 No No 6 2 Active Weight, for sharks, whole weight in kg. NUMBER 59 EV_WGTUOM VARCHAR2 3 No No Active Unit of measure for weight (LB, KG). VARCHAR2 60 EV_WGTQUAL VARCHAR2 2 No No Active Weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 61 EV_WGTTYPE VARCHAR2 2 No No Active Weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 62 EV_WGTDET VARCHAR2 2 No No Active Weight determination code, see support table MRWEIGHT_DETERMINATION for descriptions. VARCHAR2 63 EV_RPTWEIGHT NUMBER 22 No No 6 2 Active Reported weight, for sharks, whole weight in kg. NUMBER 64 EV_RPTWGTUOM VARCHAR2 3 No No Active Unit of measure for reported weight (LB, KG). VARCHAR2 65 EV_RPTWGTQUAL VARCHAR2 2 No No Active Reported weight quality code, see support table MRWEIGHT_QUALITY for descriptions. VARCHAR2 66 EV_RPTWGTTYPE VARCHAR2 2 No No Active Reported weight type code, see support table MRWEIGHT_TYPES for descriptions. VARCHAR2 67 EV_CONTACTID NUMBER 22 No No 6 0 Active Contact id for event. NUMBER 68 EV_INDUSTRY VARCHAR2 2 No No Active Industry (category, sector) at time of event, see support table MRINDUSTRY for descriptions. VARCHAR2 69 EV_OCCUPATION VARCHAR2 2 No No Active Occupation at time of event, see support table MROCCUPATION for descriptions. VARCHAR2 70 EV_GEAR VARCHAR2 2 No No Active Gear used, see support table MRGEARS for descriptions. VARCHAR2 71 HOW_REPORTED VARCHAR2 2 No No Active How recapture was reported, see support table MRRECAP_REPORTED for descriptions. VARCHAR2 72 INFO_PENDING VARCHAR2 1 No No Active Additional information is pending about the recapture 0 = no, 1 = yes. VARCHAR2 73 DATE_ENTERED VARCHAR2 10 No No Active Date of Entry. VARCHAR2 74 DATE_LAST_UPDATED VARCHAR2 10 No No Active Date of Last Update VARCHAR2 gov.noaa.nmfs.inport:36253 Patricia Jones 2017-01-12T16:31:43 SysAdmin InPortAdmin 2022-08-09T17:11:17 2017-01-12 Northeast Fisheries Science Center NEFSC 166 Water Street Woods Hole MA 02543-1026 USA (508)495-2000 https://www.nefsc.noaa.gov 8:00 a.m. to 4:30 p.m. Monday - Friday 1001 Public No 2017-01-12 1 Year 2018-01-12