topic Re: (not) display rows with 0 value with Unique Value Renderer in ArcGIS JavaScript Maps SDK Questions

(not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Thu, 10 May 2018 17:04:19 GMT

I am working on a web app using ArcGISDynamicMapServiceLayers, which use UniqueValueRenderers to draw points based on attributes. In many cases, the attribute value is 0, in which cases I would not want to display anything. If I do not assign some symbol to these values, the service draws the default symbol in those locations. I tried assigning a symbol with 0 opacity (transparent), but when I use an InfoWindow in the web app, a click will still [pick up these invisible symbols.

Is there a way that I can not draw these symbols at all if the attribute value is 0?

The user will choose which attribute to use for rendering the symbols. So that value may be 0 in some cases and nonzero in others.

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Thu, 10 May 2018 17:10:35 GMT

Jason,

Why not set the layer definition expression to exclude those feature with the attribute value of 0?

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Thu, 10 May 2018 17:18:09 GMT

Can I do that after loading the map services? In other words, can I set the layer definition expression dynamically in runtime?

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Thu, 10 May 2018 17:30:08 GMT

Sure.

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Fri, 11 May 2018 12:34:49 GMT

ok I will try that, thanks!

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Fri, 11 May 2018 12:49:54 GMT

Don't forget to mark this question as answered by clicking on the "Mark Correct" link on the reply that answered your question.

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Fri, 11 May 2018 13:54:09 GMT

I will if and when I can get this to work..so far it is not; the definition is applied to the layer, but I can still click on the 'removed' points, and an infoWindow appears with 0 value. I will keep investigating.

update - I confirmed that the layer definitions are being applied; I added a filter to the 'all points' set, and only the points that met the condition are visibly shown. But, I can still click on points that are not visible but are part of the 'all' set, and an InfoWindow appears.

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Fri, 11 May 2018 14:47:11 GMT

Jason,

If you are still getting the popup when clicking on a point that is filtered out using the defention query then are you adding the layer using a ArcGISDynamicMapServiceLayer or a FeatureLayer?

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Fri, 11 May 2018 14:50:02 GMT

ArcGISDynamicMapServiceLayer, i mention 'dynamic map services' in my original question and tags...Ill edit for clarity.

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Sat, 11 Dec 2021 11:02:05 GMT

Jason,

Strange. Here is a sample where all states but Kansas are remove using the definition query and when I click on any other state a popup is NOT displayed.

<!DOCTYPE html>
<html>

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />


  <meta name="viewport" content="initial-scale=1, maximum-scale=1,user-scalable=no">
  <title>Create Map with Custom ArcGISDynamicMapServiceLayer Layer Definitions
  </title>

  <link rel="stylesheet" href="https://js.arcgis.com/3.24/esri/css/esri.css" />
  <style>
    html,
    body,
    #mapDiv {
      padding: 0;
      margin: 0;
      height: 100%;
    }
  </style>

  <script src="https://js.arcgis.com/3.24/"></script>
  <script>
    var map;

    require([
        "esri/map",
        "esri/layers/ArcGISDynamicMapServiceLayer",
        "esri/layers/ImageParameters",
        "esri/dijit/PopupTemplate",
        "dojo/domReady!"
      ],
      function(Map, ArcGISDynamicMapServiceLayer, ImageParameters, PopupTemplate) {

        map = new Map("mapDiv", {
          basemap: "streets",
          center: [-98.258, 38.236],
          zoom: 7
        });

        //Use the ImageParameters to set map service layer definitions and map service visible layers before adding to the client map.
        var imageParameters = new ImageParameters();

        //ImageParameters.layerDefinitions takes an array.  The index of the array corresponds to the layer id.
        //In the sample below an element is added in the array at 3, 4, and 5 indexes.
        //Those array elements correspond to the layer id within the remote ArcGISDynamicMapServiceLayer
        var layerDefs = [];
        layerDefs[5] = "STATE_NAME='Kansas'";
        layerDefs[4] = "STATE_NAME='Kansas' and POP2007>25000";
        layerDefs[3] = "STATE_NAME='Kansas' and POP2007>25000";
        imageParameters.layerDefinitions = layerDefs;

        //I want layers 5,4, and 3 to be visible
        imageParameters.layerIds = [5, 4, 3];
        imageParameters.layerOption = ImageParameters.LAYER_OPTION_SHOW;
        imageParameters.transparent = true;

        var template = new PopupTemplate({
          title: "{STATE_NAME}",
          fieldInfos: [
            {
              fieldName: "STATE_NAME",
              label: "State",
              visible: true
            }, {
              fieldName: "STATE_FIPS",
              label: "Fips",
              visible: true
            }, {
              fieldName: "SUB_REGION",
              label: "Sub Region",
              visible: true
            }
          ]
        });

        var infoTemplates = {
          5: {
            infoTemplate: template,
            layerURL: "https://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Demographics/ESRI_Census_USA/MapServer/5"
          }
        }

        //construct ArcGISDynamicMapServiceLayer with imageParameters from above
        var dynamicMapServiceLayer = new ArcGISDynamicMapServiceLayer("https://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Demographics/ESRI_Census_USA/MapServer", {
          imageParameters: imageParameters,
          infoTemplates: infoTemplates
        });

        map.addLayer(dynamicMapServiceLayer);
      });
  </script>
</head>

<body>
  <div id="mapDiv"></div>
</body>

</html>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Fri, 11 May 2018 15:46:52 GMT

I saw a similar example in ArcGIS's JS sample page...for one, this sample is adding the parameters before the service is added to the map. Also (and more significantly, I think), I am rendering the symbols on the fly by changing the attribute used to define the symbology, as I said in my question. I assign the renderer to a LayerDrawingOptions object, then pass those options to the layer with setLayerDrawingOptions.

I can see the effect of the layer definition visually, but the points are still there, just not visible.

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Fri, 11 May 2018 15:53:04 GMT

Jason,

Since your workflow is not a standard workflow and you have yet to share any relevant code I am not sure I can help you.

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Fri, 11 May 2018 16:31:06 GMT

my code is based on these examples from ArcGIS: this and this. My code base is rather large and hard to give a sample that will encompass everything , but I can try. The basic workflow is:

1) add dynamic map services

2) let user choose an attribute from layer

3) unique symbols based on attribute value are passed to UniqueValueRenderer, which is then assigned as renderer property to a LayerDrawingOptions object

4) drawing options assigned to layer visa setLayerDrawingOptions, then layer made visible with setVisibleLayers

for the dynamic map services to be able to render symbols, 'allow modification ...' checkbox in ArcGIS Server Manager is enabled for those layers.

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Mon, 14 May 2018 14:32:59 GMT

I created a simple demo of my problem here: (note that I can only keep this up for a short time)

Change attribute used for a renderer

To demonstrate the problem I am having:

1) click on a point and see the info window, which will show the chosen attribute field and its value

2) remember where the current points are located, then, choose a different attribute from the dropdown window

3) now click on the same spot where a point no longer appears where it appeared earlier..you will see the current value of '0' in the info window

My goal is to remove these 'invisible' points entirely

Here is the code relevant to the renderer and the layer definitions:

var baseSymbol = new SimpleMarkerSymbol(SimpleMarkerSymbol.STYLE_CIRCLE, 15);
attributeField = document.getElementById("fieldNames").value; // these values correspond with attribute field names in layer
var renderer = new UniqueValueRenderer(baseSymbol, attributeField);

// the '0' value below makes the point invisible but does not remove point from the layer
renderer.addValue(0, new SimpleMarkerSymbol(SimpleMarkerSymbol.STYLE_CIRCLE, 6).setColor(new Color([255, 0, 0,0])));
renderer.addValue(1, new SimpleMarkerSymbol(SimpleMarkerSymbol.STYLE_CIRCLE, 6).setColor(new Color([255, 77, 77, 0.8])));
renderer.addValue(2, new SimpleMarkerSymbol(SimpleMarkerSymbol.STYLE_CIRCLE, 8).setColor(new Color([230, 0, 0, 0.8])));

............................

var optionsArray = [];
var drawingOptions = new LayerDrawingOptions();
drawingOptions.renderer = renderer;
optionsArray[0] = drawingOptions;
var layerDefs = [];
layerDefs[0] = attributeField + '>0';
// layerDefs[0] = 'All_9_12>0'; // use hard coded attribute field as test to see if layerDefs are applied, commented out for now
// imageParameters.layerDefinitions = layerDefs; // tried this an alternative method // replace line below for image parameters // had no effect
map.getLayer("layer").setLayerDefinitions(layerDefs); // test line above confirmed that this is being implemented
map.getLayer("layer").setLayerDrawingOptions(optionsArray);
demoLayer.setVisibleLayers([0], true);
map.getLayer("layer").show();

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Mon, 14 May 2018 14:33:32 GMT

HI Robert, I added a link to a demo and the relevant code snippet below:

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Sat, 11 Dec 2021 11:02:08 GMT

Jason,

Your sample really helped. I did not know you where using the IdentifyTask and not just a simple InfoTemplate or PopupTemplate.

You need to apply the SQL definition to the IdentifyParamaters (lines 5 and 6).

      // identify task
      function executeIdentifyTask(event) {
        identifyParams.geometry = event.mapPoint;
        identifyParams.mapExtent = map.extent;
        identifyParams.layerDefinitions = [];
        identifyParams.layerDefinitions[0] = attributeField + '>0';‍‍‍‍‍‍

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Mon, 14 May 2018 14:56:10 GMT

thanks--so far, adding this code has resulted only in 'No information Available' return for clicking on any point, for any of the chosen attributes. Did you add any other edits?

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Mon, 14 May 2018 15:02:11 GMT

Jason,

Nope. I am not seeing that on my end. Did you add both lines 5 and 6?

Re: (not) display rows with 0 value with Unique Value Renderer

deleted-user-3QvhwBivZdaR — Mon, 14 May 2018 15:09:13 GMT

yes. i tried a few variations (removing the other lines in the identify parameters, for instance) but not effect. Here is the updated live demo..Here I only added your two new lines to the existing Identify Parameters:

Change attribute used for a renderer

Re: (not) display rows with 0 value with Unique Value Renderer

RobertScheitlin__GISP — Mon, 14 May 2018 15:20:06 GMT

Jason,

you added those lines, but in the wrong place. Notice I show the function you should add those line to.

function executeIdentifyTask(event) {