Google maps in Sense

[#1]

Hi,

I have a list of post codes with latitude and longitude grid. I need to show these locations on google maps in Sense. Can someone guide please?

[abhaysingh · Accepted solution]

Hi Sarb Nyota..

try like this

load

     field1,

     field2,

     lattitude,

     longitude,

     geomakepoint(lattitude, longitude) as Geokey

from .....

than on ui simply drag MAP chart and add geokey as measure.

thanks

Abhay

[#3]

Thanks Abbay, that seems to work now. the results show me that my latitude and longitude location is not right.

Do you know where can I find a list of all post codes with latitude and longitude information?

[abhaysingh]

No Sarb sry i cant help in this, but organization has to maintain their Database in that case no one can provide you such data if you want word standard data like county/city etc lat long than u can find it on excel..but apart from that i dont think any one can help.

and you cant represent right data until and unless you have right lat long.

thanks

abhay

[#5]

Thanks Abbay,

I found this link that gave me latitude and longitude location for my postcodes

Postcode Batch Converter | UK Grid Reference Finder

Thanks for all your help on this