During initial funding under CRAMP in 1998-99, 23 permanent study sites were established positioned in all of the proposed Fish Replenishment Areas (FRAs) as well as eight sites where fish collecting is know to occur ("impact"), and six managed areas where aquarium fish collection is prohibited (three Marine Life Conservation Districts (MLCDs) and three FMAs or "control"). Initial surveys confirm that aquarium fish collecting impacts are significant but vary along the coastline.
Tissot, B. N. and L. E. Hallacher. 1999. Impacts of aquarium collectors on coral reef fishes in Hawai'i. Final Report. Division of Aquatic Resources, Honolulu, HI. Tissot, B. N. 1999. Adaptive Management of Aquarium Fish Collecting in Hawaii. Live Reef Fish Information Bulletin 6: 16-19. Tissot, B. N. and D. M. Brosnan. 2002. Long Term Coral Reef Monitoring Programs: Working Towards a Synthesis of Science, Management and Policy. In: Best, B. and R. Pomeroy, Relevant Findings from the 9th International Coral Reef Symposium: Implications for Coral Reef Management and Policy. USAID.
Note, all tables in the database were dumped into MS 97-2000 Excel files with same name (subdirectory /excel) yet "tbl_" prefixed to tables and "qry_" prefixed to queries. From these, ASCII CSV files were obtained (subdirectory /csv). Table tbl_Substrates and tbl_RunDetail had to be broken into sequentially numbered pieces due to the large size.
A copy of a pertinent journal article can be found in /report.
Table: tbl_DiveMaster Field Comment ----- ------------------------------------- Survey representative dive number for data collection Date date of survey as dd/mm/yy Time time of dive, 00:00 - 23:59 HST SuveryN Survey sequence number (a single sequence represents each of the 26 sites being surveyed back to back) Location explicit site
Table: tbl_Location Field Comment ----- ------------------------------------- Location number corresponding to monitoring sites throughout the Hawaiian Islands and nearby atolls....includes CRAMP sites Big Island Big Island Site number Study Site descriptive site name (CRAMP compatible) Latitude degrees.minutes.seconds Longitude degrees.minutes.seconds Island descriptive name of island Status degree of management MLCD: Marine Life Conservation District NAR: Natural Area Reserve FMA: Fisheries Management Area (no fishing) Collecting Yes/no Type These are different ways of pooling and combining the various management regimes for the study sites. C = control (generally MLCDs or FMAs); F = FRA (fishery replenishment area); O = open (no protecteion). See Table 1 in Tissot et al. 2004 (/report) for more detail. The number after the code. e.g, C1, refer to the geographic location of each site, numbered north (1) to south (7). Although not all areas are completedly replicated. If there is more than one number (e.g., C789) the site was used as a reference for more than one FRA. Type2 management regime code FRA numerical order, north (1) to south (2) Type3 an old system, please ignore Depth in meters
Table: tbl_Species Field Comment ----- ------------------------------------- TaxonID code for taxon; table key Type descriptive, general taxonomic group Family taxonomic family TaxonName descriptive scientific name Synonym descriptive Hawaiian Name descriptive Common Name descriptive Trophic descriptive Kahe yes/no Kaneohe yes/no Endemic Ignore Kona Add-ons yes/no Data # Ignore Group Ignore AQ A = harvested by aquarium collectors; A1 = one of the top ten harvested species Final Report Ignore Resource Fish A = harvested by aquarium collectors; R = harvested as food fish; N = no known commercial value. Status code: A: collected by aquarium collectors A1: top 10 aquarium collector fishes blank: ?
Table: tbl_Substrate_Codes Field Comment ----- ------------------------------------- ID Name Link to Table Substrates data Code code of ID Name from PointCount Substrate options: substrate or Non-Substrate (filter) Coral options: Coral or Non-Coral (live coral filter)
Table: tbl_Substrates (PointCount data management) Field Comment ----- ------------------------------------- Transect transect number Quadrat frame number (randomly selected from all frames) Location see Parameter "Big Island" in Locations Table Station unconfirmed Frame No video frame number used for PointCount Image Date date on image, ignore (not correct) ID Name see table Substrate Codes ID Code PointCount ID Code for ID Name Point PointCount number X PointCount parameter Y PointCount parameter Intensity PointCount parameter Red PointCount parameter Green PointCount parameter Blue PointCount parameter File Name file under ../data/whap2000_Coral_Archive ID Date Date ID given by PointCount Site ID PointCount Site ID Site Code PointCount Site code (ignore) Time Code PointCount Time code (ignore) Institution where PointCount performed User Name PointCount operator, see Observers Habitat ignore WQS ignore Length ignore Depth ignore
Table: tbl_Kapoho_coral (PointCount data management) (see Substrates above)
Table: tbl_TransectRuns Field Comment ----- ------------------------------------- TransectRunID see RunDetails Survey survey number (dive number for one dive team at one location for one dive) Transect transect number Qlocation Quadrat location Observer initials of observer, see Observers Run/Quadrat run number through transect or quadrat sample
Table: tbl_WHAP_Transects_Depths Field Comment ----- ------------------------------------- ID See RunDetails Site See Locations, parameter Big Island Transect alphabetic transect ID Depth depth in meters Tran2 number code for transect
Table: tbl_RunDetails Field Comment ----- ------------------------------------- ID autonumber TransectRunId Foreign Key into TransectsRuns TaxonID code for taxon; table key Number Fish density values or coral substrate numbers Comment J=juvenile, A=adult Morph W=white SumofRun total number on survey run OldID unconfirmed
Table: tbl_Surveys Field Comment ----- ------------------------------------- Surveys Survey number BA A= After closure of FRAs (after 1/1/2000) B= Before closure of FRAs (before 1/1/2000) Date date Year year
Ignore the following tables: SAMPLING, Site-transects, Trans-quads, WHAP Transects
Other directories: /report: File Comment tissot_2005_qtr_1.pdf Powerpoint show from HCRI quarterly meeting, Jan2005 Tissot et al 2004.pdf Pacific Science journal article
/misc: File Comment areas.txt survey site locations, notes progress.txt dates of surveys, notes sites.jpg plot of locations