This is really new territory for me (I am a radio guy) I am going to
do some AVL work, I need to capture data into a database, that data
will be read into mapping machines in order to track the vehicles.
I see that I have available two database products on my RedHat machines,
MySQL and PostGRES.
What of these or what other db should I use for this sort of activty.
At present there will be the following data fields in the db.
ID, Lat, Lon, gps_time, time_received, status, additional data
gps_time is the time that the record was generated in the vehicle
received_time is the time it is entered into the database
status is a code that would change if some event (panic button,
inertia switch, open door, etc) is activated, and additional data is
other data the remote end can send to the database.
Chuck Hast
------------------------------------------------------------------------
Telecomms Consultant, Utility Partners.
WEB www.utilpart.com
Office number: 813.282.8828 x 1175
C-phone number: 813.765.6743
E-mail: wchast@utilpart.com
SMS < 150 characters: 8137656743@mobile.att.net
ARS KP4DJT
To paraphrase my flight instructor;
"the only dumb question is the one you DID NOT ask resulting in my going
out and having to identify your bits and pieces in the midst of torn
and twisted metal."
*****************************************************************
This e-mail and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom it is
addressed. If you have received this transmission in error, please notify
the sender immediately and destroy any hard copies you may have printed and
remove all copies of the e-mail from your hard drive. Opinions, conclusions
and other information in this message that do not relate to the official
business of Utility Partners, Inc shall be understood as neither given nor
endorsed by it.
Visit us on the web at http://www.utilpart.com
*****************************************************************
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:10:03 EDT