GPS Tracking Data

[navex]

Can anyone help me develop a solution as follows?
Scenario is for trucking industry, where several units Pick up and deliver freight, along the way, there are Refueling, Fuel Stops, Exchange of freight i.e. swapping trailers between trucks and etc
Scope is to monitor and collect movement data through GPS Tracking installed in Trucks. A GPS Tracking report of Start/Stop is available in CSV format which has columns
TRUCK NUMBER, DATE, TIME, ADDRESS, MILES etc
The data gives all the start and stops made by the truck, this includes stops in traffic and signals and etc considered as non relevant stops. Relevant stops are Pick up, Delivery, Fuel, Drop Trailer, Hook Trailer, any unauthorized deviation and etc.... List available
What I am looking to develop is a database where GPS Start/Stop report can be entered along with a similar manual feed for trucks with out GPS, then a person go through all the stops and Tag each relevant line ignoring non relevant stops. Then be able to extract the relevant stops in CSV format.
I am currently doing it with Excel, but connecting end of report with the next day's begging of GPS Start/Stop report is difficult and prone to mistakes.


Anybody interested in developing please let me know and I will explain further and provide the current Excel Worksheet

Thank you

[Micron]

I think we'd all like to see a bit of csv data for a start, so we can see if it's rows or columns or just pure csv. It seems like the approach would be to repeatedly add normalized data to an Access table, and have a table that lists (not in columns) the relevant stop types so that only the ones you want will appear in the report. This would negate the need for manually flagging the records with relevant stop values. That table would also provide only the relevant the stop type values for data input.

Maybe explain the project in greater detail at some point (perhaps after people here have had a look at the data). F'rinstance, why would the final output need to be csv formatted? Maybe it would be simpler if Access could modify your initial csv data instead of grabbing/converting/storing/editing/converting/outputting.

[orange]

I agree with micron that more info about the project is needed to offer focused advice.
What experience do you have with?
- the data
- Access

What exactly is the objective/goal of this project?

If you get GPS data in csv format, it would seem to be historical (that is not current) data. So what to do with this data?

Do yourself and readers here a big favor --write a clear, simple English description of the business/processes involved --avoid jargon and quasi - database terminology. People here are willing to help, especially if you are giving active effort.

Describe a day or week in the life of your business. Start at the 30,000 foot overview and gradually add detail. We need to understand the issue/opportunity in context and we need to know more about you (since this is your first post here) and how well you understand the issue and approach to a solution.

There is a database dealing with vehicles and lat/long in post #15 in this thread
It doesn't deal with your data specifically, but you may get some ideas from it.

Also, I recall a thread dealing with trucking and google maps (lat/long positions)
It may have some info for you???

Good luck with your project.