search

NYCPlanning / db-knownprojects

KPDB: A compilation of prospective residential development projects from various sources, with rough projections of new unit counts
https://nycplanning.github.io/db-knownprojects
0 stars 0 forks source link

HPD PC date #373

Closed td928 closed 1 year ago

td928 commented 1 year ago

the new date format is not working with the existing see the code below

(CASE 
    WHEN closed_date = '-' THEN NULL 
    ELSE TO_CHAR(closed_date::date, 'YYYY/MM') 
END) AS date,
td928 commented 1 year ago

further investigation shows the issue is with projected closing source data with an extra row. fixed here