DOF: Condominium Comparable Rental Income – Staten Island – FY 2011/2012
City of New York
@usgov.city_of_new_york_dof_condominium_comparable_rental_inc_b1a5a764
City of New York
@usgov.city_of_new_york_dof_condominium_comparable_rental_inc_b1a5a764
CREATE TABLE table_1 (
"staten_island_condominiums_comparable_properties_boro_block_lot" VARCHAR,
"staten_island_condominiums_comparable_properties_condo_section" VARCHAR,
"staten_island_condominiums_comparable_properties_address" VARCHAR,
"borough" BIGINT,
"postcode" BIGINT,
"latitude" DOUBLE,
"longitude" DOUBLE,
"community_board" BIGINT,
"council_district" BIGINT,
"census_tract" BIGINT,
"bin" BIGINT,
"bbl" BIGINT,
"nta" VARCHAR,
"staten_island_condominiums_comparable_properties_neighborhood" VARCHAR,
"staten_island_condominiums_comparable_properties_build_1cbd5111" VARCHAR,
"staten_island_condominiums_comparable_properties_total_units" BIGINT,
"staten_island_condominiums_comparable_properties_year_built" DOUBLE,
"staten_island_condominiums_comparable_properties_gross_sqft" BIGINT,
"staten_island_condominiums_comparable_properties_estim_8e0c782e" BIGINT,
"staten_island_condominiums_comparable_properties_gross_31048306" DOUBLE,
"staten_island_condominiums_comparable_properties_estim_43d6a1ef" BIGINT,
"staten_island_condominiums_comparable_properties_expen_83834519" DOUBLE,
"staten_island_condominiums_comparable_properties_net_o_f51789e1" BIGINT,
"staten_island_condominiums_comparable_properties_full__bf9409e8" BIGINT,
"staten_island_condominiums_comparable_properties_marke_eae04a00" DOUBLE,
"comparable_rental_1_boro_block_lot" VARCHAR,
"comparable_rental_1_address" VARCHAR,
"comparable_rental_1_neighborhood" VARCHAR,
"comparable_rental_1_building_classification" VARCHAR,
"comparable_rental_1_total_units" BIGINT,
"comparable_rental_1_year_built" BIGINT,
"comparable_rental_1_gross_sqft" BIGINT,
"comparable_rental_1_estimated_gross_income" BIGINT,
"comparable_rental_1_gross_income_per_sqft" DOUBLE,
"comparable_rental_1_estimated_expense" BIGINT,
"comparable_rental_1_expense_per_sqft" DOUBLE,
"comparable_rental_1_net_operating_income" BIGINT,
"comparable_rental_1_full_market_value" BIGINT,
"comparable_rental_1_market_value_per_sqft" DOUBLE,
"comparable_rental_1_distance_from_condo_in_miles" DOUBLE,
"comparable_rental_2_boro_block_lot" VARCHAR,
"comparable_rental_2_address" VARCHAR,
"comparable_rental_2_neighborhood" VARCHAR,
"comparable_rental_2_building_classification" VARCHAR,
"comparable_rental_2_total_units" DOUBLE,
"comparable_rental_2_year_built" DOUBLE,
"comparable_rental_2_gross_sqft" DOUBLE,
"comparable_rental_2_estimated_gross_income" DOUBLE,
"comparable_rental_2_gross_income_per_sqft" DOUBLE,
"comparable_rental_2_estimated_expense" DOUBLE,
"comparable_rental_2_expense_per_sqft" DOUBLE,
"comparable_rental_2_net_operating_income" DOUBLE,
"comparable_rental_2_full_market_value" DOUBLE,
"comparable_rental_2_market_value_per_sqft" DOUBLE,
"comparable_rental_2_distance_from_condo_in_miles" DOUBLE,
"comparable_rental_3_boro_block_lot" VARCHAR,
"comparable_rental_3_address" VARCHAR,
"comparable_rental_3_neighborhood" VARCHAR,
"comparable_rental_3_building_classification" VARCHAR,
"comparable_rental_3_total_units" VARCHAR,
"comparable_rental_3_year_built" VARCHAR,
"comparable_rental_3_gross_sqft" VARCHAR,
"comparable_rental_3_estimated_gross_income" VARCHAR,
"comparable_rental_3_gross_income_per_sqft" VARCHAR,
"comparable_rental_3_estimated_expense" VARCHAR,
"comparable_rental_3_expense_per_sqft" VARCHAR,
"comparable_rental_3_net_operating_income" VARCHAR,
"comparable_rental_3_full_market_value" VARCHAR,
"comparable_rental_3_market_value_per_sqft" VARCHAR,
"comparable_rental_3_distance_from_condo_in_miles" VARCHAR
);
Anyone who has the link will be able to view this.