Mercurial Hosting > traffic-intelligence

view scripts/examples.sql @ 976:7f5cbdc107c5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
corrected bug in converting time horizon to frames for internal computations (results for TTC, pPET and PET will be in frames)
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Mon, 05 Feb 2018 16:41:36 -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;