Skip to content
  • There are no suggestions because the search field is empty.

Setting Irrigation to a Text Value

The attribute ‘Irrigated’ comes through as a 0 or 1, plus many acres that are simply not set to a value and therefore report a blank or NULL value.  To change this to a text, create a pre-calculated column and use this formula and name each what you desire:

 If([Irrigated]=1, "Irrigated", if([Irrigated]=0, "Non-Irrigated", "Non-Irrigated"))

The final 'Non-Irrigated' in the syntax could be changed to "Not Set" or "Unknown" if desired as well - these represent the NULL acres.