How do I find what ZIP codes fall within different DMA areas in MapViewer?

You can find what ZIP codes are within the different DMA areas by utilizing the Query tool in MapViewer.


To do so:

  1. In an empty project, click File | Import. Select the DMA shapefile and click Open.
  2. In the Import Options dialog, in the Assign Coordinate System tab, leave the coordinate system set to Unreferenced local system. In the IDs And Attributes tab, set the PID and SID, then choose any other attributes you want to import and click OK.
  3. Right click in the Object Manager and click New Layer.
  4. Click Map | Create Map | Pin to make a pin map of the US ZIP locations on this new layer. Choose the ExtendedZIP5.csv file from the MapViewer 8 directory and click Open.
  5. In the MapViewer Warning dialog, click Yes to continue with the conversion between known and unknown projections.
  6. Click on the pin map layer in the Object Manager.
  7. In the General tab of the Property Manager, verify that the Locating method is Coordinate, the X coordinate is Column B: Longitude, and the Y coordinate is Column C: Latitude.
  8. Click Analysis | Query | Query.
    1. In the Query section, use the first dropdown to select Create worksheet with.
    2. Select Points from the object list.
    3. Select Layer #2 from the layer list.
    4. Leave the query string ("where" box) empty.
    5. Set the first dropdown box on the second row to in polygons.
    6. Select Layer #1 from the layer list in the second row.
    7. Click in the query string in the second row.
    8. Up in the Add to query string section, use the dropdown next to Show data and attributes to select Layer #1.
    9. Double click PID in the attributes list. This will add this to the query string.
    10. Double click = in the operator list.
    11. Click the Object Attribute Lookup button. Select the DMA area you're interested in and click OK.
    12. Click OK to perform the query.
  9. Use File | Save to save this worksheet in whatever format you want. 
  10. Go back to the Plot1 tab and repeat step 8 for any other DMA regions you're interested in. The last query is remembered by default, so you should just need to change the value of the PID in the query string.

Updated June 8, 2018

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.