Parcel (TPO information for parcels created from PAO with join attributes to owner table, building table, permit table and parcel table attribute table)<\/li>
Permit (TPO information is sub-set from:<\/li>
Select from Parcel above with criteria: Issue_Date >= 1/1/1999 and PERMIT_TYP = \u2018COM NEW\u2019 or PERMIT_TYP = \u2018RES NEW\u2019<\/li><\/ul>