St Clair Road is in Britford, which is to the south of Salisbury city centre. My guess is that it would be named after somebody’s surname.
There are at least two Saint Clares (1), but Saint Clair spelt with ‘air’ seems to only be a surname, although perhaps derived from one of the saints (2.)