Record of second email conversation with submitter. Submitter submitted revised data that included lat/long instead of northings and eastings and one minor revision to abstract. ************** Wellman, Emory Howe Thu, Aug 5, 2021 at 12:49 PM To: Stephen Formel - NOAA Federal Hi Stephen, Yes, that is totally fine! I apologize for that discrepancy. Let me know if you have any other questions! Emory From: Stephen Formel - NOAA Federal Sent: Thursday, August 5, 2021 12:41 PM To: Wellman, Emory Howe Subject: Re: NCEI submission 0239707 - questions This email originated from outside ECU. Emory, Apologies, I found one other minor point, but I need to document your approval before I change it. In the abstract you describe the data as being "CSV files and shapefiles", but they are actually xlsx files and shapefiles and a docx file. Do you approve of me making the revision to the abstract to reflect that? Thank you, Steve Stephen Formel - NOAA Federal Thu, Aug 5, 2021 at 11:48 AM To: "Wellman, Emory Howe" No worries, thank you for doing that so quickly! Steve On Thu, Aug 5, 2021 at 10:28 AM Wellman, Emory Howe wrote: Hi Stephen, This makes total sense - my apologies for not thinking to provide better coordinate data from the start. I have converted all northing/easting coordinates to decimal degree lat long coordinates and updated the sheet's metadata to reflect the addition. Please let me know if there are any further amendments I should make to this file. Thanks again and sorry about the back and forth! Emory From: Stephen Formel - NOAA Federal Sent: Thursday, August 5, 2021 09:57 AM To: Wellman, Emory Howe Subject: Re: NCEI submission 0239707 - questions This email originated from outside ECU. Emory, That's good to know, but for the purposes of archiving we need to have explicit lat/long for the data points that allow them to be connected to experimental variables (Shoreline, Treatment, Block, Location). This helps your data to stand on its own decades from now. It would also be acceptable for you to provide a new file (rather than revising ReefHeight) that explicitly connects the experimental variables (Shoreline, Treatment, Block, Location) with lat/long. I focused on ReefHeight because it was the only file that contained all of the experimental and spatial information. Thanks, Steve On Thu, Aug 5, 2021 at 8:18 AM Wellman, Emory Howe wrote: Hi Stephen, Thank you for your message. I apologize but after reviewing that spreadsheet, I am not convinced that the northing and easting coordinates are necessary...rather, I believe they are holdovers from an earlier version of the dataset. I apologize for not catching this earlier. If you are able on your end please go ahead and remove those 4 columns, otherwise I can do so and send you a new version. Sorry about that, and let me know if you have any further questions! Emory From: Stephen Formel - NOAA Federal Sent: Wednesday, August 4, 2021 05:45 PM To: Wellman, Emory Howe Subject: NCEI submission 0239707 - questions This email originated from outside ECU. Emory, I have an additional question about the package you've submitted for archiving (0239707). The only coordinates I can find in the data are the northings and eastings in the file "CarrotIsland_ReefHeight.xlsx". However, I can't seem to find the associated information to convert them to lat/long. Could you please: Send me an updated version of "CarrotIsland_ReefHeight.xlsx" with the coordinates converted to lat/long in decimal degrees? If you wish to also include the northing and easting coordinates along with the lat/long, could you please update the metadata to include the information necessary to convert the northings and eastings to lat/long? If I have overlooked the information, please forgive me and kindly point me to where it is within the data/metadata. Thank you, Steve