Final Exam

Download here

pass: kumquat

Geocoding Resources

batchgeocode

Excel Geocoder

Due Dates & Such...

NO CLASS: NOVEMBER 15

Buffer Project: November 8
Residential Market Site Selection: December 3
Final Exam (take home): November 22, due November 25 (Tuesday)

Class Plan (11/01)

Site Selection

Where to Open a New Pizzeria in the D/FW Metroplex?

• Download Data
• We will use the Guide w/o Geoprocessing document

DUE: December 3
Each team represents a group of real estate investors looking at the residential market in the D/FW Metroplex (Dallas & Tarrant Counties). You need to identify the top two (2) zip codes in the metroplex to purchase houses for the purpose of possible improving them and reselling them for profit.

At a minimum (more is better), each team must take into consideration six (6) criteria. Three criteria must include:
1. Number of days properties are on the market (from sample MLS data)
2. % change between Census 2000 median property values by block group and the average sale price (from MLS)
3. % change between block group population in 2000 to 2007

MLS Data: Download
Other Datasets: You should all be intimately familiar with other datasets by now, eh?
Zip Code: Download statewide zip code layer here

Buffer Project Final Requirements

The following sources must be used:
(supersedes syllabus)

Calculate with a 1-mile and a 5-mile buffer:

1. Total Population (2000)

2. % Change in Population 2000 - 2007

3. Median Household Income (1999)

4. % Change in Median Household Income 1999 - 2007

5. % Adults who Earned a Bachelor Degree (2000)

6. % Change in Adults Earning Bachelor Degree 2000 - 2007

7. Number of Households that Rent (2000)

8. % Change in Number of Households that Rent 2000 - 2007

9. Total Crime Index (2007)

10. Average property taxes paid (2007)

11. % change of owner occupied housing values from 2000 to 2007

12. % change of owner-occupied units from 2000 to 2007

13. % of the population made up of the majority race (2000)

14. % of the majority race population that normally leaves for work between 5am and 6am (2000)

15. Number of water wells

16. Number of Toxic Release Inventory facilities

17. Number of pizzerias

18. Number of HUD Foreclosures

19. Number of public schools

Point Feature Classes within 5-mile buffer:

1. Water wells

2. TRI facilities

3. Pizzerias

4. HUD Foreclosures

5. Public schools

Homework (Due November 1)

Each team will submit a 1-sheet paper listing the datasets necessary to somplete the buffer project and the data sources you anticipate using.

Class Plan (10/25)

Review Buffer Project

Notes:

1. Statewide County Layer
2. State Plane Zones
3. Water Wells via Texas Water Development Board
4. Toxic Release Inventory (TRI) via Environmental Protection Agency
5. HUD Foreclosures via Southwest Alliance
6. School Data via Texas Education Agency

Remainder of Semester

Buffer Project: November 8
Residential Market Site Selection: November 22
Final Exam (take home): November 22, due November 25 (Tuesday)

Midterm Grades

Grades:
Average: 84.8%

A: 9
B: 5
C: 3
D: 4
No Name on Test: 1
Number of 120%: 3

Make Up:
Redo any question you did not answer correctly and resubmit exam next Saturday (11/01) for 1/3 credit of each question missed. For example, a grade of 60% can be elevated to an 80%. You must turn in this same exam to receive the extra credit. For this reason, I will nto go over the exam until next week.

Project Due Date: November 8

Project Due Date: November 8

We will discuss how we will accommodate the rest of the syllabus requirements, but for the time being this is the new due date.

See you guys Saturday.

Midterm Exam

Here it is!

Midterm Review

Example Questions:

• How many block groups are there in Webb County, Texas?
  • 90
    
• Which block group in Travis County, TX had the highest median household income in 1999? Provide the tract and block group number.
• tract: 1912, BG: 1
  
• What is the area (in sq ft) of this block group?
• 112785017.589501
  
• Does this block group still have the highest income in 2007?
• Yes
  
• How many Italian restaurants are within 2 miles of this block group?
• To buffer an individual block group, select it in the attribute table and then buffer the layer. Only the sleected features will be buffered.
• 2
  
• What is the median year houses were built (according to Census 2000) within a 1 mile radius around all Baskin-Robbins in Bexar County, TX?
• Right-click on a field in ArcMap and select STATISTICS to learn summary stats about that field. Summary stats including average, sum, min, max, etc...
• 
  
• Which block group in Travis County, TX, has the largest perimeter? Provide tract and block group number.
  • 
    
• What is the median property value (according to Census 2000) within 2 miles from the HUD foreclosure with the lowest asking price?
• 136250
  

HW (Due 10/11)

Add up the total asking price of all currently available foreclosure properties within a 1.5 mile radius around each pizzeria in Tarrant County.

Which pizzeria has the highest total asking price?

Sources: Reference USA & Southwest Alliance of Asset Managers

Class Plan

1. New Class Schedule:

+ Buffer Project Due: October 25
+ Midterm Exam: October 18 (in-class)
+ Residential Market Site Selection: November 8
+ Hotel Market Analysis Project: November 22

2. Geocoding
+ Which currently available HUD foreclosure has the highest number of renter-occupied housing units (using Census 2000) within a 1 mile radius in Dallas County, TX.
+ How many schools are within this 1-mile radius?
+ How many water wells?

+ HUD Foreclosures via Southwest Alliance of Asset Managers
+ Batch Geocode.com to geocode addresses.
+ Factfinder
+ TIGER Shapefiles
+ School Data via Texas Education Agency
+ Water Wells via Texas Water Development Board

NOTES:

All data geocoded from Yahoo! Mapping needs to be defined as WGS84 geographic/world/wgs 84

New Project Date

Projects Due: October 18

Register: GIS Day 2008

Information Here

Extra Credit for those who Showcase!

HW (Due 10/04)

1. Which school in EL Paso County contains the highest number of Asians (2007 data) within a 1.5 mile radius?

2. In 2006, what was the average household interest paid on a home equity loan within this 1.5 mile area?

Steps:

1. Download data (Simplymap shapefile and TEA school data) & add to ArcMap
   
2. Define coord system for Simplymap shapefile (arctoolbox/data management tools/projections and transformations/define projection)
3. If data frame coordinate system is still unknown (maps still not overlaying) Layers/Properties/Coordinate System Tab/select any of them.
   
4. Buffer Schools (arctoolbox/analysis tools/proximity/buffer)
5. Right-click buffer/joins & relates/joins (to simplymap shapefile/spatial join/check ave & sum)
6. In new shapefile just created, sort fields and find answer
   

Class Plan (09/27)

New Topics Covered Today:

+ Create Personal Geodatabases
ArcToolbox/Data Management Tools/Workspace/Create Personal Geodatabase

+ Add & Calculate New Fields
Add:

+ Discuss Additional Data Sources

1. 2006/7/11/12 block group data via Simply Map
2. Water Wells via Texas Water Development Board
3. Toxic Release Inventory (TRI) via Environmental Protection Agency
4. HUD Foreclosures via Southwest Alliance
5. School Data via Texas Education Agency
6. Aerial Imagery via the Columbia Regional Geospatial Service Center

1. Today's In-Class Projects
1. Which school in Dallas County contains the highest number of Hispanics (2006 data) within a 1.5 mile radius? In 2006, what was the average household interest paid on a home equity loan within this 1.5 mile area? (This is the type of question to expect on the mid-term in 2 weeks.)
   
1. Download shapefile with 2006 data from Simply Map (out of the oven)
   
2. Download school point data from Texas Education Agency
3. Ensure projections are consistent
1. Are the two coordinate systems defined? How can you tell?
   
2. If they are not defined, how can we define them?
   
4. Create buffer
5. Spatial join buffer to block groups
1. Select both Sum and Average
6. Open attribute table of spatial join results to gather answers
2. Calculate the number of Hispanics per sq ft
1. Export the shapefile to a personal geodatabase to create a perimeter and area field. The units will be in the coordinate system units.
2. ArcToolbox/Data Management Tools/Workspace/Create Personal Geodatabase
   
3. Create a new field
1. Open the attribute table
2. Options/Add New Field
3. Right-click on the new field and select Field Calculator
4. Enter the calculation
5. OK

Class Cancelled (09/20)

I am way too sick to be able to teach today and my voice can barely croak above a whisper.

I will post this weekend here about moved due dates for the various projects.

I apologize for cancelling class on you guys, and promise to make it up to you...

Extra Credit

In this class we offer a generous extra credit benefits package.

GIS Workshop Attendance: 3 points each added to final grade
GIS Day Participation: 6 points added to final grade (info coming soon)

There are 3 workshops held this semester. Schedule is here.

Title: Create Your Own Customized Google Maps Webpage
Time: Wednesday, September 24, 3-5pm
Location: Central Library B20 (basement)
Description: Learn how you can easily create your own customized Google Map webpage, overlaying multiple point, line, and polygon layers. Every participant will create a transportable webpage that can be hosted on any web server or run off any hard or flash drive or CD-ROM.

Examples:

• Presidential Election Data 2004
• Hodge Podge Sample of Stuff From My Computer
• Consulting Firm Selections
• Health Resources

Teams: We Need Some More!

Folks not listed in one of these teams... (Click Here for Google Maps Display)

We need two additional teams. One representative of each team must send to me the following information:

1. Team Name
2. Real Estate Consulting Firm
   
3. Names of Team members
4. Email addresses
   

Team Chapter Presentations

September 27

• 4 Stars
• Chapters 1 & 2 (no case studies)

October 4

• A - Team
• Chapter 3 (chapter overview & select one case study)

October 25

• Pangea
• Chapter 4 (chapter overview & select one case study)

November 1

• Spatial Analyst
  
• Chapter 5 (chapter overview & select one case study)

November 8

• The Nameless
  
• Chapter 6 (chapter overview & select one case study)

November 15 (3)

• SouthWest Consultants
• Chapter 7 (chapter overview & select one case study)

Homework (due 09/20)

Create a map (picture) showing at least the following:

1. All Pizzerias in Travis County, TX
   
2. Distribution of median household income values per block group
   
3. 2-mile buffers around each pizzeria

Steps:

1. get block group shapefile, factfinder table, and pizzerias
• HINT: Check Yellow Page Heading or SIC and County, State. Under Enter Yellow Page Heading, type Pizzeria and click Lookup. Find the heading(s) that most closely matches your search and click it to add to list. Then state, county and you should get nice list.
  
2. add all three data items to arcmap
3. join bg to factfinder table
4. display starbucks
5. export both starbucks evenst and joined shapefile
6. generate 2-mile buffers around each pizzeria
7. print

Class Plan (09/13)

Coordinate Systems

• Geographic Coordinate System: Not projected, still in angles and degrees.
• Projected Coordinate System: Projected in linear units (meters, miles, feet, etc.)

• Defining A Coordinate System: A shapefile without a .prj file will have the top, bottom, left, and right coordinates defined, but the system and units that these coordinates represent are not defined.
• ArcToolbox/Data Management Tools/Projections and Transformations/Define Projection
• Projecting a Shapefile/Feature Class: Converting from one defined coordinate system to another.
• If a file's coordinate system is undefined, it must be defined before attempting to project or convert from one system to another.
1. ArcToolbox/Data Management Tools/Projections and Transformations/Feature/Project

HINTS:

• TIGER Files are always geographically referenced as North American Datum 1983 (NAD 83) when initially downloaded. They must always be defined when downloaded from the ESRI site we are primarily using.
• ReferenceUSA coordinates likewise are always in NAD 83 and must be specified at the time you initially display the XY points.
  

Class Exercise
Which Starbucks in Dallas County has the highest median residential property value (2000) within a 1-mile radius?

• Steps (new items in red):
1. Obtain FactFinder and Block Group TIGER files.
2. Define the TIGER file projection as NAD 83
1. ArcToolbox/Data Management Tools/Projections and Transformations/Define Projection
2. Input Dataset: TIGER file
3. Click: Coordinate System browse icon
4. Click: Select
5. Geographic/North America/North American Datum 1983
   
3. Join table to shapefile
4. Export temporary join to new shapefile
• Right-click shapefile/Data/Export Data
5. Obtain Starbuck locations table from ReferenceUSA
• Library Home Page/Databases A-Z/ReferenceUSA
  
• Click: US Businesses
• Click: Custom Search
• Check: Company Name and County, State
• Click: Create Search
• Type: Starbucks
• Select Texas
• Select and Click on: Dallas
• Click: Search Now
• Should get 121 records. We are limited to 50 records per download, so this means 3 download to get all 121. There are 25 records per page.
• Click: All
• Click: 2
• Click: All
• Click Download
• Check: Detailed
• Click: Download, and then open in Excel
• Repeat for pages 3 and 4 and then copy the second batch of 50 records and paste all rows except for title field row to the bottom of the first table.
• Repeat for page 5
• In Excel, (1) remove all fields after Lat and Long and then (2) remove the following characters from the top title field row: [SPACE], +, -, #.
• Save, close Excel, and add table to ArcMap
6. Display Starbucks locations in ArcMap
• Right-click on the table/Display XY Data
  
• X: Longitude
• Y: Latitude
• Click: Edit
• Click: Select
• Geographic Coordinate Systems/North America/North American Datum 1983
• Add
• OK
• OK
• OK
7. Export Event Class to shapefile
8. Create 1-mile buffer around all Starbucks Locations
• ArcToolbox/Analysis Tools/Proximity/Buffer
9. Summarize property values within radius
• Right-click the buffer layer/Joins & Relates/Join
• What Do You Want to Join to This Layer: Join Data From Another Layer Based on Spatial Location
• Choose the Layer to Joini to This Layer: Your exported block group layer
• Check: Average
• Specify Output file
• OK
10. View Answer in Newly Created Shapefile's Attribute Table
    

!! OFFICE HOURS LOCATION CHANGE !!

Tues & Wed: 3-5pm
Digital Media Studio in
Central Library, Rm. B29

Thurs: 3-5pm
Sci & Eng. Library in
Nedderman Hall Rm. B03

Sat: 9-2pm, 5-8pm
Central Library Rm. B20

Homework (due 09/13)

Create a map showing the distribution of the percent of adults (age 25+) that have at least a bachelor degree, by block group, for Tarrant County.
+ Overlay this map with all of the Chinese Restaurants in the county. (only if we cover this during class)

Print out the map (black/white is OK), write you name on it and turn it in.

Class Plan (09/06)

Class Plan:

• Distribute ArcGIS CDs (installation assistance)
  


• Where to Locate GIS Data??
• UT Arlington Library Subject Guide: GIS
  


• Exercise: Create a map showing the median household income and median contract rent per blockgroup in Dallas County, TX.
  


• Introduce TIGER Files (about)
  
• Topologically Integrated Geographic Encoding and Referencing system
  
• Download county-level files from ESRI ArcData.
  
• Download state-level files from the U.S. Census Bureau.
• Download Texas state-level files from the Texas State Data Center.


• Data from American Factfinder Website


• Clean Tables for ArcGIS
• Top row reserved for field names. Data must begin on second row
  
• No characters permitted in the top row (field name row) except for letters, numbers, and underscores.
• Field names may not begin with a number.
• Files must be saved as either:
• Comma-Delimited files (*.csv)
• Tab-Delimited files (*.txt)
• dBase (*.dbf)
• ArcGIS 9.2 can read Microsoft Excel 2000/2003 (*.xls) files
  


• To join together in ArcMap
• Add the shapefile and table to ArcMap
• Right-click the shapefile (in the layer list) and select Joins/Relates and click Join
• Specify the two fields that will join together (one to one relationship) and click OK


• Export shapefile to make join permanent
• Right-click shapefile, select Data, and click Export Data.
• 
  


• (Time Permitting) Add all of the Indian Restaurants in Dallas County to the above map.
• Use Reference USA
• Catch: Reference USA permits 50 records per download. So if you need 104 records, you need to download three batches of records and copy/paste them together.

Homework Factfinder Help

Step-by-steps and tips here concerning accessing the American FactFinder website to help with homework.

1. Using any browser other than IE (such as Mozilla Firefox), navigate to the American FactFinder website.
2. Click 'Data Sets'
3. Select SF3 and click 'Detailed Tables'
4. Change the default view from 'list' to
   'geo within geo'
5. Ensure that you set this page up properly to acquire all blockgroups in the county you need and click 'Next'
   
6. Change the default view to 'by subject'
7. Search through the drop-down menu to find the data you need. You can find it. No worries.
8. Use the 'What's This' link to read the documentation on particular tables.
9. When you find the table you need, add it and click 'Next'
10. When you see the first 10 blockgroups on the screen, mouseover the 'print/download' tab at the top and select 'download'
11. In the popup dialog that opens up, select the Excel format under 'Database Format'
12. OK

Class Teams

There are at this moment 24 folks in the class. We need a total of 6 teams, so 4 people per team. 14 folks have formed 4 teams thus far.

Here are the team designations so far (with initials). Make sure you are included here if you are on a team and if you are not on a team, get on one or form one.

4 Stars

• CH
• SL
• CS
• GT

A - Team

• JB
• BK
• BM
• BS

Pangea

• RA
• RB
• WS

SouthWest Consultants

• JB
• JK
• RM

homework pdf book

download off campus

email me if you forget password

Welcome to the Class

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

This course is Advanced Real Estate Market Analysis, with a strong focus on data sources, data collection, and geographic information systems (GIS). Consider this course a combination of market analysis and an Introduction to GIS.

This is a practical course. After this course, you will be able to actually use GIS. You will be able to acquire your own data sets, create your own maps, and run your own analysis.

Easy.

Hold onto your hats folks, because this will be one heck of a 14-week ride!! No doubt it will be a lot of work, but market analysis and GIS is just so dang fun that I promise it will be worth it.

This blog will be used as a class discussion forum during these 16 weeks. Posting instructions on syllabus. Please do not hesitate to post your most brilliant ideas (at least marginally course related) and even your most frustrating problems. Yes, there will be frustrations. Perhaps many. It is inevitable. Also feel free to comment on my postings and others' postings as well. We have a lot to learn in only 16 weeks so this extra communication forum between classes might be useful.

This blog should be checked regularly for any important information, such as changes to my office hours, assignment changes, or class cancellations (but don't hold your breath waiting for that one...).

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.

When registering the software onb your own computers, you are prompted to specify which extensions you would like to trial. You need to select at least 'Spatial Analyst', '3D Analyst', and 'Geostatistical Analyst'. It does you no harm, however, to simply select all of them.

From ESRI:

Please advise each student to review the site listed below before installing the software:

[ LINK ]

Please also advise the students that as they register the software, they should make sure to write out the full school name in the organization field rather than using any acronyms, the word "Student", or the word "Self". When those words or initials are used, there is a delay in the registration time as it is required that ESRI manually review the registration rather than having the process be completed automatically.

It is advisable that you install ArcGIS 9.2 Service Pack 6. You want the ArcGIS Desktop (ArcInfo, ArcEditor, ArcView) version.

ESRI Virtual Courses

Each student will be given access codes for various ESRI Virtual Courses.

INSTRUCTIONS:
-----------------------------------------------
1. Go To My Training
Go to http://training.esri.com. Click "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.
-----------------------------------------------

When assigned ESRI Virtual Course modules, bring in hard copies of the certificate 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'.

Homework (due 09/06)

1. What is the % Hispanic population of the Census Block Group in Dallas County with the highest % of renters?
1. Hints: Census 2000 data can be found at American Factfinder. First, identify the block group that has the highest % renters and then the % Hispanic pop in that block group is the answer.
2. Read What is ArcGIS? pages 1 - 63 (chapters 1-4).
1. Download while on campus
   
2. Write a paragraph (a few sentences) explaining how you think GIS can be used for market research.

Create a Word file containing these assignments and bring in a hard-copy.

What?? You say there are possibly numerous block groups with 100% renters? If this turns out to be the case, search through the block groups with 100% renters to locate the Block Group with the highest number of Hispanics. Your answer will then be the % Hispanic in this block group.

Team Chapter Presentations

There will be 6 teams. In addition to various team projects and presentations (see syllabus), each team will make a chapter presentation to the class. The first team will cover chapters 1 and 2. The second team will cover chapter 3. The third team chapter 4 and so on through chapter 7.

Teams 2 through 6 will discuss/outline the chapter and one case study. Team 1 will not have a case study, and so will cover 2 chapters.

Before the second class, I will post the schedule and chapters for each team.

Plan for First Class

Here's what I want for us to do:

1. Discuss syllabus
2. Explore DFW Pizzeria Demo Data
3. Explore real estate consulting firms
   
1. Form teams and email group names and firm
1. Each student email: (1) Team Name, (2) Firm Name, (3) Firm FID
2. No firms from Dallas or Tarrant counties
   
4. Explore American FactFinder
1. Which block group in Tarrant County has the highest median household income?
2. What is the % African American population within this block group?
   
5. Discuss homework