From a 24-row sample across 30 columns.
postcodelatitudecensus_tract+9longitudelocation:@computed_region_f5dn_yrer+4postcodelatitudecensus_tract+13Mappable — Socrata point column `geocoded_column`.
Open on the map →| f1 | borough | ifo_busine | applicant | year | location | to | site_visit | structure | structur_1 | structur_2 | establishm |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | BK | Erv's on Beekman | Owner | 2019 | 2122 Beekman Place | N/A | 2018-06-20T00:00:00.000 | Platform | Custom | 20' | 40' |
| 2 | BK | Pokeworks |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
f1 | text | — | 0% | 194 |
borough | categorical | — | 0% | MNBKQnsof 4 |
ifo_busine | text | — | 0% | Laughing Man Coffee & Te…Under Line CoffeeBrooklyn Fare |
applicant | text | — | 0% | OwnerDowntown Brooklyn Partne…Hudson Square BID |
year | categorical |
GET /api/datasets/d83i-6us7 GET /api/datasets/d83i-6us7/quality GET /api/datasets/d83i-6us7/related GET /api/columns?dataset=d83i-6us7
latitudecensus_tractboroughlatitudeboroughlongitude+5boroughlocation:@computed_region_f5dn_yrer+4latitudelongitude:@computed_region_f5dn_yrer+4to| Pokeworks |
| 2019 |
| 258 7th Avenue |
| 6th Street |
| 2018-10-17T00:00:00.000 |
| Platform |
| — |
| 20' |
| 19-6" |
| 3 | BK | Sal & Paul Pizzeria | Pitkin Avenue BID | 2015 | 1686 Pitkin Avenue | Rockaway Avenue | 2014-06-01T00:00:00.000 | Platform | Standard Design Protype Install | 20 Feet | 20 Feet |
| 4 | BK | SkyIce & DB Smoke Shop | Owner | 2016 | 63 5th Avenue | St Marks Avenue | 2016-01-22T00:00:00.000 | Platform | Standard | 20 feet | 19' |
| 5 | BK | Barber Shop | FAB Alliance | 2019 | 462 Grand Avenue | Lefferts Place | 2019-02-06T00:00:00.000 | Platform | Standard | 20' | X' |
| 6 | BK | BRIC | BRIC | 2016 | 647 Fulton Street | Ashland Place | 2016-07-26T00:00:00.000 | Platform | Standard non platform | 20 feet | X' |
| 7 | BK | Golden Fried Dumpling | Downtown Brooklyn Partnership | 2014 | 192 Duffield Street | MetroTech Roadway | 2014-07-06T00:00:00.000 | Platform | Custom | 40 Feet | 32'-10" |
| 8 | BK | Khim's Millenium Market | Downtown Brooklyn Partnership | 2014 | 111 Lawrence Street | MetroTech Roadway | 2014-07-06T00:00:00.000 | Platform | Custom | 40 Feet | — |
| 9 | BK | Office Building | RFR Realty LLC | 2017 | 117 Adams & 73 Sand Street | Jay Street | 2016-04-01T00:00:00.000 | Sidewalk | Sidewalk | 300' | 1000' |
| 10 | MN | Les Enfants de Boheme | Co-owners | 2015 | 177 Henry Street | East Broadway | 2015-01-29T00:00:00.000 | Platform | Custom | 40 feet | 60 feet |
Showing 12 of 30 columns. All of them are listed below.
| — |
| 0% |
201920162015of 6 |
location | text | — | 0% | 359 W 45th Street462 Grand Avenue2122 Beekman Place |
from_ | text | — | 100% | — |
to | text | — | 0% | 9th AvenueMetroTech RoadwayGreenwich Street |
site_visit | datetime | — | 0% | 2014-07-06T00:00:00.0002018-10-17T00:00:00.0002016-03-08T00:00:00.000 |
structure | categorical | — | 0% | PlatformNon PlatformSidewalkof 3 |
structur_1 | categorical | — | 4% | CustomStandardSidewalkof 6 |
structur_2 | categorical | — | 4% | 20'20 feet40 Feetof 11 |
establishm | categorical | — | 13% | X'1000'72'of 19 |
parking_re | categorical | — | 4% | Street CleaningMetered parkingNo Standing Zoneof 17 |
applicatio | text | — | 4% | Yesof 1 |
community_board | categorical | — | 4% | 104302102of 11 |
_2019_insta | datetime | — | 0% | 1899-12-31T00:00:00.0002019-04-24T00:00:00.0002019-06-01T00:00:00.000of 14 |
_2019_remov | text | — | 100% | — |
latitude | coordinate | — | 0% | 40.75203440.75609940.749857 |
longitude | coordinate | — | 0% | -73.996856-73.98999-73.996463 |
postcode | categorical | — | 4% | 111011001810001of 17 |
council_district | categorical | — | 4% | 3135of 10 |
census_tract | integer | — | 4% | 1111979802 |
bin | integer | — | 4% | 101037910777932000803 |
bbl | integer | — | 4% | 300148000110103600013009890043 |
nta | categorical | — | 4% | Hudson Yards-Chelsea-Fla…West VillageHunters Point-Sunnyside-…of 15 |
geocoded_column | coordinate | — | 0% | {'coordinates': [-73.989…{'coordinates': [-73.942…{'coordinates': [-73.979… |