City Radii Project

As part of our efforts to monitor hate speech, we search for problematic content which has been geotagged by users, and then we use those geocoordinates to determine levels of hate speech in certain countries. Where this becomes difficult is when we narrow the focus to urban areas, since we don't have an easy way of establishing that any given set of geocoordinates is within the municipal boundaries of a certain city. (While we can do reverse geocoding, this is a processing-intensive endeavor which can still result in ambiguous place names and can be extremely (financially) expensive depending on the cartographic provider.)

As an alternative solution, we've begun using the average radius of certain cities to do counts of hate speech (e.g. there are X incidents within a 10 km radius of city center). To make this more efficient, we need to add radii to our Cities table.

The purpose of this project is to provide either the radius or the area of the geographic center of each city listed in our Cities table. Providing the area is probably the easier approach, since the radius can then be calculated from area using some algebra.

As a bonus, we'd also like to:

  • Add current population to our Cities table so that we can contextualize volume of incidents against number of people
  • Add a RegionID wherever possible by cross-referencing with our Regions table


Spreadsheet


I want to tackle this project Check out other projects first