topic Define a layer from a related table in ArcGIS JavaScript Maps SDK Questions

Define a layer from a related table

ChristopherJohnson1 — Mon, 10 Aug 2015 08:44:03 GMT

Good morning. I have created a map service from a basic map document and I have related a SQL table to the document. I would like to plot information from the SQL table (locations of places) as points on the feature layer...as another layer. Is this possible?

I have seen the examples of clicking on a point on a map and getting the related data. I do not want that...I want to show all of the related data on the map at the same time.

Thanks...CJ

Re: Define a layer from a related table

RobertScheitlin__GISP — Mon, 10 Aug 2015 12:00:47 GMT

Christopher,

If you SQL Table is a table that has XY values then you can create an XY Event layer or an Query Layer in ArcMap and then publish this mxd to ArcGIS Server so that the data can be used like a normal Spatial Layer.

Re: Define a layer from a related table

ChristopherJohnson1 — Mon, 10 Aug 2015 17:30:20 GMT

Thanks for the reply, Robert.

That is exactly what I am trying to do. I have added a query layer to the map document, related the standalone table to the layer in the document and published the document as a map service. I am now trying to display the data from the standalone table/query layer, over the feature layer, using the JavaScript API. All of the examples though, show obtaining related data on selection. I just want to create another feature layer with that information. For example, I want to create a choropleth/thematic map and then overlay locations on top of that. Do you have any examples?

Thanks...Chris

Re: Define a layer from a related table

RobertScheitlin__GISP — Mon, 10 Aug 2015 18:05:12 GMT

Chris,

So your standalone table has not attributes like lat/Lon or X/Y that can be used to make it a Query layer on it's own? We are talking relates vs joins right? Normally you would see relate returned as in all the samples using a selection due to the one to many relationship of many relates.

Re: Define a layer from a related table

ChristopherJohnson1 — Mon, 10 Aug 2015 18:15:21 GMT

The standalone table does have lat/long coordinates. There is a 1:many relationship between the layer and the standalone table, however. That is the reason that I use a relate versus a join, as I am under the impression that a join will only allow for a 1:1 mapping.

Thanks...Chris

Re: Define a layer from a related table

RobertScheitlin__GISP — Mon, 10 Aug 2015 18:33:06 GMT

Chris,

You are correct 1:Many needs a relate and thus what you are wanting is not possible to my knowledge.

Re: Define a layer from a related table

ChristopherJohnson1 — Mon, 10 Aug 2015 18:36:24 GMT

Thank you, Robert.

As a follow-up, to do what I require, since the locations layer is pretty static, I would need to add it to the geodatabase/shapefile, correct?

Thanks...Chris

Re: Define a layer from a related table

RobertScheitlin__GISP — Mon, 10 Aug 2015 18:49:31 GMT

Chris,

That is what I would do.

Re: Define a layer from a related table

ChristopherJohnson1 — Mon, 10 Aug 2015 18:52:59 GMT

I really appreciate your help, Robert. Thank you!