search

inasafe / inasafe-fba

Next generation of InaSAFE that includes support for forecast based action
MIT License
1 stars 8 forks source link

Duplicate rows in summary tables #56

Open timlinux opened 4 years ago

timlinux commented 4 years ago

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

image
timlinux commented 4 years ago

e.g hazard event 212 on staging site / db

lucernae commented 4 years ago

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.