About this Dataset

Address Points Retired

The dataset contains locations and attributes of retired address points, created as part of the Master Address Repository (MAR) for the Office of the Chief Technology Officer (OCTO) and Department of Buildings (DOB). There are over 40,000 retired addresses. These once existed, but no longer do. More information on the MAR can be found at https://opendata.dc.gov/pages/addressing-in-dc. The data dictionary is available: https://opendata.dc.gov/documents/2a4b3d59aade43188b6d18e3811f4fd3/explore. In the MAR 2, the AddressPt is called ADDRESSES_PT and its features additional useful information such as placement location, created date, last edited date, begin date and more.
Organization: District of Columbia
Last updated: 2024-04-30T18:00:32.023382
Tags: district-of-columbia, location, mar, mardata, mardistrict, master-address-repository, octo, retired, street-address, washington-dc

Tables

Table 1

@usgov.district_of_columbia_address_points_retired.table_1

4.1 MB
45624 rows
52 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "address" VARCHAR,
  "address_number" DOUBLE,
  "address_number_suffix" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "quadrant" VARCHAR,
  "zipcode" DOUBLE,
  "city" VARCHAR,
  "state" VARCHAR,
  "country" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "address_type" VARCHAR,
  "status" VARCHAR,
  "ward" VARCHAR,
  "national_grid" VARCHAR,
  "has_ssl" VARCHAR,
  "has_place_name" VARCHAR,
  "has_condo" VARCHAR,
  "has_residential_unit" VARCHAR,
  "street_view_url" VARCHAR,
  "residential_type" VARCHAR,
  "housing_unit_count" DOUBLE,
  "residential_unit_count" DOUBLE,
  "placement" VARCHAR,
  "building" VARCHAR,
  "ssl" VARCHAR,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "lot" VARCHAR,
  "ssl_alignment" VARCHAR,
  "multiple_land_ssl" VARCHAR,
  "grid_direction" VARCHAR,
  "routeid" VARCHAR,
  "blockkey" VARCHAR,
  "subblockkey" VARCHAR,
  "mar_id" BIGINT,
  "metadata_id" BIGINT,
  "before_date" VARCHAR,
  "before_date_source" VARCHAR,
  "begin_date" VARCHAR,
  "begin_date_source" VARCHAR,
  "first_known_date" VARCHAR,
  "first_known_date_source" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_date" TIMESTAMP,
  "se_anno_cad_data" VARCHAR,
  "objectid" BIGINT
);