I can now reveal some first screenshots of the Android PCDB Waypoints app.  This is making great progress, and most of the important tables and supporting screens have now been ported from MS Access to Android and SQLite.  Most importantly, I can import the Access database tables, so PCDB Waypoints is getting a good deal of scaled-up testing.  That includes 344 routes, 2182 waypoints, 580 charts and 510 "places" (starting points or destinations).
This is the current startup screen.  It provides options, via buttons on the left-hand side, to display other information, but contains some basic stuff about the currently selected boat, which is used to calculate estimated times for routes and voyages.  It also uses the tablet's GPS to display the current position, which in this case is rather far from the sea!  Note that the position is displayed via a new Android widget called LatLong, which takes into account the user's desired representation (LLD, LLDM, LLDMS) and automatically handles changes to the components of a position to deliver merely the updated latitude and longitude values back to the App.  It saves the app from having to take these values apart to update the degrees, minutes, seconds and N/S or E/W buttons.

This shows a selected voyage, with its dates.  Note the list of available voyages on the left hand side.  Not also the ComboBox used to pick the boat on which the voyage will or did take place; this is an upgrade on the pseudo-ComboBoxes used in the current version of PCDB SuDoku Solver and fully supports a "not in list" capability as a callback.

This screenshot shows the details of a waypoint, in this case one I used on a trip to Ireland a few years ago.  Again, not the use of the LatLong widget to display the waypoint's position and support changes to it.  Also ComboBoxes for the waypoint's type (Icon) and the Folio, or geographic area, in which it lies.

This shot shows the list of waypoints associated with a route, in this case from East Ferry marina in Cobhto Kinsale which is the culinary capitol of Ireland.  It includes the "Cork 7" waypoint shown above.  Each waypoint is shown with its distance and bearing from the previous one, and the total distance is shown at the top.
There's more work to do yet on the presentation and layout of this screen, bu the data is there.

So it's well on the way.  Hopefully this app will be working and robust to support our trip to the Antrim coast later this summer!

09/28/2013 2:02pm

Great post, thank you.


Leave a Reply.