Data Search Tool Tutorial

In addition to looking at the details of each property individually, you can create custom groups of properties that show grouped counts of properties, buildings, and units.  This feature can help you analyze data. 

*This tutorial assumes that you’re familiar with using the Data Search Tool’s SHIP filters.

You can create up to three layers of grouped data by selecting characteristics.

The new simplified table now displays the information grouped by borough. 

The columns are simplified as well.  They now show only the aggregated number of properties, buildings, and units inside each borough.  You can still sort each column.

You can continue to filter the data and view the results as groups. 

Perhaps you want to see what properties were placed in service with the Low-Income Housing Tax Credit in the 1990s.

• Select “LIHTC Status” to expand the menu.
• Enter desired years into the “Placed in Service” year range in order to see only properties that were placed in service during that time.

You can create groups that aggregate the data which year properties were placed in service with the Low-Income Housing Tax Credit.

• Create groups by pressing “(change)” to bring up the list of aggregate choices.
• Like with filters, question marks here explain what a characteristic means.
• Press “Submit” to view the aggregate.

You should now see a table that shows all properties that were placed into service with Low-Income Housing Tax Credit between 1990 and 2000.  Year-by-year, you can see property, building, and unit counts.

You can group the information by up to three characteristics.

• Select “(change)” to open the aggregates menu again.
• Select “Borough”.
• Press “Submit” to update the table.

Your table will now be divided both by boroughs and placed-in-service years. 

Click on the column header to sort the data by any characteristic.  For example, if you sort by “Total Units” you can see that Manhattan lead in placing new LIHTC units in service in the 1990s.

Important Note: Grouping by Administering Agencies or Portfolios SHIP grouping criteria can cause double-counting.  This is because a single property can have fall within multiple portfolios administered by multiple agencies.