DART FYI

The following is the current status and other information for DART users:

10/21/2009	Cumulate Graph option added to all fish-based Graphics & Text reports: Adult Passage, Adult PIT Tag Returns, PIT Tag by Hydro Unit, PIT Tag by Observation Site, PIT Tag by Release Site, PIT Tag by Tag Coordinator, Smolt Index, Transportation, Trap Collected Counts, and Columbia Basin ESU.
10/21/2009	Adult Steelhead Wild 10 Year Average and Adult Shad 10 Year Average added to the Adult Passage Graphics & Text report.
10/6/2009	A new Adult Passage All Species Summary report has been added to the DART Adult Passage suite of reports. The All Species Summary report presents a summary table for all species counted in the current year at the select project including: cumulative passage to date, 10 Year Average passage to date, current passage percent of the 10 Year Average, run complete date. The summary table contains links to the 10 Year Run Timing graphs, Cumulative Passage with 10 Year Average graph, and a 4 Year Rolling Mean graph.
8/5/2009	A new Report Year Type option has been added to composite and detail reports where appropriate. The Report Year Type option allows for the selection of Within Calendar Year (the default) or Span Calendar Years for a single year query. For example, to query an Adult Passage winter run, select Year as start year, enter Start Date and End Date, and select Span Calendar Years option. This functionality does not apply to the Graphics&Text queries.
4/17/2009	The Pacific Northwest Index dataset, found on the DART Related Data and Topics web page, has been updated for 2008. Please consult the Pacific Northwest Index (PNI) web page for method descriptions.
3/24/2009	Columbia Basin Quick Look 2009 for Adult Passage, ESU Passage, Smolt Passage, and River Environment: 2009 basin-wide current conditions with 10 Year Averages.
2/12/2009	Columbia Basin ESU (Evolutionarily Significant Unit) reports and analysis tools expanded: Graphics&Text, One Week, Daily Summary, Summary&Migration Timing, Detail, Mean Travel Time, Run Timing, and Analyses. The Summary&Migrating Timing report includes the total observations to date for each component stock (Release Site, Species, Run, and Rear Type) at all projects in migration order with migration timing information for each project and linkages to river conditions during migration.
2/9/2009	Adult Passage All Projects Summary report has been added. This report generates the Adult Visual Counts Summary for All Projects table, which includes the total visual counts for all monitored adult species at all projects for a selected year. In addition, the 10 Year Averages for Chinook, Jack Chinook, Steelhead, Sockeye and Coho are included in the table.
1/29/2009	Adult Passage counts from Willamette Falls for 2001 to the present, provided by Oregon Department of Fish & Wildlife, have been added to the DART Adult Passage dataset. We expect to update this dataset as data is provided throughout the year.
1/22/2009	Bonneville Dam Adult Passage counts for 1960, 1965, and 1966 were synchronized with the Annual fish passage reports of the U.S. Army Corps of Engineers, North Pacific Division.
12/10/2008	The Spring Transition Dates and Fall Transition Dates dataset, found on the DART Related Data and Topics web page, has been updated for 2008 Spring Transition Dates. Please consult the Spring Transition Dates and Fall Transition Dates web page for method descriptions.
11/04/2008	The Lamprey Adult Passage counts for 2004 at Wells Dam were reloaded with a corrected dataset provided by Douglas County PUD.
10/08/2008	Adult PIT Tag Conversion Rate report has been expanded to include a summary graph of annual pooled Conversion Rates.
09/05/2008	Release basin summaries and migration timing information have been added to the DART PIT Tags by Hydro Unit Summary, PIT Tags by Observation Site Summary, and PIT Tags by Tag Coordinator Summary report tools.
09/05/2008	More than 15 PTAGIS detection sites have been added to all DART PIT Tag report tools.
07/22/2008	Adult PIT Tag Conversion Rate detail report includes last juvenile detection site and detection date information.
06/25/2008	The Pacific Northwest Index (PNI) dataset, a terrestrial climate index, found on the DART Related Data and Topics web page, has been updated for 1891-2007.
04/01/2008	Adult PIT Tag Conversion Rate report has been expanded. We have added the option to include PTAGIS Recapture and Mortality datasets in the conversion rate calculations. Details on the expansion are covered in the Spring 2008 issue of the Salmon Insider, the Columbia Basin Research Newsletter.
3/24/2008	The Spring Transition Dates and Fall Transition Dates dataset, found on the DART Related Data and Topics web page, has been updated for 2007 Fall Transition Dates. Please consult the Spring Transition Dates and Fall Transition Dates web page for method descriptions.
3/4/2008	PTAGIS detection sites at John Day River RM 20 (JD1) and Trout Creek, Wind River (TRC) have been added to all DART PIT Tag Adult Returns report tools. Release basins for John Day River and Wind River have been added to the Conversion Rate, Observation Year and Run Timing PIT Tag Adult Returns report tools.
2/14/2008	javaDART Applet for 2008 released.
10/9/2007	DART Data Inventory query tools have been added for the Adult Passage Counts and River Environment datasets. Map-based DART Data Inventory is accessible from Google Maps at CBR.
2/7/2007	Resident Species PIT Tag Summary report has been added. The report generates the Resident Species Release Summary table, which includes the Release Count for each Release Site by Species, Run, and Rear Type combinations for the selected Species and Release Year. The summary table also includes whether any of the PIT Tagged Resident fish were detected. Detection detail information is accessible from the query results for a particular Species, Run, Rear Type, and Release Site combination or for the Species.
1/26/2007	Adult Passage counts from Tumwater Dam for 1999-2006, provided by Washington Department of Fish & Wildlife and Chelan PUD, have been added to the DART Adult Passage dataset. We expect to update this dataset as data is provided during the migration season. Adult passage data for Tumwater Dam is the combination of released counts, referring to fish passed upstream of the dam and allowed to spawn naturally, and collected counts, referring to fish retained for hatchery broodstock. The Chinook adult passage counts are the sum of hatchery spring, hatchery summer, wild spring, and wild summer chinook as reported. The Jack Chinook adult passage counts are the sum of hatchery spring, hatchery summer, wild spring, and wild summer jack chinook as reported.
1/26/2007	The Spring Transition Dates and Fall Transition Dates dataset, found on the DART Related Data and Topics web page, has been updated to include both the OSCURS method (1946-1994) and Logerwell et al. method (1969-present). Please consult the Spring Transition Dates and Fall Transition Dates web page for method descriptions.
12/20/2006	Ten Year Historical Run Timing reports for the Adult Passage, PIT Tag Adult Returns, PIT Tag Observations, Smolt Index, and Columbia Basin ESUs datasets are now available for the years 1997-2006.
7/18/2006	DART River Environment queries are reporting the USACE's Recalibrated Spillway Discharge at Bonneville for 2002-2004. The Water Quality reports for BON, CWMW, CCIW, and WRNO include the recalibrated spill at Bonneville. The USACE initially reported incorrect hourly Bonneville spillway discharge for this period.
05/22/2006	We have updated our graphics program to allow non-averaged data and 10 year average data to share the same Y-axis.
05/16/2006	We have implemented a life stage filter as part of the queries found under the "PIT Tag Adult Returns" category on the DART web pages: Graphics&Text, Observation Year, Release Year, Observation Summary, Mean Travel Time, Run Timing, and Conversion Rate. The Adult PIT Tag observations presented in these reports are based on data filtering--including migration year, release year, release length, observation year, release site, and other criteria--used to determine the stage of the PIT-tagged fish at the time of the detection. DART categorizes PIT Tag observations into three stages: Adult, Juvenile, and Unknown. PIT Tag detections that DART has determined to be of Juvenile or Unknown stage are excluded from these PIT Tag Adult Returns reports.
04/18/2006	Bonneville Power Administration has extended the contract for the Fish Passage Center through November 2006. Further information about this topic can be found at Bonneville Power Administration Newsroom (04/12/2006 release), The Columbia Basin Bulletin (04/14/2006), and NW Fishletter (04/18/2006 #213). FPC is the primary source for the Smolt Index, Hatchery Releases, and Transportation datasets in DART.
04/17/2006	Ten Year Historical Run Timing reports developed and applied to the Adult Passage, PIT Tag Adult Returns, PIT Tag Observations, Smolt Index, and Columbia Basin ESUs datasets. Use the reports to view species or stock run timing and migration timing characteristics--which includes first, 1%, 5%, 10%, 50%, 90%, 95%, and last passage dates as well as the number of days for the middle 80% of the run--at a specific project for the last 10 years (1996-2005). The 10 Year Historical Run Timing reports allow the comparison of run timing across multiple years for a particular species or stock.
04/17/2006	For all datasets, we have integrated the Report query option into the Graphics&Text query option. Select "View Data Table (MM/DD)" from the "Select Output Format" list on the query page to produce the same output as the Report query option.
04/01/2006	The majority of Columbia Basin ESU passage reports for 2006 are active. The Arithmetic Mean Travel Time Estimates for juvenile and adult Columbia Basin ESU populations are active for 2006 as well.
03/31/2006	DART Metadata & Glossaries web page provides access to the collection of metadata and glossary information available for datasets offered in the Columbia River DART (Data Access in Real Time) database. Dataset-specific Metadata & Glossary information are linked to each applicable query page.
01/11/2006	Implemented the DART Data Feedback form for submitting data quality control issues to the DART Coordinator.
04/15/2005	Adult PIT Tag Conversion Rate report has been further expanded. From the Conversion Rate Report output, you may select from several other report options to examine the data: Detection Details by Release Site, Detection Details by Age, Detection Details by Date, and Conversion Rates by Date. Detection details reports include release date, release site, release river km, last detection dates, reach travel time, and special conditions indicators for individual PIT Tag IDs and arithmetic and harmonic mean travel times for fish grouped by report category. Or you may click on a Release Site to view detection details for that particular release site within the year.
04/04/2005	The majority of Columbia Basin ESU passage reports for 2005 are active. The Arithmetic Mean Travel Time Estimates for juvenile and adult Columbia Basin ESU populations are active for 2005 as well.
03/16/2005	Adult PIT Tag Conversion Rate report has been expanded to include flags for special conditions (overwintering, tagged as adults, and multiple migrations) and links to detection detail reports for individual detection year by single release site, by all release sites, and by age.
03/14/2005	javaDART version 2.0 is released as an applet to run in your web browser and as an application to download to your local system.
02/24/2005	The 2005 Adult Passage counts reported by the primary agencies and made available in the DART database are approximately 1 week behind today's date. Most projects do not start daily reporting of adult passage data until April.
02/16/2005	Fixed issue with Adult Passage Annual Summary report that was excluding data outside the spring, summer and fall migration seasons.
02/16/2005	Upper Willamette River Spring Chinook ESU reports for 2005 are active.
12/27/2004	Upgrade to the DART graphing program installed.
09/28/2004	Updates to the majority of the detail and summary PIT Tag reports installed.
09/14/2004	Adult Passage Annual Summary report has been added. The Annual Summary report includes total adult salmon passage counts for all adult species at a selected project for all years in the Columbia River DART database. The annual summary totals may be limited by a selected range of dates or by chinook run dates as defined by the USACE and YKFP.
09/14/2004	Adult PIT Tag Conversion Rate report updated to include Month Range query selection.
09/03/2004	Adult Passage data was synchronized with the adult passage data set available through the USACE Northwest Division's interactive database query system. At the same time, historical chinook run designations were re-assigned to match current run timings as defined by the USACE and YKFP.
07/30/2004	javaDART 2.0 is a new Columbia River DART database access tool based on the java programming language. It runs within a web page as an applet giving users greater flexibility to extract and analyze data from DART in both graphical and text-based formats. javaDART provides access to the River Environment, Adult Passage, and Juvenile Passage data sets. Plotting multiple data types in a single graph is possible with javaDART, which supports up to four separate Y axes. Graphs can be configured with axis scaling options including zoom in and zoom out capabilities for each axis as well as a round axis function that uses an adaptive rounding algorithm to create readable axis value labels. Graphs may be saved or exported to number of popular formats or copied to the system clipboard. With the text data interface, users can specify which columns to be copied or saved to disk. The text view handles both Julian dates and a standard date format. javaDART data analysis functions include parameter versus parameter (XY) plots and linear regressions on data series pairs. Regression lines and statistics are displayed on the graphs. Data filtering algorithms are a powerful data analysis feature of javaDART that can identify and remove erroneous data that sometimes occur in data queries. The user can easily control the amount of filtering using a redesigned filtering interface with slider controls. In addition, javaDART offers data accumulation; histogram options by weeks, months, or years; and plotting multiple years consecutively or as individual years.
06/14/2004	New version of the Survival and Mean Travel Time estimates program available from the PIT Tag Release and Observation Summary report has been installed. Analysis available for user-selected PIT Tag groups include Cormack/Jolly-Seber, arithmetic mean travel time, and harmonic mean travel time estimates.
06/11/2004	PIT Tag Adult Returns Observation Summary report updated to include by Brood Year summary option.
05/11/2004	DART initiated a daily ODBC connection to the Yakima-Klickitat Fisheries Project adult passage data for Prosser and Roza dams. This cooperative database endeavor ensures synchronicity between the two data sites and is an example of the possibilities for a regionally distributed database.
04/29/2004	Columbia Basin ESU juvenile and adult data services expanded to include: Upper Columbia River Spring Chinook, Middle Columbia River Steelhead, Lower Columbia River Steelhead, and Upper Willamette River Spring Chinook.
04/14/2004	Updated PIT Tag Release Sites on PIT Tag query pages.
10/28/2003	Adult PIT Tag Conversion Rate report output updated to include overwintering information and separate conversion rate summaries for all years and all historic years in the query.
10/28/2003	New version of the Survival and Mean Travel Time estimates program available from the PIT Tag Release and Observation Summary report has been installed. Analysis available for user-selected PIT Tag groups include Cormack/Jolly-Seber, arithmetic mean travel time, and harmonic mean travel time estimates.
06/23/2003	Prosser and Roza dams adult passage data are now available from the Yakima Klickitat Fisheries Project. Currently, the data set is not updated daily.
03/27/2003	2003 Adult Passage Counting Schedule: The near realtime data from visual counts has started.
03/13/2003	2003 Adult Passage Counting Schedule: The 2003 data currently available in our database originates from USACE video recordings; the video counts are running approximately 1 week behind today's date. This year, the video counts are for a 16 hour period compared to only 8 hours in previous years.
03/10/2003	New Adult PIT Tag Observation Sites -- BO3, IHA, PRA, and RIA -- have been added to the PIT Tag query pages.
03/10/2003	Updated PIT Tag Release Sites on PIT Tag query pages.
09/19/2002	Updated PIT Tag Release Sites on PIT Tag query pages.
06/07/2002	DART provides two types of water temperature data. One is the scrollcase data taken from inside the project structure. The other is the water column temperatures observed at the Water Quality Monitoring (WQM) probes generally at about 15 feet deep in the forebays and tailraces of the projects. In the past, these two data sets were merged into one with pre-1995 data exclusively scrollcase and post-1994 data exclusively WQM. These two data sets are now separated. Both temperature data sets can be queried from the River Environment web pages: "Temperature (Scroll Case)" for scroll case and "Temperature (WQM)" for water quality monitor.
05/24/2002	Adult Passage data at Bonneville added for 1938 - 1948.
04/23/2002	The Smolt Index data set has been updated from the Fish Passage Center (primary source) for all years. The data set includes the individual rear types: Wild, Hatchery, and Unknown. From 2000 to the present, the only individual rear type in the data set is Unknown.
03/28/2002	New Adult PIT Tag Observation Sites -- BO1, BO2, MC1, MC2, TMA, and WEA -- have been added to the PIT Tag query pages.
03/25/2002	2002 Adult Passage Counting Schedule: The near realtime data from visual counts has started.
03/14/2002	2002 Adult Passage Counting Schedule: The near realtime data from visual counts of adults at the Columbia Basin hydroelectric projects are officially scheduled to begin April 1, 2002. The 2002 data currently available in our database originates from USACE video recordings; the video counts are running approximately 1 week behind today's date.
09/06/2000	A Location Map showing the majority of data collection locations contained in DART is now available. Go to Map.
07/13/2000	A new PIT tag summary report, Release and Observation Summary, has been created to allow selection of specific or general release criteria and obtain a summary of the releases and observations that match.