Database Software

Hello,

i have a question on Geocoding.

We successfully loaded data for Germany into a GC - Shema and "normal" Geocoding works good.

But when geocoding without specifiing the zip code we only get results for settlements, which are also municipalities.

Example:

select sdo_gcdr.geocode ('geocode', SDO_KEYWORDARRAY('Sinzig'), 'DE', 'RELAX_ALL') from dual;

Result:

(; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; )


in POSTAL_CODE table:

select * from GC_POSTAL_CODE_DE where SETTLEMENT_NAME='Sinzig';

53489 Sinzig Ahrweiler Rheinland-Pfalz DEU 49003445 49000202 49010580 7,22564763 50,5277536 DE 1

in GC_AREA_DE:

select * from GC_AREA_DE where AREA_NAME='SINZIG';

AREA_ID, AREA_NAME, LAN, ADMIN_LEVEL, LEVEL1_AREA_ID, LEVEL2_AREA_ID, LEVEL3_AREA_ID, LEVEL4_AREA_ID, LEVEL5_AREA_ID, LEVEL6_AREA_ID, LEVEL7_AREA_ID, CENTER_LONG, CENTER_LAT, ROAD_SEGMENT_ID, POSTAL_CODE, CO, PARTITION_ID, REAL_NAME
49003445 SINZIG DEU 4 49 49010580 49000202 49003445 50,5277536 7,22564763 3371875 53489 DE 1 Sinzig


whereas

select sdo_gcdr.geocode ('geocode', SDO_KEYWORDARRAY('Ahrweiler'), 'DE', 'RELAX_ALL') from dual;

(0; (; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ); ; ; ; ; Ahrweiler; ; RHEINLAND-PFALZ; DE; 53506; ; ; ; ; ; ; F; F; ; ; L; 0; 3287522; ??????????B281CP?; 4; RELAX_ALL; 50,4675819668166; 7,04481374950425)

works, the result is a MUNICIPALITY_LEVEL


My Question is: Does Geocoding without Zip always return to the MUNICIPALITY_LEVEL ?

That would require to store the so called settlement as municipality and omit either the state or the Kreis-level for germany

I hope my question is understandable and all req. infos are given.

thanx in advance