topic Re: SQL query for symbology in Python Questions

SQL query for symbology

LawrenceFujiwara — Wed, 05 Jun 2013 19:14:40 GMT

Hi,

I was working with ArcMap when I noticed that there are no SQL query for symbology like they have for labels. (I want to select from more than one attribute to display)

I was wondering if I would need to write out a script to have a SQL query for the symbology.

I personally have no knowledge in writing any scripts so would like to avoid it but if there is no way how would I go about writing this.

Any help is appreciated.

Thank you.

Re: SQL query for symbology

KerryAlley — Wed, 05 Jun 2013 19:45:56 GMT

Hi Lawrence,

It isn't possible to have multiple "Symbol Classes" that behave similarly to "Label Classes," with or without Python. Whenever I want to apply different symbologies to the same layer/dataset, I create multiple copies of the original layer and then give each copy its own definition query and symbology. Even if you wanted to automate this process with Python, you'd still have to have pre-existing layer files with the desired definition queries and symbologies, which could then be imported into your new layers.

Good luck!
Kerry

Re: SQL query for symbology

RhettZufelt — Wed, 05 Jun 2013 20:25:39 GMT

If you just want to display based on more than one attribute, does the Categories, Unique values, many fields option not work?

Also, you can create a style file and have it automatically assign symbology based on the categories in the styles file.

See here for the options:

http://resources.arcgis.com/en/help/main/10.1/index.html#/Drawing_a_layer_using_categories/00s50000003m000000/

R_

Re: SQL query for symbology

LawrenceFujiwara — Wed, 05 Jun 2013 20:32:49 GMT

"Unique values with many field" is exactly what I needed.

Thank you!