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.
To make great civil engineers! To provide the knowledge and tools necessary to help aid them in civilizing the wilderness.
Getting to Know ArcGIS desktop, 2nd
Edition
GIS Tutorial: Workbook for ArcView 9
| CEE 468 | |||
|---|---|---|---|
| Student Name | Class Standing | Group Partner(s) | |
| Barajas, Ivana | ivanabarajas@yahoo.com | Ty Nelson | |
| Barber, Kayli | barberk2@unlv.nevada.edu or vegaskayli@hotmail.com | FEMA Flood Zones and LOMRs | Shaun Boulton and Cassandra Watson |
| Boulton, Shaun | shnbltn@yahoo.com | FEMA Flood Zones and LOMRs | Kayli Barber and Cassandra Watson |
| Braddell, Scott | scottb@vtnnv.com | Joe Cetrulo, Scott Maxfield and John Rescober | |
| Cetrulo, Joseph-Peter | cetruloj@cox.net | Scott Braddell, Scott Maxfield and John Rescober | |
| Cirrinicione, Thomas | lvdiceman19@hotmail.com | ||
| Croft, Dustin | dustinb313@msn.com | ||
| Cunningham, Michael | mjackal845@cox.net |
||
| Glenn, Bryan | glennb2@unlv.nevada.edu | Reproduce Digital FIRM Panels | Feng Pan and James Frame |
| Graves, Kevin | kevingraves83@hotmail.com | Kelly Wilson, Kimberly Lowe, Kevin Graves and Sunshine Woods | |
| Hansen, Robert | rhansen@wrightengineers.com or rhansen@unlv.nevada.edu | Chris Parker and Tahmineh Zenhari | |
| Kalawe, Alex | dahamma46@hotmail.com | ||
| Kobayashi, Lynden | lynden69808@hotmail.com | ||
| Lowe, Kimberly | lowek@unlv.nevada.edu | Kelly Wilson, Kevin Graves and Sunshine Woods | |
| Maxfield, Scott Donald | dsmax4@gmail.com | Scott Braddell, Joe Cetrulo and John Rescober | |
| Nelson, Ty | tyjnelson@gmail.com | Ivana Barajas | |
| Parker, Christopher | cparker@wrightengineers.com | Tahmineh Zenhari and Rob Hansen | |
| Piparo, Timothy | ttpip48@gmail.com | ||
| Robinson, Richard | richardr2126@hotmail.com or robinsor@unlv.nevada.edu | FEMA Flood Zones and LOMRs | Kayli Barber, Shaun Boulton and Cassandra Watson |
| Suarez, Luis | sephirothlita@hotmail.com | ||
| Watson, Cassandra | cassjwats@yahoo.com | FEMA Flood Zones and LOMRs | Kayli Barber, Shaun Boulton and Richard Robinson |
| Wilson, Kelly | calisac@hotmail.com | Kimberly Lowe, Kevin Graves and Sunshine Woods | |
| Woods, Sunshine | sunshinemwoods@hotmail.com | Kelly Wilson, Kimberly Lowe and Kevin Graves | |
| Zenhari, Tahmineh | tzenhari@wrightengineers.com | Chris Parker and Rob Hansen | |
| CEG 668 | |||
| Grad Name | Standing | Major | >|
| Frame, James | kimo6525@gmail.com | Reproduce Digital FIRM Panels | Feng Pan and Bryan Glenn |
| Holur Venkatesh, Nanda | nandavenkatesh@gmail.com or nanda@egr.unlv.edu | Create Isopluvials from RFCD Rain Gauges | Civil- Virupaksha, Vinay |
| Isukapalli, Bala Geetha Van | geetha_unlv@yahoo.com or isukapal@unlv.nevada.edu | Masters | Transportation - Anil Kumar Puli |
| Kaiparambil, Ancila | kaipara2@unlv.nevada.edu or ancila.kv@gmail.com | Implement an Internet Mapping Application Using MapGuide, Map of Interconnect/FAST conduit lines and Existing/Proposed Traffic Signals | Civil - Naveen Veeramisti, Avinash Kaiparambil, Vidhya Kumaresan |
| Kaiparambil, Avinash | kv_avinash@yahoo.com | Implement an Internet Mapping Application Using MapGuide, Map of Interconnect/FAST conduit lines and Existing/Proposed Traffic Signals | Civil- Vidhya Kumaresan, Naveen Veeramisti, Ancila Kaiparambil |
Kouhpaenejad, Ahmad Ed |
edkouhpa@yahoo.com | Doctoral | Civil- Xuecai Xu and Xin Li |
| Kumaresan, Vidhya | vidhyakumaresan@gmail.com | Implement an Internet Mapping Application Using MapGuide, Map of Interconnect/FAST conduit lines and Existing/Proposed Traffic Signals | Civil- Avinash Kaiparambil, Vidhya Kumaresan, Naveen Verramisti |
| Li, Xin | lix11@unlv.nevada.edu | Doctoral | Civil- Kouhpaenejad, Ahmad Edand Xuecai Xi |
| Pan, Feng | panpanfeng797@gmail.com | Reproduce Digital FIRM Panels | Bryan Glenn, James Frame |
| Puli, Anil Kumar | pulia@unlv.nevada.edu | Geetha Isukapalli | |
| Rescober, John | jrescober@gcwallace.com or parejojo@hotmail.com | Scott Braddell, Joe Cetrulo and Scott Maxfield | |
| Veeramisti, Naveen Kumar | chinthunavin@gmail.com | Implement an Internet Mapping Application Using MapGuide, Map of Interconnect/FAST conduit lines and Existing/Proposed Traffic Signals | Civil - Ancila Kaiparambil, Avinash Kaiparambil, Vidhya Kumaresan |
| Virupaksha, Vinay | vinay@egr.unlv.edu | Create Isopluvials from RFCD Rain Gauges | Transportation- Nanda Venkatesh |
| Xu, Xuecai | xux2@unlv.nevada.edu | Doctoral | Civil- Kouhpaenejad, Ahmad Edand Xin Li |
| Description | Percentage | Number Assignments | Assignment Worth | Total Points |
|---|---|---|---|---|
| GIS Tutorial Workbook Exercises | 25.2% | 9 | 28 | 252 |
| ESRI Virtual Campus | 11.2% | 14 | 8 | 112 |
| Lecture (In Class) Homework | 24.7% | 13 | 19 | 247 |
| Term/Class Project | 18.9% | 1 | 189 | 189 |
| Final Exam | 20% | 1 | 200 | 200 |
| Total | 100% | 1000 |
| 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 |
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
Email module completion certificates to cee468@egr.unlv.edu with the subject line including your full name, class# virtual campus module
| No. | Time Schedule | Group Memebers |
| 1 | 6:00pm-6:20pm | Geetha Isukapalli and Anil Puli |
| 2 | 6:20pm-6:40pm | Ed Ahmad Kouhpaenejad, Xuecai Xu and Xin Li |
| 3 | 6:40pm-7:00pm | Kayli Barber, Shaun Boulton, Richard Robinson and Cassandra Watson |
| 4 | 7:00pm-7:20pm | Kimberly Lowe, Kelly Wilson and Sunshine Woods |
| 5 | 7:20pm-7:40pm | Mike Cunningham, Luis Suarez, Lynden Koboyashi, Alex Kalawe |
| 6 | 7:40pm-8:00pm | Robert Hansen, Chris Parker, and Tahmineh Zenhari |
| 7 | 8:00pm-8:20pm | Scott Braddell, Joe Cetrulo, Scott Maxfield, and John Rescober |
| No. | Time Schedule | Group Memebers |
| 1 | 5:20pm-5:40pm | Ivana Barajas, Ty Nelson, Tom Cirrinicione, and Dustin Croft |
| 2 | 5:40pm-6:00pm | Feng Pan, Bryan Glenn, James Frame |
| 3 | 6:00pm-6:20pm | Vinay Virupaksha and Nanda Venkatesh |
| 4 | 6:20pm-6:40pm | Naveen Veeramisti, Ancila Kaiparambil, Vidhya Kumaresan and Avinash Kaiparambil |
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.


For exported maps, transparency can be re-applied to the desired elements in an external editing application such as Adobe Illustrator 9(see ESRI Article ID 17332)
| 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 |
| 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 |