Solution for creating custom symbology based on 3 fields?

[MatthewRusso]

Below is an example of 3 fields I want to create symbology based on.

Each feeder number(unique value) has to be put on a color ramp.  Each phase I would like to have a line weight designated to. Overhead/Underground should be dashed, or solid.

The feature class i'm working with has thousands of records and I was wondering if anyone has advice on how to script/SQL statement/automate the process.  I do not want to go through indivdually to edit them.

Maybe i am missing something....

Feeder #	Phase	Overhead/Underground
1	1	Overhead
2	1	Underground
3	3	Underground
4	2	Underground
5	1	Overhead
6	3	Overhead
7	3	Overhead
8	2	Underground
9	1	Underground
10	3	Underground
11	2	Overhead
12	2	Overhead
13	2	Overhead
14	1	Overhead
15	1	Overhead
16	1	Underground
17	3	Underground
18	3	Underground
19	3	Underground
20	2	Underground

[TimWitt2]

Hey Matthew,

When you right-click you layer you can go to properties. Go to the symbology tab and on the left choose Multiple Attributes. As value fields you can choose Phase and Overhead. Now click on Add all values. This should let you specify how you want to draw each combination.

Hope this helps!

Tim

[MatthewRusso]

Tim,

This is what I am trying to do but with my layer, I have so many values to individually populate that it would be to time consuming.  I want to be able to set "Rules" for my symbology.  "If Phase = 1 then line weight = 2"  "If Phase = 2 then line weight = 4".  I just ran my file through this and had 5000+ unique records.  I am wondering if you have the ability to give symbology defintions through a geodatabase with  domains etc.

I might be misunderstanding you but thanks!

[TimWitt2]

IF you leave feeder out of your symbology I don't know why it would give you so many unique records. It should only give you 6. If you also use feeder in your symbology then my method won't work since you would have to symbolize too many manually.

I don't think ArcGIS has the capability to symbolize via code.

[XanderBakker]

You may want to look into Representations and Managing overrides with explicit fields in particular:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

You will need a Standard or Advanced license level...

[MatthewRusso]

I'm on 10.1,  I am testing add a representation to a file to see if it fits the need.

Thanks for the info it looks promising.

[MatthewRusso]

That makes sense, I am trying to help out a co-worker with this so maybe I can get him started with this and see what we can make work.

Thanks,

Matt