Normally you need to go to the consulate which is in charge for your state. The map is very clear https://www.germany.info/us-de/servi...finder/1217036 . The consulate in San Fransisco is in charge of Wyoming .

But! My dad lives in Florida and normally Miami is the consulate he must go to but last year when he needed to renew his passport there were no appointments available and he got on in Atlanta. The consulate in Atlanta did not really like it but accepted it when he explained that he was not able to get an appointment in Miami.