This page describes how EAS is integrated with other city systems.
| Table of Contents |
|---|
Terminology
Extract-Transform-Load (ETL)
Enterprise Addressing System (EAS)
Department of Public Works (DPW)
Parcel - includes attribute data as well as geometry
Parcels
Parcel Creation - DPW
Parcel creation occurs at DPW.
Every week night an automated extract-transform-load ( ETL ) job runs that loads new parcels into EAS.
A parcel as defined by EAS includes attribute and geometry data.
The DPW process for creating parcels is non-trivial and is documented here (need link).
Parcel Update - DPW
Parcel updates occur at DPW.
Every week night an automated ETL runs that updates EAS parcels from DPW.
We assume that the block and lot fields do not change.
All other fields may be updated, including the geometry.
Parcel Retirement - DPW
Parcel retirement occurs at DPW.
Every week night an automated extract-transform-load (ETL) job runs that loads retired parcels into EAS.
If a parcel is newly retired, addresses that are linked to the retired parcel are marked as "invalid".
An "invalid" address may be retired or may remain active.
The decision to retire an address is made by an EAS reviewer.
A reviewer may decide to keep an address active, even with a retired parcel, if there is permit activity on that parcel.
However, in most cases the reviewer will retire an "invalid" address.
The DPW process for retiring parcels is non-trivial and is documented here (need link).
Parcel Provisioning - EAS
In some rare cases, an address must be created immediately using a parcel that does not yet officially exist.
In these cases, an EAS Reviewer can "provision" a parcel within EAS.
This creates an unofficial or "provisioned" parcel in EAS.
The EAS Reviewer then requests that the offcial parcel be created by DPW and must provide documentation from the assessor-recorder to DPW.
When the official parcel is created by DPW, the nightly ETL uses the block-lot to update the provisioned parcel, and marks the provisioning as complete.
Streets
Street Segment Creation - DPW
Street segment creation occurs at DPW.
Every week night an automated extract-transform-load (ETL) job runs that loads new street segments into EAS.
A street segment as defined by EAS includes attribute and geometry data.
The DPW process for creating street segment is non-trivial and is documented here (need link).
Street Segment Update - DPW
Street segment updates occur at DPW.
Every week night an automated extract-transform-load (ETL) job updates street segments into EAS.
A street segment as defined by EAS includes attribute and geometry data.
Street Segment Retirement - DPW
Street Segment Provisioning - EAS
Street Name Creation - DPW
Street Name Change - DPW
Addresses
Address Create - EAS
Address Retire - EAS
...