Midterm Practice Questions

1. How many foreclosures are currently available in Tarrant County with a Property Status as 'New Listing' (status option available on form)? (dowload page)

• Data
• Answer: 52
  

2. Geocode the foreclosures listed from answer #1 using TAD parcel shapefile. What % of addresses are not geocoded? (No sufficient address match found.)

• 0%
  

3. What is the street number and street name of the foreclosure property with the highest square feet? (If a tie occurs, list them all.)

• 8122 Abbey Glen Ct
  

4. What is the price per square foot of this property?

• $50.04
  

5. Which foreclosure property has the lowest price per square foot?

• 4008 Wiman Drive
  

6. What is the crime rate (total crime index) within .5 mile radius around this property? (demo data) (spatial join tools)

• 171.09
  

7. How many other foreclosures are currently available within this .5 mile radius?

• 0 (because each buffer contains itself as the point)
• Right-click the buffer and joins/joins and relates
• Make sure it is a spatial join
• select the points in the drop down menu to join to the buffers
• FILE LOCATION/NAME !!! Beware of it
• OK
  

8. Which MLS contains the highest number of other MLS within .25 miles that contain within one bedroom. (Data) (super spatial join)


The field to average FOR THIS PARTICULAR QUESTION does not matter, but the script requires it so pick one.

• 6042 MERCEDES AVE
• 5906 MCCOMMAS BLVD
• 6015 MCCOMMAS BLVD
• 5946 MCCOMMAS BLVD