Mercurial > hg > nsaunier > traffic-intelligence

view scripts/examples.sql @ 800:2cade72d75ad dev

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
modified so there is no tracking outside of the mask (does not continue if features can still be matched) as requested
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Tue, 31 May 2016 17:06:41 -0400
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;