Zoning Lookup Layer
District of Columbia
@usgov.district_of_columbia_zoning_lookup_layer_1c4b5
District of Columbia
@usgov.district_of_columbia_zoning_lookup_layer_1c4b5
The zoning layer lookup aids the online zoning map to show zoning information by address and consolidates other important information such as Ward, ANC, SMD, Historic Districts, etc. in one reference dataset. The PREMISEADD field lists the address that is identified as the lot’s primary address for tax purposes. ADDRESS_OTHER contains a list of all other addresses on the lot, if any. Addresses may exist in a many-to-one relationship with property lots. ZONING is the primary field for zoning designation. ZONING_LABEL contains the zoning as well as any applicable IZ+ designation.
Organization: District of Columbia
Last updated: 2025-03-11T23:40:55.792971
Tags: dc, dcoz, district-of-columbia, land-use, planning, real-property, washington-dc, zoning, zr16
CREATE TABLE table_1 (
"objectid" BIGINT,
"square" VARCHAR,
"suffix" VARCHAR,
"res" VARCHAR,
"par" VARCHAR,
"lot" VARCHAR,
"ssl" VARCHAR,
"premiseadd" VARCHAR,
"owner_unitnumber" VARCHAR,
"owner_name" VARCHAR,
"owner_careofname" VARCHAR,
"owner_address" VARCHAR,
"owner_citystzip" VARCHAR,
"streetname" VARCHAR,
"qdrntname" VARCHAR,
"address_other" VARCHAR,
"ward_id" VARCHAR,
"ward_name" VARCHAR,
"ward_rep_name" VARCHAR,
"ward_rep_email" VARCHAR,
"ward_web_url" VARCHAR,
"ward_rep_phone" VARCHAR,
"ward_rep_office" VARCHAR,
"anc_id" VARCHAR,
"anc_name" VARCHAR,
"anc_web_url" VARCHAR,
"anc_rep_name" VARCHAR,
"anc_email" VARCHAR,
"anc_address" VARCHAR,
"smd_email" VARCHAR,
"smd_web_url" VARCHAR,
"smd_rep_name" VARCHAR,
"smd_name" VARCHAR,
"smd_id" VARCHAR,
"smd_address" VARCHAR,
"zoning" VARCHAR,
"zoning_label" VARCHAR,
"zone_district" VARCHAR,
"zr16_original" VARCHAR,
"zr58" VARCHAR,
"zoning_web_url" VARCHAR,
"iz_designation" VARCHAR,
"overlay_short" VARCHAR,
"overlay_name" VARCHAR,
"overlay_link" VARCHAR,
"downtown_tradearea" VARCHAR,
"downtown_subarea" VARCHAR,
"ma_casenumber" VARCHAR,
"ma_url" VARCHAR,
"pud_name" VARCHAR,
"pud_web_url" VARCHAR,
"pud_zoning" VARCHAR,
"pud_status" VARCHAR,
"pud_case_number" VARCHAR,
"dr_casenumber" VARCHAR,
"dr_url" VARCHAR,
"campus_url" VARCHAR,
"campus_name" VARCHAR,
"historicdistrict_name" VARCHAR,
"historiclandmark_label" VARCHAR,
"flum_allcodes" VARCHAR,
"census_name" VARCHAR,
"census_url" VARCHAR
);Anyone who has the link will be able to view this.