topic Re: How to Connect Data to a Map in ArcGIS Web AppBuilder Questions

How to Connect Data to a Map

WilliamMiller4 — Thu, 09 Feb 2017 17:31:15 GMT

Hi,

I have a map service that holds a non-geographic table from a non-ArcGIS database. I need to connect that data to the map, so the properties can be highlighted, etc. There are fields in the table that match data in the map, such as account_number. How do I match the two so I can get each properties' coordinates or am I going about this wrong?

William

Re: How to Connect Data to a Map

RobertScheitlin__GISP — Thu, 09 Feb 2017 17:39:19 GMT

William,

If you followed Andrews advice in that other thread and registered the data with ArcGIS Server than you can join the non-spatial table and publish a new map service containing the joined data.

Re: How to Connect Data to a Map

WilliamMiller4 — Thu, 09 Feb 2017 19:01:49 GMT

Hi Robert,

We registered a view of the joined tables with ArcGIS Server. (For some reason, ArcMap could join the tables but not publish them as a service.) So it's possible to join a non-spatial table with a map layer?

William

Re: How to Connect Data to a Map

RobertScheitlin__GISP — Thu, 09 Feb 2017 19:11:47 GMT

Sure that is extremely common practice in ArcMap.

Re: How to Connect Data to a Map

Drew — Thu, 09 Feb 2017 19:13:53 GMT

William,

Can you provide some details

What database are you using? (SQL, Oracle, other..)
Are the 2 tables in the same database?
Are you connecting with a database AND user that is registered with your ArcGIS Server (as Robert mentioned)
Is this your own ArcGIS Server or and ArcGIS online/portal account? I just assumed AGS.
When you are in the process of publishing the service what errors do you see when you do an 'Analyse' ?

If I had to guess you have not registered the correct database connection with the server.
All participating tables in the view must be registered with ArcGIS Server

Drew

Re: How to Connect Data to a Map

WilliamMiller4 — Thu, 09 Feb 2017 20:06:25 GMT

Hi Drew,

Here are some more details:

The database is SQL.
The two tables are in the same database.
I don't know. The GIS director performed the operation. (I know very little about ArcMap, as I have never really had a chance to use it.)
This is being done on our ArcGIS Server.
The first time it was attempted, ArcMap just closed. The second time, I didn't have time to read the message on the screen.

The view of the two tables was published as a map service with a random layer, as it would not publish without a layer. I had shown the director your instructions on how to publish the table as a map document, but was told it needed to be a map service in order for me to access it.

William

Re: How to Connect Data to a Map

WilliamMiller4 — Thu, 09 Feb 2017 20:11:39 GMT

Hi Robert,

Unfortunately this solution won't work as the view of the two tables has multiple records for each account number (one of the tables is of property sales) and ArcMap's join only adds one of the records. At least that's what I'm told will happen.

William

Re: How to Connect Data to a Map

Drew — Thu, 09 Feb 2017 21:02:22 GMT

That is true. You would need a dummy map layer in the service to get the tables to publish.
You can see we have similar in our REST endpoint (Search_Tables)

Reading above is sounds like a 1 to many relationship and not a 1 to 1 .this changes things too...

thinking....

Now I am not 100% on this.... but you might be able to do a 'relate' on the table and then publish.

Once published you will want to look at the executeRelationshipQuery

QueryTask | API Reference | ArcGIS API for JavaScript 3.19

Drew

Re: How to Connect Data to a Map

WilliamMiller4 — Fri, 10 Feb 2017 17:11:25 GMT

Hi Drew,

I think I'll have to write a web service due to the one to many relationship of the data.

Thank you for all your help though. I learned a lot!

William

Re: How to Connect Data to a Map

Drew — Fri, 10 Feb 2017 18:41:45 GMT

No problem. A web service is just as good and may provide more flexibility down the road.

Re: How to Connect Data to a Map

WilliamMiller4 — Fri, 03 Mar 2017 19:43:54 GMT

Hi Robert,

Since I'm using a WCF rest service, how should I go about getting query results that include a reference or link to a parcel? I found this article about Using QueryTask, Query, and FeatureSet that seems helpful for running a query like this from Web AppBuilder, but how would I do it from the WCF rest service?

William

Re: How to Connect Data to a Map

RobertScheitlin__GISP — Fri, 03 Mar 2017 19:51:42 GMT

William,

I a little confused by this question. What does your rest service do then if it is not already querying a database?

In my parcel rest service I pass a parcel identification number to it from the results of a query task or a selection and then in the web service I query my CAMA data (non-gis data) using a SQL query with that ppin and pass back the CAMA data of interest for that parcel.

Re: How to Connect Data to a Map

WilliamMiller4 — Fri, 03 Mar 2017 20:08:40 GMT

Hi Robert,

From my widget, I use esriRequest to pass user specified input (say a school district, a sale date range and a sale price range) to the my rest service. The rest service puts the request in SQL format, queries the database and returns information on the parcels that match, such as account number, address, sale date, sale price, seller, buyer, square footage, etc. I'm not sure how to query an ArcGIS rest service directly from my rest service to get the geometry or spatial references to link the database data to the map.

William

Re: How to Connect Data to a Map

RobertScheitlin__GISP — Fri, 03 Mar 2017 20:54:24 GMT

William,

I would not try to have the rest service do that I would return that data and then back in the app use a QueryTask to get the graphic from ArcGIS Server using a query based on the account number or parcel number.

Re: How to Connect Data to a Map

WilliamMiller4 — Fri, 10 Dec 2021 23:02:02 GMT

Hi Robert,
I'm trying to get the graphic for each parcel returned from the rest service set to a variable, pass that variable as part of an object and add the graphic to the map, however I seem to be missing something, most likely related to dojo/Deferred. The code below seems to work, but if I uncomment line 33, I get "Reference Error: graphic is not defined". If I comment out line 20 and uncomment line 21, all the parcels are black, and the symbolColor, while correct in the console.log(line 9), has NaN for the RGB values in the console.info(line 22).

_requestSucceeded: function(response){
  
  for(var i = 0, len = response.length; i < len; i++){
    
    var accountNum = response[i].AccountNum;
    var include = response[i].Include;
    var symbolColor = response[i].SymbolColor;
    var def = new Deferred();
    console.log(symbolColor);
    
    //Get information on the shape of each parcel from the AccountNum
    var queryString = "AccountNum = " + response[i].AccountNum;
    var query = new Query();
    var queryTask = new QueryTask("arcgis/rest/services/Dynamic/AccountNumber/MapServer/0");
    query.where = queryString;
    query.returnGeometry = true;
    queryTask.execute(query, lang.hitch(this, function(results){
      var features = results.features;
      for(var i = 0, len = features.length; i < len; i++){
        var symbol = new SimpleFillSymbol(SimpleFillSymbol.STYLE_SOLID, new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([255,0,0]), 2), new Color([255,255,0,0.25]));
        //var symbol = new SimpleFillSymbol(SimpleFillSymbol.STYLE_SOLID, new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([symbolColor]), 2), new Color([symbolColor,0.25]));
        console.info(symbol);
        var graphic = features[i];
        graphic.setSymbol(symbol);
        this.map.graphics.add(graphic);
      }
      def.resolve({state: 'success', value: results});
    }), lang.hitch(this, function(error){
      def.resolve({state: 'failure', value: error});
    }));
        
    this.list.add({
      //graphic: graphic,
      accountNum: accountNum,
      include: include,
      symbolColor: symbolColor
    });
  }
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

William

Re: How to Connect Data to a Map

RobertScheitlin__GISP — Mon, 06 Mar 2017 20:48:16 GMT

William,

What is the value that is returned by line 9?

console.log(symbolColor);

The only reason you use

new Color([x]) ‍

is when x is the three rgb numbers.

So your issue might be

new Color(symbolColor)‍

Re: How to Connect Data to a Map

WilliamMiller4 — Mon, 06 Mar 2017 21:01:47 GMT

Hi Robert,

The value of console.log(symbolColor) varies by accountNum, but some examples are in the screenshot below.

William

Re: How to Connect Data to a Map

RobertScheitlin__GISP — Mon, 06 Mar 2017 21:13:16 GMT

William,

I have seen this before. I think you have to use

Color.fromArray(symbolColor);‍‍‍‍

Re: How to Connect Data to a Map

WilliamMiller4 — Mon, 06 Mar 2017 22:02:26 GMT

Hi Robert,

I added the following line

var color = new Color.fromArray(symbolColor);‍

and changed

var symbol = new SimpleFillSymbol(SimpleFillSymbol.STYLE_SOLID, new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, new Color([symbolColor]), 2), new Color([symbolColor,0.25]));‍

var symbol = new SimpleFillSymbol(SimpleFillSymbol.STYLE_SOLID, new SimpleLineSymbol(SimpleLineSymbol.STYLE_SOLID, color, 2), color);‍

The graphics still look black, but now it looks like all the console.info lines are showing a: 1, b: 5, g:5 , r: 2 for the color values. I think it has something to do with the deferred, because all the console.log(symbolColor) from line 9 display in the console and then all the console.info(symbol) from line 22. Also, there is the reference error about graphic not being defined when line 33 is uncommented.

William

Re: How to Connect Data to a Map

RobertScheitlin__GISP — Tue, 07 Mar 2017 04:08:19 GMT

William,

Try this then:

var color = Color.fromRgb("rgb(" + symbolColor + ")");‍‍