Query the GNAF database

query_gnaf.sql

select * 
from gnaf_201705."addresses"
where "street_name" = 'ANN'
and "street_type" = 'STREET'
and "locality_name" = 'BRISBANE CITY'
limit 10

select *
from gnaf_201705."localities"
where "locality_name" = 'STAFFORD'
and "state" = 'QLD'

select * 
from gnaf_201705."address_admin_boundaries"
where "locality_pid" = 'QLD2717'

select *
from admin_bdys_201705."local_government_areas"
where "lga_pid" = 'QLD21'