Duplicate rows in summary tables
Opened this issue · 2 comments
timlinux commented
@gubuntu and @NyakudyaA can you please fix the summary tables for the roads are causing duplicate rows e.g.
timlinux commented
e.g hazard event 212 on staging site / db
lucernae commented
I have fixed the faulty logic in #77 .
However in production the duplicate rows keeps appearing because of wrong assignments in the table record itself.
Take a look at the example below:
The assignment is inconsistent. All these roads have the same village_id, but some roads in a sub_district and another in different sub_district. It doesn't make sense for a village to be in two sub_district all at once.