U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > U.S. Forums > General U.S.
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
Reply Start New Thread
 
Old 03-30-2018, 09:41 AM
 
Location: From Michigan. Now in Memphis, TN
130 posts, read 197,259 times
Reputation: 181

Advertisements

Hi. I made this map of major private supersector industry by county in the US for the 3rd quarter of 2017. I thought perhaps you all might find something of interest in it so I decided to share it. I'd love to hear any enlightened analysis you can provide about the way the data shaped up.

Reply With Quote Quick reply to this message

 
Old 03-30-2018, 09:42 AM
 
Location: From Michigan. Now in Memphis, TN
130 posts, read 197,259 times
Reputation: 181
This map is an original creation. I sorted through all of the data by state, exported it, cleaned it, and encoded it in Excel to get the results which I then added to the map by hand coloring every county in MS Paint (tool).
Note: The data used was raw numbers of employed persons by supersector and by county. This data all comes from the Quarterly Census of Employment and Wages for the 3rd quarter of 2017 provided by the Bureau of Labor Statistics, a bureau of the United States Department of Labor (source).
To better understand the industry supersectors, here are the sectors for each supersector:
Natural resources and mining:
• Agriculture, Forestry, Fishing and Hunting
• Mining, Quarrying, and Oil and Gas Extraction
Construction:
• Construction of Buildings
• Heavy and Civil Engineering Construction
• Specialty Trade Contractors
Manufacturing:
• Food Manufacturing
• Beverage and Tobacco Product Manufacturing
• Textile Mills
• Textile Product Mills
• Apparel Manufacturing
• Leather and Allied Product Manufacturing
• Wood Product Manufacturing
• Paper Manufacturing
• Printing and Related Support Activities
• Petroleum and Coal Products Manufacturing
• Chemical Manufacturing
• Plastics and Rubber Products Manufacturing
• Nonmetallic Mineral Product Manufacturing
• Primary Metal Manufacturing
• Fabricated Metal Product Manufacturing
• Machinery Manufacturing
• Computer and Electronic Product Manufacturing
• Electrical Equipment, Appliance, and Component Manufacturing
• Transportation Equipment Manufacturing
• Furniture and Related Product Manufacturing
• Miscellaneous Manufacturing
Trade, transportation, and utilities:
• Wholesale Trade
• Retail Trade
• Transportation and Warehousing
• Utilities
Information:
• Publishing Industries (except Internet)
• Motion Picture and Sound Recording Industries
• Broadcasting (except Internet)
• Telecommunications
• Data Processing, Hosting, and Related Services
• Other Information Services
Financial activities:
• Finance and Insurance
• Real Estate and Rental and Leasing
Professional and business services:
• Professional, Scientific, and Technical Services
• Management of Companies and Enterprises
• Administrative and Support and Waste Management and Remediation Services
Education and health services (this includes public and private employees):
• Educational Services
• Health Care and Social Assistance
Leisure and hospitality:
• Arts, Entertainment, and Recreation
• Accommodation and Food Services
Other services:
• Repair and Maintenance
• Personal and Laundry Services
• Religious, Grantmaking, Civic, Professional, and Similar Organizations
• Private Households
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 10:16 AM
 
Location: TOVCCA
8,452 posts, read 11,431,560 times
Reputation: 12307
Nice work!
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 10:20 AM
 
3,570 posts, read 1,519,707 times
Reputation: 3011
I do A LOT of in-depth research on metros, have done so since 1985. Looks like you put a lot of time and effort into your map. You did a great job.
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 10:48 AM
 
Location: Seattle
409 posts, read 245,526 times
Reputation: 987
Really cool, thanks for sharing.
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 01:25 PM
 
Location: Clemson, SC by way of Tyler,TX
4,851 posts, read 2,978,355 times
Reputation: 3399
very nice
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 01:34 PM
 
Location: Zurich, Switzerland/ Piedmont, CA
32,342 posts, read 55,140,686 times
Reputation: 15409
Congrats. I appreciate your work.
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 01:50 PM
 
Location: From Michigan. Now in Memphis, TN
130 posts, read 197,259 times
Reputation: 181
Thank you all. Feel free to offer explanations for things. I discovered a few things in compiling this map:

1) the service industry is overtaking the manufacturing industry by even larger numbers than I thought. Many heavy manufacturing counties in Indiana, Michigan, Ohio were almost ties between manufacturing and trade but flipped in favor of trade (retail).
2) this map really shows the decline of the coal industry in West Virginia, Kentucky, and Pennsylvania. There were many counties where trade had clearly taken over what was once a mining-dominated county.
3) counties where education prevails over trade or manufacturing tend to clump together.
4) you can see some predominate features on this map like the Rocky Mountains where leisure prevails and some parts of the Appalachians. It's also a useful map for finding out where to go on vacation.
5) some major companies can be seen like State Farm in Bloomington, IL.
6) you can see the remainder of the Rust Belt on this map and how it cuts Ohio in half.
7) West Texas oil drilling is very noticeably marked on this map.
8) suburbs of big cities often have professional and business services as their major industry.
9) agriculture is no where near as dominant an industry in terms of raw numbers of employment as it can appear to be by driving around the country.
10) there is also a smattering of Professional and business and Construction counties in rural areas. Those I can't yet explain.

If you notice anything else I'd love to hear about it!
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 02:36 PM
 
1,701 posts, read 1,364,251 times
Reputation: 1743
This is interesting - thanks for posting!
Reply With Quote Quick reply to this message
 
Old 03-30-2018, 02:38 PM
 
2,000 posts, read 1,015,925 times
Reputation: 2667
Map must have been removed. Thread should be closed, without it.
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:

Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > U.S. Forums > General U.S.
Follow City-Data.com founder on our Forum or

All times are GMT -6.

2005-2019, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 - Top