Wednesday, November 24, 2010

Questions Regarding the Residential Units



What is the Residential Unit Table?

The residential unit table contains unit values and other related information regarding residential units. There are estimated 204,000 to 210,000 residential units (with a secondary address).  Each residential unit is associated with an address from the address table (via the ADDRESS_ID field). Example unit values include '101', '201', 'A', '910', '1', '6' and 'A2.' This data includes both rental and condo units which is noted in the 'UNIT_TYPE' field. For condo units the condo's SSL values and condo book and page number is also stored.


What are some of the challenges while creating the Residential Unit Table?


The biggest challenge is just dealing with acquiring the the huge quantity of residential units which is estimated at 204,000 to 210,000. Another challenge is matching the residential unit information with condo units from Office of Tax & Revenue's ITS Public Extract table. Unfortunately, in the ITS Public Extract table there is a tremendous amount of incomplete and incorrect data. This is especially true when it comes to the premise address and unit number columns.

What are the remaining weaknesses in the Residential Unit Table?

• Special use residential facilities (University Dorms, Group Homes, Retirement, Nursing Home and Military Barracks)
• Multi unit row houses
• Large buildings with a low occupancy rate
• Buildings which were constructed very recently

No comments: