×

Step 3 : Build DB View


Build MS4DB View (only Windows) : 4 views :total/sum/avg : population/province/city
READ MS4SCRIPT CODE

MS4 DB : Create View 1 : Total population/province : Drag & Drop Column
MS4 DB : Create View 2: nb city/province : Drag & Drop Column
MS4 DB : Create View 3 : nb city ,province,population
MS4 DB : Create View 4 : average population
MS4 DB : Create View 5 : province-mapcode
MS4 DB : Create View 6 : city Latitude/Longitude