Select Instance
Example Queries
🎯 Pass between two players
SELECT(PLAYER("pwc1").PASSTO(PLAYER("pwc2")).MINRANGE()).WHERE(RECTANGLE(-60, 20, 65, 40)).FROM("SNGS-060, SNGS-061")
⚽ Ball movement
SELECT(BALL().MOVETO(4, 6).WHERE(RADIUS(-20, 10, 35)), BALL().MOVETO(14, 9).MINRANGE()).FROM("SNGS-061")
🏃 Player movement
SELECT(PLAYER("pwc3").MOVETO(1, 6).MINRANGE().WHERE(RADIUS(-20, 20, 20)), PLAYER("pwc3").MOVETO(6, 7)).FROM("SNGS-061")
👥 Team movement
SELECT(TEAM("t1", PLAYER("pwc3"), PLAYER("pleft", "left"), PLAYER("p1", 1)).MOVETO(11, 10, 3)).WHERE(RECTANGLE(-20,-20,40,20)).FROM("SNGS-060")
📍 Ball position
SELECT(POSITION(BALL(), 1, 4)).WHERE(RADIUS(-20, 0, 20)).FROM("SNGS-060")
🔒 Player possession
SELECT(POSSESSION(PLAYER("pwc4"))).WHERE(RECTANGLE(-5, 5, 10, 10), STARTMAX(50), ENDMAX(200), MAXDURATION(50), MINDURATION(15)).FROM("SNGS-060")
Syntax Guide
Queries follow the pattern: SELECT(…).WHERE(…).FROM(…)
SELECT — What to search for
PLAYER("identifier")- Declare a player variable. Optionally specify a team affiliation or ID:
PLAYER("identifier", "left"),PLAYER("identifier", 1). BALL()- Reference the ball.
TEAM("identifier", PLAYER(…), …)- Group several players into a team.
.MOVETO(x, y)- Constrain an entity to move from zone x to zone y.
.PASSTO(PLAYER(...))- Constrain a player to pass the ball to another player.
.MINRANGE()- Minimise the time range of the movement or action.
POSITION(entity, zones...)- Constrain an entity to be in the zones
POSSESSION(entity)- Constrain an entity to have ball possession.
FROM — Which instances to search
Specify one or more instance IDs: .FROM("SNGS-060") or .FROM("SNGS-060, SNGS-061", ...).
WHERE — Spatial & temporal constraints
RECTANGLE(x, y, w, h)- Restrict the search to a rectangular area.
RADIUS(x, y, r)- Restrict the search to a circular area centered at
(x, y)with radiusr. STARTMIN(frame)- Restrict the minimal starting time
STARTMAX(frame)- Restrict the maximal starting time
ENDMIN(frame)- Restrict the minimal ending time
ENDMAX(frame)- Restrict the maximal ending time
MINDURATION(nFrames)- Limit the minimal length of the pattern.
MAXDURATION(nFrames)- Limit the maximal length of the pattern.
💡 Tip: Append .SEARCH(1) to your query to get the first solution.