Explore

SQL

Useful DBT stuff for specialists

pq_validation_snapshot

_processingrequest_enriched

⁠

PQ options info⁠

⁠

Base Query for future project

SELECT

pqs.slug_id AS slug_id,

pqs.id as pqid,

pqs.dataset_name,

pqs.needed_human_for_gd,

pqs.id AS id,

pqs.aeropointsurvey_frontend_url,

pqs.date_created,

pqs.gcp_count,

json_extract_path_text(data_json, 'make', true) AS make,

json_extract_path_text(data_json, 'model', true) AS model,

json_extract_path_text(data_json, 'cameraModel', true) AS camera_model,

pqs.is_propeller_ppk AS ppk,

pqs.accuracy_grade AS accuracy,

pqs.source_file_gigapixels AS gpix,

pqs.got_reprocessed,

pqs.first_processing_duration_h AS processing_time,

data_json,

pqs.correction_source_type AS correction_source_type,

CASE

WHEN pqs.is_propeller_ppk = true AND pqs.has_precise_geotags = true THEN 'Propeller PPK'

WHEN pqs.is_propeller_ppk = false AND pqs.has_precise_geotags = true THEN 'User-supplied HA'

WHEN pqs.is_propeller_ppk = false AND pqs.has_precise_geotags = false THEN 'Standard Accuracy'

END AS Processing_type,

CASE

WHEN camera_model = 'RGB61' THEN 'Wingtra RGB61'

WHEN camera_model = 'DSC-RX1RM2' THEN 'Wingtra RX1'

WHEN camera_model = 'M3E' THEN 'M3E'

END AS model_type

FROM dbt._processingrequest_enriched AS pqs

LEFT JOIN

dbt.pq_validation_snapshot AS snap ON snap.processingrequest_slug_id = pqs.slug_id

WHERE pqs.is_completed = true

AND pqs.date_created >= '2025-06-01'

AND slug_id = 'pqa1cd0903'

AND is_sitesurveyqualified

AND camera_model IS NOT NULL

AND accuracy = 'strict'

AND camera_model IN ('M4E','M3E')

Want to print your doc?
This is not the way.

Try clicking the ··· in the right corner or using a keyboard shortcut (

CtrlP

) instead.