Page 6 of 8 FirstFirst 12345678 LastLast
Results 51 to 60 of 78

Thread: My first CarPC in my Subaru Legacy (Estate) - With LED sign!

  1. #51
    Newbie
    Join Date
    Apr 2007
    Posts
    32
    A LED suggestion that i've always wanted to develop myself but dont' have the know-how would be this.

    A digital measuring device would keep track of the distance of the car behind you. Then taking into consideration how fast both cars are moving the LED sign would flash up to the driver behind you that they are following you to close. Hopefully causing them to back off. I'm sure you could come up with something awesome like that.

  2. #52
    Low Bitrate AvWuff's Avatar
    Join Date
    May 2008
    Posts
    74
    Hi PinPoint,

    That is a neat idea, but probably not worth the cost of an expensive sonar or other rangefinding system.. Since I check my rearview while driving every 3-5 seconds anyway, I could just have a button to flash "Back Off" or something :-)
    Read about my Car PC at www.avbrand.com/projects/carpc -- LED sign now functional!

  3. #53
    Maximum Bitrate
    Join Date
    Dec 2007
    Location
    Iowa
    Posts
    610
    Hey AvWuff, I know this almost a dead thread about now but i've checked out ur site and i love your gps tracking and the site that lets you see where your car is located. I'm interested in implementing this to run in the background. Any thoughts? How difficult was this?

  4. #54
    Low Bitrate AvWuff's Avatar
    Join Date
    May 2008
    Posts
    74
    Hi Bxsteez,

    It wasn't very difficult at all. Basically, I have a MySQL database running on the Car PC with two tables: "trips" and "gps". The Trips table contains "trip" information -- that is, each drive from point A to point B is a "trip". The software automatically creates a new trip if the car is started more than 10 minutes from the last event of the previous trip.

    The "gps" table basically contains latitude, longitude, trip ID, date & time, and speed. A new record is added to this table every 2 seconds while the car is running.

    Because keeping the data in the car isn't very useful, when I arrive back home, my software "syncs" this trip & gps data with my web-based MySQL server. For each trip, there's a flag "synced", and if that flag is false, it simply copies all of the GPS records over to the remote database, and then sets the flag.

    The final part of the equation is displaying the data. That's pretty simple -- the trips table turns into the listbox that lets you select which trip you'd like to view, and when you select a trip, all of the points are loaded into a GPolyLine (part of the Google Maps API).

    Then there's some extra stuff so that you can click on the line to see the date & time at that point, and the speed... data that is just pulled from the database.

    The "Live" position reporting works in much the same way -- except it uses the internet connection in the car. It simply calls a script on my webserver with the current latitude and longitude every few seconds, and the server stores that info in the database and can then generate a map to display that information live.

    Good luck,
    -av
    Read about my Car PC at www.avbrand.com/projects/carpc -- LED sign now functional!

  5. #55
    Maximum Bitrate
    Join Date
    Dec 2007
    Location
    Iowa
    Posts
    610
    This is what i thought but my problem is getting the information to the website to update the position. I'm new to webpage development so maybe it is simple and i just don't realize it.

  6. #56
    Low Bitrate AvWuff's Avatar
    Join Date
    May 2008
    Posts
    74
    You need to have skillz in some kind of server-side scripting language (ASP, PHP, something like that) and a place to store the data server-side (such as a database).

    I'm sure you'll figure it out. If not, there's a bunch of services online that do this sort of thing for you.
    Read about my Car PC at www.avbrand.com/projects/carpc -- LED sign now functional!

  7. #57
    Maximum Bitrate
    Join Date
    Dec 2007
    Location
    Iowa
    Posts
    610
    Thats what i'm trying to pick up. I think i can write the webpage in java since i did some research on the google api and i think i can make the map page with no problem but i'm trying to find info on how to upload the gps info from the com port to the webpage. I wondered if i just stored it in a file and then send the file to the server. I'm not sure how efficient that would be if i want it to be updated at a decent rate. What do you think?

  8. #58
    Low Bitrate AvWuff's Avatar
    Join Date
    May 2008
    Posts
    74
    No, no, basically you need a program running on the car PC that can open the com-port and read the NMEA data, and every 10 seconds or so, call a URL like this one:

    http://www.yourserver.com/your/web/p...&long=-78.3332

    with the numbers there replaced with the actual numbers

    Then, in your php/java/whatever page, you look for those values coming from the URL string and store them in the database. It's not that hard to do server-side.

    -av
    Read about my Car PC at www.avbrand.com/projects/carpc -- LED sign now functional!

  9. #59
    Maximum Bitrate
    Join Date
    Dec 2007
    Location
    Iowa
    Posts
    610
    Interesting... I'm looking into PHP. This is probably gonna take me a while lol.. I know how to write in C and C++ but i've never written in java or php. Do you know if the google api can be used in php or is it just java?

  10. #60
    Maximum Bitrate
    Join Date
    Dec 2007
    Location
    Iowa
    Posts
    610
    Ok i think i have a handle on thhis MySQL database thing. Enough to start writing code. Quick question. How do you get the information to the database? Basically how do i setup a url that will store information into the table of the database?


    ****NEVERMIND... i'm such an idiot lol****

Page 6 of 8 FirstFirst 12345678 LastLast

Similar Threads

  1. subaru legacy mounting problems
    By DarkFox1 in forum Fabrication
    Replies: 7
    Last Post: 04-02-2007, 12:18 PM
  2. Subaru Legacy GT Limited Install Complete
    By xcntrk75 in forum Show off your project
    Replies: 14
    Last Post: 03-09-2006, 01:32 PM
  3. 1992 Subaru Legacy Turbo
    By Splinter in forum Show off your project
    Replies: 11
    Last Post: 01-21-2006, 03:15 PM
  4. LED sign random idea
    By hijinks21 in forum General Hardware Discussion
    Replies: 16
    Last Post: 10-18-2005, 10:32 AM
  5. Carputer | n00b | 91' Subaru Legacy RS
    By bones in forum Newbie
    Replies: 4
    Last Post: 07-10-2005, 10:09 PM

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
  •