AGOLホストデータ編集をDesktop FGDBにマージするためのワークフロー

JeffreyWarren

<\/HEAD>

皆さん、おはようございます。<\/P>

<\/P>

現在、すべてのフィーチャサービスをAGOLでホストしています。今回が初めて、AGOLからデータを取得してArcGIS Desktopに戻す作業になります。AGOLから作成されたfgdbのデータを元のデータセットにマージするためのワークフローのアイデアを探しています。フィールドクルーが多くの属性を更新しており、それらを取り込みたいと考えています。ジオメトリはすでにいくつか移動しているため、ジオメトリには手を加えたくありません。必要なのは属性情報と彼らが割り当てた添付ファイル／写真だけです。<\/P>

<\/P>

共有していただけるワークフローのアイデアはありますか？可能であれば、このプロセスを最終的に自動化したいと思っています。<\/P>

<\/P>

思いつく限りでは、Facility IDを使って結合（join）を作成し、フィールド計算（field calc.）を行う方法しか思い浮かびませんが、他に良いアイデアがあれば知りたいです。私たちのデータはLGIMスキーマにありますが、今はWaste Waterに集中しています。ただし、この作業が終われば他のユーティリティも控えています。<\/P>

<\/P>

よろしくお願いします。<\/P>

Jeff<\/P><\/BODY><\/HTML>

EmilieBrill-Duisberg

Hi Jeff,

This is a challenge that Enterprise geodatabases and ArcGIS for Server services are well-suited for.  However, when working with file geodatabases and hosted feature services, you can get your newly collected attributes from your Collector data into your old feature class using joins and field calculations.  Transferring the attachments is a bit trickier, but follows the same basic logic.  You can use the following workflow to port your Collector attachments over to your previous geometry without bringing along the geometry created in the Collector app.  This workflow could be made into a ModelBuilder model or Python script for automation.

1.  Export your ArcGIS Online feature service, edited in Collector, to a new file geodatabase and download it to your local machine.

2.  The file geodatabase contains a relationship class which connects the features to the attachments using a GlobalID and a REL_GLOBALID field:

3.  Perform an attribute join to append the attribute fields from the downloaded feature class to your original feature class.  This join is based on a unique ID that exists in both tables and is necessary because we need to get the GlobalID field created by ArcGIS Online when the photos were collected into your original feature class as shown below.  It is a good practice to export to a new feature class after the join has been created to prevent any unexpected behavior caused by an active join.

4.  Next, perform an attribute join to append the attribute fields from the downloaded attachment table to the output of Step 3 above.  This join is based on the Global ID and REL_GLOBALID fields:

5. It's a good idea once again to make the join permanent by copying the features to a new feature class.  Now, we have a single feature class containing your original geometry and containing the Attachment IDs and the Attachment Names from the Collector data downloaded from ArcGIS Online.  This will be critical for matching up the correct photos and features.

6. Create a file directory on your computer and batch download all your attachments using the instructions given at http://support.esri.com/technical-article/000011912.

7.  Add a new text field to the output of Step 5 for the filepaths of your attachments.

8. Populate the field with your attachment filepaths using Field Calculator.  In VB, the code would be:

"<path to the folder with your photos>\ATT" & [ATTACHMENTID] & "_" & [ATT_NAME]

9. You should end up with a complete filepath which matches those of the photos you batch downloaded in Step 6:

10.  Enable attachments on this feature class using the Enable Attachments tool.  Then use the Add Attachments tool to attach the photo/video attachments:

This will match your attachments to the correct feature and create a new relationship class between the final output of the above workflow and an attachment table containing your media.

Best wishes,

Emilie

Esri Support