Created
March 4, 2016 04:51
BigQuery Table schema for Google Vision API response (see https://cloud.google.com/vision/reference/rest/v1/images/annotate#AnnotateImageResponse)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "name": "faceAnnotations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "boundingPoly", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "vertices", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "y", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "x", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "fdBoundingPoly", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "vertices", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "y", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "x", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "landmarks", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "position", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "y", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "z", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "x", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "type", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "rollAngle", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "panAngle", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "tiltAngle", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "detectionConfidence", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "landmarkingConfidence", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "joyLikelihood", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "sorrowLikelihood", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "angerLikelihood", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "surpriseLikelihood", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "underExposedLikelihood", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "blurredLikelihood", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "headwearLikelihood", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "landmarkAnnotations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "mid", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "locale", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "description", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "score", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "confidence", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "topicality", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "boundingPoly", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "vertices", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "y", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "x", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "locations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "latLng", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "latitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "longitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "properties", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "name", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "value", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "logoAnnotations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "mid", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "locale", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "description", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "score", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "confidence", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "topicality", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "boundingPoly", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "vertices", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "y", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "x", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "locations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "latLng", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "latitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "longitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "properties", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "name", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "value", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "labelAnnotations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "mid", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "locale", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "description", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "score", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "confidence", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "topicality", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "boundingPoly", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "vertices", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "y", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "x", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "locations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "latLng", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "latitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "longitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "properties", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "name", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "value", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "textAnnotations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "mid", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "locale", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "description", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "score", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "confidence", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "topicality", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "boundingPoly", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "vertices", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "y", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "x", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "locations", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "latLng", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "latitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "longitude", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "properties", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "name", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "value", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "safeSearchAnnotation", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "adult", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "spoof", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "medical", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "violence", | |
| "type": "STRING", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "imagePropertiesAnnotation", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "dominantColors", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "colors", | |
| "type": "RECORD", | |
| "mode": "REPEATED", | |
| "fields": [ | |
| { | |
| "name": "color", | |
| "type": "RECORD", | |
| "mode": "NULLABLE", | |
| "fields": [ | |
| { | |
| "name": "red", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "green", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "blue", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "alpha", | |
| "type": "INTEGER", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| }, | |
| { | |
| "name": "score", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| }, | |
| { | |
| "name": "pixelFraction", | |
| "type": "FLOAT", | |
| "mode": "NULLABLE" | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| ] | |
| } | |
| ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment