Hi, I am using following code for my map and there is a problem with the Georgia because it is displaying the Georgia state in US. How can i change that? please help. Thanks
DISTRICT_LINK_MAP:
LOAD
Distinct (mid(COUNTRY_NAME,1,(Len(COUNTRY_NAME)-3))) AS DISTRICT_NAME
FROM
(qvd) Where COUNTRY_NAME<>'SRI LANKA';
let noRows = NoOfRows('DISTRICT_LINK_MAP')-1;
for i=0 to $(noRows)
//let a = peek('CONTRACT',$(i),'Customer_Master');
let b = peek('DISTRICT_NAME',$(i),'DISTRICT_LINK_MAP');
// let c = peek('Quantity',$(i),'CustomerTable');
GeocodeResponse:
LOAD
status,
//'$(a)' as CustomerName,
'$(b)' as DISTRICT_NAME,
//'$(c)' as CustomerQuantity,
([result/geometry/location/lat]) as Latitude,
([result/geometry/location/lng]) as Longitude
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(b)&sensor=false] (XmlSimple, Table is [GeocodeResponse])
;
next i;
max_zoom_level = 5; //maximum value 17
// Variables required for calculating map
// No need to change these
var_pi180 = '=pi()/180';
var_lat_offset = '0';
var_mc2 = '=256*pow(2,$(var_zoom))';
var_mc1 = '=256*pow(2,($(var_zoom)-1))';
var_mid_lat = '=min(Latitude)+(1+var_lat_offset)*((max(Latitude)-min(Latitude))/2)';
var_mid_long = '=min(Longitude)+(max(Longitude)-min(Longitude))/2';
var_zoom = '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( Longitude *((256*pow(2,_zoom_level ))/360)) ) <map_size_x AND max((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))-min((256*pow(2,(_zoom_level-1)))+((0.5*log((1+(sin((Latitude)*pi()/180)))/(1-(sin((Latitude)*pi()/180)))))*((-256*pow(2,_zoom_level))/(2*pi()))))<map_size_y,_zoom_level,1),_zoom_level))';
var_maptype = '=if(isnull(only(maptype)),fieldvalue( '&chr(39)&'maptype'&chr(39)&', 1 ),maptype)';
map_size_x = '640';//640
map_size_y = '400';//400
SET HidePrefix = '_' ;
// Field required for calcualting best zoom level
_zoom_level:
Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);
maptype:
LOAD * INLINE [
maptype
roadmap
mobile
satellite
terrain
hybrid
];
set hideprefix = 'maptype';
