How to create a survey related data model in an enterprise geodatabase?

JürgenBiendara1

Hello,

I have successfully created and published a Survey123 form in my ArcGIS Enterprise environment. Now I want to create an identical form and use a hosted feature service that runs against my enterprise geodatabase.

The question is: What is the easiest way to create the database model in my enterprise geodatabase?

From my perspective, the easiest way would be some kind of copying and pasting the data model that was created by publishing the survey from the data store to my geodatabase.

I also found this blog post, which speaks of "...create the tables in the enterprise geodatabase to store the data".

https://community.esri.com/groups/survey123/blog/2016/12/14/migrating-data-from-the-survey-feature-service-to-an-enterprise-geodatabase

Any suggestions, how to accomplish this request?

And a second question: Once I have created the data model in my enterprise geodatabase, (how) can I switch an existing Survey123 form to the related feature service?

Thank you very much, best regards,

Jürgen

dougbrowning

I used this flow.  It is based on using collector but concepts the same.

 

Create the form and publish.

Download the form feature service as a gdb.

Create a new GDB in catalog - this holds your collector features.

Add the FS that collector is going to use (point, line, whatever).

     Add a key field to the collector class then pass this value to Survey123 (like you have been doing).

Copy the Survey123 FC you downloaded into the collector gdb.

Create a Relationship class from the Collector FC to the Survey123 FC.

Publish this gdb as a service.

Go into the Survey123 form and set the submission_url to the new HFS you just published.

Republish the form.

 

Now you can add the collector service to a map and all the relationship classes come along.  Now you have your collector features connected to your forms.  Forms to lines or polygons or whatever does not matter.

 

I have this working with 9 forms/9 relationships classes and works great.  I can list all the forms for a feature or open a form and backtrack to the feature.  Plus if you export the HFS to a GDB all the relationships classes come with it.  They also works in ArcMap when connecting to the HFS directly.  Oh and you can even see the linked forms in Collector - even other peoples forms!

 

Also what I did was add a field called XForm and put the item id in that field.  Then in the collector map I can use that field to construct the URL.  It then launches and prefills in the "Key" field you decided to use.  This way you can actually mix and match forms if you want.  Say 2017 features link to the 2017 form but the 2018 features link to the 2018 form.

 

Hope that makes sense and helps you.