1 / 27

Abstract

Visualization of the CReSIS Greenland Datasets for the PolarGrid High Performance Computing System . Abstract.

svein
Download Presentation

Abstract

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Visualization of the CReSIS Greenland Datasets for the PolarGrid High Performance Computing System

  2. Abstract The Center for Remote Sensing of Ice Sheets (CReSIS) has been compiling Greenland ice sheet thickness data since 1993. The airborne program utilizes a 150 MHz radar echo sounder to measure the ice thickness. The data is currently available on the CReSIS web site in various formats including PDF, Matlab, and plain text files. These formats are not usable in the classroom environment as a visual representation of the ice depth for each expedition. During the Undergraduate Research Experience in Ocean, Marine and Polar Science 2009 program, the Greenland Data Visualization Team took the CReSIS data and created a 4-D visualization consisting of depth, time, latitude, and longitude. This visualization was created utilizing HTML, JavaScript, and PHP. Microsoft Excel was used to filter the raw data downloaded from the CReSIS site. The team then statistically analyzed the Greenland ice sheet thickness data for calculated, missing, and actual depth readings. The goal of this project was to present the CReSIS data via the web in a visual format to elementary, undergraduate, and graduate students for research and education. This visualization package and corresponding data will eventually be migrated to the Elizabeth City State University Polar Grid High Performance Computing System. The research that follows involved converting plain text files to comma separated values to be used by PHP and JavaScript to produce data visualizations in Google Maps and HTML pages.

  3. Overview

  4. Data Visualization & Terminology

  5. Excel

  6. Project Phases

  7. Phase One • Download files • Storage on flash drive or personal computers

  8. Phase Two Added Columns • Index • Date • Comment

  9. Phase Three New Longitude formula: =(E1-360) Replace -999 or NAN to 0 formula: =IF((D1=“0”),”0”-(D1)) Comment in column J formula: =IF((D1=“0”),”M”,IF((I1=“CALCD”), “C”, “A”))

  10. Phase Four Combine files into one folder

  11. Phase Five Sort by time and redo index

  12. Line Graph Phase Six =IF(sheet name_05!$A2/ROUNDUP(COUNT(sheetname_05!$A:$A)/32000,0)=INT(sheet name_05!$A2/ROUNDUP(COUNT(sheet name_05!$A:$A)/32000,0)),sheet name_05!A2,"")

  13. Scatter Plot

  14. Flight Plan May 30, 2002 data of flight

  15. Phase Seven • Copy phase five • Recorded and analyze • Count for actual, calculating , and missing lines Formula: =COUNTIF(J:J,”A”)

  16. Phase Eight • Copy phase five folder • Reduce to 200 lines Formula: =IF(S1$A1/ROUNDUP(COUNT(S1!$A:$A)/200,0)=INT(S1!$A1/ROUNDUP(COUNT(S1!$A:$A)/200,0))1!A1””)

  17. Phase Nine • Deleted columns A, E, H, and I • Replace “p” (paragraph mark ) with ^p for PHP

  18. Phase Ten • Remove calculations and formulas from excel • Delete A, E, H, and I again • Overwritten, Producing In Google Map

  19. Final Product Flight Paths http://mmt.cs.ecsu.edu/pgdataviz/pg-data-set-flightlines.php 4-D Visualization http://mmt.cs.ecsu.edu/pgdataviz/pg-data-set-request.php Data Downloads http://mmt.cs.ecsu.edu/pgdataviz/dd.php

  20. Outcome

  21. Depth Type

  22. Future Work • 2008- Present- Future data could can be utilized to produce a more accurate visual of what is happening to the now. • Antarctic Data- The calculation of lost ice could be compared to see if there is the same amount of loss or if the climate is changing differently in the two locations. • Excel Macros-In phases IV and VII macros were used to perform some of the tedious task. In phase IV the task was to combine the data by days. Since there were multiple files per day, Visualization is used often in the area of teaching, research, and development. • Standardized Data Collection Format CReSIS used different formats, which made out work more challenging by précising the information together. • At some point the data will be moved to a high computing cluster at ECSU. This cluster will be able to handle the data faster. The high computer cluster will be located in the E.V. Wilkins Building on the ECSU campus.

  23. Acknowledgments Dr. Linda B. Hayden Jeff Wood CERSER CReSIS

  24. References • http://serc.carleton.edu/introgeo/mathstatmodels/UsingXL.htm • (https://www.cresis.ku.edu/research/data/greenland_data.htm • Greenland Data Sets,CReSIS,2009- https://www.cresis.ku.edu/research/data/greenland_data.html • Climate Change,CReSIS,2008- https://www.cresis.ku.edu/news/documents/ClimateChangeFAQ.pdf • Microsoft Excel, 2007 http://office.microsoft.com/en- us/Excel/default.aspx [5] Roman, Steven. Writing Excel Macros with VBA. O'Reilly Media, Inc, 2002. • Microsoft, "VBA for Excel". Microsoft. 2008 http://www.Excel- vba.com/Excel-vba-contents.html.

More Related