Select to view content in your preferred language

Shape_Area Exporting

577
6
02-08-2023 03:53 PM
DOI_Admin
Emerging Contributor

What units are used in Shape_Area when Exporting Polygons from Survey123 to csv or Excel?? I used Hectares on the Polygons in the Survey and appeared on the excel in exponential figures..  

excel geoshape.JPG

0 Kudos
6 Replies
DanPatterson
MVP Esteemed Contributor

area and length are always calculated in the coordinate system of the featureclass.  These data suggest a GCS in decimal degrees.  Nothing changes these values although they can be calculated or shown in a different coordinate system, in a variety of places, which has what has happened here.  If you need values in metric units, you will need to take the extra steps to get them in your table.


... sort of retired...
O1S1
by
New Contributor

Hi Dan, 

Could you please outline the extra steps?

I am having the same issue when exporting to excel or CSV and need the shape_areas in m2.

I can export in m2 to a report with no issues but can find where to update the export template for csv or excel.

I mostly use Survey123 web. 

Thanks

0 Kudos
DanPatterson
MVP Esteemed Contributor

Calculate Geometry Attributes (Data Management)—ArcGIS Pro | Documentation

where you can specify the output coordinate system for the calculations 

however... the above is for arcgis pro


... sort of retired...
0 Kudos
DOI_Admin
Emerging Contributor

Thankyou Sir.. Really Appreciated the reply....

0 Kudos
DougBrowning
MVP Esteemed Contributor

You can create a field that calculates the area  see here  https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-lines-and-polygons...

As stated the shape fields are built into the feature class and are not a 123 thing.

Or you can use Arcade after the fact for display.  I like this way because if someone alters the shape in the webmap the 123 formula does not update.  But there are disadvantages too.

Hope that helps

 

DOI_Admin
Emerging Contributor

Thankyou @DougBrowning