About this Dataset

Address Points

The dataset contains locations and attributes of 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). It contains the addresses in the District of Columbia which are typically placed on the buildings. Visit opendata.dc.gov/pages/addressing-in-dc#documentation for more information on the MAR.
Organization: District of Columbia
Last updated: 2024-04-30T18:34:22.297868
Tags: district-of-columbia, location, mar, mardata, mardistrict, master-address-repository, octo, street-address, washington-dc

Tables

Table 1

@usgov.district_of_columbia_address_points_348c5.table_1

24.95 MB
144,279 rows
54 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "mar_id" BIGINT,
  "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,
  "routeid" VARCHAR,
  "blockkey" VARCHAR,
  "subblockkey" VARCHAR,
  "ward" VARCHAR,
  "metadata_id" BIGINT,
  "national_grid" VARCHAR,
  "has_ssl" VARCHAR,
  "has_place_name" VARCHAR,
  "has_condo" VARCHAR,
  "has_residential_unit" VARCHAR,
  "street_view_url" VARCHAR,
  "residential_type" VARCHAR,
  "placement" VARCHAR,
  "ssl_alignment" VARCHAR,
  "building" VARCHAR,
  "ssl" VARCHAR,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "lot" VARCHAR,
  "multiple_land_ssl" VARCHAR,
  "grid_direction" VARCHAR,
  "housing_unit_count" BIGINT,
  "residential_unit_count" DOUBLE,
  "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,
  "smd" VARCHAR,
  "anc" VARCHAR
);