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; } } }

Turn fields off by script

MattEiben

I've been beating my head against a wall for a full workday trying to figure this one out. What I want to accomplish is to turn a number of fields off in a feature layer. There is a method using the fieldInfo() method, but that only seems to work when creating a NEW feature layer. I want to apply the turned off fields to the EXISTING layer.

Code example below

mxd = arcpy.mapping.MapDocument("CURRENT")  df = arcpy.mapping.ListDataFrames(mxd, "*")[0]  LayerNeedsFieldsTurnedOff = arcpy.mapping.ListLayers(mxd, "Layer Name", df)[0]  desiredFields = ["LAST","FIRST","CITY","ZIP"]  # This makes the field_info object that can then be applied to a layer field_info = arcpy.Describe(LayerNeedsFieldsTurnedOff).fieldInfo for index in xrange(0, field_info.count):     if field_info.getfieldname(index) not in engineFields:         field_info.setvisible(index,"HIDDEN")

This is where I'm not sure what to do, all the examples show making an new layer like:

arcpy.MakeFeatureLayer_management(LayerNeedsFieldsTurnedOff,"temp_layer","","",field_info)

This however set's me down a rabbit hole I really don't want to go down. (duplicate layers, symbology, labeling, etc...) Is there a way to apply the field visibilities back to the original layer and not a new one?

Thanks in advance!

Encuentra más publicaciones etiquetadas con

Accepted answers

T__WayneWhitley

I wasn't entirely satisfied with the following code, but seems to do the trick - it comes with the caveat that you have to 'manually' code other things like labeling. Maybe I am missing something but found that since I 'stamped' what seems to be a new layer from the MFL execution to include the field_info obj, it dropped my labeling. It also wrote 'temp_layer' in the Description property. But my layer is written with at least the correct field_info settings.

<SPAN class="keyword token">import</SPAN> arcpy
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>addOutputsToMap <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'your path to target mxd'</SPAN><SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'*'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
LayerNeedsFieldsTurnedOff <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'your target layer name'</SPAN><SPAN class="punctuation token">,</SPAN> df<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; 

<SPAN class="comment token"># fill in your desired fields to remain visible </SPAN>
desiredFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'fieldname0'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldname1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldname2'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'etc'</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; 
field_info <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>fieldInfo 
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>field_info<SPAN class="punctuation token">.</SPAN>count<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field_info<SPAN class="punctuation token">.</SPAN>getfieldname<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> desiredFields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field_info<SPAN class="punctuation token">.</SPAN>setvisible<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'HIDDEN'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> field_info<SPAN class="punctuation token">)</SPAN>&nbsp; 
refLyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>Layer<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 

<SPAN class="comment token"># rename the ref layer the same as your target layer </SPAN>
refLyr<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'your target layer name'</SPAN>&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>ApplySymbologyFromLayer_management<SPAN class="punctuation token">(</SPAN>refLyr<SPAN class="punctuation token">,</SPAN> LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">)</SPAN> 
arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>UpdateLayer<SPAN class="punctuation token">(</SPAN>df<SPAN class="punctuation token">,</SPAN> LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">,</SPAN> refLyr<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
mxd<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 

<SPAN class="comment token"># clean up</SPAN>
<SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'\'temp_layer\' still in memory...deleting now...'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'deleting obj refs...'</SPAN> 
<SPAN class="keyword token">del</SPAN> mxd<SPAN class="punctuation token">,</SPAN>LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">,</SPAN> refLyr 
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'done.'</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>

Just a further note - seems you could 'mine' properties from a lyr library or another mxd (or such library) to more easily 'reapply' these properties, for instance, like labeling.

-Wayne

All comments

T__WayneWhitley

Yes, I wholeheartedly agree...good catch.
If you will, go ahead and mark this thread answered so that it is closed. You are new to the forum, so if you don't know how, just fiddle with the button controls over to the right of the posts. You have to be logged in; you can only 'checkmark' one post, next to the one you feel represents the best answer (or, if you feel so inclined, do not mark an answer)...toggle up for points next to any posts you want to award. That's it, oh and welcome to the forums - good start!

Enjoy,
Wayne

MattEiben

This is exactly what I was looking for! I was getting pretty close, but that neatly ties it up. Thanks for the code sample. 🙂 Hopefully, ESRI makes fieldInfo() a write attribute in the future, that would make this a little less roundabout. Thanks again!

Matt

T__WayneWhitley

<SPAN class="keyword token">import</SPAN> arcpy
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>addOutputsToMap <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">False</SPAN>
mxd <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>MapDocument<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'your path to target mxd'</SPAN><SPAN class="punctuation token">)</SPAN>
df <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListDataFrames<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'*'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
LayerNeedsFieldsTurnedOff <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>ListLayers<SPAN class="punctuation token">(</SPAN>mxd<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'your target layer name'</SPAN><SPAN class="punctuation token">,</SPAN> df<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; 

<SPAN class="comment token"># fill in your desired fields to remain visible </SPAN>
desiredFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'fieldname0'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldname1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fieldname2'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'etc'</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; 
field_info <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>fieldInfo 
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>field_info<SPAN class="punctuation token">.</SPAN>count<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> field_info<SPAN class="punctuation token">.</SPAN>getfieldname<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> desiredFields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field_info<SPAN class="punctuation token">.</SPAN>setvisible<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'HIDDEN'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">''</SPAN><SPAN class="punctuation token">,</SPAN> field_info<SPAN class="punctuation token">)</SPAN>&nbsp; 
refLyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>Layer<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 

<SPAN class="comment token"># rename the ref layer the same as your target layer </SPAN>
refLyr<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">=</SPAN> <SPAN class="string token">'your target layer name'</SPAN>&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>ApplySymbologyFromLayer_management<SPAN class="punctuation token">(</SPAN>refLyr<SPAN class="punctuation token">,</SPAN> LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">)</SPAN> 
arcpy<SPAN class="punctuation token">.</SPAN>mapping<SPAN class="punctuation token">.</SPAN>UpdateLayer<SPAN class="punctuation token">(</SPAN>df<SPAN class="punctuation token">,</SPAN> LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">,</SPAN> refLyr<SPAN class="punctuation token">,</SPAN> <SPAN class="token boolean">False</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
mxd<SPAN class="punctuation token">.</SPAN>save<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 

<SPAN class="comment token"># clean up</SPAN>
<SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'\'temp_layer\' still in memory...deleting now...'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'temp_layer'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'deleting obj refs...'</SPAN> 
<SPAN class="keyword token">del</SPAN> mxd<SPAN class="punctuation token">,</SPAN>LayerNeedsFieldsTurnedOff<SPAN class="punctuation token">,</SPAN> refLyr 
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'done.'</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>

Just a further note - seems you could 'mine' properties from a lyr library or another mxd (or such library) to more easily 'reapply' these properties, for instance, like labeling.

-Wayne

MattEiben

Thanks for your reply,

I think I understand the general idea you're getting at there. My code left off with a field_info object needing to be assigned to a Layer.

I went ahead and did :

arcpy.MakeFeatureLayer_management(LayerNeedsFieldsTurnedOff,"temp_layer","","",field_info)

This resulted in a feature layer that does have the fields turned off as desired, though symbology and labeling got messed up (that can be fixed layer).

With the fields fixed in the "temp_layer", I used the arcpy.mapping.UpdateLayer like this:

tempLayer = arcpy.mapping.Layer("temp_layer")
arcpy.mapping.UpdateLayer(df,arcpy.mapping.Layer(LayerNeedsFieldsTurnedOff, tempLayer)

Unfortunately, it looks like the UpdateLayer method doesn't carry over the field information to the original layer. The only method I've seen so far that even accepts the FieldInfo() object as an argument seems to be MakeFeatureLayer.

I suspect what I'm looking to do may not be possible with existing arcpy, as the layer docs show .fieldInfo as being a 'read only' property.
http://resources.arcgis.com/en/help/main/10.1/index.html#//018v00000063000000

If you have any sample code, I'd love to take a look at it though! Probably won't be able to tinker with it until next week Monday though.

T__WayneWhitley

Interesting...I haven't tried this but can you use the UpdateLayer command?

What I mean is, maybe it is possible to create a new layer obj (as you already know how to do) from your map feature layer, then go through similar steps as you seem to already have a handle on with your posted code, then 'stamp' your map layer object (using UpdateLayer) with your new layer object with the fieldInfo object associated with it (which has the fields turned on/off as you wish).

Does that make sense? - you already have most of the code and I am assuming you successfully defined the new layer field visibility?
When you ListLayers and get a handle on the appropriate layer within your mxd (or lyr), supposedly you can switch layer objects. It's been a little while since I've tried it but think it works, see the syntax and webhelp ref below. There are good bits of sample code at the webhelp or I can dig up some of my code later if you still need it.

Hope you get it going--
Wayne

UpdateLayer (data_frame, update_layer, source_layer, {symbology_only})

UpdateLayer (arcpy.mapping)
Desktop » Geoprocessing » ArcPy » Mapping module » Functions
http://resources.arcgis.com/en/help/main/10.2/index.html#//00s30000003p000000

EDIT:
By the way, there is a similar post I made here using the fieldInfo object to set the ratio policy of a 'new' feature layer to subsequently use in Intersect processing. I'd like to test (when I get to my other computer) whether I can extend the code posted there to 'grab' the layers from a map doc and similarly set the visibility on the fieldInfo and combine that with the Intersect (or any other overlay processing) and use the output layer to update an existing lyr in the map doc. It would not be a stretch...let me know how yours works. If I remember, I will later post the test I just mentioned.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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