Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id, name_2 FROM instagram_itens ii
- JOIN gis.bra_adm2 br
- ON ST_CONTAINS(br.geom, ii.geom)
- JOIN instagram_monitoring_itens imi
- ON imi.item_id = ii.id
- WHERE imi.monitoring_id ILIKE 'hilaine-amostra%'
- AND ii.geom IS NOT NULL
- LIMIT 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement