• Due Tuesday August 16th at 6pm
• No live presentations
• Upload PowerPoint to MavSpace, make public, and email the link to me
• I will compile the links on this site so interested folks can see what everyone else came up with.

• Considering dropping this and giving everyone full marks. We can discuss this tonight.

• Barring further unforeseen emergencies class will meet both tonight and Thursday.
• As it is possible there is no final exam happening, the only remaining project to work on are the free-choice projects.
• I will be available to meet with people needing 1-on-1 assistance during class time.
• If you completed your projects, or otherwise not feeling the need for further assistance, then there is no need to attend classes this week.
• This is the final two classes.
  

1. Georeferencing Toolbar: Customize/Toolbars/Georeferencing
2. Create New feature Class: ArcToolbox/Data Management Tools/Feature Class/Create Feature Class
3. Editor Toolbar:Pencil Icon or Customize/Toolbars/Editor

1. Site Selection in ArcMap (using merge, intersect, and erase)

• Where to open a new pizzeria in the DFW Metroplex?
• Download Data
• Open ArcMap and add from database:
• Pizzerias
• CPK
• SampleData2005
• Landuse
• Major Roads
• Positive Criteria:
• Intersect all positive criteria
• ArcToolbox/Analysis Tools/Overlay/Intersect
• Negative Criteria
• Merge all negative criteria
• ArcToolbox/Data Management Tools/General/Merge
• (Can also use Union. As a habit I always use merge because it combines attributes which union does not do.)
  
• Erase Positive Criteria with Negative Criteria [This in Student License? I am not sure!]
  
• ArcToolbox/Analysis Tools/Overlay/Erase

• First, ensure you have elevation data for your region. The higher your elevation precision, the higher your resulting slope precision will be.
• Here is a direct link to TNRIS' Arlington NED (30 meter)
• Second, ensure the Spatial Analyst extension is turned on. (Customize/Extensions)
  
• Third, ensure your XY coordinates are in the same units as your Z units. (We are fine for this example, just want to point it out
  
• Fourth, ArcToolbox/Spatial Analyst/Surface/Slope

• Download from TNRIS
• Use the collarless version for displaying purposes. Use the collared version for the legend information.

• File/Map Document Properties and you will see the checkbox for relative path names.

• Simple Site Selection Logic (intersects, union, merge, erase)
• Maps for Presentations (pretty maps)
• Georeferencing & Digitizing
• ArcGIS Online
  

1. A file you obtained does not have its coordinate systems defined
2. A file has the wrong coordinate system (usually due to a mistake) RARE

• Obtain the volcano data from the National Atlas.
  
• Use the U.S. National Atlas Equal Area projection system (Predefined/Projected/Continental/North America/U.S. National Atlas Equal Area)
• No WinZip, WinRar, or equivalent on your computer to open the .TAR files from National Atlas? Download Peazip. Is free, safe, and can even be run as a portable app from a USB drive.

1. National Atlas
1. No WinZip, WinRar, or equivalent on your computer to open the .TAR files from National Atlas? Download Peazip. Is free, safe, and can even be run as a portable app from a USB drive.
2. Texas Park and Wildlife Division

1. Near (ArcToolbox/Analysis Tools/Proximity/Near)
2. Point Distance (ArcToolbox/Analysis Tools/Proximity/Point Distance)

• Take this table (download table) and calculate the straight-line distance from each location to UT Arlington Library.
• To create the UT Arlington Library point, first ensure you have the Bing aerials viewed. (File/ArcGIS Online, search for Bing). Second, geocode as we normally do to the University address and then move the point to the Library. Third, convert the graphic to a feature class.
• We can use either the Near or the Point Distance tool for this exercise.

• We will use the Spatial Analyst Extension. The extension needs to be enabled before we can use it.
• Customize/Extensions and check Spatial Analyst
  
• ArcToolbox/Spatial Analyst Tools/Surface/Slope

• One database and a folder for your raster files.
• Database will have 11 feature classes
• Raster folder will have 6 raster files.
• Do not turn in temporary files
• Neat and well organized

• Anyone with a score under 90% can earn additional points to bump up their exam grade. Turn in, by Thursday, your exam that I emailed to you with corrected answers and you will receive .5 credit. For example, if you earned a 70 and redid the 3 answers you got wrong, your grade would bump up to a 85.
  

• Take-home exam will be available at 6pm this evening.
• Exams must be submitted (electronically by hitting the DONE button on the bottom of the page) by Friday evening, 8pm.
• You may use any and every resource you can access, with the exception of receiving advice or help from anyone else.
• Be honorable. Everyone will receive a good grade for the course. You will not be pleased with yourself in the morning should you cheat.
• Best of Luck!

• Our classroom in Library basement will not be open. If you will be working on campus, go to the 3rd, 4th, or 5th floor of the Central Library or any of the locations listed here: http://ask.uta.edu/a.php?qid=75132
• I will not be available in-person during the exam, but I will try to be available via IM this evening. Go to http://libguides.uta.edu/geol4330, right side of screen.
  

1. Create a raster file showing the 10-meter resolution elevation model within 5 miles of TCU. Please ensure this file is projected as state plane feet. You will get the 10-meter elevation file from the USDA-NRSC: Geospatial Gateway. You will need to fill out a form to request the data which will be emailed to you as a link. This means please do not wait until 30 minutes before class begins to do this as you may not get your link on time. We have not yet used this source, so do not get frustrated. I have confidence in all of us that we can figure it out!
• Symbolize your resulting raster using 10 equal interval classes. What is the range of the highest class, representing the highest elevation values?
  


• Getting to Know ArcGIS: Chapter 6, exercises 6a, 6b, 6c, 6d. (pps. 131-173)
  

1. Convert USGS DEM to GRID (ArcToolbox/Conversion Tools/To raster/DEM to Raster)
2. Raster Mosaic (ArcToolbox/Data Management Tools/Raster/Raster Dataset/Mosaic to New Raster)
3. Clip Raster (ArcToolbox/Data Management Tools/Raster/Raster processing/Clip)

1. National Elevation Dataset [TNRIS]
2. Digital Raster Graphic (DRG) [TNRIS]
3. 2010 1-meter NAIP Imagery [TNRIS]
4. LandSat 7 Imagery [Columbia Regional Geospatial Service Center]
• Use composite image/321 images. The 321 images are the 'natural color' images.

• ReferenceUSA (Define as NAD83)
  
• TRI (Define as NAD83)
1. Of course use the 2009 (latest) file. When the comma separated values (.CSV) file displays in your browser, hit File/Save to save it to your desktop. Make sure the file has a .CSV extension so Excel can easily open it.

1. Excel ratios
2. Projecting to State Plane (feet)
3. Merging shapefiles
4. Creating Personal geodatabases

• Download prepared SimplyMap data
• To calculate % change, divide the difference by the original number.
• For example, to calculate the % change from a 2000 population to 2010 population:
• (2010Pop - 2000Pop)/2000Pop
• We will also need the Merge Tool: ArcToolbox/Data Mangement Tools/general/Merge
• Is a good idea to join any attributes and export before merging if your tables are by county.
  

• Create a simple Personal Geodatabase: ArcToolbox/Data Management Tools/Workspace/Create Personal GDB
• Two Methods to Project a Feature Class:
1. ArcToolbox/Data Management Tools/Projections and Transformations/Feature/Project
2. Ensure the Data Frame is set to the desired coordinate system (right-click 'Layers' and select Properties, and go to Coordinate System tab). Then Export the feature class using the same coordinate system as the Data frame.
   

• 1 county = lucky
• 2 county = unlucky
• 3+ county = unreasonable, you may select another college if you wish
  

1. First Let's Handle the HUD Properties
1. Download HUD foreclosure property listing for Fort Worth
2. Clean the downloaded HUD table by removing all illegal characters from header row.
3. Geocode addresses using GPS Visualizer
4. Add lat/long coordinates back into Excel sheet, finish cleaning and delete any unnecessary fields, and save as an .XLS Excel file.
5. Add Excel to ArcMap
6. Display XY Data for the HUD properties, making sure you specify Geographic/World/WGS84 as the coordinate system.
7. Export to a new shapefile
2. Now Let's Focus on the Average Mortgage Debt
1. Download the data from SimplyMap (This variable is listed in: Census 2010 Estimates/Supplemental Data/Financial Assets and Debt/Average Mortgage Debt, 2010) Remember, a helping video can be viewed here.
2. Open table in Excel and clean header row.
3. HUGE TIP: Ensure the block group geoid field and and fancy formatted fields (such as with dollar signs) are reformatted as numbers with no decimal places. To do this, right click on the fields and select Format Cells and change the type to number and the number of decimal places to zero (none).
4. Save as an .XLS Excel file and bring into ArcMap
3. Now Let's Grab that TIGER Census Block Group File
1. Head on over to here to grab it as usual.
2. HUGE TIP: Even though the SimplyMap data are 2010 estimates the geographies used are still 2000! So grab the 2000 block group TIGER file, and not the 2010!
3. Unzip and add shapefile to ArcMap
4. Moving On, Let's Join SimplyMap Table to TIGER Shapefile
1. HUGE TIP: Try as you might, you will be unable to straight-away join the shapefile to the SimplyMap data due to incompatible field types, so we need to fix this before we can join.
1. Open TIGER file attribute table. On top left corner is a button that opens a menu when clicked. Select Add Field. Name the field as you wish, but ensure the field type is a Double.
2. Right click on your newly created field and select Field Calculator. In the calculator, double-click the unique identifier so that it appears in the box below.
3. Run it and close the attribute table when completed.
2. Now you can easily join the table to the shapefile basing the join on your newly created field. Remember to right-click on the shapefile to base the join.
3. Export your temporary join.
5. Now We Need Some Buffs, Right?
1. Buffer your exported HUD shapefile by 1-mile.
2. ArcToolbox/Analysis Tools/Proximity/Buffer
6. Oh Snap, Final Step Already? OK, Then Let's Spatial Join!
1. Right-click on your newly created buffer layer and spatially join it to the exported block group shapefile. Remember to check the Average checkbox.
2. Open the attribute table of your newly generated spatial join file and voila! Scroll to the right and you should see your data. Sort descending and the one at the top is the winner.
   

Sort of a review class. Only new item learned is geocoding via GPS Visualizer and three new sources: HUD Foreclosures Data & TEA School District Locator & Arlington Police Department.

1. Create a shapefile of all available HUD foreclosures in Arlington.

HUD Foreclosures Data

• Geocode using the GPS Visualizer
  (uses Yahoo! Maps to geocode)
• Alternative is Excel Geocoding Tool - ( - backup - ) (uses Yahoo! Maps to geocode)
  
• Yahoo & Google Geocoders Use Geographic/World/WGS84

1. Coordinate systems
2. Geocoding (more detail)
3. Personal Geodatabases

1. Textbook, pg. 339 - 365 exercises 13a & 13b. Print off last step of each exercise and bring in.
2. Which zip code in Texas has the largest number of Municipal Solid Waste Sites/Landfills in it? If there is a tie, list them all.
1. Municipal Solid Waste Sites/Landfills via Texas Commission on Environmental Quality
2. Texas Zip Codes via TIGER (Please use the 2010 zip codes.)
   

• SimplyMap
• Texas Water Development Board

• Select by Location
  
• Buffers
  

1. Download 2010 estimates by block group from SimplyMap.
1. This is a proprietary database, limited to 10 simultaneous users.
1. Prepared table
2. Walk-through video
   
2. Clean SimplyMap table
3. Add to ArcMap
2. Download 2000 block group shapefile from TIGER
1. Add to ArcMap
3. Join SimplyMap table to TIGER shapefile. (See a problem here?)
1. Fix field type in shapefile
1. Open shapefile attribute table
2. Click 'Table Options' button on top left corner, and select 'Add Field'
3. Give name (following rules)
4. Type: Double
5. OK
6. Scroll to far right of table and you will see your new field
7. Right click your new field and select 'Field Calculator'
8. Double-click 'BKGPIDFP00' so it appears in the text area box below.
9. OK
10. Now Join
    
2. Export to make join permanent
4. Download statewide well shapefile from Texas Water Development Board
1. Add to ArcMap
5. Create UT Arlington point shapefile
   
1. Click the 'Find' button (binoculars)
2. In the 'Locations' tab, select the U.S. Streets Geocode Service
3. Enter: 701 S. Nedderman Drive, Arlington, TX 76019
4. Click 'Find'
5. Right-click top result and select 'Add Point'
6. Close 'Find' dialog box
7. Right-click 'Layers' and select 'Convert Graphics to Features'
8. Specify a suitable location/name and OK
6. Create a 1-mile buffer (radius) around UT Arlington
1. ArcToolbox/Analysis Tools/Proximity/Buffer
7. Tested exercise before class (not typical) and the spatial join against the well data took a long time due to the nigh number of wells in Texas. It will run faster if we clip the well data to Tarrant County first.
1. At top of screen, Selection/Select by Location
2. Select all features from [XYwelldata]
3. Source Layer: BG Layer
4. OK
5. Export
   
8. Spatial Joins
   

1. Graduated Symbols
   
2. Spatial Join
3. Buffers
   

1. ReferenceUSA
   

• Download prepared database here
• View the graduated symbols of total air emissions by facility
• Spatial Join #1: (Which zip codes have the highest number of facilities reporting air emissions?)
• Right-click zip codes/Joins & Relates/Join
• Change join type to spatial join
• Join to the TRI data
• Specify output location/name
• Spatial Join #2: (Which zip codes have the highest amount of air emission releases?)
• Repeat above, but this time we will check the 'Sum' checkbox.

• Download Garbage Collection facilities from ReferenceUSA
• Click U.S. Businesses
• Select Custom Search tab
• Click Business Type
• Check Keyword/SIC/NAICS
• Type Garbage Collection and click Lookup
• Select Garbage Collection (should be first item)
• On the left again, click Geography
• Check Metro Area
  
• Specify Dallas/Fort Worth
• On the right, click View Results
  
• We are limited to 50 records per download! This will therefore take multiple downloads that need to be copied together.
• Clean resulting table. Remove any fields you do not need, but it is required to keep the name of the company and the lat/long at a minimum
  
• Tricksey Part! We need to convert the lat and long fields from numbers stored as text to actual numeric fields. Select entire fields and click the exclamation and select Convert to Number.
• Create Points
• Right-click on table and select Display XY Data
• Longitude: X
• Latitude: Y
• Must assign a coordinate system!
• ReferenceUSA (and TIGER) use NAD 1983 (North American Datum)
• Geographic/North America/North American Datum 1983
• Buffer Points 1 Mile
• ArcToolbox/Analysis Tools/Proximity/Buffer
• Spatial Join
  

1. What are TIGER files?
2. What are the common boundaries as designated by the U.S. Census Bureau?
3. What data can be gathered from the decennial Census 2000?
4. How to extract Census 2000 data from Old American Factfinder?
   
5. How to join TIGER 2000 boundaries to Census 2000 data tables?
6. How to create a choropleth map (color distribution)?
   

1. TIGER Files - Topologically Integrated Geographic Encoding and Referencing system
2. Old American Factfinder

1. Use this guide here - Decennial Data 1990-2000 tab
   

1. There are five rules to remember.
1. First, there can be only one header row (horizontal row at the top). ArcGIS will interpret the top row as the attribute names and the second row through the end of the table as the data contents. Often times tables may contain 2 or more rows at the top that help to define the contents of each attribute (vertical columns). Other times tables may contain no header row whatsoever. In both of these instances, the tables must be edited so there is one single header row before importing into ArcMap.
2. Second, the header row can only contain letters, numbers, and underscores. All other characters (including space) will cause errors either when importing into ArcMap or when attempting to be made a permanent part of a feature class.
3. Third, the header row may not begin with a number. For example, POP2010 is acceptable, but 2010POP may generate errors.
4. Fourth, save your file in a format ArcMap can read. ArcMap can read a variety of file formats, but the most popular include Excel (.XLS or .XLSX), tab-delimited (.TXT), comma-delimited (.CSV), and dBase table (.DBF).
5. Fifth, be careful how many characters you use in your header row. If you plan on integrating this table into a shapefile, all headers will be truncated to the first 10 characters.

1. Right-click the layer or table you want to join, point to Joins and Relates, and click Join.
2. Click the first drop-down arrow and click Join attributes from a table.
3. Click the second drop-down arrow and click the field name in the layer on which the join will be based.
4. Click the third drop-down arrow to choose the table to join to the layer. If the table is not currently part of the map, click the Browse button to search for it on disk.
   
5. Click the fourth drop-down arrow and click the field in the table on which to base the join.
6. Click OK.

1. If you want to permanently save joined data with your geographic features, export the data to a new feature class, right-click the layer in the table of contents, point to Data, and click Export data.
   
2. Right-click shapefile, select Data, and click Export Data.

• Ensure all understand syllabus
• Discuss GIS and its relationship with popular geospatial viewers

• What is ArcMap and ArcCatalog and how do we open these applications?
• Download Practice Data (ensure you install to the C:/ directory)
  
• Example #1: Explore Metroplex Pizza Data
• Task: Identify the Census Block Groups with the highest median household income
• We will do this by opening the attribute table, sorting, and selecting.
  
• Example #2: Explore Austin Congress Avenue Data (time permitting)
  
• Task: Identify the trees with the height class of '2'
• Height Class (1 = <15 feet, 2 = 15-25 feet, 3 = >25 feet)
• Background on tree dataset: 'Staff created field spreadsheets and enlisted volunteers to conduct study on two Saturdays in April 2002. Over 100 volunteers collected the data on over 3000 trees. Results were digitized. Some field checking occurred to asses data accuracy.'
• Select a College for Personal Geodatabase Project
• Download Data Here
• Any college except for those in the Metroplex (Dallas/Tarrant County) or A&M College Station (reserved).

• Total Hispanic Population by Census Block Group: IMG
• Total Hispanic Population as Percent of Total Population by Census Block Group: IMG

• Review syllabus
• What is Geographic Information Systems?
• Access to ArcGIS @ Home
• Each student will receive a 12-month license of ArcGIS 10, student version, to install on your home (off-campus) computer.

• Beginning Thursday (06/09), the second class, we will be meeting in Central Library basement, room B20. Hence this abridged first class.
• Last I saw the bookstore did *not* yet have the required textbook so we will not be making use of it until next Tuesday (06/14).