From a 0-row sample across 0 columns.
oftcodefmsagencyioverallsco+23the_geomthe_geomThe machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | — | — | — |
projectid | numeric | A unique number assigned to identify a capital project. | — | — |
projtitle | text | The full title of the capital project. | — | — |
fmsid | text | The unique budget code assigned to the capital project in the citywide Financial Management System (FMS). | — | — |
fmsagencyi | numeric | The three number citywide Financial Management System (FMS) agency code. | — | — |
leadagency | text | The primary agency leading the capital project in three letter acronym. |
GET /api/datasets/jvk9-k4re GET /api/datasets/jvk9-k4re/quality GET /api/datasets/jvk9-k4re/related GET /api/columns?dataset=jvk9-k4re
| — |
| — |
managingag | numeric | The agency that manages the project in three letter acronym. | — | — |
projectdes | text | The description of the capital project. | — | — |
projecttyp | text | The three letter code that identifies the type of work being performed. | — | — |
projectt_1 | text | The full description on the type of work that is being performed for the capital project. | — | — |
projectsta | text | The current status of the capital project. | — | — |
constructi | numeric | The fiscal year of the capital project. | — | — |
designstar | datetime | The date the design phase of the capital project starts. | — | — |
construc_2 | datetime | The date the project will be completed. | — | — |
currentfun | numeric | Estimated current funding allocated for this capital project. | — | — |
projectcos | numeric | Estimated cost of the capital project. | — | — |
overallsco | text | Overall brief description of the capital projects. | — | — |
otherscope | text | Brief description for any other capital projects. | — | — |
projectjus | text | The reason for the initiation of the project. | — | — |
onstreetna | text | The street where the capital project is taking place. | — | — |
fromstreet | text | The nearest cross street from where the capital project is taking place. | — | — |
tostreetna | text | The nearest cross street to where the capital project is taking place. | — | — |
boroughnam | text | The New York City borough where the project would take place. | — | — |
oftcode | text | A 18 digit code consisting of three 6-digit street codes representing On-From-To streets as returned by GeoSupport functions. | — | — |
location_1 | numeric | The length of the street segment or geometry of the project in feet. | — | — |
designfy | numeric | The fiscal year in which the design was initiated. | — | — |
safetyscop | text | Brief description for a safety related capital projects. | — | — |