I have two PostGIS tables. One is the DMA and another of states
I'm trying to draw a boundary from the states table onto the DMA table to show what state a particular DMA fall on, since DMA can fall onto multiple states (for instance, Denver DMA covers both CO and UT).
This question is similar to this except I can't get the code to work since it seems to referenced only one table.
I have an idea to create a loop that will query each state and separating the DMAs and then recombining it together but that seems a bit tedious, there has to be another way. Thanks!
أكثر...
I'm trying to draw a boundary from the states table onto the DMA table to show what state a particular DMA fall on, since DMA can fall onto multiple states (for instance, Denver DMA covers both CO and UT).
This question is similar to this except I can't get the code to work since it seems to referenced only one table.
I have an idea to create a loop that will query each state and separating the DMAs and then recombining it together but that seems a bit tedious, there has to be another way. Thanks!
أكثر...