topic Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table, in ArcGIS Enterprise Questions

Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JamalNUMAN — Fri, 10 Feb 2017 21:47:05 GMT

Mapping stand-alone table records that have corresponding values in layer’s attribute table,

In the screenshots below, some of features of the layer corresponds to multiple records in the stand-alone table. Then, how these RECORDS can be displayed in the map to get what appears in the second screenshot?

The data is attached

Thank you

Best

Jamal

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JonathanQuinn — Fri, 10 Feb 2017 22:29:30 GMT

Sounds like you'll need a relate or relationship class. You can take a look at the doc on deciding between the different options as well.

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JamalNUMAN — Fri, 10 Feb 2017 22:38:11 GMT

Thanks Jonathan.

What I wanted here is to have dynamic mapping for values of the stand-alone table that are linked to the attribute table of a layer. The content of the link you have already provided has nothing to do with this issue.

What other ideas might be there?

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JonathanQuinn — Fri, 10 Feb 2017 22:45:10 GMT

So you want the table records to appear as points based on a relationship with values shared between the table and features? Take a look at the Make Query Table tool. If you use the common field to link the features and include the SHAPE column, you should create duplicate points for every record within the table.

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JamalNUMAN — Fri, 10 Feb 2017 23:44:13 GMT

This is very helpful Jonathan. However, I couldn’t figure out how to displace these points other than applying the “offset” as shown in the screenshot below

is this really the best practice to get the points displaced in dynamic environment such that the data got understood?

Is there any extension in ArcGIS that is better manage this?

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JonathanQuinn — Fri, 10 Feb 2017 23:58:07 GMT

I'm not aware of any extension that will change the behavior you're seeing. Smart clustering is available for a few of the clients of a portal, (AGOL or on-premises), but if you're not interested in that route, I'm not sure what else is available.

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JamalNUMAN — Sat, 11 Feb 2017 21:15:49 GMT

Thanks Jonathan.

Mapping many-one data is very common and frequent at my work environment. All the time, we are asked to visualize projects that have been implemented in particular community. Thus, we need to link many projects to the same community. However, the challenge here is to perform this in a dynamic environment such that as the data changes then their presentation is reflected right away on the map.

Why not to think about kind of spiral method that is able to map the many projects to the same community?

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JoshuaBixby — Sun, 12 Feb 2017 02:34:03 GMT

Look at using the Maplex Label Engine instead of the Standard Label Engine. The Maplex labeling engine can usually handle labeling challenges like you are facing, usually but not always.

Regarding the larger question of labeling based on related data, it has been asked numerous times over the past ten years or more. There never has been nor is there now a straightforward way to do it. For certain situations, the Business Analyst extension works. If one is custom coding via ArcObjects or its successors, there were some limited options. Overall, though, intermediate data sets and workarounds are the answer.

I think the path you are exploring now is likely the best, if you can get the labeling challenge addressed.

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JamalNUMAN — Sun, 12 Feb 2017 11:34:08 GMT

Thanks Joshua.

Labeling many-one is solved here:

labeling a layer with the values of stand-alone table (that is associated to the layer with 1-Many relationship),

https://community.esri.com/thread/185465-labeling-a-layer-with-the-values-of-stand-alone-table-that-is-associated-to-the-layer-with-1-many-relationship

The issue here is that we need to have a dynamic environment due to the fact that we publish our data via ArcGIS Server and consumed in the web and thus we need to reflect any change on the data to be displayed right away on the web. With the current capabilities of ArcGIS, this appears not to be possible which impose more pressure and stress on the team.

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

abdullahqasrawi — Sun, 12 Feb 2017 13:21:45 GMT

I used Make query table tool and I am facing the following barriers

.1-community layer contains 866 points and Query table contain 204 points, I noticed that the map contain the same number of points in both of them?

Number of organizations that appear in symbology is more than 175,000 despite the fact query table contain just 204 points

3 I have 5 different types of symbols, when I applied the symbology all the types of symbols appeared for each point despite the fact not all points contain all symbols

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

JoshuaBixby — Sun, 12 Feb 2017 14:57:55 GMT

I wouldn't say the issue/challenged is "solved" in the referenced link, it is a useable (and somewhat novel) workaround. As you state, a real solution would be both straightforward and work dynamically. Now that database views can be registered with the geodatabase at ArcGIS 10.5, it does crack the door to different approaches when one's data is stored in an enterprise geodatabase.

Re: Mapping stand-alone table records that have corresponding values in layer’s attribute table,

abdullahqasrawi — Sun, 04 Jun 2017 06:54:12 GMT

when I was use make query table then i selected my symbols, I found that we can’t identify each symbol. please see the attachment
Is there a way to make each symbol to be identified?