Inspection Photo Export Format

Inspection photos are attachments associated with line items inside of an inspection.

Column Description
id Unique identifier and system generated primary key of the inspection item photo.
inspection_id Integer foreign key representing the inspection that these photo is associated.
inspection_item_id Integer foreign key representing the inspection line item this photo is associated.
user User who performed the inspection and associated the photo with the line item.
structure_path Array of the location path of where this inspection was performed.
created_at Timestamp of when this photo as attached to the line item.
source_name In-app indicates that the user took the photo using the OrangeQC in-app camera. Gallery indicates that the user attached the photo from the Camera Roll or Photo Gallery on their device. Unknown is when the system could not determine the source of this file.
latitude GPS latitude of where the photo was attached to the line item.
longitude GPS longitude of where the photo was attached to the line item.
medium_url URL to medium sized thumbnail image. Recommended for most use cases.
original_url URL to original size image scaled and resized on the mobile device.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us