topic Re: Need help putting latitude and longitude CSV excel file onto map in ArcGIS Online Questions

Need help putting latitude and longitude CSV excel file onto map

BenProsser — Wed, 16 Aug 2017 09:54:39 GMT

Firstly, I'm new so i can't do much. I have a small amount of data, each linked to a lat/long destination. However whenever I try to import this, it says:

'Longitude, and / or Latitude, not fully specified".

I was wondering if someone could tell me how I'm meant to lay it out so that it is fully specified?

Thanks.#

Re: Need help putting latitude and longitude CSV excel file onto map

NeilAyres — Wed, 16 Aug 2017 10:45:09 GMT

Can you post a view of your Lat/Long values here?

Re: Need help putting latitude and longitude CSV excel file onto map

BenProsser — Wed, 16 Aug 2017 10:50:47 GMT

Re: Need help putting latitude and longitude CSV excel file onto map

NeilAyres — Wed, 16 Aug 2017 10:53:33 GMT

So which is the Lat & Long columns?

I would suggest you need a header line.

Re: Need help putting latitude and longitude CSV excel file onto map

NeilAyres — Wed, 16 Aug 2017 10:56:50 GMT

Ah, is that ...

a string with both coords in the same cell?

That's not going to work.

I think you need to re-arrange this data. With 2 columns, one each for the Lat & Long.

And you data items as columns as well, not rows as you have it here.

Re: Need help putting latitude and longitude CSV excel file onto map

DanPatterson_Retired — Wed, 16 Aug 2017 11:00:48 GMT

You need to rearrange your table

Longitude, Latitude, Open_space, Age, Noise, Upkeep, Cleanl, Pedest

-51 51. 2 2 -3 0 2 27

Notice, that everything is a number, the first row is the header, there are no blank rows AND, the field names are short, don't begin with a number, and have NO spaces (and don't contain reserved words)

Re: Need help putting latitude and longitude CSV excel file onto map

BenProsser — Wed, 16 Aug 2017 11:02:04 GMT

Is this better?

Re: Need help putting latitude and longitude CSV excel file onto map

BenProsser — Wed, 16 Aug 2017 11:02:26 GMT

Ah okay, thanks!

Re: Need help putting latitude and longitude CSV excel file onto map

BenProsser — Wed, 16 Aug 2017 11:06:52 GMT

Thanks!

Re: Need help putting latitude and longitude CSV excel file onto map

NeilAyres — Wed, 16 Aug 2017 11:35:56 GMT

You will have to split that first column into 2 columns. But that would be the way to go.