Discussion and implementation of location table in backend

[andrewtavis]

Terms

• [X] I have searched open and closed feature requests
• [X] I agree to follow activist's Code of Conduct

Description

A final table that's needed for the early stages of activist is the location table. Schemas for this can be found in the designs on Figma, but the current table is not reflective of what's needed.

For this issue we need to decide on:

• Where the location data should come from
• What columns will be in the end table with the schemas then being updated

From there we can move on to implementing this in the backend 🚀

Contribution

Would be great to get some ideas from people on how best to implement this!

[andrewtavis]

Ping @to-sta, @wkyoshida and @momanyisamuel for the base conversation for this 😊

[andrewtavis]

Note that for the new map component we're making direct API requests against Nominatim for this, so the structure of this table should reflect some of the responses we're getting at least partially. An example:

https://nominatim.openstreetmap.org/search?q=Brandenburg%20Gate%20Berlin&format=json