nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Layer symbology - adjust to new attribute values

RobertFritz2

Hi,

I have got many layers each one with extensive symbology. Now I need to change the data source for these layers. The new data sources have different table names (no problem), different field names (no problem) and different values. Now I struggle with the values - I thought I could just edit the values and replace them (such as "1" with "510"). But I can't figure out how. Is that possible (ArcMap 10.3)? I don't want to create lookup tables as suggested somewhere else. If I cant change values used in layer symbology in ArcMap - could it be done using ArcPy (yes / no)?

Thanks, Rob

Najděte více příspěvků označených jako

Accepted answers

XanderBakker

If I understand you correctly, you have many layers with different schemas (fields, etc) but they all have a field that represents the same type of information, however each layer may use it's own values.

Normally you would use domains, but I am sure that this is data provided to you and you have had no influence over the way data is managed.

In this case I would suggest to work with LUTs (lookup tables) or some source that you can use to interpret a value and assign the correct one. You could use a script that does this for you, but any solution you choose will require you to indicate which value needs to be mapped to the correct value.

To provide some example of a script that do the mapping between the value, here's an example:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> arcpy

&nbsp;&nbsp;&nbsp; lut <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\some\path\to\yourData.gdb\yourLUT'</SPAN>
&nbsp;&nbsp;&nbsp; fld_source <SPAN class="operator token">=</SPAN> <SPAN class="string token">'name of field with source values'</SPAN>
&nbsp;&nbsp;&nbsp; fld_correct <SPAN class="operator token">=</SPAN> <SPAN class="string token">'name of field with correct values'</SPAN>

&nbsp;&nbsp;&nbsp; fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\some\path\to\yourData.gdb\yourFeatures'</SPAN>
&nbsp;&nbsp;&nbsp; fld_input_value <SPAN class="operator token">=</SPAN> <SPAN class="string token">'your field with wrong values'</SPAN>
&nbsp;&nbsp;&nbsp; fld_output_value <SPAN class="operator token">=</SPAN> <SPAN class="string token">'new field to store correct values'</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create dictionary from LUT</SPAN>
&nbsp;&nbsp;&nbsp; dct_lut <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>lut<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>fld_source<SPAN class="punctuation token">,</SPAN> fld_correct<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># add field to output, will overwrite value if output field already exists</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fld_output_value<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># adjust to type of field</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fld_output_value<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN> 

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># update the values using the lut</SPAN>
&nbsp;&nbsp;&nbsp; fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>fld_input_value<SPAN class="punctuation token">,</SPAN> fld_output_value<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in_value <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> in_value <SPAN class="keyword token">in</SPAN> dct_lut<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> dct_lut<SPAN class="punctuation token">[</SPAN>in_value<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; curs<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

(not tested)

All comments

RobertFritz2

Hi Xander,

many thanks. The new data source will be in place for a long time as the data model has been simplified and standardized. Using lookup tables won't solve my problem in the long term. At some point I just need to adapt layer symbology to the new values.

I assume there is already a feature request in place to be able to modify/change the values in layer symbology? Or maybe thats already possible with ArcGIS Pro (although that wouldn't help me either as I need to publish to MDX to our server). Anyway - looks like I cant do it the way I thought,

Rob

XanderBakker

Normally you would use domains, but I am sure that this is data provided to you and you have had no influence over the way data is managed.

To provide some example of a script that do the mapping between the value, here's an example:

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">import</SPAN> arcpy

&nbsp;&nbsp;&nbsp; lut <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\some\path\to\yourData.gdb\yourLUT'</SPAN>
&nbsp;&nbsp;&nbsp; fld_source <SPAN class="operator token">=</SPAN> <SPAN class="string token">'name of field with source values'</SPAN>
&nbsp;&nbsp;&nbsp; fld_correct <SPAN class="operator token">=</SPAN> <SPAN class="string token">'name of field with correct values'</SPAN>

&nbsp;&nbsp;&nbsp; fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\some\path\to\yourData.gdb\yourFeatures'</SPAN>
&nbsp;&nbsp;&nbsp; fld_input_value <SPAN class="operator token">=</SPAN> <SPAN class="string token">'your field with wrong values'</SPAN>
&nbsp;&nbsp;&nbsp; fld_output_value <SPAN class="operator token">=</SPAN> <SPAN class="string token">'new field to store correct values'</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create dictionary from LUT</SPAN>
&nbsp;&nbsp;&nbsp; dct_lut <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN> r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>lut<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN>fld_source<SPAN class="punctuation token">,</SPAN> fld_correct<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># add field to output, will overwrite value if output field already exists</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fld_output_value<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># adjust to type of field</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>AddField_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fld_output_value<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"SHORT"</SPAN><SPAN class="punctuation token">)</SPAN> 

&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># update the values using the lut</SPAN>
&nbsp;&nbsp;&nbsp; fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>fld_input_value<SPAN class="punctuation token">,</SPAN> fld_output_value<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> flds<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> curs<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; in_value <SPAN class="operator token">=</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> in_value <SPAN class="keyword token">in</SPAN> dct_lut<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> dct_lut<SPAN class="punctuation token">[</SPAN>in_value<SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; curs<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> __name__ <SPAN class="operator token">==</SPAN> <SPAN class="string token">'__main__'</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; main<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

(not tested)

RobertFritz2

Hi Dan,

I need to adjust the attribute values used for symbolizing features.

I changed the data source and the field Name (was: symby, is now: objektart_id).

With the Change in data source the attrbute values ahve changed as well, such as that SYMBY = 1 equals OBJEKTART_ID 510.

So I want to swap the Attribute values but retain the symbolization.

I have many layers each with extensive symbology.

Ideally I could save the layer file as XML and modify the values there but ArcMap doesnt allow this. Is there any other way to achieve this with reasonable effort? ArcPy would be an Option as well.

Screenshot is attached,

Thank you, Rob Layer_Properties_Symbology

DanPatterson_Retired

Is it a label or a separate text element? What are the values you want to convert? That will determine the approach if any

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.