Mercurial > hg > nsaunier > traffic-intelligence

view scripts/examples.sql @ 1161:b968c33f8c2f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
work on producing figures and collision maps for large datasets with multiple sites
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Thu, 04 Mar 2021 23:12:34 -0500
parents d44eba0db517
children
line wrap: on
line source



# get object id, first and last frame numbers, length and number of features
select OF.object_id, min(P.frame_number) as frame1, max(P.frame_number) as frame2, max(P.frame_number)-min(P.frame_number) as length, count(OF.trajectory_id) as nfeatures from positions P, objects_features OF where P.trajectory_id = OF.trajectory_id group by OF.object_id order by nfeatures asc;