Given 3 tables:
Bitcoin_News_Events
Regions
Locations
I would like to see the output of two joins:
- Bitcoin_News_Events + Region
- Bitcoin_News_Events + Locations
As a for instance, the recent article about Russia "banning" bitcoin circulation would highlight the region of russia on a map.
When articles mention US states that have protected bitcoin ownership, those articles would be retrievable from a region lookup.
Tools that might be used to implement this site:
- Postgresql
- PostGIS https://postgis.net
- Open Layers https://openlayers.org/