Page Comparison

...

Q1
From DBI's perspective, we are either going to be inserting addresses or updating addresses with your data. (Addresses are never deleted but retired on our end and yours I believe). How will we tell the difference if it is an address update or a brand new address? via an XML tag?

A1
Agreed. See Jump ahead to example 3 to see a proposed solution.

Q2
The first example you give below does not have an APN (what DBI refers to as block/lot). DBI cannot make use of any address without an APN (block/lot). These should be excluded until they are complete.

A2.1
This part might be interesting.
Please tread this entire page to get a sense of what we need to do.
In particluar, please look at this and this.
MAD addresses can be associated with APNs or not.
By and large I think they are, but read more below.

...

    <address_change>
        <action>insert</action>
        <address>
            <number>14</number>
            <street>MAPLE ST</street>
            <unit_number>b</unit_number>
            ...
            <apn>1234001</apn>
        </address>
    </address_change>

...

The only difference here is that the APN is different in message 2.
This much is straight forward.
If a unit address changes, and there are APNs assigned to the unit,
we have one address change message for each of these APNs.
But at 2655 Hyde, there are lots of APNs assigned to the base address.

...