Tuesday, July 28, 2009

REAR Addresses

Last week David and I went for field research and found 3 addresses with REAR associated with it in an alley named Linden Court NE. It is so hard to track REAR addresses as most of them are neither issued officially by DCRA (Department of Consumer and Regulatory Affairs) nor recognized by USPS. These unauthorized or made up addresses are one of the major challenge that MAR has had to deal with.

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:

STARTED: 7/25/2009 3:00:00 AM
FINISHED: 7/25/2009 5:42:58 AM

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.

Friday, July 17, 2009

Address Anomalies Document Updated

The Address Anomalies list has been updated. It is in a PDF format and can be accessed & downloaded here.

Thanks to Demetrios Vlassopoulos and his team for pointing out a few more address anomalies.

To get an idea about the kind of addresses that are treated as anomalies, please refer to Slide 4.

Please free to contact the Master Address Repository (MAR) team in case of any questions.

Wednesday, July 8, 2009

Year built vs. Address Number

Sometimes it is easy to get confused with the address number even after being in the field. For example, MAR had an address 1937 Benning Road NE and while reviewing it was found that neither it was recognized by USPS nor by some other datasets. Therefore, we went to the location and found that the number mentioned on the building was the year it was built in. It seems that it was picked by someone in the field before. Apart from the year there wasn’t any address number and building looked abandoned. The address 1937 Benning Road NE was removed from the MAR. A careful review of addresses has made MAR a quality dataset.

Residential Units Update

Currently, the MAR has 185,906 residential units. Back in December 2008 there were about 175,000 residential units. It is estimated that there are between 194,000 to 202,000 residential units. Thus the MAR has an between 92% - 96.8% of all residential units. As we get closer to 100% the difficulty of finding the remaining residential units increases. These 185,902 units are located in 20,132 unique primary addresses. Thus the average primary address has 9.25 units (185,902 / 20,132).

What are the remaining weaknesses in the Residential Unit Table?

  • Special Use Residential Facilities (University Dorms, Group Homes, Retirement, Nursing Home, Military Barracks)
  • Multi Unit Row Houses
  • Large Buildings with a Low or Zero Occupancy Rate
  • Buildings which have been very recently constructed

Wednesday, July 1, 2009

Monthly MAR Data & Information Report: June 2009

***** Monthly MAR Data & Information Report: June 2009 *****

May Data Loads into Addresses, Alias, Units, Street Names Aliases:


Dataset Numbers:

  • Addresses: 141,696
  • Residential Units: 185,899
  • Aliases: 5,150
  • Street Name Alias: 1,021
  • Intersections: 16,359
  • Block: 15,826
  • Address / SSL Cross Reference Table: 236,230

MAR Address Standards have been published and are available via the MAR Website.

We are assisting Office of Tax & Revenue in dealing wither address problems in their Integrated Tax Systems (ITS).

Preparations are underway for our attendance at the Addressing Conference in Providence, RI in August. We will be learning from others about address issues. We will also be presenting at the conference about the MAR in general and also about the Residential Unit Table.

More Even or More Odd Addresses?

Are there more even or more odd addresses in Washington, DC?

After running all 140,267 address numbers:

Odd Addresses: 70,339 (50.1%)
Even Addresses: 69,928 (49.9%)

There are more odd addresses. It is very close. :-) These numbers were run on July 1st, 2009. 1/2 address and other addresses with address number suffixes were considered to take the parity (even or odd) of the address number. Thus 1333 1/2 RANDOM STREET NE would be considered an odd address.