From a 500-row sample across 14 columns.
agency_nameHas street addresses (`address`) — needs geocoding before it can be drawn.
| publication_date | agency_name | asset_num | prog_num | suffix2 | asset_name | address | discipline | system | component | survey_date | capisid_bc |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Architecture | Exterior | Windows | 2016-03-23T00:00:00.000 | LRCM15SSB |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
publication_date | categorical | The date on which the report was published | 0% | 201909122020102020211027of 7 |
agency_name | text | The owning Agency | 0% | DEPARTMENT OF EDUCATIONDEPT. OF SMALL BUSINESS …DEPT. OF PARKS & RECREAT… |
asset_num | integer | up to 5-digit number identifying an asset | 0% | 73272688 |
prog_num | text | Agency program asset number | 0% | HHC0009HHC0001 |
GET /api/datasets/vck7-ujai GET /api/datasets/vck7-ujai/quality GET /api/datasets/vck7-ujai/related GET /api/columns?dataset=vck7-ujai
| 20190912 |
| NEW YORK PUBLIC LIBRARY |
| 1924 |
| NPL0001 |
| 000 |
| CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG |
| 42 ST AND 5TH AVE. @ BRYANT PARK |
| Architecture |
| Exterior |
| Parapets |
| 2016-03-23T00:00:00.000 |
| LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Architecture | Exterior | Roof | 2016-03-23T00:00:00.000 | LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Architecture | Interior | Floors | 2016-03-23T00:00:00.000 | LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Architecture | Interior | Floors | 2016-03-23T00:00:00.000 | LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Architecture | Interior | Ceilings | 2016-03-23T00:00:00.000 | LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Electrical | Under 600 Volts | Wiring | 2016-03-23T00:00:00.000 | LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Electrical | Stand-by Power | Batteries | 2016-03-23T00:00:00.000 | LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Electrical | Lighting | Interior Lighting | 2016-03-23T00:00:00.000 | LRCM15SSB |
| 20190912 | NEW YORK PUBLIC LIBRARY | 1924 | NPL0001 | 000 | CENTRAL RESEARCH LIBRARY STEPHEN A. SCHWARTZMAN BLDG | 42 ST AND 5TH AVE. @ BRYANT PARK | Electrical | Lighting | Exterior Lighting | 2016-03-23T00:00:00.000 | LRCM15SSB |
Showing 12 of 14 columns. All of them are listed below.
DBS0022suffix2 | text | Agency program sub-asset number | 0% | 000010020 |
asset_name | text | Name identifying an asset | 0% | BELLEVUE HOSPITAL BLDG HWOODHULL MEDICAL CENTER …HARLEM HOSPITAL MARTIN L… |
address | text | Street address of asset | 0% | 462 FIRST AVENUE AT 27TH…41ST - 51ST STREET AND 1…W 77TH ST. AND CENTRAL P… |
discipline | categorical | Descriptive identifier of structural element | 0% | ArchitectureMechanicalElectricalof 14 |
system | text | Descriptive identifier of structural system | 2% | ExteriorInteriorHeating |
component | text | Descriptive identifier of structural system component | 2% | Exterior WallsRoofConversion Equipment |
survey_date | datetime | Last date of survey | 0% | 2018-06-25T00:00:00.0002019-10-30T00:00:00.0002021-03-11T00:00:00.000 |
capisid_bc | text | Budget line Identifier | 0% | OTHER FUNDINGCAPITALEXPENSE |
plan_yr | integer | Budget Commitment year | 0% | 202220252023 |
activity_cost | integer | Planned Funding | 81% | 127207.00186937.00145380.00 |