Field Staff Tracking
GPS Tracking
Image & Photo Capture

Image & Photo Capture

Field staff can capture and upload geo-tagged photos during their site visits. These photos serve as proof-of-visit and are linked to the GPS tracking record for manager review.

Image Upload Flow

Image Data Model

The SiteVisitGPSImagesAPIModel captures:

FieldTypeDescription
SiteVisitGPSImagesIDlongAuto-generated primary key
SiteVisitGPSIDlongForeign key to parent GPS record
SiteVisitGPSDetailIdlongLinks to specific GPS waypoint (optional)
ImagePathstringServer-side stored file path
CreatedDateAndTimeDateTimeTimestamp of upload
ImgBase64StringstringBase64-encoded image data (upload only)

Image-Location Linkage

Images can optionally be linked to specific GPS waypoints via SiteVisitGPSDetailId. This creates a relationship chain:

The GetSitevisitGPSImageLocationDetail query joins images with their associated GPS detail records, returning only entries where both latitude and longitude are non-zero.

Retrieval Endpoints

QueryMethodReturns
GetSitevisitGPSImages(id)SitevisitGPSBOAll images for a GPS record with serial numbers
GetImageFilePath(imageId)SitevisitGPSBOServer file path for a specific image
GetSitevisitGPSImageLocationDetail(id)SitevisitGPSBOImages with linked lat/long coordinates

API Endpoint

POST /webapi/SiteVisitGPS/SaveReportOnDutyImage

Request Body:

{
  "SiteVisitGPSID": 8901,
  "SiteVisitGPSDetailId": 0,
  "ImgBase64String": "/9j/4AAQSkZJRgABAQ..."
}

Response:

{
  "Id": 456,
  "result": true,
  "message": "Successfully Updated"
}