From a 500-row sample across 10 columns.
the_geomoftcodeboroughcod:@computed_region_yeji_bk3qthe_geom:@computed_region_92fq_4b7q+2oftcodeMappable — Socrata point column `the_geom`.
Open on the map →| the_geom | oftcode | boroughcod | primarynam | primaryn_1 | :@computed_region_efsh_h5xi | :@computed_region_f5dn_yrer | :@computed_region_yeji_bk3q | :@computed_region_92fq_4b7q | :@computed_region_sbqj_enih |
|---|---|---|---|---|---|---|---|---|---|
| 40.68351, -73.97595 | 305580313430000000 | B | 5 AVENUE | ATLANTIC AVENUE | 17619 | 68 | 2 | 48 | 50 |
| 40.71157, -74.00246 | 112420125490000000 | M |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
the_geom | coordinate | Geometry column | 0% | {'coordinates': [-73.911…{'coordinates': [-74.001…{'coordinates': [-73.982… |
oftcode | text | A unique numerical 18 digit code for the On street- From street- To street of the block to match in LION StreetCode field. | 0% | 338730352730000000355830373930000000305280377135000000 |
boroughcod | categorical | The borough of the street segment in one letter format. | 0% | MBQof 5 |
primarynam | text | The name of the street where the construction embargo is taking place. |
GET /api/datasets/jr6f-nsuv GET /api/datasets/jr6f-nsuv/quality GET /api/datasets/jr6f-nsuv/related GET /api/columns?dataset=jr6f-nsuv
the_geom| AVENUE OF THE FINEST |
| MADISON STREET |
| 13096 |
| 56 |
| 4 |
| 32 |
| 2 |
| 40.71455, -73.99076 | 114010116410000000 | M | CANAL STREET | DIVISION STREET | 11723 | 70 | 4 | 32 | 4 |
| 40.72978, -73.98681 | 110110117190000000 | M | 2 AVENUE | EAST 10 STREET | 11724 | 70 | 4 | 50 | 5 |
| 40.69349, -73.97917 | 363030363985000000 | B | MYRTLE AVENUE | NAVY STREET | 16865 | 68 | 2 | 48 | 55 |
| 40.75995, -73.99623 | 111720134610000000 | M | AMTRAK RR | WEST 42 STREET | 13094 | 12 | 4 | 10 | 6 |
| 40.56109, -74.16983 | 544750516860000000 | S | RICHMOND AVENUE | ARTHUR KILL ROAD | 10699 | 30 | 1 | 9 | 75 |
| 40.72980, -73.97480 | 117310131700000000 | M | EAST 16 STREET | AVENUE C LOOP | 11729 | 71 | 4 | 51 | 7 |
| 40.66147, -73.98612 | 305780372430000000 | B | 7 AVENUE | PROSPECT AVENUE | 17617 | 9 | 2 | 27 | 45 |
| 40.66996, -73.90888 | 368630370930000000 | B | OSBORN STREET | PITKIN AVENUE | 17614 | 55 | 2 | 17 | 46 |
| 0% |
BROADWAY5 AVENUE3 AVENUE |
primaryn_1 | text | The closest intersection to the on street in one direction. | 0% | NORTHERN BOULEVARD5 AVENUEWESTCHESTER AVENUE |