           BASIC HELP : MS4BI by MS4script   
   2022 version 1.10

Chapter 6 : CHARTS

KEYWORD : FORMGOOLE : DRAWGEOMAP

Definition
Based on the GOOGLE graphics library, displays Standard GEOMAP charts .

Syntax 1

  	
	 	FormGoogle : DRAWGEOMAP 
		 Begin_sw
			([
			code javascript..table : [{f:'string ', v:'CODE ISO '},latitude],
			])
		 End_sw		;

Example 1

  		   
 #include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 
	 BEGIN
	position  : relative, 450,650 :  
 	FormGoogle : DRAWGEOMAP 
	 Begin_sw
	([
		['Province','Disposable Income by Household'],
		[{f:'Anhui ', v:'CN-34 '},15154],
		[{f:'Beijing ', v:'CN-11 '},40830],
		[{f:'Chongqing ', v:'CN-50 '},16569],
		[{f:'Zhejiang ', v:'CN-33 '},29775],   
	]),
		{
			colorAxis: {colors: ['yellow', 'red']},
			displayMode: 'regions',
			region: 'CN',
			resolution: 'provinces'
		}
   End_sw

FormGoogle : DRAWGEOMAP

        MS4BI  : GEOMAP (Google chart)

Source & Copy FormGoogle GEOMAP

Visualise ALL EXAMPLES : FormGoogle

Syntax 2 : LoadArray

  	
	 	FormGoogle : DRAWGEOMAP 
		loadArray :  ArrayName   { field :"NameVar"  } ,
		 Begin_sw
		([
			code javascript.. 
         ])
		 End_sw		;

Example 2 LOADARRAY

  		   
 #include "#SYSPATHMS4BI+\zInclude\includeChart.h"  
 Array:    GeoMapRef  Occurs 40 { char StringEx1:20;CHAR stringVal :128; integer IntValEx1;} 
 

	FormGoogle : DRAWGEOMAP 
    loadArray : GeoMapRef   { field :"stringVal"  } ,
	 Begin_sw
	{
        colorAxis: {colors: ['yellow', 'red']},
        displayMode: 'regions',
        region: 'CN',
        resolution: 'provinces'
	}
    End_sw

Visualise Example : FormGoogle GEOMAP (LOADARRAY)
Source & Copy FormGoogle GEOMAP (LOADARRAY)

Visualise ALL Examples : FormGoogle
Visualise ALL CHART examples

Prerequisites
- include header file : driver:\MandragorePlanete\MS4BI\zInclude\IncludeChart.h (optional)
- DBconnect{Ms4DB} (DB Name )(optional)

Remarks
IncludeChart.h :

By adding a label to each value, we can still use ISO codes and avoid the troubles of Geocharts not understanding some of the English names of Chinese provinces.
MS4SCRIPT : only ADD-ON MS4BI
GO to see : GOOGLE CHARTS (web)

See also
FormPlus,FormPchart,FORMEXCEL,FORMMORRIS,FORMLEAFLET,

Chapter 6 : CHARTS

KEYWORD : FORMLEAFLET : DRAWGEOMAP

Definition
Based on the LEAFLET graphics library, displays Standard GEOMAP charts .

Syntax 1

  	
	  
		FormLeaflet : DRAWGEOMAP ID: "string", 
		SetView(latitude,  longitude), Zoom :  integer ,
		height :"var px or % ",width : "var px or %"
 		 Begin_sw
		  code javascript..table : var marker = L.marker([latitude,  longitude]).addTo(mymap).bindPopup("string");
		 End_sw		;

Example 1

  		   
  
  
 BEGIN
	 
 	FormLeaflet : DRAWGEOMAP ID: "mymap", 
		SetView( 48.864716, 2.349014), Zoom :  14 , ** longitude latitude
		height :"350px",width : "80%"
    Begin_sw  
      var marker = L.marker([ 48.8601804,2.3461359]).addTo(mymap).bindPopup("Hello MG planete");
  	End_sw	;

Form Leaflet : DRAWGEOMAP

        MS4BI-MG PLANETE   : GEOMAP    PARIS

Source & Copy FormLeaflet GEOMAP

Visualise ALL Examples : FormLeaflet
Visualise ALL CHART examples

Syntax 2 : LoadArray

  	
	    FormLeaflet : DRAWGEOMAP ID: "string", 
		SetView(latitude,  longitude), Zoom :  integer ,
		height :"var px or % ",width : "var px or %"
		loadArray :  ArrayName   { field :"Array NameVar"  } ,
		 Begin_sw
		([
			code javascript.. 
         ])
		 End_sw		;

Syntax 3 : TABLE FIELD : go to see : LEAFLET GEOMAP

Example 2 LOADARRAY

  		   
  Array:    GeoMapRef  Occurs 40 { char StringEx1:20;CHAR stringVal :128; integer IntValEx1;} 
 

	FormLeaflet : DRAWGEOMAP 
	 ID: "mymap", 
	SetView(51.5112,  101.254), Zoom :  12 ,
	height :"300px",width : "80%"
    loadArray : GeoMapRef   { field :"stringVal"  } ,
	 Begin_sw
	 
		var influence = L.circle([39.913818,116.363625], 160000).addTo(mymap);
		var circle = L.circle([33.391376,117.557678], {
						color: 'red',
						fillColor: '#f03',
						fillOpacity: 0.5,
						radius: 150000
						}).addTo(mymap);
					circle.bindPopup("I am a circleXXXXXXXXXXXXXXXXXXX.");
		var polygon = L.polygon([
					[27.518280, 120.425766],
					[32.540447,119.243889],
					[27.934572,116.312164]
					]).addTo(mymap);

					polygon.bindPopup("I am a polygon.");

					marker.bindPopup("Hello world!
I am a popup.").openPopup();

 
					var popup = L.popup()
					.setLatLng([35.8617,104.1954])
					.setContent("CHINA.")
					.openOn(mymap);
    End_sw

Visualise Example : FormLeaflet GEOMAP (LOADARRAY)
Source & Copy FormLEaflet GEOMAP (LOADARRAY)

Visualise ALL Examples : FormLeaflet
Visualise ALL CHART examples

Syntax 3 : TABLE FIELD

  	
	    FormLeaflet : DRAWGEOMAP ID: "string", 
		SetView(latitude,  longitude), Zoom :  integer ,
		height :"var px or % ",width : "var px or %"
		use table ( NameVar  or string , field :"string Table Name field" )
 		 Begin_sw
		([
			code javascript.. 
         ])
		 End_sw		;

Example3 : TABLE FIELD

  		   
     Ms4_SQL{ms4DB}("CREATE TABLE [TABEXAMPLE] "+ 
	"(      [INDEXID] TEXT,"+ 
	"       [LONGSTRING] char(1024),"+ 
	"       PRIMARY KEY (`INDEXID`) )");  
 
      Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX0','%s')",GeoMapRef[0].stringval);
      Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX1','%s')",GeoMapRef[1].stringval);
	  Ms4_SQL{ms4DB}("INSERT INTO TABEXAMPLE VALUES('INDEX2','%s')",GeoMapRef[2].stringval);


	FormLeaflet : DRAWGEOMAP 
	 ID: "mymap", 
		SetView(27.934572,116.312164), Zoom : 4.3 ,
	height :"450px",width : "650px"
	use table ("[TABEXAMPLE]", field :"longstring" ) 
	 Begin_sw
	    var popup = L.popup()
					.setLatLng([35.8617,104.1954])
					.setContent("CHINA.")
					.openOn(mymap);
    End_sw

Visualise Example : FormLeaflet GEOMAP (TABLE FIELD)
Source & Copy FormLEaflet GEOMAP (TABLE FIELD)

Visualise ALL Examples : FormLeaflet
Visualise ALL CHART examples

Prerequisites
- include header file : driver:\MandragorePlanete\MS4BI\zInclude\IncludeChart.h (optional)
- DBconnect{Ms4DB} (DB Name )(optional)

Remarks
IncludeChart.h :

MS4SCRIPT : only ADD-ON MS4BI
GO to see : LEAFLET CHARTS (web)

See also
FormPlus,FormPchart,FORMEXCEL,FORMMORRIS,FORMLEAFLET

Interested in joining us? contact@mgplanete.com
The Mg Planete team

the official sites :
mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
ms4script.com

Download

official site :
getms4bi.com

Our purpose : Keep it simple !

written with ms4script

help 01.010.2022.8

MS4BI HELP 2022

Designer

BASIC HELP : MS4BI by MS4script

Chapter 6 : CHARTS

KEYWORD : FORMGOOLE : DRAWGEOMAP

Definition

Syntax 1

Example 1

FormGoogle : DRAWGEOMAP

MS4BI : GEOMAP (Google chart)

Syntax 2 : LoadArray

Example 2 LOADARRAY

Prerequisites

Remarks

See also

Chapter 6 : CHARTS

KEYWORD : FORMLEAFLET : DRAWGEOMAP

Definition

Syntax 1

Example 1

Form Leaflet : DRAWGEOMAP

MS4BI-MG PLANETE : GEOMAP PARIS

Syntax 2 : LoadArray

Syntax 3 : TABLE FIELD : go to see : LEAFLET GEOMAP

Example 2 LOADARRAY

Syntax 3 : TABLE FIELD

Example3 : TABLE FIELD

Prerequisites

Remarks

See also

Copyright 2022 by Mandragore Planete

Download

Our purpose : Keep it simple !

MS4BI in 5 minutes