The American Community Survey (ACS) is an ongoing survey that provides new data every year. This gives communities current information needed to plan investments and services. Information from the survey generates data that help determine how more than $400 billion in federal and state funds are distributed each year.
-A guide: A Compass for Understanding and Using American Community Survey Data is available here.
-A quick primer on the differences between the American Community Survey and Census 2010 data is available here.
-We also like this Librarian's Guide to Understanding the American Community Survey Multiyear Estimates.
This is a common request that requires a few steps to set up. First you need to format your data in a way that can be read by COGIS. Here is a sample spreadsheet with the proper data formatting. Note that each site is listed in its own row and each activity is given its own column.
555 North state Street
222 South State Street
777 West Broadway Blvd
Once you have uploaded this Excel sheet into COGIS, you will want to go to “Edit Local Data” and select “Copy or Delete and Existing Data Layer”, select the file from the list, and make additional copies of the layers, one for each activity you want to show. You will want to give the new copies unique names that reflect the activities. Do this by clicking the “Edit Information About Data Layer”, then changing the name in the top field.
After each new layer has its own unique name you will want to change the visualization of the layers by going to the “Set Data Layer’s Display Properties for Mapping”. Put the Site Name in the “Label Field” and the Activity in the “Mapping Field”. Below that, select the “Draw Data Using Unique Values” and give the “X” field a unique color and symbol. If you do not want the “O” to display so you can delete these entries so they do not appear.
If you want to show all the activities on one map you will need to give each layer a different symbol size and unique color. You will then order the layers so the largest symbol is the bottom layer and smallest symbol the top layer. This will create a bulls-eye appearance if a site had multiple activities. In our sample spread sheet above, North would have two stacked symbols, South only one, and West would have three stacked symbols.