You can find a list of the SCYSA affiliated clubs at this website:

http://www.scysa.org/about/clubs.aspx

You are correct CESA Spartanburg doesn't show up. I believe on last year's list CESA Columbia was shown under the Midstate heading. Not sure why CESA Spartanburg isn't showing up in the Piedmont District list.