Processing LED On the Map Data

1. Processing LED On the Map Data Jeff Arp – Nonprofit Center of Milwaukee

2. On the Map Output

3. http://lehd.did.census.gov/led/onthemap/

4. LED Tables • OD = 4(ja, jp, pa, pp) x 2 (main, aux) = 8 • RAC = 4(ja, jp, pa, pp) x 10(age1, age2, age3, earn1, earn2, earn3, ind1, ind2, ind3,total) = 40 • WAC = 4(ja, jp, pa, pp) x 10(age1, age2, age3, earn1, earn2, earn3, ind1, ind2, ind3,total) = 40 • OD + RAC + WAC = 88 x 6yr = 528

5. LED Tables • OD = 4(ja, jp, pa, pp) x 2 (main, aux) = 8 • RAC = 4(ja, jp, pa, pp) x 10(age1, age2, age3, earn1, earn2, earn3, ind1, ind2, ind3,total) = 40 • WAC = 4(ja, jp, pa, pp) x 10(age1, age2, age3, earn1, earn2, earn3, ind1, ind2, ind3,total) = 40 • OD + RAC + WAC = 88 x 6yr = 528

6. LED Tables • OD = 4(ja, jp, pa, pp) x 2 (main, aux) = 8 • RAC = 4(ja, jp, pa, pp) x 10(age1, age2, age3, earn1, earn2, earn3, ind1, ind2, ind3,total) = 40 • WAC = 4(ja, jp, pa, pp) x 10(age1, age2, age3, earn1, earn2, earn3, ind1, ind2, ind3,total) = 40 • OD + RAC + WAC = 88 x 6yr = 528

8. OD WI Main

9. OD WI AUX

10. The rest of the data

12. DownThemAll OD processing • Extract to CSV Convert to DBF Combine WI 'Main' & Aux files Import WI Records from 'Aux' files of other states

13. Import WI Records from 'Aux' files of other states Add X and Y Coords of block centroid for O & D Calculate O-D Distance Use File for Stats Total on O for Mapping Residents Total on D for Mapping Workplaces

14. Workplaces Residents

15. Workplaces Residents

16. Extract to CSV DownThemAll (age1, age2, age3, earn1, earn2, earn3, ind1, ind2, ind3,total) RAC/ WAC processing Convert to DBF Collapse 10 tables into 1 Put all years into 1 tablefor stats (1 rec per census block per year) Use one year files for mapping

17. Age1 table All Cross table Age2 table Age3 table

19. Workplaces Residents

20. Things to consider • Processing time • HD Space • LED Data issues/anomalies