56311 Entity Published / External 25298 Pacific Reef Assessment and Monitoring Program: Geospatial, Temperature, and Depth Data Collected during Towed-diver Surveys of the U.S. Pacific Reefs from 2000 to 2017 Data Set Segments is a polyline shapefile and it is generated during data processing of the geospatial and SBE39 data. The data represent the estimated survey track of the divers for each 5-minute segement of a towed-diver survey. The data is generated by processing the DivePoints using a track processing algorithm, lacing together each of the 5-second survey points, and grouping them by SegmentID. Data Table Yes Data table for Segments shapefile from the towed-diver surveys. 1 FID NUMBER No No Active Sequential unique whole numbers that are automatically generated. 2 Shape GEOMETRY No No Active Indicates the type of geometry (Polyline), automatically generated in ArcGIS. 3 DIVEID NUMBER No No Active Unique ID/9-digit serial number for each 50-minute survey. The serial number is formed by concatenating the 4-digit survey year, 2-digit month, 2-digit day, and dive/tow survey number of the day (1-6). The dive number sequence restarts each day and is restricted to values 1-6. For example, the DIVE ID for the first dive on March 13, 2011 is 201103131. 4 SEGMENTID NUMBER No No Active Unique ID/11-digit serial number for each 5-minute survey segment/observation. The serial number is formed by concatenating the DIVEID with the 2 digit segment number (01-10). The segment number sequence restarts each survey and is restricted to values 01-10. For example, the SEGMENT ID for segment #5 on dive #1 on March 13, 2011 is 20110313105. 5 DIVEYEAR NUMBER No No Active 4-digit year the survey was conducted. 6 REGION NVARCHAR2 No No Active 4-letter region code for the geographic region (archipelago) in which the survey was conducted. AMSM: American Samoa MARI: Guam and Commonwealth of Northern Mariana Islands MNHI: Main Hawaiian Islands NWHI: Northwestern Hawaiian Islands PRIA: Pacific Remote Island Areas 7 ISLAND NVARCHAR2 No No Active 3-letter island code for the island at which the survey was conducted. Full name of each island code is listed in the Island_Lookup_Table.csv. 8 FTEMP_MEAN NUMBER No No Active The mean temperature (in degrees Celsius) recorded by the SeaBird SBE39 mounted on the fish towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases the average temperature from the fish and benthic SBE39s is only provided in CTEMP_MEAN, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the mean temperature is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record temperature data for the majority of the 5-minute survey segment, this field is left blank. 9 FTEMP_STDE NUMBER No No Active The standard deviation of temperature (in degrees Celsius) recorded by the SeaBird SBE39 mounted on the fish towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases only the average temperature from the fish and benthic SBE39s is provided in CTEMP_MEAN, and therefore the standard deviation of the temperature was provided only in CTEMP_STDE, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the temperature standard deviation is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record temperature data for the majority of the 5-minute survey segment, this field is left blank. 10 BTEMP_MEAN NUMBER No No Active The mean temperature (in degrees Celsius) recorded by the SeaBird SBE39 mounted on the benthic towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases the average temperature from the fish and benthic SBE39s is only provided in CTEMP_MEAN, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the mean temperature is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record temperature data for the majority of the 5-minute survey segment, this field is left blank. 11 BTEMP_STDE NUMBER No No Active The standard deviation of temperature (in degrees Celsius) recorded by the SeaBird SBE39 mounted on the benthic towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases only the average temperature from the fish and benthic SBE39s is provided in CTEMP_MEAN, and therefore the standard deviation of the temperature was provided only in CTEMP_STDE, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the temperature standard deviation is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record temperature data for the majority of the 5-minute survey segment, this field is left blank. 12 FDEP_MEAN NUMBEAR No No Active The mean depth (in meters) recorded by the SeaBird SBE39 mounted on the fish towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases the average depth from the fish and benthic SBE39s is only provided in CDEP_MEAN, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the mean depth is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record depth data for the majority of the 5-minute survey segment, this field is left blank. 13 FDEP_STDE NUMBER No No Active The standard deviation of depth (in meters) readings recorded by the SeaBird SBE39 mounted on the fish towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases the average depth from the fish and benthic SBE39s is only provided in CDEP_MEAN, and therefore the standard deviation of the depth was provided only in CDEP_STDE, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the depth standard deviation is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record depth data for the majority of the 5-minute survey segment, this field is left blank. 14 BDEP_MEAN NUMBER No No Active The mean depth (in meters) recorded by the SeaBird SBE39 mounted on the benthic towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases the average depth from the fish and benthic SBE39s is only provided in CDEP_MEAN, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the mean depth is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record depth data for the majority of the 5-minute survey segment, this field is left blank. 15 BDEP_STDE NUMBER No No Active The standard deviation of depth (in meters) readings recorded by the SeaBird SBE39 mounted on the benthic towboard averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. From 2000 to 2009, in most cases the average depth from the fish and benthic SBE39s is only provided in CDEP_MEAN, and therefore the standard deviation of the depth was provided only in CDEP_STDE, unless the data from a specific time period was reprocessed with a newer version of the Python script (and therefore the depth standard deviation is provided for both the fish and benthic as well as the combined). All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If the SBE39 failed to record depth data for the majority of the 5-minute survey segment, the field is left blank. 16 CTEMP_MEAN NUMBER No No Active The mean combined temperature (in degrees Celsius) recorded by the SeaBird SBE39 units mounted on the fish and benthic towboards, averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If either of the SBE39 units failed to record temperature data for the majority of the 5-minute survey segment, this field is left blank. 17 CTEMP_STDE NUMBER No No Active The standard deviation of the combined temperature (in degrees Celsius) readings recorded by the SeaBird SBE39 units mounted on the fish and benthic towboards, averaged over the 300 5-second readings made during the 5-minuted towed-diver survey segment. All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If either of the SBE39 units failed to record temperature data for the majority of the 5-minute survey segment, this field is left blank. 18 CDEP_MEAN NUMBER No No Active The mean combined depth (in meters) recorded by the SeaBird SBE39 units mounted on the fish and benthic towboards, averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If either of the SBE39 units failed to record depth data for the majority of the 5-minute survey segment, this field is left blank. 19 CDEP_STDE NUMBER No No Active The standard deviation of the combined depth (in meters) readings recorded by the SeaBird SBE39 units mounted on the fish and benthic towboards, averaged over the 300 5-second readings made during the 5-minute towed-diver survey segment. All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. If either of the SBE39 units failed to record depth data for the majority of the 50-minute survey segment, this field is left blank. 20 GEO_LENGTH NUMBER No No Active The length (in meters) of each 5-minute towed-diver survey segment calculated by the track processing script in Geodesic (unprojected) space. This is the arc length of each survey based on a spherical earth model. It is calculated by adding up the geodesic distance between each of the 5-second survey points, grouped by SEGMENTID. All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. 21 LAT NUMBER No No Active Latitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment. 22 LON NUMBER No No Active Longitude in decimal degrees, WGS84, for the center point of each 5-minute towed-diver survey segment. 23 UTM_LENGTH NUMBER No No Active The length (in meters) of each 5-minute towed-diver survey segment calculated by the data manager using ArcGIS, based on the UTM projection for the location of the survey. This is a manual calculation made in ArcGIS after the initial track processing has been completed. Coordinate System = UTM Zone projection appropriate for each survey region, Units = meters. All zero values represent NULL values and not measured values due to a limitation of the shapefile format. All NULL values were converted to zero when the source geodatabase feature class was exported to shapefile format. No zeros exist in the source dataset. 24 UPLOADDATE TIMESTAMP No No Active Date when the data was uploaded to the database (m/d/yyyy). 25 SCRIPTVER NVARCHAR2 No No Active Version of the upload script used to process the data and write it to the geodatabase. 26 STARTTIME NVARCHAR2 No No Active The start date and time of the 5-minute towed-diver survey segment based on the local time zone for the area being surveyed (m/d/yyyy h:mm:ss AM/PM). 27 ENDTIME NVARCHAR2 No No Active The end date and time of the 5-minute towed-diver survey segment based on the local time zone for the area being surveyed (m/d/yyyy h:mm:ss AM/PM). gov.noaa.nmfs.inport:56311 Tomoko Acoba 2019-05-17T17:21:03 SysAdmin InPortAdmin 2022-08-09T17:11:00 2019-05-30 Pacific Islands Fisheries Science Center PIFSC 1845 Wasp Blvd. Honolulu HI 96818 USA 808-725-5300 https://www.pifsc.noaa.gov 8:00 a.m. - 4:30 p.m. 1001 Public No 2019-05-30 1 Year 2020-05-30