About this Dataset

DEP Green Infrastructure (Regulated Projects)

This dataset contains the locations and detailed information of green infrastructure practices in NYC neighborhoods built primarily through NYC Green Infrastructure Program initiatives. Green infrastructure (GI) collects stormwater from streets, sidewalks, and other hard surfaces before it can enter the sewer system or cause local flooding. The GI practice data contained in this dataset includes the location, program area, status, and type of GI. This dataset is updated by the NYC Department of Environmental Protection on a monthly basis. The “Regulated_Projects” polygon layer contains Unified Stormwater Rule green infrastructure projects. This layer is part of a larger Green Infrastructure dataset. You can download the full dataset and the data dictionary below under “Attachments”. Source Data: DEP Green Infrastructure Program Map
Organization: City of New York
Last updated: 2025-03-14T23:49:32.958301
Tags: green-infrastructure

Tables

Table 1

@usgov.city_of_new_york_dep_green_infrastructure_regulated_assets.table_1

48.48 kB
131 rows
32 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "asset_id" BIGINT,
  "gi_id" VARCHAR,
  "dep_contra" VARCHAR,
  "dep_cont_1" VARCHAR,
  "row_onsite" VARCHAR,
  "project_na" VARCHAR,
  "asset_type" VARCHAR,
  "status" VARCHAR,
  "asset_x_co" DOUBLE,
  "asset_y_co" DOUBLE,
  "borough" VARCHAR,
  "sewer_type" VARCHAR,
  "outfall" VARCHAR,
  "nyc_waters" VARCHAR,
  "bbl" BIGINT,
  "secondary" BIGINT,
  "community" BIGINT,
  "city_counc" BIGINT,
  "assembly_d" BIGINT,
  "asset_leng" DOUBLE,
  "asset_widt" BIGINT,
  "asset_area" DOUBLE,
  "gi_feature" VARCHAR,
  "tree_latin" VARCHAR,
  "tree_commo" VARCHAR,
  "constructi" VARCHAR,
  "construc_1" VARCHAR,
  "program_ar" VARCHAR,
  "status_gro" VARCHAR,
  "shape_leng" DOUBLE,
  "shape_area" DOUBLE
);