I'm new to the GIS world, and I'm trying to work out what tool I should start with in order to analyse some data and run custom spatial queries on it.
I have a data set representing the recording of a construction site vehicle and its activity over a period of time. Each record in the data contains such fields as lat/long, timestamp, and various parameters describing what activity the vehicle was performing at that particular point in time.
Without spending weeks developing my own tool, I would like to be able to display a map, select a start and end time (to filter out the relevant records), and render a trace of where the vehicle went and somehow indicate what it was doing where. Eg, it may be a grader machine, and I simply want to display whether the blade was engaged to the ground or not (on/off). Maybe just green points where it was engaged, and red points where it was not.
I'd also like to be able to run some spatial queries, eg within a certain bounding box, how much time was spent with the blade engaged to the ground. Or how far did the vehicle travel during a certain time period, and for how much of that distance was the blade engaged. Simple queries like that.
A bonus would be if I could achieve an animation of the activity, ie a play-back of the vehicle moving and plotting its route and activity, but this is not necessary.
Could I achieve this with something like QGIS, or what tool would you recommend, if any?