Latitude and Longitude alteration

[tmcrouse]

I used GEOCoder to obtain Lat and Long for addresses I have. The only problem is the output is all numeric with no decimals and no way to know the correct lat and long. The output looks like this:

latitude longitude


34888890 849000000

Can anyone tell me how to get them to the correct formatting?

[alansidman]

Perhaps a query like this.

SELECT Table1.ID, [Longitude]/1000000 AS NewLong, [Lattitude]/10000000 AS NewLat
FROM Table1;


then use the query as your recordset, or create a make table query with the resulting query

[John_G]

You should look at the documentation for GEOCoder to determine what the output format is, i.e. where the implied decimal point is and how many decimal places follow it. If you can determine for certain how many decimal places there are - even if they are all zeros - you can convert to the lat-long decimal values by dividing by the appropriate value. You could use type double for maximum accuracy.

One thing you will need to be careful of is what does GEOCoder do when the integer portion of the lat or long value is <10 or >99, and what does it do for coordinates in the southern or eastern hemispheres.

[orange]

I agree with John_G in that your first step is to see what/how GEOCoder has done/expects/should be interpreted.

You may also find this material from Chip Pearson useful at least as a reference. It says Excel, but the vba is applicable to Access also.