1 / 11

CSCI 572 Project: Geo-spatial Search Engine

CSCI 572 Project: Geo-spatial Search Engine. By Liqiang Cheng, Naiqi Jin and Jason Yap. Project Description. Project summary: A Geo-spatial search system that collects and combines data from various sources into a single searchable repository. Goals:

zudora
Download Presentation

CSCI 572 Project: Geo-spatial Search Engine

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. CSCI 572 Project: Geo-spatial Search Engine By Liqiang Cheng, Naiqi Jin and Jason Yap

  2. Project Description • Project summary: A Geo-spatial search system that collects and combines data from various sources into a single searchable repository. • Goals: • Collect data about locations of interest from multiple sources. • Provide a User Interface that allows a user to query a geographic area for interesting locations. • Satisfy queries efficiently (results returned in real time).

  3. Architecture User (Web Browser) External Sources User Query Results Yelp.com Web Server Crawler Upload Query Crawled Results Update DBMS & Index Translated Index Query Result Set Urbanspoon.com Data Repository and Spatial Indexes

  4. Crawler urbanspoon.com yelp.com

  5. Crawler • two data sources • yelp.com • urbanspoon.com • crawling several postal codes around USC • information crawled • name • address • URL • latitude, longitude • average review (1-100 points) • number of reviews

  6. Example Crawled Results yelp.com

  7. Indexing and Retrieval • MySQL Spatial Index was used to index locations for efficient querying. • MyISAM tables specified with “SPATIAL INDEX” create an R-tree index which supports efficient range queries. • GPS coordinates for each location was extracted by the crawler and registered with the DBMS and index through the Upload component. • To generate a query for retrieval, a user specifies points of a polygon which translate to GPS coordinates. A Minimum Bounding Rectangle(MBR) specifies the area for the DBMS query in SQL.

  8. User Interface • Advertisement module - Commercial scrolling advertisement and propagation such as facebook and twitter. • Geo-spatial Search module (Primary UI) - Conducting search query by drawing polygon. - Google maps presentation ordered by Name, Rating, Type or Votes No. (Different type has different color indexed Marker) UI (Web Browser) Advertisement Geo-spatial Search

  9. User Interface

  10. User Interface OrderBy Number of Votes OrderBy Average Rating Facebook popularization OrderBy Average Rating

  11. Demo • Website: • http://mslab11.usc.edu:8080/cs572/

More Related