Address SMD And ANC Changes by US Government | Demographics and Population Studies

About this Dataset

Address SMD And ANC Changes

Addresses that have changed ANC and SMD as a result of new delineations in the Advisory Neighborhood Commission Boundaries Act of 2022, signed into law on June 16, 2022. They are in effect beginning January 1, 2023. View the ANC 2023 and SMD 2023 boundaries.
Organization: District of Columbia
Last updated: 2024-04-30T18:44:06.502043
Tags: address, anc-changes, dc, district-of-columbia, location, mar, mardistrict, master-address-repository, octoedi, smd-changes, washington-dc

Tables

Table 1

@usgov.district_of_columbia_address_smd_and_anc_changes.table_1

3.69 MB
86583 rows
19 columns


CREATE TABLE table_1 (
  "address_id" BIGINT,
  "addrnum" DOUBLE,
  "addrnumsuffix" VARCHAR,
  "stname" VARCHAR,
  "street_type" VARCHAR,
  "quadrant" VARCHAR,
  "fulladdress" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "ward_2022" VARCHAR,
  "zipcode" DOUBLE,
  "res_type" VARCHAR,
  "anc_2013" VARCHAR,
  "smd_2013" VARCHAR,
  "anc_2023" VARCHAR,
  "smd_2023" VARCHAR,
  "changed_smd" VARCHAR,
  "changed_anc" VARCHAR,
  "objectid" BIGINT
);