From a 500-row sample across 5 columns.
boroughcodephysicalidglobalidHas borough codes (`boroughcode`) — joinable, but needs boundary shapes to draw.
| physicalid | boroughcode | fiscalyearpruned | contract | globalid |
|---|---|---|---|---|
| 42619.0 | 3 | 2000.0 | N/A | 637EF3A1-5FC7-4974-AE6E-27979258AF0E |
| 42619.0 | 3 | 2009.0 | N/A | EDCF718D-2ED8-4509-9BF6-E46BEC057C2A |
| 46804.0 | 3 | 2008.0 | N/A | F6EDD958-90C2-49F1-964E-698975B2D9F5 |
| 26398.0 | 4 | 2009.0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
physicalid | integer | This attribute is derived from CSCL and is a unique identifier within a borough, assigned to intersection to intersection stretches of a street. | 0% | 52697.060868.084632.0 |
boroughcode | categorical | Borough | 1% | 432of 5 |
fiscalyearpruned | integer | Fiscal Year Pruned; Year the block was pruned | 0% | 2009.02015.02008.0 |
contract | categorical | Contract name for block pruning | 0% | N/A509BP-S19 |
GET /api/datasets/tqsy-2s6w GET /api/datasets/tqsy-2s6w/quality GET /api/datasets/tqsy-2s6w/related GET /api/columns?dataset=tqsy-2s6w
| N/A |
| 6E21D547-ED27-435A-9BF2-2804613AF229 |
| 82121.0 | 4 | 2014.0 | N/A | CA54736F-18D4-4ADF-9B38-CE93E7B146EB |
| 82121.0 | 4 | 2014.0 | N/A | 62122C24-A079-4DA2-9EA8-2109CE09351F |
| 56201.0 | 2 | 2011.0 | N/A | D7F6387C-C889-4B82-8D62-54E364AF9E9E |
| 94542.0 | 3 | 2011.0 | N/A | 948E32D8-8D9A-4A8D-8ACB-E448E1F42363 |
| 51260.0 | 3 | 2012.0 | N/A | D3D33C3C-ED0F-4096-861A-0C3950C39AF5 |
| 51260.0 | 3 | 2012.0 | N/A | 55D457AA-15A4-4D6B-B032-0963F5D1B587 |
fyschedule | categorical | Fiscal Year Schedule; estimated fiscal year of next pruning | 100% | 2019.02013.02018.0of 8 |
globalid | text | Unique ID for each pruning record. | 0% | 462AB907-237B-441C-849C-…FD0BCE59-24A1-4339-B8CB-…0B186767-3A87-4DA1-A7AC-… |