15.2.3 Processing Collection of Matches

If your Collection Name is GEOCODE_RESULTS then you can access the address matches using the following query:

select seq_id,
       c001 as street,
       c002 as house_number,
       c003 as postalcode,
       c004 as municipality,
       c005 as settlement,
       c006 as region,
       c007 as country,
       c011 as matchvector,
       n001 as longitude,
       n002 as latitude,
       d001 as geocoding_timestamp
from apex_collections
where collection_name = 'GEOCODE_RESULTS'
order by seq_id

Tip:

The results are added to the collection in the order "best match first" order the geocoding service provides them, so ordering by the collection's SEQ_ID column retains that order for your processing.