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

1325
11
02-10-2017 01:47 PM
JamalNUMAN
Esteemed Contributor

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

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
11 Replies
JonathanQuinn
Esri Frequent Contributor

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.

JamalNUMAN
Esteemed Contributor

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?

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
JonathanQuinn
Esri Frequent Contributor

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.

JamalNUMAN
Esteemed Contributor

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?

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
JonathanQuinn
Esri Frequent Contributor

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.

JamalNUMAN
Esteemed Contributor

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?

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
JoshuaBixby
MVP Esteemed Contributor

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.   

JamalNUMAN
Esteemed Contributor

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-...

 

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.

----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
JoshuaBixby
MVP Esteemed Contributor

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.