Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Populate table with 2 example address scenarios

...


Base Address ScenarioInput ScenarioInput GeometryExampleCurrent Bulk Loader BehaviorDesired Changes to Bulk Loader BehaviorNotes
A.Base address does not exist in EASAddress with no unitsValid (within N-foot threshold)



B.Base address does not exist in EASAddress with one unitValid



C.Base address does not exist in EASAddress with two+ unitsValid



D.

Base address does not exist in EAS

Address with no unitsInvalid (exceeds N-foot threshold)



E.Base address does not exist in EASAddress with no unitsInvalid or None



Anchor
scenario_f
scenario_f
F.

Base address exists, but does not have any units

Address with no unitsValid105 10TH AVEIgnored record.New status column with value indicating that the record was ignored because it already exists.See Example 1
Anchor
scenario_g
scenario_g
G.

Base address exists, but does not have any units

Address with one unitValid1377 03RD AVE 1337VAdded 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 2
H.

Base address exists, but does not have any units

Address with two+ unitsValid



I.

Base address exists, but does not have any units

Address with no unitsInvalid 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 ScenariosInput address uses valid street name aliasValid



O.Other ScenariosInput address exists as a retired addressValid



P.Other ScenariosStatus/Disposition considerations




Q.

Other ScenariosConsiderations for dataset details ("More" tab in UI)




...


ROW
BULK LOADER INPUT FIELDS


SCENARIO


OUTCOME


EXCEPTION TEXT

st_numst_num_sfxst_pfxst_namest_typest_sfxunitunit_sfxblocklotsourceshape
1NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLN/ANull record.

2any valueNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLN/AOnly the Complete Street Number was submitted.

3NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNull record.

4any valueNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLOnly the Complete Street Number was submitted.

Examples

Anchor
example01
example01
Example 1 Scenario F. 105 10TH AVE: Input address with no units. Base address exists, but does not have any units.

Image Added

Input address was ignored. No changes made.


Anchor
example02
example02
Example 2 Scenario G. 1377 03RD AVE 1337V: Input address and unit. Base address exists, but does not have any units.

Image Added

Unit was added. 'More' tab reflects last change.

Section X

Info

...