Class Plan (02/14)

Happy Valentine's Day!!

Class Exercise: Which foreclosure property in Tarrant County has the lowest value compared to its previous sales in the neighborhood? -- If we do not make it through today, we will continue next week --

We will consider the following factors when selecting which properties to include as comparables:

1. Number of Bedrooms
2. Square Foot
3. Year Built
   

Steps:

1. Download the Good Data:
1. Latest Foreclosure Listings (website here)
   
2. TAD Parcel Shapefile (same as we used last week)
3. Tarrant County MLS Data (older data for learning purposes - promise new data next week)
4. Super Spatial Join Script (academic purposesd only)
   
2. Create Address Locator (copied from last week)
   
1. Add parcel shapefile to ArcMap
2. ArcToolbox/Geocoding Tools/Create Address Locator
3. Address Locator Style: 'US One Address with Zone'
4. Reference Data: 'tadParcelsCity' // Role: 'Primary Table'
   
5. Field Mapping:
• House Number: 'Street_No'
• Prefix Direction: 'PREDIR'
• Prefix Type: NONE
• Street Name: 'STREET_NAM'
• Street Type: STREET_TYP'
• Suffix Direction: 'PostDir'
• Zone: 'CITY_NAME'
  
6. Specify a location and name for the lcoator
7. OK
3. Filter MLS Table for Necessary Fields:
1. Filter All Records for SLD in the 'Status' field
1. Use the Autofilter (Tools/Filter/Autofilter)
2. Copy results to new Excel Table
   
2. Copy Needed Fields to New Excel Table
   
1. Minimum Field Necessary:
1. ADDRESS (for geocoding)
2. CITY (for geocoding)
3. BEDS (comparable criteria)
   
4. SQUAREFT (comparable criteria)
5. AGE (comparable criteria)
6. TPRICESOLD (price per square foot)
4. Add Filtered Table to ArcMap
5. Geocode Table (copied from last week)
1. Right-click table in ArcMap and select 'Geocode Addresses'
2. Select the appropriate Address Locator and select OK
3. Street: 'Address'
4. Zone: 'City'
5. Specify location and name for output shapefile
6. OK
6. NEXT WEEK!! Obtain TAD's Data into Foreclosure Shapefile
1. Spatial Join from foreclosure shapefile to TAD parcel boundaries
1. Right-click on foreclosure shapefile and select join
2. spatial join
   
7. Buffer Foreclosure Points
1. ArcToolbox/Analysis Tools/Proximity/Buffer
2. Specify Input, Output, and Distance (measurement and units)
3. OK
8. Standard Spatial Join (the way we have been doing it)
1. !! This Step For Comparing Purposes Only !!
2. !! Better to Use Super Spatial Join !!
   
3. Right-click the geocoded foreclosures (use the results of the parcel geocode) and select Joins & Relates/Join
1. What Do You Want to Join to this Layer: 'Join data from another layer based on spatial location'
2. Choose the layer to join to this layer: 'tadParcelsCity'
3. Each point will be given all the attributes of the polygon that: 'it falls inside'
4. Specify location and name for output shapefile
5. OK
9. Super Spatial Join
1. Ensure that you downloaded the script and installed it to the C:/ direcotry (which is the default).
2. Run C:/reae5392/superSpatialJoin.mxd
3. Add Buffer and MLS Points
4. Click the Smiley Super Spatial Join Button
1. Acknowledge & Agree
2. Join Layer - MLS
3. Input Layer - Foreclosures
5. Might Take a While.......