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.#
Can you post a view of your Lat/Long values here?
So which is the Lat & Long columns?
I would suggest you need a header line.
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.
Ah okay, thanks!
Is this better?
You will have to split that first column into 2 columns. But that would be the way to go.
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)
Thanks!