Skip to content

Instantly share code, notes, and snippets.

@patdevinwilson

patdevinwilson/Query for null photos

Last active May 16, 2019 13:24
Show Gist options
  • Save patdevinwilson/398209b77760f4a63e86c108370f2f0a to your computer and use it in GitHub Desktop.
Save patdevinwilson/398209b77760f4a63e86c108370f2f0a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Query for null photos
SELECT
p.record_id,
p.photo_id,
p.latitude,
p.longitude
FROM
photos p
INNER JOIN "Photos test for Patrick" i ON p.record_id = i._record_id
WHERE p.latitude IS NULL and p.longitude IS NULL;
@patdevinwilson
Copy link
Author

patdevinwilson commented Apr 29, 2019 •
edited
Loading

SELECT
p.record_id,
p.photo_id,
p.latitude,
p.longitude
FROM
photos p
INNER JOIN "survey name" i ON p.record_id = i._record_id
WHERE p.latitude IS NULL and p.longitude IS NULL AND i._status = 'Approved';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment