Data Integration & Interoperability

CSV • KML • GeoJSON • GeoTIFF

Structured thermal inspection data exports for seamless integration with GIS, CMMS, and asset management systems

WGS84 & UTM 14NQGIS / ArcGIS ReadyCMMS CompatibleRTK Positioning

CSV Format Specifications

Coordinate Systems

  • WGS84: EPSG:4326 (lat/lon in decimal degrees)
  • UTM 14N: EPSG:32614 (South Plains regional)

Timestamps

  • Local Time: CST/CDT with ISO 8601 format
  • UTC: Zulu time for audit trails and sync

Data Fields

trailer_id, lat, lon, dt_local, dt_utc, ambient_C, dT_env_F, anomaly_type, dT_norm_C, class, standoff_m, RTK_fix_pct, image_thermal_id, image_rgb_id, notes

Integration Use Cases

  • Import into Excel, Power BI, Tableau
  • CMMS work order generation (Maximo, SAP)
  • Fleet management dashboard integration
  • Historical trending and analytics

KML / GeoJSON Specifications

KML Features

  • Class-colored pins: C0 blue, C1 amber, C2 red, C3 purple
  • ExtendedData: dT_env_F, standoff_m, emissivity, T_refl_C, RTK_fix_pct
  • Popups: Rich HTML descriptions with images and metadata

GeoJSON Properties

  • Geometry: Point features with WGS84 coordinates
  • Properties: All thermal metadata as JSON properties
  • FeatureCollection: Standard GeoJSON structure

Compatible Applications

  • Google Earth, QGIS, ArcGIS Desktop/Pro
  • Leaflet, Mapbox, OpenLayers web maps
  • CMMS map plugins and dashboards
  • Custom web applications and APIs

Note: ESRI FileGDB and shapefile exports available upon request for enterprise GIS workflows.

Integration Workflows

Common integration patterns for West Texas logistics and maintenance operations:

CMMS Integration

  1. 1. Import CSV into maintenance management system
  2. 2. Auto-generate work orders for C2/C3 anomalies
  3. 3. Assign GPS coordinates to work order location
  4. 4. Track repair completion and cost
  5. 5. Compare next inspection for defect progression

GIS Visualization

  1. 1. Open KML in Google Earth or QGIS
  2. 2. Overlay thermal pins on aerial imagery
  3. 3. Filter by anomaly class for prioritization
  4. 4. Measure distances and spatial patterns
  5. 5. Export maps for stakeholder reports

Custom Dashboard

  1. 1. Parse GeoJSON with JavaScript (Leaflet/Mapbox)
  2. 2. Display real-time fleet thermal health status
  3. 3. Calculate fleet-wide metrics and KPIs
  4. 4. Trigger alerts for new C2/C3 anomalies
  5. 5. Historical trending charts and analytics

Executive Reporting

  1. 1. Import CSV into Excel or Power BI
  2. 2. Pivot tables for fleet-wide statistics
  3. 3. Charts showing anomaly trends over time
  4. 4. Cost analysis for repair prioritization
  5. 5. Board-ready thermal health dashboards

RTK GPS Positioning Accuracy

All thermal anomaly locations are tagged with GPS coordinates during flight. Positioning accuracy depends on RTK network availability:

RTK Coverage Available

  • Horizontal Accuracy: 2cm (0.8 inches)
  • Vertical Accuracy: 3cm (1.2 inches)
  • RTK Fix Percentage: Reported in CSV metadata
  • Coverage: Most Lubbock/Amarillo metro areas

Standard GPS Only

  • Horizontal Accuracy: 1-3 meters
  • Vertical Accuracy: 3-5 meters
  • Coverage: Many rural grain elevator/feedlot sites
  • Note: Still adequate for trailer/facility identification

RTK fix percentage is included in every CSV row so you can filter data by positioning quality for applications requiring high precision.

Need custom data formats or API integration?

We can accommodate specific CMMS requirements, custom field mappings, and API integration for enterprise clients. Contact us to discuss your data integration needs.

Serving West Texas • CSV/KML/GeoJSON standard • Custom formats available