Chyba v normalizacii adries

[lenhardt]

Pre Štefan Schwartz uvadzame adresu Mierové námestie 251/25, 972 51 Handlová, Slovakia
pricom v zdrojovych datach (ako aj na finstate ako sme boli upozorneni) mame

vd=> set search_path="source_ekosystem_RPO_20190127023255";
vd=> select * from organization_address_entries where organization_id=9300750;
-[ RECORD 1 ]-----+---------------------------
id | 3517330
organization_id | 9300750
formatted_address |
street | Mierové námestie
reg_number | 250
building_number | 9
postal_code | 97251
municipality | Handlová
country | Slovenská republika
effective_from | 2017-08-11

cize mame 251/25 miesto 250/9,

vzniklo to mozno posunutim adresy o trochu kvoli normalizacii?
alebo povazujeme koniec PSC 97251 ako cislo domu?

adresa v produkcnych datach
vd=> set search_path="prod_20190113191148";
vd=> select * from entities where id=1558154;
id | name | address_id
---------+-----------------+------------
1558154 | Štefan Schwartz | 349468
vd=> select * from address where id=349468;
id | lat | lng | address
--------+------------+-----------+---------------------------------------------------
349468 | 48.7325915 | 18.761415 | Mierové námestie 250/9, 972 51 Handlová, Slovakia

[lenhardt]

Uz to bolo opravene.