search

DataUSA / datausa-site

The most comprehensive visualization of U.S. public data —
www.datausa.io
GNU Affero General Public License v3.0
97 stars 28 forks source link

only Nation/State/PUMA should use PUMS for industry/occupation vizs #788

Closed jspeis closed 5 years ago

jspeis commented 5 years ago

Expected Behavior

Vizzes related to industry/occupation counts for MSA/places should use ACS instead of PUMS because the PUMS data won't actually cover the same geography. (Nation/State/PUMA levels however can use PUMS)

https://datausa.io/profile/geo/new-york-ny/#tmap_occ_num_emp https://datausa.io/profile/geo/new-york-ny/#tmap_ind_num_emp

Current Behavior

The industry and occupation data appears to come from PUMS instead of ACS

Steps to Reproduce (for bugs)

  1. /profile/geo/new-york-northern-new-jersey-long-island-ny-nj-pa-metro-area/
  2. or /profile/geo/new-york-ny
davelandry commented 5 years ago

For myself for later: https://saguaro.datausa.io/api/data?Geography=16000US3651000&measure=Workforce%20by%20Occupation%20and%20Gender,Workforce%20by%20Occupation%20and%20Gender%20Moe&year=latest&drilldowns=Occupation&parents=true

davelandry commented 5 years ago

Dependent on https://github.com/Datawheel/datausa-tracker/issues/230

jspeis commented 5 years ago

just to note: counties should also use the ACS data as well (as is the case on current data usa)

davelandry commented 5 years ago

@jspeis so... another way to look at it would be: Nation and States be the only levels using PUMS? Is that correct?

jspeis commented 5 years ago

Plus PUMA, so only Nation/State/PUMA would use PUMS

davelandry commented 5 years ago

@jspeis this has been addressed on xenium. The change effected not only those 2 tree maps, but also the "top/bottom" bar charts underneath each, as well as the text accompanying each viz.

jspeis commented 5 years ago

I took a look at the new york page and it seems like the data might be coming from the wrong cube for the 'Highest Paid' section for occupations? If it's not using gender I think that viz should be using the acs_ygo_occupation_for_median_earnings_1 cube? cc @hwchen

/profile/geo/new-york-ny#top_occ_med_earnings

https://xenium-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJBQ1MgT2NjdXBhdGlvbiIsIkFDUyBPY2N1cGF0aW9uIiwiT2NjdXBhdGlvbiJdXSwiY3V0cyI6W1tbIjE2MDAwVVMzNjUxMDAwIl0sWyJHZW9ncmFwaHkiLCJQbGFjZSIsIlBsYWNlIl1dLFtbMjAxN10sWyJZZWFyIiwiWWVhciIsIlllYXIiXV1dLCJjdWJlIjoiYWNzX3lnb19vY2N1cGF0aW9uX2Zvcl9tZWRpYW5fZWFybmluZ3NfMSIsIm1lYXN1cmVzIjpbIk1lZGlhbiBFYXJuaW5ncyBieSBPY2N1cGF0aW9uIl19

davelandry commented 5 years ago

@jspeis good catch, I've updated xenium. Is it correct that "Median Earnings by Occupation" is the only one with a rollup table? I'm using the "by Gender" tables for the number of employees, RCA, and all of the Industry charts.