Want to see track positions and line based on date range

want to see trackers(track lines and marker) between a date range on open street map.this image is somewhat similar

.
Basically want to store all positions on database and retreive them based on date rangespecified.

[{"id":"2b37e271.f8384e","type":"tab","label":"Flow 5","disabled":false,"info":""},{"id":"38b49374.f6d47c","type":"inject","z":"2b37e271.f8384e","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":60,"wires":[["7b9e6f04.dd4fc"]]},{"id":"a3b6babd.4f4208","type":"debug","z":"2b37e271.f8384e","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":710,"y":160,"wires":[]},{"id":"7b9e6f04.dd4fc","type":"http request","z":"2b37e271.f8384e","name":"","method":"GET","ret":"bin","paytoqs":"ignore","url":"https://miapp.ca/GTFS_RT/Vehicle/VehiclePositions.pb","tls":"","persist":false,"proxy":"","authType":"","x":250,"y":120,"wires":[["cf2739cf.edd338"]]},{"id":"cf2739cf.edd338","type":"gtfs-feed","z":"2b37e271.f8384e","name":"","x":430,"y":140,"wires":[["21f26eed.c651a2"]]},{"id":"21f26eed.c651a2","type":"change","z":"2b37e271.f8384e","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"payload.entity.vehicle","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"$map(\t   msg.payload,\t   function($v, $k, $a) {\t       {\t           \"trip_id\": $v.trip.trip_id,\t           \"id\": $v.vehicle.id,\t           \"latitude\": $v.position.latitude,\t           \"longitude\": $v.position.longitude,\t           \"current_status\": $v.current_status,\t           \"timestamp\": $v.timestamp,\t           \"name\": $v.vehicle.id,\t           \"label\": $v.vehicle.label,\t            \"lat\": $v.position.latitude,\t            \"lon\": $v.position.longitude,\t            \"SIDC\": \":bus:\",\t            \"icon\": \":bus:\",\t            \"options\": { \"fillOpacity\":0.8 }\t    \t       }\t\t   }\t)","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":530,"y":240,"wires":[["a3b6babd.4f4208"]]}]

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.