1. Brian Schlining
  2. deepseaguide

Wiki

Clone wiki

deepseaguide / SQLExamples

SQL Examples

Lookup an Artifact by DublinCore identifier

This example does a lookup for the concept Grimpoteuthis.

SELECT 
  url 
FROM 
  DublinCore AS dc  LEFT OUTER JOIN 
  URLArtifact AS ua ON ua.DublinCoreID_FK = dc.id 
WHERE 
  identifier = 'MBARI,VARS,Concept,Grimpoteuthis,histogram,counts,depth in meters,50.0 meter bins,text/plain,Greater Monterey Bay'

Updated