From a 500-row sample across 23 columns.
statusstreetstatusHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| the_geom | segmentid | bikeid | prevbikeid | status | boro | street | fromstreet | tostreet | onoffst | facilitycl | allclasses |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {"type":"MultiLineString","coordinates":[[[-73.98255629299425,40.73135013385513],[-73.98248469541169,40.731451475200764]]]} | 0190857 | 4.0 | NA | Current | 1 | 1 AV | E 1 ST | E 20 ST | ON | I | I |
| {"type":"MultiLineString","coordinates":[[[-73.91048159778626,40.874016698818906],[-73.91039313323765,40.874079146562465]]]} |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | unknown | Geometry column used for mapping | — | — |
segmentid | text | From LION 23C. A number of up to seven digits that identifies each segment of a street or a non-street feature represented in the LION file. Nonstandard Segment IDs reflect a difference in geometry from LION 23C and existing conditions. | 0% | 025671103346460354348 |
bikeid | integer | A unique number that corresponds to one or more LION segments that share all other attributes. | 0% | 4176.0760.0759.0 |
prevbikeid | text | A unique number that identifies the related record of a Bike ID that has been superseded. | 8% | NA760759 |
GET /api/datasets/mzxg-pwib GET /api/datasets/mzxg-pwib/quality GET /api/datasets/mzxg-pwib/related GET /api/columns?dataset=mzxg-pwib
| 0338221 |
| 3046.0 |
| NA |
| Current |
| 1 |
| BROADWAY BR |
| 9 AV |
| W 225 ST |
| OFF |
| L |
| L |
| {"type":"MultiLineString","coordinates":[[[-73.99612861145164,40.67816150028236],[-73.99647228408435,40.6774386592711]]]} | 0022375 | 7972.0 | NA | Current | 3 | SMITH ST | SCHERMERHORN ST | HAMILTON AV | ON | II | II |
| {"type":"MultiLineString","coordinates":[[[-73.92810290445244,40.7878325657557],[-73.9289420050228,40.78690189853436]]]} | 0245597 | 3025.0 | NA | Current | 1 | RFK BR | MN QN BOUNDARY | HELL GATE CR | OFF | L | L |
| {"type":"MultiLineString","coordinates":[[[-73.96453128895577,40.796970022547924],[-73.9642871384521,40.79730694114483]]]} | 9007769 | 211.0 | NA | Current | 1 | COLUMBUS AV | CATHEDRAL PKWY | W 96 ST | ON | I | I |
| {"type":"MultiLineString","coordinates":[[[-73.90836045155963,40.847363138153135],[-73.90807188846553,40.84758704115371]]]} | 0148864 | 7007.0 | 759 | Current | 2 | GRAND CONCOURSE | E 176 ST | E 170 ST | ON | II | II |
| {"type":"MultiLineString","coordinates":[[[-73.88191280185242,40.835308868253975],[-73.88184580129821,40.83528535705398]]]} | 0315220 | 730.0 | NA | Current | 2 | E 174 ST BR | HOE AV | METCALF AV | ON | II | II |
| {"type":"MultiLineString","coordinates":[[[-73.80357251630933,40.7052332312815],[-73.80265548634424,40.70548042965016]]]} | 0057273 | 1724.0 | NA | Current | 4 | 89 AV | PARSONS BLVD | SUTPHIN BLVD | ON | II | II |
| {"type":"MultiLineString","coordinates":[[[-73.91020255272515,40.87421367725321],[-73.90967117913117,40.874588767956205]]]} | 0270797 | 3046.0 | NA | Current | 1 | BROADWAY BR | 9 AV | W 225 ST | OFF | L | L |
| {"type":"MultiLineString","coordinates":[[[-73.91388850205131,40.76932392934112],[-73.91610188292806,40.76660591411719]]]} | 0068144 | 1636.0 | NA | Current | 4 | 36 ST | ASTORIA BLVD S | 34 AV | ON | II | II |
Showing 12 of 17 columns. All of them are listed below.
status | categorical | Indicates whether a record represents a current (i.e. existing) bicycle facility or a retired (i.e. historic) one. | 0% | CurrentRetiredof 2 |
boro | categorical | A 1-digit code identifying the borough in which the left side of the street segment is located. | 0% | 134of 5 |
street | text | Name of the street or facility. | 0% | GRAND CONCOURSE1 AVQUEENS BLVD |
fromstreet | text | The street, when available, or where no street is present a park, waterfront line, land mark, or nearest street adjacent to the beginning of the facility route. | 0% | E 161 ST3 AV5 AV |
tostreet | text | The street, when available, or where no street is present a park, waterfront line, land mark, or nearest street adjacent to the end of the facility route. | 0% | VAN CORTLANDT AVE EBROADWAY3 AV |
onoffst | categorical | Indicates whether a bicycle facility is on-street or off-street. | 0% | ONOFFof 2 |
facilitycl | categorical | The HIGHEST facility class found along a segment. | 0% | IIIIIIof 4 |
allclasses | categorical | Lists ALL bicycle facility classes (separated by commas) that are present on a given segment. | 0% | IIIIIIof 15 |
bikedir | categorical | Travel direction based on LION geometry. | 0% | 2RLof 3 |
lanecount | categorical | The number of bike lanes on a segment in any direction. | 0% | 120of 5 |
ft_facilit | categorical | From-To Facility. Type of bicycle facility in the direction of the STARTpoint TO ENDpoint of the segment. | 25% | ProtectedConventionalSharedof 13 |
tf_facilit | categorical | To-From Facility. Type of bicycle facility in the direction of the ENDpoint TO STARTpoint of the segment. | 26% | ProtectedConventionalSharedof 13 |
ft2facilit | categorical | From-To Facility 2. (On segments with lane counts of 3 or greater, or multiple parallel bicycle facilities) Type of bicycle facility in the direction of the STARTpoint TO ENDpoint of the segment. | 100% | ConventionalSharedProtectedof 4 |
tf2facilit | categorical | To-From Facility 2. (On segments with lane counts of 3 or greater, or multiple parallel bicycle facilities) Type of bicycle facility in the direction of the ENDpoint TO STARTpoint of the segment. | 100% | ProtectedSharedConventionalof 5 |
instdate | datetime | Install Date. The approximate or exact date when the installation or modification of a bicycle facility was completed. | 0% | 2009-05-01T00:00:00.0001980-07-01T00:00:00.0001979-05-01T00:00:00.000 |
ret_date | datetime | Retired Date. The date when a BIKE ID or a bike facility was removed or superseded by a new facility or Bike ID. | 82% | 2023-06-20T00:00:00.0002017-10-06T00:00:00.0002023-12-21T00:00:00.000 |
grnwy | text | Greenway. Indicates the presence of a greenway alignment. | 79% | Greenwayof 1 |
gwsystem | categorical | Greenway System Name | 82% | Manhattan WaterfrontJamaica BayBrooklyn Waterfrontof 16 |
gwsys2 | categorical | Secondary Greenway System Name, if an alignment includes two greenway systems. | 100% | Mosholu-PelhamManhattan WaterfrontBronx Riverof 6 |
spur | text | Greenway Spur Name, if the bikeway includes a secondary alignment. | 82% | Main AlignmentRandall's IslandFar Rockaway |
gwyjuris | categorical | Greenway Jurisdiction | 79% | DOTDPRNYSDOTof 14 |