topic Re: Query & QueryTask with a feature layer not shown until Query Task executed in ArcGIS JavaScript Maps SDK Questions

Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Thu, 06 Mar 2014 19:52:32 GMT

I am trying to query a feature layer that is not shown on the map until the query is actually executed. I have a button that I am using to set off the query when it is clicked. Here is the code that I am trying to use:

on(dom.byId("mapshow"), "click", selectHistorical); function selectHistorical(){  var queryTask = new QueryTask(window.historicalUrl);  var query = new Query();  query.returnGeometry=true;  query.outFields=window.historicalOutFields;  query.text = dom.byId("mydropdown").value;  query.outSpatialReference = {"wkid":2236};  dojo.connect(queryTask, "onComplete", function(featureSet){   map.graphics.clear();   dojo.forEach(featureSet.features, function(feature){    var graphic = feature;    map.graphics.add(graphic);   });  });  queryTask.execute(query); }

The feature layer is already included in the webpage in on demand mode. What I am trying to do is query the layer so that the only items that show up from that layer are the items from one specific unit id. This is to show the history of one specific vehicle over time. Eventually we would also want to query the time so that the user can specify a certain time and date to get the historical information for one specific vehicle. I am posting a photo of the viewer.

[ATTACH=CONFIG]31992[/ATTACH]

The dropdown menu in the right panel has the unit id's for all police vehicles. What I want is for the historical data (in the historical feature layer) to be shown for whatever specific unit id is selected when I click on the show on map button.

I am fairly new to coding with esri, so any help is appreciated.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

AndyBurns — Fri, 10 Dec 2021 22:11:54 GMT

Hi

Looks like your query is correct and i presume you can see the query execute if you use firebug or similar?

try the below, you need to take the results and do something with them. I pass it to the showResults function, build a table and zoom to the location on the map.

//execute query
          queryTask.execute(query0, showResults);
        };

        function showResults(results) {
          var s = "<table>";
          var aliases = results.fieldAliases; 
          var len = results.features.length;
          var fieldTypes = {};
          //var dateI = results.fields.length;

           // define a variable that will hold the field type for each field name.          
            array.forEach(results.fields, function (aField) {
            fieldTypes[aField.name] = aField.type;
          });

            if (len === 0) { // if no results
             s = "No results for IPMS reference: " + IPMSREF
            } else { // if 1 or more results, display them
             for (var i = 0; i < len; i++) {
              var featureAttributes = results.features.attributes; 
                for (var att in featureAttributes) {
                 //var aliasesFix = aliases[att].replace("*", "")
                  if (featureAttributes[att] == null) {
                   featureAttributes[att] = ""
              }
              else if (fieldTypes[att] == "esriFieldTypeDate") {
               featureAttributes[att] = formatDate(new Date(featureAttributes[att]));
              }
              else if (fieldTypes[att] == "esriFieldTypeDouble") {
                featureAttributes[att] = Math.round(featureAttributes[att]*10000)/10000
              }
              else if (att == "EDITEDBY" && "CREATEDBY") {
                featureAttributes[att] = featureAttributes[att].replace("IPS$",""); 
              }

           s = s + "<tr><td><span style='white-space: nowrap'>" + "<b>" + (aliases.hasOwnProperty(att) && aliases[att]) + "</b>" + ": " + "</td><td style='width:100%;'>" + featureAttributes[att] + "</td></tr>";
            }
            s = s + "<tr class='blank_row'><td></td>"
            }  
            s = s + "</table><br />";                 
          };
           dom.byId("info").innerHTML = s;
           dojo.query("#info table tr:nth-child(odd)").addClass("odd");
           dojo.query("#info table tr:nth-child(even)").addClass("even");

           //get x and y from centre of results geometry = true query
           var polyGonGeom = results.features[0].geometry;
           var polyGonExt = polyGonGeom.getExtent();
           map.setExtent(polyGonExt);

           var Polygon = new esri.geometry.Polygon(polyGonGeom, new esri.SpatialReference({
               wkid: 27700
            }));   

           console.log(Polygon)
           
            if (!graphic) {
                  addGraphic(Polygon);
                } else {
                  graphic.setGeometry(Polygon);
              }; 
        };
        //add graphic to the map
       function addGraphic(Polygon) {
        //parameters for the symbol 
        var symbol = new esri.symbol.SimpleFillSymbol(esri.symbol.SimpleFillSymbol.STYLE_SOLID, new esri.symbol.SimpleLineSymbol(esri.symbol.SimpleLineSymbol.STYLE_SOLID, new dojo.Color([49, 101, 156]), 2), new dojo.Color([148, 186, 231, 0.5]));
                // var symbol = new esri.symbol.PictureMarkerSymbol({
                //     "angle": 0,
                //     "xoffset": 0,
                //     "yoffset": 0,
                //     "type": "esriPMS",
                //     "url": "http://static.arcgis.com/images/Symbols/Basic/BlueShinyPin.png",
                //     "contentType": "image/png",
                //     "width": 24,
                //     "height": 24
                // });
                var graphic = new esri.Graphic(Polygon, symbol);
                map.graphics.add(graphic);
        };

Re: Query & QueryTask with a feature layer not shown until Query Task executed

AndyBurns — Fri, 07 Mar 2014 09:56:40 GMT

Tried:

query.where = "ID =" dom.byId("mydropdown").value;

instead of query.text??

replace ID with your rest url attribute column name.

Do you get a result with firebug to the call?

Re: Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Fri, 10 Dec 2021 22:11:56 GMT

Tried:
query.where = "ID =" dom.byId("mydropdown").value;
instead of query.text??

replace ID with your rest url attribute column name.

Do you get a result with firebug to the call?

I tried your suggestion, but it didn't like where the quotes were. So, I moved the quotes to only include

"VehicleId" = dom.byId("mydropdown").value;

Now in internet explorer debugging tools, I am getting the error: SCRIPT5008: Invalid left-hand side in assignment

Also, when I first open the debugger, it is giving this error:
LOG: dojo.io.script errorError: Error performing query operation

Any idea why these errors are occuring? It works for the data, just not the geometry. I am able to pull the data into a grid, but the geometry doesn't show up on the map. The code for showing up in the grid is as follows:

on(dom.byId("execute"), "click",execute);
      
function execute(){
 var queryTask = new QueryTask(window.historicalUrl);
 var query = new Query();
 query.text = dom.byId("mydropdown").value;
 query.returnGeometry = true;
 query.outFields = window.historicalOutFields;
 queryTask.execute(query, function (results) {
  var data = [];
  var data = array.map(results.features, function (feature) {
   return {
    "Vehicleid": feature.attributes[window.historicalOutFields[0]],
    "Velocity": feature.attributes[window.historicalOutFields[1]],
    "Direction": feature.attributes[window.historicalOutFields[2]],
    "TimeStamp": feature.attributes[window.historicalOutFields[3]]
   }
  });
  var memStore = new Memory ({data:data});
  window.grid3.set("store", memStore);
 });
};

Is there a way to just get the geometry into this code? If so, it is preferable for one button click instead of two. If it's a different query altogether, then I will have to go with the two buttons.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

JakeSkinner — Fri, 07 Mar 2014 11:45:11 GMT

Hi Michelle,

Could you create a jsfiddle with your code? This will make it easier to troubleshoot.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Fri, 07 Mar 2014 12:00:24 GMT

Hi Michelle,

Could you create a jsfiddle with your code? This will make it easier to troubleshoot.

Jake,
Here is my code in a jsfiddle. We are nearing the end of what needs to be done, and the historical data is the last of what we are trying to do with the viewer.
http://jsfiddle.net/mrogers83/Hz59f/1/

Re: Query & QueryTask with a feature layer not shown until Query Task executed

JakeSkinner — Fri, 07 Mar 2014 12:19:42 GMT

I couldn't see if this resolved the problem since the services don't appear to be public facing, but try chaning the query to the following:

query.where = "DeviceId = '" + dom.byId("mydropdown").value + "'";

Re: Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Fri, 07 Mar 2014 12:34:40 GMT

I couldn't see if this resolved the problem since the services don't appear to be public facing, but try chaning the query to the following:
query.where = "DeviceId = '" + dom.byId("mydropdown").value + "'";

You are correct in saying that the services are not public facing. This is for security reasons because we are tracking police vehicles. I no longer get an error message when I click the button, but I am not seeing anything show up on my screen either. I have tried debugging through firefox and internet explorer since I am only working with Notepad ++ for development, but neither one gives me any indication of what is wrong that the geometry is not showing up on the map.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

AndyBurns — Fri, 07 Mar 2014 14:18:38 GMT

do you have firebug installed? If so, check the response from the querytask and you should see the features and the geometry.

Let us know how you get on.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Fri, 07 Mar 2014 14:42:47 GMT

do you have firebug installed? If so, check the response from the querytask and you should see the features and the geometry.

Let us know how you get on.

I just installed firebug. Where would I see the response from the querytask? I've never used firebug before.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

AndyBurns — Fri, 07 Mar 2014 20:13:03 GMT

depending on how you code it might be in console or you can see the request being send and the reply in the net tab ie:

when you click the query button you should see the request and the response:

[ATTACH=CONFIG]32027[/ATTACH]

I personally always take the points and do a for loop and position all the points features.geometry using map.graphic.

Im at home at the moment but if you can see if you get the response and the data from that .value is what you expecting im sure i can help without my work laptop.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

JakeSkinner — Mon, 10 Mar 2014 11:31:05 GMT

I was having trouble getting this to work with the wkid 2236, but was able to get it to work using a the geographic coordinate system 4326. Here was the function I used:

function selectHistorical() {         var queryTask = new QueryTask(window.historicalUrl);         var query = new Query();         query.returnGeometry = true;         query.outFields = window.historicalOutFields;         query.where = "DeviceId = '" + dom.byId("mydropdown").value + "'";                     query.outSpatialReference = {             "wkid": 4326         };                              dojo.connect(queryTask, "onComplete", function (featureSet) {                             map.graphics.clear();             dojo.forEach(featureSet.features, function (feature) {                                                       var point = new Point(feature.geometry.x, feature.geometry.y, new SpatialReference({wkid:4326}));                 var simpleMarkerSymbol = new SimpleMarkerSymbol(SimpleMarkerSymbol.STYLE_SQUARE, 10,                   new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID,                   new Color([0,255,0,0.25]), 1),                   new Color([255,0,0])                 )                                                      var graphic = new Graphic(point, simpleMarkerSymbol);                                     map.graphics.add(graphic);             });         });                 queryTask.execute(query);     }

You will need to add the following modules:

SpatialReference, Point, SimpleMarkerSymbol, SimpleLineSymbol, and Graphic

Re: Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Mon, 10 Mar 2014 11:31:05 GMT

depending on how you code it might be in console or you can see the request being send and the reply in the net tab ie:

when you click the query button you should see the request and the response:

[ATTACH=CONFIG]32027[/ATTACH]

I personally always take the points and do a for loop and position all the points features.geometry using map.graphic.

Im at home at the moment but if you can see if you get the response and the data from that .value is what you expecting im sure i can help without my work laptop.

I am getting the correct response to the query I am executing, but at the bottom, it shows exceededTransferLimit as true. It is trying to place almost 8000 records in the map. This is because I am querying a historical layer that has history for at least 30 days where the vehicle is updating location every 5 seconds. Is there a way for it not to exceed the transfer limit? I feel like this is what is hanging it up from being placed in the map.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Mon, 10 Mar 2014 12:27:02 GMT

Jake,

I found out from the guy doing the services that the spatial reference was changed to world spatial reference instead of NAD 83 which is what it was, so that's why the wkid wasn't working. I was able to copy the code that you used, and the information is now populating in the map. Do you know how I could get a popup to be active on that layer once it is brought in? We would like to see the information for each point, but cannot currently do that.

Thanks for your help.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

JakeSkinner — Fri, 10 Dec 2021 22:11:59 GMT

Here is an update to the function to show a popup once the point is displayed:

dojo.connect(queryTask, "onComplete", function (featureSet) {                
                map.graphics.clear();
                dojo.forEach(featureSet.features, function (feature) {                                      
                    var point = new Point(feature.geometry.x, feature.geometry.y, new SpatialReference({wkid:4326}));
                    var simpleMarkerSymbol = new SimpleMarkerSymbol(SimpleMarkerSymbol.STYLE_SQUARE, 10,
                      new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID,
                      new Color([0,255,0,0.25]), 1),
                      new Color([255,0,0])
                    )
                    
                    attr = {"Velocity": feature.attributes.Velocity};
                    var infoTemplate = new InfoTemplate("Attributes", "Velocity: ${Velocity}");
                                        
                    var graphic = new Graphic(point, simpleMarkerSymbol, attr, infoTemplate);                    
                    map.graphics.add(graphic);
                    
                    featureArray = [];
                    featureArray.push(graphic);

                    map.infoWindow.setFeatures(featureArray);
                    map.infoWindow.show(point);
                });
});

Don't forget to add the InfoTemplate module.

Re: Query & QueryTask with a feature layer not shown until Query Task executed

MichelleRogers1 — Mon, 10 Mar 2014 15:41:37 GMT

Thanks so much Jake! That was exactly what I needed. Now to figure out how to get the data for a specific time period using a calendar picklist.....:rolleyes:

topic Re: Query & QueryTask with a feature layer not shown until Query Task executed in ArcGIS JavaScript Maps SDK Questions

Query &amp; QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Re: Query & QueryTask with a feature layer not shown until Query Task executed

Query & QueryTask with a feature layer not shown until Query Task executed