topic Re: Collector and Tables Relationship class in ArcGIS Collector Questions

Collector and Tables Relationship class

SiranErysian2 — Mon, 30 Jul 2018 15:46:29 GMT

Related Tables in Collector: Spoke to Jeff Shaner and others at ESRI Conference 2018 and it was suggested that I use the Global ID field as the Primary key when joining a stand alone table with point feature class in map service published for Collector. Is this when the Global ID field is established? My table does not have a global id field. I have another field that I proposed to use that is in both the table and the feature class attributes. Why Global ID is suggested to use? Do I need to create a relationship between the table and the feature in the geodatabase for the table to appear in Collector?

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Thu, 02 Aug 2018 14:45:09 GMT

To answer your first question, if you publish your data to AGOL without a GlobalID, then a GlobalID is automatically generated. It is suggested as a primary key because it is system generated, is unique and

In order for the related table to appear in Collector‌ your workflow should be:

Create your feature class
1. Use the Add GlobalIDs tool, ArcMap will handle this even if the feature class is empty.
Create your related table, and include a text field called GUID
Create your relationship between the feature class and the table, using GlobalID as the primary key on the FC and GUID as the foreign key on the table.
Make sure both the FC and the table are present in your .mxd
Publish to AGOL.
Create your webmap, and then open it in Collector.

Feel free to PM me if you have any questions on this one.

Re: Collector and Tables Relationship class

SiranErysian2 — Thu, 02 Aug 2018 17:17:45 GMT

Joshua,

I did all of the above and it did not work. The relationship was created from feature to tabIe but I want to have all the information in the table that includes many records for the points, in the feature to reflect that information when identifying the point feature. I don't see that when I click on the points in Arc Map mxd.

Re: Collector and Tables Relationship class

SiranErysian2 — Thu, 02 Aug 2018 17:51:52 GMT

Joshua,

I went ahead and published my map to AGOL. I used the feature class as my origin table/feature class and the related table as the destination table/feature class. I see the feature class and table. I see the Global ID field. GUID field in related table is not populated. When I click on the features in the pop up I see at the bottom with Edit and zoom, Show related records (in the table) but when I click on that I get window that says No Results Found. Also, there is a field in the related table that shows the relationship class but it has a lock on it. How will my users see the information in the related table in Collector? I am making progress but still need your help.

Re: Collector and Tables Relationship class

SiranErysian2 — Thu, 02 Aug 2018 18:20:43 GMT

Joshua,

Thanks you for your response. I have been working with your suggestions.

I posted some information on the Geonet site but I want to include more information and screen shots if possible.

I opened my map in AGOL and Collector and see my features. I see the related table

Clicking on a point in the map show the pop up.

Clicking on Show related Records

The related table has a field that is supposed to show the previous year’s measurements for each point record. There are more than 1 year that I wanted to show thus the 1 to Many relationship.

But there is nothing there. Also it is locked. Everything is shared.

It made sense to me when creating the relationship class that the feature was the origin table/feature class and the related table the destination. See below.

Should I switch them?

In Collector I see the related table at the bottom of the Details for a feature. There is View> but it is empty. This is where I would like my users to see the related historic information for the particular feature to compare with the data they will be collecting in the field. There is New> which has all the fields that are included in the feature class which was used to edit the information last year. So I would like to edit here and just have them view the related table with the information at the bottom of this list. However, when I click on the edit function to collect information on a point, I do not see the related table. I guess that’s Ok but where should the edits be captured? I have to strip the information from last year’s collection in the feature class every time and re-publish the map. At the user conference, I spoke with some of the Collector developers and they suggested just adding information in the related table. But some of that information will always be the same and I would make those fields not editable.

I hope this gives you some idea of what I’m trying to do. I hope you can continue to assist me.

Thank you.

Siran D. Erysian, M.A., GISP,

Research Analyst II – GIS

_{Think Spatially}

Department of Water Resources

3374 E. Shields Ave, Rm. A-1, Fresno, CA 93726 (559) 230-3312

Siran.Erysian@water.ca.gov

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Thu, 02 Aug 2018 18:47:56 GMT

So the way the Relationship Class will work is this:

When you create a new record in the Related Table, the GUID will be populated with the GlobalID of the Feature it's related to.

The reason you aren't seeing any records when you click on the feature is because there are no records related to that feature until you create them.

If you're wanting to related existing records to the features, you'll need to create the relationships manually in ArcMap using GlobalID -> GUID, or, alternately, use some existing key(s) that relate the table to the features.

I'd suggest reading up a little on Relationship Classes before doing any more work.

Re: Collector and Tables Relationship class

SiranErysian2 — Thu, 02 Aug 2018 19:48:19 GMT

Joshua,

I want to relate existing records to the features and I did use the Global ID and GUID in the relate as you saw in the screen capture. I want to see the existing records, not create new ones.

I am familiar with relationship classes and have done them several times successfully. Probably what I need to do is use a field that already exists in both the feature class and the related table so it will work. But everyone has so far suggested using the Global ID and the GUID which I had done manually in the mxd but there are no related records. It didn’t make sense to me to use those fields.

I’ll try another field and let you know the result.

Siran D. Erysian, M.A., GISP,

Research Analyst II – GIS

_{Think Spatially}

Department of Water Resources

3374 E. Shields Ave, Rm. A-1, Fresno, CA 93726 (559) 230-3312

Siran.Erysian@water.ca.gov

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Thu, 02 Aug 2018 20:21:07 GMT

You're on the right track. They (I) were suggesting to use GlobalID and GUID as a best practice if you're starting from scratch. If you're using existing data, then the easiest route will be to use existing primary / foreign keys. I imagine you'll have success

Re: Collector and Tables Relationship class

SiranErysian2 — Thu, 02 Aug 2018 20:57:55 GMT

That makes sense! Thanks. I’ll try again.

Siran D. Erysian, M.A., GISP,

Research Analyst II – GIS

_{Think Spatially}

Department of Water Resources

3374 E. Shields Ave, Rm. A-1, Fresno, CA 93726 (559) 230-3312

Siran.Erysian@water.ca.gov

Re: Collector and Tables Relationship class

SiranErysian2 — Thu, 02 Aug 2018 22:32:33 GMT

It didn't seem to work once I published my map again with the new relationship class on existing fields. Can't get related records to show from the related table when I click on the pop-up for the location.I don't even get a window with an error. I have Show Related Data checked in the configure pop-up. Do you have any other suggestions?

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Fri, 03 Aug 2018 13:16:28 GMT

Hmm. In ArcMap when you #identify on the point do you see the appropriate related record?

Re: Collector and Tables Relationship class

SiranErysian2 — Fri, 03 Aug 2018 15:40:16 GMT

Yes it does. I related them manually. Editing feature and selecting a record in the feature and add selected to the relationship that appears. (Question: is there a more automated way to do this?)

I want the field crews to see historic information for the location. I created an expression from 3 fields (I’d like to get rid of the extra zeros but can’t figure out how to do that yet)

So republishing this feature service allows me to see the records in the AGOL map prepared for Collector. When I click on a point, I see Show related Records at the bottom and when I click on that link, I see the related that shows me the 3 dates where information is present.

What I don’t understand is when I click on Show in the Data Associated with Wells field I only get the most current record in a table window to the left no matter what field I click on

What is this table?

Thank you. You have been most helpful.

Siran D. Erysian, M.A., GISP,

Research Analyst II – GIS

_{Think Spatially}

Department of Water Resources

3374 E. Shields Ave, Rm. A-1, Fresno, CA 93726 (559) 230-3312

Siran.Erysian@water.ca.gov

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Fri, 03 Aug 2018 16:42:56 GMT

If you want to invite me to your ArcGIS Online group I'll have a look, it'll be much easier for me to investigate your issue that way...

Re: Collector and Tables Relationship class

SiranErysian2 — Fri, 03 Aug 2018 16:49:17 GMT

Is this the address I put in?

jschwartz@fcgov.com_fcgov<mailto:jschwartz@fcgov.com_fcgov>

Siran D. Erysian, M.A., GISP,

Research Analyst II – GIS

_{Think Spatially}

Department of Water Resources

3374 E. Shields Ave, Rm. A-1, Fresno, CA 93726 (559) 230-3312

Siran.Erysian@water.ca.gov

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Fri, 03 Aug 2018 16:51:41 GMT

jschwartz@fcgov.com

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Fri, 03 Aug 2018 16:54:05 GMT

Got the invite, checking now.

Re: Collector and Tables Relationship class

SiranErysian2 — Fri, 03 Aug 2018 16:55:53 GMT

Modesto GWB is the hosted feature layer. Modesto test is the map

Siran D. Erysian, M.A., GISP,

Research Analyst II – GIS

_{Think Spatially}

Department of Water Resources

3374 E. Shields Ave, Rm. A-1, Fresno, CA 93726 (559) 230-3312

Siran.Erysian@water.ca.gov

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Fri, 03 Aug 2018 17:01:53 GMT

OK cool. I see the map in Collector. When I click on an asset (Well), I can view the related records. This is the expected behavior. What is not working the way you would hope?

Re: Collector and Tables Relationship class

SiranErysian2 — Fri, 03 Aug 2018 17:15:41 GMT

So if you click on the work Show in the field Data Associated with Wells in the ModestoGWELEV related table, you see 3 values

So this is what the field worker will see? Is it possible for 3 fields to show here? I’d like the Date, Reading@ RP and NM Code (that’s if there is no reading that day, the reason why)

I set this up in the identify display in Arc Map so I was wondering if there was a way to show this in a table?

I haven’t’ looked at this in Collector yet. Can you give that a try and let me know what you see? I use iOS iPad for my Collector and I’ll do that shortly also.

Thanks again.

Siran D. Erysian, M.A., GISP,

Research Analyst II – GIS

_{Think Spatially}

Department of Water Resources

3374 E. Shields Ave, Rm. A-1, Fresno, CA 93726 (559) 230-3312

Siran.Erysian@water.ca.gov

Re: Collector and Tables Relationship class

deleted-user-qpvAI3Fo0MKR — Fri, 03 Aug 2018 18:00:50 GMT

What you're describing is the expected behavior. When you click on the asset (Well) you'll be able to view the list of related records, then your crew will need to click on the individual records to see the actual related record itself. This is how it works. Does this make sense?