We are a small company specialising in logistic systems. For a customer we are looking into the possibility of visualising the traffic flow in its logistic system by means of a website.
The website would show a picture of the layout of the system and routes that logistic items have followed in the system.
Logistic data points are stored in a database in a table with this layout:
1 - unique id
2 - timestamp
3 - logistic item id
4 - tracking point id
In a separate table the position of all logistic points relative to a fixed point is given:
1 - unique id
2 - logistic item id
3 - x coordinate
4 - y coordinate
Features we want to see (or be convinced that it's not possible :-):
- map of system with pan and zoom features like in Google Maps
- data point visualisation of a route of a logistic item (uniquely identified by logistic item id) through the system. A route is made up of all data points of a logistic item and connections between the points based on the sequential order (timestamp) in the data points table
Table datapoints contains these records:
The above records would give this: points 1, 2 and 3 would be shown on the picture in the correct location based on the x and y coordinates and lines would have to be drawn between item 1 & 2 and between item 2 & 3. This gives the path the item followed through the system.
A proof of concept is what we are looking for first. The concept should be able to scale up to display 1000 tracking points and 20000 lines simultaneously while not slowing down too much in drawing the picture (is this too much?).
Wish/bonus: show frequently travelled routes as thick lines and less frequently travelled routes as thin lines. "Thick" and "thin" should be determined based on the frequencies of the routes.
Looking forward to hearing from you and please do contact us if this is unclear. We will update the description based on answers to your questions. We found a picture on the internet showing what we have in mind.
We are not sure what to expect in terms of pricing/budget, this also depends on the quality of the solution.