LinkNYC New Site Permit Applications
City of New York
@usgov.city_of_new_york_linknyc_new_site_permit_applications
City of New York
@usgov.city_of_new_york_linknyc_new_site_permit_applications
CREATE TABLE table_1 (
"site_id" VARCHAR,
"planned_kiosk_type" VARCHAR,
"installation_status" VARCHAR,
"ppt_id" DOUBLE,
"legacy_id" VARCHAR,
"borough" VARCHAR,
"council_district" DOUBLE,
"community_board" BIGINT,
"final_submission_a" TIMESTAMP,
"gf_permit_application_id" DOUBLE,
"gf_doitt_submitted_to_cb_a" TIMESTAMP,
"gf_cb_comment_period_ends_a" TIMESTAMP,
"street_address" VARCHAR,
"cross_street_1" VARCHAR,
"cross_street_2" VARCHAR,
"ixn_corner" VARCHAR,
"postcode" BIGINT,
"zoning" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"site_in_business_improvement_district_bid" VARCHAR,
"bid" VARCHAR,
"link_in_historic_district" DOUBLE,
"historic_district_name" VARCHAR,
"neighborhood_tabulation_area_nta" VARCHAR,
"building_identification_number_bin" DOUBLE,
"borough_block_lot_bbl" DOUBLE,
"census_tract" VARCHAR,
"location2" VARCHAR
);
Anyone who has the link will be able to view this.