public ArrayList<Campsite> getCampsites() {
String query = "SELECT * FROM " + TABLE_CAMPSITES;
ArrayList<Campsite> campsiteList = new ArrayList<>();
String name;
String city;
String feature;
String favorite;
int rating;
double latitude;
double longitude;

SQLiteDatabase db = this.getWritableDatabase();
Cursor cursor = db.rawQuery(query, null);

while (cursor.moveToNext()) {
name = String.valueOf(cursor.getString(cursor.getColumnIndex("name")));
city = String.valueOf(cursor.getString(cursor.getColumnIndex("city")));
feature = String.valueOf(cursor.getString(cursor.getColumnIndex("feature")));
favorite = String.valueOf(cursor.getString(cursor.getColumnIndex("favorite")));
rating = cursor.getInt(cursor.getColumnIndex("rating"));
latitude = cursor.getDouble(cursor.getColumnIndex("latitude"));
longitude = cursor.getDouble(cursor.getColumnIndex("longitude"));

campsiteList.add(new Campsite(name, city, feature, favorite, rating, latitude, longitude));
}
cursor.close();
return campsiteList;
}