ArcGIS Pro 3.8 API Reference Guide
ArcGIS.Desktop.Mapping Namespace / ClassBreaksRendererDefinition Class / ExclusionClause Property
Example

In This Topic
    ExclusionClause Property (ClassBreaksRendererDefinition)
    In This Topic
    Gets or sets a SQL statement to exclude features while computing class breaks.
    Syntax
    public string ExclusionClause {get; set;}
    Public Property ExclusionClause As String
    Example
    Create a feature layer with class breaks renderer
    {
      string colorBrewerSchemesName = "ColorBrewer Schemes (RGB)";
      StyleProjectItem colorBrewerStyle = Project.Current.GetItems<StyleProjectItem>().First(s => s.Name == colorBrewerSchemesName);
      string colorRampName = "Greens (Continuous)";
      IList<ColorRampStyleItem> colorRampListFromTheStyle = await QueuedTask.Run(() =>
        colorBrewerStyle.SearchColorRamps(colorRampName));
    
      ColorRampStyleItem colorRampFound = colorRampList[0];
      GraduatedColorsRendererDefinition gcDef = new GraduatedColorsRendererDefinition()
      {
        ClassificationField = "CROP_ACR07",
        ClassificationMethod = ArcGIS.Core.CIM.ClassificationMethod.NaturalBreaks,
        BreakCount = 6,
        ColorRamp = colorRampFound.ColorRamp,
        SymbolTemplate = SymbolFactory.Instance.ConstructPolygonSymbol(
                                ColorFactory.Instance.GreenRGB, SimpleFillStyle.Solid, null).MakeSymbolReference(),
        ExclusionClause = "CROP_ACR07 = -99",
        ExclusionSymbol = SymbolFactory.Instance.ConstructPolygonSymbol(
                                ColorFactory.Instance.RedRGB, SimpleFillStyle.Solid, null).MakeSymbolReference(),
        ExclusionLabel = "No yield",
      };
      var featureLayerCreationParams = new FeatureLayerCreationParams((new Uri(@"c:\Data\CountyData.gdb\Counties")))
      {
        Name = "Crop",
        RendererDefinition = gcDef
      };
      await QueuedTask.Run(() =>
        LayerFactory.Instance.CreateLayer<FeatureLayer>(featureLayerCreationParams, map));
    }
    Requirements

    Target Platforms: Windows 11 Home, Pro, Enterprise (64 bit)

    ArcGIS Pro version: 3.0 or higher.
    See Also