OpenUpSA/wazimap-ng

New Relationship

Opened this issue · 0 comments

We need to introduce a new Many2Many relationship.

Between Location and GeographyBoundary
The geo query for getting locations inside a boundary is too slow for our production use case.
Therefore we need to model that geographic relationship ourselves. Which is not that big off a deal.

Locations have many GeographyBoundaries (they can be in different sub level boundaries, e.g. state and district, etc)
And Boundaries have many Locations.

This will make the queries a lot faster.