From a 500-row sample across 35 columns.
row_onsiteasset_typethe_geom+27row_onsiteasset_typethe_geom+27row_onsiteasset_typethe_geom+27Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | asset_id | gi_id | dep_contra | dep_cont_1 | row_onsite | project_na | asset_type | status | asset_x_co | asset_y_co | borough |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.61159, -73.99605 | 189376 | PP6059 | 4 | GKOH15-04 | ROW | DDC OH15 Phase 4 | ROW Porous Concrete | 100% Design Submitted | 985347.41 | 162095.64 | Brooklyn |
| 40.74391, -73.78948 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | — | 0% | {'coordinates': [-73.810…{'coordinates': [-73.950…{'coordinates': [-73.880… |
asset_id | integer | — | 0% | 940129401794019 |
gi_id | text | — | 0% | RG-2RG-1RG-3 |
dep_contra | categorical | — | 0% | 123of 10 |
GET /api/datasets/df32-vzax GET /api/datasets/df32-vzax/quality GET /api/datasets/df32-vzax/related GET /api/columns?dataset=df32-vzax
borough:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+3borough:@computed_region_sbqj_enih:@computed_region_92fq_4b7q+3boroughbbl:@computed_region_sbqj_enih:@computed_region_92fq_4b7qbbl+2| 140887 |
| IB1996C |
| 3 |
| GQTI10-03 |
| ROW |
| DDC TI-010 Phase 3 |
| ROW Infiltration Basin with Grass Top |
| Constructed (Full Maintenance) |
| 1042584.59 |
| 210374.73 |
| Queens |
| 40.68966, -73.82001 | 94361 | 280B | 2 | GQJA03-02 | ROW | DDC JAM-003 Phase 2 | ROWB | Constructed (Full Maintenance) | 1034165.69354 | 190589.26513 | Queens |
| 40.73762, -73.78151 | 102331 | 725A | 2 | GQTI10-02 | ROW | DDC TI-010 Phase 2 | ROWB | Constructed (Full Maintenance) | 1044799.54959 | 208086.53344 | Queens |
| 40.84955, -73.86076 | 96846 | 516D | 2 | GXHP07-03 | ROW | EDC HP-007 Phase 2 | ROWB | Constructed (Full Maintenance) | 1022771.5163 | 248822.894 | Bronx |
| 40.65641, -73.92028 | 150445 | 1c | 3 | GK26W3-03 | ROW | EDC 26W-003 (Fresh Creek) Phase 3 | ROWB | Constructed (Full Maintenance) | 1006368.28 | 178432.95 | Brooklyn |
| 40.74409, -73.78932 | 140882 | IB1995A | 3 | GQTI10-03 | ROW | DDC TI-010 Phase 3 | ROW Infiltration Basin with Grass Top | Constructed (Full Maintenance) | 1042630.08 | 210439.65 | Queens |
| 40.64019, -73.91709 | 174039 | 2114C | 3 | GKCI05-03 | ROW | EDC CI005 Phase 3 | ROWB | Constructed (Full Maintenance) | 1007258.783 | 172526.8921 | Brooklyn |
| 40.61116, -73.99701 | 189378 | PP6065 | 4 | GKOH15-04 | ROW | DDC OH15 Phase 4 | ROW Porous Concrete | 100% Design Submitted | 985078.81 | 161938.69 | Brooklyn |
| 40.65905, -73.92018 | 133241 | 634B | 1 | GK26W3-03 | ROW | EDC 26W-003 (Fresh Creek) Phase 1 | ROWB | Constructed (Full Maintenance) | 1006395.98 | 179394.35 | Brooklyn |
Showing 12 of 35 columns. All of them are listed below.
dep_cont_1 | text | — | 0% | GK26W3-03GKNC15-02GK26W5-05 |
row_onsite | categorical | — | 0% | ROWOnsiteof 2 |
project_na | text | — | 0% | EDC 26W-005 Phase 2Design of Kissena Cloudb…DDC TI-010 Phase 4 |
asset_type | text | — | 0% | ROWBROW Infiltration Basin w…ROW Porous Concrete |
status | categorical | — | 0% | Constructed (Full Mainte…Constructed100% Design Submittedof 7 |
asset_x_co | float | — | 0% | 1036848.62076997919.151017326.88401 |
asset_y_co | float | — | 0% | 209105.51951203797.195253487.76991 |
borough | categorical | — | 0% | QueensBrooklynBronxof 5 |
sewer_type | categorical | — | 0% | CombinedMS4Non-combinedof 4 |
outfall | text | — | 0% | TI-010CI-00526W-005 |
nyc_waters | categorical | — | 0% | Jamaica Bay and Tributar…Flushing CreekEast River / Open Watersof 12 |
bbl | text | — | 0% | 204905000110000000004054620001 |
secondary_ | text | — | 85% | 100000000040201800014019760028 |
community_ | integer | — | 0% | 407305410 |
city_counc | integer | — | 0% | 204241 |
assembly_d | integer | — | 0% | 255854 |
asset_leng | float | — | 0% | 10.020.013.0 |
asset_widt | float | — | 0% | 5.04.04.5 |
asset_area | float | — | 0% | 100.050.052.0 |
gi_feature | categorical | — | 24% | StandardType C - SW ChamberType A - Stone Columnsof 8 |
tree_latin | text | — | 22% | No TreeOther (See notes)Quercus bicolor |
tree_commo | text | — | 22% | N/ASwamp White OakPin Oak |
constructi | text | — | 9% | GK26W3-03GKNC15-02CQTI10KIS |
construc_1 | text | — | 9% | 123 |
program_ar | categorical | — | 0% | Right of Way (ROW)Public OnsiteExternalof 4 |
status_gro | categorical | — | 0% | ConstructedFinal DesignIn Constructionof 3 |
constructed_date | datetime | Estimated completion date of the asset. | 13% | 2021-06-29T00:00:00.0002024-04-30T00:00:00.0002025-03-13T00:00:00.000 |