TAMU ESSM 351 - Lab03--Instructions (17 pages)

Previewing pages 1, 2, 3, 4, 5, 6 of 17 page document View the full content.
View Full Document

Lab03--Instructions



Previewing pages 1, 2, 3, 4, 5, 6 of actual document.

View the full content.
View Full Document
View Full Document

Lab03--Instructions

51 views


Pages:
17
School:
Texas A&M University
Course:
Essm 351 - Geog Info Sys Res Mgmt
Geog Info Sys Res Mgmt Documents
Unformatted text preview:

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 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 Lab 3 Sea Level Rise Activity 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 used Page 2 Lab 3 Sea Level Rise Activity 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 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 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 Page 3 Lab 3 Sea Level Rise Activity 17 Excel should automatically draw a break line for each column You need to delete 3 of those lines by double clicking each line i e where the three red arrows point to in the Before picture below In other words double click to delete lines 4 5 and 8 so that the range of years is properly shown as one column The standard error e g 0 05 should also be in one column Once completed your columns would be properly divided as in the After picture Make sure that the data shows up correctly Otherwise you will encounter more problems when working with ArcGIS later on Before After 18 Click Next 19 Click Finish You should now have 14 columns in the Excel table 20 Right click the row number on the first row to insert a new row above it select Insert Page 4 Lab 3 Sea Level Rise Activity 21 In the newly inserted row type in column names Refer to the webpage to find the column headings for your dataset We will use …


View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Lab03--Instructions and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Lab03--Instructions and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?