How did the border wall affect San Diego? Well, in 1986 the San Diego Border Patrol Sector accounted for 1/3 of all apprehensions at the U.S.-Mexico border.
Today, it accounts for only a small fraction. That means the wall worked.
Check out this piece from the Daily Signal called "Underreported: How Building a Border Wall Changed San Diego."