Skip to content

Instantly share code, notes, and snippets.

@nagachika

nagachika/google-cloud-vision-api-bigquery-schema.json

Created September 27, 2016 07:07
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nagachika/6140395b75512a848c549b46760abd75 to your computer and use it in GitHub Desktop.
Save nagachika/6140395b75512a848c549b46760abd75 to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery Schema JSON for Vision API result
Raw
google-cloud-vision-api-bigquery-schema.json
[
{
"name": "gcs_url",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "timestamp",
"type": "TIMESTAMP",
"mode": "NULLABLE"
},
{
"name": "labelAnnotations",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "mid",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "description",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "topicality",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "locale",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "properties",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "value",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "name",
"type": "STRING",
"mode": "NULLABLE"
}
]
},
{
"name": "score",
"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": "confidence",
"type": "FLOAT",
"mode": "NULLABLE"
}
]
},
{
"name": "landmarkAnnotations",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "mid",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "description",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "topicality",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "locale",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "properties",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "value",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "name",
"type": "STRING",
"mode": "NULLABLE"
}
]
},
{
"name": "score",
"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": "confidence",
"type": "FLOAT",
"mode": "NULLABLE"
}
]
},
{
"name": "safeSearchAnnotation",
"type": "RECORD",
"mode": "NULLABLE",
"fields": [
{
"name": "medical",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "spoof",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "violence",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "adult",
"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": "pixelFraction",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "color",
"type": "RECORD",
"mode": "NULLABLE",
"fields": [
{
"name": "green",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "blue",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "red",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "alpha",
"type": "FLOAT",
"mode": "NULLABLE"
}
]
},
{
"name": "score",
"type": "FLOAT",
"mode": "NULLABLE"
}
]
}
]
}
]
},
{
"name": "textAnnotations",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "mid",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "description",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "topicality",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "locale",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "properties",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "value",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "name",
"type": "STRING",
"mode": "NULLABLE"
}
]
},
{
"name": "score",
"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": "confidence",
"type": "FLOAT",
"mode": "NULLABLE"
}
]
},
{
"name": "logoAnnotations",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "mid",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "description",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "topicality",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "locale",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "properties",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "value",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "name",
"type": "STRING",
"mode": "NULLABLE"
}
]
},
{
"name": "score",
"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": "confidence",
"type": "FLOAT",
"mode": "NULLABLE"
}
]
},
{
"name": "faceAnnotations",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "tiltAngle",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "underExposedLikelihood",
"type": "STRING",
"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": "landmarkingConfidence",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "joyLikelihood",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "detectionConfidence",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "surpriseLikelihood",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "angerLikelihood",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "headwearLikelihood",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "panAngle",
"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": "landmarks",
"type": "RECORD",
"mode": "REPEATED",
"fields": [
{
"name": "position",
"type": "RECORD",
"mode": "NULLABLE",
"fields": [
{
"name": "y",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "x",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "z",
"type": "FLOAT",
"mode": "NULLABLE"
}
]
},
{
"name": "type",
"type": "STRING",
"mode": "NULLABLE"
}
]
},
{
"name": "blurredLikelihood",
"type": "STRING",
"mode": "NULLABLE"
},
{
"name": "rollAngle",
"type": "FLOAT",
"mode": "NULLABLE"
},
{
"name": "sorrowLikelihood",
"type": "STRING",
"mode": "NULLABLE"
}
]
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment