1 Reply Latest reply: May 13, 2013 4:54 AM by Stefan Jager RSS

    Oracle Geocoder with Custom Data

    1008092
      Hello all. I'm testing the geocoded with my custom data from El Salvador. I have configured all the tables required. My GC_PARSER_PROFILEAFS is:

      <address_format unit_seperators="," replace_hyphen="true">
      <address_line>
      <place_name />
      </address_line>
      <address_line>
      <street_address>
      <street_name>
      <base_name />
      <street_type />
      <suffix />
      </street_name>
      <house_number>
      <format form="0*" effective="0-1" output="$" />
      <format form="0*-0*" effective="0-1" output="$" />
      <format form="#0*" effective="0-1" output="$" />
      <format form="No.0*" effective="0-1" output="$" />
      <format form="No. 0*" effective="0-1" output="$" />
      </house_number>
      </street_address>
      </address_line>
      <address_line>
      <settlement optional="yes" />
      <city optional="no" />
      <region optional="no" order="1" />
      </address_line>
      </address_format>

      When I run:

      SELECT SDO_GCDR.GEOCODE_ALL('LOCALIZAME_SV',
      SDO_KEYWORDARRAY('Calle Arce No.123', 'San Salvador, San Salvador'),
      'SV', 'DEFAULT'
      ) FROM DUAL;

      I get:

      (null)

      If I run:

      SELECT SDO_GCDR.GEOCODE_ADDR('LOCALIZAME_SV',
      GEO_ADDR_POI('SV', 'Burger King')
      ) FROM DUAL;

      MDSYS.SDO_GEO_ADDR(0MDSYS.SDO_KEYWORDARRAY(),'BURGER KING','ALAMEDA JUAN PABLO II',NULL,NULL,'COL. ESCALON',NULL,'SAN SALVADOR','SV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'F','F',NULL,NULL,' ',0,5748,'???O#ENUT?B281CP?',1,'DEFAULT',-89.23162,13.710509,'???01141114??401?')

      Why I'm I getting null when searching for streets and not getting all the geocoded data right?

      Can please someone point me on the right direction?

      Thank a lot.

      Frank Fica
        • 1. Re: Oracle Geocoder with Custom Data
          Stefan Jager
          Hi Franc,

          check your data (are all the columns filled, and are they filled with the proper data?), and expand your Parser profile.
          What do you get when you execute this:
          SELECT SDO_GCDR.GEOCODE_ADDR
          (
          'LOCALIZAME_SV',
          SDO_GEO_ADDR
          (
          'SV', -- COUNTRY
          'DEFAULT', -- MATCHMODE
          'Calle Arce No.123', -- STREET
          NULL, -- SETTLEMENT
          NULL, -- MUNICIPALITY
          'San Salvador', -- REGION
          NULL -- POSTALCODE )
          )
          FROM DUAL;
          instead of using the custom function to return an address array from a POI?

          Besides the excellent book "Pro Oracle Spatial for Oracle Database 11g" I would also check the [url http://docs.oracle.com/cd/E11882_01/appdev.112/e11830/sdo_geocode_concepts.htm#CIHECECC]documentation. This link assumes you are using Oracle 11R2, allthough you did not provide your database version.

          Regards,
          Stefan

          PS. please do not dig up old threads, when you've already created one with your question.