LPC Permit Application Information
City of New York
@usgov.city_of_new_york_lpc_permit_application_information
City of New York
@usgov.city_of_new_york_lpc_permit_application_information
CREATE TABLE table_1 (
"docket" VARCHAR,
"address" VARCHAR,
"received_date" TIMESTAMP,
"borough" VARCHAR,
"block" BIGINT,
"lot" BIGINT,
"lmnametype" VARCHAR,
"applicant_name" VARCHAR,
"applicant_co" VARCHAR,
"applicant_address1" VARCHAR,
"applicant_address2" VARCHAR,
"applicant_zip" VARCHAR,
"applicant_city" VARCHAR,
"applicant_state" VARCHAR,
"owner_name" VARCHAR,
"owner_address1" VARCHAR,
"owner_address2" VARCHAR,
"owner_zip" VARCHAR,
"owner_city" VARCHAR,
"owner_state" VARCHAR,
"communityboard" VARCHAR,
"worktypes" VARCHAR,
"regulation_type" VARCHAR,
"issue_date" TIMESTAMP,
"xcoordinate" DOUBLE,
"ycoordinate" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"regulation_number" VARCHAR,
"owner_co" VARCHAR,
"expiration_date" TIMESTAMP,
"community_board" VARCHAR,
"council_district" VARCHAR,
"census_tract" VARCHAR,
"bin" VARCHAR,
"nta" VARCHAR,
"zip_code" VARCHAR
);
Anyone who has the link will be able to view this.