Working for a state commerce agency, you are asked to report the number of jobs created in each Senate and House district. You are given recent data from an industrial extension jobs survey to complete this task. The problem is centered around how to get the data you need from several different resources when the relationship between data are not always singular, i.e. one-to-many or many-to-one with tabular or spatial joins.
First you need to look for what information/fields you need from each data set and see what kind of object identifier is present. Go through and select only the data you need using select by attribute, eliminating any data outside of NC. You then have to decide the best way to join the data with the Senate and House district shapefiles. For this problem, a spatial join was used.
Senate Job Creation Map House Job Creation Map
More sweet potatoes are grown in NC than in any other state. You client wants to know the number of sweet potato growers located in each river basin in NC, which is home to 17 river basins total.
Industry data from the Bureau of Labor Statistics, State of NC shapefile, River Basins of NC Shapefile.
The first thing you need to do is limit your geographic area to NC. Since only 2 river basins are wholly contained within the state, you need to clip the area to NC only. When looking at sweet potato growers in NC, the BLS data is calculated by the number of growers per county. This data should be converted to a point file based on address. Once this has been done you need to figure out what kind of join you'd need with the NC /river basin shapefile. In this case a spatial join would be proper.