...
- create a dummy street record for the UNKNOWN street
- duplicates are not allowed, so we would have to create 0..N UNKNOWN
- we would provide update statements such as
- update addresses set number where id = x;
Option 2
We can programatically select a good approximation.
Details
- query to get the street nearest the parcel centroid
- query to find the point on the street that is nearest the parcel centroid
- use that point and interpolation to choose the best address number
- no duplicates!
- spatial query to determine right/left side (then even/odd number)
- we would provide update statements such as
- update addresses set number, street, street_type where id = x;
...