Spatial (MOSC)

MOSC Banner

Geocoding

edited Jan 9, 2013 5:40AM in Spatial (MOSC) 4 commentsAnswered
 Hi,I have a problem with the address geocoding.
I'm using the function SDO_GCDR.GEOCODE but in some case, even if i give the correct street name, municipality and province, the geocoding returns a wrong postal code.

this is an example:

SELECT SDO_GCDR.GEOCODE('GEO',
                             SDO_KEYWORDARRAY('VIA POLIFEMO 50061',
                                              'FIESOLE',
                                              'FI'),
                                              'IT','DEFAULT')
FROM dual;
-------------------------
MDSYS.SDO_GEO_ADDR(0),NULL,'Via Polifemo',NULL,NULL,NULL,'Fiesole','FIRENZE','IT','42020',NULL,'42020',NULL,'101','POLIFEMO','VIA','T','F',NULL,NULL,'L',0,75790319,'?????ENUT?B281CP?',3,'DEFAULT',11.36529,43.78511,'???12101010??004?')
        
The geocoded address contains then correct street name, municipality and province, but an incorrect postal code.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center