SELECT stStateName,stCityName,stUrlSlug,stStateAbbr FROM tbl_states WHERE stStateName LIKE 'California' AND stCityName LIKE 'San-diego'