how to find longitude and latitude

[#1]

Hi All,

I want to plot a map for against my data, but i dont have longitude and latitude.

How can i find it,, please help,,,, its very urgent,

Thanks in advance

Best Regards,

Binod Kr.

[#2]

Latitudes and Longitude if not present in your database [in most of the cases it doesnt have], you will need to search it on the net. There are lots of the sites which provide such data, may be free or with some nominal fees.

For example: http://www.infoplease.com/ipa/A0001769.html or

http://www.mapsofworld.com/lat_long/united-kingdom/united-kingdom-lat-long.html

Cheers

[#3]

I've come across a prevous QVW where the address details were being passed against the Google GEO code web service at the time of data load.  The script being used is as follows

Table1:

LOAD

     FirstName,

     LastName,

     Address,

     City,

     State

FROM

People.xlsx

(ooxml, embedded labels, table is Sheet1);

let noRows = NoOfRows('Table1')-1;

for i=0 to $(noRows)

          let d=peek('LastName',$(i),'Table1') & ', ' & peek('FirstName',$(i),'Table1');

          let p=peek('Population',$(i),'Table1');

          let address=peek('Address',$(i),'Table1') & ' ' & peek('City',$(i),'Table1') & ' ' & peek('State',$(i),'Table1');

          Data:

          LOAD

          '$(d)' as Name,

          '$(p)' as Population,

          '$(address)' as Address,

          subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,

          subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude

          FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);

next

hope this helps.  I've not implemented this myself but the comment i had seen from other users was that they had managed to implement it successfully

[#4]

just found this app and this does it slight differently