How to create a query that can find all Risso dolphin's using the SIO Species library
- Double click "DeploymentDetails" node (0:05)
- Drag the rectangle into the "Return Value(s)" box on the bottom right (0:07)
- Change the schema of the graph on the top left from "Deployment" to "Detections" (0:10)
- Single click "Effort" node (0:17)
- Single click "Kind" node (0:19)
- Double click "SpeciesID" node (0:23)
- Drag the rectangle into the "Return Value(s)" box on the bottom right (0:27)
- Double click "SpeciesID" node to create a second rectangle (0:29)
- Drag the rectangle into the "Where Conditions(s)" box on the bottom left (0:30)
- Change the Species library to "SIO.SWAL.v1" (0:32)
- Change the view to the map by clicking on "Map" tab in the top left (0:37)
- Enter "Gg" for Risso dolphin's in the "SIO.SWAL.v1" library (0:40)
- Press Submit and wait for XML results from the database (0:43)
- Map gets populated with markers and xml information from the results (0:47)
How to create a query that can find all deploymenys by project and how to refine the search by adding a site criteria.
- Double click "DeploymentDetails" node (0:02)
- Drag the rectangle into the "Return Value(s)" box on the bottom right (0:03)
- Double click "Project" node (0:06)
- Drag the rectangle into the "Return Value(s)" box on the bottom right (0:08)
- Double click "Site" node (0:11)
- Drag the rectangle into the "Return Value(s)" box on the bottom right (0:13)
- Double click "Project" node (0:24)
- Drag the rectangle into the "Where Condition(s)" box on the bottom left (0:27)
- Single click on "Map" tab (0:28)
- Enter "CINMS" in the "Deployment/Project" box within the Where Condition(s) (0:30)
- Press "Submit Query" and wait for results from the database (0:34)
- Map and Results updated with data from database (0:36)
- Show the data for the map marker. The site data is "K" (0:42)
- Show the data for the map marker. The site data is "K2" (0:44)
- Click on "Build" tab (0:46)
- Double click "Site" node (0:50)
- Drag the rectangle into the "Where Condition(s)" box on the bottom left (0:52)
- Enter "K" in the "Deployment/Site" box within the Where Condition(s) (0:55)
- Click on "Map" tab (0:58)
- Press "Submit Query" and wait for results from the database (1:00)
- New results only show the site K now for the CINMS project