City Regionalization Project

As part of our efforts to monitor hate speech, we use look-up tables of cities, regions and countries to help search for problematic content which has been geotagged by users. Currently, our Cities table doesn't contain RegionIDs, but our Regions table does, so we're looking for someone who can find a way to cross-reference the two to assign RegionIDs to each of approx. 10,000 cities. The screenshot below shows the data we're trying to acquire.


Cities Table Regions Table
 
Spreadsheet            Spreadsheet


I want to tackle this project Check out other projects first