This is a recent excavation, made when Tempe widened the Rio Salado road in 2002. This excavation is roughly equivalent in depth to the railroad cut on the south side.  In this excavation, calcrete exists only as thin (a few centimeters at most) white deposits in the rock fractures.  The white bits that you see here and there are the best formed calcrete on the north side of Tempe Butte.  You might want to return to the calcrete discussion on the south side, and remember that it takes a stable (not eroding) surface to form thick calcrete deposits. 

The tilted (or "dipping) layers are called the Tempe Beds.  They consist of alternating bands of sandstone (lighter) and silt/clay shale (darker).  About 20 million years ago, a semi-arid river flowed at this place.  The river carried sand and mud (silt and clay).  The flooding of this river leaves behind deposits as it subsides.  First, the sand is deposited.  Then, as the floodwaters subside even further, the mud is deposited.  Over time, the sand is "lithified" (hardened) into sandstone, and the mud is lithified into shale. 

The whole package of the andesite on top, sandstone and shale in the middle, and rhyolite on the bottom were titled with the development of South Mountain to the southwest.