Select to view content in your preferred language

When configuring pop-up related/joined attributes are not shown

963
5
07-16-2013 04:55 AM
SorinCiolofan
Emerging Contributor
Hello all!

I have in ArcMap a shapefile and a dbf table called VALUES. Basically I want to get some extra data from this dbf table so I joined it with the shape file. After that I exported the shape's data with Data->Export data option and chose Export All features.
I created a zip file from generated files and then imported in ArcGIS online with Add Layer from file. Until now, no problem.
When I want to configure the pop-up I can see available only the following attributes: {FID} , {ID} which comes from the shape's table BUT NO ATTRIBUTES from my VALUES dbf table to which I made a join previously. Was something wrong which I did?
So my goal is to see on configure pop-up the columns from VALUE table as well.

Thank you very much
Sorin
Tags (2)
0 Kudos
5 Replies
MikeMinami
Esri Notable Contributor
Popups don't support showing related table records at this time. It's something we're considering for the future, however. You have to add the attributes to the shapefile, which won't really support one to many.

Thanks,

Mike
0 Kudos
SorinCiolofan
Emerging Contributor
Popups don't support showing related table records at this time. It's something we're considering for the future, however. You have to add the attributes to the shapefile, which won't really support one to many.

Thanks,

Mike


Hi Mike and others,

So what has to be done? Because from your answer I understood it will not support 1-n relations. Suppose I have in my shape files 2 points, A and B and in one table i have values measured from a sensor in point A and values measured in point B, how can I have in ArcGIS Online a pop-up that will display the values measured? Or this is not possible? If it is not possible at all, what is a workaround? Do I have to code myself a pop-up? Are there any samples of code to do this or something close to this requirement?

Thank you
Sorin
0 Kudos
PaulLohr
Frequent Contributor
What about placing multiple points, one on top of another, to represent the "many" side of the relationship? The pop-up on the ArcGIS Online map should retrieve all of the point records with a single click. Not a clean solution but perhaps a workaround.

ESRI is terribly slow at getting useful functionality in place. ArcGIS Online has been around for quite a while yet we still don't have something as common as support for one to many relationships.
0 Kudos
SorinCiolofan
Emerging Contributor
What about placing multiple points, one on top of another, to represent the "many" side of the relationship? The pop-up on the ArcGIS Online map should retrieve all of the point records with a single click. Not a clean solution but perhaps a workaround.

ESRI is terribly slow at getting useful functionality in place. ArcGIS Online has been around for quite a while yet we still don't have something as common as support for one to many relationships.


Thanks for reply. Yes, that's exactly what I was trying now, but got into this other problem
I tried to run the Make Query Table tool from ArcMap on 2 entities: ShapeFileTest which is a shapefile and Values table which is a dbf table. I followed the steps described here http://help.arcgis.com/en/arcgisdesk...001w000000.htm.
At the end I got the following error: 000383 : Issue with a table; cannot find the workspace
Description
The input table has an unknown workspace. MakeQueryTable accepts data from an ArcSDE geodatabase, a file geodatabase, a personal geodatabase, or an OLE DB connection.

I set up in the Make Query Table window, Environments... tab the following current workspace C:\Users\arcgis
which is also the place where the map, the shapefile and the dbf files resides. It is also set in the Catalog options window.

Do you have any idea what is going wrong here?

Any help is much sppreciated.
Thanks
Sorin
0 Kudos
SorinCiolofan
Emerging Contributor
What about placing multiple points, one on top of another, to represent the "many" side of the relationship? The pop-up on the ArcGIS Online map should retrieve all of the point records with a single click. Not a clean solution but perhaps a workaround.

ESRI is terribly slow at getting useful functionality in place. ArcGIS Online has been around for quite a while yet we still don't have something as common as support for one to many relationships.


Hello Paul,

I came back to your original answer, because I am not sure that I fully understood the workaround. Could you please let me know your answer to following questions:
I have 2 points on the layer (corresponding to 2 sensors on map) and for each point I have 100 values measured. What I want to be able to see when I open a popup for one sensor is a bar chart representing the variation in time of the 100 values.
Do I need to create for each sensor, 100 points on the layer, where each point overlaps the precedent one? Do I need to click 200 times on the map?
And then, if the points overlaps, then a new pop-up is created for each point so I will actually get 100 pop-ups per sensor instead of 1 pop-up?
I can see that the FID value is unique for each point, so a new record in the table actually means to create a new point?
Not sure what is the meaning of the ID attribute.

Thanks
Sorin
0 Kudos