topic Re: Heat Map using sql table in ArcGIS JavaScript Maps SDK Questions

Heat Map using sql table

kawishabbas — Wed, 21 Aug 2019 11:49:59 GMT

Is there any possibility to use SQL Table instead of CSV to visualize points with heat map..???

https://developers.arcgis.com/javascript/latest/sample-code/sandbox/index.html?sample=visualization-heatmap

Robert Scheitlin, GISP‌ Egge-Jan Pollé‌ Kelly Hutchins‌

Re: Heat Map using sql table

Egge-Jan_Pollé — Wed, 21 Aug 2019 12:13:25 GMT

Hi kawish abbas,

Yeah, I suppose you can apply the renderer to any kind of point layer.

Cheers,

Egge-Jan

Re: Heat Map using sql table

RobertScheitlin__GISP — Wed, 21 Aug 2019 12:43:00 GMT

I don't think so. Unless you have the ability to make a layer (of some supported type) out of that tables data. I suppose if the SQL Table is from a Geodatabase or you have a web service that allows the query of the tables data, then you could create client side graphics in a FeatureLayer from that.

Re: Heat Map using sql table

kawishabbas — Wed, 21 Aug 2019 12:52:09 GMT

Robert Scheitlin, GISP‌

I have created json service by using express.. Can i use this json service to create heat map..???

Re: Heat Map using sql table

kawishabbas — Wed, 21 Aug 2019 12:53:11 GMT

Egge-Jan Pollé‌

I have created my own json service using express. How can i use it with arcgis api...??

Re: Heat Map using sql table

RobertScheitlin__GISP — Wed, 21 Aug 2019 12:59:14 GMT

Use esriRequest to call the json service and get your data. Shown in this sample.

https://developers.arcgis.com/javascript/latest/sample-code/sandbox/index.html?sample=request

Then use code from this sample to create FeatureLayer from that data.

https://developers.arcgis.com/javascript/latest/sample-code/sandbox/index.html?sample=layers-featurelayer-collection

Once you have a FeatureLayer apply the HeatMap renderer to it.

Re: Heat Map using sql table

kawishabbas — Wed, 21 Aug 2019 13:09:03 GMT

Thank you Robert i will try this.

Re: Heat Map using sql table

kawishabbas — Sun, 12 Dec 2021 02:11:42 GMT

Robert..

i have called json service and got data in console. But when i use code from this sample https://developers.arcgis.com/javascript/latest/sample-code/sandbox/index.html?sample=layers-featurelayer-collection and try to got data with featureCollection, i received "undefined". How can i create featureCollection??

Response from JSON service

{ 
"data": [
  {
      "OBJECTID": 146,
      "Splitter": "64",
      "Comment": "DHA Phase05",
      "Name": "Plaza POP ODB 02",
      "ID": "2100604",
      "Placement": "Aerial",
      "POP": 21006,
      "Shape": {
        "srid": 32642,
        "version": 1,
        "points": [
          {
            "x": 301997.6824000003,
            "y": 2746232.8489999995,
            "z": null,
            "m": null
          }
        ],
        "figures": [
          {
            "attribute": 1,
            "pointOffset": 0
          }
        ],
        "shapes": [
          {
            "parentOffset": -1,
            "figureOffset": 0,
            "type": 1
          }
        ],
        "segments": []
      }
    }
  ]
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Heat Map using sql table

RobertScheitlin__GISP — Thu, 22 Aug 2019 13:05:22 GMT

Kawish,

Time to show your code. In the sample I provided it returns a featureCollection. In your case you have a json string that you need to parse and create Graphics for each result in your data array.

Re: Heat Map using sql table

kawishabbas — Sun, 12 Dec 2021 02:11:45 GMT

Robert

Could you please give me sample code for given json string that how to parse and create feature layer..

{ 
"data": [
  {
      "OBJECTID": 146,
      "Splitter": "64",
      "Comment": "DHA Phase05",
      "Name": "Plaza POP ODB 02",
      "ID": "2100604",
      "Placement": "Aerial",
      "POP": 21006,
      "Shape": {
        "srid": 32642,
        "version": 1,
        "points": [
          {
            "x": 301997.6824000003,
            "y": 2746232.8489999995,
            "z": null,
            "m": null
          }
        ],
        "figures": [
          {
            "attribute": 1,
            "pointOffset": 0
          }
        ],
        "shapes": [
          {
            "parentOffset": -1,
            "figureOffset": 0,
            "type": 1
          }
        ],
        "segments": []
      }
    },
      {
      "OBJECTID": 147,
      "Splitter": "64",
      "Comment": "DHA Phase06",
      "Name": "Badar POP ODB Muhafiz",
      "ID": "2100502",
      "Placement": "Aerial",
      "POP": 21005,
      "Shape": {
        "srid": 32642,
        "version": 1,
        "points": [
          {
            "x": 302831.8328999998,
            "y": 2742953.342599999,
            "z": null,
            "m": null
          }
        ],
        "figures": [
          {
            "attribute": 1,
            "pointOffset": 0
          }
        ],
        "shapes": [
          {
            "parentOffset": -1,
            "figureOffset": 0,
            "type": 1
          }
        ],
        "segments": []
      }
    }
  ]
}
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Heat Map using sql table

RobertScheitlin__GISP — Sun, 12 Dec 2021 02:11:48 GMT

Kawish,

You can not expect that someone will do the coding for you all the time by providing a sample that works for your specific case. If you post your attempt to work with your data and where you are stuck then some corrections or guidance can be provided.

Like I said before you need to loop through the json data.

var graphicsArray = respose.data.map(function(result){
  var resultPnts = result.Shape.points.map(function(point){
    return new Point(point.x, point.y, new SpatialReference({wkid: point.srid});
  });
  var atts = {
    "ObjectID": result.OBJECTID,
    "Splitter": result.Splitter,
    "Comment": result.Comment,
    "Name": result.Name,
    "ID": result.ID,
    "Placement": result.Placement,
    "POP": result.POP
  };
  var graArr = resultPnts.map(function(pnt){
    return new Graphic(pnt, new SimpleMarkerSymbol(), atts)
  });
  return graArr;
});‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Then use the code from the sample and some code from the FeatureLayer documentation to populate the FeatureLayer:

const fields = [
 new Field({
   name: "ObjectID",
   alias: "ObjectID",
   type: "oid"
 }), new Field({
   name: "Splitter",
   alias: "Splitter",
   type: "string"
 }), new Field ({
   name: "Comment",
   alias: "Comment",
   type: "string"
 }), new Field ({
   name: "Name",
   alias: "Name",
   type: "string"
 }), new Field ({
   name: "ID",
   alias: "ID",
   type: "string"
 }), new Field ({
   name: "Placement",
   alias: "Placement",
   type: "string"
 }), new Field ({
   name: "POP",
   alias: "Population",
   type: "integer"
 })
];
var featureLayer = new FeatureLayer({
  objectIdField: "ObjectID",
  source: graphicsArray,
  fields: fields
});‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Heat Map using sql table

kawishabbas — Mon, 26 Aug 2019 04:56:34 GMT

Robert

I am very grateful to your help and i am really sorry that you had to suffer so much because of me.