Parcels
City of Seattle
@usgov.city_of_seattle_parcels_1b463
City of Seattle
@usgov.city_of_seattle_parcels_1b463
CREATE TABLE table_1 (
"objectid" BIGINT,
"pin" VARCHAR,
"address" VARCHAR,
"prop_name" VARCHAR,
"land_sqft" BIGINT,
"parcel_dev_sqft" BIGINT,
"land_use_code" BIGINT,
"land_use_desc" VARCHAR,
"land_use_desc_10" VARCHAR,
"zoning" VARCHAR,
"zonelut" VARCHAR,
"mio_base_zone" VARCHAR,
"class" VARCHAR,
"zone_geo" VARCHAR,
"villnumb" DOUBLE,
"trbl10" DOUBLE,
"rescat" VARCHAR,
"empcat" VARCHAR,
"pub_own_type" VARCHAR,
"tax_status" VARCHAR,
"sf_units" BIGINT,
"mf_units" BIGINT,
"exist_units" BIGINT,
"yr_built" BIGINT,
"maxrdens" BIGINT,
"obs_rdens_units" BIGINT,
"res_far" DOUBLE,
"obs_far_units" BIGINT,
"res_max_far" DOUBLE,
"max_far_units" BIGINT,
"max_res_fl_area" BIGINT,
"bldg_grss_sqft" BIGINT,
"bldg_res_grssqf" BIGINT,
"bldg_com_grssqf" BIGINT,
"comm_far" DOUBLE,
"obs_comm_fl_area" BIGINT,
"comm_max_far" DOUBLE,
"max_comm_fl_area" BIGINT,
"redev_fl_area" BIGINT,
"bldg_av" BIGINT,
"land_av" BIGINT,
"landmark" VARCHAR,
"stat_type" VARCHAR,
"ratio" DOUBLE,
"ilr" DOUBLE,
"dr" DOUBLE,
"resstat" VARCHAR,
"comstat" VARCHAR,
"splitres" DOUBLE,
"splitcom" DOUBLE,
"empl" BIGINT,
"adjrcap_maxrdens_sfl" BIGINT,
"adjrcap_fl_area_max" BIGINT,
"adjccap" BIGINT,
"exist_empl" BIGINT,
"empcap" BIGINT,
"zone_type" VARCHAR,
"dc_type" VARCHAR,
"built_far" DOUBLE,
"max_far" DOUBLE,
"avail_far" DOUBLE,
"avail_sqft" BIGINT,
"sym_comm" DOUBLE,
"status_text_1" VARCHAR,
"sym_res" DOUBLE,
"status_text_2" VARCHAR,
"use_category" VARCHAR,
"year_built_n" BIGINT,
"uv_name" VARCHAR,
"pin_link" VARCHAR,
"shape_area" DOUBLE,
"shape_length" DOUBLE
);
Anyone who has the link will be able to view this.