Community Commons has a lot of data. Over a thousand layers from a variety of sources and in a multitude of geographies that can all be seen on a map. That’s a great thing when you want a visual way to look at the needs and assets of your community, but sometimes you really need that data in a table format as well. There are three ways to do that on Community Commons.
- Create a report: This is the easiest way, but not all data that can be mapped is available in report form.
- Click on a geography in your map: This is great when you are only looking at one specific area but it’s not downloadable.
- Use the Select Data tool: This allows you to choose one or multiple areas in which to see the data by attribute and download it in a table.
We’ll now walk you through the steps for each method.
Create a report
Community Health Needs Assessment reports are easy to create and contain hundreds of data layers that can be viewed and downloaded in a variety of formats.
From the Maps & Data tab, choose Build A Report. Once there, select your state and county, or multiple counties, and click View Report.
Once there, click on any Data Category to see what layers are available. Then click on any Data Indicator and scroll down to see the data in a variety of formats. You will see Download Data links with any table of data in the report.
Click in a map
Let’s say you created a map for your community showing percentage of Food Insecure Children Ineligible for Assistance by county as well as the location of All Public Schools by location in the Hampton and Norfolk, Virginia area. We can see that some counties have a higher percentage range of food insecure children but we don’t know the actual percentages per county. We can also see that there are a number of schools in these areas, but we don’t know the percentage of children receiving free and reduced-price lunches at these schools.
When you click on any of the location data or within the county geography, a window opens giving you more details about that data you are looking at. This data is not downloadable into a table format and you can’t see more than one location at a time. You would need to use our Select Data tool for that.
The Select Data tool
When you want to see a table representation showing the data for several counties together or if you want a data table for all public schools within a specific area, you use the Select Data tool.
Once you open the Tools menu, choose Select Data and a number of options will open. This map has more than one data layer, so you will have to choose the one you want see a data table for. Simply click on the data layer listed and a drop-down list will open.
Now you need to chose how you’re going to gather the data you want. If you choose Select by Rectangle, that will allow you see the data for several counties as long as the rectangle touches every county you want.
Now you have data table that can be downloaded into an Excel format.
To see the school data, go back to the Select Data tool and choose the All Public Schools by Location data layer and, this time, choose the Select by Polygon tool. This allows you to draw a more focused area of data around the schools in the Hampton City area. Once you finish your polygon, the data table automatically populates for you.
We encourage you to spend some time experimenting with the Select Data tool as well as any of our other tools on Community Commons. You can always find help on our Support page or you can contact us if you need further assistance.