About this Dataset

Bikes In Buildings Requests

The Bicycle Access to Office Buildings Law aims to increase bicycle commuting by providing cyclists with the opportunity to securely park their bicycles in or close to their workplaces. The law allows tenants to request for access from landlords in commercial buildings, and for DOT to monitor the requests for access and their status.
Organization: City of New York
Last updated: 2020-11-10T17:05:10.635444
Tags: alternate, bib, bicycle, bike, building, exception, parking, plan, request

Tables

Table 1

@usgov.city_of_new_york_bikes_in_buildings_requests.table_1

343.69 kB
2,365 rows
54 columns

CREATE TABLE table_1 (
  "requestid" BIGINT,
  "indexnumber" VARCHAR,
  "tenantname" VARCHAR,
  "tenantfloor" VARCHAR,
  "tenantbuildingnumber" VARCHAR,
  "tenantstreetname" VARCHAR,
  "tenantcity" VARCHAR,
  "tenantstatecode" VARCHAR,
  "tenantpostcode" BIGINT,
  "tenantborough" VARCHAR,
  "ownername" VARCHAR,
  "ownerfloor" VARCHAR,
  "ownerstreetaddress" VARCHAR,
  "ownercity" VARCHAR,
  "ownerstatecode" VARCHAR,
  "ownerzipcode" BIGINT,
  "floorsuiterequested" VARCHAR,
  "noofbicyclerequested" BIGINT,
  "bbl" BIGINT,
  "bin" BIGINT,
  "dateofrequest" TIMESTAMP,
  "requestdateofentry" TIMESTAMP,
  "implementdate" TIMESTAMP,
  "planpostdate" TIMESTAMP,
  "plansubmitdate" TIMESTAMP,
  "exceptionrequestduedate" TIMESTAMP,
  "tenantnotificationexceptiondate" TIMESTAMP,
  "locationofentrances" VARCHAR,
  "routetoelevators" VARCHAR,
  "regularhoursofoperation" VARCHAR,
  "planddatereceived" TIMESTAMP,
  "alternateparkinglocation" VARCHAR,
  "alternateparkingdescription" VARCHAR,
  "noofbicycleaccomodate" VARCHAR,
  "routetoalternateparking" VARCHAR,
  "parkingexceptiondatereceived" DOUBLE,
  "parkingexceptiondateofentry" TIMESTAMP,
  "dobdevicenumber" VARCHAR,
  "dateofbuilding" TIMESTAMP,
  "dateofelevator" TIMESTAMP,
  "methodofelevator" VARCHAR,
  "selfserviceoroperator" VARCHAR,
  "iscartop" VARCHAR,
  "iscardoor" VARCHAR,
  "elevatorexceptiondatereceived" TIMESTAMP,
  "elevatorexceptionhardcopyreceived" VARCHAR,
  "elevatorexceptiondateofentry" TIMESTAMP,
  "requeststatus" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" BIGINT,
  "council_district" BIGINT,
  "census_tract_2020" BIGINT  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);