Latest Contributions by FranklinAlexander

I have a table stored in a SQL database with a date field that is formatted as such: yyyy-mm-dd. Since I cannot query the table directly from the client site, a view table was created and housed in an esri gdb, then published to ArcGIS REST. For some reason (I didn't create the view table), the date field format in the view table is d/m/yyyy. Now I am querying the data using the REST service url from the query widget.js file using queryTask. What is being returned is an integer for the date, which is fine except the integer being return converts to 1939-12-31, when the correct date (in the database) is 1940-01-01.  After playing around with this, I have determined that the javascript date function seems to like the d/m/yyyy format, because that format gets translated correctly, and the yyyy-mm-dd format is one day behind ( I get two different integers). This tells me that when queryTask looks at the view table date field (which has the correctly formatted date), it must actually be seeing the SQL database table field with the format it doesn't like.  My question is how do I solve this? I tried this: d = new Date(stats2.KillDate); let yy = d.getFullYear().toString(); let mm = (d.getMonth()+1).toString(); let dd = (d.getDate()+1.toString(); ‍‍‍‍‍‍‍ This works ok most of the time, but it's not 100%. In the case of 1940-01-01, I get 1939-12-32 One last bit of info: 1940-01-01 (stored as date field in SQL database) returns the date integer  -946771200000 (converts incorrectly) 1/1/1940 (stored as date field in esri gdb table) would return the better date integer -946753200000 (converts correctly) This can't be the first time this has come up and I am sure there is probable some looong solution (using js switch/case?), but if anyone knows a better way of handling this please advise. Thanks!!  ... View more

I have a query widget that queries a view table on ArcGIS REST. In the widget.js file, I am building a whereclause with the widget parameters and using QueryTask to query the database. I need to run two instances of QueryTask, the second takes a lot of time because it has to use statistical results from each row from the 1st query by looping through (67 times) to build an array of rows. [ [...], [...], [...] ]. I then need to format the results of the results array and create a layer. All of this works, except that I am having an async issue. I can't start processing the result array to create the layer until it is done populating. I am going to post a general outline of what I have now and what I have tried, but I won't post all of the code because it is hundreds of lines: //build whereclause here ...building whereclause... var queryTask = new QueryTask(tableUrl); var buckQuery = new Query(); //statistical definitions here (not shown) buckQuery.returnGeometry = false; buckQuery.outFields = ["*"]; buckQuery.outStatistics = [statSum, statAvg, statMax, statCount]; buckQuery.orderByFields = ["COUNTY_NAME"]; buckQuery.where = whereclause; queryTask.execute(buckQuery).then(function(response) { var QueryResults = response.features; let resultArr = []; for((var i = 0; i < QueryResults.length; i++) { let rowSum = null; ...more code rowSum = [c, stats.FINALSCORESUM, stats.FINALSCOREAVG, stats.COUNTY_COUNT, countArea, stats.MAXFINALSCORE]; var queryTask2 = new QueryTask(tableUrl); var buckQuery2 = new Query(); buckQuery2.returnGeometry = false; buckQuery2.outFields = ["COUNTY_NAME", "METHOD", "KillDate", "FULLNAME"]; buckQuery2.where = whereclause2 + " AND FINALSCORE = " + stats.MAXFINALSCORE + " AND COUNTY_NAME = '" + stats.COUNTY_NAME + "'"; queryTask.execute(buckQuery2).then(function(response) { var QueryResults2 = response.features; let stats2 = QueryResults2[0].attributes; ... more code rowSum.push(stats2.METHOD.toString(), kd, stats2.FULLNAME); resultArr.push(rowSum); }); } }); if(resultArr !== null || resultArr !== undefined) { //here is where I need to do everything else //resultArr is undefined } ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ This produces an array as described above, but now I need to use that array to create new Formatted Results for the info window and result layer. All of this works fine (I set a timeout to 6 seconds for testing purposes!), I just can't figure out how to keep the javascript from running ahead, and wait on the result array to finish populating. I tried a few things: First I tried using a Promise/resolve function like this:   //build whereclause here ...building whereclause... var queryTask = new QueryTask(tableUrl); var buckQuery = new Query(); //statistical definitions here (not shown) buckQuery.returnGeometry = false; buckQuery.outFields = ["*"]; buckQuery.outStatistics = [statSum, statAvg, statMax, statCount]; buckQuery.orderByFields = ["COUNTY_NAME"]; buckQuery.where = whereclause; return new Promise(function(resolve, reject) { queryTask.execute(buckQuery).then(function(response) { var QueryResults = response.features; let resultArr = []; for((var i = 0; i < QueryResults.length; i++) { let rowSum = null; ...more code rowSum = [c, stats.FINALSCORESUM, stats.FINALSCOREAVG, stats.COUNTY_COUNT, countArea, stats.MAXFINALSCORE]; var queryTask2 = new QueryTask(tableUrl); var buckQuery2 = new Query(); buckQuery2.returnGeometry = false; buckQuery2.outFields = ["COUNTY_NAME", "METHOD", "KillDate", "FULLNAME"]; buckQuery2.where = whereclause2 + " AND FINALSCORE = " + stats.MAXFINALSCORE + " AND COUNTY_NAME = '" + stats.COUNTY_NAME + "'"; queryTask.execute(buckQuery2).then(function(response) { var QueryResults2 = response.features; let stats2 = QueryResults2[0].attributes; ... more code rowSum.push(stats2.METHOD.toString(), kd, stats2.FULLNAME); resultArr.push(rowSum); }); } }); }).then(function(resultArr) { showResults(resultArr); }); function showResults(resultArr) { ... }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ but this didn't solve the issue. The showResults function executes without waiting and once again I get undefined for the result array. I also tried using a simple callback: function getQueryResultsAndBuildArray (whereclause, callback) //this is the same function as above so I won't paste it ...code goes here callback(resultArr); } function showResults(resultArr) { .... } getQueryResultsAndBuildArray (whereclause, showResults); ‍‍‍‍‍‍‍‍‍‍‍‍ Got the exact same result, undefined when executing the showResults function. Just looking for some input on what I am doing wrong and maybe a better way to approach. Thanks!! ... View more

I have a web app that is pulling in two layers from ArcGIS REST, a point layer and a polygon layer. I already used queryTask to filter out features from the point layer and return a max value based on a statistical calc, and then set a layer definition so that only those points with the max value will render in the map. Now I want to use those points to do a spatial query that filters out all but the features from the polygon layer that intersect a point in the point layer. I am doing something wrong with the geometry because I get a type error: "Cannot read property 'wkid' of undefined" when trying to run the spatial query: //run spatial query on polygon layer using geometry from point layer then pushes //resulting feature id to array function getSubRegions(geometry, srArray) { var subRegUrl = "https://ocean.floridamarine.org/arcgis/rest/services/.../MapServer/2"; var queryTask = new QueryTask(subRegUrl); var subRegQuery = new Query(); subRegQuery.where = "1=1"; subRegQuery.outFields = ["*"]; subRegQuery.geometry = geometry; subRegQuery.spatialRelationship = Query.SPATIAL_REL_INTERSECTS; subRegQuery.returnGeometry = true; //console.log("subregion query ", subRegQuery); queryTask.execute(subRegQuery).then(function(result) { if(result.features[0] != undefined) { var subRegID = result.features[0].attributes.OBJECTID; if(srArray.indexOf(subRegID) === -1) { srArray.push(subRegID); } } }); } //gets point layer and loops through to select intersecting polygons. Resolves polygon //feature ids function getSitesGeo(currentBatch, sitesUrl) { var queryTask = new QueryTask(sitesUrl); var batchQuery = new Query(); batchQuery.where = "Batch = " + currentBatch; batchQuery.outFields = ["*"]; batchQuery.returnGeometry = true; return new Promise((resolve, reject) => { queryTask.execute(batchQuery).then(function(result) { //console.log("sites results ", result); let srArray = []; let features = result.features; features.forEach(function(feature) { var geometry = feature.geometry; if(isNaN(parseFloat(geometry.x)) === false) { getSubRegions(geometry, srArray); } }); resolve(srArray); }); }); } //filters points by max field value, uses resulting points as geometry for spatial //query on polygon layer. Returns values for definition query. function getBatchNumnber() { var sitesUrl = "https://ocean.floridamarine.org/arcgis/rest/services/.../MapServer/0"; var queryTask = new QueryTask(sitesUrl); var batchQuery = new Query(); var statDef = new StatisticDefinition(); statDef.statisticType = "max"; statDef.onStatisticField = "Batch"; statDef.outStatisticsFieldName = "CurrentBatch"; batchQuery.where = "1=1"; batchQuery.outFields = ["*"]; batchQuery.outStatistics = [statDef]; batchQuery.returnGeometry = true; queryTask.execute(batchQuery).then((result) => { var currentBatch = result.features[0].attributes.MAX_Batch; window.currentBatch = currentBatch; getSitesGeo(currentBatch, sitesUrl) .then(result => { window.subRegIds = result; }) }); } //create def query in Local Layer widget.js lLayer = new ArcGISDynamicMapServiceLayer(layer.url, lOptions); if (layer.hasOwnProperty('definitionQueries')) { var definitionQueries; if(window.currentBatch) { definitionQueries = { 0: "Batch = " + window.currentBatch, 1: "OBJECTID IN (" + window.subRegIds.join(',') + ')', 2: "OBJECTID IN (" + window.subRegIds.join(',') + ')' } }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Everything is working fine except for the points geometry type error. I am not sure if I have the geometry configured wrong (it is in an array), or if I am miss-understanding how the spatial query is supposed to work I think this is something fairly simple that I am doing wrong, just need a little help seeing it. Thanks!!  ... View more