About this Dataset

DEP Green Infrastructure (Point Layer)

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. 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-01-31T23:01:34.745158
Tags: green-infrastructure

Tables

Table 1

@usgov.city_of_new_york_dep_green_infrastructure_f5704.table_1

1.23 MB
14,375 rows
30 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" DOUBLE,
  "asset_area" DOUBLE,
  "gi_feature" VARCHAR,
  "tree_latin" VARCHAR,
  "tree_commo" VARCHAR,
  "constructi" VARCHAR,
  "construc_1" VARCHAR,
  "program_ar" VARCHAR,
  "status_gro" VARCHAR
);