Running the third query in the Paper

[chanwutk]

Hello,

I am working on a geospatial video analytic system (https://github.com/apperception-db/spatialyze), and I am currently evaluating my system against SkyQuery. In this evaluation, I am planning to compare our runtime performance on the third query provided in the paper (https://favyen.com/skyquery.pdf). However, I cannot find the cycling-lanes.png in the skyquery-dataset. Would you mind pointing out where can I have access to this file, please?

[favyen2]

I have added https://github.com/favyen/skyquery/tree/master/input-images let me know if you encounter issues using it.

[chanwutk]

Thank you!

[chanwutk]

We have another question for running the query.
We specifically are trying to run the 3rd query in the paper (Street hazard detection application).
Would you mind suggesting the best way for us to execute the query?
Currently, we run the web application in ./web/ and execute this query:

cars = Detect("car_model")
car_traj = Track(cars;"iou")

cycling_lanes = Import("cycling-lanes.png")
stopped = Select(car_traj;"displacement < 3")
stopped = Select(stopped;"duration > 5")
hazards = Join(stopped;cycling_lanes)

However, we find that the current version of Skyquery does not contain the Join operator.
Would you mind suggesting us how to execute the Join operator, please?