Page Comparison

This page is to describe and discuss what a potential problem with EAS addresses in the adoption of the Acella system.

Definition

We'll call this the non coincident parcel address problem. toc

Definition

Some EAS addresses contain parcels that are not spatially non-coincident parcelscoincident with their address point.
A picture is worth a thousand words.

...

Here is a spreadsheet that contains all of these addresses.
You can see these in detail in EAS.
There are 3253 unretired parcel level addresses currently being used at DBI. 
This is out of some 300,000 plus addresses. 

Query

We can find these easily with a query like this.

SELECT
	ab.base_address_num,
	ab.base_address_suffix,
	a.unit_num,
	sn.base_street_name,
	sn.street_type,
	p.blk_lot
FROM address_base ab
inner join addresses a on (ab.address_base_id = a.address_base_id)
inner join streetnames sn on (ab.street_segment_id = sn.street_segment_id)
inner join street_segments ss on (ab.street_segment_id = ss.street_segment_id)
left outer join address_x_parcels axp on (axp.address_id = a.address_id)
left outer join parcels p on (axp.parcel_id = p.parcel_id)
WHERE 1 = 1
and sn.category = 'MAP'
and ab.retire_tms is null
and a.retire_tms is null
and axp.retire_tms is null
and not st_intersects(ab.geometry, p.geometry)
order by
	ss.st_name,
	ss.st_type,
	ab.base_address_num,
	ab.base_address_suffix,
	a.unit_num;

Discussion

We were planning to adapt the existing EAS change notification process to feed address changes into the Acella GIS. 
In doing so we would not have to stick with the exact model layed out in the XML file.
In fact, it may help to think about the Acella address data as a view (in the MVC sense) of the EAS address....
and perhaps the address point in Acella GIS is not the address base point but rather the parcel centroid.

Another possibility is for EAS to adopt a muli-point geometry for the base address.

Another other ideas?

Questions

Does DBI have to support this kind of address?

...