US Map in geospatial view using scatter

[#1]

Hi,

I am trying to show US map using scatter plot and dynamic image as background with latitude and longitude of each city, but it's not coming up as expected. Please help.

Regards,

Navdeep

[stigchel]

The minus sign in your longitude numbers got lost, fix that in your load or replace longitude with -longitude everywhere

e.g.

var_mid_long=min(-longitude)+(max(-longitude)-min(-longitude))/2

[#3]

Hey, Could you explain what you meant by negative sign or please share if you have done something like this, because I am not very much clear about this piece of code.

Regards,

Navdeep

[stigchel]

The longitude numbers are wrong in your data, take e.g. New York, they should be 40.77,-73.98 instead as below from your load

join(Georaphy)

load * inline

[

City,State,latitude,longitude

...

New York,NY,40.77,73.98

..

[stigchel · Accepted solution]

You can e.g. do the following to correct, also see attached

join(Georaphy)

load City,State,latitude,-longitude as longitude;

load * inline

[

City,State,latitude,longitude

[#6]

Thanks, got your point.