def bldg_sqft(parcels, buildings):
    """
    Total built square feet per parcel.

    """
    b = buildings.to_frame(['parcel_id', 'total_sqft'])
    return b.groupby('parcel_id')['total_sqft'].sum().reindex(parcels.index).fillna(0)