Build a Website using Google Maps and SQLite

The Zeus WEB system is a small application, which has three basic functions as described below, 1. The first function is to listen on a TCP port for incoming data records, which will be sent from Smartphones. This data is in the same format as the SQL table called “Device_Transactions” (see at end of this document). Each of these records of data will be written to the SQLite database (see SQL at the end of this document). 2. The second function is search the database by a specific “User Name”, locating the most current record and displaying the user’s position (Latitude and Longitude) on a view of Google Maps. If the user wants history, then a selection box will allow the user to select the last 1 day, 1 week, or 1 month of history showing each record as push pins on Google Maps. The user can double click on a pushpin, and then the details (Lat/Long, date/time, etc.) of that location will appear. A “+” and “-“ in the lower right hand corner will allow for zooming in or out of the map. Alternately, instead of the “+” and “-“ a vertical zoom control can be used. 3. The third function is providing Users who have the User Type of “A” for administrator, to maintain the tables “User”, “Yacht” and “Icons”. A simple row/column format will allow for adding, deleting and modifying the data in these tables.