topic Re: Importing CSV with DMS Coordinates in ArcGIS Online Questions

Importing CSV with DMS Coordinates

JessicaRouns — Mon, 31 Jan 2022 21:39:07 GMT

Currently, when importing a CSV the lat and longs need to be in decimal degrees. Does any one know of a way to import a CSV with lat and long in DMS? Using Pro is not an option. Are there any custom widgets that will aide this?

Re: Importing CSV with DMS Coordinates

DanPatterson — Mon, 31 Jan 2022 22:45:46 GMT

import your coordinates into excel and do the conversion there (dd = Deg + min/60 + sec/3600 )

For future reference Pro has this capability Coordinate Table To Point (Defense)—ArcGIS Pro | Documentation

but it doesn't appear to be in ArcMap's version

Re: Importing CSV with DMS Coordinates

JessicaRouns — Tue, 01 Feb 2022 21:42:14 GMT

Hi Dan

This would be a bit of a last resort. Was hoping someone knew of a custom import widget specifically for DMS. The geometry service allows conversion between DD and DMS, wonder if something can be built utilising this service to publish DMS directly?

Re: Importing CSV with DMS Coordinates

BryndaHatch — Thu, 03 Feb 2022 16:07:14 GMT

Jessica,

Have you tried ArcGIS for Office? You can download it from here: https://www.esri.com/en-us/arcgis/products/arcgis-for-office/download

With ArcGIS for Office, I was able to plot DMS onto a map within Excel and then publish it to AGOL from there. The only catch was that the Lat and Long had to be in separate columns.

https://doc.arcgis.com/en/office/install-and-configure/supported-notation-formats-m4o.htm

Thanks,

Brynda

Re: Importing CSV with DMS Coordinates

JessicaRouns — Fri, 04 Feb 2022 01:03:18 GMT

Hi Brynda,

Thanks so much for the help doc. This is is a great quick fix solution, but the goal would still be a custom widget within Portal to read and spatialise DMS from a spreadsheet.

Thanks again,
Jess

Re: Importing CSV with DMS Coordinates

BryndaHatch — Fri, 04 Feb 2022 13:39:48 GMT

Jess,

Since you're asking for a new feature, can I suggest you post your idea to the Ideas page? https://community.esri.com/t5/arcgis-online-ideas/idb-p/arcgis-online-ideas

The development team takes customer's ideas into consideration when planning new work.

Thanks,

Brynda