search

NYCPlanning / db-zoningtaxlots

Zoning Tax Lot Database (ZTLDB) -- associates zoning designations with lots from the Department of Finance Digital Tax Map
https://edm-data-engineering.nycplanningdigital.com/?page=Zoning+Tax+Lots
0 stars 0 forks source link

Add reports to report new special district, zoning district, commercial overlays, and limited height districts. #106

Open AmandaDoyle opened 3 years ago

AmandaDoyle commented 3 years ago

Add reports to report new special district, zoning district, commercial overlays, and limited height districts.

Working draft logic below

 WITH newspecialdistrict as (
 SELECT specialdistrict1 as specialdistrict FROM dcp_zoningtaxlots."2021/06/01"
 UNION 
 SELECT specialdistrict2 as specialdistrict FROM dcp_zoningtaxlots."2021/06/01"
 UNION
 SELECT specialdistrict3 as specialdistrict FROM dcp_zoningtaxlots."2021/06/01"
 ),
 oldspecialdistrict as (
 SELECT specialdistrict1 as specialdistrict FROM dcp_zoningtaxlots."2021/05/01"
 UNION 
 SELECT specialdistrict2 as specialdistrict FROM dcp_zoningtaxlots."2021/05/01"
 UNION
 SELECT specialdistrict3 as specialdistrict FROM dcp_zoningtaxlots."2021/05/01"
 )
 SELECT * FROM newspecialdistrict a where a.specialdistrict NOT IN (SELECT specialdistrict FROM oldspecialdistrict WHERE specialdistrict is not null);
 WITH newzoningdistrict as (
 SELECT zoningdistrict1 as zoningdistrict FROM dcp_zoningtaxlots."2021/06/01"
 UNION 
 SELECT zoningdistrict2 as zoningdistrict FROM dcp_zoningtaxlots."2021/06/01"
 UNION
 SELECT zoningdistrict3 as zoningdistrict FROM dcp_zoningtaxlots."2021/06/01"
 UNION
 SELECT zoningdistrict4 as zoningdistrict FROM dcp_zoningtaxlots."2021/06/01"
 ),
 oldzoningdistrict as (
 SELECT zoningdistrict1 as zoningdistrict FROM dcp_zoningtaxlots."2021/05/01"
 UNION 
 SELECT zoningdistrict2 as zoningdistrict FROM dcp_zoningtaxlots."2021/05/01"
 UNION
 SELECT zoningdistrict3 as zoningdistrict FROM dcp_zoningtaxlots."2021/05/01"
 UNION
 SELECT zoningdistrict4 as zoningdistrict FROM dcp_zoningtaxlots."2021/05/01"
 )
 SELECT * FROM newzoningdistrict a where a.zoningdistrict NOT IN (SELECT zoningdistrict FROM oldzoningdistrict WHERE zoningdistrict is not null);
WITH newcommercialoverlay as (
 SELECT commercialoverlay1 as commercialoverlay FROM dcp_zoningtaxlots."2021/06/01"
 UNION 
 SELECT commercialoverlay2 as commercialoverlay FROM dcp_zoningtaxlots."2021/06/01"
 ),
 oldcommercialoverlay as (
 SELECT commercialoverlay1 as commercialoverlay FROM dcp_zoningtaxlots."2021/05/01"
 UNION 
 SELECT commercialoverlay2 as commercialoverlay FROM dcp_zoningtaxlots."2021/05/01"
 )
 SELECT * FROM newcommercialoverlay a where a.commercialoverlay NOT IN (SELECT commercialoverlay FROM oldcommercialoverlay WHERE commercialoverlay is not null);
 WITH newlimitedheightdistrict as (
 SELECT DISTINCT limitedheightdistrict FROM dcp_zoningtaxlots."2021/06/01"
 ),
 oldlimitedheightdistrict as (
 SELECT DISTINCT limitedheightdistrict FROM dcp_zoningtaxlots."2021/05/01"
 )
 SELECT * FROM newlimitedheightdistrict a where a.limitedheightdistrict NOT IN (SELECT limitedheightdistrict FROM oldlimitedheightdistrict WHERE limitedheightdistrict is not null);