Overview

This page lists various types of address input scenarios that the Bulk Loader can encounter.

TODO: This table currently assumes empty block/lot values are submitted. Extend this table to include combinations of possible scenarios such as valid block/lot values; invalid values; same block/lot as EAS; different block/lot than EAS; etc.

Initial Table Form

	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)	1235 10TH AVE	Adds address to EAS with no parcel association. Uses geometry supplied in SHP.	New status column with value indicating that the address was successfully added to EAS using the geometry supplied and without a parcel association.	See Example 1
B.	Base address does not exist in EAS	Address with one unit	Valid	398 10TH ST # 2	Adds address to EAS with no parcel association. Adds unit to address. Uses geometry supplied in SHP.	Populate new status column.	See Example 2
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	105 10TH AVE	Ignored record.	New status column with value indicating that the record was ignored because it already exists.	See Example 3
G.	Base address exists, but does not have any units	Address with one unit	Valid	1377 03RD AVE 1337V	Added unit (no parcel association). Set default status/disposition value to 'official' (vs the other possible value: 'provisional').	Populate new status column accordingly. (Also, maybe set status/disposition to a value other than 'official'.)	See Example 4
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	OUTCOME	EXCEPTION TEXT
ROW	st_num	st_num_sfx	st_pfx	st_name	st_type	st_sfx	unit	unit_sfx	block	lot	source	shape	SCENARIO	OUTCOME	EXCEPTION TEXT
1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	N/A	Null record.		street name does not exist
2	any value	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	N/A	Only the Complete Street Number was submitted.		street name does not exist
3	NULL	NULL	NULL	any value	NULL	NULL	NULL	NULL	NULL	NULL	NULL	N/A	Only the Street Name was submitted.		street type does not exist in street dataset
4	NULL	NULL	NULL	any value	any value	NULL	NULL	NULL	NULL	NULL	NULL	N/A	Only the Complete Street Name was submitted.		no matching block - lot
5	any value	NULL	NULL	any value	any value	NULL	NULL	NULL	NULL	NULL	NULL	N/A	Only the Street Number and Street Name were submitted.		no matching block - lot
6	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Null record.
7	any value	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Only the Complete Street Number was submitted.

Examples

Example 1 - 1235 10TH AVE - Scenario A

Example 2 - 398 10TH ST # 2 - Scenario B

Example 3 - 105 10TH AVE - Scenario F

Example 4 - 1377 03RD AVE 1337V - Scenario G

Related articles

Browser not supported