Mercurial > hg > nsaunier > traffic-intelligence

annotate scripts/examples.sql @ 398:3399bd48cb40

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Ajout d'une méthode pour obtenir le nombre de FPS Méthode de capture des trames vidéos plus résistante aux erreur Utilisation d'un dictionnaire pour les fichier de configuration afin de garder le nom des sections
author Jean-Philippe Jodoin <jpjodoin@gmail.com>
date Mon, 29 Jul 2013 13:46:07 -0400
parents d44eba0db517
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
367
d44eba0db517 creating a file with SQL code samples
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
1
d44eba0db517 creating a file with SQL code samples
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
2
d44eba0db517 creating a file with SQL code samples
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
3 # get object id, first and last frame numbers, length and number of features
d44eba0db517 creating a file with SQL code samples
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
4 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;