search

ward-wise / ward-wise-front-end

6 stars 4 forks source link

Add geometry data to ward_spending_item table #90

Open smacmullan opened 2 months ago

smacmullan commented 2 months ago

ward_spending_item and the geometry data are in two separate tables, but can be linked via the geocodeId and multiLocationId (multilocationId -> mapping table -> geometry). We should add a new column in ward_spending_item for the geometry data and use the IDs to merge the tables into one.