Discussion and implementation of location table in backend

andrewtavis commented 9 months ago

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 commented 9 months ago

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

andrewtavis commented 8 months ago

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

activist-org / activist