About this Dataset

DEP Green Infrastructure (Medians)

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 "Medians" polygon layer contains large-scale green infrastructure practices within City-owned medians to target water quality objectives and inland flooding challenges.
Organization: City of New York
Last updated: 2025-10-04T21:32:23.966363
Tags: green-infrastructure

Tables

Table 1

@usgov.city_of_new_york_dep_green_infrastructure_medians.table_1

114.21 kB
24 rows
33 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" VARCHAR,
  "community" BIGINT,
  "city_counc" BIGINT,
  "assembly_d" BIGINT,
  "asset_leng" BIGINT,
  "asset_widt" DOUBLE,
  "asset_area" BIGINT,
  "gi_feature" VARCHAR,
  "tree_latin" VARCHAR,
  "tree_commo" VARCHAR,
  "constructi" VARCHAR,
  "construc_1" DOUBLE,
  "constructe" TIMESTAMP,
  "program_ar" VARCHAR,
  "status_gro" VARCHAR,
  "shape_leng" DOUBLE,
  "shape_area" DOUBLE
);