From a 500-row sample across 16 columns.
boroughcent_latitudecent_longitude+2boroughcent_latitudecent_longitude+2boroughcent_latitudecent_longitude+2Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| summary_id | num_of_violation | num_of_violation_1 | bin | bbl | cent_latitude | cent_longitude | block | lot | borough | community_district | council_district |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2 | 1 | 1000003 | 1000020002 | 40.70055 | -74.011588 | 2 | 2 | MN | 101 | 1 |
| 3 | 5 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summary_id | integer | Record Key | 0% | 342751633610051 |
num_siam_sprinkler | text | Quantity of siamese sprinklers | 52% | 010203 |
sprinkler_type | text | Sprinkler Type | 52% | FlowAuto wetTrip Test |
num_siam_standpipe | text | Quantity fo siamese standpipes | 85% | 010203 |
standpipe_type | categorical |
GET /api/datasets/nvgj-hbht GET /api/datasets/nvgj-hbht/quality GET /api/datasets/nvgj-hbht/related GET /api/columns?dataset=nvgj-hbht
binbblboroughcent_latitudecent_longitude+1borough| 1000004 |
| 1000030010 |
| 40.700918 |
| -74.014444 |
| 3 |
| 10 |
| MN |
| 101 |
| 1 |
| 4 | 2 | 4 | 1000005 | 1000041001 | 40.702153 | -74.012021 | 4 | 1001 | MN | 101 | 1 |
| 5 | 1 | 1 | 1000006 | 1000051001 | 40.702266 | -74.010607 | 5 | 1001 | MN | 101 | 1 |
| 6 | 1 | 1 | 1000007 | 1000050010 | 40.702776 | -74.010722 | 5 | 10 | MN | 101 | 1 |
| 7 | 4 | 3 | 1000008 | 1000070027 | 40.70329 | -74.011022 | 7 | 27 | MN | 101 | 1 |
| 8 | 1 | 0 | 1000012 | 1000070031 | 40.703171 | -74.011354 | 7 | 31 | MN | 101 | 1 |
| 9 | 1 | 0 | 1000014 | 1000070038 | 40.70344 | -74.011087 | 7 | 38 | MN | 101 | 1 |
| 10 | 39 | 6 | 1000016 | 1000080044 | 40.703144 | -74.011909 | 8 | 44 | MN | 101 | 1 |
| 11 | 4 | 4 | 1000017 | 1000080051 | — | — | 8 | 51 | MN | — | — |
Showing 12 of 16 columns. All of them are listed below.
| Standpipe type |
| 85% |
WetCombinationDryof 6 |
num_of_violation | integer | Total Quantity of Open Notices of Violation | 0% | 102 |
num_of_violation_1 | integer | Total Quantity of Open Violation Orders | 0% | 012 |
bin | integer | Building Identification Number | 0% | 422012438122861064814 |
bbl | integer | Building Block Lot | 0% | 204905000140046500011009720001 |
cent_latitude | float | Latitude of Building Centroid | 4% | 40.8405740.83861240.83611 |
cent_longitude | float | Longitude of Building Centroid | 4% | -73.85886-73.856525-73.845147 |
block | integer | — | 0% | 51414452470 |
lot | integer | — | 0% | 110015 |
borough | categorical | — | 0% | BKMNQNof 5 |
community_district | integer | — | 4% | 301105107 |
council_district | integer | — | 4% | 341 |