University of Nevada Las Vegas College of Civil & Environmental Engineering


CEE 468/668 GIS Applications in Civil Engineering (Summer 2007)

CEE 468/668 - GIS Applications in Civil Engineering

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

Section 0: Table of Contents

Table of Contents

Calendar of Lecture Topics, Guest Speakers and Assignments

Section 1: Syllabus

Instructor Biography

Teaching Assistant(s)

Mission Statements

Civil and Environmental Engineering Mission Statement

It is the mission of the department to produce quality civil engineering graduates with technical and management skills that meet or exceed the expectations of industry, government and graduate programs.

CEE 468/668 Mission Statement

To make great civil engineers! To provide the knowledge and tools necessary to help aid them in civilizing the wilderness. To help the Civil Engineer to Create, to Achieve, to have Success.

CEE 468 Course Relationship with UNLV College of Engineering Program Outcomes

Learning Objectives

CEG_468 Course Learning Objectives

Upon successfully completing this course, the student will be able to perform the following:

  1. Students knowledge they apply the GIS tool to solve problems
  2. Students can create plots in ArcMap. Know how to add layers, label & symbolize features
  3. Students can generate reports from a tabular database
  4. Students can query & join tables in a tabular database
  5. Students can perform spatial analysis/buffers/overlays/spatial joins within ArcMap
  6. Students can create a tabular & spatial databases (i.e. geodatabase)
  7. Students can create accurate features (i.e. points, polygons, & lines) using coordinate geometry (COGO) editing tools
  8. Students can create point features from a database using geocoding and the Add X/Y method
  9. Students know what metadata is and how to use it
  10. Students know the various agencies they can obtain GIS related data from
  11. Students can use raster data such as aerial photos
  12. Students can create surfaces/digital terrain models (DTM) and contours

Instructor's Expectations from Students

Student's Expectations from Instructor

Software

Software-Required

Software-Recommened

MapGuide

Hydrology Software

Textbooks

Textbook-Required

Textbook-Recommended

Class Roster

CEE 468
Student Name Email Picture
ALEMU, ZELALEM ALEMUZ@UNLV.NEVADA.EDU
AMATO, JOHN AMATOJ@UNLV.NEVADA.EDU
BARENG, SARAH BARENGS@UNLV.NEVADA.EDU
Show picture
BOLTON, CHRISTOPHER CBOLTON@UNLV.NEVADA.EDU
COBB, CHRIS COBBC4@UNLV.NEVADA.EDU, cobblv@yahoo.com
COLE, SARAH LANGELIE@UNLV.NEVADA.EDU, sarah_ann_cole@yahoo.com
FEICA, DIANNA FEICAD@UNLV.NEVADA.EDU
FREY, GLENN FREYG3@UNLV.NEVADA.EDU
GLORIANI, ARLENE GLORIANI@UNLV.NEVADA.EDU
GONZALEZ, EDUARDO GONZA132@NEVADA.EDU
GORDON, NICHOLAS GORDONN3@UNLV.NEVADA.EDU
HARRIS, DEREK HARRISD6@UNLV.NEVADA.EDU
MANGAOANG, FRANCIS MANGAOAN@UNLV.NEVADA.EDU, edwardthurman@aol.com
MEJIA, ERNESTO MEJIAE2@UNLV.NEVADA.EDU
MORGAN, RYAN MORGANR@UNLV.NEVADA.EDU
Show picture
MORRIS, ALVIN MORRIS47@UNLV.NEVADA.EDU, almo_4@yahoo.com
Show picture
NIKAIDO, CHAD NIKAIDO@NEVADA.EDU
NORCOTT, HESTON HNORCOTT@UNLV.NEVADA.EDU, hestongrr@gmail.com
OLDS, ROBERT OLDSR@UNLV.NEVADA.EDU
PETRIE, JOHN JPETRIE@UNLV.NEVADA.EDU, johnnypetrie@yahoo.com
PIPARO, TIMOTHY PIPARO@UNLV.NEVADA.EDU
RAJABDEEN, MOHAMED RAJABDEE@UNLV.NEVADA.EDU
Show picture
ROSS, TREVOR TROSS@UNLV.NEVADA.EDU
RUANGJUMRUSVET, CHANON RUANGJUM@UNLV.NEVADA.EDU , chanon13@hotmail.com
SEHDEV, VIKAS SEHDEVV@UNLV.NEVADA.EDU, beemsang@hotmail.com
THUNG, MICHELLE THUNGM@UNLV.NEVADA.EDU
THURMAN, EDWARD THURMANE@UNLV.NEVADA.EDU, edwardthurman@aol.com
VERON, WARREN VADA.EDU, warren2k_99@yahoo.com
CEE 668
Grad Name Email Picture
CHUNG,BACH SAN CHUNGB2@UNLV.NEVADA.EDU
KALSI,NITIN KALSIN@UNLV.NEVADA.EDU
LIAO,ELYSON LIAOE@UNLV.NEVADA.EDU

Computer Lab

Location and Time

UNLV College of Engineering Room TBE-B367 (Computers: 32 for students & 1 for instructor)
Tuesday, Thursday, and Friday nights, 6:00-8: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

Classroom format, grading, homework, exams

Classroom format

Grades Query from Login webpage

Grades Percentage

Description Percentage Number Assignments Assignment Worth Total Points
GIS Tutorial Workbook Exercises 25.2% 9 28 252
Quizes 5% 2 25 50
ESRI Virtual Campus 10.8% 12 9 108
Lecture (In Class) Homework 26% 13 20 260
Term/Class Project 18% 2 180 180
Final Exam 15% 1 150 150
Total 100% 1000

Grading Level and Criteria

Grade Percentage Range Minimum Points
A 100%-93% 930
A- 92%-89% 890
B+ 88%-86% 860
B 85%-82% 820
B- 81%-79% 790
C+ 78-74% 740
C 73%-69% 690
C- 68%-65% 650
D 64%-60% 600
F 59%-0% <600

Lecture Homework

Email Rules when submitting answers to homework assignments

Assignments

  • Lecture Homework for Class #1
    • Obtain UNLV Computer Account and Email (e.g. username@egr.unlv.edu or username@unlv.nevada.edu)
    • Create account on campus.esri.com
    • Enroll in all the provided virtual campus courses
    • Know how to Transfer files between home/work and UNLV. Recommend using SSH, NetStorage, USB Thumbdrive, email or burning a CD
    • Obtain Required Textbook
    • Email send an email from your preferred email account to cee468@egr.unlv.edu. Subject line must be as stated in the Email Rules above.
      • Attach a thumbnail picture of yourself
      • Email members of your term project group
  • Lecture Homework for Class #2
    • Obtain student version of ArcGIS from instructor
    • Create template for your own maps
    • Add the following layers to ArcMap: street centerline, city boundaries, RTC Monorail Terminals, & RTC Monorail
    • Zoom into the RTC Monorail area
    • From ArcMap - Data View, print the map (File -> Print). Write your name, date, and homework assignment#.
    • Read Chapter 1 and 2 of Getting to Know ArcGIS
    • Obtain ArcGIS CD from instructor - install on home computer if running Win2000 or XP
  • Lecture Homework for Class #3
    • Read Chapter 3 and 4 of Getting to Know ArcGIS
  • Lecture Homework for Class #4
    • Read Chapter 18 and 19 of Getting to Know ArcGIS
    • Create an ArcGIS map document template (.mxt) for this and future assignments. Add north arrow, neatlines, title, logo, and vicinity map. Paper size 8.5in by 11in, landscape.
    • Add point feature of 1000 random elevation points on the new UNLV Research and Technology Park
    • Create Surface and Contour based on these random points
    • Add the street centerline (SCL) geodatabase (streetcenterline.mdb), streets line feature class to the map.
    • Label the street using the strname field
    • Label the contour with altitude (value in Z field)
    • Export above layout as pdf and Email to cee468@egr.unlv.edu
  • Lecture Homework for Class #5
    • Read Chapter 5 of Getting to Know ArcGIS
    • Create an 8.5x11 map showing the following
    • Intersection California street and Wyoming street around Boulder City Hall. (These two streets should be selected or labeled with different color with other streets)
    • A short line on the northwest corner of the intersection to present the fire hydrant.
    • Show the aerial photo.
    • Export above layout as pdf and Email to cee468@egr.unlv.edu. Note if PDF is larger than 2mb, then change the resolution from 300dpi to 72dpi
  • Lecture Homework for Class #6
    • Create an 8.5x11 map showing the following stuff: traffic signals in Clark County
    • Add major streets (streets_l)
    • Intersection California street and Wyoming street around Boulder City Hall. (These two streets should be selected or labeled with different color with other streets)
    • Point on the northwest corner of the intersection to present the fire hydrant.
    • Show the aerial photo.
    • Export above layout as pdf and Email to cee468@egr.unlv.edu
    • In class mini termproject: Create 4 Boulder City benchmarks individually. Requirement: (1)Export the map (including your assigned 4 points) to PDF file; (2)Email your Personal GeoDatabase (named by BoulderCityBenchmarks_YourName.mdb) to cee468@egr.unlv.edu. Below is the benchmarks assigned table:

      In Class Mini Termproject Assignment

      • Student Name Assigned Benchmarks (OID) Status
      ALEMU, ZELALEM 1-4  
      AMATO, JOHN 5-8  
      BARENG, SARAH 9-11  
      BOLTON, CHRISTOPHER 12-15  
      COBB, CHRIS 16-19  
      COLE, SARAH 20-23 missing
      FEICA, DIANNA 24-27  
      FREY, GLENN 28-31 missing
      GLORIANI, ARLENE 32-35 missing
      GONZALEZ, EDUARDO 36-39  
      GORDON, NICHOLAS 40-43  
      HARRIS, DEREK 44-47 missing
      MANGAOANG, FRANCIS 48-51 missing
      MEJIA, ERNESTO 52-55  
      MORGAN, RYAN 56-59 missing
      MORRIS, ALVIN 60-63  
      NIKAIDO, CHAD 64-67 mistake with BM_NO and OID
      NORCOTT, HESTON 68-71  
      OLDS, ROBERT 72-75  
      PETRIE, JOHN 76-79  
      PIPARO, TIMOTHY 80-83  
      RAJABDEEN, MOHAMED 84-87  
      ROSS, TREVOR 88-91  
      RUANGJUMRUSVET, CHANON 92-95 OID 94 not accurate
      SEHDEV, VIKAS 96-99  
      THUNG, MICHELLE 100-103  
      THURMAN, EDWARD 104-107  
      VERON, WARREN 108-111  
      CHUNG,BACH SAN 112-115  
      KALSI,NITIN    
      LIAO,ELYSON 0  
  • Lecture Homework for Class #7
    • Create an 8.5x11 map showing the bus stops within 300 feet of parcel 16222.
    • Add a vicinity map
    • Export the map as pdf and Email to cee468@egr.unlv.edu. Note if PDF is larger than 2mb, then change the resolution from 300dpi to 72dpi
  • Lecture Homework for Class #8
    • Create a PDF of the map showing and labeling interstate highways (I-15 & US 95) with a shield marker containing the highway number. Email to cee468@egr.unlv.edu.
  • Lecture Homework for Class #9
    • Create a PDF showing the shortest path that the vehicle ran around the Las vegas Area. Email to cee468@egr.unlv.edu.
    • Create a PDF showing the your benchmarks in Boulder City. Email to cee468@egr.unlv.edu.
  • Lecture Homework for Class #10
    • none.
  • Lecture Homework for Class #11
    • Create a PDF showing the shortest path between Boulder City - City Hall and UNLV using the Major Streets (sclmajor) feature class. For the layout, use the 8.5x11 portrait template Email to cee468@egr.unlv.edu.
  • Lecture Homework for Class #12
    • Create a PDF of all the septic tanks within a buffer of 400 ft of the sewer lines in Green Valley; Create a report showing all these septic tanks.
    • Create a Map showing the parcels (IndexGrids.mdb) dissolved by Book No. and Section No. seperately. All the features that Section No. equal to 2 should be selected in the map of parcels dissolved by Section No.
  • Lecture Homework for Class #13
    • Email the Las Vegas future schools ploygon link to be published in the google map.
    • Email the Las Vegas Valley Layer added from "http://services.arcgisonline.com/v92" as PDF file.
  • Lecture Homework for Class #13
    • Email the map done in class as a PDF file.
  • Lecture Homework for Class #14
    • none
  • Lecture Homework for Class #15
    • none

    ESRI Virtual Campus

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

    UNLV Representative for ESRI Software and Virtual Campus Code Requests - Jaye Rodriguez, Agency Program Information Specialist II with Campus Computing Services. Email: jaye.rodriguez@unlv.edu, Tel 702-895-0736, Fax 702-895-0797

    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

    • Login to your Virtual Campus account
    • Go to the module that you completed and click the "completed" icon next to the module's name
    • For the course certificate of completion, go to "My Training History" or within the My Courses, click the icon on the top left "display my course status" and print the certificate from there.
    • Additional questions, contact Ann Paisalvejakam of ESRI Virtual Campus, campus@esri.com

    ESRI Virtual Campus

    • Required
      • Learning ArcGIS 9
      • The 15 Minute Map: Creating a Basic Map in ArcMap
    • Chose any 5 modules from any of the following virtual campus courses
      • ArcGIS Annotation: Tips and Tricks
      • Basics of the Geodatabase Data Model
      • Cartographic Design Using ArcGIS 9
      • Creating and Integrating Data for Natural Resource Applications
      • Creating and Maintaining Metadata Using ArcGIS Desktop
      • Creating and Editing Geodatabase Features with ArcGIS 9 (for ArcEditor and ArcInfo)
      • Creating and Editing Geodatabase Topology with ArcGIS 9 (for ArcEditor and ArcInfo)
      • Creating and Editing Labels and Annotation
      • Creating and Editing Linearly Referenced Features with ArcGIS 9
      • Creating, Editing and Managing Geodatabases for ArcGIS 9
      • Customizing ArcGIS 9
      • Customizing ArcIMS
      • Customizing ArcMap: Easy Ways to Extend the Interface
      • Editing Spatial Data in ArcMap: Tips and Tricks
      • Geoprocessing with ArcGIS Desktop
      • Georeferencing Rasters in ArcGIS
      • Getting Started with Surface Analysis using ArcGIS Spatial Analyst
      • Introduction to Visual Basic 6
      • Introduction to ArcScan for ArcGIS
      • Introduction to ArcView 3.x
      • Introduction to GIS Data ReViewer, Part II (for ArcEditor and ArcInfo)
      • Introduction to Map Production System Atlas
      • Introduction to Urban and Regional Planning Using ArcGIS 9
      • Labeling in ArcMap: Tips and Tricks
      • Learning ArcGIS 9 3D Analyst
      • Learning ArcGIS 9 Spatial Analyst
      • Learning ArcIMS
      • Learning Visual Basic for Applications for New ArcGIS Developers
      • Linear Referencing with ArcGIS Desktop
      • Migrating Coverages into the Geodatabase
      • Spatial Analysis of Geohazards Using ArcGIS 9
      • Storing Raster Data in an ArcSDE Geodatabase (for ArcEditor and ArcInfo)
      • Turning Data into Information Using ArcGIS 9
      • Understanding GIS Queries
      • Understanding Branching and Looping in VBA
      • Understanding Map Projections and Coordinate Systems
      • Using CASE Tools (for ArcEditor and ArcInfo)
      • Using ArcCatalog: Tips and Tricks
      • Working with CAD Drawings in ArcGIS
      • Working with Geodatabase Subtypes and Domains (for ArcEditor and ArcInfo)
      • Working with Forms in VBA
      • Working with Map Topology in ArcGIS
      • Working with Rasters in ArcGIS 9
      • Working with Survey Data in ArcGIS
      • Working with Variables and Functions in VBA

    ESRI Virtual Campus Homework

    Email module completion certificates to cee468@egr.unlv.edu with the subject line including your full name, class# virtual campus module

    1. Class #1
      • none
    2. Class #2
      • Learning ArcGIS 9 - Module 1 - Getting Started with ArcGIS
    3. Class #3
      • Learning ArcGIS 9 - Module 2 - Creating Map Symbology
    4. Class #4
      • Learning ArcGIS 9 - Module 3 - Referencing Data to Real Locations
    5. Class #5
      • Learning ArcGIS 9 - Module 4 - Organizing and Editing Data
    6. Class #6
      • Learning ArcGIS 9 - Module 5 - Creating and Editing Data
    7. Class #7
      • Learning ArcGIS 9 - Module 6 - Getting Started with GIS Analysis
    8. Class #8
      • Learning ArcGIS 9 - Module 7 - Working with Geoprocessing and Modeling Tools
    9. Class #9
      • Learning ArcGIS 9 - Module 8 - Designing Maps with ArcGIS
    10. Class #10
      • The 15 Minute Map: Creating a Basin Map in ArcMap
    11. Class #11
      • Any module in Any Virtual Campus
    12. Class #12
      • Any module in any virutal campus
    13. Class #13
      • Any module in any virutal campus

    Term Project

    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. Thomas Piechota have offered to help identify possible projects.

    Term Project Groups

    • Elyson Liao, Ernesto Mejia, Warren Veron
    • Chad Nikaido, Ryan Morgan
    • Bach San Chung, Chris Bolton, Derek Harris, Sarah Cole
    • Diana Feica, Nick Gordon, Sarah Bareng, Trevor Ross
    • John Petrie, Robert Olds, Tim Piparo
    • Mohamed Rajabdeen, Glenn Frey, Zelalem Alemu
    • Arlene Gloriani, Eduardo Gonzalez, John Amato, Vik Sehdev
    • Alvin Morris, Chris Cobb, Edward Thurman, Michelle Thung
    • Chanon Ruangjumrusvet, Heston Norcott, Francis Mangaoang

    Term Project Presentation Schedule (Date: August 10th, 2007, Friday)

    No. Time Schedule Group Memebers
    1 6:00pm-6:20pm Elyson Liao, Ernesto Mejia, Warren Veron
    2 6:20pm-6:40pm Chad Nikaido, Ryan Morgan
    3 6:40pm-7:00pm Bach San Chung, Chris Bolton, Derek Harris, Sarah Cole
    4 7:00pm-7:20pm Diana Feica, Nick Gordon, Sarah Bareng, Trevor Ross
    5 7:20pm-7:40pm John Petrie, Robert Olds, Tim Piparo
    6 7:40pm-8:00pm Mohamed Rajabdeen, Glenn Frey, Zelalem Alemu
    7 8:00pm-8:20pm Arlene Gloriani, Eduardo Gonzalez, John Amato, Vik Sehdev
    8 8:20pm-8:40pm Alvin Morris, Chris Cobb, Edward Thurman, Michelle Thung
    9 8:40pm-9:00pm Chanon Ruangjumrusvet, Heston Norcott, Francis Mangaoang
     

    Rules for Term Project

    • Purpose of Assignment - work on one project from beginning to end
    • Work together as a team
    • Email status of project to cee468@egr.unlv.edu
    • Email subject Line must contain Family Name (Last name) of each member, Class number, and Chapter number. Example Smith and Doe, Class #9, Chapter 4
    • Typically must attach a PDF of term project assignment
    • Alway use the same email account when submitting homework. Don't send email assignment from UNLV email account one week, next from a work email account, and then another time using a personal email account. Use one account only.
    • Item to email will identified below with the heading Email

    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

      • Discuss the interests of the student(s): 5 minutes
      • Brainstorm: 5 minutes to generate the most ideas (min. 3 ideas per person). Will write these down and submitt to instructor.
        • What civil engineering problems have lists of data/information and a spatial component?
      • Select a topic: 5 minutes
        • Criteria - data exists or can easily be created, in your field of expertise, combine efforts with another course, project scope is between 20-40 hrs of work.
      • Select a team leader

    Term Project Interview Appointments

    July 12, 2007

    • 7:30 pm - 7:40 pm Nitin Kalsi
    • 7:40 pm - 7:50 pm Elyson Liao, Ernesto Mejia, Warren Veron
    • 7:50 pm - 8:00 pm Chad Nikaido, Ryan Morgan
    • 8:00 pm - 8:15 pm Bach San Chung, Chris Bolton, Derek Harris, Sarah Cole

    July 13, 2007

    • 7:30 pm - 7:45 pm Diana Feica, Nick Gordon, Sarah Bareng, Trevor Ross
    • 7:45 pm - 8:00 pm John Petrie, Robert Olds, Tim Piparo
    • 8:00 pm - 8:15 pm Mohamed Rajabdeen, Glenn Frey, Zelalem Alemu
    • 8:15 pm - 8:30 pm Arlene Gloriani, Eduardo Gonzalez, John Amato, Vik Sehdev
    • 8:30 pm - 8:45 pm Alvin Morris, Chris Cobb, Edward Thurman, Michelle Thung
    • 8:45 pm - 9:00 pm Chanon Ruangjumrusvet, Heston Norcott, Francis Mangaoang

    Term Project Grading Metric

    • Weekly Report Progress (60 pts)
      1. Identify Team Members (3 pts)
      2. Number of ideas generated in brainstorming exercise (5 pts)
      3. Select project from brainstorming exercise (5 pts)
      4. Submitted Project Title (2 pts)
      5. Submitted Problem Description Statement - Objective of Report (5 pts)
      6. Submitted Brief Description of Project (5 pts)
      7. Submitted Data Needs (5 pts)
      8. Identify Spatial Data Sources (5 pts)
      9. Methodology, process to solve the problem (5 pts)
      10. Draft GIS figure(s) (5 pts)
      11. Conclusion (5 pts)
      12. Draft Report (5 pts)
      13. Powerpoint Presentation Slides (5 pts)
    • Final Presentation (60 pts)
      1. Duration of presentation, 15 minutes
      2. Quality of Power Point Slides
      3. Incorporate GIS graphics from ArcMap into presentation
      4. Discussion of GIS analysis
      5. Participation of team members - graded individually
    • Final Report (60 pts)
      1. Used Microsoft Template for report, Use the Microsoft Word Term Paper Template (Templates > Education > For Students > Papers, Reports, and Presentation. Can be downloaded from officeupdate.microsoft.com/TemplateGallery/
      2. Introduction
      3. Included 2 figures created from ArcMap
      4. Conclusion
      5. References

    Term Project Topics List

    1. Hydrology
      • FEMA Flood Zones and LOMRs (Kayli, Richard, Cassandra, Shaun)
      • Reproduce Digital FIRM Panels (Feng Pan, Bryan Glenn, James Frame)
      • Create Isopluvials (i.e. rain contours) from RFCD rain gauges. Compare to the NOAA Atlas Design Storm. (Vinay Virupaksha and Nanda Venkatesh)
      • Link RFCD DDMS software to ArcGIS using ModelBuilder (Chris, Tahmineh, Rob - Wright Engineers)
      • ArcHydro Data Model
    2. Surveying
      • Create GIS layer of Elevation Benchmarks in Boulder City - Survey, Clark County - Survey, City of Las Vegas - Survey, City of Henderson - Survey, City of North Las Vegas, and City of Mesquite - Survey
      • Create GIS layer of Horizontal Control Points/Monuments
      • Create GIS layer of Records of Survey from the County Recorder
        • Need to perform a spatial join between the ClarkTRS layer and the Syd Rabin Spreadsheet
      • Copy Assessor Subdivision/Final Map Layer
      • Establish link to Images
        • Purchase from CCDS Imaging and Records Division - Lisa
        • Ask Recorders Office - Laurel
        • CCPW
        • Title Companies
      • Elevation Certificates
        • FEMA elevation certificates
        • Building Division Finish Floor Certificates
      • Convert Syd Raben Spreadsheet - tabular index of recorded documents to contain hyperlinks and spatial index
      • Imaging Index - work with Kazem on scanning images and doing OCR to capture attributes
      • Aerial Photos
        • Create a spatial index of Aerial Photos for sale from Kenny Aerial Mapping and AeroTech - Leo Torres
        • Clark County GISMO
        • Southern Nevada Water Authority
      • AutoCAD DWGs
        • Street Names
        • Convert Assessor Parcels to DWG from GeoDatabase
        • Index Grids - ClarkTRS
      • Clients
        • Surveyors
          • Get list surveyors from CCDS - Patricia or Erik and Board of Engineers and Surveyors
        • Recorders Office
          • Partner with Kazem with UNLV and Syd Rabin
        • Assessor's Office
        • County and City Surveying Divisions
          • Joint Project - publish benchmark books
        • Expand services offered by AeroTech
        • Regional Flood Control District - manage the Topo, watershed basins, USGS DEMs
        • Large Property Owners
        • Developers
        • Title Companies - expand service of the Title Report, determine all easements on the land
        • Engineers - create a PDF map similar to Assessor, include a grid symbol which provides a link to the application number for the Land Use Application, Record of Survey, Off Site Improvement Plan, Drainage Study, and Traffic Study
      • Streams of Income
        • 3 Variables
          1. Quality - improve accuracy and thoroughness of research of survey records
          2. Time - improve turn around time to perform the work, currently only large firms will have staff that isn't rusty, we will do the samething every time so efficient. Also will spend time on the system, make it easier the nex time around
          3. Price/Cost - worst case breakeven, best case is lower cost for the Engineering Firm or Developer, where this duty of a staff member can be offloaded and allow them to focus/ specialize on another task.
        • Paid to Create GIS layers
        • Resell GIS layers, package with other products
        • Paid to Train Clients how to use data
        • Paid to Consult - provide engineering services - conceptual drainage studies
      • Deliverables
        • Excel Spreadsheet
        • Adobe PDF
        • AutoCAD DWG - Civil 3D Digital Terrain Models (DTM)
        • Internet Mapping
        • ESRI geodatabase, Survey Analyst
    3. Geotechnical
      • Conversion of NRCS Soils Data (SSURGO) into ArcGIS Geodatabase
    4. ESRI Niche
      • Get paid several ways doing the same thing: 1) get a project to build a model, 2) incorporate that model into the software and resale, 3) provide training how to use the model, and 4) use the findings from the project with another entity/agency/company and get paid to do the same thing.
      • Drainage Niche - 1) get paid doing drainage review for Nye, Lincoln and Clark Counties, 2) do drainage studies for private developers, 3) develop programs such as DDMS or the Chris Stone method for RFCD or other agencies, 4) provide training how to use the programs/software, 5) build GIS layer of the facilities being designed in the drainage studies for RFCD or other agencies, 6) provide a call before you dig program, 7) be the permitting process expert for the County - paid by other consultants to share how to do things faster, and 8) be an expert witness for drainage law.
    5. Land Development
      • Unify Land Use codes for Southern Nevada
      • Convert Bond Estaments into MasterFormat
      • Call Before You Dig Internet Mapping Application
      • Identify Vacant Parcels and Future BLM Parcels to be Auctioned. (Scott, Scott, Joe, and Joe)
      • 3D Map UNLV building footprints, Research Surveying Documents of Finish Floor Elevations
      • Identify Ideal Properties for Investment
        • Ideal Properties have the following characteristics
          • Low Purchase Price
            • Methodolgy
              • Need to compare with other properties, need a rule of thumb such as price per square foot, need to know the asking/selling price
              • Query loan amounts, find actual selling price, not the same as recorded by the Assessor.
          • Low cost to Improve or civilize
            • Utilities in close proxmity, Conforming Zone Change, In a flood zone or wash?
            • Any future Public Works projects (build roads, flood control)
          • High Resale Value, Marketability, Satisfy a Need/Demand
          • Adequate Parcel Size
            • Methodology - query parcel size, also identify all adjacent vacant properties - merge several smaller parcels into one large one thus increasing the options to develop. Economy of Scale - 1 acre parcel might not pencil out but a 10 acre parcel will, high the quantity lower the unit cost.
        • Case Study - what worked, what did
        • what is the competition doing? Does another successful company like KB Homes do the same thing?
        • Pioneer, new idea?
        • What is the target? What are the investors looking for? Seems if you focus on the money, that is will buy any property which will be easy to resell for more money, its like gambling, or putting the cart before the horse, purchase on speculation. Instead, of focusing on the niche or business.
        • Becker Realty Corp
          • 50 S. Jones Blvd, Suite 101, Las Vegas NV 89107, Fax: 702-870-1228
          • Barry Becker, Jr. Email: barrybeckerjr@beckerrealty.net, Voice: 702-870-0212 x6552, Mobile: 702-497-9532
          • Randy Becker, Email: rbecker@beckerrealty.net, Voice: 702-870-0212 x6522, Mobile: 702-497-3040
          • Kevin McKinley, Email: kevinmckinley@beckerrealty.net, Voice: 702-870-1227 x6539, Mobile: 702-528-4363
        • Zone Engineering. Civil Engineering and Land Development. 50 S Jones Blvd, Suite 202. Las Vegas NV 89107.
          • Dubernia "Toot" Bales, PE with Zone Engineering. Voice: 702-877-3005, Fax: 702-877-3007 Mobile: 702-379-7474, Email: tootbales@zoneengineering.com
          • Chi Seto, Email: cseto@zoneengineering.com
      • Title Companies: LandAmerica Land Title of Nevada and First American Title Company (FATCO) of Nevada- Google Maps or Internet Mapping
        • Products - 1) Title Insurance, 2) Escrow
        • Target Customers - 1) Realtors (both Commercial and Residential, note its the Buyers choice on which Title Company, i.e. Escrow agent, to use). 2) Lenders
        • Focus - greater return for clients
        • Funding
          • Directly from individual Title Company (e.g. Land Title, FATCO, Chicago Title, ...)
          • Clark County Title Services - will benefit all Title Companies
          • UNLV/TRC joint funding with Kazem and Mukund
          • Annual or Monthly Subscription to the service
          • Usage based, pay as you go
          • Reports
          • charge fees for service or provide free for preferred clients (generate more sales)
        • Services to Realtors (Internet Mapping Website, Generate Listing Packets, and Property Profiles)
          • Quality maps and graphics
          • Link to MLS
          • Link to Property Line
          • HUD and foreclosures
          • Show School Attendance Zones, Existing and Proposed Schools
          • Special Improvement Districts (SID)
          • Assessor Parcels (boundaries, ownership, last sales price, address, lot size, ...)
          • Subdivision Maps
          • Crime Statistics
          • Buffer Analysis/Radius Searches
          • Demographics
          • BLM parcels to be auctioned
        • Services to Land Developers, Engineers, Surveyors
          • Identify Raw/Vacant Parcels (can also be seen from the aerial photos)
          • Zoning
          • Existing and Future Land Use (commercial, residential, industrial, ...)
          • Master Plans
          • Utilities (sewer, water, storm drains, power, phone, cable)
          • Traffic Counts (NDOT, RTC, Traffic Studies, ...)
          • FEMA Flood Zones
          • RTC Capital Improvement Projects
          • RFCD 10 year Master Plan
          • Link to deeds, easements, any incumbents on the land
          • Permit Process
          • 5 year no-cut streets
          • Survey Benchmarks and Monuments
          • Civil Engineering Impact Studies and Plans (i.e. Drainage Studies, Traffic Studies, Offsites, Geotechnical Reports, Land Use Applications, ...)
        • Competing Services
          • Zillow.com - Appraisals, Comparables, and estimates on the worth of a property
          • Zip Reality - free version of MLS
          • SPSGIS - Single Point Solutions. GIS services tailored for the Real Estate Industry
        • ClosingPoint - created by Nations Holding Group for exclusive use by United Title Company and Land Title of Nevada. Focus is to help clients leverage technology to increase revenue, lower operational costs and provide business insight and exceptional service to maximize customer relationships and generate returns on investment (ROI) (see About ClosingPoint)
    6. Utilities
      • Subsurface Utility Engineering (SUE)
      • Create a single ArcGIS Geodatabase of any of the following utilities
        • Map of the Kern River Gas Transmission Company
        • Map of SNWA or LVVWD water lines showing 3D profile (Kimberly Lowe, Kelly Wilson and Sunshine Woods)
        • Map of Southwest Gas Lines
        • Map of Cox Cable lines
        • Map of Embarq Phone Lines
      • Create a single ArcGIS Geodatabase of all Southwest Gas line
      • Implement ArcGIS Schematics Extension for Street Lights and Gas Lines
      • Utility Coordination
        • Applied Utility Services
          7651 Jones Blvd
          Las Vegas NV 89131
          Voice: 702-368-6500
          Fax: 702-515-0800
          Email: appliedutils@earthlink.net
          Owners: Jeffery Neal and Ron Best
        • Services
          • Utility coordination
          • Negotiations for commercial, industrial, residential, major projects and master planned communities
          • Management responsibility for the review and evaluation of engineering plans and implementation of strategies to direct and guide the design process to minimize costs and meet time constraints
          • Review and evaluation of engineering and utility plans
        • subcontractor for GC Wallace on the McCarran Airport Terminal 3 - Roadways project
    7. Water Systems (waste, potable/drinking, and storm)
      • Create existing and proposed storm drains in Southern Nevada, identify cost of future facilities (Mike Cunningham, Tim Piparo, Lynden Koboyashi, Alex K)
      • Analyize Septic Tanks connecting to the Public Sewer System
        • Need sewer lines, septic tanks, rules and regs
          • Contact Daniel LaRubio with SNHD about the maximum septic tank density per circular square mile. Believe NDEP said 119 septic in Las Vegas Valley per the UDACS 102 training on March 27, 2007 at LVVWD.
        • Clark County Nevada Request For Proposal (RFP No. 600591) Clark County Individual Sewage Disposal System Study. Administered by Kathryn 'Kate' Hoffmann with Clark County Air Quality, email: hoffmann@co.clark.nv.us voice: 702-455-1955. Draft UNLV Proposal
      • Create a single ArcGIS Geodatabase of all sewer lines in Southern Nevada (Kayli, Richard, Cassandra, Shaun)
      • Create a single ArcGIS Geodatabase of all water lines in Southern Nevada
      • Analyze the water table depth in Southern Nevada (Ivana, Ty, Tom, Dustin)
      • Map of all water well locations
    8. Transportation
      • Create a single ArcGIS Geodatabase of all Traffic Signals
      • Clark County School District Attendence Zones, Busing Zones, and Bus Routes (Naveen Veeramisti and Ancila Kaiparambil)
      • Map of Interconnect/FAST conduit lines and Existing/Proposed Traffic Signals (Vidhya, Avinash)
      • Map of streets lights and electrical loadings
      • Vehicle Routing - determine the shortest path
      • How to Prevent Tagging/Graffiti/Vandelism on Highways Counter Measures (Geetha Isukapalli and Anil Puli)
      • Identify Crashes within Clark County by Age, Time and Type (Ahmad "Ed" Kouhpaenejad, Xuecai "Danny" Xu and Xin Li)
    9. Software Development

    Term Project Titles

    CEE 468/668 Summer 2007 Term Projects:

    Summer 2007 Term Projects
    Team Members Term Project Paper Term Project Presentation
    Elyson Liao, Ernesto Mejia, Warren Veron   Download
    Chad Nikaido, Ryan Morgan   Download
    Bach San Chung, Chris Bolton, Derek Harris, Sarah Cole   Download
    Diana Feica, Nick Gordon, Sarah Bareng, Trevor Ross   Download
    Chanon Ruangjumrusvet, Heston Norcott, Francis Mangaoang   Download
    Mohamed Rajabdeen, Glenn Frey, Zelalem Alemu   Download
    Arlene Gloriani, Eduardo Gonzalez, John Amato, Vik Sehdev   Download
    Alvin Morris, Chris Cobb, Edward Thurman, Michelle Thung   Download
    John Petrie, Robert Olds, Tim Piparo   Download

    More details about CEE 468/668 Summer 2007 Term Projects please clike here

    Term Project Weekly Homework

    1. Class #3
      • Email members of your team for the class project with the subject of the term project
      • Email a list of ideas on possible class project. Minimum 3 ideas per person.
      • Email results of team interview brainstorming with instructors.
      • Email Data Needs. Identify your data needs. Does the data exist or will you need to collect it?
    2. Class #6
      • Email Project Title
      • Email a description of the problem you are solving with GIS. Also know as a Problem Description statement.
      • Email Brief description of Project
    3. Class #9
      • Email Problem Description statement (Objective of Report)
      • Email list of the spatial data and data sources. What data is tabular and what is spatial.
      • You may refer the term project reports from Spring semester, 2007.
    4. Class #12
      • Email Methodology/Process to solve the problem
      • Email GIS draft figures
      • Email Conclusion
    5. Class #15
      • Email final report in Adobe PDF format
      • Email PowerPoint slide presentation in Adobe PDF format

    Quizes on Textbook Reading Assignment

    • Hands on quiz - classroom demonstration of GIS concept/command
    • Quiz based on topic in reading assignment
    • Student will be randomly selected at the beginning of each class
    • Student will be quized once during the semester
    • Example Quiz Question - How do you add features/layers to the ArcMap map display? Answer: 1) click the Add Data button or 2) File -> Add Data...

    How To Remember What You Just Read

    • "Before you read it, skim it. Read the headings, look at the graphs or illustrations, get a sense of the material." [Crook 92, p. 111]
    • "Based on your survey, formulate some questions about the material you are about to read. If there are questions at the end of the chapter, read through them before you start reading the text." [ibid]
    • "Read the text." [ibid]
    • "If appropriate, go back and highlight or underline the important sections." [ibid]
    • "Review the text." [ibid]

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

    • Step 0. Ensure the Analysis ToolPak feature is enabled (Tools -> Add-Ins... -> Analysis ToolPak)
    • Step 1. Copy the table of student names from this page and paste into Excel at cell B1.
    • Step 2. Delete all rows without a student name.
    • Step 3. Assign an id value, 1 to 32 in the A field
    • Step 4. Type the following formula (shown in bold) in cell G1. =RANDBETWEEN(1,32)
    • Step 5. Type the following formula (shown in bold) in cell H1. =VLOOKUP(G1,A1:B32,2)
    • Step 6. Press F9 key to refresh the random generation. Cell H1 should have the random student who will step to the front of the class and demonstrate the solution to the quiz problem.
    • Note, could also using a stop watch which shows the hundredth of a second. Multiply this value to the total number of students and round. This value is the randomly select a student.
    • Instructors version of Randomly selecting a student for the quiz, RandomStudentsQuiz.xls
    • Alternative method of randomly selecting student using ArcMap, RandomStudentsQuiz.mdb, RandomStudentsQuiz.mxd
    • Reference: Standard Practice for Random Sampling of Construction Materials, ASTM D3665-02

    Today's Quiz Questions

      1. How do you change marker symbols for a point feature? (see p. 91, 111-114)
      2. Using the RTC.mdb geodatabase, PostSpeedLimits line feature class, symbolize the map using all values in the MaxSpeedLimit field, in other words speed limit of 75 mph is assigned one color, speed limit of 65 mph is assigned another color, and so on. Each speed limit should have a unique symbol assigned to it.

    GIS Tutorial Workbook Homework

    Assignments:

    1. Class #1
      • none
    2. Class #2
      • none
    3. Class #3
      • none
    4. Class #4
      • Email map of Exercise 1-1 as pdf
      • Email map of Exercise 1-2 as pdf
      • Email the data document if there are questions for Exercise 1-1 and Exercise 1-2.
      • GIS Tutorial 1 Hints
      • Due on 19 July 2007
    5. Class #5
      • Email map for Exercise 2-1 as pdf
      • Email map for Exercise 2-2 showing just the city of Pittsburg zoom extent as pdf
      • Email the data document if there are questions for Exercise 2-1 and Exercise 2-2.
      • GIS Tutorial 2 Hints
      • Due on 20 July 2007
    6. Class #6
      • Email map for Exercise 3-1 as pdf
      • Email map for Exercise 3-2 as pdf
      • Email the data document if there are questions for Exercise 3-1 and Exercise 3-2.
      • GIS Tutorial 3 Hints
      • Due on 24 July 2007
    7. Class #7
      • Email map for Exercise 7-1 as pdf
      • Email map for Exercise 7-2 as pdf
      • Email the data document if there are questions for Exercise 7-1 and Exercise 7-2.
      • GIS Tutorial 7 Hints
      • Due on 26 July 2007
    8. Class #8
      • Email map for Exercise 5-1 as pdf
      • Email map for Exercise 5-2 as pdf
      • Email the data document if there are questions for Exercise 5-1 and Exercise 5-2.
      • GIS Tutorial 5 Hints
      • Due on 27 July 2007
    9. Class #9
      • Email map for Exercise 6-1 as pdf
      • Email map for Exercise 6-2 as pdf
      • Email the data document if there are questions for Exercise 6-1 and Exercise 6-2.
      • GIS Tutorial 6 Hints
      • Due on 31 July 2007
    10. Class #10
      • Email map for Exercise 4-1 as pdf
      • Email map for Exercise 4-2 as pdf
      • Email the data document if there are questions for Exercise 4-1 and Exercise 4-2.
      • GIS Tutorial 4 Hints
      • Due on 2 August 2007
    11. Class #11
      • Email map for Exercise 8-1 as pdf
      • Email map for Exercise 8-2 as pdf
      • Email the data document if there are questions for Exercise 8-1 and Exercise 8-2.
      • GIS Tutorial 8 Hints
      • Due on 3 August 2007
    12. Class #12
      • Email map for Exercise 9-1 as pdf
      • Email map for Exercise 9-2 as pdf
      • Email the data document if there are questions for Exercise 9-1 and Exercise 9-2.
      • GIS Tutorial 9 Hints
      • Due on 7 August 2007
    13. Class #13
      • none
    14. Class #14
      • none
    15. Class #15
      • none

             

    GIS Tutorial Workbook

    Table of Contents


    Guest Speakers

    • Call Before You Dig by Underground Service Alert (USA North)
      • Don Heyer, Operations and Public Relations Manager
      • Address: 4090 Nelson Avenue Suite A, Concord CA 94520-1232.
      • Voice: 925-798-9504 x4. Mobile: 702-595-7919. Fax: 925-798-1683. Email: dheyer@usan.org
      • Member of the Common Ground Alliance
    • Southern Nevada Water Authority (SNWA)
      • Judy Brandt, GIS Analyst, Groundwater Resources Department, Data Resources Division. Voice 702-862-3727, email Judy.Brandt@snwa.com
    • McCarran International Airport
      • Majed A. Khater, Ph.D., AIA, Airport GIS Manager
      • PO Box 11005, Las Vegas NV 89111-1005
      • Voice: 702-261-2348, Mobile: 702-283-0755, Fax: 702-261-3755
      • Email: mak@mccarran.com
      • Sonya, voice: 261-5882
    • Freeway and Arterial System of Transportation (F.A.S.T.)
      • Thomas E. Wolch, PE
      • Principal ITS Traffic Engineer
      • Freeway and Arterial System of Transportation
      • 4615 W. Sunset Road
      • Las Vegas NV 89118
      • Voice: 702-432-5300, Mobile: 702-208-3475, Fax: 702-432-5302
      • Email: wolcht@rtcsnv.com
    • Las Vegas Valley Water District
      • Laura B. Jacobsen, PE - Manager, Planning Division LVVWD Resources Dept. Voice: 702-258-3186, Fax: 702-822-8351, Email: laura.jacobsen@lvvwd.com
      • Jason Ghadery, Assistant Civil Engineer, Engineering Services Division. Voice: 702-822-8394, Fax: 702-258-7193, Email: jason.ghadery@lvvwd.com
    • Bureau of Reclamation
      • Ron Simms, GIS Administrator, Email: rsimms@lc.usbr.gov
      • Douglas B. Blatchford, PE, River Operations Group Manager, Lower Colorado Region, Voice: 702-293-8190, Mobile: 702-528-4064, Email: dblatchford@lc.usbr.gov
    • Nellis Air Force Base
      • Roger Clarke, Geospatial Information Manager.
        Nellis AFB Geospatial Information Office (99 CES/CECT)
        Email: Roger.Clarke@nellis.af.mil Voice: 702-652-4681.
        6020 Beale Ave Nellis AFB, NV 89191
        COMM: 702-652-4681 DSN: 682-4681
    • Southern Nevada Health District
      • Daniel LaRubio, Jr. PE - Environmental Health Engineer/Supervisor (Dennis Campbell is his supervisor). Voice: 702-759-0660, Fax: 702-383-1445, Email: larubio@snhdmail.org
      • Mark Silverstein, Senior Planner with Clark County Air Quality and Environmental Management, Voice: 702-455-4728, Email: silverstein@co.clark.nv.us - working
    • UNLV Information Science Research Institute (ISRI)
      • Thomas A. Nartker, Ph.D. - Director ISRI, Professor Computer Science
        4505 Maryland Pkwy
        Box 454021
        Las Vegas NV 89154-4021
        Voice: 702-895-3338, Fax: 702-895-1183
        e-mail: tom@cs.unlv.edu
      • Kazem Taghva, Ph.D. - Technical Director ISRI, Professor Computer Science
        Voice: 702-895-0873, Fax: 702-895-1183
        e-mail: taghva@isri.unlv.edu

    Section 2: ArcGIS Instructor Materials and Topic

    Topic List

    Overview of GIS

    Exploring ArcMap

    Exploring ArcCatalog

    Making Maps Quickly

    Making Maps for Presentation

    Building geodatabases

    Querying Data

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

    Labeling Features and Annotation

    Symbolizing features and rasters

    Classifying features and rasters

    Selecting features by location

    Joining and relating tables

    Overview Data Frame

    Using Excel with ArcGIS

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

    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

    Creating Features

    Preparing data for analysis

    Analyzing Spatial Data

    Spatial Analyst

    3D Analyst Extension

    ArcGIS Overlay Analysis

    Projecting data in ArcMap

    Geocoding

    How to Trace Vehicle Route Using GPS Data Based on Shortest Path

    Internet Mapping, Mashups, ArcGIS Online, Google Maps and Google Earth

    Export Geodatabase to AutoCAD drawing file (.dwg)

    US Census and TIGER/Line

    Paper Size

    Survey

    Microsoft Access Database Review

    Miscellaneous Topics

    Overview of GIS

    GIS Concept

    • Geographic Information Systems (GIS)
    • "Geographic information system" means a collection of computer hardware, software and data that is used for the collection, management, manipulation, analysis and display of information that includes a positional component.' (Nevada Administrative Code, NAC 625.795 4a)
    • Basically just a database linked to a map that allows one to perform spatial queries/analysis. For example, in databases such as Microsoft Access, a form is used to input and display data. The query connects the form to the database. The data isn't stored in the form. So in ArcGIS, the form would be ArcMap and the database is Microsoft Access (known as the GeoDataBase, GDB). In Autodesk Land Development, the database is the points file, alignment, etc. and the form is AutoCAD.
    • "Any geographic information system should be capable of six fundamental operations in order to useful for finding solutions to real-world problems. A GIS should be able to Capture data, Store data, Query data, Analyze data, Display data, and Output data" (ESRI Virtual Campus-Basics of ArcGIS, Lesson 1: Introducing a GIS, What can a GIS do?)

    The GIS 4 Step Solution Process

    • Step 1: Identify Problem
    • Step 2: Create or Acquire Data
    • Step 3: Perform Analysis
    • Step 4: Present Results

    GIS Tabular Data

    1. Flat files
      • Simple ASCII text files, whether columnar, tab (.tab) or comma delimited (.csv)
    2. Relational Database Management Systems (RDMS)
      • Use of a relate item (known as a primary key) to link separate tables together
      • Objective is to limit duplicate field entries by using an ID and lookup table (a.k.a. switchboard)
      • Use the write once principal - data is stored in one record, then linked into other tables.
    3. Object Database
      • Basically any data that is embedded in the file, example is AutoCAD drawings-attributes stored within file.

    GIS Data Types/Features

    1. Points
      • Represents a single place on a map, such as a fire hydrant
      • A single coordinate pair is used to identify the location.
      • Point features have clear boundaries or distinction between other features
      • Use point features if your data is countable
    2. Lines/Arcs/Polyline
      • Represents a linear feature, such as a street centerline.
    3. Polypolylines/Routes
      • A single feature that includes two or more polylines, such as a bus route
      • Just a convenient way to group related polylines into one map feature so that they can be selected or linked to a database as a single entity
      • Known as Dynamic Segmentation in ArcInfo
    4. Polygons
      • A feature that encloses an area, a boundary, such as the State of Nevada.
      • 3D Polygon Features - stores Z values in a shapefile or geodatabase
    5. Polypolygons/Multipart Features
      • Map feature consisting of two or more polygons that is treated as a single map feature (multiple noncontiguous areas), such as the State of Hawai'i which consists of several islands. Known as Multipart Features in ArcGIS, Polypolygons in Autodesk MapGuide, MPolygons in AutoCAD Map.
    6. Regions
      • Composite polygons (hybrid of polygons and layers)
      • Implemented in ArcInfo, similar to polypolygons (supports noncontiguous areas) but more powerful
      • Allows for overlapping polygons (e.g. spatial index of construction projects or showing the boundary of a country over time)
      • Nested features are supported, that is polygons within polygons, for example counties within a state.
      • See ESRI Article Number 23404 How to Create a region or boundary map with no internal boundaries in ArcMap.
      • See ESRI Article Number 21381 How to Create donut polygons from existing features in ArcMap
    7. Text/Annotation
      • Labels that appear on maps
      • Tend not to have any attributes or location associated with it directly
      • Annotation is typically text but can also be any graphic element that annotates your map (e.g. lines, circles, and polygons).
      • Dynamic Text/Labels- labels generated from a database. Autodesk LDD and Map and AutoCAD block attributes do this.
      • Static Text- labels places by hand. Called annotation by ESRI. AutoCAD TEXT command.
      • Feature-Linked Annotation- have the control of static text, but also if the feature (e.g. fire hydrant) is deleted, label is also deleted (e.g. fire hydrant number). Used by ESRI
    8. Raster Images
      • Matrix/Grid of pixels, identify by rows and columns
      • Opposite of vector drawings
      • A pixel/cell contains a single value
      • Example, aerial photos
      • Use if data varies continuously across an area, not countable. Example temperature, rainfall, elevation.
    9. Map Elements (a.k.a. map objects, map components)
      • Used in map layouts/paperspace for final presentation, instead of analysis like data view/modelspace.
      • Title of Map - should be easy to see and reflect the map's purpose
      • North Arrow - used to orient the map to the world. Size of north arrow should not be so large that it diverts attention from the map body. Known Bug: The north arrow and other graphic elements shift positions in the layout, see ESRI Article ID 25845
      • Legend - used to help the reader interpret the map body
      • Scale bar - used to relate the size of objects on the map to the real world. Typically located on the bottom of the map and can be represented as a verbal scale (1"=40') or a representative fraction (1:480)
      • Borders and neatlines - borders are used around the data frame and neatlines highlight the map elements.
      • Inset Maps - also known as Overview/Index/Vicinity/Key maps and are used to identify the location of the map body (data frame) a larger portion of the world.
      • Marginalia (mar'gi'na'lia)- any supporting elements on a map that help the reader interpret the map
    10. Paperspace/Layouts vs. Modelspace/Data Views
      • Modelspace- scale of objects are 1:1, drawn at actually size. Can think of the modelspace like the body of a document. "Data View is the all-purpose viewing option for exploring, displaying, querying, editing, and analyzing data." [ESRI Virtual Campus - Presenting Data in ArcGIS Lesson 1: Making maps in ArcMap]
      • Layouts- virtual page upon which you place and arrange data frames/viewports and map elements. The objects are scaled to fit on paper. Engineers typically use scale of 1"=40'. Can think of the Layout as the header/footer section in a document, watermarks, page numbers, etc. "The Layout View lets you produce cartographic quality digital and hardcopy maps using the information contained in your data frames, reports, and graphs." [ibid]
      • ArcPlot is similar to Layouts
      • ArcEdit is similar to Modelspace
      • Viewports/Data Frames link the modelspace to the layout
      • Layouts usually contain graphic and map elements
    11. Coordinates
      • X-Y coordinates locate a point in 2D space
      • two types of coordinates systems: geographic (lat/long) and projected (stateplane)
      • Origin is lower lefthand corner of graph, typically begins with 0,0
      • False Origin- used to keep coordinates positive, e.g. Mount Diablo Meridian (MDM) (near San Francisco, CA) is the true origin for State Plane Coordinates but the origin is shifted 8,000,000 meters down (Northing) and 200,000 meters to the right (Easting).
    12. Table Attributes
      • One or more records (rows) with one or more fields (columns)
      • stores the tabular information in a GIS
      • Cell- the intersection of a record/row with a field/column

    ArcGIS Desktop consists of ArcView, ArcEditor, and ArcInfo

    • ArcView is a subset of ArcEditor which is a subset of ArcInfo. Similar to AutoCAD and AutoCAD Map, where AutoCAD Map can do everything AutoCAD can do.
    • Only ArcView is available as a stand-alone seat
    • "ArcView 8 is a powerful GIS data visualization, query, analysis, and map creation solution designed for Microsoft Windows NT/2000. It provides interactive tools for exploring, selecting, displaying, editing, analyzing, symbolizing, and classifying data as well as for automatically creating, updating, and managing metadata." (ESRI Virtual Campus-Basics of ArcGIS, Lesson 2)
    • ArcEditor adds the ability to edit coverages and geodatabases
    • ArcInfo adds additional geoprocessing tools and a full version of ArcInfo Workstation (comprised of ARC, ArcEdit, ArcPlot, INFO, and ARC Macro Language or AML)
    • All 3 types of ArcGIS (i.e. ArcView, ArcEditor, ArcInfo) include these 3 Applications
      • ArcMap Application- used to display and query geographic data on maps and to edit and output data
      • ArcCatalog Application- used to browse/preview geographic data sources and create and update metadata. Basically a Windows Explorer for spatial data.
      • ArcToolbox Application- contains powerful tools for performing geographic analysis and data conversion. Used to change map projections.
    • ArcView Extensions: Network Analyst, 3D Analyst, ArcPress, Geostatistical Analyst, Spatial Analyst, and StreetMap.
    • ArcGIS System consists of ArcGIS Desktop, ArcIMS, and ArcSDE. Won't be covered in this course.
    • References: [Vance 00 p. 115] and [MapGuide R5 p. 91]

    Exploring ArcMap

    Exploring ArcMap

    [Ormsby 00, Chapter 3]

    Map Legend/Table Of Contents (TOC)

    Primary ArcGIS Supported Spatial Files

    Tools Toolbar

    ArcMapToolsToolbar.jpg
    1. Zoom
      • Changes the display scale has shown in the Standard Toolbar (ArcMap Menubar: View -> Toolbars -> Standard)
      • To zoom in click the + magnifier icon in the Tools toolbar. A single click in the map display zooms around a point. Click and drag will create a rectangle to zoom around an area.
      • To zoom out click the - magnifier icon in the Tools toolbar.
      • To zoom to a specific scale in the data frame, type or choose the desired scale on the Standard toolbar.
      • To zoom to the extent of a layer, choose "Zoom to Layer Extent" from the context menu of the layer in the TOC.
      • To zoom to the full extent of a data frame, click the Full Extent button (icon of the world) on the Tools toolbar. If option is grayed out, click View -> Data Frame Properties: Data Frame Tab and check Automatic extent.
      • Continous Zoom/Pan (ArcMap): Tools -> Customize: Commands Tab: Pan/Zoom, in Commands Window drag and drop the "Continuous Zoom and Pan" button onto the Tools toolbar.
      • Continous Zoom/Pan (ArcCatalog): Tools -> Customize: Commands Tab: Geography Category, in Commands Window drag and drop the "Continuous Zoom and Pan" button onto the Tools toolbar.
      • Continous Zoom/Pan: hold right mouse button down and move mouse to zoom in/out
      • Continous Zoom/Pan: hold left mouse button down and move mouse to pan
      • Wheel Mouse Scroll - just rotate the wheel mouse to scroll up/down in ArcMap
      • Wheel Mouse Zoom - hold down Ctrl key while scrolling with mouse to zoom in/out
      • Wheel Mouse Switch between Data View & Layout View - hold down Shift key while rotating wheel mouse to switch views
    2. Select Features
      • white arrow with a square map in the upper right corner
      • Used to select feature in a data frame or in Data View
      • [Ormsby 00, p. 201]
    3. Select Elements
      • icon that has a black arrow
      • Used mainly in Layout View to select map elements (e.g. north arrow, legend, and so on)
    4. Identify Tool
      • use the mouse to perform a spatial query feature attributes
      • Another method to query data
      • Icon found on the Tools toolbar
      • features in all visible layers under the pointer will be identified. Solves issue of overlapping features.
      • Displays all fields with it's values/attributes of the identified feature. Not like Map Tips which only display attributes of one field.
      • Can "flash" the feature in the map display by clicking the name of the feature on the left pane in the Identify Results window.
      • See [Ormsby 00, p. 26-27, 197-200]
    5. Find Tool
      • Another method to query attribute data
      • Results of query are displayed like the Identify Results window
      • [Ormsby 00, p. 207-208]
    6. Go To XY
        ArcMapGoToXY.jpg
      • Decimal Degree Example in Las Vegas NV: Long = -116.2 Lat = 36.1
      • Help when using USGS data or Google Earth/Map
      • Use the Identify Tool to obtain the location of the cursor in different formats (e.g. Degrees Minutes Seconds)
        ArcMapIdentifyLocationOptions.jpg
    7. Measure Tool
      • must select icon on Tools toolbar
      • looks like a ruler with a question mark (?) above it
      • Results of measure in map display are displayed in the status bar
    8. Hyperlink Tool
      • icon that has a yellow lightning bolt on it
      • Need to define hyperlinks before you can use them
      • 2 ways to define hyperlinks: Field-based and Dynamic
      • Use field based hyperlinks instead of manual hyperlinks, see ESRI Article Number 17520.
      • Note if the hyperlink button is grayed out, open the layer properties in the TOC, select Display tab, then check "Support Hyperlinks using field"
      • Cannot use the Hyperlink tool on raster layers. See ESRI Article ID 18368
      • See [Ormsby 00, p. 205] or online help [ArcMap Desktop Help -> ArcMap -> Querying maps -> Displaying a Web page or document about a feature]

    ArcMap Window Menu

    Map Tips

    Layers/Themes

    Data Frames

    ArcMap output options

    Map Documents (.mxd)

    Using ArcMap with Relative Path Names

    Review transferring data files from UNLV to home/work

    Exploring ArcCatalog

    ArcCatalog

    Adding data to ArcMap

    Searching for Map Data

    Importing files into geodatabase tables using ArcCatalog

    Making Maps Quickly

    Templates

    How to Create an ArcMap Plotter independent map template

    Layout Toolbar

    Logos and Pictures

    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

    Building geodatabases

    Geodatabase

    Geodatabase Geometry Types

    Geodatabase X/Y Domain

    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

    4. 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

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

    Labeling Features and Annotation

    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

    Fonts

    Symbolizing features and rasters

    Symbols and Styles

    Creating Marker Symbols

    Symbols by Attributes

    Using Interstate Shields

    Classifying features and rasters

    Classifying Features and Rasters

    Quantitative Scaled Symbology

    1. Graduate Color
      • this is a color ramp, applies to polygons, won't work well with points or lines. (See ESRI Article Number 20653 on How to apply a color range to a portion of symbols in ArcMap.
      • Most effective on polygon layers because subtle color differences are easier to detect on large features (see Ormsby 04 p. 129)
    2. Graduate Symbol
      • different marker size, applies to points, lines, & polygons.
      • Normally used with point layers (see Ormsby 04 p. 129)
      • Specify number of classess, minimum and maximum symbol size.
      • Example using 3 classess and min value = 1 and max value = 3, then ArcMap will symbolize the map with 3 symbols, sizes 1, 2, and 3
    3. Proportional Symbol
      • vary in size proportionally to the value symbolized.
      • Example marker symbol for a city of 10,000 would be ten times larger than a marker symbol for a city of 1,000.
      • work best when the range of values for an attribute is not too wide (see Ormsby 04 p. 130)
      • Instructor recommends using Graduate Symbol over Proportional Symbol. Appears Proportional symbol crashes ArcMap, cannot specify a maximum symbol size, and unclear is units apply to the map or the symbol.
    4. Dot Density
      • applies to polygons only. (see ESRI Article Number 17472 Dot density symbology previews can be incorrect. and Ormsby 04 p. 130)

    Classification methods

    Symbology Charts

    Understanding Classification Histogram

    Selecting features by location

    Spatial Relationships

    Select by Location

    Joining and relating tables

    Database Relationships

    Relate Tables

    Join Tables

    Spatial Joins

    Example Spatial Join: Assign closest bus stop to each parcel

    Overview Data Frame

    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.

    Using Excel with ArcGIS

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

    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

    Creating Features

    ArcMap Edit Session

    ArcMap Editing

    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

    Creating Points