Yep sure can (I'm always horrible at explaining these things).
The tool works like this:
First you select an area of interest (known as "topics" in the database). Examples are: housing, land use, public health, safety.
Once you do that it returns a list of resources in the chosen topic(s). You can then refine your search with any one of three other set of checkboxes.
Area (state, county, city, block, etc)
Setting (rural, suburban, urban, etc)
Mode (car, bus, rail, walking, etc)
The current database has separate tables for each one of those options (area, setting, mode) and the resources (most but not all) are duplicated in each of those tables. My example table in the OP is from the Areas table but the other two look the same. And the first set of checkboxes (the topics) are just a column that appears in all tables. It's like someone just imported 3 excel spreadsheets and decided to make a database out of them.
Here's how the three tables are set up:
I've moved the topic names to their own table to give them their own ID numbers, and I made a resources table to do the same, and so that each resource is only listed once (rather than once in each table). I've also created a relational table to tie each resource to their appropriate topics (many-to-many, as each resource can appear in more than one topic). I started to do the same for the areas, settings, and modes, but the problem is that, for example, Resource 5 when in Topic 1 will have a Y for "city", but Resource 5 in Topic 2 will have a N for "city". It's quite confusing I know, which is why I'm here.