Monday, December 21, 2009

Demolished: 200 E Street SW


The Market Inn which was located at 200 E Street SW has been demolished. Thus the address was now has a status = 'RETIRE' in the MAR. In the above May 2009 image the building was still standing. When I went past the area today, I noticed that building no longer existsed.

Thursday, December 10, 2009

Adding Residential Units at 4100 Georgia Avenue NW


In the MAR, residential units have been added to the recently completed apartment building located at 4100 Georgia Avenue NW. This building also has ground floor retail which contains a Yes Organic Market. The apartment building has 72 units as noted on their website. Now the individual unit numbers needed to be obtained. The unit information was found by typing in the address 4100 Georgia Avenue NW, Washington, DC into the USPS Zip Code lookup. The units being:


  • 201 - 212
  • 301 - 312
  • 401 - 412
  • 501 - 512
  • 601 - 612
  • 701 - 712

Each floor has 12 units and there are six floors with units (floors 2 - 7). Thus 12 * 6 = 72, which confirms the 72 units mentioned on the apartment building's website. Lovely!

Wednesday, December 2, 2009

Keeping Up With New Development

It is vital for the MAR to keep up with new development in the city. To reach that goal many sources are applied such as:

  • Address Applications from DCRA
  • Recent satellite / Aerial imagery
  • Building Permit Database
  • Other Databases
  • Site Visits
  • Site Plans from Developers
  • Reading DC Blogs

Today, I went for a site visit to the Capitol Quarter Development located around 4th Street SE & K Street SE. The Capitol Quarter Development is a large project involving multiple city blocks with hundreds of rowhouses. While visiting the site I was confirming and notung the location of addresses and where construction is occurring. Later in the day I was able to update the MAR live using the MAR Maintenance Tool.



Capitol Quarter Development
along the 1000 block of 5th Street SE

Tuesday, December 1, 2009

MAR Monthly Report: November 2009


Dataset Numbers:

  • Addresses: 141861
  • Residential Units: 189880
  • Aliases: 5216
  • Street Name Aliases: 1055
  • Intersections: 16382
  • Blocks: 15825
  • Address / SSL Cross Reference: 236082
---------------

News:

Vivek Srivastav who was part of the MAR Data Team has resigned after three years of work on the project. I wish future success.

An updated MAR Presentation has been posted on both the external and internal MAR Websites.

The MAR is being used to work on updating the 2010 Census Master Address File for Washington, DC.

Tuesday, November 24, 2009

Address Submission Option


Addresses that are not found using the MAR Web Services Sample Client and which are located
along a valid address range on a street have the option of being submitted for review by
knowledgeable address specialists.

Go to the MAR Sample Client and type in the address in question and click submit. If the address is within a valid street address range, and it is not in the MAR an option will appear entitled 'Select this link to report a New Location or to change an existing location,' Click on the link and carefully fill in the form. Click 'Submit for Verification'. A member of the MAR Data Team will research the address and respond within a couple of business days.

Google Street Name Mess Up and Collabrative Mapping


View Larger Map

Some of the street names in Google Maps are incorrect. I found a couple of cases in the large development called Capitol Gateway.
  • There is no 17th Place SE here. It should be 57th Place SE
  • On the crescent shaped street near where it says 'McWilliams Ballard' it should be 57th Street SE (not 57th Place SE).
Fortunately, Google Maps has a very useful feature called 'Report a Problem' where users can submit inaccuracies found on their map. I took advantage of their noble feature and easily submitted these problems. Hopefully they will respond soon to my corrections. This 'Report a Problem' feature is an example of Collaborative Mapping.

Collaborative Mapping is important for the future of the Master Address Repository (MAR). The MAR allows collaboration when it comes to reporting missing addresses and residential units. In the future increased collaboration is the way to go.

P.S. Capital Gateway, themselves, also misplaced street names on their site plan.

Sunday, November 22, 2009

Why is the MAR Important?

  • The MAR has established a unified addressing standard. It allows the District Government to easily compare information about an address, block or intersection across databases and agencies.
  • Addressing standards are built into the MAR.
  • It has tools that allow for geocoding and information retrieval regarding addresses, intersections and blocks that enforce the standards.
  • MAR simplifies crosscutting queries by address within the DC Government.
Taken from the MAR Presentation (pdf)

Thursday, November 19, 2009

Problematic Addresses in the Integrated Tax System (ITS)

DC's Integrated Tax System (ITS) has thousands of incorrect and poorly formatted addresses for their properties. The Office of the Chief Financial Officer (OCFO) is responsible for the ITS and has been informed about significant problems with regarding to premise addresses in their database.

There are thousands of faulty records, some missing quadrants, incorrect street names, incorrect address numbers, missing premise addresses and more.

For an example go to: Search Real Property Assessment Database

Type in Square '0185' and Lot '0828' and then click 'Search Now' You will find that the Premise address field is missing the quadrant designation (it should be NW).

Below is an example where the ITS has incorrect addresses for four properties along 1400 block of 19th Street SE. In the image below the Master Address Repository (MAR) addresses are the green dots and the ITS addresses are the blue dots. It is clear from the image that their is a discrepancy between the MAR and the ITS regarding the proper locations of the addresses. In this case the MAR is correct. This has been confirmed by using USPS and Google Street View.




The ITS is one of many sources for the MAR. Unfortunately, some of the address errors in the ITS have infiltrated their way into the MAR. In the past few years, most of these address errors have been removed from the MAR. Now it is time for ITS to clean up their data.

Tuesday, November 17, 2009

NY Times Article on Collabrative Mapping

New York Times article on Collaborative Mapping. The article discusses the emerging field of collaborative mapping and how various organizations such as Google are taking advantage of it.

Collaborative mapping is important and there is much potential here. With regards to the MAR and collaborative mapping, the MAR Sample Client allow users to easily submit missing addresses or residential units. In the future the MAR will become more collaborative. This blog is meant as a way to reach out to users who are interested in collaborating with us or just learning more about the MAR.

Monday, November 16, 2009

Even and Odd Addresses

Even address numbers are assigned on the left side of the street as the numbers ascend. Odd numbers are assigned on the right side of the street as the numbers ascend. That is the side of the street is determined as one faces away from the US Capitol Building. Please see the below image from the Capitol Hill Neighborhood.


It should be noted that a very small percentage of addresses are not assigned that way and are thus considered address anomalies (large pdf).





Friday, November 13, 2009

Dakota Crossing



Dakota Crossing Development
The Dakota Crossing Development contains 202 townhouses located in the NE quadrant of Washington, DC. It sandwiched between South Dakota Avenue For, Lincoln Drive, 31st Place and 33rd Place NE. All the addresses in this development are in the Master Address Repository (MAR). The MAR data team has visited this site a few times to confirm addresses and the progress of the development. It is located in square 4325.

Tuesday, November 3, 2009

How are new addresses issued by DC Government?

The Department of Consumer and Regulatory Affairs (DCRA) is responsible for issuing new addresses. New addresses need to be approved by DCRA. DC GIS is tasked with maintaining the address database. DC GIS works closely with DCRA on address issues.

For more information about address applications please go to: DCRA Website


Monday, November 2, 2009

*** October 2009 Monthly MAR Report ***



Dataset Numbers:


  • Addresses: 141,827
  • Residential Units: 188,776
  • Aliases: 5,215
  • Street Name Alias: 1,022
  • Intersections: 16,382
  • Block: 15,825
  • Address / SSL Cross Reference Table: 235,456

--------------------------------

News:
  • The block & intersection table were updated

  • The MAR Frequently Asked Questions (FAQ) was expanded and reviewed. It is available on the MAR Website.

  • Working with Office of Unified Communications to help improve their addresses and place names in their Computer Aided Dispatch (CAD) for 911 and 311

Thursday, October 22, 2009

Components of a Washington DC Address

Components of an Address

Addresses shall be parsed into the following component parts and order:

  • Address Number
  • Address Number Suffix
  • Street Name
  • Street Type
  • Quadrant
  • Unit Number

There components of an address are concatenated when creating the address. An example would be 441 GENERIC STREET SE 101.

Address Number


Address numbers, street numbers, are numeric. There shall be no address numbers that are higher than 8500. Fractions, such as "½", are sometimes present, and are always considered address number suffixes.


Address Number Suffix
Fractions (such as '1/2'), as well as alphabetical designations (such as "A') and 'REAR' are not considered address numbers. They are considered address number suffixes. Not all alphabetical designations are to be considered address number suffixes, as some of them are unit numbers.

Street Name

All street names should be spelled out in full in the Master Street Name list. Common aliases for street names, including common abbreviations (e.g., "MLK Ave." for "Martin Luther King Jr. Avenue") are found in the street name alias table. The street name does not include the street type such as 'COURT', 'ROAD or 'STREET.'

Street Type

Street types should be spelled out in full in the in the Master Address Repository. Street Types include, but are not limited to 'ROAD', 'STREET', 'AVENUE', 'COURT' etc.

Quadrant

The quadrants are Northeast (NE), Northwest (NW), Southeast (SE) and Southwest (SW) and shall be abbreviated as shown above. All addresses in Washington DC have a quadrant attached to them (with the possible exception of the Capitol which is at the central point of the addressing grid. These quadrant designations are critical to location of addresses in Washington DC, and must be incorporated into every address.


Unit Number

Unit number denotes a housing occupancy which has a secondary designation. These can be apartments or condominiums

----------------------------------------------------------

This information as taken from the Master Address Repository (MAR) Address Standards Document (pdf).

Friday, October 16, 2009

Field Research Today



Today, the MAR Data Team is off to do field research (site visits) across a decently large area. We have some interesting sites to visit. Field research is often necessary as sometimes address issues cannot be solved in the office environment. Among the sites are:
  • St. Matthews Court NW & N Street NW
  • 1400 Block of Church Street NW
  • 1500 block of 9th Street NW
  • 1600 block of 11th Street NW
  • New York & 6th Street NW
  • 600 block of I Street NW
  • Union Station Bike Transit Center
  • Alley in Capitol Hill Neighborhood
  • Montello Avenue NE
  • 2100 & 2200 block of 24th Place NE
  • Evarts Street NE
  • 400 block of Rhode Island Avenue NE

Thursday, October 1, 2009

Monthly MAR Report: September 2009


Number of Records:
  • Addresses: 141,781
  • Residential Units: 188,801
  • Aliases: 5,199
  • Street Name Alias: 1,022
  • Intersections: 16,359
  • Block: 15,826
  • Address / SSL Cross Reference Table: 236,838

News:

The new DC GIS 2009 Orthoimage has been searched for changes affecting addresses and streets. Dozens of changes have been made based on the image search. About a dozen site visits remain in cases where changes cannot be confidently determined in the office environment.

Wednesday, September 30, 2009

Informative Article on DC Streets

The article Washington's systemic streets provided a solid history and explanation regarding DC's street system. Technical but definitely readable.

Tuesday, September 29, 2009

How does the MAR deal with empty lots?

Usually, empty lots will not have an address record associated with it . However, if there is a DCRA approved address for the lot, there should be an address record whose status is 'assigned'. If there was a building, that existed on the lot between 1999 to last year, and that building was demolished then it is highly likely that there will be an address record whose status is 'RETIRE'. The 'RETIRE' status indicates that the building is demolished and / or that the address is no longer in existence.



Empty Lots on the 1600 Block of Kramer Street NE

(Image from Google StreetView)

It is of low importance to the MAR Data Team to add new addresses for buildings that were demolished many years ago. (their status would be 'RETIRE')

Thursday, September 17, 2009

Residential Unit Submission Page

The MAR recently added a unit submission page where residential units can be submitted for inclusion in the Residential Units table. Units can only be submitted for primary addresses which already exist in the address table. To use this feature type go to the MAR Sample Client. Then type in the primary address (without the unit). If the address is valid then one gets to the Location Details page.




On the Location Details page it will show the details of the address. If the address already has residential units (in the MAR) it will show 'Unit: Display / Submit Unit(s).' If the address does not have any units (in the MAR) then it will show 'Unit: None. / Submit Unit(s).' If, for example, there are no units then click on the 'None. Submit Unit(s)' link, the Unit Submission Page will appear. See below image:



The user can then fill out the appropriate information and submit it to the MAR Data Team for inclusion. The submission will be reviewed and a followup email will be sent to the user.

Your assistance is appreciated. Currently, there are 188,298 residential units in the MAR. It is estimated that there should between 194,000 to 202,000 records.

Thursday, September 10, 2009

Searching New Imagery for Change


When DC GIS acquires new imagery there is a a need to perform change detection. Among the things being searched for are:

  • New Buildings
  • New Streets
  • Demolished Buildings
  • Demolished Streets
The new 2009 1 meter Imagery is searched using a a grid which overlays DC. The grid has 350 squares.

While looking at the new imagery, I found two addresses 3203 Georgia Avenue NW and 3205 Georgia Avenue NW which appeared to be demolished (see image at top of blog post). Since the 2009 imagery is of of low resolution compared to DC GIS's 2008 Orthophoto Imagery, I wanted confirmation that these two addresses had been demolished. I check with USPS to see if they were considered deliverable. They were still deliverable (which is and indication that they might be still in existence). So I googled these addresses. I found these two images (3203 & 3205) on flickr which stated these addresses had been demolished. This information coupled with the 2009 Imagery was sufficient to change the status of these addresses to 'RETIRE' in the addresses from the MAR. Demolished addresses receive a 'RETIRE' status in the MAR.

Wednesday, September 9, 2009

What is a Unit Block in DC?

A unit block in Washington, DC is a block that has a theoretical range of address numbers between 1 and 99. Most blocks can be referred to as something similar to the 100 block of Street Name, the 200 block of Street Name, 300 block of Street Name. It is awkward to call something the 0 block of, so instead the block is referred to as the unit block (example: Unit block of T Street NW)


The unit block of T Street NW (from Google Maps). It is located adjacent to, and just to the west of, North Capitol Street.


Unit blocks are located in three types of places:
  • Regular blocks on the address grid, usually located adjacent to East Capitol Street, North Capitol Street, South Capitol Street.
  • Circles (Dupont Circle NW, Logan Circle NW, Sherman Circle NW)
  • Alley Streets (Pomander Walk NW, Walter Houp Court NE)
Also check out Distribution of Addresses 1 - 99 (Unit Block).

Tuesday, September 1, 2009

Monthly MAR Data & Information Report: August 2009

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















-------------------------------------
Dataset Numbers:

  • Addresses: 141,769
  • Residential Units: 187,400
  • Aliases: 5,204
  • Street Name Alias: 1,022
  • Intersections: 16,359
  • Block: 15,826
  • Address / SSL Cross Reference Table: 235,565
--------------------------------------------

News:

We attended and presented twice regarding the MAR at the 2009 URISA/NENA Addressing Conference in Providence, RI. Useful information was learned from the dozens of presentations we attended.

Large development sites (areas) were field visited such as Dakota Crossing, National Baseball Stadium area, Henson Ridge Phase II and the Shops at Park Village. A small number of changes to the MAR were digitized due to the information collected.

Monday, August 31, 2009

Duplicate Address




Last week David & I went for the field research to check the location of 3233 15th Place SE as it was appearing at two locations.

Unfortunately 3233 15th Place SE was on two buildings ….may be 30 meters away. One for a cemetery and another for a new townhouse that looked unoccupied.

MAR team took initiative on this and informed DCRA to correct the address for of one of them; may be townhouse as that is the newly issued address as compare to the cemetery.
This kind of case is unusual and may create nightmare for address related services like getting mail and in emergency situations. However, one good thing is that the MAR team is taking good care of unusual address pattern/locations including duplicates. :)


Monday, August 24, 2009

Square, Suffix, Lot (SSL)


Today's topic is the Master Address Repository (MAR) and Square, Suffix, Lot. One of the goals of the MAR is to establish a better relationship between addresses and SSLs (property identifier). For a plethora of information regarding Square, Suffix and Lots check out the Vector Property Map (VPM) website. Also see Office of Surveyor which is tasked with maintaining the official map of property boundaries in Washington, DC. The Search Real Property Assessment Database is used to search and display real property assessment records, use the on-line public information database.


What is the relationship between an address and an SSL (property record)?

It is a many to many relationship. One SSL (Square, Suffix, Lot) can have multiple addresses located on it. This often includes garden style apartment complexes as well as corner addresses with separate addresses facing each adjacent street. One address can also sit upon multiple properties. One single family residence can sit upon multiple lots. The address records only contain one 'base' SSL (usually comes from OwnerPly). The cross reference table contains the many to many relationship between an address and an SSL. Some addresses do not have an associated SSL (such as some metro entrances or many addresses on Federal property). In, the address table, each address record will only be associated with one SSL. That SSL will be the base SSL, which is the SSL under which the address point is located.


What is the Address / SSL Cross Reference Table?

The Cross Reference table stores the relationship between an address and an SSL (property identifier). The relationship between these two items is a many to many. It stores over 200,000 records. One SSL (Square, Suffix, Lot) can have multiple addresses located on it. This often includes garden style apartment complexes as well as corner addresses with separate addresses facing each adjacent street. One address can also sit upon multiple properties. One single family residence can sit upon multiple lots. The address records only contain one 'base' SSL (usually comes from OwnerPly). The cross reference table contains the many to many relationship between Address ID and SSL. Some addresses do not have an associated SSL (such as metro entrances or many addresses on Federal property).

How is the Address / SSL Cross Reference Table maintained?

The Address / SSL Cross Reference Table is maintained by an automated process that is run each weekend. The table is completely repopulated each and every weekend. The table is created based on the following sources:
  • Vector Property Map (VPM)
  • Address Records
  • Condo Relate
  • Residential Unit Table
  • Integrated Tax System
  • Selected building polygons

Thursday, August 20, 2009

Place Names


The Master Address Repository (MAR) also includes place names (which we call alias names). It is important to have these place names in the MAR for multiple reasons. One reason is that many of these places do not have addresses and thus need to be located using their place name. For example the Washington Monument or the Carousel on the National Mall (see image).

The Alias (place) Table in the MAR contains names for building, historical sites, statues, metro station entrances, museums, federal buildings, hospitals, embassies, hotels and more. There are over 5,000 alias records, each of which is associated with an address. Using the MAR Sample Client alias names can be searched. Each and every alias record is associated with an address record. Multiple alias names can be associated with one address record.

Monday, August 3, 2009

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


-----------------------------------

Dataset Numbers:

Addresses: 141,728
Residential Units: 187,384
Aliases: 5,155
Street Name Alias: 1,021
Intersections: 16,359
Block: 15,826
Address / SSL Cross Reference Table: 235,456

------------------------------------------------

News:

The MAR training for Joseph Bembry, who is a DCRA Employee, had been completed. He will be reviewing and recommending new addresses. He has also been trained to directly add addresses to the MAR using the MAR Maintenance Tool.

80 roadwaysegment IDs were updated to reflect changes in the Department of Transportation's Street Spatial Database (SSD).

Sunday, August 2, 2009

Corner Buildings, Multiple Addresses


There are thousands of building located on street corners within Washington, DC. While the overwhelming majority of these buildings only have one address, some of these buildings have multiple addresses. An example of a corner building with multiple addresses is the building on the southwest corner of 7th Street & H Street NW:


  • 734 7TH STREET NW (Fuddrucker's)
  • 702 H STREET NW (small Office building with a few office suites)

One can view this location in Google Streetview. Both of these addresses are in the Master Address Repository.
Over the past few years the MAR Data Team has collected and mapped hundreds of these addresses located at corner buildings which have multiple addresses. This has been accomplished through processing millions of records which contained addresses located in Washington and through field research (site visits). Despite a large investment of time in this effort, there are still probably a few missing corner addresses.

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:

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.

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
News:

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.

Tuesday, June 23, 2009

Attending the 2009 URISA/NENA Addressing Conference


The MAR Data Team will be presenting at the 2009 URISA/NENA Addressing Conference which is scheduled for August 4-6, 2009 in Providence, Rhode Island. It is a national conference where we will learn much from others.



We will also be presenting two papers:
  • Building and Maintaining a Residential Unit Table for Washington, DC
  • Building and Maintaining the Master Address Repository (MAR) for Washington, DC

Wednesday, June 17, 2009

Family Gets a New Address In Bethesda -- Without Moving

The Washington Post has an article about how Montgomery County, MD changed an address of an existing house in order to accommodate an infill development. The address 6211 Wedgewood Road, Bethesda was changed to 6213 Wedgewood Road in order to make room for a teardown next door where the developer built two houses (where one previously existed). According to the Montgomery County planning Commission:

"The [Planning] Commission is responsible for ensuring that all newly assigned addresses in the County present a clear precise flow for public safety which is our number one priority."

By changing the address to 6213 (from 6211) it allowed the two houses next door to have the addresses 6209 & 6211. By performing this change, the addresses along this street are sequential and will not have 1/2 or address number suffixes (6209A, 6209B, 6209 1/2).

In Washington, DC we have dozens of address anamolies which are public safety hazards ( an example: 416 Cedar Street NW).

Wednesday, June 10, 2009

Faulty Addresses in DC Government Datasets

In DC Government databases, like other municipal government databases, the address is the most common geographic piece of information. DC Government databases contain tens of thousands of incorrect address in all sorts of datasets. Some of these incorrect addresses cause many problems as these records often cannot be located. Incorrect addresses also cause problems when comparing different datasets to each other based on the address. For example in a DC Net database there was an address of 500 C Street NW for the DC Superior Court but in actuality the address should be 500 Indiana Avenue NW.

It is my hope that the various DC Agencies take the issue of correct addresses seriously. DC GIS is working with various agencies such as Office of Tax & Revenue, Department of Parks & Recreation on address issues.

Wednesday, June 3, 2009

Address Problem: 1913 BLADENSBURG ROAD NE & 2300 T STREET NE


Moving Addresses
One Master Address Repository user, who works at DCWASA, found that the addresses 1913 BLADENSBURG ROAD NE and 2300 T STREET NE were in the wrong locations. He claimed that their locations needed to be switched.
After researching this issue using the Google Maps, Office of Tax & Revenue Data and web searches, it was determined that indeed these two addresses were in incorrect locations.
Using the MAR Maintenance Tool the two addressees were switched: 1913 BLADENSBURG ROAD NE has been moved into the property lot 0012 and 2300 T STREET NE has been moved into lot 0014.
Thanks to the user from DCWASA for providing this valuable information. The Master Address Repository Data Team appreciates this type of information as it assists us significantly in finding errors in the Master Address Repository.

Monday, June 1, 2009

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

Monthly Number of Loaded Records












Dataset Numbers:
  • Addresses: 141,693
  • Residential Units: 185,632
  • Aliases: 5,150
  • Street Name Alias: 1,021
  • Intersections: 16,359
  • Block: 15,826
  • Address / SSL Cross Reference Table: 235,645

News:


A major update of SSL (property) values in the ASSIGNED and RECOMMENDED Addresses was performed.

A large number of residential units were loaded into the MAR. There are now 185,632 records in the Residential Units Table. There are an estimated 194,000 – 202,000 residential units in Washington, DC; thus the Residential Unit Table is estimated to be between 91.9% - 95.6% complete.

Updated and published the MAR Presentation. It is available on the MAR Website.

The Address Anomalies Report has been updated. A few more cases have been added. It is available on the MAR Website.

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:

http://dcist.com/2006/04/12/not_exactly_eas.php


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


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

      News:

      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 dcaddresscoordinates.blogspot.com. 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.

      Thursday, April 30, 2009

      Addresses Per Quadrant

      Image: Distribution of Addresses by Quadrant


      The four quadrants in Washington have large difference in terms of land area and population. Similarly, there are also large difference in terms of the number of addresses.

      The Master Address Repository (MAR) has a total of 140,245 addresses:
      • NW: 64,825
      • NE 39,689
      • SE: 30,705
      • SW: 5,025

      Tuesday, April 28, 2009

      Field Research Today


      Today, the MAR Data Team went to do field research. Sometimes information regarding an address needs to be gathered in the field as well as in the office environment. Each week or so we go out to the field.

      Can anyone figure out where this picture was taken?

      Monday, April 27, 2009

      Collecting Data: Site Plans


      Site Plan for part of Capitol Gateway Development


      One of the strengths of the addresses in the MAR is that there are so many sources for the addresses. The above picture shows a site plan for Capitol Gateway Development. This picture was taken in December 2006. Capitol Gateway is located at the very eastern corner of Washington, DC.

      Wednesday, April 22, 2009

      416 Cedar Street NW = Address Anomaly


      The address of the Takoma Park Library is 416 Cedar Street NW which is an address anomaly. Address anomalies are illogical addresses.

      Why is 416 Cedar Street NW an address anomaly?

      Cedar Street is an east west street and is numbered as such. The address 416 Cedar Street NW is in the NW quadrant and thus as one heads further west along east west streets the address numbers increase. As one heads west from 5th Street (in the NW quadrant) the number should be 500 or greater. Since 416 Cedar Street NW is located just west of 5th Street NW it should have a 500 block designation. A logical address for the Takoma Library is 500 Cedar Street NW. The library should change their address so it easier to locate.


      Map of 416 Cedar Street NW. Click on image for larger view.

      There are dozens of addresses that are illogical. These addresses are illogical because they do not follow the normal rules of Washington, DC's addressing grid system. These illogical addresses are also referred to as address anomalies. DC GIS maintains an address anomalies list which can be viewed and downloaded on the following webpage:

      There are dozens of address anomalies in Washington, DC. DC GIS has spent hundreds of hours tracking down these cases and ensuring that the database matches the reality on the street.

      Please check out our Address Anomalies Report (very large pdf).

      Monday, April 20, 2009

      What is the relationship between an address and an SSL (property record)?

      It is a many to many relationship. One SSL (Square, Suffix, Lot) can have multiple addresses located on it. This often includes garden style apartment complexes as well as corner addresses with separate addresses facing each adjacent street. One address can also sit upon multiple properties. One single family residence can sit upon multiple lots. The address records only contain one 'base' SSL (usually comes from OwnerPly). The cross reference table contains the many to many relationship between Address ID and SSL. Some addresses do not have an associated SSL (such as metro entrances or many addresses on Federal property). In, the address table, each address record will only be associated with one SSL. That SSL will be the base SSL, which is the SSL under which the building rests upon. [Taken from the MAR FAQ (pdf)]

      Monday, April 13, 2009

      Henson Ridge Development


      Click on image for larger picture.

      Tuesday, April 7, 2009

      The MAR Within DC Government

      The MAR (Master Address Repository) was initiated, built and is maintained by DC GIS. DC GIS is the Washington, DC's Geographic Information System (GIS) Group which is part of the Office of the Chief Technology Officer (OCTO).

      The Department of Consumer and Regulatory Affairs (DCRA) is the agency responsible for issuing new addresses. Applications for new addresses should be filed with DCRA. DC GIS assists DCRA in reviewing these address applications. Most of these addresses from the address application are then added to the MAR.

      Monday, April 6, 2009

      Vacant Lots & Addresses

      Despite what many see as a crowded city, there are indeed thousands of vacant property lots in Washington. They are spread throughout the city but are especially prevalent in the lower income and more historic neighborhoods. In general vacant lots will not have an address in the Master Address Repository (MAR), unless:
      • A building with an address recently existed there. Example: 113 58TH STREET NE. (the address will have the STATUS of 'RETIRE').
      • A building will be built on this vacant lot in the near future. Example: 443 Woodcrest Drive SE.

      The Integrated Tax System (ITS) does have addresses for many vacant lots in the city such as 1329 North Capitol Street NE.

      Thursday, April 2, 2009

      Blog Introduction

      Is 441 4th Street NW a legitimate address? Where is the intersection of Naylor Road SE and R Street SE? What is an address anomaly? How many primary address are in Washington, DC?

      This blog will deal with these types of questions. Washington, DC has a comprehensive Master Address Repository (MAR) which not only contains addresses but also contains:
      • Intersections
      • Blocks
      • Places Names (alias names)
      • Residential Units

      In the coming months this blog will provide insights into Washington DC's Master Address Repository (MAR). Check out the official MAR Website.

      We look forward to hearing feedback from the readers of this blogs.

      Wednesday, April 1, 2009

      Monthly MAR Data & Information Report: March 2009











      Dataset Numbers:

      • Addresses: 141,633
      • Residential Units: 180,060
      • Aliases: 5,105
      • Street Name Alias: 1021
      • Intersections: 16.359
      • Block: 15,826
      • Address / SSL Cross Reference Table: 235,493


      Addresses:


      • Major update of addresses at the large Capitol Quarter development which is located just south of the Southeast Freeway between 3rd & 5th Street SE. See: http://www.eyacapitolquarter.com/


      • A major update of addresses at Emerson Park townhouse development which is located just south of the Fort Totten Metro Station.

      • Fixed incorrect Zipcode values for addresses on a part of Bolling Air Force Base.

      • National GRID issues were fixed


      Residential Units

      • Significant progress was made in March on improving the data in the Residential Units Table. Despite the progress there most probably between 10,000 - 15,000 missing residential units (estimated). It is estimated that the residential unit data is about 87% - 94% complete.


      Blocks:



      • Old blocks which no longer exist were deleted. 107 new blocks were added. These new blocks were often located in new residential developments such as Phillips Park and Emerson Park.


      Other:

      • A few street centerline updates were emailed to the folks at DDOT and OUC.

      • Automated the updating of National GRID Coordinates values when addresses are loaded using the MAR Batch Data Loading Procedure.
      • An update to Address / SSL Cross Reference Table so that when new addresses (except those that are retired) are added, the address and its associated SSL value is automatically populated into the Address / SSL Cross Reference Table.