...
| Base Address Scenario | Input Scenario | Input Geometry | Example | Current Bulk Loader Behavior | Desired Changes to Bulk Loader Behavior | Notes | |
|---|---|---|---|---|---|---|---|
| A. | Base address does not exist in EAS | Address with no units | Valid (within N-foot threshold) | ||||
| B. | Base address does not exist in EAS | Address with one unit | Valid | ||||
| C. | Base address does not exist in EAS | Address with two+ units | Valid | ||||
| D. | Base address does not exist in EAS | Address with no units | Invalid (exceeds N-foot threshold) | ||||
| E. | Base address does not exist in EAS | Address with no units | Invalid or None | ||||
| F. | Base address exists, but does not have any units | Address with no units | Valid | ||||
| G. | Base address exists, but does not have any units | Address with one unit | Valid | ||||
| H. | Base address exists, but does not have any units | Address with two+ units | Valid | ||||
| I. | Base address exists, but does not have any units | Address with no units | Invalid or None | ||||
| J. | Base address exists and has existing unit(s) | Address with no units | Valid | ||||
| K. | Base address exists and has existing unit(s) | Address with one unit that does not exists in EAS | Valid | ||||
| L. | Base address exists and has existing unit(s) | Address with one unit that does exists in EAS | Valid | ||||
| M. | Base address exists and has existing unit(s) | Address with two+ units where some but not all exist in EAS | Valid | ||||
N. | Other Scenarios | Input address uses valid street name alias | Valid | ||||
| O. | Other Scenarios | Input address exists as a retired address | Valid | ||||
| P. | Other Scenarios | Status/Disposition considerations | |||||
Q. | Other Scenarios | Considerations for dataset details ("More" tab in UI) |
Truth Table Form
ROW | BULK LOADER INPUT FIELDS | SCENARIO | ROWEXCEPTION TEXT | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| st_num | st_num_sfx | st_pfx | st_name | st_type | st_sfx | unit | unit_sfx | block | lot | source | shape | SCENARIO | EXCEPTION TEXT | |
| 11 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | N/A | Null record. | |
| 2 | any value | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | N/A | Only the Complete Street Number was submitted. | |
| 3 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Null record. | |
| 4 | any value | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Only the Complete Street Number was submitted. | |
...