google maps problem

[#1]

Hi,

I am trying to plot a google map by zip code. I am using the attached zipcodes coordinates to plot the geocodes. However, the graph seems to be showing the cricles at the corner of the googlemap as shown below

I am not trying anything fancy here. Just trying to see how the map looks like so in the expression using sum(1) just to check how the map looks like.  If I use these coodinates from the attached file, the map looks like the one I have shown above

However, If I use some sample coordinates like below, the map works

	Store_City, Longitude, Latitude
	Ontario, 50.0000, 85.0000
	Caboolture, 27.0667, 152.9667
	Bundaberg, 24.8500, 152.3500
	British Columbia, 54.0000, 125.0000
	Nova Scotia, 45.0000, 63.0000
	Chermside, 27.3833, 153.0167
	Buderim, 26.6850, 153.0530
	Quebec, 53.0000, 70.0000

Can someone please tell me what is wrong with the zip codes from the attached file?

[fred_s]

Hi Syed,

Try replacing the . with a ,

replace(Longitude_org,'.',',') as Longitude

Grtz Fred

[fred_s]

See this thread, two days ago:

Re: load postal code into map