Results 1 to 4 of 4

Thread: OSM Backend for Point of Interest Searching

  1. #1
    licensed to kill - FKA kev000
    Auto Apps:loading...
    tripzero's Avatar
    Join Date
    Aug 2006
    Location
    16.40618, 120.61106
    Posts
    2,560

    OSM Backend for Point of Interest Searching

    RATIONAL:
    I'm annoyed by Google's and other's terms of service related to map searching. You really can't do anything useful with Google's search unless you are always connected. You can't save the results for offline use and thus cannot create bookmarks derived from locations you find via a Google map search. To get around this problem, I'm writing an app that will export all the points of interest in the OpenStreetMap project into a database that we can do location based searching on. Best of all, we can actually save the data in the form of bookmarks.

    Right now, I'm just dumping all the named nodes into a table. Named nodes are things like "taco bell" with coordinate data and other things related to it. So far, OSM has almost 4 million named nodes. Many of them are street names and city names, and others still are bike and hiking trails. But there are still quite useful. This is the data i'm storing in the database:

    Code:
    id
    label
    latitude
    longitude
    address
    Search will be location and radius based. So you'll be able to do a simple query and get nice results:

    Code:
    SELECT * FROM PointsOfInterest WHERE label LIKE '%taco%' AND latitude < 123.456 AND latitude > 123.546 AND longitude < 49.3243 AND longitude > 49.3122
    This should return a bunch of mexican restaraunts for the given rectangular are.

    Whats finished:
    I've got code that will generate the database. I'm working on optimizing it so it's fast. I want to be able to do monthly sync's with OSM to keep the database up to date.

    I'm able to parse the entire planet in a couple hours. Like I said earlier, almost 4 million points of interest. Hopefully we can grow that.

    TODO:
    Obviously, a web service needs to be created to take advantage of this data. Also, any client needs to know what to do with the data. For LinuxICE, I'll have a client made that will integrate this with navit.

    Also, I want to be able for users to add points of interest and contribute that up to OSM. If anyone is interested in helping me do that, that'd be great.

    In the future, I want to add tables for streets. This will allow us to do actual address searching.
    Former author of LinuxICE, nghost, nobdy.
    Current author of Automotive Message Broker (AMB).
    Works on Tizen IVI. Does not represent anyone or anything but himself.

  2. #2
    Admin. Linux loser.
    Auto Apps:loading...
    Bugbyte's Avatar
    Join Date
    Sep 2004
    Location
    Corning, NY
    Posts
    7,364
    Blog Entries
    2
    Good stuff. Maybe the service can provide an option to store some favorites for POI's. I think we could let the web interface provide a way to enter your favorites and manage them (e.g. "Taco", or "gasoline"). The POI service could have a method to pull those favorites and send them to your client.
    Quote Originally Posted by ghettocruzer View Post
    I was gung ho on building a PC [until] just recently. However, between my new phone having internet and GPS and all...and this kit...Im starting to have trouble justfiying it haha.
    Want to:
    -Find out about the new iBug iPad install?
    -Find out about carPC's in just 5 minutes? View the Car PC 101 video

  3. #3
    Raw Wave
    Auto Apps:loading...
    justchat_1's Avatar
    Join Date
    Jul 2008
    Location
    Boston, Ma or NY,NY
    Posts
    2,359
    This might be a stupid question but if the data is coming from OSM...the same data source as navit....why have an online database? wouldn't the data already exist locally?

    Aside from that.....great idea!! I think thats one of the big shortcomings of OSM data..I almost wish there was a separate open POI project to build the database. Which actually reminds me.. there are a few POI communities that maintain independent CSV lists you might want to import also.

  4. #4
    licensed to kill - FKA kev000
    Auto Apps:loading...
    tripzero's Avatar
    Join Date
    Aug 2006
    Location
    16.40618, 120.61106
    Posts
    2,560
    Quote Originally Posted by justchat_1 View Post
    This might be a stupid question but if the data is coming from OSM...the same data source as navit....why have an online database? wouldn't the data already exist locally?

    Aside from that.....great idea!! I think thats one of the big shortcomings of OSM data..I almost wish there was a separate open POI project to build the database. Which actually reminds me.. there are a few POI communities that maintain independent CSV lists you might want to import also.
    I plan on using the database locally as well. I think it would be great to use online for what bugbyte is alluding to in his question: saving bookmarks and setting your destination from an interface before you get into the car.

    I would love to import any other poi's. I would want to push them if possible to OSM though. When I get the initial db created, I'll work in importing other sources.
    Former author of LinuxICE, nghost, nobdy.
    Current author of Automotive Message Broker (AMB).
    Works on Tizen IVI. Does not represent anyone or anything but himself.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •