DART transport analysis of PTAGIS dataset is conducted annually after the end of the transportation season. DART analyzed 2000 to the present for transportation at Lower Granite, Little Goose, Lower Monumental, and McNary (until operations stopped).

The DART transport filter of the PTAGIS dataset examines fish detected at transport locations and assigns a probable transport outcome to individuals. It is designed to create a list of fish that are expected to be transported based on coil detections but may have extenuating circumstances.

The psql file "Transport_Filter_NEW.psql" is the vehicle for this. Tables involved include transport_proj_list, transport_rel_list, transport_dates, trans_min_max, cbr_transport_exceptions, and trans_dates_tmp.

The first step is to examine the transport schedule as reported by Fish Passage Center (FPC). The results are placed in the table transport_dates. Chinook are added separately because they have multiple run-types. A key statistic is bypass percent.

The table is improved by determining days where fish are collected but the action (e.g., bypassed or transported) is recorded on the following day. trans_dates_tmp is the table for this. Its refinements go into transport_dates.

The table transport_dates is then examined for the minimum and maximum transport dates for each species and project. The results are placed in trans_min_max. The table trans_dates_tmp is examined to extend the dates here as well, if needed.

We then create two lists: transport_proj_list table are fish seen at the transport sites with their maximum detection date and associated coil_ids. transport_rel_list are fish identified in transportation releases. There is a little overlap here so fish listed as transport releases that are detected at the transport sites are deleted from the transport_proj_list. Project and detection site names are forced into alignment in these two lists.

Based on PTAGIS site configuration information, fish with absolute non-transport final coils_ids are deleted from the table. The remaining fish are assigned trans_status codes of 'T' (TRANSPORTED) or 'S' (SAMPLED) depending on the date and location of their last detection at a project. All transportation release fish are assigned an initial code of 'T'.

Any fish not receiving a status code is deleted from the tables.

Then the trans_status codes are examined relative to transport_dates. Fish that are detected on days when bypass exceed 93% have a 'B' (BYPASS) appended to their trans_status, e.g., TB. Fish seen at projects outside the transportation date window are also appended with a 'B'. Fish that are held extra days before an action is recorded (trans_dates_tmp) are examined manually after the filter is completed to determine if the fish need an added bypass designation. These additional bypass dates are added programmatically to the filter.

There is significant metadata regarding project/date combinations where transport operations were compromised. We have two methods of determining these events:

1. Specific expert information regarding specific releases, projects, and dates.
2. Careful retrospective analysis of the transportation filter results to identify project/date combinations where a significant percentage of expected transport fish were returned to the river. Subsequent downstream detections are used in this analysis. If 25% of temporally grouped 'T' or 'S' status fish are detected downstream, we consider the time period to have a bypass pattern (P).

This intelligence is contained into the table cbr_transport_exceptions. Fish matching the appropriate criteria in the table are assigned the trans_status of TBP (TRANSPORT BYPASS PATTERN) or SBP (SAMPLE BYPASS PATTERN) as listed in the table.

The transport_rel_list is appended to transport_proj_list at this juncture.

There are a number of barge releases that are identified as not satisfying a 'transported' criteria. These 'bad barge trip' fish are assigned a trans_status code of '99'.

Once fish have these designations, they are examined for unexpected downstream PTAGIS detections. Fish seen at a transport site that have received a trans_status designation of 'S', 'T', 'SB', or 'TB' but are seen at a downstream location as a juvenile have a 'D' (DOWNSTREAM) appended to their trans_status.

The transport_proj_list table contains the following transport designations: