From a 112-row sample across 24 columns.
:@computed_region_92fq_4b7q:@computed_region_f5dn_yrer:@computed_region_efsh_h5xi+2latitude:@computed_region_92fq_4b7qborough+5:@computed_region_92fq_4b7qborough:@computed_region_f5dn_yrer+3Mappable — Socrata point column `the_geom`.
Open on the map →| vms | main_roadway | direction | cross_street | borough | borocode | borocd | coundist | assemdist | stsendist | congdist | type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ITS -9 | Belt Pkwy | W/B | Avenue X | Brooklyn | 3 | 318 | 46 | 59 | 19 | 8 | Gantry |
| V1_MDE_03 | Major Deegan Expwy | NB |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
vms | text | Identifier for the sign | 0% | V5_GCP_07V6_MLK_01V5_LIE_12 |
main_roadway | text | Road name where the sign is located | 0% | Long Island ExpwyBrooklyn Queens ExpwyGrand Central Pkwy |
direction | categorical | Which side of the road the sign is visble from | 0% | WBSBNBof 10 |
cross_street | text | Nearest cross street | 0% | Battery Park UnderpassSB at Buhre Ave |
GET /api/datasets/yhdx-itry GET /api/datasets/yhdx-itry/quality GET /api/datasets/yhdx-itry/related GET /api/columns?dataset=yhdx-itry
the_geomborocodeborocdboroughboroughdirection| NB at W. 193rd St |
| Bronx |
| 2 |
| 207 |
| 14 |
| 86 |
| 31 |
| 13 |
| — |
| V6_MLK_01 | Martin Luther King Expwy | SB | SB at Watchogue Rd. | Staten Island | 5 | 501 | 49 | 61 | 23 | 11 | — |
| EVAC-1 | Hylan Blvd | EB/NB | Lincoln Ave | Staten Island | 5 | 502 | 50 | 64 | 24 | 11 | Portable/Fixed |
| V6_SIE_03 | Staten Island Expwy | EB | EB at Woolley Ave | Staten Island | 5 | 502 | 50 | 63 | 24 | 11 | — |
| EVAC-6 | Flatbush Ave | N/B | Hendrickson Pl | Brooklyn | 3 | 318 | 46 | 59 | 22 | 8 | Portable/Fixed |
| ID#1142 | FDR Drive | S/B | Battery Park Underpass | Manhattan | 1 | 101 | 1 | 61 | 27 | 10 | Fixed |
| V1_BRE_01 | Bruckner Expwy | EB | EB at E. 144th Street | Bronx | 2 | 201 | 8 | 84 | 29 | 14 | — |
| V5_VWE_03 | Van Wyck Expwy | NB | NB at Jewel Avenue | Queens | 4 | 408 | 24 | 27 | 16 | 6 | — |
| V5_GCP_11 | Grand Central Pkwy | NB | NB at Northern Blvd./Connector | Queens | 4 | 481 | 21 | 27 | 11 | 6 | — |
Showing 12 of 24 columns. All of them are listed below.
NB at Rossville Aveborough | categorical | Which of the 5 boroughs the sign is in | 0% | QueensBronxStaten Islandof 5 |
borocode | categorical | The borough number where the sign is installed in. | 0% | 425of 5 |
borocd | integer | The Borough Community District for the sign location. | 0% | 502402481 |
coundist | integer | The Council District for the sign location. | 0% | 132621 |
assemdist | integer | The Assembly District for the sign location. | 0% | 278263 |
stsendist | integer | The State Senate District for the sign location. | 0% | 122434 |
congdist | categorical | The Congressional District for the sign location. | 0% | 14611of 11 |
type | categorical | Type of sign | 88% | Portable/FixedFixedGantryof 3 |
owner | categorical | Does the City or State own the sign? | 0% | NYSDOTNYCDOTof 2 |
femafldz | categorical | FEMA flood zone code for the sign location. | 0% | XAEof 2 |
femafldt | categorical | FEMA flood zone desciption for the sign location | 22% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…of 2 |
hrcevac | categorical | Hurricane Evacuation Zone Code | 0% | X12of 7 |
latitude | float | Geographic coordinate in decimal degrees | 0% | 40.5969240.7608840.600963 |
longitude | float | Geographic coordinate in decimal degrees | 0% | -73.8373-74.015447-74.22038 |
the_geom | coordinate | — | 0% | {'coordinates': [-73.817…{'coordinates': [-73.966…{'coordinates': [-73.837… |