HW #2 (DUE: 02/07)

Create a Google Map containing the following layers in Tarrant County, TX. When clicked, the markers for each type should provide the street address of the establishment. Upload the all associated files into MavSpace, and make the directory public. I will take a look at your webpage during class next week.

• Chinese Restaurants (download table)
• McDonalds (download table)
• HUD Foreclosures (access here)

Class Plan (01/31)

Today's Exercise:

• Create a Google Map showing the location of all of the current foreclosures in Dallas County. To include basemap data in ArcMap, use the Census_TIGER2000 service from Geography Network.
  
• Necessary Resources:
• ArcMap2GMap
• ArcMap2GMap Sample Data
• HUD Foreclosure Listings
• BatchGeocode.com
• Also, try Excel Geocoding Tool ( - backup - )
• We must specify a geographic coordinate system. See here for more info.
• Yahoo! Maps geocoding service uses WGS84
• X - Longitude
• Y - Latitude
• Coordinate System: Geographic/World/WGS84
• Upload to MavSpace and create an accessible webpage.
• API Key
  
• Time & Mood Permitting: Include HTML formatting in the Google Map popup.'

Procedure:

1. Extract ArcMap2GMap directly to the C:/ directory. This should create C:/ArcMap2GMap
2. Launch C:/ArcMap2GMap/ArcMap2GMap.mxd
3. At this point we will play around with ArcMap2GMap to see what it can do for us.
   
4. Minimize ArcMap
   
5. Download foreclosure listings
6. Open file in Microsoft Excel and clean table by removing all characters in the topo field row except for letters, numbers, and underscores. Also, field names may not start with a number.
   
7. Copy data in Excel table and paste into BatchGeocode to geocode.
   
8. Copy and paste the geocoded results back into the Excel file, overwriting the original table.
9. In Excel, save as an Excel 97-2003 Workbook. ArcGIS can not read XLSX files nor can they read HTML-formatted Excel files.
10. Maximize ArcMap
    
11. Add table to ArcMap
12. Right-click table and select Display XY Data
13. X: Long | Y: Lat
14. To enter the spatial reference: Click Edit/Select/Geographic Coordinate Systems/World/WGS_1984
15. OK, OK, OK
16. Export temporary XY Event Class to a permanent shapefile: Right-click the Event Class/Data/Export Data. Ensure a reasonable output location and file name. OK
17. If prompted, yes you would like to add the recently exported file to the map as a layer.
18. Click the ArcMap2GMap button.
19. Fill out form and voila, we have maptastic!

Example of multiple fields in Google Maps language:

"HUD Foreclosures
" & [Address] & "
" & [Price]

Welcome to the Class

Welcome to the class.

Please note the links to the right of this page -----> -----> ----->

This Selected Topics course is a project-based course where the entire semester is focused on completing a specific project. The project focuses on residential property investment strategies using GIS. Each student will individually develop a strategy to select foreclosures for investment in the Tarrant County, TX.

What does this mean?

This means we will be accessing MLS data, HUD Foreclosure data, TAD data, and Crime Rankings, and other datasets. This means that we will be including all of this data into Geographic Information Systems (GIS). We will use ArcGIS 9. This also means that we will learn how to automate this process.

What experience do I need?

None at all. GIS experience will be helpful, but is not required. Likewise, real estate experience is helpful, but is not required.

But, I have no interest whatsoever in residential property investment !

No worries. All of the skills you will learn are transferable. It will be fun no matter what...

This sounds pretty good. I think you are the best instructor ever!

Yep... You're well on your way to earning an 'A' with thinking like that.

Plan for Class #1

Here is today's Plan:

• Discuss Syllabus
• Discuss Project
• Friday Night Hangout
  
• Explore ArcGIS Using sample data [download here]
  
• TIME (and mood) PERMITTING - Generate Google Map [download ArcMap2GMap] [sample data here]

HW #1 (DUE: 01/31)

Learning ArcGIS Desktop Virtual Course

1. Each student will receive your course code during class.

2. Complete the Exam of Module 1 and Module 2 and bring in a hard copy of the certificates to me. Here is an example of a certificate:


After successfully completing the exam, click the certificate button (looks like a little graduation cap) and then click on 'Completed'.

ArcGIS @ Home

Each student will receive a 12 month educational license for ArcGIS 9.2. This software includes single-use code. This means you cannot install the software on more than 1 computer.

I advise you to install ArcGIS 9.2 service pack 4 (SP4) soon after installing ArcGIS from the CD. The service pack can be found here. You want to download and install the 'ArcGIS Desktop (ArcInfo, ArcEditor, ArcView)'.

ESRI Virtual Campus

Each student will be given an access code for 'Learning ArcGIS Desktop', a virtual course. This is part of ESRI's Virtual Campus.

I INSTRUCTIONS:
-----------------------------------------------
1. Go To My Training
Go to http://training.esri.com. Click "Go to My Training." Under My Courses click "My Virtual Campus Courses." If you already have an ESRI Global Account, log in using your username and password. If you do not, click "Create New Account."

2. Start Your New Course
Click "Start a new course". Type your 14-character Course Access Code in the field provided and click "Go." Follow the instructions on your screen.

3. Go To Class
From your course list, click the course title to begin.