Questions for Lab#5


1. How many houses in Neighborhood parcels have more than 1600 square feet of space?

 7

2. How many houses in Neighborhood parcels have a pool?

 5

3. How many houses in Neighborhood parcels have 3 or more bedrooms and 1.5 or more bathrooms?

 12

4. How many houses in Neighborhood parcels are for sale for less than $100,000 and have at least 1000 square feet of space?

 11

5. What exact query did you use to select the correct parcels in #4?  Copy and paste it here:

 "SALE_PRICE" <100000 AND "SQ_FT" >=1000

6. Among the properties in Other parcels, what is dollar value of the parcel with the highest property value?

$1,175,032

7. What are the names of the two cross-streets for this parcel (in #6, above)?

 Colton and Texas

8. Who owns the parcel immediately to the south of this parcel (in #6, above)?

The Salvation Army

9. What is the file extension used to designate a data or attribute table? (Hint: These are known as database files.)

.dbf

10. What are the ID numbers and recommended remedial actions for each of the pits containing lead?

23_w_15134: Operator needs to submit plan to LADNR for clean-up procedure for approval.
50_w_26291: Operator needs to submit plan to LADNR for clean-up procedure for approval.
29_p_158: <Null>