| sharksTilePawPrints table with only good tile detections only and defaults |
| This view removes matches where there are pawprint detections but not a tile detection |
SELECT *
FROM sharksTilePawPrints
WHERE tlSeqNum>0
UNION
SELECT *
FROM sharksTilePawPrints
WHERE tileSetSeqNum<0
The details of the table defined by this view are available here.