Abstract: Techniques for storing and retrieving content associated with a specific geographic location include identifying discrete regions included in a bounding region and initializing a list of discrete regions and a count of identified local content. For each identified region: determining a number of content items included in the region; updating the region list with an ID of the identified region if it contains at least one content item; and adding the determined number of content items to the count of identified local content. Deciding whether to proceed to a next identified region includes determining if unprocessed regions remain and if a predetermined content limit was reached. The next region is then processed if there is a next region and the content limit has not been reached. The regions are processed, content IDs for content items associated with processed regions are located in a content database for further selection or serving.

Abstract: A system and method are disclosed including determining structured information sources that a local business participates in based on a common set of features that identify the business, collecting user interaction information from the structured information sources, aggregating the collected user interaction information into a set of attributes that are common across the structured information sources, storing local business location and the aggregated user interaction information for the set of attributes into a local business database, receiving a request from a mobile device for an ad including a geographic location, determining a geographic region that contains the geographic location, retrieving a set of local businesses from the local business database having locations within the region, determining distance values between the geographic location and the business locations, retrieving a subset of attributes for the aggregate user interaction information from the database, constructing feature vectors i