Odd US Cities

For reasons unknown, there are a few thousand locations in the patentsview database where value in the city field looks more like a street. This page is sending in a get request to the locations endpoint with the following parameters:

q={"_and":[{"location_country":"US"}, {"_contains":{"location_city":" Ave"}}]}
&f=["location_total_num_patents", "location_state", "location_country", "location_latitude", "location_longitude", "location_city","location_id"]
&s=[{"location_state":"asc"}, {"location_city":"asc"}]
&o={"per_page":100}

The map below is initially centered on Indianapolis. To display the map centered on one of the weird cities, click on the corresponding radio button and then click the "Center Map" link. Clicks on the location_id will show the raw data from the locations endpoint for that id below the map. This phenomenon does not seem limited to the US; other countries have similar rows as shown here.

Null States   Center Map
#CityStateCountry latitude longitudelocation_id
Requesting data from Patentsview. Results will appear here in a few seconds!