notes.txt

SELECT * FROM plutoshapes a LEFT OUTER JOIN (SELECT address,allzoning1,allzoning2,appbbl,appdate,areasource,assessland,assesstot,bbl as bbl2,bldgarea,bldgclass,bldgdepth,bldgfront,block,borocode,borough,bsmtcode,builtcode,builtfar,cb2010,cd,comarea,commfar,condono,council,ct2010,easements,edesignum,exemptland,exempttot,ext,facilfar,factryarea,firecomp,garagearea,healtharea,histdist,irrlotcode,landmark,landuse,lot,lotarea,lotdepth,lotfront,lottype,ltdheight,numbldgs,numfloors,officearea,otherarea,overlay1,overlay2,ownername,ownertype,plutomapid,policeprct,proxcode,resarea,residfar,retailarea,sanborn,schooldist,spdist1,spdist2,splitzone,strgearea,taxmap,tract2010,unitsres,unitstotal,version,xcoord,ycoord,yearalter1,yearalter2,yearbuilt,zipcode,zmcode,zonedist1,zonedist2,zonedist3,zonedist4,zonemap FROM pluto14v2) b ON a.bbl = b.bbl2

DARK GRAY: #2A313D
BLUE: #2C9AE9