Capacity of Other Community Facility (Column CL) Variable: otherfacility Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Square Feet of Real Estate Total (Column CM) – Variable: arearealestatetotal Publication: Yes Data Cleansing: P&A#10, P&A#11, P&A#7, and P&A#16. Calculate the total number of commercial real estate square feet namely by adding square feet of manufacture, “X” office, and retail. Replace Feet of Real Estates Total” with X if Feet of “Square – “Square Real Estates Total” is missing. Treat as missing if less than 10. – Square Feet of Real Estate Manufacturing (Column CN) – Variable: sqfremanufacture Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Square Feet of Real Estate Office (Column CO) – Variable: sqfreoffice Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Square Feet of Real Estate-Retail (Column CP) Variable: sqfreretail Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Housing Units Sale (Column CQ) – Variable: housingunitssale Publication: No Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Housing Units Rental (Column CR) – Variable: housingunitsrent Publication: No Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Affordable Housing Units Sale (Column CS) – Variable: affordablehousesale Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16
Capacity of Other Community Facility (Column CL) Variable: otherfacility Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Square Feet of Real Estate – Total (Column CM) Variable: arearealestatetotal Publication: Yes Data Cleansing: P&A#10, P&A#11, P&A#7, and P&A#16. Calculate the total number of commercial real estate square feet namely “X” by adding square feet of manufacture, office, and retail. Replace “Square Feet of Real Estates – Total” with X if “Square Feet of Real Estates – Total” is missing. Treat as missing if less than 10. Square Feet of Real Estate – Manufacturing (Column CN) Variable: sqfremanufacture Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Square Feet of Real Estate – Office (Column CO) Variable: sqfreoffice Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Square Feet of Real Estate-Retail (Column CP) Variable: sqfreretail Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Housing Units – Sale (Column CQ) Variable: housingunitssale Publication: No Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Housing Units – Rental (Column CR) Variable: housingunitsrent Publication: No Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16 Affordable Housing Units – Sale (Column CS) Variable: affordablehousesale Publication: Yes Data Cleansing: Apply P&A#10, P&A#11, P&A#7, and P&A#16
CDFI%20CIIS%20Data%20Documentation.docx