From a 500-row sample across 20 columns.
binHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| bin | boro | feature_carried | feature_crossed | bridge_type | spans | rating_source | inspection_date | general_recommendation | current_rating | verbal_rating | deck_area_sq_ft |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1065210 | Q | WHITESTONE EXP NB | BCIP | A | 1 | STATE | 2018-06-07T00:00:00.000 | 5 | 5.127 | GOOD | 2480 |
| 1066510 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
bin | text | — | 0% | 106651010671501240090 |
boro | categorical | — | 0% | QMKof 10 |
feature_carried | text | — | 0% | GRAND CONCOURSEBSHPMOSHOLU PARKWAY |
feature_crossed | text | — | 0% | LIRR BAY RIDGEMETRO NORTH RR HARAMTRAK 30 ST BRANCH |
rail_road | categorical |
GET /api/datasets/4yue-vjfc GET /api/datasets/4yue-vjfc/quality GET /api/datasets/4yue-vjfc/related GET /api/columns?dataset=4yue-vjfc
bin| B |
| BRUCKNER EXPWY SVC RD |
| WESTCHESTER CREEK |
| WMA |
| 17 |
| STATE |
| 2018-09-21T00:00:00.000 |
| 3 |
| 3.104 |
| FAIR |
| 35000 |
| 1067150 | B | NEREID AVE (E 240TH ST) | BRONX RIVER PKWY | O | 10 | STATE | 2017-10-12T00:00:00.000 | 5 | 4.379 | FAIR | 58125 |
| 1240090 | BM | MACOMBS DAM BRIDGE | HARLEM RIVER | WMO | 52 | STATE | 2017-12-11T00:00:00.000 | 5 | 4.197 | FAIR | 220000 |
| 1247010 | Q | 91 PLACE (2247010) | LIRR PT WASH BR | O | 1 | STATE | 2017-10-12T00:00:00.000 | 6 | 6.167 | VGOOD | 2760 |
| 1247200 | Q | 67 AVE PED BR (2247200) | LIRR MAIN LINE | PED-O | 3 | CITY | 2018-06-12T00:00:00.000 | 4 | 4.138 | FAIR | 1300 |
| 1247280 | Q | 51 AVE PED BR (2247280) | LIRR MAIN LINE | PED-O | 5 | CITY | 2018-06-15T00:00:00.000 | 3 | 2.883 | POOR | 700 |
| 1247560 | Q | METROPOLITAN AVE | LIRR - NY&ATL | O | 2 | STATE | 2018-09-11T00:00:00.000 | 4 | 4.69 | FAIR | 20640 |
| 2055801 | Q | NORTHERN BLVD WB | FLUSHING RIVER | WO | 40 | STATE | 2018-09-29T00:00:00.000 | 4 | 4.182 | FAIR | 71900 |
| 2055802 | Q | NORTHERN BLVD EB | FLUSHING RIVER | WO | 40 | STATE | 2018-09-29T00:00:00.000 | 4 | 4.188 | FAIR | 78894 |
Showing 12 of 18 columns. All of them are listed below.
| — |
| 60% |
TAMof 16 |
bridge_type | categorical | — | 0% | OAPED-Oof 17 |
other_owner | categorical | — | 82% | PFEDof 4 |
spans | integer | — | 0% | 123 |
rating_source | categorical | — | 0% | STATECITYPARKSof 6 |
inspection_date | datetime | — | 0% | 2018-01-24T00:00:00.0002018-04-09T00:00:00.0002023-04-11T00:00:00.000 |
general_recommendation | categorical | — | 0% | 564of 7 |
current_rating | float | — | 0% | 657 |
verbal_rating | categorical | — | 0% | FAIRGOODVGOODof 5 |
deck_area_sq_ft | integer | — | 0% | 250060004100 |
replacement_cost | integer | — | 0% | 112500002700000018450000 |
x_coord_lat | float | — | 51% | 40.7581599440.7977740.67091376 |
y_coord_lon | float | — | 51% | -73.91468107-73.81584704-73.98256593 |
cd | integer | — | 0% | 164402413 |
cd2 | integer | — | 90% | 207401404 |
cd3 | categorical | — | 99% | 208401101of 6 |