-
Notifications
You must be signed in to change notification settings - Fork 0
/
Lagos Amenities and Resources Dashboard documentation.htm
2886 lines (2877 loc) · 342 KB
/
Lagos Amenities and Resources Dashboard documentation.htm
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<html><style>body {
color: #000000;
background-color: #FFFFFF;
font-size: 24;
font-family: Serif;
font-weight: bold;
font-style: italic;
}
h1, h2, h3, h4, h5, h6 {
color: #000000;
background-color: #FFFFFF;
font-size: 24;
font-family: Serif;
font-weight: bold;
font-style: italic;
}
table, pre {
color: #000000;
background-color: #FFFFFF;
font-size: 16;
font-family: Serif;
font-weight: normal;
font-style: normal;
}
ul, #myUL {
list-style-type: none;
}
#myUL {
margin: 0;
padding: 0;
}
.caret, .dropDownCaret {
cursor: pointer;
}
.caret::before {
content: "\25B6";
color: black;
display: inline - block;
margin - right: 6px;
}
.dropDownCaret::before {
content: "\25BC";
color: black;
display: inline - block;
margin - right: 6px;
float: right;
}
.nested {
display: none;
}
.active {
display: block;
}
</style><body><br></br><h1><div>Power BI Documentation</div></h1><br></br><hr></hr><h2><div>Generated by <a href="http://radacad.com/power-bi-helper">Power BI Helper</a> (Copyright © <a href="http://radacad.com">RADACAD</a>).</div><br></br><div>Date: 4/24/2023 4:13:37 AM</div><br></br></h2><h1><div>------------------****** Visualization ******---------------------</div></h1><br></br><h2><div>File: Lagos Amenities and Resources Dashboard.pbix</div></h2><br></br><h3><div>Path: D:\PP\Dataproanalytic\Learning Content\My Past Power BI Training Project\Lagos Amenities and Resources Dashboard.pbix</div></h2><br></br><hr></hr><br></br><h3><div>List of Pages:</div></h3><br></br><table border='1px' cellpadding='1'><tr ><td >DisplayName</td><td >Name</td><td >Ordinal</td><td >DisplayOption</td><td >Width</td><td >Height</td><td >PageIndex</td></tr><tr ><td >Homepage</td><td >ReportSection128b99d085685cbd7e96</td><td >0</td><td >1</td><td >1280</td><td >720</td><td >0</td></tr><tr ><td >Lagos Population</td><td >ReportSection</td><td >1</td><td >1</td><td >1280</td><td >720</td><td >1</td></tr><tr ><td >Agriculture</td><td >ReportSection725bc232f842f4cf7a34</td><td >2</td><td >1</td><td >1280</td><td >720</td><td >2</td></tr><tr ><td >Commerce</td><td >ReportSectionc179ed56dced2d0b44f9</td><td >3</td><td >1</td><td >1280</td><td >720</td><td >3</td></tr><tr ><td >Com Tool Tip 1</td><td >ReportSection50d4b79e67f50e28ff1e</td><td >4</td><td >3</td><td >650</td><td >350</td><td >4</td></tr><tr ><td >School</td><td >ReportSection7626f70fe70048b64974</td><td >5</td><td >1</td><td >1280</td><td >720</td><td >5</td></tr><tr ><td >Safety</td><td >ReportSection5739525ebe18b3f2c792</td><td >6</td><td >1</td><td >1280</td><td >720</td><td >6</td></tr><tr ><td >Safety Tooltip 1</td><td >ReportSection6a41570f3bebabc02ca5</td><td >7</td><td >3</td><td >650</td><td >350</td><td >7</td></tr><tr ><td >Health</td><td >ReportSectioneaeeff9d1cc221ce8be4</td><td >8</td><td >1</td><td >1280</td><td >720</td><td >8</td></tr><tr ><td >Health Tooltip 1</td><td >ReportSectionb114a408a7f8b9943e13</td><td >9</td><td >3</td><td >650</td><td >350</td><td >9</td></tr><tr ><td >About the data</td><td >ReportSectionee41bb02261f7e19b7ff</td><td >10</td><td >1</td><td >1280</td><td >720</td><td >10</td></tr></table><hr></hr><br></br><h3><div>Visuals in Homepage:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >actionButton</td><td ></td><td >102.732047017005</td><td >174.874371859296</td><td >1000</td><td >291.859296482412</td><td >54.2713567839196</td><td >13d1c8447007eeb2a9bd</td><td ></td><td >0</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >840.155419274212</td><td >547.537688442211</td><td >2000</td><td >309.949748743719</td><td >53.0653266331658</td><td >634cf6928cb7dc3c3a7d</td><td >1000</td><td >1</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >93.5689705791807</td><td >524.850213980029</td><td >3000</td><td >310.18544935806</td><td >54.4365192582026</td><td >063ee013f189e86bc155</td><td >2000</td><td >2</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >849.803660480242</td><td >155.577889447236</td><td >4000</td><td >290.653266331658</td><td >54.2713567839196</td><td >ec427065b6b9920d9139</td><td >3000</td><td >3</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >820.130293646072</td><td >349.246015715447</td><td >5000</td><td >350</td><td >61</td><td >b6a5c72cab35900102c7</td><td >4000</td><td >4</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >73.5404399087099</td><td >333.808844507846</td><td >6000</td><td >350.242510699001</td><td >61.6262482168331</td><td >017aee79258e42690ffa</td><td >5000</td><td >5</td><td >0</td></tr><tr ><td >textbox</td><td ></td><td >21.7085427135678</td><td >9.64824120603015</td><td >7000</td><td >1212.06030150754</td><td >78.391959798995</td><td >99e2013133099fdcb48c</td><td >6000</td><td >6</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >1105.16405135521</td><td >679.942938659059</td><td >8000</td><td >148.930099857347</td><td >40.0570613409415</td><td >2c539eb9c55bec7344bd</td><td >7000</td><td >7</td><td >0</td></tr><tr ><td >actionButton</td><td >'Population Distribution'</td><td >858.245871535519</td><td >157.989949748744</td><td >9000</td><td >273.768844221106</td><td >47.035175879397</td><td >246c481ea21301a31b6c</td><td >8000</td><td >8</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >149.646415122387</td><td >179.694397283531</td><td >10000</td><td >198.030560271647</td><td >42.7843803056027</td><td >c5381f1560ccd131ada0</td><td >9000</td><td >9</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >884.020100502512</td><td >354.572864321608</td><td >11000</td><td >223.115577889447</td><td >53.0653266331658</td><td >12b1255a9ad09abbe366</td><td >10000</td><td >10</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >136.811101030706</td><td >339.830220713073</td><td >12000</td><td >223.701188455008</td><td >55.0084889643463</td><td >8d5edd53a678114d6b9a</td><td >11000</td><td >11</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >136.811101030706</td><td >524.414261460102</td><td >13000</td><td >223.701188455008</td><td >53.786078098472</td><td >d13fc4120698a3019da8</td><td >12000</td><td >12</td><td >0</td></tr><tr ><td >actionButton</td><td ></td><td >882.969489625971</td><td >542.713567839196</td><td >14000</td><td >224.321608040201</td><td >62.713567839196</td><td >93a8bc930905d4996150</td><td >13000</td><td >13</td><td >0</td></tr><tr ><td >lottieCE54BF3CBD11486EAE5DEA48995B34A4</td><td ></td><td >305.125628140704</td><td >45.8291457286432</td><td >0</td><td >631.959798994975</td><td >559.597989949749</td><td >374f3c89014d3cb3c7ca</td><td ></td><td >14</td><td >0</td></tr></table><br></br><h3><div>Visuals in Lagos Population:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >card</td><td ></td><td >132.593800978793</td><td >103.360522022839</td><td >6000</td><td >183.752039151713</td><td >99.184339314845</td><td >19b3de2e10e172d0764d</td><td ></td><td >0</td><td >1</td></tr><tr ><td >card</td><td ></td><td >341.056051990252</td><td >102.940698619009</td><td >7000</td><td >197.562956945573</td><td >99.821283509342</td><td >af42e4a478cae40b7e79</td><td >1000</td><td >1</td><td >1</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >16.7047308319739</td><td >8000</td><td >577.357259380098</td><td >52.2022838499184</td><td >1c1e2d9d051cec3d45fb</td><td >2000</td><td >2</td><td >1</td></tr><tr ><td >PBI_CV_73744D90_4DC9_4F18_8BA5_EE8FA5C98035</td><td ></td><td >132.593800978793</td><td >243.26264274062</td><td >9000</td><td >183.752039151713</td><td >163.915171288744</td><td >5d0cf95c227e63c35b4a</td><td >3000</td><td >3</td><td >1</td></tr><tr ><td ></td><td ></td><td >12.3252496433666</td><td >95.5206847360913</td><td >32009</td><td >86.2767475035663</td><td >624.479315263909</td><td >7e260c2b7890e4c49618</td><td >32000</td><td >4</td><td >1</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >0</td><td >85.2496433666191</td><td >624.479315263909</td><td >26036eb631c2bc1be17a</td><td ></td><td >5</td><td >1</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >111.954350927247</td><td >1000</td><td >67.7888730385164</td><td >71.8972895863053</td><td >99615e42ff9a2aac8b86</td><td >1000</td><td >6</td><td >1</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >196.176890156919</td><td >2000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >7823eb3e68170ed9b04a</td><td >2000</td><td >7</td><td >1</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >282.453637660485</td><td >3000</td><td >76.0057061340942</td><td >64.7075606276748</td><td >3d5da083b195489ee623</td><td >3000</td><td >8</td><td >1</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >364.621968616262</td><td >4000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >b4bbc4625a60ee6fcc5d</td><td >4000</td><td >9</td><td >1</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >446.79029957204</td><td >5000</td><td >67.7888730385164</td><td >63.6804564907275</td><td >84cc8861ab8fb6e45d44</td><td >5000</td><td >10</td><td >1</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >533.067047075606</td><td >6000</td><td >76.0057061340942</td><td >62.6533523537803</td><td >0990765c52abdbaeb8ba</td><td >6000</td><td >11</td><td >1</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >18.4878744650499</td><td >7000</td><td >67.7888730385164</td><td >64.7075606276748</td><td >f03bb9e51b3cff13e89c</td><td >7000</td><td >12</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >18.4878744650499</td><td >8000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >f97a265b84d0ba5b1491</td><td >8000</td><td >13</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >111.954350927247</td><td >9000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >4b5461a362761d065f1d</td><td >9000</td><td >14</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >198.231098430813</td><td >10000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >0cb5f058a61e496af41b</td><td >10000</td><td >15</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >283.480741797432</td><td >11000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >dc1d276c35f703d1ff7e</td><td >11000</td><td >16</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >366.676176890157</td><td >12000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >ee2094bf78af0a6d865f</td><td >12000</td><td >17</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >446.79029957204</td><td >13000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >51aebf30c0cff445a594</td><td >13000</td><td >18</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >1.02710413694722</td><td >533.067047075606</td><td >14000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >6e21b325a40599b661ac</td><td >14000</td><td >19</td><td >1</td></tr><tr ><td >PBI_CV_73744D90_4DC9_4F18_8BA5_EE8FA5C98035</td><td ></td><td >341.402936378467</td><td >243.26264274062</td><td >11000</td><td >188.972267536705</td><td >163.915171288744</td><td >1025d57d5529730065d9</td><td >5000</td><td >20</td><td >1</td></tr><tr ><td >card</td><td ></td><td >561.494719740049</td><td >103.980503655565</td><td >12000</td><td >218.359057676686</td><td >98.7814784727864</td><td >c4eb85c9f86d4a1eab49</td><td >6000</td><td >21</td><td >1</td></tr><tr ><td >card</td><td ></td><td >806.888708367181</td><td >105.02030869212</td><td >13000</td><td >215.239642567019</td><td >97.7416734362307</td><td >261aa9f19757596a5e1d</td><td >7000</td><td >22</td><td >1</td></tr><tr ><td >card</td><td >'Lagos State Population Distribution by Ward'</td><td >1047.17781402936</td><td >105.448613376835</td><td >14000</td><td >206.721044045677</td><td >97.0962479608483</td><td >217a7c5c1b6b38bd7553</td><td >8000</td><td >23</td><td >1</td></tr><tr ><td >TornadoChart1452517688218</td><td ></td><td >132.593800978793</td><td >440.587275693312</td><td >15000</td><td >397.781402936378</td><td >269.363784665579</td><td >46c400c2089fb32de946</td><td >9000</td><td >24</td><td >1</td></tr><tr ><td >shapeMap</td><td >'Lagos State Population distribution by ward'</td><td >577.357259380098</td><td >303.817292006525</td><td >16000</td><td >668.189233278956</td><td >396.73735725938</td><td >9e790b42ceac56037a0d</td><td >10000</td><td >25</td><td >1</td></tr><tr ><td >slicer</td><td ></td><td >601.416267942584</td><td >8.57416267942584</td><td >17000</td><td >202.105263157895</td><td >62.4688995215311</td><td >1695f8de790adbeb7062</td><td >11000</td><td >26</td><td >1</td></tr><tr ><td >slicer</td><td ></td><td >821.894736842105</td><td >7.34928229665072</td><td >18000</td><td >207.004784688995</td><td >64.9186602870813</td><td >cbd0a4a9920518b3430e</td><td >12000</td><td >27</td><td >1</td></tr><tr ><td >slicer</td><td ></td><td >1047.27272727273</td><td >7.34928229665072</td><td >19000</td><td >202.105263157895</td><td >64.9186602870813</td><td >ed2533d29c093374f071</td><td >13000</td><td >28</td><td >1</td></tr><tr ><td >tableEx</td><td ></td><td >576.3132137031</td><td >301.729200652529</td><td >20000</td><td >282.936378466558</td><td >408.221859706362</td><td >b06edba2bd0b349c8cd2</td><td >14000</td><td >29</td><td >1</td></tr><tr ><td >pivotTable</td><td ></td><td >880</td><td >301.538461538462</td><td >21000</td><td >365.538461538462</td><td >408.615384615385</td><td >94c162ce945658f8f416</td><td >15000</td><td >30</td><td >1</td></tr><tr ><td >actionButton</td><td >'Map Offf'</td><td >574.225122349103</td><td >235.954323001631</td><td >22000</td><td >348.711256117455</td><td >63.6867862969005</td><td >d7e08a3fdc042c15ebb7</td><td >16000</td><td >31</td><td >1</td></tr><tr ><td >actionButton</td><td >'Table Off'</td><td >915.628058727569</td><td >233.866231647635</td><td >23000</td><td >337.226753670473</td><td >64.7308319738989</td><td >1a071bf32c62703b9c4d</td><td >17000</td><td >32</td><td >1</td></tr><tr ><td >actionButton</td><td >'Map On'</td><td >576.3132137031</td><td >233.866231647635</td><td >24000</td><td >337.226753670473</td><td >63.6867862969005</td><td >4e092d4a699f72b8ea32</td><td >18000</td><td >33</td><td >1</td></tr><tr ><td >actionButton</td><td >'Table On'</td><td >922.936378466558</td><td >236.99836867863</td><td >25000</td><td >330.962479608483</td><td >63.6867862969005</td><td >0fdd4a2d4d6896655c3d</td><td >19000</td><td >34</td><td >1</td></tr><tr ><td >actionButton</td><td ></td><td >564.614134849716</td><td >288.025995125914</td><td >5000</td><td >697.709179528838</td><td >422.160844841592</td><td >acc2ec025601c566cc25</td><td >20000</td><td >35</td><td >1</td></tr><tr ><td >textbox</td><td ></td><td >116.933115823817</td><td >95.0081566068516</td><td >4000</td><td >1145.31810766721</td><td >119.021207177814</td><td >e3d36b36266a8df6027d</td><td >21000</td><td >36</td><td >1</td></tr><tr ><td >textbox</td><td ></td><td >564.828711256117</td><td >227.601957585644</td><td >3000</td><td >697.42251223491</td><td >491.745513866232</td><td >5de936fd295cb5f98734</td><td >22000</td><td >37</td><td >1</td></tr><tr ><td >textbox</td><td ></td><td >116.933115823817</td><td >227.601957585644</td><td >2000</td><td >431.190864600326</td><td >194.192495921697</td><td >e1c0d374a1e72343eb55</td><td >23000</td><td >38</td><td >1</td></tr><tr ><td >textbox</td><td ></td><td >117.977161500816</td><td >430.146818923328</td><td >1000</td><td >430.146818923328</td><td >289.200652528548</td><td >88045b4545ac5a80d009</td><td >24000</td><td >39</td><td >1</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >0</td><td >1262.85167464115</td><td >79.6172248803828</td><td >53a0446d4ec57e11bc91</td><td >25000</td><td >40</td><td >1</td></tr></table><br></br><h3><div>Visuals in Agriculture:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >card</td><td ></td><td >128.612440191388</td><td >107.789473684211</td><td >5000</td><td >203.33014354067</td><td >93.0909090909091</td><td >19b3de2e10e172d0764d</td><td ></td><td >0</td><td >2</td></tr><tr ><td >card</td><td ></td><td >349.090909090909</td><td >106.564593301435</td><td >6000</td><td >207.004784688995</td><td >93.0909090909091</td><td >af42e4a478cae40b7e79</td><td >1000</td><td >1</td><td >2</td></tr><tr ><td >textbox</td><td ></td><td >116.062767475036</td><td >16.4336661911555</td><td >7000</td><td >358.459343794579</td><td >53.4094151212554</td><td >1c1e2d9d051cec3d45fb</td><td >2000</td><td >2</td><td >2</td></tr><tr ><td >card</td><td ></td><td >579.368421052632</td><td >107.789473684211</td><td >8000</td><td >213.129186602871</td><td >93.0909090909091</td><td >c4eb85c9f86d4a1eab49</td><td >4000</td><td >3</td><td >2</td></tr><tr ><td >card</td><td ></td><td >816.995215311005</td><td >107.789473684211</td><td >9000</td><td >207.004784688995</td><td >95.5406698564593</td><td >261aa9f19757596a5e1d</td><td >5000</td><td >4</td><td >2</td></tr><tr ><td >card</td><td ></td><td >1043.5980861244</td><td >107.789473684211</td><td >10000</td><td >204.555023923445</td><td >93.0909090909091</td><td >217a7c5c1b6b38bd7553</td><td >6000</td><td >5</td><td >2</td></tr><tr ><td >shapeMap</td><td >'Rate of Farmlands by Population (00,000) by Ward'</td><td >595.291866028708</td><td >302.545454545455</td><td >11000</td><td >646.736842105263</td><td >407.885167464115</td><td >9e790b42ceac56037a0d</td><td >7000</td><td >6</td><td >2</td></tr><tr ><td >slicer</td><td ></td><td >633.73572593801</td><td >8.35236541598695</td><td >12000</td><td >193.148450244698</td><td >61.5986949429038</td><td >1695f8de790adbeb7062</td><td >8000</td><td >7</td><td >2</td></tr><tr ><td >slicer</td><td ></td><td >846.721044045677</td><td >7.30831973898858</td><td >13000</td><td >177.487765089723</td><td >65.7748776508972</td><td >cbd0a4a9920518b3430e</td><td >9000</td><td >8</td><td >2</td></tr><tr ><td >slicer</td><td ></td><td >1044.04567699837</td><td >5.22022838499184</td><td >14000</td><td >203.588907014682</td><td >65.7748776508972</td><td >ed2533d29c093374f071</td><td >10000</td><td >9</td><td >2</td></tr><tr ><td >donutChart</td><td ></td><td >128.612440191388</td><td >241.301435406699</td><td >15000</td><td >410.334928229665</td><td >193.531100478469</td><td >90c14bd48b55d2ac585d</td><td >11000</td><td >10</td><td >2</td></tr><tr ><td >clusteredColumnChart</td><td ></td><td >128.612440191388</td><td >483.827751196172</td><td >16000</td><td >410.334928229665</td><td >226.602870813397</td><td >59e77ed513e56bfa212b</td><td >12000</td><td >11</td><td >2</td></tr><tr ><td >tableEx</td><td ></td><td >590.392344497608</td><td >295.196172248804</td><td >17000</td><td >657.760765550239</td><td >415.234449760766</td><td >6765256e7b525d0f8fea</td><td >13000</td><td >12</td><td >2</td></tr><tr ><td >actionButton</td><td >'Map on'</td><td >576.918660287081</td><td >233.952153110048</td><td >19000</td><td >336.842105263158</td><td >58.7942583732057</td><td >e6f6b3d347b27d074595</td><td >14000</td><td >13</td><td >2</td></tr><tr ><td >actionButton</td><td >'Table on'</td><td >934.583732057416</td><td >233.952153110048</td><td >18000</td><td >317.244019138756</td><td >68.5933014354067</td><td >1d3219ff6b8b2ffd69e6</td><td >15000</td><td >14</td><td >2</td></tr><tr ><td >actionButton</td><td >'Map off'</td><td >590.392344497608</td><td >237.626794258373</td><td >20000</td><td >330.717703349282</td><td >61.244019138756</td><td >9d65d97dd1f6fd967756</td><td >16000</td><td >15</td><td >2</td></tr><tr ><td >actionButton</td><td >'Table off'</td><td >926.00956937799</td><td >232.727272727273</td><td >21000</td><td >336.842105263158</td><td >60.0191387559809</td><td >0cb69176ce513b13b5bb</td><td >17000</td><td >16</td><td >2</td></tr><tr ><td >textbox</td><td ></td><td >116.363636363636</td><td >470.354066985646</td><td >3000</td><td >439.732057416268</td><td >248.650717703349</td><td >5e083d93721f1bf32c6e</td><td >18000</td><td >17</td><td >2</td></tr><tr ><td >textbox</td><td ></td><td >579.368421052632</td><td >230.277511961722</td><td >2000</td><td >683.483253588517</td><td >488.727272727273</td><td >f1f19e1e926296c537f4</td><td >19000</td><td >18</td><td >2</td></tr><tr ><td >textbox</td><td ></td><td >116.363636363636</td><td >227.827751196172</td><td >4000</td><td >438.507177033493</td><td >220.478468899522</td><td >103cc7d46ce095f190cd</td><td >20000</td><td >19</td><td >2</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >1000</td><td >1262.85167464115</td><td >79.6172248803828</td><td >1730d08e6fad7d16a9cf</td><td >21000</td><td >20</td><td >2</td></tr><tr ><td >textbox</td><td ></td><td >116.363636363636</td><td >95.5406698564593</td><td >0</td><td >1146.48803827751</td><td >117.588516746411</td><td >57c402621527717019a6</td><td >22000</td><td >21</td><td >2</td></tr><tr ><td ></td><td ></td><td >12.3252496433666</td><td >95.5206847360913</td><td >23000</td><td >86.2767475035663</td><td >624.479315263909</td><td >fbbe73daeb8b174e8fc3</td><td >32000</td><td >22</td><td >2</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >0</td><td >85.2496433666191</td><td >624.479315263909</td><td >36dde2c104b16cc415ae</td><td ></td><td >23</td><td >2</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >111.954350927247</td><td >1000</td><td >67.7888730385164</td><td >71.8972895863053</td><td >fc45dc89a6482e64b79d</td><td >1000</td><td >24</td><td >2</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >196.176890156919</td><td >2000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >b5183eccda28bed2fa45</td><td >2000</td><td >25</td><td >2</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >282.453637660485</td><td >3000</td><td >76.0057061340942</td><td >64.7075606276748</td><td >645c4dfae08b5d0f724c</td><td >3000</td><td >26</td><td >2</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >364.621968616262</td><td >4000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >e017aba59f0ffd6d42e9</td><td >4000</td><td >27</td><td >2</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >446.79029957204</td><td >5000</td><td >67.7888730385164</td><td >63.6804564907275</td><td >1a2a9d739877cd2dbdb9</td><td >5000</td><td >28</td><td >2</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >533.067047075606</td><td >6000</td><td >76.0057061340942</td><td >62.6533523537803</td><td >d10afad9f5d9c585e6d0</td><td >6000</td><td >29</td><td >2</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >18.4878744650499</td><td >7000</td><td >67.7888730385164</td><td >64.7075606276748</td><td >020ffcf5db01702dbe5d</td><td >7000</td><td >30</td><td >2</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >18.4878744650499</td><td >8000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >ca8e4168f615d41f2d44</td><td >8000</td><td >31</td><td >2</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >111.954350927247</td><td >9000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >419eed349ce3f04877af</td><td >9000</td><td >32</td><td >2</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >198.231098430813</td><td >10000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >6c7437c87891691777ed</td><td >10000</td><td >33</td><td >2</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >283.480741797432</td><td >11000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >1f9312c8e45e6ab50eaa</td><td >11000</td><td >34</td><td >2</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >366.676176890157</td><td >12000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >94a96ae4fbec544f0c66</td><td >12000</td><td >35</td><td >2</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >446.79029957204</td><td >13000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >9220416a435b5dab96b5</td><td >13000</td><td >36</td><td >2</td></tr><tr ><td >actionButton</td><td ></td><td >1.02710413694722</td><td >533.067047075606</td><td >14000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >53739efcbc485c07e2d1</td><td >14000</td><td >37</td><td >2</td></tr></table><br></br><h3><div>Visuals in Commerce:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >card</td><td ></td><td >120.038277511962</td><td >102.88995215311</td><td >6000</td><td >189.856459330144</td><td >73.4928229665072</td><td >19b3de2e10e172d0764d</td><td ></td><td >0</td><td >3</td></tr><tr ><td >card</td><td ></td><td >322.143540669856</td><td >102.88995215311</td><td >7000</td><td >177.607655502392</td><td >73.4928229665072</td><td >af42e4a478cae40b7e79</td><td >1000</td><td >1</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >18.7928221859706</td><td >8000</td><td >554.388254486134</td><td >48.026101141925</td><td >1c1e2d9d051cec3d45fb</td><td >2000</td><td >2</td><td >3</td></tr><tr ><td >card</td><td ></td><td >514.703493095045</td><td >103.980503655565</td><td >9000</td><td >181.965881397238</td><td >72.7863525588952</td><td >c4eb85c9f86d4a1eab49</td><td >3000</td><td >3</td><td >3</td></tr><tr ><td >card</td><td ></td><td >712.266450040617</td><td >105.02030869212</td><td >10000</td><td >177.806661251015</td><td >71.7465475223396</td><td >261aa9f19757596a5e1d</td><td >4000</td><td >4</td><td >3</td></tr><tr ><td >card</td><td ></td><td >1094.15986949429</td><td >104.404567699837</td><td >11000</td><td >164.959216965742</td><td >73.0831973898858</td><td >217a7c5c1b6b38bd7553</td><td >5000</td><td >5</td><td >3</td></tr><tr ><td >shapeMap</td><td ></td><td >120.038277511962</td><td >475.253588516746</td><td >12000</td><td >759.425837320574</td><td >229.052631578947</td><td >9e790b42ceac56037a0d</td><td >6000</td><td >6</td><td >3</td></tr><tr ><td >slicer</td><td ></td><td >603.866028708134</td><td >4.89952153110048</td><td >13000</td><td >278.047846889952</td><td >62.4688995215311</td><td >1695f8de790adbeb7062</td><td >7000</td><td >7</td><td >3</td></tr><tr ><td >slicer</td><td ></td><td >907.636363636364</td><td >3.67464114832536</td><td >14000</td><td >260.899521531101</td><td >62.4688995215311</td><td >cbd0a4a9920518b3430e</td><td >8000</td><td >8</td><td >3</td></tr><tr ><td >card</td><td ></td><td >907.749796913079</td><td >105.02030869212</td><td >15000</td><td >172.607636068237</td><td >71.7465475223396</td><td >58a48ffde55a1bf0553d</td><td >9000</td><td >9</td><td >3</td></tr><tr ><td >payPalKPIDonutChart55A431AB15A540ED924ACD72ED8D259F</td><td ></td><td >120.065252854812</td><td >254.747145187602</td><td >16000</td><td >129.461663947798</td><td >132.593800978793</td><td >e053bf9e78564aa58d3f</td><td >10000</td><td >10</td><td >3</td></tr><tr ><td >payPalKPIDonutChart55A431AB15A540ED924ACD72ED8D259F</td><td ></td><td >251.1004784689</td><td >254.775119617225</td><td >17000</td><td >150.66028708134</td><td >134.736842105263</td><td >c5228459a3c71b610dd8</td><td >11000</td><td >11</td><td >3</td></tr><tr ><td >payPalKPIDonutChart55A431AB15A540ED924ACD72ED8D259F</td><td ></td><td >401.364744110479</td><td >252.672623883022</td><td >18000</td><td >153.891145410236</td><td >134.134849715678</td><td >34f47e5720e80d53b38b</td><td >12000</td><td >12</td><td >3</td></tr><tr ><td >tableEx</td><td ></td><td >918.66028708134</td><td >280.497607655502</td><td >19000</td><td >330.717703349282</td><td >423.808612440191</td><td >b6cf43db27a3ae2ff919</td><td >13000</td><td >13</td><td >3</td></tr><tr ><td >payPalKPIDonutChart55A431AB15A540ED924ACD72ED8D259F</td><td ></td><td >580.593301435407</td><td >253.55023923445</td><td >20000</td><td >145.760765550239</td><td >131.062200956938</td><td >0abbe8ea078d044f0c3d</td><td >14000</td><td >14</td><td >3</td></tr><tr ><td >payPalKPIDonutChart55A431AB15A540ED924ACD72ED8D259F</td><td ></td><td >727.578947368421</td><td >252.325358851675</td><td >21000</td><td >151.885167464115</td><td >132.287081339713</td><td >a8992e97d43669eaa7d2</td><td >15000</td><td >15</td><td >3</td></tr><tr ><td >slicer</td><td ></td><td >111.259138911454</td><td >398.245329000812</td><td >22000</td><td >778.813972380179</td><td >55.1096669374492</td><td >52a214819553d8b2feea</td><td >16000</td><td >16</td><td >3</td></tr><tr ><td >clusteredBarChart</td><td ></td><td >919.804241435563</td><td >283.980424143556</td><td >23000</td><td >328.874388254486</td><td >419.706362153344</td><td >2512d2565ce1eb2420e9</td><td >17000</td><td >17</td><td >3</td></tr><tr ><td >actionButton</td><td >'Bar chart off'</td><td >907.636363636364</td><td >207.004784688995</td><td >24000</td><td >173.933014354067</td><td >66.1435406698565</td><td >42f90cd23e7f3123ced3</td><td >18000</td><td >18</td><td >3</td></tr><tr ><td >actionButton</td><td >'Table off'</td><td >1090.14354066986</td><td >205.77990430622</td><td >25000</td><td >172.708133971292</td><td >63.6937799043062</td><td >1fe43884dd7efea81b14</td><td >19000</td><td >19</td><td >3</td></tr><tr ><td >actionButton</td><td >'Table on'</td><td >1085.24401913876</td><td >208.22966507177</td><td >26000</td><td >172.708133971292</td><td >67.3684210526316</td><td >d864aa42197f75a2e405</td><td >20000</td><td >20</td><td >3</td></tr><tr ><td >actionButton</td><td >'Bar chart on'</td><td >908.861244019139</td><td >205.77990430622</td><td >27000</td><td >173.933014354067</td><td >67.3684210526316</td><td >36fa223653d58845f411</td><td >21000</td><td >21</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >116.363636363636</td><td >227.827751196172</td><td >28000</td><td >121.263157894737</td><td >39.1961722488038</td><td >374ae245a42dcfa309f8</td><td >22000</td><td >22</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >259.951259138911</td><td >232.916328188465</td><td >29000</td><td >121.657189277011</td><td >38.4727863525589</td><td >74324e33ca76a2f2b6a3</td><td >23000</td><td >23</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >416.459330143541</td><td >231.502392344498</td><td >30000</td><td >122.488038277512</td><td >37.9712918660287</td><td >20ce2a47a2729e78ba78</td><td >24000</td><td >24</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >575.012185215272</td><td >233.95613322502</td><td >31000</td><td >169.48822095857</td><td >38.4727863525589</td><td >24dccde351ae6fdaab14</td><td >25000</td><td >25</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >725.783915515841</td><td >234.995938261576</td><td >32000</td><td >181.965881397238</td><td >38.4727863525589</td><td >fd5b6ac950e1eab30774</td><td >26000</td><td >26</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >277.716150081566</td><td >270.407830342577</td><td >33000</td><td >276.672104404568</td><td >116.933115823817</td><td >4a3ce5a8cee04ff61baa</td><td >27000</td><td >27</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >564.66985645933</td><td >235.177033492823</td><td >34000</td><td >325.818181818182</td><td >82.066985645933</td><td >a6f60662e129438e7920</td><td >28000</td><td >28</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >116.458164094232</td><td >198.602761982128</td><td >35000</td><td >281.78716490658</td><td >30.1543460601137</td><td >175efdb0a8533a35888f</td><td >29000</td><td >29</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >580.593301435407</td><td >197.205741626794</td><td >36000</td><td >85.7416267942584</td><td >30.622009569378</td><td >541bc916a1b4d23d37d1</td><td >30000</td><td >30</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >744.500406173842</td><td >198.602761982128</td><td >37000</td><td >145.57270511779</td><td >30.1543460601137</td><td >2960b059e6cd6f016f1c</td><td >31000</td><td >31</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >111.464114832536</td><td >464.22966507177</td><td >2000</td><td >777.799043062201</td><td >254.775119617225</td><td >7fb723e1e506b571d92a</td><td >33000</td><td >32</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >907.636363636364</td><td >198.430622009569</td><td >4000</td><td >355.215311004785</td><td >520.574162679426</td><td >a2c6e0489e41f2d3b095</td><td >34000</td><td >33</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >111.464114832536</td><td >198.430622009569</td><td >3000</td><td >453.205741626794</td><td >191.081339712919</td><td >56212049c15aa78af093</td><td >35000</td><td >34</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >5000</td><td >1262.85167464115</td><td >79.6172248803828</td><td >6d974c04e03d14d3aba8</td><td >36000</td><td >35</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >111.464114832536</td><td >95.5406698564593</td><td >0</td><td >1150.16267942584</td><td >90.6411483253589</td><td >99f058f07b3df625c0a9</td><td >37000</td><td >36</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >574.468899521531</td><td >198.430622009569</td><td >1000</td><td >316.019138755981</td><td >191.081339712919</td><td >cd497a139372112dcb46</td><td >38000</td><td >37</td><td >3</td></tr><tr ><td ></td><td ></td><td >12.3252496433666</td><td >95.5206847360913</td><td >39000</td><td >86.2767475035663</td><td >624.479315263909</td><td >ae405b5439ffe4aa63c5</td><td >32000</td><td >38</td><td >3</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >0</td><td >85.2496433666191</td><td >624.479315263909</td><td >2d4f20aac1760e11680d</td><td ></td><td >39</td><td >3</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >111.954350927247</td><td >1000</td><td >67.7888730385164</td><td >71.8972895863053</td><td >1c3820790212cd128bc4</td><td >1000</td><td >40</td><td >3</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >196.176890156919</td><td >2000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >f53369aebf8c8e5ab056</td><td >2000</td><td >41</td><td >3</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >282.453637660485</td><td >3000</td><td >76.0057061340942</td><td >64.7075606276748</td><td >52d54960b41072cd5a7a</td><td >3000</td><td >42</td><td >3</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >364.621968616262</td><td >4000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >70f3d2372bdd817d94f7</td><td >4000</td><td >43</td><td >3</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >446.79029957204</td><td >5000</td><td >67.7888730385164</td><td >63.6804564907275</td><td >f7b1015d20d62f65c039</td><td >5000</td><td >44</td><td >3</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >533.067047075606</td><td >6000</td><td >76.0057061340942</td><td >62.6533523537803</td><td >9f61633c5028b237901e</td><td >6000</td><td >45</td><td >3</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >18.4878744650499</td><td >7000</td><td >67.7888730385164</td><td >64.7075606276748</td><td >367cf9c9c4c2dab54fc4</td><td >7000</td><td >46</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >18.4878744650499</td><td >8000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >d607510e14f58708a8c8</td><td >8000</td><td >47</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >111.954350927247</td><td >9000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >b52174b7bcdae82d03c0</td><td >9000</td><td >48</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >198.231098430813</td><td >10000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >28cd47c8aefb6f61bc04</td><td >10000</td><td >49</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >283.480741797432</td><td >11000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >599788eefd716c3aa2ad</td><td >11000</td><td >50</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >366.676176890157</td><td >12000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >03d415b8f8226d6830e4</td><td >12000</td><td >51</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >446.79029957204</td><td >13000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >3ad3f06a2cacfe52a37e</td><td >13000</td><td >52</td><td >3</td></tr><tr ><td >actionButton</td><td ></td><td >1.02710413694722</td><td >533.067047075606</td><td >14000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >c93857596fc05fb796dc</td><td >14000</td><td >53</td><td >3</td></tr></table><br></br><h3><div>Visuals in Com Tool Tip 1:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >clusteredColumnChart</td><td ></td><td >0</td><td >0</td><td >0</td><td >650</td><td >350</td><td >b009d370afee99b3015d</td><td ></td><td >0</td><td >4</td></tr></table><br></br><h3><div>Visuals in School:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >card</td><td ></td><td >119.021207177814</td><td >103.360522022839</td><td >6000</td><td >161.827079934747</td><td >107.536704730832</td><td >19b3de2e10e172d0764d</td><td ></td><td >0</td><td >5</td></tr><tr ><td >card</td><td ></td><td >295.464926590538</td><td >102.31647634584</td><td >7000</td><td >170.179445350734</td><td >107.536704730832</td><td >af42e4a478cae40b7e79</td><td >1000</td><td >1</td><td >5</td></tr><tr ><td >textbox</td><td ></td><td >3.13213703099511</td><td >15.6606851549755</td><td >8000</td><td >660.880913539967</td><td >53.2463295269168</td><td >1c1e2d9d051cec3d45fb</td><td >2000</td><td >2</td><td >5</td></tr><tr ><td >card</td><td ></td><td >483.393148450245</td><td >103.360522022839</td><td >9000</td><td >190.016313213703</td><td >107.536704730832</td><td >c4eb85c9f86d4a1eab49</td><td >4000</td><td >3</td><td >5</td></tr><tr ><td >card</td><td ></td><td >690.114192495922</td><td >103.360522022839</td><td >10000</td><td >178.531810766721</td><td >107.536704730832</td><td >261aa9f19757596a5e1d</td><td >5000</td><td >4</td><td >5</td></tr><tr ><td >card</td><td ></td><td >885.350734094617</td><td >103.360522022839</td><td >11000</td><td >179.575856443719</td><td >107.536704730832</td><td >217a7c5c1b6b38bd7553</td><td >6000</td><td >5</td><td >5</td></tr><tr ><td >shapeMap</td><td >'Ratio of Population by Ward'</td><td >585.709624796085</td><td >294.42088091354</td><td >22000</td><td >664.013050570962</td><td >415.530179445351</td><td >9e790b42ceac56037a0d</td><td >7000</td><td >6</td><td >5</td></tr><tr ><td >slicer</td><td ></td><td >689.070146818923</td><td >0</td><td >12000</td><td >196.280587275693</td><td >74.1272430668842</td><td >1695f8de790adbeb7062</td><td >8000</td><td >7</td><td >5</td></tr><tr ><td >slicer</td><td ></td><td >897.879282218597</td><td >0</td><td >13000</td><td >167.047308319739</td><td >74.1272430668842</td><td >cbd0a4a9920518b3430e</td><td >9000</td><td >8</td><td >5</td></tr><tr ><td >slicer</td><td ></td><td >1079.54323001631</td><td >2.08809135399674</td><td >14000</td><td >174.355628058728</td><td >73.0831973898858</td><td >ed2533d29c093374f071</td><td >10000</td><td >9</td><td >5</td></tr><tr ><td >clusteredBarChart</td><td ></td><td >116.933115823817</td><td >478.172920065253</td><td >15000</td><td >421.794453507341</td><td >231.778140293638</td><td >59e77ed513e56bfa212b</td><td >11000</td><td >10</td><td >5</td></tr><tr ><td >tableEx</td><td ></td><td >588.84176182708</td><td >294.42088091354</td><td >5000</td><td >661.924959216966</td><td >415.530179445351</td><td >6765256e7b525d0f8fea</td><td >12000</td><td >11</td><td >5</td></tr><tr ><td >actionButton</td><td >'Map on'</td><td >582.57748776509</td><td >241.174551386623</td><td >17000</td><td >336.182707993475</td><td >49.0701468189233</td><td >e6f6b3d347b27d074595</td><td >13000</td><td >12</td><td >5</td></tr><tr ><td >actionButton</td><td >'Table on'</td><td >920.848287112561</td><td >242.218597063622</td><td >16000</td><td >337.226753670473</td><td >49.0701468189233</td><td >1d3219ff6b8b2ffd69e6</td><td >14000</td><td >13</td><td >5</td></tr><tr ><td >actionButton</td><td >'Map off'</td><td >579.445350734095</td><td >241.174551386623</td><td >18000</td><td >337.226753670473</td><td >48.026101141925</td><td >9d65d97dd1f6fd967756</td><td >15000</td><td >14</td><td >5</td></tr><tr ><td >actionButton</td><td >'Table off'</td><td >921.89233278956</td><td >243.26264274062</td><td >19000</td><td >336.182707993475</td><td >48.026101141925</td><td >0cb69176ce513b13b5bb</td><td >16000</td><td >15</td><td >5</td></tr><tr ><td >card</td><td ></td><td >1079.54323001631</td><td >102.31647634584</td><td >20000</td><td >172.267536704731</td><td >107.536704730832</td><td >d14d9685662921501958</td><td >17000</td><td >16</td><td >5</td></tr><tr ><td >donutChart</td><td >'No of School by Category'</td><td >116.933115823817</td><td >249.52691680261</td><td >21000</td><td >422.838499184339</td><td >196.280587275693</td><td >dd0fe83611bd95ea7d1f</td><td >18000</td><td >17</td><td >5</td></tr><tr ><td >textbox</td><td ></td><td >107.536704730832</td><td >469.820554649266</td><td >0</td><td >442.675367047308</td><td >250.570962479608</td><td >922939c6ddb52b6b502d</td><td >19000</td><td >18</td><td >5</td></tr><tr ><td >textbox</td><td ></td><td >107.536704730832</td><td >235.954323001631</td><td >1000</td><td >442.675367047308</td><td >220.293637846656</td><td >23756cb20eae767b844a</td><td >20000</td><td >19</td><td >5</td></tr><tr ><td >textbox</td><td ></td><td >574.225122349103</td><td >235.954323001631</td><td >2000</td><td >688.026101141925</td><td >483.393148450245</td><td >252d5ce40ad8293b15c0</td><td >21000</td><td >20</td><td >5</td></tr><tr ><td >textbox</td><td ></td><td >107.536704730832</td><td >95.0081566068516</td><td >4000</td><td >1155.75856443719</td><td >123.197389885808</td><td >4a83d8a3b443eb3c5d98</td><td >22000</td><td >21</td><td >5</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >3000</td><td >1262.25122349103</td><td >80.3915171288744</td><td >5a09f897637c33090034</td><td >23000</td><td >22</td><td >5</td></tr><tr ><td ></td><td ></td><td >12.3252496433666</td><td >95.5206847360913</td><td >24000</td><td >86.2767475035663</td><td >624.479315263909</td><td >bbdd105cb7b3c8e38d20</td><td >32000</td><td >23</td><td >5</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >0</td><td >85.2496433666191</td><td >624.479315263909</td><td >c5c8832d7c6058aae2a1</td><td ></td><td >24</td><td >5</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >111.954350927247</td><td >1000</td><td >67.7888730385164</td><td >71.8972895863053</td><td >e3e37bc47e994af5ea6a</td><td >1000</td><td >25</td><td >5</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >196.176890156919</td><td >2000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >b374070bd41bc76b2f76</td><td >2000</td><td >26</td><td >5</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >282.453637660485</td><td >3000</td><td >76.0057061340942</td><td >64.7075606276748</td><td >486dcdc0f6afcb807308</td><td >3000</td><td >27</td><td >5</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >364.621968616262</td><td >4000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >16ddf0b3477be9c23f05</td><td >4000</td><td >28</td><td >5</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >446.79029957204</td><td >5000</td><td >67.7888730385164</td><td >63.6804564907275</td><td >165c4b0f4b6e1914eb94</td><td >5000</td><td >29</td><td >5</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >533.067047075606</td><td >6000</td><td >76.0057061340942</td><td >62.6533523537803</td><td >e46cfeffe6faa7fad02f</td><td >6000</td><td >30</td><td >5</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >18.4878744650499</td><td >7000</td><td >67.7888730385164</td><td >64.7075606276748</td><td >24b80cb24d358b6cf1ca</td><td >7000</td><td >31</td><td >5</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >18.4878744650499</td><td >8000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >7582147f3050bb877cd3</td><td >8000</td><td >32</td><td >5</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >111.954350927247</td><td >9000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >ee6cbf83b93447c6e401</td><td >9000</td><td >33</td><td >5</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >198.231098430813</td><td >10000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >d2cf38a518fe156c2a26</td><td >10000</td><td >34</td><td >5</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >283.480741797432</td><td >11000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >975466c2c534a750d8e0</td><td >11000</td><td >35</td><td >5</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >366.676176890157</td><td >12000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >c73cc163f374a1515307</td><td >12000</td><td >36</td><td >5</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >446.79029957204</td><td >13000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >1ab58714f33d236a11af</td><td >13000</td><td >37</td><td >5</td></tr><tr ><td >actionButton</td><td ></td><td >1.02710413694722</td><td >533.067047075606</td><td >14000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >4f13f480cdd63dec4071</td><td >14000</td><td >38</td><td >5</td></tr></table><br></br><h3><div>Visuals in Safety:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >card</td><td ></td><td >1034.64926590538</td><td >104.404567699837</td><td >6000</td><td >209.853181076672</td><td >85.6117455138662</td><td >8b08b1d3cbfca8829ccb</td><td ></td><td >0</td><td >6</td></tr><tr ><td >card</td><td ></td><td >791.386623164763</td><td >104.404567699837</td><td >7000</td><td >211.941272430669</td><td >85.6117455138662</td><td >74e3e85b49e07cdd15c2</td><td >1000</td><td >1</td><td >6</td></tr><tr ><td >card</td><td ></td><td >556.476345840131</td><td >104.404567699837</td><td >8000</td><td >205.676998368679</td><td >85.6117455138662</td><td >9c90e6ba513c584b9a3b</td><td >2000</td><td >2</td><td >6</td></tr><tr ><td >card</td><td ></td><td >330.962479608483</td><td >104.404567699837</td><td >9000</td><td >196.280587275693</td><td >85.6117455138662</td><td >a06fe9ee20f82521104a</td><td >3000</td><td >3</td><td >6</td></tr><tr ><td >card</td><td ></td><td >124.241435562806</td><td >104.404567699837</td><td >10000</td><td >182.707993474715</td><td >85.6117455138662</td><td >7d0ad727520b67e30b6f</td><td >4000</td><td >4</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >14.3794579172611</td><td >11000</td><td >617.289586305278</td><td >53.4094151212554</td><td >59e42dbfc4d056e2906d</td><td >6000</td><td >5</td><td >6</td></tr><tr ><td >donutChart</td><td ></td><td >116.933115823817</td><td >236.99836867863</td><td >12000</td><td >410.309951060359</td><td >146.166394779772</td><td >a8363e8aa5e4eb393516</td><td >8000</td><td >6</td><td >6</td></tr><tr ><td >clusteredBarChart</td><td >'No of Fire Station by LGA'</td><td >124.241435562806</td><td >422.838499184339</td><td >13000</td><td >403.00163132137</td><td >286.068515497553</td><td >c349b2d666ebf047dc59</td><td >9000</td><td >7</td><td >6</td></tr><tr ><td >shapeMap</td><td >'Total Number of Fire Station Available by Local Government'</td><td >565.872756933116</td><td >452.071778140294</td><td >14000</td><td >678.62969004894</td><td >256.835236541599</td><td >a0d168d4f2a3346b4aa5</td><td >7000</td><td >8</td><td >6</td></tr><tr ><td >columnChart</td><td ></td><td >565.872756933116</td><td >233.866231647635</td><td >15000</td><td >678.62969004894</td><td >188.972267536705</td><td >5477943c7fdeba953208</td><td >10000</td><td >9</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >556.476345840131</td><td >441.63132137031</td><td >3000</td><td >703.686786296901</td><td >277.716150081566</td><td >d18fe81c3a0458023cad</td><td >11000</td><td >10</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >111.712887438825</td><td >411.353996737357</td><td >4000</td><td >427.014681892333</td><td >307.993474714519</td><td >bda286d98f8e785df837</td><td >12000</td><td >11</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >111.712887438825</td><td >95.0081566068516</td><td >5000</td><td >1148.45024469821</td><td >106.492659053834</td><td >7e7214467fa8996f1482</td><td >13000</td><td >12</td><td >6</td></tr><tr ><td >slicer</td><td ></td><td >740.228384991843</td><td >8.35236541598695</td><td >16000</td><td >278.760195758564</td><td >62.6427406199021</td><td >bbd386c94fa7e2c3a3bb</td><td >14000</td><td >13</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >8.35236541598695</td><td >0</td><td >2000</td><td >1251.81076672104</td><td >79.347471451876</td><td >118f00e9dc29abeb2461</td><td >15000</td><td >14</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >556.476345840131</td><td >221.337683523654</td><td >1000</td><td >703.686786296901</td><td >209.853181076672</td><td >ea2250bffd241fd18e9f</td><td >17000</td><td >15</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >111.712887438825</td><td >221.337683523654</td><td >0</td><td >427.014681892333</td><td >176.443719412724</td><td >9d72ac15c4e82bb78299</td><td >18000</td><td >16</td><td >6</td></tr><tr ><td ></td><td ></td><td >12.3252496433666</td><td >95.5206847360913</td><td >18000</td><td >86.2767475035663</td><td >624.479315263909</td><td >0ed83d661f59f25357b6</td><td >32000</td><td >17</td><td >6</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >0</td><td >85.2496433666191</td><td >624.479315263909</td><td >0ac2ca15e959353f28a3</td><td ></td><td >18</td><td >6</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >111.954350927247</td><td >1000</td><td >67.7888730385164</td><td >71.8972895863053</td><td >51f425241fe5bb6f5318</td><td >1000</td><td >19</td><td >6</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >196.176890156919</td><td >2000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >650242cdefb42ef35efe</td><td >2000</td><td >20</td><td >6</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >282.453637660485</td><td >3000</td><td >76.0057061340942</td><td >64.7075606276748</td><td >15152d933b0032c1e31c</td><td >3000</td><td >21</td><td >6</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >364.621968616262</td><td >4000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >407b91916ac30318a4c5</td><td >4000</td><td >22</td><td >6</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >446.79029957204</td><td >5000</td><td >67.7888730385164</td><td >63.6804564907275</td><td >025fecfbe34ebc0a13cc</td><td >5000</td><td >23</td><td >6</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >533.067047075606</td><td >6000</td><td >76.0057061340942</td><td >62.6533523537803</td><td >d8859780457bdd7a8ff5</td><td >6000</td><td >24</td><td >6</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >18.4878744650499</td><td >7000</td><td >67.7888730385164</td><td >64.7075606276748</td><td >f287528787fae4968617</td><td >7000</td><td >25</td><td >6</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >18.4878744650499</td><td >8000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >b21c10b00efd9ec2d85a</td><td >8000</td><td >26</td><td >6</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >111.954350927247</td><td >9000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >a9f902b0618c782c3a36</td><td >9000</td><td >27</td><td >6</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >198.231098430813</td><td >10000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >bd4769860feddec4b07d</td><td >10000</td><td >28</td><td >6</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >283.480741797432</td><td >11000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >33e4c2cc07c35633c465</td><td >11000</td><td >29</td><td >6</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >366.676176890157</td><td >12000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >7b83c77f44af155fa527</td><td >12000</td><td >30</td><td >6</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >446.79029957204</td><td >13000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >071df90ccd86370d328c</td><td >13000</td><td >31</td><td >6</td></tr><tr ><td >actionButton</td><td ></td><td >1.02710413694722</td><td >533.067047075606</td><td >14000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >64b0d4cf4150a1b22241</td><td >14000</td><td >32</td><td >6</td></tr></table><br></br><h3><div>Visuals in Safety Tooltip 1:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >clusteredBarChart</td><td >'Total Fire Vehicle by Ward'</td><td >25</td><td >133</td><td >0</td><td >348</td><td >208</td><td >b009d370afee99b3015d</td><td >4000</td><td >0</td><td >7</td></tr><tr ><td >treemap</td><td >'Total Ambulance by Ward'</td><td >386</td><td >133</td><td >1000</td><td >254</td><td >199</td><td >198ee95cff3688d4adae</td><td >5000</td><td >1</td><td >7</td></tr><tr ><td >card</td><td ></td><td >25</td><td >48</td><td >2000</td><td >167</td><td >76</td><td >1199d1ebcec6dcd38e78</td><td ></td><td >2</td><td >7</td></tr><tr ><td >card</td><td ></td><td >207</td><td >48</td><td >3000</td><td >166</td><td >76</td><td >0f2b60e0af922c0d7ea7</td><td >1000</td><td >3</td><td >7</td></tr><tr ><td >card</td><td ></td><td >403</td><td >48</td><td >4000</td><td >219</td><td >76</td><td >614255838138924bb72e</td><td >2000</td><td >4</td><td >7</td></tr><tr ><td >card</td><td ></td><td >25</td><td >0</td><td >5000</td><td >589</td><td >38</td><td >95d6710830a80f661673</td><td >3000</td><td >5</td><td >7</td></tr></table><br></br><h3><div>Visuals in Health:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >card</td><td ></td><td >768.273894436519</td><td >104.764621968616</td><td >7000</td><td >155.09272467903</td><td >74.9786019971469</td><td >8b08b1d3cbfca8829ccb</td><td ></td><td >0</td><td >8</td></tr><tr ><td >card</td><td ></td><td >610.099857346648</td><td >104.764621968616</td><td >8000</td><td >152.011412268188</td><td >74.9786019971469</td><td >74e3e85b49e07cdd15c2</td><td >1000</td><td >1</td><td >8</td></tr><tr ><td >card</td><td ></td><td >443.81308411215</td><td >105.271028037383</td><td >9000</td><td >166.280373831776</td><td >74.1682242990654</td><td >9c90e6ba513c584b9a3b</td><td >2000</td><td >2</td><td >8</td></tr><tr ><td >card</td><td ></td><td >280.399429386591</td><td >104.764621968616</td><td >10000</td><td >154.065620542083</td><td >74.9786019971469</td><td >a06fe9ee20f82521104a</td><td >3000</td><td >3</td><td >8</td></tr><tr ><td >card</td><td ></td><td >119.144079885877</td><td >104.764621968616</td><td >11000</td><td >154.065620542083</td><td >74.9786019971469</td><td >7d0ad727520b67e30b6f</td><td >4000</td><td >4</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >117.089871611983</td><td >14.3794579172611</td><td >12000</td><td >534.094151212553</td><td >53.4094151212554</td><td >59e42dbfc4d056e2906d</td><td >5000</td><td >5</td><td >8</td></tr><tr ><td >donutChart</td><td ></td><td >119.144079885877</td><td >210.55634807418</td><td >13000</td><td >226.990014265335</td><td >170.499286733238</td><td >a8363e8aa5e4eb393516</td><td >7000</td><td >6</td><td >8</td></tr><tr ><td >shapeMap</td><td >'Shape Map of Laboratory Distribution'</td><td >124.279600570613</td><td >453.980028530671</td><td >26000</td><td >739.514978601997</td><td >256.776034236805</td><td >a0d168d4f2a3346b4aa5</td><td >6000</td><td >7</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >111.954350927247</td><td >442.681883024251</td><td >5000</td><td >756.9757489301</td><td >277.318116975749</td><td >d18fe81c3a0458023cad</td><td >8000</td><td >8</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >111.954350927247</td><td >96.5477888730385</td><td >6000</td><td >1148.30242510699</td><td >91.4122681883024</td><td >7e7214467fa8996f1482</td><td >9000</td><td >9</td><td >8</td></tr><tr ><td >slicer</td><td ></td><td >687.132667617689</td><td >0</td><td >14000</td><td >181.797432239658</td><td >62.6533523537803</td><td >bbd386c94fa7e2c3a3bb</td><td >10000</td><td >10</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >4000</td><td >1260.25677603424</td><td >79.0870185449358</td><td >118f00e9dc29abeb2461</td><td >11000</td><td >11</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >111.954350927247</td><td >201.312410841655</td><td >3000</td><td >241.369472182596</td><td >187.960057061341</td><td >9d72ac15c4e82bb78299</td><td >13000</td><td >12</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >366.676176890157</td><td >201.312410841655</td><td >16000</td><td >243.423680456491</td><td >187.960057061341</td><td >3c592ce6550eca85bed6</td><td >14000</td><td >13</td><td >8</td></tr><tr ><td >donutChart</td><td ></td><td >375.920114122682</td><td >210.55634807418</td><td >17000</td><td >226.990014265335</td><td >170.499286733238</td><td >e73ea7024faf3e586faa</td><td >15000</td><td >14</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >625.506419400856</td><td >202.339514978602</td><td >18000</td><td >243.423680456491</td><td >187.960057061341</td><td >ced83871ee096018fc4e</td><td >16000</td><td >15</td><td >8</td></tr><tr ><td >donutChart</td><td ></td><td >629.614835948645</td><td >210.55634807418</td><td >19000</td><td >235.206847360913</td><td >171.526390870185</td><td >d6b9cd13701eef6b77cc</td><td >17000</td><td >16</td><td >8</td></tr><tr ><td >BarChartF5983CEA542C47889C9DE852B430DE5F</td><td ></td><td >880.228245363766</td><td >211.583452211127</td><td >20000</td><td >183.851640513552</td><td >508.416547788873</td><td >003ed55718e7bd0bfed2</td><td >19000</td><td >17</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >880.228245363766</td><td >202.339514978602</td><td >2000</td><td >183.851640513552</td><td >517.660485021398</td><td >36a9b1c09f47177e84e0</td><td >18000</td><td >18</td><td >8</td></tr><tr ><td >slicer</td><td ></td><td >884.336661911555</td><td >5.13552068473609</td><td >21000</td><td >174.607703281027</td><td >62.6533523537803</td><td >7755f919fcd7d4b0939e</td><td >20000</td><td >19</td><td >8</td></tr><tr ><td >slicer</td><td ></td><td >1077.43223965763</td><td >6.16262482168331</td><td >22000</td><td >170.499286733238</td><td >67.7888730385164</td><td >ad23b871662f48d33fc9</td><td >21000</td><td >20</td><td >8</td></tr><tr ><td >tableEx</td><td >'Table Chart'</td><td >123.824521934758</td><td >453.543307086614</td><td >23000</td><td >729.988751406074</td><td >259.167604049494</td><td >ccb4b73e17687ba6fdbf</td><td >23000</td><td >21</td><td >8</td></tr><tr ><td >actionButton</td><td >'Table on'</td><td >345.556805399325</td><td >400.269966254218</td><td >24000</td><td >99.347581552306</td><td >33.1158605174353</td><td >4d7441495aacb93a3257</td><td >24000</td><td >22</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >111.954350927247</td><td >396.462196861626</td><td >1000</td><td >752.867332382311</td><td >36.9757489300999</td><td >039da0f01cf3c4da72bd</td><td >22000</td><td >23</td><td >8</td></tr><tr ><td >actionButton</td><td >'Shape on'</td><td >234.690663667042</td><td >398.830146231721</td><td >25000</td><td >100.787401574803</td><td >33.1158605174353</td><td >4a5210bea2d302e660cf</td><td >25000</td><td >24</td><td >8</td></tr><tr ><td >actionButton</td><td >'Bubble on'</td><td >119.144079885877</td><td >398.516405135521</td><td >27000</td><td >99.6291012838802</td><td >32.867332382311</td><td >f4b47edc5f425f7ba820</td><td >26000</td><td >25</td><td >8</td></tr><tr ><td >actionButton</td><td >'Bubble off'</td><td >122.508250825082</td><td >398.503850385039</td><td >28000</td><td >98.5698569856986</td><td >33.7953795379538</td><td >f9db4d9521a8cb3cafbe</td><td >28000</td><td >26</td><td >8</td></tr><tr ><td >actionButton</td><td >'Shape off'</td><td >233.250843644544</td><td >398.830146231721</td><td >29000</td><td >100.787401574803</td><td >33.1158605174353</td><td >3a64663e9b8e8c7a9683</td><td >29000</td><td >27</td><td >8</td></tr><tr ><td >actionButton</td><td >'Table off'</td><td >348.436445444319</td><td >398.830146231721</td><td >30000</td><td >99.347581552306</td><td >33.1158605174353</td><td >f1ff46df71be399ad8bd</td><td >30000</td><td >28</td><td >8</td></tr><tr ><td >card</td><td ></td><td >936.718972895863</td><td >104.764621968616</td><td >31000</td><td >160.228245363766</td><td >74.9786019971469</td><td >22a03d20549a0d0a2b7d</td><td >31000</td><td >29</td><td >8</td></tr><tr ><td >card</td><td ></td><td >1108.24536376605</td><td >105.791726105563</td><td >32000</td><td >148.930099857347</td><td >74.9786019971469</td><td >110e7dea7da5e4a81259</td><td >32000</td><td >30</td><td >8</td></tr><tr ><td >BarChartF5983CEA542C47889C9DE852B430DE5F</td><td ></td><td >1077.43223965763</td><td >206.447931526391</td><td >33000</td><td >184.878744650499</td><td >509.44365192582</td><td >b017403fe829ae4188ad</td><td >33000</td><td >31</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >1079.48644793153</td><td >202.339514978602</td><td >0</td><td >182.824536376605</td><td >517.660485021398</td><td >2e42b382be24fcef15f1</td><td >34000</td><td >32</td><td >8</td></tr><tr ><td ></td><td ></td><td >12.3252496433666</td><td >95.5206847360913</td><td >34000</td><td >86.2767475035663</td><td >624.479315263909</td><td >deb4f1b8789a473cfafb</td><td >27000</td><td >33</td><td >8</td></tr><tr ><td >textbox</td><td ></td><td >0</td><td >0</td><td >0</td><td >85.2496433666191</td><td >624.479315263909</td><td >36cb5e9d2e2888d25a7c</td><td ></td><td >34</td><td >8</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >111.954350927247</td><td >1000</td><td >67.7888730385164</td><td >71.8972895863053</td><td >b1262fc628d58530794b</td><td >1000</td><td >35</td><td >8</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >196.176890156919</td><td >2000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >29bab3c60c92f1205f72</td><td >2000</td><td >36</td><td >8</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >282.453637660485</td><td >3000</td><td >76.0057061340942</td><td >64.7075606276748</td><td >ec1e9ee3d641fae814ec</td><td >3000</td><td >37</td><td >8</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >364.621968616262</td><td >4000</td><td >76.0057061340942</td><td >66.7617689015692</td><td >94f704d5b91e8525801b</td><td >4000</td><td >38</td><td >8</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >446.79029957204</td><td >5000</td><td >67.7888730385164</td><td >63.6804564907275</td><td >8a3d84f1c2f302500512</td><td >5000</td><td >39</td><td >8</td></tr><tr ><td >image</td><td ></td><td >5.13552068473609</td><td >533.067047075606</td><td >6000</td><td >76.0057061340942</td><td >62.6533523537803</td><td >b65e623b2d5e276f4e55</td><td >6000</td><td >40</td><td >8</td></tr><tr ><td >image</td><td ></td><td >9.24393723252497</td><td >18.4878744650499</td><td >7000</td><td >67.7888730385164</td><td >64.7075606276748</td><td >c824685a589d4402c05f</td><td >7000</td><td >41</td><td >8</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >18.4878744650499</td><td >8000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >9d3eb0b2523a008d810a</td><td >8000</td><td >42</td><td >8</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >111.954350927247</td><td >9000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >56240cc1963897ee3733</td><td >9000</td><td >43</td><td >8</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >198.231098430813</td><td >10000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >232321d65d5765e9c0c3</td><td >10000</td><td >44</td><td >8</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >283.480741797432</td><td >11000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >bf0e7b54a144ef455546</td><td >11000</td><td >45</td><td >8</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >366.676176890157</td><td >12000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >faae97bfa9f3046b5294</td><td >12000</td><td >46</td><td >8</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >446.79029957204</td><td >13000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >e504330f4a8a3184a35f</td><td >13000</td><td >47</td><td >8</td></tr><tr ><td >actionButton</td><td ></td><td >1.02710413694722</td><td >533.067047075606</td><td >14000</td><td >85.2496433666191</td><td >64.7075606276748</td><td >27f6315a1b8b6ce11c41</td><td >14000</td><td >48</td><td >8</td></tr><tr ><td >map</td><td >'Laboratory Distribution by Ownership'</td><td >123.916391639164</td><td >453.421342134213</td><td >35000</td><td >732.233223322332</td><td >259.097909790979</td><td >f2f08a05f5ccbf678cf2</td><td >35000</td><td >49</td><td >8</td></tr><tr ><td >map</td><td >'Laboratory Distribution by Ownership'</td><td >133.916391639164</td><td >460.902090209021</td><td >36000</td><td >732.233223322332</td><td >259.097909790979</td><td >9709be95ce2171d608eb</td><td >36000</td><td >50</td><td >8</td></tr><tr ><td >map</td><td >'Laboratory Distribution by Ownership'</td><td >122.508250825082</td><td >454.829482948295</td><td >37000</td><td >732.233223322332</td><td >259.097909790979</td><td >a0334cffdd432866e13c</td><td >37000</td><td >51</td><td >8</td></tr><tr ><td >actionButton</td><td >'Theme'</td><td >508.338833883388</td><td >399.91199119912</td><td >38000</td><td >78.8558855885588</td><td >33.7953795379538</td><td >fa79c8d5d5f16628a7d2</td><td >38000</td><td >52</td><td >8</td></tr><tr ><td >actionButton</td><td >'Road on'</td><td >623.806380638064</td><td >399.91199119912</td><td >42000</td><td >74.6314631463146</td><td >33.7953795379538</td><td >c88fdc47eadf975aeff6</td><td >39000</td><td >53</td><td >8</td></tr><tr ><td >actionButton</td><td >'Aerial off'</td><td >701.254125412541</td><td >398.503850385039</td><td >39000</td><td >74.6314631463146</td><td >33.7953795379538</td><td >72d6e3489665426fecd7</td><td >40000</td><td >54</td><td >8</td></tr><tr ><td >actionButton</td><td >'Dark off'</td><td >781.518151815181</td><td >397.095709570957</td><td >40000</td><td >74.6314631463146</td><td >33.7953795379538</td><td >5f9841bc16b26672d860</td><td >41000</td><td >55</td><td >8</td></tr><tr ><td >actionButton</td><td >'Road off'</td><td >623.806380638064</td><td >399.91199119912</td><td >41000</td><td >74.6314631463146</td><td >33.7953795379538</td><td >19ad2d1452826e79a518</td><td >42000</td><td >56</td><td >8</td></tr><tr ><td >actionButton</td><td >'Aerial on'</td><td >702.662266226623</td><td >398.503850385039</td><td >43000</td><td >74.6314631463146</td><td >33.7953795379538</td><td >42c85f7f60568efdb7fe</td><td >43000</td><td >57</td><td >8</td></tr><tr ><td >actionButton</td><td >'Dark on'</td><td >781.518151815181</td><td >397.095709570957</td><td >44000</td><td >74.6314631463146</td><td >33.7953795379538</td><td >42b26a7bf278448dce6d</td><td >44000</td><td >58</td><td >8</td></tr></table><br></br><h3><div>Visuals in Health Tooltip 1:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >BarChartF5983CEA542C47889C9DE852B430DE5F</td><td >'No of Laboratory by Ward'</td><td >0</td><td >137</td><td >0</td><td >216</td><td >208</td><td >b009d370afee99b3015d</td><td >4000</td><td >0</td><td >9</td></tr><tr ><td >BarChartF5983CEA542C47889C9DE852B430DE5F</td><td >'Laboratory by Owner'</td><td >233</td><td >137</td><td >1000</td><td >202</td><td >118</td><td >198ee95cff3688d4adae</td><td >5000</td><td >1</td><td >9</td></tr><tr ><td >card</td><td ></td><td >3</td><td >48</td><td >2000</td><td >160</td><td >76</td><td >1199d1ebcec6dcd38e78</td><td ></td><td >2</td><td >9</td></tr><tr ><td >card</td><td ></td><td >173</td><td >48</td><td >3000</td><td >143</td><td >76</td><td >0f2b60e0af922c0d7ea7</td><td >1000</td><td >3</td><td >9</td></tr><tr ><td >card</td><td ></td><td >326</td><td >48</td><td >4000</td><td >146</td><td >76</td><td >614255838138924bb72e</td><td >2000</td><td >4</td><td >9</td></tr><tr ><td >card</td><td ></td><td >0</td><td >0</td><td >5000</td><td >650</td><td >38</td><td >95d6710830a80f661673</td><td >3000</td><td >5</td><td >9</td></tr><tr ><td >BarChartF5983CEA542C47889C9DE852B430DE5F</td><td >'Laboratory by Type'</td><td >228</td><td >271</td><td >6000</td><td >207</td><td >79</td><td >bacb3e6c437b91dfdb44</td><td >6000</td><td >6</td><td >9</td></tr><tr ><td >card</td><td ></td><td >479</td><td >48</td><td >7000</td><td >165</td><td >76</td><td >2447e68e2db51a5196d4</td><td >7000</td><td >7</td><td >9</td></tr><tr ><td >BarChartF5983CEA542C47889C9DE852B430DE5F</td><td >'No of Laboratory by Ward'</td><td >447</td><td >137</td><td >8000</td><td >203</td><td >213</td><td >7bb3b92edf027bb0f319</td><td >8000</td><td >8</td><td >9</td></tr></table><br></br><h3><div>Visuals in About the data:</div></h3><table border='1px' cellpadding='1'><tr ><td >Visual Type</td><td >Title</td><td >X</td><td >Y</td><td >Z</td><td >Width</td><td >Height</td><td >Name</td><td >tabOrder</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >textbox</td><td ></td><td >16.6233766233766</td><td >54.025974025974</td><td >0</td><td >1246.75324675325</td><td >641.038961038961</td><td >0e08ca03d9bc2a103ee2</td><td ></td><td >0</td><td >10</td></tr><tr ><td >actionButton</td><td ></td><td >0</td><td >0</td><td >1000</td><td >100</td><td >40</td><td >955ea8972fe0e57f3ab7</td><td >1000</td><td >1</td><td >10</td></tr></table><hr></hr><br></br><h3><div>List of Bookmarks:</div></h3><br></br><table border='1px' cellpadding='1'><tr ><td >DisplayName</td><td >Page Name</td><td >Index</td><td >Name</td></tr><tr ><td >Barchart</td><td >ReportSectionc179ed56dced2d0b44f9</td><td >0</td><td >Bookmark7689b21ba94c353301a7</td></tr><tr ><td >Table</td><td >ReportSectionc179ed56dced2d0b44f9</td><td >1</td><td >Bookmark6666cb190c7aa5d44ff1</td></tr><tr ><td >Map (Pop)</td><td >ReportSection</td><td >2</td><td >Bookmarkf88e7c86520e61d44596</td></tr><tr ><td >Table (Pop)</td><td >ReportSection</td><td >3</td><td >Bookmarkedf5facecf0fca7329e7</td></tr><tr ><td >Map (Agric)</td><td >ReportSection725bc232f842f4cf7a34</td><td >4</td><td >Bookmark7bcdf5226c98a858aadc</td></tr><tr ><td >Table (Agric)</td><td >ReportSection725bc232f842f4cf7a34</td><td >5</td><td >Bookmark861986d8d1d8d84f067b</td></tr><tr ><td >Map (Sch)</td><td >ReportSection7626f70fe70048b64974</td><td >6</td><td >Bookmark6550a909ca9a64c4ee23</td></tr><tr ><td >Table (Sch)</td><td >ReportSection7626f70fe70048b64974</td><td >7</td><td >Bookmark868a492af72abf09c7cc</td></tr><tr ><td >Bubble (Road)</td><td >ReportSectioneaeeff9d1cc221ce8be4</td><td >8</td><td >Bookmark017d7c2d3ce843f3e4c4</td></tr><tr ><td >Bubble (Dark)</td><td >ReportSectioneaeeff9d1cc221ce8be4</td><td >9</td><td >Bookmark99e56ba05170d8c06185</td></tr><tr ><td >Bubble (Aerial)</td><td >ReportSectioneaeeff9d1cc221ce8be4</td><td >10</td><td >Bookmarkadbd6b669b2d456a5b58</td></tr><tr ><td >Shape Map</td><td >ReportSectioneaeeff9d1cc221ce8be4</td><td >11</td><td >Bookmark46a257bc727169954994</td></tr><tr ><td >Table Chart</td><td >ReportSectioneaeeff9d1cc221ce8be4</td><td >12</td><td >Bookmark03937b2bb24d6e12b4bd</td></tr></table><hr></hr><br></br><h3><div>List of all Columns/Fields/Measures/Expressions Used in Visuals:</div></h3><br></br><table border='1px' cellpadding='1' cellspacing='1'><tr ><td >Name</td><td >Table Name</td><td >Aggregation</td><td >Expression</td><td >VisualIndex</td><td >PageIndex</td></tr><tr ><td >No of Ambulance</td><td >Ambulance</td><td ></td><td >Ambulance.No of Ambulance</td><td >14</td><td >0</td></tr><tr ><td >Total Population</td><td >Population</td><td ></td><td >Population.Total Population</td><td >0</td><td >1</td></tr><tr ><td >Female Population</td><td >Population</td><td ></td><td >Population.Female Population</td><td >1</td><td >1</td></tr><tr ><td ></td><td >Population</td><td ></td><td >Population.%Female Population</td><td >3</td><td >1</td></tr><tr ><td ></td><td >Population</td><td ></td><td >Population.%Male Population</td><td >20</td><td >1</td></tr><tr ><td >Male Population</td><td >Population</td><td ></td><td >Population.Male Population</td><td >21</td><td >1</td></tr><tr ><td >No of LGA</td><td >Population</td><td ></td><td >Population.No of LGA</td><td >22</td><td >1</td></tr><tr ><td >No of Ward</td><td >Population</td><td ></td><td >Population.No of Ward</td><td >23</td><td >1</td></tr><tr ><td >Age Range</td><td >Population</td><td ></td><td >Population.Age Range</td><td >24</td><td >1</td></tr><tr ><td >Gender</td><td >Population</td><td ></td><td >Population.Gender</td><td >24</td><td >1</td></tr><tr ><td >Total Population</td><td >Population</td><td ></td><td >Population.Total Population</td><td >24</td><td >1</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >25</td><td >1</td></tr><tr ><td >Status Code</td><td >Fact Table</td><td >Sum</td><td >Sum(Fact Table.Status Code)</td><td >25</td><td >1</td></tr><tr ><td >Status</td><td >Fact Table</td><td ></td><td >Fact Table.Status</td><td >25</td><td >1</td></tr><tr ><td >Population</td><td >Population</td><td >Sum</td><td >Sum(Population.Population)</td><td >25</td><td >1</td></tr><tr ><td >Male Population</td><td >Population</td><td ></td><td >Population.Male Population</td><td >25</td><td >1</td></tr><tr ><td >Female Population</td><td >Population</td><td ></td><td >Population.Female Population</td><td >25</td><td >1</td></tr><tr ><td ></td><td >Population</td><td ></td><td >Population.%Male Population</td><td >25</td><td >1</td></tr><tr ><td ></td><td >Population</td><td ></td><td >Population.%Female Population</td><td >25</td><td >1</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >26</td><td >1</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >26</td><td >1</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >26</td><td >1</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >26</td><td >1</td></tr><tr ><td >Age Range</td><td >Population</td><td ></td><td >Population.Age Range</td><td >27</td><td >1</td></tr><tr ><td >Age Range</td><td >Population</td><td ></td><td >Population.Age Range</td><td >27</td><td >1</td></tr><tr ><td >Gender</td><td >Population</td><td ></td><td >Population.Gender</td><td >28</td><td >1</td></tr><tr ><td >Gender</td><td >Population</td><td ></td><td >Population.Gender</td><td >28</td><td >1</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >29</td><td >1</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >29</td><td >1</td></tr><tr ><td >Total Population</td><td >Population</td><td ></td><td >Population.Total Population</td><td >29</td><td >1</td></tr><tr ><td >Gender</td><td >Population</td><td ></td><td >Population.Gender</td><td >30</td><td >1</td></tr><tr ><td >LGA</td><td >Population</td><td ></td><td >Population.LGA</td><td >30</td><td >1</td></tr><tr ><td >Age Range</td><td >Population</td><td ></td><td >Population.Age Range</td><td >30</td><td >1</td></tr><tr ><td >Total Population</td><td >Population</td><td ></td><td >Population.Total Population</td><td >30</td><td >1</td></tr><tr ><td >Total Population</td><td >Population</td><td ></td><td >Population.Total Population</td><td >0</td><td >2</td></tr><tr ><td >No of Farmlands</td><td >Farmlands</td><td ></td><td >Farmlands.No of Farmlands</td><td >1</td><td >2</td></tr><tr ><td >Farm Rate (000)</td><td >Fact Table</td><td ></td><td >Fact Table.Farm Rate (000)</td><td >3</td><td >2</td></tr><tr ><td >No of Farming Ward</td><td >Farmlands</td><td ></td><td >Farmlands.No of Farming Ward</td><td >4</td><td >2</td></tr><tr ><td >No of Ward without Farmland</td><td >Farmlands</td><td ></td><td >Farmlands.No of Ward without Farmland</td><td >5</td><td >2</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >6</td><td >2</td></tr><tr ><td >Farm Rate (000)</td><td >Fact Table</td><td ></td><td >Fact Table.Farm Rate (000)</td><td >6</td><td >2</td></tr><tr ><td >Total Farming land</td><td >Fact Table</td><td ></td><td >Fact Table.Total Farming land</td><td >6</td><td >2</td></tr><tr ><td >Total Popn</td><td >Fact Table</td><td ></td><td >Fact Table.Total Popn</td><td >6</td><td >2</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >7</td><td >2</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >7</td><td >2</td></tr><tr ><td >Type</td><td >Farmlands</td><td ></td><td >Farmlands.Type</td><td >8</td><td >2</td></tr><tr ><td >Category</td><td >Farmlands</td><td ></td><td >Farmlands.Category</td><td >9</td><td >2</td></tr><tr ><td >Type</td><td >Farmlands</td><td ></td><td >Farmlands.Type</td><td >10</td><td >2</td></tr><tr ><td >No of Farming Ward</td><td >Farmlands</td><td ></td><td >Farmlands.No of Farming Ward</td><td >10</td><td >2</td></tr><tr ><td >Category</td><td >Farmlands</td><td ></td><td >Farmlands.Category</td><td >11</td><td >2</td></tr><tr ><td >No of Farmlands</td><td >Farmlands</td><td ></td><td >Farmlands.No of Farmlands</td><td >11</td><td >2</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >12</td><td >2</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >12</td><td >2</td></tr><tr ><td >Total Population</td><td >Population</td><td ></td><td >Population.Total Population</td><td >12</td><td >2</td></tr><tr ><td >No of Farmlands</td><td >Farmlands</td><td ></td><td >Farmlands.No of Farmlands</td><td >12</td><td >2</td></tr><tr ><td >Farm Rate</td><td >Fact Table</td><td ></td><td >Fact Table.Farm Rate/Population (00,000)</td><td >12</td><td >2</td></tr><tr ><td >Commercial Only</td><td >Farmlands</td><td ></td><td >Farmlands.Commercial Only</td><td >12</td><td >2</td></tr><tr ><td >Operating Both</td><td >Farmlands</td><td ></td><td >Farmlands.Operating Both</td><td >12</td><td >2</td></tr><tr ><td >Subsistence Only</td><td >Farmlands</td><td ></td><td >Farmlands.Subsistence Only</td><td >12</td><td >2</td></tr><tr ><td >No of Factories Industrial Sites</td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.No of Factories Industrial Sites</td><td >0</td><td >3</td></tr><tr ><td >No of In Use</td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.No of In Use</td><td >1</td><td >3</td></tr><tr ><td >No of Unused Good</td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.No of Unused Good</td><td >3</td><td >3</td></tr><tr ><td >No of Unused Poor</td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.No of Unused Poor</td><td >4</td><td >3</td></tr><tr ><td >No of Filling Stations</td><td >Filling Stations</td><td ></td><td >Filling Stations.No of Filling Stations</td><td >5</td><td >3</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >6</td><td >3</td></tr><tr ><td >Metric Selection Logic</td><td >Metric Selection</td><td ></td><td >Metric Selection.Metric Selection Logic</td><td >6</td><td >3</td></tr><tr ><td >Commerce Heading</td><td >Metric Selection</td><td ></td><td >Metric Selection.Commerce Heading</td><td >6</td><td >3</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >7</td><td >3</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >7</td><td >3</td></tr><tr ><td >Status</td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.Status</td><td >8</td><td >3</td></tr><tr ><td >No of Electricity Sub Stations</td><td >Electricity Sub Stations</td><td ></td><td >Electricity Sub Stations.No of Electricity Sub Stations</td><td >9</td><td >3</td></tr><tr ><td ></td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.% In Use</td><td >10</td><td >3</td></tr><tr ><td ></td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.% Unused Good</td><td >11</td><td >3</td></tr><tr ><td ></td><td >Factories Industrial Sites</td><td ></td><td >Factories Industrial Sites.% Unused Poor</td><td >12</td><td >3</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >13</td><td >3</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >13</td><td >3</td></tr><tr ><td >Metric Selection Logic</td><td >Metric Selection</td><td ></td><td >Metric Selection.Metric Selection Logic</td><td >13</td><td >3</td></tr><tr ><td ></td><td >Electricity Sub Stations</td><td ></td><td >Electricity Sub Stations.% of Sub Station by LGA</td><td >14</td><td >3</td></tr><tr ><td ></td><td >Filling Stations</td><td ></td><td >Filling Stations.% of Filling Station by Ward</td><td >15</td><td >3</td></tr><tr ><td >Metric</td><td >Metric Selection</td><td ></td><td >Metric Selection.Metric</td><td >16</td><td >3</td></tr><tr ><td >Metric Selection Logic</td><td >Metric Selection</td><td ></td><td >Metric Selection.Metric Selection Logic</td><td >17</td><td >3</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >17</td><td >3</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >0</td><td >4</td></tr><tr ><td >Metric Selection Logic</td><td >Metric Selection</td><td ></td><td >Metric Selection.Metric Selection Logic</td><td >0</td><td >4</td></tr><tr ><td >Total Population</td><td >Population</td><td ></td><td >Population.Total Population</td><td >0</td><td >5</td></tr><tr ><td >No of School</td><td >School</td><td ></td><td >School.No of School</td><td >1</td><td >5</td></tr><tr ><td ></td><td >School</td><td ></td><td >School.% of School to Pop</td><td >3</td><td >5</td></tr><tr ><td >Private</td><td >School</td><td ></td><td >School.Private</td><td >4</td><td >5</td></tr><tr ><td >Public</td><td >School</td><td ></td><td >School.Public</td><td >5</td><td >5</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >6</td><td >5</td></tr><tr ><td >Rate of School to Pop </td><td >School</td><td ></td><td >School.Rate of School to Pop (00,000)</td><td >6</td><td >5</td></tr><tr ><td >No of School</td><td >School</td><td ></td><td >School.No of School</td><td >6</td><td >5</td></tr><tr ><td >No of Private</td><td >School</td><td ></td><td >School.No of Private</td><td >6</td><td >5</td></tr><tr ><td >No of Public</td><td >School</td><td ></td><td >School.No of Public</td><td >6</td><td >5</td></tr><tr ><td >Ratio of Private to Public</td><td >School</td><td ></td><td >School.Ratio of Private to Public</td><td >6</td><td >5</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >7</td><td >5</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >7</td><td >5</td></tr><tr ><td >Type</td><td >Farmlands</td><td ></td><td >Farmlands.Type</td><td >8</td><td >5</td></tr><tr ><td >Category</td><td >School</td><td ></td><td >School.Category</td><td >9</td><td >5</td></tr><tr ><td >No of School</td><td >School</td><td ></td><td >School.No of School</td><td >10</td><td >5</td></tr><tr ><td >Subtype</td><td >School</td><td ></td><td >School.Subtype</td><td >10</td><td >5</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >11</td><td >5</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >11</td><td >5</td></tr><tr ><td >No of School</td><td >School</td><td ></td><td >School.No of School</td><td >11</td><td >5</td></tr><tr ><td >Rate of School to Pop </td><td >School</td><td ></td><td >School.Rate of School to Pop (00,000)</td><td >11</td><td >5</td></tr><tr ><td >No of Private</td><td >School</td><td ></td><td >School.No of Private</td><td >11</td><td >5</td></tr><tr ><td >No of Public</td><td >School</td><td ></td><td >School.No of Public</td><td >11</td><td >5</td></tr><tr ><td >Ratio of Private</td><td >School</td><td ></td><td >School.Ratio of Private:Public</td><td >11</td><td >5</td></tr><tr ><td >Ratio of Private</td><td >School</td><td ></td><td >School.Ratio of Private:Public</td><td >16</td><td >5</td></tr><tr ><td >Category</td><td >School</td><td ></td><td >School.Category</td><td >17</td><td >5</td></tr><tr ><td >No of School</td><td >School</td><td ></td><td >School.No of School</td><td >17</td><td >5</td></tr><tr ><td >No of School</td><td >School</td><td ></td><td >School.No of School</td><td >17</td><td >5</td></tr><tr ><td >No of Private</td><td >School</td><td ></td><td >School.No of Private</td><td >17</td><td >5</td></tr><tr ><td >No of Public</td><td >School</td><td ></td><td >School.No of Public</td><td >17</td><td >5</td></tr><tr ><td >Ratio of Private</td><td >School</td><td ></td><td >School.Ratio of Private:Public</td><td >17</td><td >5</td></tr><tr ><td ></td><td >Fire Station</td><td ></td><td >Fire Station.% Functional Fire Vehicle</td><td >0</td><td >6</td></tr><tr ><td >Total Functional Fire Vehicle</td><td >Fire Station</td><td ></td><td >Fire Station.Total Functional Fire Vehicle</td><td >1</td><td >6</td></tr><tr ><td >Total Fire Vehicle</td><td >Fire Station</td><td ></td><td >Fire Station.Total Fire Vehicle</td><td >2</td><td >6</td></tr><tr ><td >No of Fire Station</td><td >Fire Station</td><td ></td><td >Fire Station.No of Fire Station</td><td >3</td><td >6</td></tr><tr ><td >No of Ambulance</td><td >Ambulance</td><td ></td><td >Ambulance.No of Ambulance</td><td >4</td><td >6</td></tr><tr ><td >No of Ambulance</td><td >Ambulance</td><td ></td><td >Ambulance.No of Ambulance</td><td >6</td><td >6</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >6</td><td >6</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >7</td><td >6</td></tr><tr ><td >No of Fire Station</td><td >Fire Station</td><td ></td><td >Fire Station.No of Fire Station</td><td >7</td><td >6</td></tr><tr ><td >Name</td><td >Fire Station</td><td >Min</td><td >Min(Fire Station.Name)</td><td >7</td><td >6</td></tr><tr ><td >Ward</td><td >Fact Table</td><td >Min</td><td >Min(Fact Table.Ward)</td><td >7</td><td >6</td></tr><tr ><td >Total Fire Vehicle</td><td >Fire Station</td><td ></td><td >Fire Station.Total Fire Vehicle</td><td >8</td><td >6</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >8</td><td >6</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >9</td><td >6</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >9</td><td >6</td></tr><tr ><td >Total Fire Vehicle</td><td >Fire Station</td><td ></td><td >Fire Station.Total Fire Vehicle</td><td >9</td><td >6</td></tr><tr ><td >Total Functional Fire Vehicle</td><td >Fire Station</td><td ></td><td >Fire Station.Total Functional Fire Vehicle</td><td >9</td><td >6</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >13</td><td >6</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >13</td><td >6</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >0</td><td >7</td></tr><tr ><td >Total Fire Vehicle</td><td >Fire Station</td><td ></td><td >Fire Station.Total Fire Vehicle</td><td >0</td><td >7</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >1</td><td >7</td></tr><tr ><td >No of Ambulance</td><td >Ambulance</td><td ></td><td >Ambulance.No of Ambulance</td><td >1</td><td >7</td></tr><tr ><td >Total Fire Vehicle</td><td >Fire Station</td><td ></td><td >Fire Station.Total Fire Vehicle</td><td >2</td><td >7</td></tr><tr ><td ></td><td >Fire Station</td><td ></td><td >Fire Station.% Functional Fire Vehicle</td><td >3</td><td >7</td></tr><tr ><td >No of Ambulance</td><td >Ambulance</td><td ></td><td >Ambulance.No of Ambulance</td><td >4</td><td >7</td></tr><tr ><td >LGA</td><td >Fact Table</td><td >Min</td><td >Min(Fact Table.LGA)</td><td >5</td><td >7</td></tr><tr ><td >Ratio of Lab to Population </td><td >Laboratory</td><td ></td><td >Laboratory.Ratio of Lab to Population (000,000)</td><td >0</td><td >8</td></tr><tr ><td >Others Ownership Lab</td><td >Laboratory</td><td ></td><td >Laboratory.Others Ownership Lab</td><td >1</td><td >8</td></tr><tr ><td >State Ownership Lab</td><td >Laboratory</td><td ></td><td >Laboratory.State Ownership Lab</td><td >2</td><td >8</td></tr><tr ><td >Private Ownership Lab</td><td >Laboratory</td><td ></td><td >Laboratory.Private Ownership Lab</td><td >3</td><td >8</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >4</td><td >8</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >6</td><td >8</td></tr><tr ><td >Type</td><td >Laboratory</td><td ></td><td >Laboratory.Type</td><td >6</td><td >8</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >7</td><td >8</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >7</td><td >8</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >10</td><td >8</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >10</td><td >8</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >14</td><td >8</td></tr><tr ><td >Ownership</td><td >Laboratory</td><td ></td><td >Laboratory.Ownership</td><td >14</td><td >8</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >16</td><td >8</td></tr><tr ><td >Source</td><td >Laboratory</td><td ></td><td >Laboratory.Source</td><td >16</td><td >8</td></tr><tr ><td >LGA</td><td >Laboratory</td><td ></td><td >Laboratory.LGA</td><td >17</td><td >8</td></tr><tr ><td >ward_name</td><td >Laboratory</td><td ></td><td >Laboratory.ward_name</td><td >17</td><td >8</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >17</td><td >8</td></tr><tr ><td >Type</td><td >Laboratory</td><td ></td><td >Laboratory.Type</td><td >19</td><td >8</td></tr><tr ><td >Ownership</td><td >Laboratory</td><td ></td><td >Laboratory.Ownership</td><td >19</td><td >8</td></tr><tr ><td >Source</td><td >Laboratory</td><td ></td><td >Laboratory.Source</td><td >20</td><td >8</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >21</td><td >8</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >21</td><td >8</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >21</td><td >8</td></tr><tr ><td >Ratio of Lab to Population </td><td >Laboratory</td><td ></td><td >Laboratory.Ratio of Lab to Population (000,000)</td><td >21</td><td >8</td></tr><tr ><td >No of Pharmaceutical Facillities</td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.No of Pharmaceutical Facillities</td><td >21</td><td >8</td></tr><tr ><td >Pharmacy to Pop Ratio </td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.Pharmacy to Pop Ratio (00,000)</td><td >21</td><td >8</td></tr><tr ><td >No of Pharmaceutical Facillities</td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.No of Pharmaceutical Facillities</td><td >29</td><td >8</td></tr><tr ><td >Pharmacy to Pop Ratio </td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.Pharmacy to Pop Ratio (00,000)</td><td >30</td><td >8</td></tr><tr ><td >LGA</td><td >Fact Table</td><td ></td><td >Fact Table.LGA</td><td >31</td><td >8</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >31</td><td >8</td></tr><tr ><td >No of Pharmaceutical Facillities</td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.No of Pharmaceutical Facillities</td><td >31</td><td >8</td></tr><tr ><td >Pharmacy to Pop Ratio </td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.Pharmacy to Pop Ratio (00,000)</td><td >31</td><td >8</td></tr><tr ><td >Latitude</td><td >Laboratory</td><td ></td><td >Laboratory.Latitude</td><td >49</td><td >8</td></tr><tr ><td >Longitude</td><td >Laboratory</td><td ></td><td >Laboratory.Longitude</td><td >49</td><td >8</td></tr><tr ><td >Ownership</td><td >Laboratory</td><td ></td><td >Laboratory.Ownership</td><td >49</td><td >8</td></tr><tr ><td >Latitude</td><td >Laboratory</td><td ></td><td >Laboratory.Latitude</td><td >50</td><td >8</td></tr><tr ><td >Longitude</td><td >Laboratory</td><td ></td><td >Laboratory.Longitude</td><td >50</td><td >8</td></tr><tr ><td >Ownership</td><td >Laboratory</td><td ></td><td >Laboratory.Ownership</td><td >50</td><td >8</td></tr><tr ><td >Latitude</td><td >Laboratory</td><td ></td><td >Laboratory.Latitude</td><td >51</td><td >8</td></tr><tr ><td >Longitude</td><td >Laboratory</td><td ></td><td >Laboratory.Longitude</td><td >51</td><td >8</td></tr><tr ><td >Ownership</td><td >Laboratory</td><td ></td><td >Laboratory.Ownership</td><td >51</td><td >8</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >0</td><td >9</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >0</td><td >9</td></tr><tr ><td >Ownership</td><td >Laboratory</td><td ></td><td >Laboratory.Ownership</td><td >1</td><td >9</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >1</td><td >9</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >2</td><td >9</td></tr><tr ><td >Ratio of Lab to Population </td><td >Laboratory</td><td ></td><td >Laboratory.Ratio of Lab to Population (000,000)</td><td >3</td><td >9</td></tr><tr ><td >No of Pharmaceutical Facillities</td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.No of Pharmaceutical Facillities</td><td >4</td><td >9</td></tr><tr ><td >LGA</td><td >Laboratory</td><td >Min</td><td >Min(Laboratory.LGA)</td><td >5</td><td >9</td></tr><tr ><td >Type</td><td >Laboratory</td><td ></td><td >Laboratory.Type</td><td >6</td><td >9</td></tr><tr ><td >No of Laboaratory</td><td >Laboratory</td><td ></td><td >Laboratory.No of Laboaratory</td><td >6</td><td >9</td></tr><tr ><td >Pharmacy to Pop Ratio </td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.Pharmacy to Pop Ratio (00,000)</td><td >7</td><td >9</td></tr><tr ><td >Ward</td><td >Fact Table</td><td ></td><td >Fact Table.Ward</td><td >8</td><td >9</td></tr><tr ><td >No of Pharmaceutical Facillities</td><td >Pharmaceutical Facilities</td><td ></td><td >Pharmaceutical Facilities.No of Pharmaceutical Facillities</td><td >8</td><td >9</td></tr></table><hr></hr><br></br><h3><div>List of Tables Used in Visuals:</div></h3><br></br><table border='1px' cellpadding='1' cellspacing='1'><tr ><td >Name</td></tr><tr ><td >Ambulance</td></tr><tr ><td >Population</td></tr><tr ><td >Fact Table</td></tr><tr ><td >Farmlands</td></tr><tr ><td >Factories Industrial Sites</td></tr><tr ><td >Filling Stations</td></tr><tr ><td >Metric Selection</td></tr><tr ><td >Electricity Sub Stations</td></tr><tr ><td >School</td></tr><tr ><td >Fire Station</td></tr><tr ><td >Laboratory</td></tr><tr ><td >Pharmaceutical Facilities</td></tr></table><hr></hr><br></br><h3><div>List of Columns Not Used in Visuals:</div></h3><br></br><table border='1px' cellpadding='1' cellspacing='1'><tr ><td >Name</td><td >Table Name</td><td >State</td><td >Data Category</td><td >Data Type</td><td >Description</td><td >Display Folder</td><td >Error Message</td><td >Format String</td><td >Is Hidden</td><td >Modified Time</td><td >Structure Modified Time</td><td >Sort by Column</td><td >Summarize By</td><td >Type</td><td >Expression</td></tr><tr ><td >state_code</td><td >Ambulance</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Ambulance</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Ambulance</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Type</td><td >Ambulance</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Ambulance</td><td >Ambulance</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Type</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Category</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Electricity Sub Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Electricity Sub Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Electricity Sub Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Factories Industrial Sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Factories Industrial Sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Factories Industrial Sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Farmlands</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Farmlands</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Farmlands</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Filling Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Filling Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Filling Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Type</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Fire Station</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Fire Vehicle</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Functional Fire Vehicle</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >fire_personnel</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >lga_code</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_name</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Pharmaceutical Facilities</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Pharmaceutical Facilities</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Pharmaceutical Facilities</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Police Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Police Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Police Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >State</td><td >Population</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Ward</td><td >Population</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Population</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >lga_code</td><td >Population</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Surface Type</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Smoothness</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >OSM Class</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Road Class</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Waterway</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Waterway</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Type</td><td >Waterway</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Category1</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Management</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Education</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >no_of_teachers</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >no_of_students</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >state_code</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Name</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Settlement Name</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Total Days</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Frequency</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Type of Goods</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >State</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >ward_code</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >lga_code</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Tot Pop</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >First Qrt</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Second Qrt2</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Third Qrt3</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Population Status</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Population Status Code</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Total No of Farmland</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Farmland rate</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Rare of Schl</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >Index</td><td >Metric Selection</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >COLUMN</td><td ></td></tr><tr ><td >No of Dump Site</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Official Dump Site</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Unfficial Dump Site</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Mixed Dump Site</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Organic Dump Site</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Toxic Dump Site</td><td >Dump sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >% Sub Station by LGA</td><td >Electricity Sub Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Max</td><td >Factories Industrial Sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >% In Use</td><td >Factories Industrial Sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >% Unused Good</td><td >Factories Industrial Sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >% Unused Poor</td><td >Factories Industrial Sites</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Animal Farm</td><td >Farmlands</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Crop Farm</td><td >Farmlands</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Mixed Farm</td><td >Farmlands</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Unknown</td><td >Farmlands</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >% of Filling Station by Ward</td><td >Filling Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >% Functional Fire Vehicle</td><td >Fire Station</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Primary Laboaratory</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Secondary Laboaratory</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Ratio of Lab to Population (000,000)</td><td >Laboratory</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Pharmacy to Pop Ratio (00,000)</td><td >Pharmaceutical Facilities</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Police Stations</td><td >Police Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Ratio of Ward to Poice Station</td><td >Police Stations</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >%Female Population</td><td >Population</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >%Male Population</td><td >Population</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Road</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Not Tarred</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Tarred Road</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Ratio of Tarred to Not Tarred Road</td><td >Road</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Ratio of Population to School</td><td >School</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Market</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Bi-Weekly</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Weekly</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Measure</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Other</td><td >Markets</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Q3</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Q1</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Q2</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Rate of Farmland by Population (00,000)</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >No of Schools</td><td >Fact Table</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr><tr ><td >Metric Selected</td><td >Metric Selection</td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td ></td><td >MEASURE</td><td ></td></tr></table><hr></hr><br></br><h3><div>List of Tables Not Used in Visuals:</div></h3><br></br><table border='1px' cellpadding='1' cellspacing='1'><tr ><td >Name</td></tr><tr ><td >Dump sites</td></tr><tr ><td >Police Stations</td></tr><tr ><td >Road</td></tr><tr ><td >Waterway</td></tr><tr ><td >Markets</td></tr></table><h1><div>------------------****** Model ******---------------------</div></h1><br></br><h2><div>Model: Lagos Amenities and Resources Dashboard</div></h2><br></br><hr></hr><br></br><h3><div>List of Tables:</div></h3><br></br><table border='1px' cellpadding='1' cellspacing='1'><tr ><td >Name</td><td >Description</td><td >Storage Mode</td><td >Source</td><td >Is Hidden</td></tr><tr ><td >Ambulance</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"ambulance-emergency-services_Sheet" = Source{[Item="ambulance-emergency-services",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"ambulance-emergency-services_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"ward_code", type text}, {"name", type text}, {"type", type text}, {"police_station", type any}, {"ambulance", Int64.Type}, {"fire_station", type any}, {"fire_vehicle", type any}, {"functional_fire_vehicle", type any}, {"fire_personnel", type any}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"police_station", "fire_station", "fire_vehicle", "functional_fire_vehicle", "fire_personnel", "global_id", "source"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}, {"type", "Type"}, {"ambulance", "Ambulance"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >DateTableTemplate_74f55adc-7182-4165-ae0a-f51182b294e0</td><td ></td><td >Import</td><td ><pre>Calendar(Date(2015,1,1), Date(2015,1,1))</pre></td><td >True</td></tr><tr ><td >Dump sites</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"dump-sites_Sheet" = Source{[Item="dump-sites",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"dump-sites_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"ward_code", type text}, {"name", type text}, {"type", type text}, {"ownership", type any}, {"category", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"source", "ownership", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}, {"type", "Type"}, {"category", "Category"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Electricity Sub Stations</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"electricity-sub-stations_Sheet" = Source{[Item="electricity-sub-stations",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(#"electricity-sub-stations_Sheet",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"ward_code", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"source", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Factories Industrial Sites</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"factoriesindustrial-sites_Sheet" = Source{[Item="factoriesindustrial-sites",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(#"factoriesindustrial-sites_Sheet",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"status", type text}, {"ward_code", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"source", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}, {"status", "Status"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Farmlands</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
farmlands_Sheet = Source{[Item="farmlands",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(farmlands_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"type", type text}, {"power_source", type any}, {"category", type text}, {"ward_code", type text}, {"processing_facility", type any}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"source", "power_source", "processing_facility", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}, {"type", "Type"}, {"category", "Category"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Filling Stations</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"filling-stations_Sheet" = Source{[Item="filling-stations",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(#"filling-stations_Sheet",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"ward_code", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"source", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Fire Station</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"fire-station_Sheet" = Source{[Item="fire-station",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"fire-station_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"ward_code", type text}, {"name", type text}, {"type", type text}, {"police_station", type any}, {"ambulance", type any}, {"fire_station", Int64.Type}, {"fire_vehicle", Int64.Type}, {"functional_fire_vehicle", Int64.Type}, {"fire_personnel", type any}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"source", "police_station", "ambulance", "global_id"}),
#"Replaced Value" = Table.ReplaceValue(#"Removed Columns",null,0,Replacer.ReplaceValue,{"fire_personnel"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",null,0,Replacer.ReplaceValue,{"functional_fire_vehicle"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1",null,0,Replacer.ReplaceValue,{"fire_vehicle"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Replaced Value2",{{"fire_personnel", Int64.Type}, {"functional_fire_vehicle", Int64.Type}, {"fire_vehicle", Int64.Type}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"name", "Name"}, {"type", "Type"}, {"fire_station", "Fire Station"}, {"fire_vehicle", "Fire Vehicle"}, {"functional_fire_vehicle", "Functional Fire Vehicle"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Laboratory</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"health-care-facilities-primary-_Sheet" = Source{[Item="health-care-facilities-primary-",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"health-care-facilities-primary-_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"latitude", type number}, {"longitude", type number}, {"contact_phone", type any}, {"contact_name", type any}, {"ri_service_status", type logical}, {"cce_quantity", Int64.Type}, {"cce_available", type logical}, {"cce_lastupdated", type any}, {"category", type text}, {"global_id", type text}, {"name", type text}, {"alternate_name", type text}, {"functional_status", type text}, {"type", type text}, {"ownership", type text}, {"ward_code", type text}, {"accessibility", type any}, {"source", type text}, {"ward_name", type text}, {"lga_code", Int64.Type}, {"lga_name", type text}, {"state_code", type text}, {"state_name", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"contact_phone", "contact_name", "accessibility"}),
#"Replaced Value" = Table.ReplaceValue(#"Removed Columns","_"," ",Replacer.ReplaceText,{"source"}),
#"Filtered Rows" = Table.SelectRows(#"Replaced Value", each true),
#"Removed Columns1" = Table.RemoveColumns(#"Filtered Rows",{"ri_service_status", "cce_quantity", "cce_available", "cce_lastupdated", "global_id"}),
#"Filtered Rows1" = Table.SelectRows(#"Removed Columns1", each ([category] = "Laboratory")),
#"Sorted Rows" = Table.Sort(#"Filtered Rows1",{{"name", Order.Ascending}}),
#"Renamed Columns" = Table.RenameColumns(#"Sorted Rows",{{"latitude", "Latitude"}, {"longitude", "Longitude"}, {"category", "Category"}, {"name", "Name"}}),
#"Removed Columns2" = Table.RemoveColumns(#"Renamed Columns",{"alternate_name"}),
#"Renamed Columns1" = Table.RenameColumns(#"Removed Columns2",{{"functional_status", "Functional Status"}, {"type", "Type"}, {"ownership", "Ownership"}, {"source", "Source"}, {"lga_name", "LGA"}}),
#"Removed Columns3" = Table.RemoveColumns(#"Renamed Columns1",{"Category", "Functional Status"})
in
#"Removed Columns3"</pre></td><td >False</td></tr><tr ><td >Pharmaceutical Facilities</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"pharmaceutical-facilities_Sheet" = Source{[Item="pharmaceutical-facilities",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(#"pharmaceutical-facilities_Sheet",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"ward_code", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"source", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Police Stations</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
#"police-stations_Sheet" = Source{[Item="police-stations",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(#"police-stations_Sheet",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"ward_code", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"source", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Population</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
population_Sheet = Source{[Item="population",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(population_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"State", type text}, {"LGA", type text}, {"Ward", type text}, {"ward_code", type text}, {"lga_code", Int64.Type}, {"Female 0 to 14", type number}, {"Male 0 to 14", type number}, {"Female 15 to 19", type number}, {"Male 15 to 19", type number}, {"Female 20 to 29", type number}, {"Male 20 to 29", type number}, {"Female 30 to 39", type number}, {"Male 30 to 39", type number}, {"Female 40 to 49", type number}, {"Male 40 to 49", type number}, {"Female 50 to 59", type number}, {"Male 50 to 59", type number}, {"Female 60 to 69", type number}, {"Male 60 to 69", type number}, {"Female 70 to 100", type number}, {"Male 70 to 100", type number}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"State", "LGA", "Ward", "ward_code", "lga_code"}, "Attribute", "Value"),
#"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Columns", "Attribute", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Attribute.1", "Attribute.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Attribute.1", type text}, {"Attribute.2", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Attribute.1", "Gender"}, {"Attribute.2", "Age Range"}, {"Value", "Population"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Road</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
road_Sheet = Source{[Item="road",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(road_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"surface_type", type text}, {"smoothness", type text}, {"one_way", type logical}, {"osm_class", type text}, {"road_class", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"global_id", "source"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"one_way", type text}}),
#"Removed Columns1" = Table.RemoveColumns(#"Changed Type1",{"one_way"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"name", "Name"}, {"surface_type", "Surface Type"}, {"smoothness", "Smoothness"}, {"osm_class", "OSM Class"}, {"road_class", "Road Class"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >Waterway</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
waterway_Sheet = Source{[Item="waterway",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(waterway_Sheet,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
#"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
#"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"type", type text}, {"global_id", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"source", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}, {"type", "Type"}})
in
#"Renamed Columns"</pre></td><td >False</td></tr><tr ><td >School</td><td ></td><td >Import</td><td ><pre>let
Source = Table.Combine({#"private-schools", #"public-schools"}),
#"Filtered Rows" = Table.SelectRows(Source, each true),
#"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"source", "poi_type", "global_id"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"name", "Name"}, {"category", "Category"}, {"subtype", "Subtype"}, {"management", "Management"}, {"education", "Education"}}),
#"Duplicated Column" = Table.DuplicateColumn(#"Renamed Columns", "Category", "Category - Copy"),
#"Replaced Value" = Table.ReplaceValue(#"Duplicated Column","Pre Primary","Primary",Replacer.ReplaceText,{"Category - Copy"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","Other","Tertiary",Replacer.ReplaceText,{"Category - Copy"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Mixed","Primary",Replacer.ReplaceText,{"Category - Copy"}),
#"Renamed Columns1" = Table.RenameColumns(#"Replaced Value2",{{"Category", "Category1"}, {"Category - Copy", "Category"}})
in
#"Renamed Columns1"</pre></td><td >False</td></tr><tr ><td >Markets</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
markets_Sheet = Source{[Item="markets",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(markets_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"state_code", type text}, {"source", type text}, {"name", type text}, {"ward_code", type text}, {"settlement_name", type text}, {"settlement_type", type text}, {"type_goods", type text}, {"other_type_goods", type text}, {"product_desc", type any}, {"days_monday", type logical}, {"days_tuesday", type logical}, {"days_wednesday", type logical}, {"days_thursday", type logical}, {"days_friday", type logical}, {"days_saturday", type logical}, {"days_sunday", type logical}, {"total_days", Int64.Type}, {"frequency", type text}, {"global_id", type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Changed Type","Spare Parts","Spare_Parts",Replacer.ReplaceText,{"type_goods"}),
#"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","Food Stuff Mixed","Food_Stuff_Mixed",Replacer.ReplaceText,{"type_goods"}),
#"Replaced Value2" = Table.ReplaceValue(#"Replaced Value1","Food Stuff","Food_Stuff",Replacer.ReplaceText,{"type_goods"}),
#"Replaced Value3" = Table.ReplaceValue(#"Replaced Value2","Food_Stuff_Mixed","Food_Stuff Mixed",Replacer.ReplaceText,{"type_goods"}),
#"Removed Columns" = Table.RemoveColumns(#"Replaced Value3",{"product_desc", "global_id", "other_type_goods", "days_monday", "days_tuesday", "days_wednesday", "days_thursday", "days_friday", "days_saturday", "days_sunday"}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Removed Columns", "type_goods", Splitter.SplitTextByDelimiter(" ", QuoteStyle.Csv), {"type_goods.1", "type_goods.2", "type_goods.3", "type_goods.4", "type_goods.5", "type_goods.6", "type_goods.7"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"type_goods.1", type text}, {"type_goods.2", type text}, {"type_goods.3", type text}, {"type_goods.4", type text}, {"type_goods.5", type text}, {"type_goods.6", type text}, {"type_goods.7", type text}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type1", {"state_code", "source", "name", "ward_code", "settlement_name", "settlement_type", "total_days", "frequency"}, "Attribute", "Value"),
#"Removed Columns1" = Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns1",{{"Value", "Type of Goods"}, {"frequency", "Frequency"}, {"total_days", "Total Days"}}),
#"Removed Columns2" = Table.RemoveColumns(#"Renamed Columns",{"settlement_type", "source"}),
#"Renamed Columns1" = Table.RenameColumns(#"Removed Columns2",{{"name", "Name"}, {"settlement_name", "Settlement Name"}}),
#"Replaced Value4" = Table.ReplaceValue(#"Renamed Columns1","_"," ",Replacer.ReplaceText,{"Type of Goods"})
in
#"Replaced Value4"</pre></td><td >False</td></tr><tr ><td >Fact Table</td><td ></td><td >Import</td><td ><pre>let
Source = Excel.Workbook(File.Contents("C:\Users\USER\Documents\David Document\Lagos Report Analysis\Dataset\Merge Dataset.xlsx"), null, true),
population_Sheet = Source{[Item="population",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(population_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"State", type text}, {"LGA", type text}, {"Ward", type text}, {"ward_code", type text}, {"lga_code", Int64.Type}, {"Female 0 to 14", type number}, {"Male 0 to 14", type number}, {"Female 15 to 19", type number}, {"Male 15 to 19", type number}, {"Female 20 to 29", type number}, {"Male 20 to 29", type number}, {"Female 30 to 39", type number}, {"Male 30 to 39", type number}, {"Female 40 to 49", type number}, {"Male 40 to 49", type number}, {"Female 50 to 59", type number}, {"Male 50 to 59", type number}, {"Female 60 to 69", type number}, {"Male 60 to 69", type number}, {"Female 70 to 100", type number}, {"Male 70 to 100", type number}}),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"State", "LGA", "Ward", "ward_code", "lga_code"}, "Attribute", "Value"),
#"Split Column by Delimiter" = Table.SplitColumn(#"Unpivoted Columns", "Attribute", Splitter.SplitTextByEachDelimiter({" "}, QuoteStyle.Csv, false), {"Attribute.1", "Attribute.2"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Attribute.1", type text}, {"Attribute.2", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Attribute.1", "Gender"}, {"Attribute.2", "Age Range"}, {"Value", "Total Population"}}),
#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Gender", "Age Range", "Total Population"}),
#"Removed Duplicates" = Table.Distinct(#"Removed Columns", {"Ward"})
in
#"Removed Duplicates"</pre></td><td >False</td></tr><tr ><td >Metric Selection</td><td ></td><td >Import</td><td ><pre>let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("fc6/CgIxDMfxVwmZbzn/3BuouIhQbjo61LZKoCTQpINvb3U6UJy/H/LLsuBFQO5wDNGkUlY4c2pqlUIBR5YVBxzRD9+QGGbNPW9+5pmb5gQnkdTN9p+5itRudh9zKDn2+Uj2BNdu4CwYCb//2K+PUCnEj3We0PsX", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Metric = _t, Index = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Metric", type text}, {"Index", Int64.Type}})
in
#"Changed Type"</pre></td><td >False</td></tr></table><hr></hr><br></br><h3><div>List of Measures:</div></h3><br></br><table border="1" cellpadding="3">
<tr>
<th>Measure Name</th>
<th>Table Name</th>
<th>Description</th>
<th>Expression</th>
<th>Dependency</th>
<th>Reverse Dependency</th>
</tr>
<tr>
<td>No of Ambulance</td>
<td>Ambulance</td>
<td></td>
<td><pre>IF(ISBLANK(COUNTA(Ambulance[ward_code])) , 0, COUNTA(Ambulance[ward_code]))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Ambulance</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Ambulance</li>
<li>Column: ward_code (Table: Ambulance)</li>
</ul></span></li>
</ul></td>
<td>Measure: No of Ambulance</td>
</tr>
<tr>
<td>No of Dump Site</td>
<td>Dump sites</td>
<td></td>
<td><pre>COUNTA('Dump sites'[ward_code])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Dump Site</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Dump sites</li>
<li>Column: ward_code (Table: Dump sites)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Dump Site</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: No of Official Dump Site</li>
<li>Measure: No of Unfficial Dump Site</li>
<li>Measure: No of Mixed Dump Site</li>
<li>Measure: No of Organic Dump Site</li>
<li>Measure: No of Toxic Dump Site</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>No of Official Dump Site</td>
<td>Dump sites</td>
<td></td>
<td><pre>CALCULATE([No of Dump Site],FILTER('Dump sites', 'Dump sites'[Type] = "Official"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Official Dump Site</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Dump sites</li>
<li>Column: Type (Table: Dump sites)</li>
<li><span class="caret">Measure: No of Dump Site (Table: Dump sites)</span>
<ul class="nested">
<li>Table: Dump sites ...</li>
<li>Column: ward_code (Table: Dump sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: No of Official Dump Site</td>
</tr>
<tr>
<td>No of Unfficial Dump Site</td>
<td>Dump sites</td>
<td></td>
<td><pre>CALCULATE([No of Dump Site],FILTER('Dump sites', 'Dump sites'[Type] = "Unofficial"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Unfficial Dump Site</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Dump sites</li>
<li>Column: Type (Table: Dump sites)</li>
<li><span class="caret">Measure: No of Dump Site (Table: Dump sites)</span>
<ul class="nested">
<li>Table: Dump sites ...</li>
<li>Column: ward_code (Table: Dump sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: No of Unfficial Dump Site</td>
</tr>
<tr>
<td>No of Mixed Dump Site</td>
<td>Dump sites</td>
<td></td>
<td><pre>CALCULATE([No of Dump Site],FILTER('Dump sites', 'Dump sites'[Category] = "Mixed Dumpsite"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Mixed Dump Site</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Dump sites</li>
<li>Column: Category (Table: Dump sites)</li>
<li><span class="caret">Measure: No of Dump Site (Table: Dump sites)</span>
<ul class="nested">
<li>Table: Dump sites ...</li>
<li>Column: ward_code (Table: Dump sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: No of Mixed Dump Site</td>
</tr>
<tr>
<td>No of Organic Dump Site</td>
<td>Dump sites</td>
<td></td>
<td><pre>CALCULATE([No of Dump Site],FILTER('Dump sites', 'Dump sites'[Category] = "Organic Dumpsite"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Organic Dump Site</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Dump sites</li>
<li>Column: Category (Table: Dump sites)</li>
<li><span class="caret">Measure: No of Dump Site (Table: Dump sites)</span>
<ul class="nested">
<li>Table: Dump sites ...</li>
<li>Column: ward_code (Table: Dump sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: No of Organic Dump Site</td>
</tr>
<tr>
<td>No of Toxic Dump Site</td>
<td>Dump sites</td>
<td></td>
<td><pre>CALCULATE([No of Dump Site],FILTER('Dump sites', 'Dump sites'[Category] = "Toxic Dumpsite"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Toxic Dump Site</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Dump sites</li>
<li>Column: Category (Table: Dump sites)</li>
<li><span class="caret">Measure: No of Dump Site (Table: Dump sites)</span>
<ul class="nested">
<li>Table: Dump sites ...</li>
<li>Column: ward_code (Table: Dump sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: No of Toxic Dump Site</td>
</tr>
<tr>
<td>No of Electricity Sub Stations</td>
<td>Electricity Sub Stations</td>
<td></td>
<td><pre>COUNTA('Electricity Sub Stations'[ward_code])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Electricity Sub Stations</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Electricity Sub Stations</li>
<li>Column: ward_code (Table: Electricity Sub Stations)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Electricity Sub Stations</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: % Sub Station by LGA</li>
<li>Measure: Metric Selection Logic</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>% Sub Station by LGA</td>
<td>Electricity Sub Stations</td>
<td></td>
<td><pre>DIVIDE([No of Electricity Sub Stations],DISTINCTCOUNT('Fact Table'[LGA]),0)</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: % Sub Station by LGA</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Fact Table</li>
<li>Column: LGA (Table: Fact Table)</li>
<li><span class="caret">Measure: No of Electricity Sub Stations (Table: Electricity Sub Stations)</span>
<ul class="nested">
<li>Table: Electricity Sub Stations ...</li>
<li>Column: ward_code (Table: Electricity Sub Stations)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: % Sub Station by LGA</td>
</tr>
<tr>
<td>No of Factories Industrial Sites</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>COUNTA('Factories Industrial Sites'[ward_code])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Factories Industrial Sites</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Factories Industrial Sites</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Factories Industrial Sites</span><span class="dropDownCaret">
<ul class="nested">
<li><span class="caret">Measure: No of In Use</span>
<ul class="nested">
<li>Measure: % In Use</li>
<li>Measure: Metric Selection Logic</li>
</ul></li>
<li><span class="caret">Measure: No of Unused Good</span>
<ul class="nested">
<li>Measure: % Unused Good</li>
<li>Measure: Metric Selection Logic</li>
</ul></li>
<li><span class="caret">Measure: No of Unused Poor</span>
<ul class="nested">
<li>Measure: % Unused Poor</li>
<li>Measure: Metric Selection Logic</li>
</ul></li>
<li>Measure: % In Use</li>
<li>Measure: % Unused Good</li>
<li>Measure: % Unused Poor</li>
<li>Measure: Metric Selection Logic</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>No of In Use</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>CALCULATE([No of Factories Industrial Sites],FILTER('Factories Industrial Sites', 'Factories Industrial Sites'[Status] = "In Use"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of In Use</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Factories Industrial Sites</li>
<li>Column: Status (Table: Factories Industrial Sites)</li>
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of In Use</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: % In Use</li>
<li>Measure: Metric Selection Logic</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>No of Unused Good</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>CALCULATE([No of Factories Industrial Sites],FILTER('Factories Industrial Sites', 'Factories Industrial Sites'[Status] = "Unused Good"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Unused Good</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Factories Industrial Sites</li>
<li>Column: Status (Table: Factories Industrial Sites)</li>
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Unused Good</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: % Unused Good</li>
<li>Measure: Metric Selection Logic</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>No of Unused Poor</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>CALCULATE([No of Factories Industrial Sites],FILTER('Factories Industrial Sites', 'Factories Industrial Sites'[Status] = "Unused Poor"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Unused Poor</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Factories Industrial Sites</li>
<li>Column: Status (Table: Factories Industrial Sites)</li>
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Unused Poor</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: % Unused Poor</li>
<li>Measure: Metric Selection Logic</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>Max</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>732</pre></td>
<td>Measure: Max</td>
<td>Measure: Max</td>
</tr>
<tr>
<td>% In Use</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>DIVIDE([No of In Use],[No of Factories Industrial Sites],0)</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: % In Use</span><span class="dropDownCaret">
<ul class="nested">
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
<li><span class="caret">Measure: No of In Use (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: Status (Table: Factories Industrial Sites)</li>
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: % In Use</td>
</tr>
<tr>
<td>% Unused Good</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>DIVIDE([No of Unused Good],[No of Factories Industrial Sites],0)</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: % Unused Good</span><span class="dropDownCaret">
<ul class="nested">
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
<li><span class="caret">Measure: No of Unused Good (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: Status (Table: Factories Industrial Sites)</li>
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: % Unused Good</td>
</tr>
<tr>
<td>% Unused Poor</td>
<td>Factories Industrial Sites</td>
<td></td>
<td><pre>DIVIDE([No of Unused Poor],[No of Factories Industrial Sites],0)</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: % Unused Poor</span><span class="dropDownCaret">
<ul class="nested">
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
<li><span class="caret">Measure: No of Unused Poor (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: Status (Table: Factories Industrial Sites)</li>
<li><span class="caret">Measure: No of Factories Industrial Sites (Table: Factories Industrial Sites)</span>
<ul class="nested">
<li>Table: Factories Industrial Sites ...</li>
<li>Column: ward_code (Table: Factories Industrial Sites)</li>
</ul></li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: % Unused Poor</td>
</tr>
<tr>
<td>No of Farmlands</td>
<td>Farmlands</td>
<td></td>
<td><pre>COUNTA(Farmlands[ward_code])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Farmlands</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Farmlands</span><span class="dropDownCaret">
<ul class="nested">
<li><span class="caret">Calc_Column: Total No of Farmland</span>
<ul class="nested">
<li>Calc_Column: Farmland rate</li>
<li><span class="caret">Measure: Total Farming land</span>
<ul class="nested">
<li>Calc_Column: Farmland rate</li>
</ul></li>
</ul></li>
<li>Measure: Operating Both</li>
<li>Measure: Commercial Only</li>
<li>Measure: Subsistence Only</li>
<li>Measure: Animal Farm</li>
<li>Measure: Crop Farm</li>
<li>Measure: Mixed Farm</li>
<li>Measure: Unknown</li>
<li>Measure: Rate of Farmland by Population (00,000)</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>Operating Both</td>
<td>Farmlands</td>
<td></td>
<td><pre>CALCULATE([No of Farmlands],FILTER(Farmlands,Farmlands[Type] = "Both"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Operating Both</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: Type (Table: Farmlands)</li>
<li><span class="caret">Measure: No of Farmlands (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Operating Both</td>
</tr>
<tr>
<td>Commercial Only</td>
<td>Farmlands</td>
<td></td>
<td><pre>CALCULATE([No of Farmlands],FILTER(Farmlands,Farmlands[Type] = "Commercial"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Commercial Only</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: Type (Table: Farmlands)</li>
<li><span class="caret">Measure: No of Farmlands (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Commercial Only</td>
</tr>
<tr>
<td>Subsistence Only</td>
<td>Farmlands</td>
<td></td>
<td><pre>CALCULATE([No of Farmlands],FILTER(Farmlands,Farmlands[Type] = "Subsistence"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Subsistence Only</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: Type (Table: Farmlands)</li>
<li><span class="caret">Measure: No of Farmlands (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Subsistence Only</td>
</tr>
<tr>
<td>Animal Farm</td>
<td>Farmlands</td>
<td></td>
<td><pre>CALCULATE(Farmlands[No of Farmlands],FILTER(Farmlands,Farmlands[Category] = "Animal Farm"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Animal Farm</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: Category (Table: Farmlands)</li>
<li><span class="caret">Measure: No of Farmlands (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Animal Farm</td>
</tr>
<tr>
<td>Crop Farm</td>
<td>Farmlands</td>
<td></td>
<td><pre>CALCULATE(Farmlands[No of Farmlands],FILTER(Farmlands,Farmlands[Category] = "Crop Farm"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Crop Farm</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: Category (Table: Farmlands)</li>
<li><span class="caret">Measure: No of Farmlands (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Crop Farm</td>
</tr>
<tr>
<td>Mixed Farm</td>
<td>Farmlands</td>
<td></td>
<td><pre>CALCULATE(Farmlands[No of Farmlands],FILTER(Farmlands,Farmlands[Category] = "Mixed Farm"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Mixed Farm</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: Category (Table: Farmlands)</li>
<li><span class="caret">Measure: No of Farmlands (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Mixed Farm</td>
</tr>
<tr>
<td>Unknown</td>
<td>Farmlands</td>
<td></td>
<td><pre>CALCULATE(Farmlands[No of Farmlands],FILTER(Farmlands,Farmlands[Category] = "Unknown"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Unknown</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: Category (Table: Farmlands)</li>
<li><span class="caret">Measure: No of Farmlands (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Unknown</td>
</tr>
<tr>
<td>No of Farming Ward</td>
<td>Farmlands</td>
<td></td>
<td><pre>DISTINCTCOUNT(Farmlands[ward_code])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Farming Ward</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Farmlands</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Farming Ward</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: No of Ward without Farmland</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>No of Ward without Farmland</td>
<td>Farmlands</td>
<td></td>
<td><pre>Population[No of Ward] - [No of Farming Ward]</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Ward without Farmland</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Population</li>
<li><span class="caret">Measure: No of Farming Ward (Table: Farmlands)</span>
<ul class="nested">
<li>Table: Farmlands ...</li>
<li>Column: ward_code (Table: Farmlands)</li>
</ul></li>
<li><span class="caret">Measure: No of Ward (Table: Population)</span>
<ul class="nested">
<li>Table: Population ...</li>
<li>Column: Ward (Table: Population)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: No of Ward without Farmland</td>
</tr>
<tr>
<td>No of Filling Stations</td>
<td>Filling Stations</td>
<td></td>
<td><pre>COUNTA('Filling Stations'[ward_code])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Filling Stations</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Filling Stations</li>
<li>Column: ward_code (Table: Filling Stations)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Filling Stations</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: % of Filling Station by Ward</li>
<li>Measure: Metric Selection Logic</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>% of Filling Station by Ward</td>
<td>Filling Stations</td>
<td></td>
<td><pre>DIVIDE([No of Filling Stations],DISTINCTCOUNT('Fact Table'[Ward]),0)</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: % of Filling Station by Ward</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Fact Table</li>
<li>Column: Ward (Table: Fact Table)</li>
<li><span class="caret">Measure: No of Filling Stations (Table: Filling Stations)</span>
<ul class="nested">
<li>Table: Filling Stations ...</li>
<li>Column: ward_code (Table: Filling Stations)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: % of Filling Station by Ward</td>
</tr>
<tr>
<td>No of Fire Station</td>
<td>Fire Station</td>
<td></td>
<td><pre>COUNTA('Fire Station'[ward_code])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Fire Station</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Fire Station</li>
<li>Column: ward_code (Table: Fire Station)</li>
</ul></span></li>
</ul></td>
<td>Measure: No of Fire Station</td>
</tr>
<tr>
<td>Total Fire Vehicle</td>
<td>Fire Station</td>
<td></td>
<td><pre>SUM('Fire Station'[Fire Vehicle])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Total Fire Vehicle</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Fire Station</li>
<li>Column: Fire Vehicle (Table: Fire Station)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Total Fire Vehicle</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: % Functional Fire Vehicle</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>Total Functional Fire Vehicle</td>
<td>Fire Station</td>
<td></td>
<td><pre>SUM('Fire Station'[Functional Fire Vehicle])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Total Functional Fire Vehicle</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Fire Station</li>
<li>Column: Functional Fire Vehicle (Table: Fire Station)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Total Functional Fire Vehicle</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: % Functional Fire Vehicle</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>% Functional Fire Vehicle</td>
<td>Fire Station</td>
<td></td>
<td><pre>DIVIDE('Fire Station'[Total Functional Fire Vehicle], 'Fire Station'[Total Fire Vehicle],0)</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: % Functional Fire Vehicle</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Fire Station</li>
<li><span class="caret">Measure: Total Fire Vehicle (Table: Fire Station)</span>
<ul class="nested">
<li>Table: Fire Station ...</li>
<li>Column: Fire Vehicle (Table: Fire Station)</li>
</ul></li>
<li><span class="caret">Measure: Total Functional Fire Vehicle (Table: Fire Station)</span>
<ul class="nested">
<li>Table: Fire Station ...</li>
<li>Column: Functional Fire Vehicle (Table: Fire Station)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: % Functional Fire Vehicle</td>
</tr>
<tr>
<td>No of Laboaratory</td>
<td>Laboratory</td>
<td></td>
<td><pre>COUNTA(Laboratory[ward_name])</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Laboaratory</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Laboratory</li>
<li>Column: ward_name (Table: Laboratory)</li>
</ul></span></li>
</ul></td>
<td><ul id="myUL">
<li><span class="caret">Measure: No of Laboaratory</span><span class="dropDownCaret">
<ul class="nested">
<li>Measure: Primary Laboaratory</li>
<li>Measure: Secondary Laboaratory</li>
<li>Measure: Private Ownership Lab</li>
<li>Measure: Others Ownership Lab</li>
<li>Measure: State Ownership Lab</li>
<li>Measure: Ratio of Lab to Population (000,000)</li>
</ul></span></li>
</ul></td>
</tr>
<tr>
<td>Primary Laboaratory</td>
<td>Laboratory</td>
<td></td>
<td><pre>CALCULATE([No of Laboaratory],FILTER(Laboratory,Laboratory[Type] = "Primary"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Primary Laboaratory</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Laboratory</li>
<li>Column: Type (Table: Laboratory)</li>
<li><span class="caret">Measure: No of Laboaratory (Table: Laboratory)</span>
<ul class="nested">
<li>Table: Laboratory ...</li>
<li>Column: ward_name (Table: Laboratory)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Primary Laboaratory</td>
</tr>
<tr>
<td>Secondary Laboaratory</td>
<td>Laboratory</td>
<td></td>
<td><pre>CALCULATE([No of Laboaratory],FILTER(Laboratory,Laboratory[Type] = "Secondary"))</pre></td>
<td><ul id="myUL">
<li><span class="caret">Measure: Secondary Laboaratory</span><span class="dropDownCaret">
<ul class="nested">
<li>Table: Laboratory</li>
<li>Column: Type (Table: Laboratory)</li>
<li><span class="caret">Measure: No of Laboaratory (Table: Laboratory)</span>
<ul class="nested">
<li>Table: Laboratory ...</li>
<li>Column: ward_name (Table: Laboratory)</li>
</ul></li>
</ul></span></li>
</ul></td>
<td>Measure: Secondary Laboaratory</td>
</tr>
<tr>