ArcGIS for Excelで表示するために、ポリゴンフィーチャをテキストのgeojson形式でどのようにエクスポートしますか？

Question

こんにちは、 ArcGIS for Excelには大きな可能性があると思いますが、ポリゴンについてArcGIS ProとExcelの間で統合する最適な方法<\/U>が何かはよくわかりません。ポイントの場合は大した問題ではありません（XとYを抽出するだけです）。ポリゴンの場合は、ジオメトリを.geojson（テキスト）形式で収集する必要がありますが、それは問題ありませんが... どうすればいいのでしょうか？ <\/span><\/P>ウェブのチュートリアルではWKT形式を推奨していますが、.geojson形式で行うことも可能であるべきだ<\/U>と考えています。プラグインにとって唯一の方法です。私の提案は2つのステップです： 1. ジオメトリをテキスト（属性に）エクスポートする 2. フィーチャテーブルを以下のようにCSV/XSLXとして保存する <\/span> ArcGIS Proでどのような手順を踏むべきか確信が持てません。アドバイスをいただけると幸いです。<\/P>

ShannonCardoza · Answer

Good morning @Piotrek6116 ,

Thank you for the clarification. There are a few workflows and products that you reference in this post. Can you call our Support Services team and create a case so we can work out the details a bit more efficiently? The number for Support Services is 1 (888) 377-4575.

Have you logged a case before? Let me know if you need further guidance.

Thank you much,

SC

Piotrek6116 · Answer

Hey Shannon @ShannonCardoza,

Thanks for your answer, but it's still not what I'm looking for..

Why?

For me, A4E plugin is a good step to inspire people - who don't know too much about GIS systems.

I know about hosted features, but...

In this scenario, a people have to be a part of my organization or we have to publish content to the public - it's not a good every time. I'm talking about data integration for people, who are out of my organization and working only with Excel app.

I'm not sure if this tool designed most for points, I did some time ago, sucesfull conversation from Polygons to EsriJSON (text) but using FME app by "GeometryExtractor" tool..

So, How do achieve the same results by ArcGIS Pro?

If we wanted to put only points by A4E, In my opinion, the best way is to export it into X, Y and select the Coordinates option with custom EPSG code - but still not sure how to achieve the same results for EsriJSON geometry?

Because I guess its a bit tought to import geojson format into Excel - the documentation does not show any steps on how to integrate Excel with EsriJSON geometry, right?

The FME app have tool to deal it - so I guess developrs who deal this opiton (EsriJSON Geometry) know way how to work with that.

PS: I'm also compelled ArcGIS for Excel Basics course, I can't remember were there realize case like that
Thank you!

ShannonCardoza · Answer

Good afternoon @Piotrek6116, Thank you so much for the feedback and questions on using ArcGIS for Excel with ArcGIS Pro. I think we have a few questions to address in this post. I will list them below -

1. What is the best way to integrate it between ArcGIS Pro and Excel for polygons?

* At this time, using .geojson (text) format is the only option for polygons with Pro and A4E. Using ArcGIS Pro and exporting to Microsoft Excel worksheets (.xls and .xlsx) is the correct workflow for point data. Save the feature table into .xlsx format. You may also use ArcGIS Pro > publish a hosted feature layer to ArcGIS Online and then join in ArcGIS for Excel using a boundary.

2. To understand the .geojson format, see our help topic on Data preparation. This can be a beneficial resource.

3. ArcGIS Online also has helpful documentation on how to set up data for supported feature types. GeoJSON using ArcGIS Online, uses a geographic coordinate reference system, World Geodetic System 1984, and units of decimal degrees.

Please let me know if you have any follow-up questions on these topics.