Storing GPS data in an SQLite database?

Lordsnoutimus · by **Lordsnoutimus** » Thu Mar 04, 2010 9:15 pm

Hi,

This is from another thread, but I am trying desperately to store GPS latitude and longitude data within an SQLite database.

I have created a SQLite database in a separate class to my main activity and I am using this below when the location updates:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 
   public void onLocationChanged(Location loc) {
 
        Log.e(TAG, loc.toString());
 
        ContentValues values = new ContentValues();
 
        Double lon = loc.getLongitude();
 
        Long time = loc.getTime();
 
        values.put(GPSData.GPSPoint.LONGITUDE, loc.getLongitude());
 
           values.put(GPSData.GPSPoint.LATITUDE, loc.getLatitude());
 
           values.put(GPSData.GPSPoint.TIME, loc.getTime());
 
        getContentResolver().insert(GPSDataContentProvider.CONTENT_URI, values);
 
      }
 
Parsed in 0.032 seconds,  using GeSHi 1.0.8.4

Apparently this line is throwing an error:
and the Double long and long time are not being read? does this matter?

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

getContentResolver().insert(GPSDataContentProvider.CONTENT_URI, values);
Parsed in 0.030 seconds,  using GeSHi 1.0.8.4

i_raqz · by **i_raqz** » Sun Mar 21, 2010 11:55 pm

hi..did you find any solution for that? i am trying to save the co-ordinates in an array/file ...actually send it over a socket to some other machine..any suggestions?

Lordsnoutimus · by **Lordsnoutimus** » Mon Mar 22, 2010 1:39 am

Hi i_raqz,

I gave up with the Content Provider in the end. I couldn't find the problem and I didn't actually need to implement a contentprovider as my application doesn't need to share data with another application.

Instead, I created a database:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

 
public class WaypointsData extends SQLiteOpenHelper {
 
        private static final String DATABASE_NAME = "waypoints.db";
 
        private static final int DATABASE_VERSION = 2;
 
        //helper object for database
 
        public WaypointsData(Context ctx) {
 
                super(ctx, DATABASE_NAME, null, DATABASE_VERSION);
 
        }
 
         @Override
 
           public void onCreate(SQLiteDatabase db) { 
 
              db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID
 
                    + " INTEGER PRIMARY KEY AUTOINCREMENT, " + LONGITUDE
 
                    + " INTEGER," + LATITUDE + "  INTEGER," + TIME
 
                    + " INTEGER );");
 
           }
 
        @Override
 
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
 
        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
 
        onCreate(db);
 
        }
 
}
Parsed in 0.039 seconds,  using GeSHi 1.0.8.4

And just used a cursor to retrieve the data I wanted directly:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

private Cursor getWaypoints() {
 
                        SQLiteDatabase db = waypoints.getReadableDatabase();
 
                        Cursor cursor = db.query(TABLE_NAME, FROM, null, null, null, null, ORDER_BY);
 
                        startManagingCursor(cursor);
 
                        return cursor;
 
                }
Parsed in 0.035 seconds,  using GeSHi 1.0.8.4

If you are planning on distributing the GPS coordinates to a webserver or something similar, using a database is probably easier, and then using the Android HTTP class. If you have any more questions about the database, I can help you out.

i_raqz · by **i_raqz** » Mon Mar 22, 2010 2:05 am

Hi Lordsnoutimus,

Thanks for the reply. Well, I am trying to send the GPS co-ordinates to my webserver through sockets (not android http - we are on the same side

). But I am unable to store the gps co-ordinates in a variable/array/object or anything like that. The app crashes. Could you please tell me how do I save and then send it through the socket.
Please check the below link for then entire code that I wrote. Thanks.

my post on google group

Storing GPS data in an SQLite database?

Storing GPS data in an SQLite database?

saving gps location

Who is online