About this Dataset

Address And Square Suffix Lot Cross Reference

The relationship between a property and an address is many-to-many. In DC a SSL (Square, Suffix, Lot) is used to identify a property. One SSL can have multiple addresses located on it. This often includes garden-style apartment complexes as well as corner buildings with separate addresses facing each adjacent street. One address can also sit upon multiple SSLs. One single family residence can sit upon multiple lots. The cross reference table contains the many-to-many relationship between address IDs and SSLs. [A small percentage of addresses do not have an associated SSL (such as metro entrances or many addresses on Federal property.] Use this cross reference table to relate the District's address points in the Master Address Repository (MAR) with the SSLs and vice versa.
Organization: District of Columbia
Last updated: 2024-07-03T03:08:58.961150
Tags: address, dc, district-of-columbia, location, mardistrict, parcel, property, square-suffix-lot, ssl, washington-dc

Tables

Table 1

@usgov.district_of_columbia_address_and_square_suffix_lot_cro_0b0c2f19.table_1

6.29 MB
241,678 rows
11 columns

CREATE TABLE table_1 (
  "ssl" VARCHAR,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "lot" VARCHAR,
  "parcel" DOUBLE,
  "reservation" VARCHAR,
  "lot_type" VARCHAR,
  "address_id" BIGINT,
  "marid" BIGINT,
  "col" VARCHAR,
  "objectid" BIGINT
);