This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to build a network distribution map (example attached). I have an excel file with stores and another for all the distribution centers that serve the stores. The idea is to map all the distribution centers with their corresponding stores in a map. I've tried a couple of things found on the forum but with no luck.
Let's assume that you append the latitude/longitude information to each store and DC record; now we're ready to get started! @Jonathan-Sherman has a great suggest to Join the records together and use the ST_CreateLine( function to draw the connecting line (I did the same thing).
The next steps I take show you how to create a stylized map of these objects using the Report Map tool (plus a trick on the lines).
- The easiest way to get started with the Report Map tool is to connect multiple inputs, one for each item you would like to display. In this case, I have 3 inputs: Stores, DCs, and the lines between. An important note: all three of these input have a [DC] field which we'll use later.
- Before we start configuring our Report Map tool, here's some useful information: you can't apply thematic colors to a line, only points and polygons. What do we do? convert our lines into polygons by drawing a small buffer around it using the Buffer tool.
- Now everything is going into the Report Map tool like we need. The important settings here are under the "Data" tab, set the "Thematic" field for all your inputs to [DC]. This will give us a common field to color coordinate with.
- When we add each of the 3 spatial objects to our map (DC, Stores, Lines), there is a "Theme" option that we can set to "Unique Value" and "Map". This will map each of the unique DC field values to a unique color.
Check out the attached example to see an example of all this in action.
I've got it working but I've got one problem...when I using the Report Map Function, the lines disappear! I tried playing around with the settings in the Setings/Data/Layers/Legend tabs but can't get it working. Examples attached!