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

2 comments:

Donya27 said...

:) nice and impressive

john said...

Excellent,.,. More power to you.