Sunday, July 26, 2009

Weekly Base SSL Updates for Address Records

Every weekend all ACTIVE addresses are checked to see if their underlying base SSL (Square, Suffix, Lot (property identifier)) has changed. If it has changed, then the base SSL in the address records is switched to the new SSL. The changes are based on doing a spatial overlay with the Vector Property Map (VPM). Below is the text from the weekly process:

PRODUCTION: MAR SSL UPDATE Process Completed.
STARTED: 7/25/2009 3:00:00 AM
FINISHED: 7/25/2009 5:42:58 AM
COMPLETED Report for MAR_SSL


25-JUL-2009 03:00:00: PROCESSING STARTED FOR MAR_SSL.25-JUL-2009 03:00:00: PROCESSING STARTED FOR pr_truncate_feature_classes_c25-JUL-2009 03:00:03: PROCESSING COMPLETED FOR pr_truncate_feature_classes_c25-JUL-2009 03:05:14: PROCESSING STARTED FOR pr_update_mar_from_ownerply25-JUL-2009 04:04:04: UPDATED (294389): RES 04210000(NEW); PAR 02430071(OLD).25-JUL-2009 05:42:58: SUMMARY: 1 MAR RECORDS UPDATED.25-JUL-2009 05:42:58: PROCESSING COMPLETED FOR MAR_SSL.

This weekend one address record had its base SSL updated. This process is related but separate from another weekly process which updates the Address / SSL cross reference table.

No comments: