Rectify missing data on lisbon-building-study

[alukach]

It looks like Energy consumption_WTW_building, Custo/Rend_norm, and Area are empty values for a large number of buildings in the lisbon-building-study dataset. This causes the buildings to appear black when rendering the map for certain Category/Usage/Source combinations.

Buildings with missing values

``` B10000 B10001 B10002 B10003 B10004 B10006 B10007 B10008 B10009 B10010 B10013 B10014 B10016 B10019 B10020 B10021 B10025 B10026 B10027 B10029 B10035 B10037 B10039 B10040 B10042 B10043 B10046 B10047 B10048 B10051 B10053 B10054 B10055 B10056 B10057 B10060 B10063 B10064 B10066 B10067 B10068 B10070 B10071 B10073 B10075 B10076 B10077 B10078 B10079 B10080 B10081 B10082 B10083 B10088 B10089 B10090 B10092 B10096 B10098 B10099 B10100 B10101 B10104 B10105 B10106 B10110 B10112 B10114 B10115 B10118 B10121 B10124 B10128 B10129 B10133 B10135 B10140 B10144 B10149 B10156 B10158 B10159 B10161 B10168 B10169 B10175 B10178 B10180 B10184 B10186 B10187 B10189 B10190 B10191 B10196 B10206 B10214 B10215 B10217 B10220 B10223 B10231 B10234 B10236 B10238 B10239 B10243 B10247 B10248 B10249 B10252 B10253 B10258 B10259 B10263 B10267 B10268 B10269 B10276 B10282 B10284 B10300 B10304 B10305 B10310 B10312 B10318 B10319 B10321 B10323 B10325 B10331 B10332 B10336 B10339 B10352 B10362 B10372 B10382 B10383 B10390 B10404 B10411 B10424 B10430 B10436 B10456 B10519 B10523 B10532 B10543 B10547 B10553 B10591 B10607 B10608 B10631 B10642 B10651 B10657 B10662 B10669 B10683 B10693 B10706 B10712 B10715 B10716 B10727 B10730 B10731 B10738 B10751 B10759 B10772 B10775 B10777 B10787 B10822 B10825 B10840 B10842 B10847 B10852 B10853 B10863 B10872 B10873 B10874 B10891 B10896 B10899 B10915 B10936 B10958 B10963 B10964 B10975 B10983 B10993 B11015 B11019 B11024 B11025 B11032 B11036 B11040 B11041 B11043 B11045 B11053 B11062 B11086 B11087 B11089 B11094 B11099 B11100 B11104 B11107 B11112 B11114 B11115 B11119 B11122 B11124 B11125 B11127 B11128 B11132 B11134 B11136 B11138 B11143 B11146 B11148 B11150 B11152 B11153 B11159 B11162 B11170 B11181 B11182 B11188 B11196 B11200 B11214 B11215 B11222 B11223 B11233 B11235 B11241 B11242 B11246 B11253 B11255 B11259 B11261 B11263 B11265 B11273 B11280 B11283 B11297 B11302 B11307 B11313 B11359 B11360 B11363 B11381 B11403 B11407 B11410 B11412 B11413 B11417 B11435 B11438 B11445 B11446 B11450 B11455 B11464 B11478 B11479 B11482 B11487 B11489 B11498 B11507 B11510 B11511 B11514 B11552 B11571 B11585 B11597 B11603 B11621 B11623 B11626 B11633 B11634 B11640 B11646 B11647 B11653 B11658 B11666 B11668 B11676 B11678 B11689 B11693 B11694 B11706 B11724 B11737 B11744 B11751 B11761 B11767 B11770 B11776 B11791 B11792 B11794 B11797 B11799 B11803 B11809 B11812 B11814 B11816 B11820 B11826 B11829 B11835 B11842 B11850 B11854 B11864 B11865 B11867 B11878 B11889 B11893 B11895 B11901 B11904 B11911 B11930 B11932 B11935 B11936 B11943 B11946 B11947 B11949 B11950 B11954 B11965 B11967 B11972 B11974 B11978 B11983 B11987 B11994 B11995 B12001 B12004 B12007 B12009 B12010 B12016 B12018 B12019 B12021 B12023 B12026 B12027 B12028 B12029 B12036 B12047 B12048 B12049 B12053 B12054 B12056 B12057 B12061 B12062 B12063 B12064 B12065 B12066 B12068 B12070 B12071 B12073 B12074 B12081 B12082 B12083 B12085 B12086 B12087 B12090 B12092 B12093 B12095 B12100 B12101 B12102 B12105 B12108 B12111 B12112 B12113 B12115 B12120 B12124 B12125 B12126 B12130 B12132 B12135 B12137 B12141 B12142 B12143 B12147 B12148 B12149 B12153 B12156 B12160 B12165 B12169 B12170 B12175 B12176 B12182 B12189 B12192 B12193 B12194 B12200 B12207 B12214 B12217 B12218 B12219 B12233 B12234 B12235 B12240 B12242 B12244 B12247 B12251 B12253 B12255 B12275 B12276 B12279 B12280 B12286 B12292 B12307 B12309 B12316 B12319 B12329 B12330 B12334 B12337 B12340 B12344 B12348 B12349 B12351 B12352 B12354 B12355 B12356 B12359 B12361 B12362 B12363 B12364 B12368 B12369 B12372 B12373 B12375 B12376 B12380 B12381 B12384 B12386 B12387 B12388 B12390 B12396 B12397 B12410 B12412 B12414 B12418 B12419 B12421 B12423 B12425 B12427 B12428 B12431 B12436 B12437 B12439 B12440 B12441 B12446 B12447 B12448 B12451 B12453 B12456 B12457 B12459 B12460 B12463 B12464 B12465 B12470 B12471 B12473 B12474 B12476 B12477 B12482 B12483 B12484 B12485 B12486 B12488 B12489 B12494 B12495 B12496 B12500 B12501 B12505 B12510 B12514 B12516 B12518 B12530 B12534 B12549 B12565 B12576 B12596 B12604 B12627 B12635 B12636 B12638 B12639 B12646 B12648 B12650 B12652 B12653 B12656 B12658 B12659 B12660 B12662 B12667 B12671 B12681 B12705 B12708 B12714 B12715 B12717 B12729 B12731 B12733 B12746 B12753 B12757 B12761 B12763 B12771 B12773 B12778 B12779 B12781 B12783 B12792 B12809 B12815 B12823 B12827 B12837 B12842 B12845 B12853 B12856 B12859 B12861 B12865 B12875 B12876 B12883 B12887 B12888 B12889 B12898 B12902 B12912 B12916 B12922 B12923 B12939 B12941 B12959 B12965 B12970 B12975 B12979 B12980 B12984 B12986 B12992 B13000 B13008 B13015 B13017 B13020 B13035 B13042 B13045 B13050 B13052 B13058 B13059 B13072 B13076 B13083 B13098 B13103 B13108 B13112 B13113 B13125 B13126 B13128 B13133 B13143 B13151 B13155 B13158 B13167 B13170 B13174 B13179 B13193 B13206 B13207 B13209 B13210 B13221 B13222 B13223 B13227 B13230 B13234 B13236 B13241 B13242 B13243 B13244 B13245 B13246 B13250 B13251 B13252 B13254 B13256 B13258 B13259 B13261 B13264 B13266 B13268 B13269 B13270 B13271 B13276 B13278 B13279 B13280 B13282 B13284 B13285 B13286 B13288 B13292 B13294 B13295 B13297 B13299 B13302 B13303 B13304 B13307 B13308 B13310 B13314 B13316 B13317 B13319 B13326 B13327 B13330 B13332 B13335 B13336 B13340 B13342 B13348 B13349 B13358 B13359 B13363 B13367 B13370 B13373 B13378 B13380 B13384 B13386 B13388 B13395 B13397 B13400 B13404 B13405 B13408 B13411 B13414 B13424 B13425 B13428 B13435 B13436 B13438 B13445 B13455 B13456 B13464 B13465 B13469 B13476 B13481 B13487 B13492 B13496 B13504 B13506 B13508 B13513 B13515 B13522 B13529 B13531 B13535 B13540 B13543 B13544 B13549 B13555 B13556 B13557 B13558 B13565 B13567 B13570 B13577 B13578 B13586 B13594 B13595 B13596 B13597 B13601 B13609 B13610 B13618 B13620 B13622 B13627 B13633 B13635 B13641 B13642 B13645 B13646 B13661 B13664 B13668 B13670 B13672 B13678 B13679 B13682 B13693 B13706 B13707 B13724 B13740 B13741 B13744 B13745 B13749 B13750 B13752 B13753 B13754 B13756 B13757 B13764 B13765 B13766 B13767 B13770 B13772 B13773 B13774 B13775 B13776 B13777 B13784 B13786 B13789 B13791 B13793 B13796 B13797 B13798 B13800 B13804 B13805 B13808 B13809 B13811 B13814 B13819 B13820 B13821 B13824 B13827 B13829 B13830 B13831 B13834 B13835 B13837 B13841 B13842 B13844 B13845 B13847 B13849 B13850 B13852 B13854 B13855 B13857 B13858 B13859 B13860 B13866 B13867 B13868 B13870 B13881 B13884 B13886 B13887 B13902 B13904 B13905 B13906 B13908 B13911 B13915 B13920 B13924 B13926 B13932 B13934 B13941 B13942 B13943 B13948 B13949 B13950 B13953 B13955 B13959 B13964 B13966 B13977 B13981 B13985 B13988 B13990 B13991 B13992 B13999 B14001 B14009 B14025 B14026 B14033 B14037 B14038 B14040 B14046 B14049 B14051 B14060 B14061 B14064 B14065 B14067 B14068 B14071 B14073 B14079 B14081 B14083 B14084 B14085 B14087 B14096 B14097 B14099 B14105 B14123 B14124 B14132 B14137 B14142 B14144 B14145 B14151 B14152 B14155 B14157 B14162 B14164 B14168 B14170 B14172 B14173 B14178 B14181 B14184 B14185 B14187 B14188 B14189 B14192 B14198 B14199 B14208 B14209 B14211 B14214 B14215 B14223 B14227 B14228 B14233 B14234 B14236 B14239 B14249 B14251 B14253 B14255 B14257 B14260 B14263 B14265 B14266 B14267 B14268 B14273 B14280 B14282 B14285 B14288 B14289 B14304 B14316 B14318 B14324 B14325 B14328 B14329 B14336 B14338 B14341 B14344 B14345 B14352 B14361 B14368 B14375 B14381 B14382 B14386 B14390 B14392 B14393 B14395 B14396 B14397 B14399 B14400 B14401 B14402 B14403 B14404 B14405 B14406 B14408 B14409 B14410 B14411 B14412 B14413 B14414 B14417 B14418 B14419 B14420 B14421 B14422 B14423 B14424 B14425 B14426 B14427 B14428 B14429 B14430 B14431 B14432 B14434 B14436 B14437 B14438 B14439 B14440 B14443 B14444 B14446 B14447 B14448 B14449 B14450 B14451 B14452 B14455 B14456 B14457 B14458 B14459 B14460 B14461 B14462 B14463 B14464 B14465 B14466 B14467 B14468 B14469 B14470 B14472 B14473 B14475 B14476 B14477 B14479 B14481 B14489 B14497 B14498 B14500 B14501 B14502 B14504 B14506 B14508 B14510 B14515 B14517 B14518 B14519 B14520 B14521 B14525 B14526 B14528 B14531 B14532 B14535 B14536 B14538 B14539 B14543 B14549 B14553 B14554 B14557 B14560 B14561 B14562 B14572 B14574 B14577 B14580 B14581 B14585 B14586 B14591 B14593 B14594 B14595 B14596 B14597 B14598 B14599 B14600 B14601 B14602 B14603 B14604 B14605 B14606 B14607 B14608 B14609 B14610 B14611 B14612 B14613 B14616 B14617 B14618 B14619 B14620 B14621 B14622 B14624 B14625 B14626 B14627 B14628 B14629 B14630 B14631 B14632 B14636 B14637 B14638 B14639 B14640 B14641 B14642 B14643 B14644 B14645 B14646 B14647 B14648 B14649 B14650 B14658 B14663 B14664 B14665 B14666 B14667 B14668 B14669 B14670 B14671 B14672 B14673 B14674 B14675 B14676 B14677 B14678 B14679 B14684 B14686 B14687 B14688 B14689 B14690 B14691 B14692 B14693 B14694 B14695 B14696 B14743 B14744 B14745 B14746 B14747 B14748 B14751 B14753 B14754 B14755 B14756 B14757 B14758 B14759 B14760 B14762 B14763 B14764 B14765 B14766 B14767 B14768 B14769 B14770 B14772 B14773 B14774 B14775 B14776 B14777 B14778 B14779 B14780 B14781 B14782 B14783 B14784 B14785 B14787 B14788 B14789 B14790 B14792 B14793 B14794 B14795 B14796 B14797 B14798 B14799 B14800 B14801 B14803 B14804 B14805 B14806 B14807 B14808 B14810 B14811 B14812 B14813 B14814 B14817 B14821 B14822 B14824 B14838 B14844 B14845 B14860 B14866 B14867 B14870 B14872 B14874 B14875 B14876 B14879 B14880 B14883 B14884 B14893 B14900 B14901 B14902 B14907 B14912 B14913 B14915 B14920 B14921 B14924 B14926 B14928 B14932 B14936 B14937 B14940 B14942 B14944 B14946 B14948 B14950 B14954 B14955 B14956 B14957 B14958 B14959 B14960 B14963 B14964 B14969 B14970 B14971 B14972 B14974 B14977 B14978 B14979 B14980 B14981 B14982 B14984 B14986 B14988 B14990 B14991 B14992 B14993 B14994 B14995 B14996 B14997 B14998 B14999 B15000 B15001 B15002 B15003 B15004 B15005 B15006 B15007 B15008 B15009 B15010 B15011 B15013 B15016 B15017 B15018 B15026 B15035 B15103 B15123 B15168 B15174 B15179 B15185 B15194 B15214 B15215 B15217 B15225 B15231 B15233 B15234 B15235 B15236 B15238 B15240 B15241 B15242 B15251 B15253 B15256 B15257 ```

[heidimok]

Hi @RicardoGomesIST, if you have the missing values we can make the file update early this week. But since we will no longer display the buildings/municipalities where data is missing, we won't have the "black shading" on the UI in the final version. So even if you don't add the data now, we'll still be able to hand off the application. You could update the data yourself at a later time.

[RicardoGomesIST]

Hi. So the dashboard will not present the values (by not presenting the buildings) just for the selection EnergyConsumption_WTW_buildings? If so, we can leave it like this. In fact, at this stage, we are not so concerned about the data quality but more with the interface, feeding data and visualization. We pretend to revise the values later and yes, in the future a some buildings wont have data for certain columns so it is important to deal with this.

[heidimok]

Ok @RicardoGomesIST we will leave that data as is at this stage. We won't present the black empty shading on the UI.