Monday, December 21, 2009
Thursday, December 10, 2009
- 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
- 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.
Tuesday, December 1, 2009
- Addresses: 141861
- Residential Units: 189880
- Aliases: 5216
- Street Name Aliases: 1055
- Intersections: 16382
- Blocks: 15825
- Address / SSL Cross Reference: 236082
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
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.
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).
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
- 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.
Thursday, November 19, 2009
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
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
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
Tuesday, November 3, 2009
For more information about address applications please go to: DCRA Website
Monday, November 2, 2009
- 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
- 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 an Address
Addresses shall be parsed into the following component parts and order:
- Address Number
- Address Number Suffix
- Street Name
- Street Type
- Unit Number
There components of an address are concatenated when creating the address. An example would be 441 GENERIC STREET SE 101.
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.
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 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.
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 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
- 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
- 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
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
Tuesday, September 29, 2009
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.
(Image from Google StreetView)
Thursday, September 17, 2009
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
- New Buildings
- New Streets
- Demolished Buildings
- Demolished Streets
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
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)
Tuesday, September 1, 2009
- 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
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
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
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
Monday, August 3, 2009
Residential Units: 187,384
Street Name Alias: 1,021
Address / SSL Cross Reference Table: 235,456
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
- 734 7TH STREET NW (Fuddrucker's)
- 702 H STREET NW (small Office building with a few office suites)
Tuesday, July 28, 2009
Sunday, July 26, 2009
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
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
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 *****
May Data Loads into Addresses, Alias, Units, Street Names Aliases:
- 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.
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
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
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
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
Monday, June 1, 2009
- 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
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
- Unit Num
- Unit Type
- Unit ID
- Address ID
- Condo SSL
- Condo Square
- Condo Suffix
- Condo Lot
- Condo Book
- Condo Page
- Metadata ID
- 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?
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
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
- Publish Address Standards
- Implement Mobile Mapping Technology
- Create Residential Unit Submission Page
- Present paper regarding Addresses and Residential Units at the 2009 URISA / NENA Addressing Conference
- Present paper regarding Regarding Residential Units at the 2009 ESRI International User Conference
Monday, May 11, 2009
Click on image for larger version.
Sunday, May 10, 2009
- 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.
Thursday, May 7, 2009
Wednesday, May 6, 2009
- 1500 Galen Street SE
- 1504 Galen Street SE
Tuesday, May 5, 2009
Monday, May 4, 2009
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
basement locations which have the 1/2 designation as an address number suffix.
Friday, May 1, 2009
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
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
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
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
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
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
Tuesday, April 7, 2009
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
- 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
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:
- 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
- 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
- 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
- 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.
- 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.
- 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.