| vikingTilePawPrints 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 vikingTilePawPrints
WHERE tlSeqNum>0
UNION
SELECT *
FROM vikingTilePawPrints
WHERE tileSetSeqNum<0
The details of the table defined by this view are available here.