University of Nevada Las Vegas (UNLV) College of Civil Engineering
CEG 468/668 GIS Applications in Civil Engineering
Syllabus for the Spring 2006 Semester
http://www.ce.unlv.edu/Courses/CEG_468/cee468s06.html
http://www.ce.unlv.edu/~jensenf/cee468s06.html


To ensure your viewing the latest agenda, fresh the cache in your web browser by either 1) holding down the shift and clicking fresh with your mouse, or 2) Ctrl-F5 on the keyboard


Introduction, Location, Software, Expectations, & Learning Objectives
Grading
Term Projects
Student Email & Seating
ESRI Virtual Campus Access Codes
GIS Tutorial Workbook
Reading Assignments and Quizes
ArcGIS Creationism
Class 1: Tuesday 17 Jan 2006   homework
Class 2: Tuesday 24 Jan 2006   homework
Class 3: Tuesday 31 Jan 2006   homework
Class 4: Tuesday 7 Feb 2006   homework
Class 5: Tuesday 14 Feb 2006   homework
Class 6: Tuesday 21 Feb 2006   homework
Class 7: Tuesday 28 Feb 2006   homework
Class 8: Tuesday 7 Mar 2006   homework
Class 9: Tuesday 14 Mar 2006   homework Holiday - Spring Break (Mar 12-18) for UNLV
Class 10: Tuesday 21 Mar 2006   homework
Class 11: Tuesday 28 Mar 2006   homework
Class 12: Tuesday 4 April 2006   homework
Class 13: Tuesday 11 April 2006   homework
Class 14: Tuesday 18 April 2006   homework
Class 15: Tuesday 25 April 2006   homework
Class 16a: Tuesday 2 May 2006   Term Project Presentations (1 of 2): Study (a.k.a. Dead) Week
Class 16b: Thursday 4 May 2006   Term Project Presentations (2 of 2): Study (a.k.a. Dead) Week
Class 17: Tuesday 9 May 2006 at 8:10pm  Final Exam
References
Sources of GIS data
GIS data
Miscellaneous materials

Introduction: Instructor, Grad Assist, & Lab Monitors

Location and Time

UNLV College of Engineering Room TBE-B367 (Computers: 32 for students & 1 for instructor)
Tuesday nights, 7:00-9:30PM

Objective

Make Great Civil Engineers. To develop sufficient knowledge in each student on how to use, gather, and create spatial data to solve problems in civil engineering.

Prerequisites

CEG 201, and any one of CEG 362, 334, 452, 453

Textbook-Required

Getting to Know ArcGIS desktop, 2nd Edition
by Tim Ormsby, Eileen Napoleon, Robert Burke, Carolyn Groess, and Laura Feaster
ISBN 1-879102-89-7
GIS Tutorial: Workbook for ArcView 9
by Wilpen L. Gorr and Kristen S. Kurland
ISBN 1-58948-127-5

Textbook-Recommended

Microsoft Access 2002: Level 1 computer training courseware. Clark County University, licensed from CustomGuide, Inc. 1502 Nicollet Ave, Minneapolis MN 55403. 888-903-2432. www.customguide.com
Microsoft Access 2002: Level 2 computer training courseware. Clark County University, licensed from CustomGuide, Inc. 1502 Nicollet Ave, Minneapolis MN 55403. 888-903-2432. www.customguide.com

Software-Required

Software-Recommened

Instructor's Expectations from Students

Student's Expectations from Instructor

Learning Objectives - what the students learn is more important than what the instructor teaches


Classroom format, grading, homework, exams

Description Percentage Number Assignments Assignment Worth Total Points
GIS Tutorial Workbook Exercises 20% 9 20 180
Quizes 4% 2 18 36
ESRI Virtual Campus 16% 12 12 144
Lecture Homework 20% 12 15 180
Term/Class Project 20% 1 180 180
Final Exam 20% 1 180 180
Total 100%     900

Grade Percentage Range Minimum Points
A 100%-93% 837
A- 92%-89% 801
B+ 88%-86% 774
B 85%-82% 738
B- 81%-79% 711
C+ 78-74% 666
C 73%-69% 621
C- 68%-65% 585
D 64%-60% 540
F 59%-0% <531

Term Project

Schedule for Initial Interview

will be held in B367. Objective is to discuss your interests and develop a theme for the term project. Interviews will be 15 minutes for each group, 10 minutes for each student.

Interview Agenda

Example Term Project Ideas

  1. 3D Map UNLV building footprints
  2. Conversion of Soils Data from NRCS
  3. Create storm drain layer
  4. Class Term Project. Demonstrate knowledge in apply ArcView 9 to solve problems in civil engineering. Deliverables are a 15 minute presentation and handouts (e.g. maps, background information, slides, notes, etc.). Project can be done as a group or individually. Shashi Nambisan and Thomas Piechota have offered to help identify possible projects.

Term Project Grading Metric

Student (team leader in bold) Term Project Interview Date Appointment Time
Nathan Hall, Raul Valdez, and Jocelin Rice Tuesday, 24 January 2006 8:15pm
Jennifer Nuesca, Kevie Remynse, and Christopher Gonzales Tuesday, 24 January 2006 8:15pm
Brian Wasserman, Todd Gardener, Brian Kalina, and Jarah Parke Tuesday, 24 January 2006 8:30pm
Xiaohui Jin and Medhanie Tecle Tuesday, 24 January 2006 8:30pm
Keith Letus, Holly McNaught, and Jon Seeley Tuesday, 24 January 2006 8:45pm
Gang Xie, Yanjie Chen, and Peris Nyagah Tuesday, 24 January 2006 8:45pm
Ferrin Affleck, Lindy Pennington and Tahmineh Zenhari Tuesday, 24 January 2006 9:00pm
  Tuesday, 24 January 2006 9:00pm
  Tuesday, 24 January 2006 9:15pm

Spring 2006 Term Project Titles

Team Members Term Project Title Term Project Description
Nathan Hall, Raul Valdez, and Jocelin Rice Drainage Basin Delineation and Hydrologic Characteristics Map  
Jennifer Nuesca, Kevie Remynse, and Christopher Gonzales   Plot parks of city of Henderson and see if there is a park 1 mile from all homes. If not, propose new parks and locations
Brian Wasserman, Todd Gardener, Brian Kalina, and Jarah Parke    
Xiaohui Jin and Medhanie Tecle    
Keith Letus, Holly McNaught, Christiana Astarita, and Jon Seeley UNLV - Building Parking and WIN (Where It's Needed)  
Gang Xie, Yanjie Chen, and Peris Nyagah    
Ferrin Affleck and Pak Ho Cheung Roadway and Parcel Map Interface Between AutoCAD and ArcMap  
Bisrat Alemayehu, Lexido de los Santos, and Darren Groth Analysis of the Transporation System for the area of Green Valley  
Scott Fergurson    
Jakkri Suttanuruk    
Madalena Choi, John McAvoy, and Doug Terrill Underground Utilities Locator Using GIS data to create a database to locate manholes, waterlines, and sewerlines

Student Email Address, UNLV username, Engineering Mailbox, and Seating Assignment

>
CEE 468
UnderGrad Name Email username Mailbox #
Ferrin Affleck FerrinAffleck@earthlink.net AffleckF 45
Bisrat Alemayehu hailubisrat@hotmail.com bhailu  
Christiana Astarita astarita@co.clark.nv.us    
Pak Ho Cheung samuelcheung29@hotmail.com cheungp  
Madalena Choi choim02@hotmail.com Choim  
Lexido De Los Santos lexidodelossantos@yahoo.com    
Scott Ferguson scottiefergs@cox.net Fergus06  
Todd Gardner Garddog21@msn.com gardne24  
Christopher Gonzales Christobal31@gmail.com Christog  
Nathan Hall Nathanh@vtnnv.com halln  
Brian Kalina kalinab@unlv.nevada.edu Kalinab  
Keith Letus Kletus@lasvegasnevada.gov Kletus  
John Mcavoy mcavoyj@egr.unlv.edu mcavoyj  
Holly McNaught hsbandit@yahoo.com    
Jennifer Nuesca jnuesca@egr.unlv.edu nuesca  
Jarah Parke insaneboardn@yahoo.com jparke  
Lindyben Pennington lindypenn2005@yahoo.com penningz 149
Kevie Remynse Kevie@remynse.com remynse  
Jacelyn Rice jahcelyn@gmail.com jimce  
Jonathan Seeley seeleyj@unlv.nevada.edu, seejon@gmail.com seeley  
Douglas Terrill sirsolar13@hotmail.com dterrill  
Raul Valdez Rvaldez702@excite.com    
Brian Wasserman Bwasserman@lasvegasnevada.gov Wasserm3  
Tahmineh Zenhari tzenhari@gmail.com singlet2  
CEG 668
Grad Name Email username Mailbox #
Yanjie Chen cheny17@unlv.nevada.edu cheny17  
Jakkri Suttanuruk JakkritS@alphaengineeringlv.com    
Darren Groth drgroth11176@yahoo.com    
Xiaohui Jin xiaohui@egr.unlv.edu jinx2 79
Peris Nyagah nyagahp@unlv.nevada.edu    
Medhanie Tecle medghet@yahoo.com medhanit  
Gopalan Vishnan Gvishnan@hotmail.com    
Gang Xie xieg@unlv.nevada.edu xieg  

CEG 468/668 Group Seating Assignment


ESRI Virtual Campus

ESRI Virtual Campus Courses available for UNLV students contact instructor to obtain the course access code

INSTRUCTIONS FOR STARTING A COURSE:
-------------------------------------------------
Step 1: SIGN IN
Go to http://campus.esri.com. If you are already a Virtual Campus member, sign in with your member login and password. If you are not a member, click "Join now" under Member Sign-In and complete the form to become a member.

Step 2: START A COURSE WITH YOUR COURSE ACCESS CODE
Click "My Courses" on the left side of the page. Type your 14-character Course Access Code, and click "Add to My Courses." The title of the course will appear in your course listing.

Step 3: GO TO CLASS
In your course listing, click on the course title to begin. A list of the course modules is displayed along with other course information.

If you have any questions, go to Campus SUPPORT at http://campus.esri.com/campus/support, and check the FAQs or use the Contact Us link, http://campus.esri.com/campus/support/contact us.

Thank you!

The ESRI Virtual Campus Team
http://campus.esri.com

Virtual Campus License Codes will be passed out at first class


Sample Module Completion Ribbon

How to print the module ribbon of completion some time after its been completed

ESRI Virtual Campus


         

GIS Tutorial Workbook

Table of Contents


         

Textbook Assignment

Quizes Reading Assignments

How To Remember What You Just Read

How to use Excel to Randomly select a student to take the quiz

Getting To Know ArcGIS Desktop Quiz Questions


ArcGIS Creationism: How to create features in ArcGIS


         

Class 1: Tuesday, 17 Jan 2006

Class Introduction

GIS Process

Software Tour


         

Class 1 Homework

Administrative

ESRI Virtual Campus: Learning ArcGIS 9

Term/Class Project

Reading Assignment

ArcView Homework


         

Class 2: Tuesday, 24 Jan 2006

Guest Speaker: none

Class working directory

The GIS 4 Step Solution Process

Overview of GIS

GIS Tabular Data

  1. Flat files
  2. Relational Database Management Systems (RDMS)
  3. Object Database

GIS Data Types/Features

  1. Points
  2. Lines/Arcs/Polyline
  3. Polypolylines/Routes
  4. Polygons
  5. Polypolygons/Multipart Features
  6. Regions
  7. Text/Annotation
  8. Raster Images
  9. Map Elements (a.k.a. map objects, map components)
  10. Paperspace/Layouts vs. Modelspace/Data Views
  11. Coordinates
  12. Table Attributes
References: [Vance 00 p. 115] and [MapGuide R5 p. 91]

Getting to Know ArcGIS Desktop: Chapter 1

  1. Primary ArcGIS Supported Spatial Files
  2. Map Legend/Table Of Contents (TOC)
  3. Coordinate Systems
  4. Scale
  5. Features
  6. TIN Surfaces
  7. Raster Surfaces/GRIDs/Images
  8. Thematic Maps
  9. Topology

Getting to Know ArcGIS Desktop: Chapter 2

  1. ArcGIS Desktop consists of ArcView, ArcEditor, and ArcInfo

Exploring ArcMap

[Ormsby 00, Chapter 3]

Tools Toolbar

  1. Zoom
  2. Select Features
  3. Select Elements
  4. Identify Tool
  5. Find Tool
  6. Measure Tool
  7. Hyperlink Tool

Map Tips

Layers/Themes

Data Frames


         

Class 2 Homework

ESRI Virtual Campus: Learning ArcGIS 9

Term/Class Project

Reading Assignment

GIS Tutorial Workbook - Tutorial 1 Exercises - Turn in the following:

  1. Printout of the map for Exercise 1-1.
  2. Printout of the map for Exercise 1-2.
  3. Printout of the data document for Exercise 1-1 and 1-2.

Classroom ArcView 9.x Homework


         

Class3: Tuesday, 31 Jan 2006

Term Project Interviews

How to create random x,y,z coordinates using Excel

 

Getting to Know ArcGIS Desktop: Chapter 4 Exploring ArcCatalog

ArcCatalog

Adding data to ArcMap

Searching for Map Data

Importing files into geodatabase tables using ArcCatalog

 

Getting to Know ArcGIS Desktop: Chapter 18 - Making Maps Quickly

Templates

How to Create an ArcMap Plotter independent map template

Layout Toolbar

Logos and Pictures

Getting to Know ArcGIS Desktop: Chapter 19 - Making Maps for Presentation

Basic Map Elements to include on Maps

Scale Bar Map Elements

Comparison of Data Frame/Viewports in layouts between CAD & GIS

Size and Position of Data Frames

Title Map Element

Text Map Element

Printing


         

Class 3 Homework

ESRI Virtual Campus: Learning ArcGIS 9

Term/Class Project

GIS Tutorial Workbook - Tutorial 2 Exercises - Turn in the following:

  1. Printout of the map for Exercise 2-1.
  2. Printout of the map for Exercise 2-2 showing just the city of Pittsburg zoom extent.
  3. Answer the two questions at the end of Exercise 2-2.

Reading Assignment

ArcView Homework



         

Class 4: Tuesday, 7 Feb 2006

Guest Speakers(s)

: none

ArcMap Graphics: Points, Lines, Circles, Polygons, Rectangles

Create Overview Data Frame (a.k.a. index, vicinity, location, or key map)

How to create an exact copy of an Overview Window in a data frame

  1. Select Data Frame from the Insert menu.
  2. Rename the data frame to 'Overview'
    1. Right click on the Data Frame in the ArcMap Table of Contents
    2. Select Properties
    3. Switch to the General tab
    4. Type the new name in the Name field
    5. Click Apply and OK
  3. Create an extend rectangle for the Overview data frame
    1. Right click on the data frame and select Properties
    2. Switch to the Extent Rectangles tab
    3. Select a Data Frame from the 'Other data frames' list
    4. Click the right arrow button
    5. Click Apply and OK
  4. Select Tools -> Styles -> Style Manager...
  5. Expand the ESRI.Styles folder and select the Background subfolder
  6. Right click in the right hand window and select New -> Normal Background
  7. Click the Change Symbol button on the Background dialog box
  8. Click the Properties button on the Symbol Selector dialog box
  9. Select Line Fill Symbol from the Type dropdown list
  10. Change the angle field to 45 degrees
  11. Select Red from the Color dropdown
  12. Click the Outline button
  13. Select Red from the Color dropdown and click OK
  14. Click Apply and OK on all dialog boxes
  15. Rename the new style to 'Overview' and close the Style Manager
  16. Right click the Overview data frame and select Properties
  17. Switch to the Extent Rectangles tab
  18. Click the Frame button
  19. Switch the Outline to None and switch the Background to the new Overview background
  20. Click Apply and OK on all dialogs. Once you arrange your Layout view you should see something like the following image.

Add x,y coordinate data to ArcMap

Creating Point Layer from x,y values in a table using ArcCatalog

Create x,y,z features in ArcCatalog

Event Tables

Using ArcMap with Relative Path Names

Map Documents (.mxd)


         

Class 4 Homework

ESRI Virtual Campus: Learning ArcGIS 9

Term/Class Project

GIS Tutorial Workbook - Tutorial 3 Exercises - Turn in the following:

  1. Printout of the map for Exercise 3-1.
  2. Printout of the map for Exercise 3-2.

Reading Assignment

Homework


         

Class 5: Tuesday, 14 Feb 2006

Getting to Know ArcGIS Desktop: Chapter 5 - Symbolizing features and rasters

Symbols and Styles

Creating Marker Symbols

Symbols by Attributes

Using Interstate Shields

Compare Aerial Photo Images

ArcMap Images

Guest Speakers(s)

none

         

Class 5 Homework

ESRI Virtual Campus: Learning ArcGIS 9

Term/Class Project

GIS Tutorial Workbook - Tutorial 3 Exercises - Turn in the following:

  1. Submit Tutorial 3: 1) Printout of the map for Exercise 3-1 and 2) Printout of the map for Exercise 3-2
  2. Assigned: nothing

Reading Assignment

Homework


         

Class 6: Tuesday, 21 Feb 2006

ArcScene and 3D Analyst Extension

Using Spatial Analyst in ArcMap to create an elevation relief

  1. Spatial Analyst setup
  2. Custom ArcMap Color Ramp for Shaded Reliefs - jjensen.style. Can install from any location, I keep mine with the other styles that ship with ArcMap (c:\arcgis\arcexe83\bin\Styles\). To install in ArcMap: Tools -> Styles -> Style Manager... then click the Styles drop down menu. On the very bottom is Add... When you reopen ArcMap this custom style will be missing so to make it permanent, copy the style into your custom styles (c:\documents and settings\jjensen\Application Data\ESRI\ArcMap\jjensen.style)
  3. Add DEM (e.g. use Clark Clark DEM projected in stateplane coordinates, ccdemspcszft.tif) to ArcMap. Use above Color Ramp to symbolize.
  4. Hillshade
  • Note: if image file is in a different projection, remember that ArcMap can project raster images on the fly. So, ensure the Data Frame project is the one you desire, then add the raster data, ArcMap will reproject it automatically.
  • See How to make a layer draw partially transparent, ESRI Article ID 18073
  • USGS Digital Elevation Model (DEM)

    USGS National Elevation Dataset

    Options To Clip Raster Images

    Getting to Know ArcGIS Desktop: Chapter 9 - Joining and relating tables

    Database Relationships

    Relate Tables

    Join Tables

    Raster Image Processor (RIP)

    Reference Systems: Grids and Graticule

    Paper Size

    Review transferring data files from UNLV to home/work




             

    Class 6 Homework

    ESRI Virtual Campus: Learning ArcGIS I

    Term/Class Project

    Reading Assignment

    GIS Tutorial Workbook - Tutorial 4 Exercises

    1. Nothing Assigned Last Week
    2. Assigned: Tutorial 4: Printout of the map for Exercise 4-1 and 4-2

    Homework


             

    Class 7: Tuesday, 28 Feb 2006

    Guest Speakers(s)

    none

    ArcInfo Interchange files (.e00)

    Getting to Know ArcGIS Desktop: Chapter 6 - Classifying features and rasters

    Classifying Features and Rasters

    Quantitative Scaled Symbology

    1. Graduate Color
    2. Graduate Symbol
    3. Proportional Symbol
    4. Dot Density

    Classification methods

    Symbology Charts

    Understanding Classification Histogram

    US Census and TIGER/Line

    Hierarchical Geographic Entities

    TIGER/Line Issues

    Census 2000 Redistricting Summary Issues

    How to obtain TIGER/Line data

    Census Links

    Shapefiles of US Census Blocks

    Census 2000 Summary File 1 (SF 1)

    Import Census 2000 Redistricting Files

    How to join TIGER/Line with Census 2000 Redistricting Files

    Population Density


             

    Class 7 Homework

    ESRI Virtual Campus: Learning ArcGIS I

    Term/Class Project

    Reading Assignment

    GIS Tutorial Workbook - Tutorial 5 Exercises

    1. Submit: Tutorial 4 Exercise printouts
    2. Assigned: Tutorial 5: Printout of the map for Exercise 5-1 and 5-2 and the 2 questions for Exercise 5-1.

    Homework


             

    Class 8: Tuesday 7 Mar 2006

    Guest Speakers(s)

    none

    Reference Scale for Data Frames

    Civil Engineering Textstyle Standards and Conversions
    Textstyle, 1000th of an inch Layout Height, inches Layout Height, points Reference Scale Data View/Modelspace Height, feet Data View/Modelspace Height, unitless
    L120 120/1000 = 0.12 0.12*72 = 8.64 approximately 9 1 inch = 40 feet (1:480) 0.12*40 = 4.8 0.12*480 = 57.6
    L100 100/1000 = 0.10 0.10*72 = 7.2 approximately 7 1 inch = 40 feet (1:480) 0.10*40 = 4 0.10*480 = 48
    L80 80/1000 = 0.08 0.08*72 = 5.76 approximately 6 1 inch = 40 feet (1:480) 0.08*40 = 3.2 0.08*480 = 38.4
    L60 60/1000 = 0.06 0.06*72 = 4.32 approximately 4 1 inch = 40 feet (1:480) 0.06*40 = 2.4 0.06*480 = 28.8
    L40 40/1000 = 0.04 0.04*72 = 2.88 approximately 3 1 inch = 40 feet (1:480) 0.04*40 = 1.6 0.04*480 = 19.2
    LX X/1000 = Xinches Xinches*point conversion (1 inch = 72 points) scale (unitless scale) Xinches*scale Xinches*unitless scale

    Getting to Know ArcGIS Desktop: Chapter 7 - Labeling features

    ArcGIS Options working with Text

    Dynamic Labeling

    Dynamic Labeling - Placing Labels

    Dynamic Labeling: ArcMap Formatting tags

    Dynamic Labels: Stacked Labels and more

    Dynamic Labels with VBScript Functions

    Dynamic Labels: Label Methods

    Dynamic Labels: Label Priorities

    Dynamic Labels: Draw Toolbar Label Options

    Map Document Annotation: Layout View

    Map Document Annotation: Data View

    Map Document Annotation: Data View - Creating New

    GeoDatabase Annotation: Standard Annotation

    GeoDatabase Annotation: Feature Linked

    ArcInfo Coverage Annotation

    Dimension Features

    Fonts


             

    Class 8 Homework

    ESRI Virtual Campus: Learning ArcGIS I

    Term/Class Project

    Reading Assignment

    GIS Tutorial Workbook

    1. Submit: Tutorial 5
    2. Assigned: none

    Homework


             

    Class 9: Tuesday, 14 Mar 2006

    Guest Speakers(s)

    none

    Enjoy your Spring Break, no class this week


             

    Class 9 Homework

    ESRI Virtual Campus: Learning ArcGIS II

    Reading Assignment

    Term/Class Project

    Homework


             

    Class 10: Tuesday, 21 Mar 2006

    Guest Speakers(s)

    none

    Data Downloads - GIS data section

    Getting to Know ArcGIS Desktop: Chapter 8 - Querying Data

    7 ways to query features

    How to Query Graphics

    How to query Raster Surfaces

    How to query TIN Surfaces

    1. Identify

    2. Selecting Features Interactively

    3. Selecting Features by Attribute

    SQL Comparsion Geodatabase, Shapefile, and Coverage

    SQL Comparison of GDB, SHP, Coverage queries
    Operator Field Type Geodatabase Shapefile Coverage Notes
    Field names all enclose in square brackets[ ] enclose in double quotes, " " enclose in double quotes, " " field names are enclosed in [] or ""
    LIKE Text [STRNAME] like 'maryland' "STRNAME" LIKE 'MARYLAND' "STRNAME" LIKE 'MARYLAND' case sensitive for shp and coverage
    Equal, = Text [STRNAME] = 'maryland' "STRNAME" = 'MARYLAND' "STRNAME" = 'MARYLAND' case sensitive for shp and coverage
    Equal, = Numeric [SCLQA] = 25 "SCLQA" = 25 "SCLQA" = 25 case sensitive for shp and coverage
    multiple Wildcard, * or % Text [STRNAME] like 'maryl*' "STRNAME" like 'MARYL%' "STRNAME" like 'MARYL%' will match any group of characters
    Single Wildcard, ? or _ Text [STRNAME] like 'Marylan?' "STRNAME" like 'MARYLAN_' "STRNAME" like 'MARY_AND' will match a single character
    Range of values, - Text [STRNAME] like '[m-p]*' "STRNAME" like '[M-P]%' "STRNAME" like '[M-P]%' selects street names starting with M, N, O, and P
    Less than, < Text [STRNAME] < 'maryland' "STRNAME" < 'M%' "STRNAME" < 'M%' comparison based on alphabetical order
    Not equal to, <> Text [STRNAME] <> 'maryland' "STRNAME" LIKE 'MARYLAND' "STRNAME" LIKE 'MARYLAND' select everything but Maryland
    Between Numeric [SCLQA] between 10 and 30 not available not available same as 10 <= [SCLQA] <= 30
    IN Text [STRNAME] IN ('maryland', 'flamingo', 'swenson', 'tropicana') not available not available can do the samething with the OR operator
    NULL Text and Numeric [SCLQA] IS NOT NULL "SCLQA" IS NOT NULL "SCLQA" IS NOT NULL used when field values are not entered
    NOT NULL Text and Numeric [SCLQA] IS NOT NULL "SCLQA" IS NOT NULL "SCLQA" IS NOT NULL field values are entered
    Date Date [Datefield] = #mm-dd-yyyy# [Datefield] = date 'yyyy-mm-dd' [Datefield] = date 'yyyy-mm-dd' dates often stored with time

    5. Selecting Features by Graphics

    6. Finding Features

    7. Map Tips

    Selectable Layers

    Hyperlinks

    Creating Reports

    Review - Reports and Joins


             

    Class 10 Homework

    ESRI Virtual Campus

    GIS Tutorial Workbook - Tutorial 6 Exercises

    1. Assigned: Tutorial 6 Exercise printouts, turn in printout of exercise 6-1 and 6-2 next week.

    Reading Assignment

    Term/Class Project

    Homework


             

    Class 11: Tuesday, 28 March 2006

    Guest Speakers(s)

    none

    Data Downloads - GIS data section

    Definition Queries

    Getting to Know ArcGIS Desktop: Chapter 10 - Selecting features by location

    Spatial Relationships

    Select by Location

    Spatial Joins

    Creating Point Features from Polygon Centroid Features

    Example Spatial Join: Assign closest bus stop to each parcel


             

    Class 11 Homework

    ESRI Virtual Campus

    Reading Assignment

    GIS Tutorial Workbook

    Term/Class Project

    Homework


             

    Class 12: Tuesday 4 April 2006

    Guest Speakers(s)

    none

    Data Downloads - GIS data section

    Getting to Know ArcGIS Desktop: Chapter 11 - Preparing data for analysis

    Chapter 11 Topics

    Dissolving Features

    Graphs

    Exporting Data

    Create a new layer based on a selection set

    Getting to Know ArcGIS Desktop: Chapter 12 - Analyzing Spatial Data

    Buffer

    Buffer Tools

    Buffer Applications

    Vignette

    Geoprocessing Wizard

    Merge Adjacent Layers

    Clipping Layers

    Overlays

    Calculating Attribute Values


             

    Class 12 Homework

    ESRI Virtual Campus

    Reading Assignment

    GIS Tutorial Workbook

    Term/Class Project

    Homework


             

    Class 13: Tuesday, 11 April 2006

    Important News: Ching will be teaching the class today

    Agenda:

    1. Turn in Class 12 homework
      • Any Module, from Any Virtual Campus Course, of your Choice not previously turned in
      • Exercise 8-1 and 8-2 Map and 7 Questions (4 from 8-1 and 3 from 8-2)
      • In-class homework
      • Term Project: Conclusion
    2. No Quiz
    3. Previous homeworks turned back.
      • Grading sheet available after class to check against missing homeworks or other issues.
      • Address all GIS Tutorial workbook questions with Ching.
      • Address all other assignment questions with Jeff.
    4. Class 13 Lecture available as exercise per separate link here.
    5. Class 13 Homework
    6. Open lab and questions

    Click here to goto the class 13 page.


     

    Getting to Know ArcGIS Desktop: Chapter 14 - Building geodatabases

    Geodatabase

    Geodatabase Geometry Types

    Geodatabase X/Y Domain

     

    ArcMap Editing


             

    Class 13 Homework

    ESRI Virtual Campus

    Reading Assignment

    Homework

    Class Project

    Homework


               

    Class 14: Tuesday, 18 April 2006

    Guest Speakers(s)

    none

    Data Downloads - GIS data Section

     

    Getting to Know ArcGIS Desktop: Chapter 13 - Projecting data in ArcMap

    When adding data to ArcMap, will sometimes get a warning message "One or more layers is missing spatial reference information, Data from those layers cannot be projected"

    Map Projections

    How to Project Geodatabases and Shapefiles

    Define a Shapefile's Projection

    Define a ArcInfo Coverage's Projection

    Define a GeoDatabase feature class Projection

    Common Coordinate Systems used in Clark County NV

    Define Local/Surface Coordinate Projection in ArcMap

  • Alternative method is to Define a Projection using ArcToolbox
  • Transformation

    Indepth Discussion on Projections

    Export Geodatabase to AutoCAD drawing file (.dwg)

    ArcGIS 9.1 CAD Field Definitions

    ArcMap Field Name CAD Staging GDB Table Field Type Field Length CAD Applications(s) Short Description Effect on 'Export To CAD' tool
    EntID Attrib Long 4 Both ArcGIS created unique entity identifier and foreign key Not Used
    OwnerID Attrib Long 4 Both ArcGIS created parent entity key Not Used
    AttrFlag Attrib Long 4 Both Tag and Attribute visibility flag Not Used
    SetName Attrib String 255 Both AutoCAD Blockname, Microstation Set Name Not Used
    AttrTag Attrib String 64 Both Tag or Attribute name Not Used, but if a valid tag value is a field name then that field's value will be inserted into the block attribute of an inserted block that has a matching tag name
    AttrHndl Attrib String 17 Both AutoCAD internal identifer Not Used
    AttrType Attrib Long 4 Both Microstation Tag field type, AutoCAD is always a string Not Used
    AttrStr Attrib String 255 Both An Attribute's value converted to a string Not Used
    AttrLong Attrib Long 4 Both An Attribute's value converted to a long integer Not Used
    AttrDbl Attrib Double 8 Both An Attribute's value converted to a real number Not Used
    DocID CADLayer Long 4 Both ArcGIS identifier for CAD file in the CAD Staging GDB CADDoc table Not Used
    LyrName CADLayer String 255 Both CAD Layer name A valid value will control the CAD layer of the output feature
    LyrNum CADLayer Long 4 Both The Microstation V7 or previous level number Not Used
    LvlDesc CADLayer String 255 Both The Microstation V7 or previous level description Not Used
    LyrColor CADLayer Short 2 Both CAD Layer default color A valid value used in conjunction with the 'LyrName' field will set the layer color of a CAD layer not already defined in the output CAD file
    LyrLineWt CADLayer Short 2 Both CAD layer default line weight A valid value used in conjunction with the 'LyrName' field will set the layer line weight of a CAD layer not already defined in the output CAD
    LyrLnType CADLayer String 255 Both CAD layer default line type A valid value used in conjunction with the 'LyrName' field will set the layer line type of a CAD layer not already defined in the output CAD file
    LyrFrzn CADLayer Short 2 AutoCAD Only CAD layer freeze/thaw value for visibility A valid value used in conjunction with the 'LyrName' field will set the layer line type of a CAD layer not already defined in the output CAD file
    LyrLock CADLayer Short 2 AutoCAD Only CAD layer freeze/thaw value for visibility A valid value used in conjunction with the 'LyrName' field will set the layer line type of a CAD layer not already defined in the output CAD file
    LyrOn CADLayer Short 2 Both CAD layer On/Off value for selectability A valid value used in conjunction with the 'LyrName' field will set the layer line type of a CAD layer not already defined in the output CAD file
    LyrVPFrzn CADLayer Short 2 AutoCAD Only CAD layer default viewport freeze/thaw parameter Not Used
    LvlPlot CADLayer Short 2 Both CAD layer plotting order A valid value used in conjunction with the 'LyrName'field will set the layer line type of a CAD layer not already defined in the output CAD file
    LyrHandle CADLayer String 16 Both CAD maintained internal identifier for the CAD layer Not Used
    EntID Entity Long 4 Both ArcGIS created unique entity identifier and foreign key Not Used
    DocID Entity Long 4 Both ArcGIS created identifier for CAD file in the CAD staging GDB CADDoc table Not Used
    OwnerID Entity Long 4 Both ArcGIS created parent entity key Not Used
    CadType Calculate = "Text" for converting annotation to output TEXT entities. Calculate = "Polyline" to convert polylines. Calculate to "3D Polyline" to create Z-aware output Entity String 32 Both CAD element/entity type A valid value overrides the default output entity type with a valid alternative
    NumLevel Entity Long 4 MicroStation Only V7 or prior level number Not Used
    Color Use CAD color numbers Entity Short 2 Both CAD color number A valid value will override the default entity color of the output feature
    LineWt Has no effect on Export to CAD, either to AutoCAD or Microstation Entity Short 2 Both CAD Line weight value A valid value will control the line weight of the output feature
    Layer Calculate records with suitable values in this field for Layer Names in the output CAD file Entity String 255 Both CAD entity layer name A valid value will override the default entity layer name of the output feature
    Handle Entity String 16 Both CAD created entity internal identifier Not Used
    RefName If Elevation attribute exists in the data, assign RefName as the Alias for the attribute. The Z-aware output polylines will store the Z-values. Entity String 255 Both CAD entity Block name/Hatch name/Cell Name/Tag name or Text Value A valid value will override the default entity name of the output feature
    Class Entity String 255 MicroStation Only CAD element class designation A valid value will override the default class designation of the output feature
    Linetype calc to "3D Polyline" for Z-aware output Entity String 255 Both CAD entity line type A valid value will override the default entity line type of the output feature
    LTScale calc to the line weight value desired in the output DGN file Entity Double 8 Both CAD entity line type scale A valid value will control the line type scale of the output feature
    Width Entity Double 8 Both CAD entity line width A valid value will override the default entity line width of the output feature
    Thickness Calculating this value passes the line thickness to the output AutoCAD file Entity Double 8 Both CAD entity thickness A valid value overrides the default entity thickness of the output feature
    Rotation Entity Double 8 Both CAD entity rotation A valid value override the default entity rotation of the outpu "point-type" features
    CadModel Entity String 255 MicroStation Only CAD Model Name A valid value override the default entity model in which the output feature is created
    ExtX Entity Double 8 AutoCAD Only CAD entity extrusion vector component in the X coordinate Not Used
    ExtY Entity Double 8 AutoCAD Only CAD entity extrusion vector component in the Y coordinate Not Used
    ExtZ Entity Double 8 AutoCAD Only CAD entity extrusion vector component in the Z coordinate Not Used
    ScaleX Entity Double 8 AutoCAD Only CAD entity X component of scale value A valid value overrides the default entity scale X component of block inserts for an output feature
    ScaleY Entity Double 8 AutoCAD Only CAD entity Y component of scale value
    ScaleZ Entity Double 8 AutoCAD Only CAD entity Z component of scale value A valid value overrides the default entity scale Z component of block inserts for an output feature
    QrotX Entity Double 8 MicroStation Only CAD X component of the quaterian rotation value A valid value overrides the default X component of the quaterian rotation value for an output feature
    QrotY Entity Double 8 MicroStation Only CAD Y component of the quaterian rotation value A valid value overrides the default Y component of the quaterian rotation value for an output features
    QrotZ Entity Double 8 MicroStation Only CAD Z component of the quaterian rotation value A valid value overrides the default Z component of the quaterian rotation value for an output feature
    EntID Mslink Long 4 MicroStation Only ArcGIS created unique entity identifier and foreign key Not Used
    Linktype Mslink Long 4 MicroStation Only MSLink type value Not Used
    DBType Mslink String 128 MicroStation Only MSLink database type Not Used
    MSCatID Mslink Long 4 MicroStation Only Microstation Catalog table record number that contains the name of the table that the MSLink value points to Not Used
    MSLink Mslink Long 4 MicroStation Only Microstation record number of attached data or other coded value Not Used
    MSLink2 Mslink Long 4 MicroStation Only Microstation Catalog table record number that contains the name of the table that the MSLink value points to Not Used
    MSValue Mslink String 255 MicroStation Only Microstation record number of attached data or other coded value as a string Not Used
    EntID CADText Long 4 Both ArcGIS created unique entity identifier and foreign key Not Used
    TxtValue CADText String 255 Both First 255 Characters of a text entity string A valid value overrides the default height of an output text feature
    TxtMemo Calculate = "TextString" value in the geodatabase annotation feature class CADText String 2147483647 Both Entire CAD text string  
    TxtHt CADText Double 8 Both CAD text entity height A valid value defines the value of an output text feature
    TxtRotate CADText Double 8 Both CAD text entity rotation A valid value overrides the default rotation of an output text feature
    TxtWidth CADText Double 8 Both CAD text entity width factor Not Used
    TxtOblique CADText Double 8 Both CAD text entity oblique angle Not Used
    TxtGenType CADText String 32 Both CAD text entity ??? Not Used
    TxtJust CADText String 32 Both CAD text entity justification parameter Not Used
    VertAlign CADText String 32 Both CAD text entity vertical alignment parameter Not Used
    TxtStyle CADText String 255 Both CAD text entity style A valid value overrides the default text style of an output text feature
    TxtFont CADText String 255 Both CAD text entity font Not Used
    TxtBoxHt CADText Double 8 Both CAD text entity bounding box height Not Used
    TxtBoxWd CADText Double 8 Both CAD text entity bounding box width Not Used
    TxtRefWd CADText Double 8 Both CAD Multi-text width factor Not Used
    TxtAttach CADText Long 4 Both CAD Multi-text Attachment parameter Not Used
    TxtDir CADText Long 4 Both CAD Multi-text entity line spacing type Not Used
    LnSpace CADText Long 4 Both CAD Multi-text entity line spacing type Not Used
    SpaceFact CADText Double 8 Both CAD Multi-text entity spacing factor Not Used
    EntID XTRProps Long 4 AutoCAD Only ArcGIS created unique entity identifier and foreign key Not Used
    XDList XTRProps String 2147483647 AutoCAD Only XML string of coded Xdata values and their types A properly formated XML string will create coded Xdata on output features (see the create CAD Xdata tool)
    DocName CADDoc String 255 Both CAD file name without full path Not Used
    DocPath CADDoc String 2147483647 Both CAD file name with full path A valid value overrides the default output CAD file of an output feature, unless the IGNORE PATHS IN TABLE parameter is set
    DocType CADDoc String 255 Both CAD file type: (AutoCAD, Microstation, DXF) A valid value overrides the default CAD file type of an output feature if the output CAD file in the included 'DocPath' field does not exist.
    DocVer CADDoc String 16 Both CAD file version A valid value overrides the default CAD file version of an output feature if the output CAD file in the included 'DocPath' field does not exist.
    Using the Set CAD Alias Tool: When converting annotation feature classes to CAD set the alias for TEXTSTRING to RefName. This converts the annotation to TEXT entities in the output CAD file. Set the Alias for the field containing suitable layer names to "Layer"

     

    Getting to Know ArcGIS Desktop: Chapter 15 - Creating Features

    ArcMap Edit Session

    Improve Speed of Editing

    Snapping Environment

    Creating Features from other Features

    Creating Features using ArcMap

    Traverse - Quadrant Bearing Measurements

    Traverse Tool (ArcEditor and ArcInfo only)

    Attribute Domains

    Subtypes


             

    Class 14 Homework

    ESRI Virtual Campus

    Reading Assignment

    GIS Tutorial Workbook

    Term/Class Project

    Homework


             

    Class 15: Tuesday, 25 April 2006

    Guest Speakers(s)

    none

    Data Downloads - GIS data Section

     

    Geocoding

    Geocoding Applications

    Geocoding Service

    Interactive Geocoding

    Batch Geocoding - Shapefile (dbf)

    Batch Geocoding - Geodatabase (mdb)

    ZIP codes

    Microsoft Access Database Review 2

    Simple Access Database Queries Using Filters

    Access Tables and Fields

    Elevation Contours

    Creating Contours

    Symbolize Contours

    Triangulated Irregular Network (TIN) Surface

    TIN Attributes

    Create a TIN from sample point feature/mass points/survey shots

    Creating TIN surfaces from vector data

    Edit a TIN

    Cut/Fill Analysis using a TIN

    Compare TIN surface to GRID surface

    Cut-and-Fill Analysis


             

    Class 15 Homework

    ESRI Virtual Campus

    Reading Assignment

    GIS Tutorial Workbook

    Term/Class Project

    Homework


             

    Class 16: Tuesday, 2 May 2006

    Guest Speakers(s)

    none

    Extra Credit

    Spring 2005 Term Project Presentations

    Presentation Time and Date Team Members Term Project Title Term Project Description
    6:40pm, Tuesday 2 May 2006 Medhanie Tecle & Xiaohui Jin Runoff Flows  
    7:00pm, Tuesday 2 May 2006 Student evaluations
    7:20pm, Tuesday 2 May 2006 Darren Groth, Lexido del los Santos & Bisrat Alemayehu    
    7:40pm, Tuesday 2 May 2006 Ferrin Affleck & Pak Ho Cheung    
    8:00pm, Tuesday 2 May 2006 Madalena Choi, John McAvoy & Doug Terrill    
    8:20pm, Tuesday 2 May 2006 Nathan Hall, Jacelin Rice, & Raul Valdez    
    8:40pm, Tuesday 2 May 2006 Christopher Gonzales, Kevie Remynse & Jennifer Nuesca    
    9:00pm, Tuesday 2 May 2006 Jon Seeley, Keith Letus, Holly McNaught & Christina Astarita    
    9:20pm, Tuesday 2 May 2006 Brian Kalina, Todd Gardner, Brian Wasserman, Jarah Parke    
    9:40pm, Tuesday 2 May 2006 Gang Xie, Peris Nyagah & Yanjie Chen    

    Class 16 Homework

    ESRI Virtual Campus: Learning ArcGIS 3D Analyst, or Learning ArcGIS Spatial Analyst or Introduction to Visual Basic for ESRI Software

    Reading Assignment

    Homework


             

    Class 16b: Thursday, 4 May 2006

    Guest Speakers(s)

    none

    Extra Credit

    Spring 2005 Term Project Presentations

    Presentation Time and Date Team Members Term Project Title Term Project Description

             

    Class 16b Homework

    ESRI Virtual Campus: Learning ArcGIS 3D Analyst, or Learning ArcGIS Spatial Analyst or Introduction to Visual Basic for ESRI Software

    Reading Assignment

    Homework


             

    Class 17: Tuesday, 9 May 2006, 8:10PM

    Final Exam must be submitted to both Jeff and Ching via email

    Spring 2006 Final Exam is ready as of 5:30pm on Wed, 3 May 2006

    1. Given this traverse text file (FinalExamTraverse.txt), create a line feature class by loading this traverse into ArcMap (hint: ArcMap Advanced Editing -> Traverse option). The traverse will draw a CEE468/CEG668 student's first name. What is the student's name?
    2. Create a point feature class or Add X/Y Event layer from this dBase IV file (FinalExamXY.dbf). What letter(s) do these points form?
      • Learning Objective: Students can create point features from a database using geocoding and the Add X/Y method
    3. Create elevation contours from the following digital elevation model (DEM) finaldemunlv.img, finaldemunlv.img.xml, finaldemunlv.rrd. This DEM has elevation units of meters. Using either the 3D Analyst or Spatial Analyst extensions, generate elevation contours with an interval of 50 meters, base contour of 500 meters and z factor of 1. How many 50 meter elevation contours are created?
      • Learning Objective: Students can create surfaces/digital terrain models (DTM) and contours
    4. Determine which FEMA LOMR revised the FEMA FIRM panel which contains UNLV?
      • Background: The Clark County Regional Flood Control District (CCRFCD) maintains a GIS layer of all the current Flood Zones in Clark County Nevada. The flood zone boundaries are often revised by Civil Engineers to increase the amount of usable land for development by the construction of detention basins and/or concrete channels to contain the flooding. FEMA requires a Letter of Map Revision (LOMR) to be submitted by the Civil Engineer once the flood control structures are constructed. Then FEMA will reduce the width of the flood zone and revise the FIRM panel.
      • All FEMA published FIRM panel maps and LOMRs can be downloaded in pdf format from CCRFCD, under District Documents then select 'Flood Insurance Rate Maps' or 'Letter of Map Revision' folders.
      • All FEMA FIRM panels for Clark County can be downloaded from CCRFCD in shapefile or coverage format. For this problem download the following: panel.shp panel.dbf panel.prj panel.sbn panel.sbx panel.shp.xml panel.shx
      • All the LOMR revised areas have been converted to shapefiles and can also be downloaded from CCRFCD. For this problem download the following: lomr.shp lomr.dbf lomr.prj lomr.sbn lomr.sbx lomr.shp.xml lomr.shx
      • Using the panel and lomr shapefiles, which FIRM panels (field name is PANEL in panel.shp) have been revised by LOMR Case Number 02-09-718P (field name is CASE_NO in lomr.shp)?
    5. Determine the number of points selected within a buffer/selecting by location/selecting by attribute/exporting data.
      • Given this shapefile ( FinalExamGISpts.shp, FinalExamGISpts.dbf, FinalExamGISpts.shx, FinalExamGISpts.sbn, FinalExamGISpts.prj, FinalExamGISpts.sbx) Select the point feature class which ID = 0 (ID is the field name). Should have 2 points selected. Select all points within an 8 mile buffer of these 2 selected points.
      • Part 1 - How many points are selected?
      • Part 2 - Export the selected points from Part 1. Select points with an attribute value, ID = 18. Should have just 1 point selected. Then select all points within an 8 mile buffer of this single point. How many points are selected?
      • Learning Objective: Students can perform spatial analysis/buffers/overlays/spatial joins within ArcMap
    6. Give the URL of 3 agencies (e.g. Federal, State, or Local Govt) where you can obtain GIS data? (5 pts)
      • Learning Objective: Students know the various agencies where they can obtain GIS related data
    7. Create an ArcMap layout with only the following:
      • Map Page Size: 1) ensure Use Printer Paper Settings is unchecked, 2) width = 36 inches, 3) height = 24 inches, Orientation = Landscape
      • Data Frame Size: 1) position data frame x=1" and y=1" from the lower left corner, 2) width = 34 inches, 3) height = 22 inches
      • Add the DEM image from the previous question, finaldemunlv.img, finaldemunlv.img.xml, finaldemunlv.rrd.
      • Set the data frame scale in layout view to 1:20,000. Manually center the image within the data frame.
      • Do NOT add any marginalia
      • Export the map to PDF. Set resolution to 300 dpi, output image quality to Normal (ratio 1:3).
      • What is the file size of this PDF, in KB? Note if you add any other features, the filesize will be off.
        • Learning Objective: Students can create plots in ArcMap and know how to add layers, text labels and symbolize features
    8. Metadata is data about/beyond data. One piece of the metadata is the projection. What is the projection and datum for the US Census Cartographic Boundary Files -> Traffic Analysis Zones (TAZ)?
      • Learning Objective: Students know what metadata is and how to use it
    9. From the lecture, 5 methods or ways where discussed to perform queries in ArcMap. What are 4 or them? (5 pts)
      • Learning Objective: Students can query and join tables in a tabular database
    10. Marginalia (e.g. north arrow, legend, scale bar, and so on) is added to the Data View (a.k.a. ModelSpace) or the Layout View (a.k.a. PaperSpace)?
      • Learning Objective: Students can create plots in ArcMap and know how to add layers, label and symbolize features
    11. A blank data frame inherits the projection parameters of the first feature added to it? True or False.
    12. Convert this ArcInfo Interchange file (e00example.e00) to a coverage. Display the arc feature (not tic feature) in ArcMap. Using the LINEWIDTH field, symbolize the feature. LINEWIDTH=0 color=white. LINEWIDTH=1 color=red, width=3. What word does the red lines spell?


    Thanks for your patience and all the best in your Civil Engineering Careers.

    Jeff & Ching
           
             

    References

    [ArcGIS White Paper] - ArcGIS 8.1 An ESRI White Paper. January 2001.
    [Bagui 02] - Learning SQL A Step-by-Step Guide Using Access by Sikha Bagui & Richard Earp. ISBN: 0-321-11904-5. Access the latest information about Addison-Wesley titles
    [Flynn 97] - INSIDE ArcInfo, 2nd Edition by Jay Flynn & Teresa Pitts. ISBN: 1-56690-194-4
    [Madsen 95] - Civil Drafting Technology, 4th Edition by David A. Madsen and Terence M. Shumaker. ISBN: 0-13-087155-9
    [MapGuide R5] - Autodesk MapGuide Release 5 User's Guide
    [Ormsby 01] - Getting to Know ArcGIS desktop by Tim Ormsby, Eileen Napoleon, Robert Burke, Carolyn Groess, and Laura Feaster. ISBN 1-879102-89-7
    [Shaner 00] - Editing in ArcMap by Jeff Shaner and Jennifer Wrightsell. ISBN 1-879102-97-8
    [Vance 00] - INSIDE AutoCAD Map 2000, 3rd Edition by Dylan Vance, Ray Eisenberg and David Walsh. ISBN: 1-56690-193-6
    [Frerichs 98] - Roadway Design: Using GIS to streamline and improve highway planning and design. Wade N. Frerichs and James R. West.
    [Cuomo 99] - A Topography Review: Surveying Principles for Civil Engineers by Paul A. Cuomo, P.L.S. February 1999 issue of CE News
    [Dewberry 98] - The practice of land development: Planning, engineering, surveying, and more by Sidney O. Dewberry, P.E., L.L.S., and John Hummel, P.E.
    [TCRP Report #60] - Using Geographic Information Systems for Welfare to Work Transportation Planning and Service Delivery: A Handbook (TCRP Report #60) (2000) Part A, Part B,Case Studies
    [Quickzone] - Quick Zone - A New Work Zone Delay Estimation Tool. Contact Deborah Curtis, FHWA Office of Operations Research & Development, (202) 493-3267, Deborah.Curtis@fhwa.dot.gov
    [Crook 92] - How to Remember Names by Dr. Thomas Crook. ISBN 0-06-016628-2. First Edition, 1992.
    [MUTCD] - Manual of Uniform Traffic Control Devices (MUTCD)
    [ESRI GDB Lecture 01] - Creating and Managing Geodatabases (for ArcEditor 8 and ArcInfo 8), Course Lectures. GIS Education Solutions from ESRI. June 2001.
    [ESRI GDB Exercises 01] - Creating and Managing Geodatabases (for ArcEditor 8 and ArcInfo 8), Course Exercises. GIS Education Solutions from ESRI. June 2001.
    [ESRI Edit ArcMap 02] - Editing in ArcMap. ArcGIS 8.3 Version Documentation. Contributing Writers: Bob Booth, Jeff Shaner, Scott Crosier, Phil Sanchez, and Andy MacDonald. ISBN 1-58948-062-7
    [ESRI 3D Analyst] - Using ArcGIS 3D Analyst. Contributing Writers: Bob Booth. ISBN 1-58948-004-X
    [Musciano 00] - HTML & XHTML The Definitive Guide, 4th Edition by Chuck Musciano & Bill Kennedy
    [Hutchinson 04] - Inside ArcView GIS 8.3 by Scott Hutchinson. ISBN: 0-7668-3475-1
    [CustomGuide 01] - Microsoft Access 2002: Level 1 and Level 2. CustomGuide.com, 2001. 1502 Nicollet Ave. Minneapolis MN 55403. 888-903-2432.
    [CCPW Survey] - Clark County Surveyor's Benchmark Book. Provides Elevation Data in the Las Vegas Valley, units meters, North American Vertical Datum 1988 (NAVD88). Can download the complete Benchmark Book in PDF. Summary "Because of localized subsidence in the Las Vegas Valley, the benchmark elevations from the 1992 County Vertical Control Network, together with elevations published by the cities of Las Vegas, North Las Vegas, and Henderson are no longer completely reliable. Accordingly, the County Surveyor sought to standarize and coordinate the upgrading of this critical design criteria. The County Surveyor's work involved re-running the primary Clark County Vertical Control Circuits from the latest National Geodetic Survey (NGS) control, adjusting the remaining circuits and tying them to each of the cities' data, which was also adjusted based on the North American Vertical Datum of 1998." (Clark County General Information Report, GIR No. 0380)

             

    Sources of GIS data

    Bureau of Land Management

    Robert "Bob" Taylor, GIS Coordinator (also on the GPS Lead team for Las Vegas)
    Bureau of Land Management, Las Vegas Field Office
    4701 N Torrey Pines Dr
    Las Vegas NV 89130
    Voice: 702-515-5051
    Fax: 702-515-5023
    Email: robert_taylor@nv.blm.gov
    Comments: has a staff of 3 people. GIS data uses UTM Zone 11, Units Meters, Datum NAD27 projection. Maps based on BLM survey records, USGS DLG, and a Section Township Range coverage.

    United States Federal Forests

    Toiyabe National Forest Spring Mountain National Recreation Area
    4701 N Torrey Pines Dr
    Las Vegas NV 89130-2301
    Contacts: Scott Ewers, Lands & Special Uses. Voice: (702)515-5440, Fax: (702)515-5499, Email: mewers@fs.fed.us
    Lance Dutton, Engineer, Email: ldutton@fs.fed.us, Voice: (702)515-5419

    GIS people in Ogden UT. Roberta Quigley (801)625-5188, GIS Coordinator

    Humboldt-Toiyabe National Forest GIS Contacts: Dave McMorran 1200 Franklin Way
    Sparks NV 89431
    Voice Direct: (775)355-5388, Voice main: 775-355-5301, Email: dmcmorran@fs.fed.us

    Pacific West Region (Washington, Oregon, Idaho, California, and Nevada)
    National Forest Boundaries, metadata, ArcInfo e00. Projection: Geographic, Units: Decimal Degrees, Datum: NAD27 (according to Dan Thompson 801-975-3441).

    Red Rock Canyon National Conservation Area

    Red Rock Canyon National Conservation Area
    Boundary created by Clark County Comprehensive Planning staff:
    Ron Gregory-Federal Lands Coordinator (702-455-3121, rgy@co.clark.nv.us) and
    Ralph Spear-GIS Analyst (702-455-4181, res@co.clark.nv.us)
    ESRI Shapefiles (redrockbnd.shp, redrockbnd.dbf, redrockbnd.shx, redrockbnd.prj). Stateplane Coordinates, Nevada East Zone, Units Feet, NAD83.

             

    Download GIS data

  • Example Datasets
  • Sample Data


             

    Miscellaneous Materials

    Class Objective:

    discuss how to create point features from a text file or a table

    Handout

    Questions and Answers from last week

    Tables

    Questions and Answers from last week

    Can we get access codes for the Programming with Avenue virtual campus course?

    Create List of Styles

    Geographic Names Information System (GNIS)

    Conversion of GNIS text file to ArcView shapefile

    1. In the past file was zipped/compressed, so download nv_deci.gz, use WinZip to unzip (gunzip) file, rename file-give .txt extension
    2. Open nv_deci.txt in a text editor, add the following as the first record (this will be the field names) "STATE","FEATURENAME","FEATURETYPE","COUNTY","STATECODE","COUNTYCODE","LATYDMS",
      "LONGXDMS","LATYDD","LONGXDD","SRCLATYDMS","SRCLONGXDMS","SRCLATYDD","SRCLONGXDD","ELEV",
      "POP","FEDSTATUS","CELLNAME" (see the Readme file for complete names)
      • Use the FeatureName field as an Auto-Label
      • Cell Name is the 7.5min quad map name
    3. From ArcView Project Menu, select Table icon, then Add button. Browse to the nv_deci.txt
    4. In ArcView View window, View -> Add Event Theme... Table=nv_deci.txt X field=longxdd Y field=latydd
    5. Query Builder, select County="Clark"
    6. Save the selected GNIS points for Clark County as a new shapefile, Theme -> Convert to Shapefile... gniscc.shp, click Yes to add shapefile to the view
    7. Project GNIS points from Lat/Long NAD27 to Stateplane Nevada East zone NAD83 feet. Might have to load the File -> Extensions -> Projection Utility Wizard, then File -> ArcView Projection Utility...
    8. All done, just use Theme -> Auto-label... to display the Feature Name attributes, insert an aerial photo or Digital Elevation Model (DEM) and you have successfully labelled the mountains, rivers, etc.

    Misc Data

    Viewing CAD files in ArcMap

    Parks, Forests and Trails within Clark County, NV


    Contacts


       

    Show/Hide Un-Revised