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

335.64 KB
2365 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,
  "neighborhood_tabulation_area_nta_2020" VARCHAR
);