Table 1 of Holtschlag, David J. and John A. Koschik, 2003, An acoustic Doppler current profiler survey of flow velocities in St. Clair River, a connecting channel of the Great Lakes, Date Posted: March 28, 2003, US Geological Survey Open-File Report 03-119 [http://mi.water.usgs.gov/pubs/OF/OF03-119/index.php]

Tables - An acoustic Doppler current profiler survey of flow velocities in St. Clair River, a connecting channel of the Great Lakes

Table 1. ASCII output file created by WinRiver Software (Link to Accessible version of Table 1.)
Data type	Sample data
Transect data	ADCP Survey of St. Clair River: CS-001
	(Comment number 1)

	USACE (Transect run left to right)
	(Comment number 2)

	50 25 29 56 1 20 1
	(Depth cell length (cm), Blanking distance (cm), ADCP depth (cm), Number of depth cells, Number of pings per ensemble, Time per ensemble in 1/100s of a second, Profiling mode.)

Ensemble data summary	2 5 20 9 2 38 69 376 1 -1.120 0.600 35.950 9.550
	(Year (last digit), Month, Day, Hour, Minute, Second, 1/100s of second, Ensemble number, Number of ensembles, Pitch (degrees), Roll (degrees), Corrected heading (degrees), ADCP Temperature, in degrees Celsius)

	1.64 0.76 0.05 0.03 0.00 469.18 0.00 10.07 5.99 6.22 6.22 5.99
	(Bottom-track velocity (ft/s): East(+)/West(-), North(+)/South(-), Vertical Up(+)/Down(-), Error, Not applicable(NA), NA, NA, NA, Depth: Beams 1-4 (ft)

	0.87 0.48 0.37 0.79 0.87
	(Total distance in ft, Total elapsed time in seconds, Distance north (ft), Distance east (ft), Distance made good (ft)).

	43.0040250 -82.4137100 -32768 -32768 0.9
	(Latitude, Longitude, Measured discharge, Top discharge, Bottom discharge,

	-0.0 -0.1 -0.0 0.0 20.0 0.0 0.0 3.73 3.73
	(Discharge ft³/s: (Measured, Top, Bottom, Start-shoreline), Start distance to shore (ft), End-shoreline discharge (ft³/s), End distance to shore (ft), Starting depth of measured layer (ft), Ending depth of measured layer (ft).

	35 ft BT dB 0.45 0.115
	(Number of bins to follow, Measurement unit (cm or ft), Velocity reference, Intensity units, Intensity scale factor, Sound absorption factor)

Bin data	3.73 0.50 241.35 -0.4 -0.2 -0.0 -0.2 99.0 89.1 90.4 89.1 100 -0.05
	(Depth in ft, Velocity magnitude in ft/s, Measured velocity direction in degrees, East velocity in ft/s, North velocity in ft/s, Vertical velocity in ft/s, Error velocity in ft/s, Backscatter in percent (beams 1-4), Percent good, flow)

	5.37 -32768 -32768 -32768 -32768 -32768 -32768 255 109.0 109.0 255 0 2147483647
	7.01 -32768 -32768 -32768 -32768 -32768 -32768 255 255 255 255 0 2147483647
	8.65 -32768 -32768 -32768 -32768 -32768 -32768 255 255 255 255 0 2147483647
	.
	. (Additional velocity data at each depth bin).
	.
	59.51 -32768 -32768 -32768 -32768 -32768 -32768 255 255 255 255 0 2147483647

The ADCP position and velocity data were modified as discussed in the preceding sections and new ASCII files were created to facilitate the analysis of flow velocities in St. Clair River. The new format is a rectangular array of data, similar to that seen in a spreadsheet, with each valid velocity measurement at a depth cell contained in an individual row. The column contents of each row are described in Table 2. The new format includes all valid data from a cross section by combining data from both the left-to-right and the right-to-left transects in a single file. The column “L2R” identifies the direction the transect was surveyed. Together, the ADCP data files provide point velocity data at more than 2.7 million locations in St. Clair River.

Column label	Data attribute
Easting	The adjusted easting position of the velocity measurement, referenced to the North American Datum of 1983 (NAD 83) State Plane Coordinate system for the southern zone of Michigan (2113), in international feet. (Equation 8).
Northing	The adjusted northing position of the velocity measurement, referenced to the North American Datum of 1983 (NAD 83) State Plane Coordinate system for the southern zone of Michigan (2113), in international feet. (Equation 8).
Depth	The depth below the water surface of the velocity measurement, in feet.
VelMag	The magnitude of the measured water velocity, in feet per second.
VelAzmAdj	The adjusted direction of water velocity, which is positive when measured clockwise from zero degrees north (along the positive y-axis. (Equation 9).
VelEastAdj	The easting component of water velocity, in feet per second. (Equation 10).
VelNrthAdj	The northing component of water velocity, in feet per second. (Equation 10).
VelUp	The upward component of water velocity, in feet per second.
Latitude	The latitude of the velocity measurement, in decimal degrees. In the data file, a value of 30.000000 indicates that the global positioning signal was not recorded.
Longitude	The longitude of the velocity measurement, in decimal degrees. Note, a value of -30.000000 indicates that the global positioning signal was not recorded.
BotDep	The distance between the water surface and the bottom of the river, in feet.
Discharge	The flow (discharge of water) through the subarea defined by the flow velocity and area, in cubic feet per second.
TimeTotal	Cumulative time since the beginning of the ADCP measurement, in seconds.
L2R	An indicator of the direction in which the transect was measured. A value of 1 (logical true) indicates that the transect was measured from the left-to-right across the river (looking downstream), and is zero otherwise.
VelAzmMea	The measured azimuth of the flow velocity, unadjusted for magnetic declination. The azimuth is positive when measured clockwise from zero degrees north (along the positive y-axis).
VelError	An estimator of the precision of the velocity measurement, in feet per second.
BackScat	The percent of the original acoustic signal that is scattered back to the ADCP unit. Backscatter is sometimes related to the amount of suspended material in the water column.