I have two tables: One is the DMA and another of states
I'm trying to create a third table is will have the state boundaries draw onto the DMA map, since the DMA map does not cleanly break along state lines. For instance, Denver DMA will cover CO and UT. I don't neccessarily need for them to be labeled or named correctly since I will be assigning them new IDs
This is very similar to this question but the answer there does not really address my issue.
I'm thinking of creating a loop that will do the spatial queries by state and separating them out and recombining it all together, but that seems tedious, there has be a better answer. Thanks!
أكثر...
I'm trying to create a third table is will have the state boundaries draw onto the DMA map, since the DMA map does not cleanly break along state lines. For instance, Denver DMA will cover CO and UT. I don't neccessarily need for them to be labeled or named correctly since I will be assigning them new IDs
This is very similar to this question but the answer there does not really address my issue.
I'm thinking of creating a loop that will do the spatial queries by state and separating them out and recombining it all together, but that seems tedious, there has be a better answer. Thanks!
أكثر...