Mercurial Hosting > traffic-intelligence

view scripts/examples.sql @ 811:429bb43e8278 opencv3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
switching the branches to correct names (opencv3.1 is old code previously updated to OpenCV3 and default is now updated to OpenCV 2.4.13
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Fri, 10 Jun 2016 15:44:37 -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;