HistoricZoningDistricts2008
City of San Francisco
@usgov.city_of_san_francisco_historiczoningdistricts2008
City of San Francisco
@usgov.city_of_san_francisco_historiczoningdistricts2008
CREATE TABLE table_1 (
"blklot" VARCHAR,
"mapblklot" VARCHAR,
"block_num" VARCHAR,
"the_geom" VARCHAR,
"lot_num" VARCHAR,
"from_st" VARCHAR,
"to_st" VARCHAR,
"street" VARCHAR,
"st_type" VARCHAR,
"odd_even" VARCHAR,
"id" BIGINT,
"block" DOUBLE,
"lot" DOUBLE,
"blocklot" DOUBLE,
"zip" VARCHAR,
"neighborho" VARCHAR,
"planningdi" BIGINT,
"taz" BIGINT,
"mixed_use" VARCHAR,
"restype" VARCHAR,
"resunits" BIGINT,
"lastsale" VARCHAR,
"lastsalepr" BIGINT,
"assessedva" BIGINT,
"estimatedv" BIGINT,
"landval" BIGINT,
"strucval" BIGINT,
"usetype" VARCHAR,
"rescom_uni" BIGINT,
"landuse" VARCHAR,
"stories" BIGINT,
"bdrms" BIGINT,
"bldgsqft" BIGINT,
"lidarsqft" BIGINT,
"high_sqft" BIGINT,
"lidarstori" BIGINT,
"yrbuilt" BIGINT,
"ownrname" VARCHAR,
"address1" VARCHAR,
"address2" VARCHAR,
"total_uses" BIGINT,
"cie" BIGINT,
"med" BIGINT,
"mips" BIGINT,
"retail" BIGINT,
"pdr" BIGINT,
"visitor" BIGINT,
"zoning" VARCHAR,
"current_zo" VARCHAR,
"zoning_sim" VARCHAR,
"zoning_gen" VARCHAR,
"zoningtrea" VARCHAR,
"heightlimi" VARCHAR,
"heightnum" BIGINT,
"censustrac" BIGINT,
"lu_cleanup" VARCHAR,
"source" VARCHAR,
"updatedate" VARCHAR,
"annotation" VARCHAR,
"landname" VARCHAR,
"publicfacs" BIGINT,
"landuse_20" VARCHAR,
"lcu" BIGINT,
"paperlot" BIGINT,
"changedsin" BIGINT,
"temp" BIGINT,
"x" DOUBLE,
"y" DOUBLE,
"bldgindust" BIGINT,
"costarrba" BIGINT,
"costarinfe" BIGINT,
"flex_bldg" BIGINT,
"industrial" BIGINT,
"office_bld" BIGINT,
"retail_bld" BIGINT,
"building_t" BIGINT,
"taz2007" BIGINT,
"zoning_com" VARCHAR,
"stories_co" BIGINT,
"pdr_possib" BIGINT,
"pdr_share" BIGINT,
"height_010" BIGINT,
"height_11" BIGINT,
"overlay" BIGINT,
"incomplete" BIGINT,
"height_sto" BIGINT,
"height_s_1" BIGINT,
"livework_n" BIGINT,
"ressqft_ex" BIGINT,
"commlsqft" BIGINT,
"commlsqft1" BIGINT,
"commlsqf_1" BIGINT,
"units_new" BIGINT,
"ressqft" BIGINT,
"commsqft" BIGINT,
"commsqft_p" BIGINT,
"commsqft_m" BIGINT,
"totalsqft" BIGINT,
"netunits" BIGINT,
"netsqft" BIGINT
);
Anyone who has the link will be able to view this.