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 the 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)?
Texas
Street and Colton Avenue
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.
29_p_158: none
50_w_26291: Operator needs
to submit plan to LADNR for clean-up procedure for approval.