From a 500-row sample across 29 columns.
borough:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+2boroughboroughboroughlatitude:@computed_region_sbqj_enih+4Mappable — Socrata point column `the_geom`.
Open on the map →| the_geom | borocode | boroname | borocd | coundist | assemdist | stsendist | congdist | program | site_id | group_id | borough |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 40.63165, -73.95271 | 3 | Brooklyn | 314 | 45 | 42 | 21 | 9 | Bike Racks | S.0000226 | RL.1900.00226 | BK |
| 40.75017, -74.00621 | 1 | Manhattan |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | Geometry column used for mapping | 0% | {'coordinates': [-73.908…{'coordinates': [-73.881…{'coordinates': [-73.989… |
borocode | categorical | Borough and Community District code of the bicycle rack. | 0% | 314of 5 |
boroname | categorical | The full name of the borough the bicycle rack is located in. | 0% | BrooklynManhattanQueensof 5 |
borocd | text | — | 0% |
GET /api/datasets/592z-n7dk GET /api/datasets/592z-n7dk/quality GET /api/datasets/592z-n7dk/related GET /api/columns?dataset=592z-n7dk
latitudelongitudethe_geomfromstreet| 104 |
| 3 |
| 75 |
| 47 |
| 12 |
| Bike Racks |
| S.0001593 |
| RL.1900.01593 |
| MN |
| 40.72986, -73.98715 | 1 | Manhattan | 103 | 2 | 66 | 27 | 10 | Bike Racks | S.0002063 | RL.1900.02063 | MN |
| 40.68096, -73.98045 | 3 | Brooklyn | 306 | 39 | 52 | 20 | 10 | Bike Racks | S.0002194 | RL.1900.02194 | BK |
| 40.70545, -73.92097 | 3 | Brooklyn | 304 | 34 | 53 | 18 | 7 | Bike Racks | S.0004845 | RL.1900.04845 | BK |
| 40.73632, -73.98904 | 1 | Manhattan | 105 | 2 | 74 | 59 | 12 | Bike Racks | S.0006498 | RL.1900.06498 | MN |
| 40.61765, -74.03077 | 3 | Brooklyn | 310 | 47 | 46 | 26 | 11 | Bike Racks | S.0007316 | RL.1900.07316 | BK |
| 40.73949, -73.92054 | 4 | Queens | 402 | 26 | 37 | 12 | 7 | Bike Racks | S.0009113 | RL.1900.09113 | QN |
| 40.73231, -73.95972 | 3 | Brooklyn | 301 | 33 | 50 | 59 | 7 | Bike Racks | S.0010232 | RL.1900.10232 | BK |
| 40.73617, -74.00889 | 1 | Manhattan | 102 | 3 | 66 | 47 | 10 | Bike Racks | S.0011350 | RL.1900.11350 | MN |
Showing 12 of 29 columns. All of them are listed below.
301105302 |
coundist | text | The New York Council District of the bicycle rack. | 0% | 3233 |
assemdist | text | The Assembly District of the bicycle rack. | 0% | 667552 |
stsendist | text | The State Senate District of the bicycle rack. | 0% | 282726 |
congdist | categorical | The New York Congressional District of the bicycle rack. | 0% | 10127of 13 |
program | categorical | Name of program | 0% | Bike RacksBike Corralof 2 |
site_id | text | Unique identifier for the bicycle rack. | 0% | S.0000096S.0012456S.0001276 |
group_id | text | — | 0% | RI.2025.00182BC1033BC0951 |
borough | categorical | The full name of the borough the bicycle rack is located in. | 0% | BKMNQNof 5 |
ifoaddress | text | Building number (part of street address) | 1% | NA41 Cooper SquareNO ADDRESS |
onstreet | text | The name of the street the rack(s) are on | 23% | BROADWAYBroadwayROOSEVELT AV |
fromstreet | text | The intersecting street name at one end of the street | 30% | BROADWAY6 Avenue2 Avenue |
tostreet | text | The intersecting street name at the other end of the street | 30% | 3 Avenue5 Avenue6 Avenue |
side_of_st | categorical | Identifies the side of the street where the rack(s) are installed. | 36% | SWNof 8 |
racktype | text | The type of asset/bike rack | 0% | Large HoopSmall HoopU Rack |
date_inst | datetime | Date of installation | 1% | 1900-01-01T00:00:00.0002002-06-10T00:00:00.0002000-04-05T00:00:00.000 |
latitude | float | The latitude geographic coordinate for the bicycle rack, | 0% | 40.80565940.68512140.747329 |
longitude | float | The longitude geographic coordinate for the bicycle rack, | 0% | -73.908752-73.944523-73.966082 |
ntaname | text | Name of the New York City neighborhood for the location of the bicycle rack. | 0% | WilliamsburgEast VillageChelsea-Hudson Yards |
femafldz | categorical | FEMA flood zone code for the bicycle rack. | 0% | XAEVEof 4 |
femafldt | categorical | FEMA flood zone description for the bicycle rack. | 3% | AREA OF MINIMAL FLOOD HA…0.2 PCT ANNUAL CHANCE FL…of 2 |
hrcevac | categorical | Hurricane Evacuation Zone Code | 0% | X65of 7 |