Helpful Queries

Treetracker

Data Pipeline

select bulk_data from bulk_tree_upload where bulk_data -> 'registrations' @> '[{"device_identifier" : "a3243cf6b33d7db3"}]';

select bulk_data->'trees'->>0 from bulk_tree_upload where bulk_data -> 'trees' @> '[{"planter_identifier" : "0922166"}]';