Of all the country’s major metro areas, the San Jose-San Francisco-Oakland area of California has the highest average pay for civilian workers. It was, in fact, 20 percent above the national average in 2009.

But that’s not true for every industry.

The Bureau of Labor Statistics yesterday released a detailed report on how metro areas ranked in pay by occupational category. I’ve embedded the data in a spreadsheet below. A value of 100 represents the average nationwide, and so a value of 110 means the metro area’s pay is 10 percent above the national average (and likewise a score of 90 means the pay is 10 percent below the national average):

Workers in the Brownsville-Harlingen metropolitan area in Texas took in the lowest metro-area pay, earning 79 cents for every dollar earned by workers nationwide.

Compensation in the metro area encompassing San Francisco was highest in several sectors, including professional and related jobs (tied with Salinas, Calif.); service jobs; sales and related jobs (again, tied with Salinas, Calif.); and office and administrative support jobs.

For the other occupational groups: