From a 500-row sample across 25 columns.
:@computed_region_sbqj_enih:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+10ntacommunity_boardlongitude+4ntacommunity_boardMappable — Socrata point column `location_1`.
Open on the map →| name | boro | geo_dist | projdesc | award | consttype | buildingid | building_address | city | zip_code | borough | latitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| P.S. 46 - MANHATTAN | M | 5 | FULL PROGRAM ACCESSIBILITY | 11997400 | CIP | M046 | 2987 FREDERICK DOUGLASS BOULEVARD | Manhattan | 11206 | — | — |
| P.S. 83 - BRONX | X |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
name | text | Name of School | 0% | HS FOR HEALTH CAREER & S…FRANCIS LEWIS HS - QUEEN…P.S. 70 - BRONX |
boro | categorical | Borough school exists | 0% | QKXof 5 |
geo_dist | integer | District school exists | 0% | 273124 |
projdesc | text | Description of work | 0% | IPDVS INSTALLATIONS / IP…IPDVS INSTALLATIONS / IP…PLANYC BOILER CONVERSION… |
GET /api/datasets/8586-3zfm GET /api/datasets/8586-3zfm/quality GET /api/datasets/8586-3zfm/related GET /api/columns?dataset=8586-3zfm
longitudecommunity_boardlongitudelatitude+4:@computed_region_sbqj_enih:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+4ntacommunity_boardlongitude+5| 11 |
| ROOFS / MECHANICAL EQUIPMENT REPLACEMENT / EXTERIOR MASONRY / PARAPETS / ROOFS |
| 21441000 |
| CIP |
| X981 |
| 1840 BOGART AVENUE |
| Bronx |
| 11206 |
| BRONX |
| 40.848222 |
| CROTONA INTERNATIONAL HIGH SCHOOL - BRONX | X | 10 | PATH OF TRAVEL RESO A PLAYGROUND UPGRADE / FY23 RESO A PLAYGROUND UPGRADE | 2798000 | CIP | X660 | 2474 CROTONA AVENUE | Bronx | 11206 | BRONX | 40.855698 |
| X721 SPED - BRONX | X | 11 | EXTERIOR MASONRY WATER PENETRATION / WINDOWS / ROOFS / FLOOD ELIMINATION / PARAPETS | 9394223 | CIP | X722 | 2697 WESTCHESTER AVENUE | Bronx | 11206 | BRONX | 40.842289 |
| ELLIS PREPARATORY ACADEMY-X | X | 10 | WALK-IN REFRIGERATOR AND FREEZERS | 659500 | CIP | X475 | 99 TERRACE VIEW AVENUE | Bronx | 11206 | BRONX | 40.877105 |
| HERO HIGH (HEALTH, EDUCATION, AND RESEARCH OCCUPAT | X | 7 | BATHROOM UPGRADES / GYM UPGRADE | 3775000 | CIP | X655 | 455 SOUTHERN BOULEVARD | Bronx | 11206 | BRONX | 40.810803 |
| X721 SPED - BRONX | X | 11 | ROOF REPLACEMENT | 2778600 | CIP | X722 | 2697 WESTCHESTER AVENUE | Bronx | 11206 | BRONX | 40.842289 |
| MINIVENTURES OF NY, INC.- SITE #4 - BRONX | X | 10 | LSP - ACS EARLY LEARN LEASE RENEWAL | 42700 | CIP | XAYF | 2863 WEBSTER AVENUE | Bronx | 11206 | BRONX | 40.866931 |
| X010 SPED - BRONX | X | 12 | IPDVS INSTALLATIONS / IPDVS INSTALLATIONS / IPDVS INSTALLATIONS | 344000 | CIP | X817 | 1680 HOE AVENUE | Bronx | 11206 | BRONX | 40.835765 |
| HERO HIGH (HEALTH, EDUCATION, AND RESEARCH OCCUPAT | X | 7 | IPDVS CAMERA INSTALLATION / IPDVS CAMERA INSTALLATION / IPDVS CAMERA INSTALLATION | 568596 | CIP | X655 | 455 SOUTHERN BOULEVARD | Bronx | 11206 | BRONX | 40.810803 |
Showing 12 of 25 columns. All of them are listed below.
award | float | Value of Prime Construction contract | 0% | 035000015700000 |
consttype | categorical | Identifies the project as CIP or Capacity | 0% | CIPCAPof 2 |
buildingid | text | ID of the Building | 0% | M465Q216Q485 |
building_address | text | Address of the Building | 0% | 549 AUDUBON AVENUE67-01 110 STREET317 EAST 67 STREET |
city | categorical | City | 0% | QueensBrooklynBronxof 6 |
zip_code | integer | Mailing zip Code | 0% | 112061137511101 |
borough | categorical | Borough name | 0% | QUEENSBROOKLYNBRONXof 5 |
latitude | float | Latitude of the site's location | 0% | 40.85585540.72940240.711033 |
longitude | float | Longitude of the site's location | 0% | -73.92712-73.845637-73.79283 |
community_board | integer | The Community Board field indicates the New York City Community District where the site is located | 0% | 412112405 |
community_council | integer | The Council District field indicates the New York City Council District where the site is located | 0% | 151017 |
bin | integer | The BIN (Building Identification Number) is a unique identifier for each building in the City | 2% | 400000010767514052143 |
bbl | integer | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City | 2% | 205141015010216000184068820001 |
census_tract | integer | The Census Tract (Census 2020) field indicates the U.S. Census Tract where the site is located. Please note that as part of the geocoding process, leading and trailing zeros are dropped | 0% | 277180271 |
nta | text | The Neighborhood Tabulation Area (Census 2020) field indicates the New York City Neighborhood area where the site is located | 0% | MN1202BK0302BX0101 |
location_1 | coordinate | System-generated column used for mapping | — | — |