LAB 3Sea Level Rise ActivityThis assignment is to be completed individually.Learning Objectives:Learning Materials:Before you being, be sure to download Lab03.zip file (from eCampus) and extract the file to your appropriate local drive.Downloading XY Coordinate DataImporting Excel Table Data into ArcMapClick OK.InterpolationAdding a Mask and Interpolation around a MaskWe now need to add a mask to your interpolated map since the map shows the sea level rise trend, so showing the in-land data (of countries around the world) would not make much sense and can distract from the main focus–of showing the sea level rise t...Making the Final MapTo Turn in for Lab Assignment 3LAB 3 Sea Level Rise Activity This assignment is to be completed individually. Learning Objectives: • Download XY coordinate data • Manage database in Excel • Import database into ArcMap • Interpolation • Add a mask Learning Materials: Relevant topic materials are available on eCampus under this week’s link. *** Make note of answers to any questions raised in this lab document. It is also recommended that you read Lab Questions 3 assignment to learn about the lab questions before beginning the lab. That way you can concurrently answer the questions or make a note of potential answers as you move forward with the lab. You will need to use ArcGIS to answer lab questions. NOTE: • Always save your work in an appropriate local drive where you have write access to (i.e. where you can save, edit, and access the file when needed) and keep saving all your course files there. If you are working on your computer, it is best to save files to your computer hard drive. If you are working on other computer (e.g. in a computer lab), please save all files in an external/flash drive. See Lab00b document on Downloading Data and Working with Zip Files. • Make note of the directory/location of the file so that you do not lose track of it. The instructions will refer to the drive as “local drive.” *** DO NOT let the program save your work to a default geodatabase folder (ending with .gdb), unless the instructions ask you to do so ***Lab 3 – Sea Level Rise Activity Page 2 In this lab, we will be working to manage a database that can be used with GIS. First, you will acquire the database from an online source. Then, you will learn to manipulate and import the database into GIS. Remember that with GIS, you can work with different types of data and file formats. Being able to manipulate and connect the data from different sources with GIS will allow for you to have more flexibility in working with data and being able to efficiently use data for your subject of interest. *** Remember: the directory you are saving course files to should be kept short (e.g. Drive:\GIS\Lab03 for Lab 3 files). Lengthy directory can sometimes cause error when running certain applications. Folder and file names should also be under 13 characters and contains no space or special characters (e.g. #$%&). If needed, you can use underscore instead of the space, e.g. Lab_01 (or Lab01), NOT Lab 01. Before you being, be sure to download Lab03.zip file (from eCampus) and extract the file to your appropriate local drive. Downloading XY Coordinate Data 1. Open your Internet Browser. 2. Go to http://www.psmsl.org/. Read and understand what PSMSL is. 3. Click the Products tab. 4. Click GLOSS Station Handbook on your left. 5. Click the link “GLOSS” in the middle of the page (http://www.gloss-sealevel.org/). a. What is GLOSS? b. What is the main component of GLOSS? c. How many sea level stations are there around the world? d. What is the stations’ main purpose? 6. Go back to the PSMSL home page (http://www.psmsl.org/) and click the Products tab. 7. Click the link “Derived Trends” on your left to navigate to the “Relative Sea Level Trends” page (http://www.psmsl.org/products/trends/). 8. Now the Relative Sea Level Trends interactive map shows up on the page. Read the information on the page and play with tools, Zoom in and out of the map (using +/- tab on the bottom right). Hover over different locations around the world–click and drag your mouse to move to different parts of the map. Where in the U.S. the sea level rises most (> +4 mm/yr)? – zoom to the U.S. map and click different arrow colors to see the trends. The dark red arrow indicates the highest change in trend (sea level rises highest over the time). What is the relative sea level trend in Galveston from 1900 to 2015? 9. Scroll down to the bottom and click “A table of long term trends” to open the link to data. You should now see the data organized in the following data columns. a. PSMSL Station code b. GLOSS code (if a GLOSS station) c. Number of years of data used to compute the trend d. Range of years usedLab 3 – Sea Level Rise Activity Page 3 e. Trend and standard error in mm/year f. Standard deviation of the residual variability about the fitted trend line in mm g. The number of years of data required to calculate a trend with an uncertainty of 1.0mm/yr, 0.5mm/yr and 0.1mm/yr, according to the fitted data model h. Latitude i. Longitude j. Country code k. Station Name You will arrange these data in Excel spreadsheet to be used later. 10. Copy data from the website (click at the far left of row #1 and drag the mouse to highlight the entire data – ends at Id 2316. Then, release the mouse click, right-click and select Copy or press Ctrl+C). 11. Open Microsoft Excel. 12. In Excel, click the Home tab at the top of the page and click Paste. 13. Click the Data tab. 14. Click Text to Columns. This will open the Convert Text to Columns Wizard dialog box. 15. Under ‘Choose the file type that best describes your data,’ choose Fixed width. 16. Click Next >. *** WARNING!!! Be sure to highlight and copy the entire data. Start clicking the mouse at the leftmost position of row #1 (NOT at number "1" but farthest to the left of the data webpage). Notice the image below on where you should start clicking and highlighting the data. Failure to properly copy over the data will result in missing and misaligned data in later steps, followed by a delay and an issue for you to move forward. See also the Copy and Organize Database VDO (in Lab 3 folder on eCampus) for an illustration on this process.Lab 3 – Sea Level Rise Activity Page 4 17. Excel should automatically draw a break line for each column. You need to delete 3 of