Open wb9688 opened 1 year ago
sqlite> select * from inactnums,oprs where oprs.id = inactnums.ligtAanRef and woonplaats='Kerkdriel' and naam='Veersteeg' and huisnummer=3 and huisletter='a';
| id | ligtAanRef | woonplaats | postcode | huisnummer | huisletter | huistoevoeging | status | begindate | enddate | ligtInRef | id | naam | type | status | ligtInRef | verkorteNaam |
|------------------|------------------|------------|----------|------------|------------|----------------|-----------------------|------------|------------|-----------|------------------|-----------|------|-----------------------|-----------|--------------|
| 0263200000364976 | 0263300000000455 | Kerkdriel | 5331PM | 3 | a | | Naamgeving uitgegeven | 2015-11-09 | 2018-08-01 | | 0263300000000455 | Veersteeg | Weg | Naamgeving uitgegeven | 1629 | |
sqlite> select * from nums where id='0263200000364976';
| id | ligtAanRef | woonplaats | postcode | huisnummer | huisletter | huistoevoeging | status | ligtInRef |
|------------------|------------------|------------|----------|------------|------------|----------------|-----------------------|-----------|
| 0263200000364976 | 0263300000000455 | Kerkdriel | 5331PM | 35 | | | Naamgeving uitgegeven | |
like this I think?
Sometimes e.g. house numbers are changed. It would be great if it would be easier to find historical addresses (by searching with e.g. the old house number) and also e.g. be able to find the current address for it.