Excel for ArcGIS は pulldata 関数を使用して REST API から属性を取得します

Question

こんにちは、

私は Excel for ArcGIS を使って作業しており、ジオコードされたポイントが Excel シート内で、交差する下院および上院の地区を取得できるように関数を実行させたいと考えています。Survey123 Connect の関数に似た、既存のデータでデータを補完するために Excel が使用できる pulldata 関数はありますか？

ShannonCardoza · Answer

After some additional collaboration, here is an optional workaround @MissouriOffice_of_Geospatial_I  -

* Sign in to your ArcGIS account

* Go to "+Add", and choose the "ArcGIS" tab, then search for the layer containing the ArcGIS data that you need

* Click on the table icon next to the layer name to add the layer's data to Excel

4. The data will be added to Excel on a different sheet ("ArcGIS data sheet")

5. Go back to the sheet with the geocoded points. Use cell references (=sheetName!cellName) to create a new column that links to the data from the ArcGIS data sheet.

6. The geocoded points data is now linked to the ArcGIS data on the "ArcGIS data sheet". To sync the data from ArcGIS, go to the ArcGIS data sheet and make sure the Excel cursor is on the ArcGIS data. The "Map Data" tab will appear. Click the "Sync with ArcGIS" button to bring any data updates from ArcGIS.

Best,

SC

ShannonCardoza · Answer

Good morning @MissouriOffice_of_Geospatial_I, Thank you for posting your question! At this time, we do not have a tool or pulldata function in ArcGIS for Excel. However, if you are trying to find interesect results between 2 feature layers you may want to explore our Create spatial filter tool. There is a Filter type parameter called Intersect which is used to specify the relationship between the two input datasets.

I am not entirely sure if this is 'like' the PullData function used in Survey 123 Connect but it maybe an option. In the meantime, let me take this workflow you suggested back to my team and see what we can do...stay tuned!

Best,

SC