idea WAB attribute table widget - export to csv - xy coordinate unit configuration in ArcGIS Web AppBuilder Ideas

WAB attribute table widget - export to csv - xy coordinate unit configuration

MegHoole — Mon, 24 Jul 2017 23:24:09 GMT

Context: When exporting a point dataset to csv using WAB's attribute table, AGO appends an x and y field and populates with coordinates based on the data's spatial reference. There is no option to configure the output units for x and y. The default seems to be web merc coordinates in meters. We'd like to be able to configure the widget to export the x y coordinates in decimal degrees, a format that our audience can use without needing to do a translation.

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

Anonymous User — Wed, 18 Oct 2017 22:20:21 GMT

I can definitely agree with this statement. Added functionality to select output coordinate system is a necessity especially if dropping into Desktop for further analysis.

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

ElliottPlack1 — Thu, 01 Mar 2018 02:24:57 GMT

I tried reprojecting my data to GCS WGS 1984 to rectify the issue (my desired outcome is to have decimal degrees for X and Y) and I'm still getting the web mercator X and Y.

But alas, the output CSV still looks like this.

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

ScottLarkin — Tue, 12 Mar 2019 04:34:31 GMT

This needs to be addressed as this is not good practice that the WAB Attribute Widget exports a CSV file with web merc coordinates by default but when you try to load this same file back into either a WAB application or an ArcGIS Online Map it does not recognize it as having valid location data or plots it incorrectly. I agree with Meg Hoole that we need to be able to configure the widget to export the x y coordinates in decimal degrees, a format that your audience can use without needing to do a translation.

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

MegHoole — Wed, 13 Mar 2019 18:16:32 GMT

Katie Cullen‌ has this been reviewed? I find that there are many many many ideas in Geonet that appear as "new" such as this one that was created 2 years ago....any updates would be appreciated. thank you!

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

Anonymous User — Wed, 13 Mar 2019 18:57:18 GMT

There was actually a bug logged for this recently:

BUG-000120358: In Web AppBuilder for ArcGIS, the Attribute Table widget 'Export to CSV' option fails to maintain the XY values in the same spatial reference as the data.

Meg Hoole do you want me to attach you to this?

If you export to csv from the item details page it does seem to honor the spatial reference.

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

ScottLarkin — Wed, 13 Mar 2019 21:33:37 GMT

Hi Kate,

Yes that would be great as I am not sure what the "item details page" is that you refer to in Web AppBuilder for ArcGIS?

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

MegHoole — Wed, 13 Mar 2019 22:44:25 GMT

Yes please and Scott Larkin‌ too if you can.

Scott Larkin‌ I think Katie means that if you go the source hosted feature layer's item details page (i.e. every item has a details page accessible via the content page, or in WAB it may be available via the layer list widget if configured as such). This is a bit convoluted for an end user to know how to do tho....

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

ScottLarkin — Wed, 13 Mar 2019 23:15:14 GMT

I agree, I did think about this but figured trying to get an end user to do this is way to much of an expectation and would only generate more questions on how.

Thanks Meg

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

MegHoole — Mon, 28 Sep 2020 21:05:16 GMT

Hi Katie... curious if there will be any further work on this BUG-000120358? Today when I export csv from WAB attribute table widget - no coordinates are included in the x and y columns.... not even web merc, and the ago hosted feature layer was published using web merc. It would be really nice to get this resolved! Thank you

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

DHCDHC — Wed, 18 Nov 2020 18:38:53 GMT

Having the option to to configure the x and y coordinates when exporting from the Query widget would certainly save us a lot of hassle.

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

DanielledeNeui_ALO — Thu, 16 Jun 2022 13:48:49 GMT

Completely agree on configuring the x and y coordinates when exporting from the query widget. I am running into the same issue. My end users will not know what to do with WGS84. Has this been resolved?

Re: WAB attribute table widget - export to csv - xy coordinate unit configuration

PJ — Tue, 01 Nov 2022 21:08:09 GMT

Hi, just wondering if this issue has been resolved yet. I am dealing with the same issue.

Thanks