topic Re: ArcGIS Online in ArcGIS Online Questions

ArcGIS Online

BrianKranick — Thu, 12 Feb 2015 18:21:48 GMT

Hello, I'm trying to load some data points from a excel or CSV file. Do you know what are the acceptable formats to load those to ArcGIS Online?

thanks,

Brian

Re: ArcGIS Online

DanielStauning — Thu, 12 Feb 2015 18:25:15 GMT

Hi Brian,

CSV files are a supported format for adding layers to the contents of a map. For a full list of supported formats you can refer to this page in the help:

Add layers—ArcGIS Online Help | ArcGIS

Good luck,

-Dan

Re: ArcGIS Online

BrianKranick — Thu, 12 Feb 2015 18:34:13 GMT

Right, thanks. So, I have a CSV file, but it looks like I might have to label the columns "Lat" and "Long" in order for GIS Online to properly read it, correct?

Re: ArcGIS Online

DanielStauning — Thu, 12 Feb 2015 18:57:36 GMT

If your file has latitude and longitude fields, these are used to locate the features on the map. If your file has address information, or if the latitude and longitude information cannot be determined by the map viewer, you are prompted to review the location fields and change them, if necessary.

The following fields are supported:

Latitude, Longitude
Lat, Long
Y, X
Ycenter, Xcenter
Point_y, Point_x
Address
City
State
Zip

CSV, TXT, and GPX files—ArcGIS Online Help | ArcGIS

Thanks,

-Dan

Re: ArcGIS Online

BrianKranick — Thu, 12 Feb 2015 20:02:25 GMT

do you know if there's a way to convert en masse coordinates from "Degrees Decimal Minutes" to DMS or DD? ie, converting a hundred coordinates on a spreadsheet from DCM to DMS or DD? or somewhere online?

Thanks,

Re: ArcGIS Online

DanielStauning — Thu, 12 Feb 2015 20:34:32 GMT

Brian,

Looks like there's a tool here that will batch convert the data from a spreadsheet to different values:

Batch Convert

Thanks,

-Dan

Re: ArcGIS Online

BrianKranick — Thu, 12 Feb 2015 23:57:20 GMT

Thank you for your help. Now, I created a cvs file with coordinates as DMS but when I import them into ArcOnline, they show up as six-digit numbers (for example, 323232N loads as 323,232.00). Do I need to change a format or something?