I'm trying to figure out an easy way to take county level jobs point data (exported from the Census bureau's OnTheMap) and merge it with census block groups in order to give each block group a total amount of jobs.
The idea would be to visualize total jobs in a similar way as you can visualize total population on the block group level.
So far I have my block groups from TIGER block group shapefiles and I have my jobs point shapefile, but combining them is proving difficult as OnTheMap is pretty rough. I could, I believe, select each census block group in OnTheMap and export the data, add it up myself into a spreadsheet and combine them all manually to join by way of block group number, but that would take so long.
There has to be a better way, right?
I figure I should be able to run an anaysis of which points are falling in which blockgroup polygon and intersect them via that, but it doesn't work.