nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Define a layer from a related table

ChristopherJohnson1

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

Finde mehr Beiträge mit dem Tag

Accepted answers

RobertScheitlin__GISP

Chris,

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

All comments

ChristopherJohnson1

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

RobertScheitlin__GISP

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.

ChristopherJohnson1

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

RobertScheitlin__GISP

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.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.