Thursday, May 28, 2009

Residential Units Info

The Residential Units table has 185,632 records. A Residential Unit is an individual housing occupancy which has a secondary designation. These can be apartments or condominiums Most of these units have an interior entrance to the location.
There are an estimate 194,000 - 205,000 residential units in Washington, DC. Thus the Residential Unit is estimated to be between 91.9% - 95.6% complete.
The Residential Unit Table includes the following columns:
  • Unit Num
  • Unit Type
  • Unit ID
  • Address ID
  • Condo SSL
  • Condo Square
  • Condo Suffix
  • Condo Lot
  • Condo Book
  • Condo Page
  • Metadata ID
Weakness in the Residential Unit Table:
  • Special Use Residential Facilities (University Dorms, Group Homes, Retirement, Nursing Home Military Baracks)
  • Multi Unit Row Houses
  • Large Buildings with a Low Occupancy Rate
  • Buildings which have been constructed very recently

Tuesday, May 26, 2009

What do the different statuses in the address table mean?

What do the different statuses in the address table mean?

ACTIVE - addresses for buildings which are standing. This status represents the overwhelming majority of addresses.

RECOMMENDED - addresses which have been recommended (suggested) by a DC GIS employee for approval by DCRA.

ASSIGNED - addresses which have been assigned (approved) by DCRA, but whose buildings have not yet been constructed.

RETIRE - addresses for buildings that have been demolished or for addresses which represented space which has since been occupied by a different address (example: a retail store closing and being taken over by a neighboring store which knocks the wall down).

TEMPORARY - addresses which will exist for a relatively short period of time. Construction trailers, special event tents may be given this TEMPORARY designation.

MISTAKE - addresses which are incorrect. These MISTAKE addresses are automatically deleted each and every evening. These MISTAKE addresses are due to incorrect data being entered using the MAR Maintenance Tool.

Tuesday, May 19, 2009

Distribution of Addresses 1 - 99 (Unit Block)

The above graph shows the quantity of addresses between 1 to 99 within Washington, DC. The above graph shows the distribution of address along the unit block which is the block where addresses are from 1 - 99. The vast majority of these addresses are next to the 'Capital Streets' which are North Capital Street, South Capital Street and East Capitol Street. Some of the alley streets and the circles (such as Dupont Circle) are addressed as unit blocks.

In the graph to the right, I have illustrated with comments some of the more interesting elements of the graph. These interesting elements include Triskaidekaphobia (the fear of the number 13), the desire for the addresses with the number 50, and the strong downward trend from around 25 to 99. For example Union Station has the address 50 Massachusetts Avenue NE.

Thursday, May 14, 2009

Upcoming & Ongoing Projects

Here is a list of Upcoming & Ongoing Projects:

Monday, May 11, 2009

Plattsburg Ct NW

While out in the field yesterday my coworker and I confirmed that the location of Plattsburg Ct was incorrect in DDOT's (DC Department of Transportation) street database. DDOT had mapped the location of Plattsburg CT NW just to the west of its actual location. Please see below image. Plattsburg Ct NW is actually to the east of 38th Street NW. A DDOT employee has been informed, via email, of this problem in their database. It should be corrected soon. Interestingly enough, Plattsburg Court NW does not have addresses associated with it.

Click on image for larger version.

Sunday, May 10, 2009

We Want Your Input.

The Master Address Repository (MAR) is a large and complicated database. In order to improve the quality of the data we are looking for your input regarding:
  • Addresses of buildings that have recently been built. Please confirm that they are in the address database. If not the missing address can be submitted though our website.
  • Buildings that are demolished. The addresses for recently demolished buildings should have a Status of 'RETIRE' (instead of 'ACTIVE'). This can be confirmed in the address database.
  • Suggestions, comments or questions.
Thank You. We look forward to you joining the conversation. Proudly members of Government 2.0!

Thursday, May 7, 2009

MAR Presentation has Been Updated

The MAR Presentation (pdf) has been updated. The MAR Presentation contains an overview of the Master Address Repository (MAR) and is 24 pages in length.

Wednesday, May 6, 2009

Demolished: 1500 Galen Street SE & 1504 Galen Street SE

These two addresses located at:
  • 1500 Galen Street SE
  • 1504 Galen Street SE
have been demolished. Thus these two addresses are now retired in the MAR. The two addresses are actually located in one building. The information came form the And Now, Anacostia Blog. Thanks.

Tuesday, May 5, 2009

Demolished: Building at 3910 Georgia Avenue NW

The abandoned commercial building located at 3910 Georgia Avenue NW has been demolished. The addresses of demolished buildings will have their status changed from 'ACTIVE' to 'RETIRE' in the MAR. You can confirm that at the MAR Sample Client.

Monday, May 4, 2009

Why Every Address Is Important

There was an interesting article published in 2006 in the Washington post for a street named as 9 ½. Check the link for details:

Street 9 1/2 wasn’t in the DC Government’s 911 system back then but certainly was in the MAR. Our slogan “Every Address is Important” is based on the fact that an incorrect address location may be disastrous in the case of an emergency situation.

Sunday, May 3, 2009

Is Your Address in The MAR?

Is your address in the Master Address Repository (MAR)?

You can Check Here. I bet it is.

It is estimated that the MAR contains more then 99.8% of all full addresses in Washington, DC which means that it is missing less than 250 addresses. This estimates does not include
basement locations which have the 1/2 designation as an address number suffix.
If your address is not in the MAR it can be submitted as a missing address. All submitted missing addresses will then be researched. If the address is found to be valid, it will then it will be added.

Friday, May 1, 2009

Ways of maintaining MAR

Addresses are the integral part of the system for delivering proper services. To maintain the quality of the MAR, we @DCGIS not only match with different databases but are also involved with the new address approval process. MAR team works with DCRA (Department of Consumer & Regulatory Affairs) in recommending new addresses. We make sure that every address application is reviewed carefully.

MAR Monthly Report: April 2009

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

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

Dataset Numbers:

  • Addresses: 141,673
  • Residential Units: 182,658
  • Aliases: 5,113
  • Street Name Alias: 1,021
  • Intersections: 16.359
  • Block: 15,826
  • Address / SSL Cross Reference Table: 235,793

    • ---------------


      A large number of residential units were loaded. This information came through field research, USPS, and various DC Databases.

      The MAR now has a blog. It can be found at The goals are to provide additional information to current users, increase interest in the MAR, and initialize a conversation with MAR users through comments left on the blog.

      MAR Maintenance Tool User's Guide has been published. The MAR Maintenance Tool allows addresses and residential units to be added and updated in a non batch method. It allows for 'live' editing of the data.

      Major updates of addresses at the Phillips Park development, which is located at the intersection of Foxhall Road and W Street NW.

      The MAR Frequently Asked Questions Document located on the MAR Website has been updated. It contains new information regarding the different statuses of addresses.