Parcel Lots
District of Columbia
@usgov.district_of_columbia_parcel_lots
District of Columbia
@usgov.district_of_columbia_parcel_lots
CREATE TABLE table_1 (
"objectid" BIGINT,
"creation_dt" TIMESTAMP,
"recordation_dt" TIMESTAMP,
"narrative" VARCHAR,
"expiration_dt" VARCHAR,
"status" BIGINT,
"square" VARCHAR,
"suffix" VARCHAR,
"par" BIGINT,
"lot" VARCHAR,
"lot_type" BIGINT,
"computed_area_sf" BIGINT,
"surveyed_area_sf" VARCHAR,
"mar_id" VARCHAR,
"is_rear_of" VARCHAR,
"bldg_num" VARCHAR,
"bldg_num_ext" VARCHAR,
"bldg_num_end_range" VARCHAR,
"bldg_ext_end_range" VARCHAR,
"quadrant" VARCHAR,
"zip5" VARCHAR,
"zip4" VARCHAR,
"record_area_sf" DOUBLE,
"conv_tolerance_type" DOUBLE,
"conv_tolerance_value" VARCHAR,
"conv_tolerance_resolution" VARCHAR,
"parcelsplyid" VARCHAR,
"squareplyid" VARCHAR,
"book_num" VARCHAR,
"page_num" VARCHAR,
"account_id" VARCHAR,
"is_theoretical_lot" DOUBLE,
"effectivetaxyear" VARCHAR,
"condo_regime_num" VARCHAR,
"kill_dt" TIMESTAMP,
"ssl" VARCHAR,
"col" VARCHAR,
"shape_length" DOUBLE,
"shape_area" DOUBLE
);
Anyone who has the link will be able to view this.