locked
SQL 2005 - Storing GPS tracking data in a database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all

    I have a requirement to store GPS lat/lon tracking data in a SQL database. I am competely new to GPS and geometry positioning with regards SQL, so have been reading up on the subject. I have also created a SQL database to hold the information (DB is called GPS_Data). However, to begin with, I am still not sure how to get the data into the database. I have tracking units installed on about 60 of our vehicles, which are setup to transmit GPS data every 5 minutes to a specified IP address and port, and this IP and port is for our SQL Server. However, from there, I am not sure how I go about getting the data actually into SQL. Any clues as to where I can look for more info, what I should do, etc??

    Many thanks for all help

    Naz

    • Moved by Olaf HelperMVP Thursday, October 10, 2013 4:04 PM Moved from "SQL Database Engine" to a more related forum
    • Moved by Sofiya Li Monday, October 14, 2013 5:24 AM the right forums
    Thursday, October 10, 2013 4:02 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am not sure how I go about getting the data actually into SQL.

    Hello Naz,

    Do you have programming knowledge's, maybe in .NET? Do you know how to read the GPS data from the (source) server? Exactly, how can we help you to getting started with this; you didn't ask a specific question, so it's hard to tell you how to go on?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, October 10, 2013 4:09 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Olaf,

    Thanks for your quick reply.

    I only have VB and SQL programming knowledge. I have bought a GPS tracking device and installed it into a vehicle. I need to get the GPS tracking data into my SQL database somehow, but I am not sure how :(  I only have the GPS tracking device, and SQL database. I have nothing else to use, so not sure what else I even need to get that data into SQL? There is no other server. I set up the GPS tracking device to transmit the tracking data to the IP address of the SQL Server. But not sure what to do now.

    I am a little lost on this

    Naz

    Thursday, October 10, 2013 4:28 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I set up the GPS tracking device to transmit the tracking data to the IP address of the SQL Server. But not sure what to do now.

    Hello Naz,

    Just sending data to the server, where SQL Server is running, is not enough; there must be "something" which receives the data and writes it to SQL Server.

    To be honest, I don't think it's possible to guide you via some forum post to create a complete solution, especially because the main part of the solution will be .NET development and not on SQL Server side.

    You may should consider to contact a freelancer / consultant to help & assist you implementing such a solution.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by SathyanarrayananS Friday, October 11, 2013 9:38 AM
    • Marked as answer by Sofiya Li Thursday, October 17, 2013 9:28 AM
    Thursday, October 10, 2013 4:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ANSA_Naz

    If you would like to store data from GPS watch into a SQL Server 2005 database, we need to note the data type in SQL Server 2005.
    There are several links for calculating Latitude/Longitude distances you may refer to:
    http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/sql-server-zipcode-latitude-longitude-pr
    http://www.johnsample.com/articles/GeocodeWithSqlServer.aspx

    There is a new data type named geography in SQL Server 2008, which can be used to store latitude and longitude coordinates. So you can also consider using SQL Server 2008. Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries, roads, or lakes.

    For more information, you can review the following article.
    Spatial Data (SQL Server): http://msdn.microsoft.com/en-us/library/bb933790.aspx
    Getting Started with the geography Data Type
    http://msdn.microsoft.com/en-us/library/bb895266.aspx

    Thanks,
    Sofiya Li

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    • Marked as answer by Sofiya Li Thursday, October 17, 2013 9:27 AM
    Monday, October 14, 2013 6:05 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi ANSA_Naz,

    Can I ask what device you're using to transmit to data in the first place?

    Thanks :)

    Saturday, November 30, 2013 7:41 PM