inasafe/inasafe-fba

Duplicate rows in summary tables

Opened this issue · 2 comments

@gubuntu and @NyakudyaA can you please fix the summary tables for the roads are causing duplicate rows e.g.

image

e.g hazard event 212 on staging site / db

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:

Screen Shot 2020-03-05 at 00 06 54

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.