These tutorials assume that you have access to ArcGIS either in our computer lab or installed on your computer so there won't be any instructions on how to install. They are written for someone with basic knowledge of ArcGIS's interface, that wants a walkthrough how this tool can be used to help them ask and answer their spatial research questions.
For tutorials starting at a beginner level I recommend those on ESRI's website or if you have a New York Public Library card, they have several great tutorials for newcomers to ArcGIS on their Lynda.com portal.
The data I'll be using in these tutorials comes from felony drug arrest statistics by county that I got from the New York State Division of Criminal Justice Services, spatial data from the New York State GIS Portal and data from the Law Enforcement Support office at the Defense Logistics Agency concerning the 1033 program. In brief, the 1033 program lets local law enforcement agencies request decommissioned military equipment ranging from office furniture, to night-vision, to weapons to Mine-Resistant Ambush Proof Vehicles (MRAPs).
While the data I'm using is real from a project that I did, it isn't going to be updated so please go back to the original sources mentioned if you'd like to explore it further. I picked these data sets because they were handy and they are large and complex enough to show how to work with different kinds of data but not too complicated to get in the way of explaining the process. The maps made in these examples are not necessarily scholarly rigorous but hopefully the process of making them will get you familiar enough with ArcGIS Pro so that when you map your own data, you'll have more time for scholarly rigor!
When displaying point data, in addition to having a point's position show its geographic location, you can have its color display qualitative or quantitative information and you may want to let the size of the marker convey further quantitative information. If you're mapping area schools, the color of your point could mean whether the school is public or private and the student to teacher ratio could be displayed by the size of the dot over the school's location. You can do this with graduated symbols that change based on numerical quantities associated with a point, much as how the changing colors of the counties in the previous exercise showed differences in arrest-rates between counties.
Another scenario that will be explored in this exercise is the situation where you don't necessarily have a one-to-one ratio between the point you have on your shape-file and the additional information you want to add from an attribute table. For instance you may have a shapefile with different points representing addresses and then on your attribute table a different line for that address for every person who lived there that you found from census records. In that case you'd want to summarize your attribute table to get the total count of people at that address.
You'll learn how to both use graduated symbols and the summarize function on your data tables in this exercise using data I have downloaded regarding individual law enforcement agencies and shipments made to them via the 1033 program.
Below I'll include the NYBasemap zip file that I created in a previous exercise and 1033_NY_PoliceStationsAndCoordinates.csv. The table in the csv contains information on what equipment was received by law enforcement agencies through the 1033 program. Each of the law-enforcement agencies is associated with a latitude and longitude of one of the police stations in that agency since the program's records don't have a specific shipping address. You'll use this data to map the different quantities received by each police station
With the sheet as it is now, all you'll be able to do is place a point over each police station. You can make the point proportionally larger each time for the value of the item received or the quantity of items received in a shipment, but if there are many shipments to one station, these shipments will be overlapping datapoints, and you'll need to use the Explore pop-up window in order to get more information on what was received. However once you create a layer with these points on it, you'll have more options on how to edit it.
There are multiple records for each of the law enforcement agencies, one for each shipment of equipment but since all that's currently being visualized in the Symbology tab is the location, only one symbol will be displayed, one for each station.
The additional data is available on the layer, you'll just need to change what the symbols are linked to in order to do it. First though, before you forget, add the metadata to your layer so that your viewer can check the description and see where your data for your symbols comes from.
You may be working on projects with many layers, and you'll want to know where the information on those layers came from. Adding a description and credits to your layer first thing is a very good habit to get into so that when you cite the sources on your map, you will just be able to get that information in the description of the layer, instead of digging back through your computer to find the source you got your information from. If you upload your map online, it is best practice to have the source of your information cited as well so viewers will know where you got it from
To total up amount of items received in total, or the total in acquisition value of all items, you'll need to alter the sheet using Summarize.
To be clear, you can also create these totals in a csv or excel file before you upload that file into ArcGIS Pro, but it's good to know how to use the Summarize function. You can take any field on an attribute table and summarize, count or average the values associated with the records containing that field. This can be helpful to you if you have multiple records associated with a single place, and some of the fields on your attribute table are numerical.
Perhaps you are mapping 311 complaints from apartments using a table where each complaint is its own row . You have fields with information including the number of residents in the apartment making a complaint and the possible fine to the landlord for that violation. Instead of just having the one dot over a building so that your viewer would have to use the Identify tool in order to see the list of violations associated with that building, you could use the Summarize function on the attribute table to
These new quantities can then be symbolized so that the symbols on your map can give additional information to whoever is looking at your map other than that buildings with the symbol have had at least one 311 complaint made against them.
In this scenario, you're looking to get the total in quantity of items, in acquisition value and the count of shipments associated with each law enforcement agency, and I'll show you how to use Summarize to do this.
With the new data coordinate data attached to your table you can now make a point for each police station that displays the data about the totals associated with it.
Now with these summaries for the total acquisition value and total quantity received added to locational data for the law enforcement agency receiving it, you can visualize the amount received by each police station, not as individual transactions but as a total.
When you finish editing the Symbology your map will look something like this
When you have a lot of data fields on the attribute table for a layer, you have a lot of options for what you can visualize and how you symbolize it. For any given layer though, you can only pick one symbol system. That's why it's handy that ArcGIS will let you copy a layer, and paste back into your Contents pane with all its associated data intact.
You can also use the summarize function on your original table to create a new table with information such as the average acquisition value of each purchase. With a large amount of varied data there are a lot of things you can do with it.
I've attached my finished map document below if you want to see how I constructed it. This will also be useful for you in the next exercise. Note that it's in project file NY1033_DataAll
In order to see how many datapoints fall within a town or county or other geographic unit, you can join two layers of your map not based on the data on their tables, but based by whether or not they intersect with a region on the map. This is called a Join by Location.
Scenarios that this is useful for include ones where you have datapoints associated with a specific place or event that you want to provide additional context for based on the data available about their surrounding towns, cities, counties, states or other regions. Maybe you're investigating a past outbreak of a disease and want to take the datapoints you have representing documented cases and associate it with zip codes so you can instead of looking at every given point and trying to draw a conclusion, visualize which zip codes had the most cases. Maybe you're doing a study on urban farming and want to visualize which census blocks have the most farms. Maybe in both of those cases you have underlying data about those zip codes or blocks that you'll want to use as context to understand why there are more sick people or urban farms in those places, like median income or population density. These are cases where spatially joining your data points in one layer to geographic features in the other can come in handy.
In this case, you have individual data points on the map related to receipts by certain law enforcement agencies of former military equipment via the 1033 program. You have data about felony drug-arrest rates but only on a county-level basis. In order to ask the question if law enforcement agencies in counties with high felony drug-arrest rates request larger values of equipment, you'd need to determine which counties these agencies were located within. Since you have the boundaries of these counties already drawn on your map, with the Join By Location function you can add a new layer that compiles all the data for points falling within each county.
For this exercise you'll be using the map we created in the last exercise, but if you didn't do that one, the map is below.
For the map you want to wind up with that visualizes the total acquisition value for all items acquired by the law enforcement agencies within the county 103Data_Original is the layer that you'll want to be joining to the Counties layer in your basemap. Since there isn't a separate field in this table that contains data about which county this law enforcement agency falls into, you'll need to do this based on these datapoint's spatial location.
When the CountyTotals layer is added but it will originally just appear as a flat symbol. You'll have to go in and change the symbology of the layer to have it display the total of value of the equipment acquired in each county.
When you finish, your map will look something like this
A reason to choose graduated symbols despite the fact that you are visualizing regional data instead of point data is so that you can then put other county-level data beneath that data, like population, economic or demographics data, or in the case of the attribute table that is associated with the County shapefile in this document, per capita drug arrests.
You'll get a map that looks something like the below, which allows you to display two kinds of data at the same time, but because it uses different methods of visualization it's still pretty clear to read. You can tell by looking at a county how many shipments from the 1033 program law enforcement agencies in its borders had, and the level of drug arrests per capita that it had.
However, look closely at the scale for the graduated symbols, You're not quite done yet. Notice how the low end of the first scale is set to 0. How many of those tiny dots represent a county with 1 shipment, and how many with 0 shipments? Currently, you don't know, however, there is a way to correct this so only counties that received any shipments from the 1033 program will receive a symbol on this map and that is by using a Definition Query on your layer.
A Definition Query lets you define which parts of your data will be shown on the map. This can be useful to you when you're working from a large data set where only a subset of the data in it is of interest to your project. In this case, you only want to display dots on counties where they received at least some equipment from the 1033 program. You could have tackled this by creating an invisible symbol to be used for items with a value of 0 in Join Count however, there will be other cases where it won't be that easily resolvable , so it's good to know the structure of using a Definition Query.
Remember, always be on the lookout for inconsistencies in your map. Are you leaving somewhere in that doesn't apply to your research question? Are you leaving something out that does?
If you ran into any issues and need to see how I configured my file the zip file with my project is located below. Note that it's in project file: NY1033_CountyTotals
When you've uploaded a sheet with multiple fields, it can get a little daunting to figure out what you want to be visualizing about your places of interest. If you have a table you downloaded from the census with population, economic and demographic information for an area across a five year span, you might only be interested certain years, or certain measures or certain counties. You can make decisions on the fly in ArcGIS about which maps are pertinent to your research question, without editing this data in a separate program before uploading it .
In this exercise you'll learn how to select only certain categories of information, to export those selections as their own layer, and by using data frames be able to switch between different maps created by selections from a single table.
As mentioned in the previous exercise, the drug arrest rates by county that I have visualized on my county map are from 2020, but the data I have about what law enforcement agencies acquired from the 1033 program comes from many different years. What if you just wanted to visualize the total value of items acquired by the different counties in 2020 and 2021? Instead of creating new sheets in Excel with just the data for those years, in ArcGIS you'll use the Select by Attributes function to look at just shipments made in those years and export a new layer with only that subset of your data. Then, by putting each in their own data frame, you'll create the groundwork to create a layout with a side-by-side comparison in the next exercise.
Start from this modified selection of data created previously below
Since the data we have in our counties on the basemap has the drug felony arrest rates for 2020, the useful data to see if there is any relation between a drug arrest-rate for a county in New York State and more costly equipment being sent to that county would be to look at the shipments sent in 2020 and 2021. We'll want to pull the data for just these years and use them to create separate layers for the map.
In this instance you are looking for numerical information but this doesn't need to always be the case. If you instead only wanted to select items with a certain text value in the field you could do that instead, like if you only wanted items that had VEHICLE in the Item_Name field, you could have made that selection. It also doesn't need to be a complete match if it is numerical information, you could select only items over a certain acquisition value. You can string multiple requests into the same query, combining several of these together to look only for vehicles valued over a certain amount shipped within a certain year range.
Select By Attributes is a very useful tool for you to customize your map to only show information that is pertinent to your research question. Definition Query serves a similar function, however when you Select by Attribute, the information not within the selection is still visible on the map, it just isn't highlighted. But back to this query -
Since these are the items you want on your new layer, these are the selections you'll export.
Now that you only have the data for 2020 and 2021 on the map, you'll be able to make a map that only contains those pertinent years.
Your map should look something like this if you've chosen the same options I did, but you can certainly vary the scales or colors you use.
A Definition Query is used on a layer to define the data it will be displaying amongst the data available to it. Similar to Select By Attribute, you can select based on what values are in a field, either from a list of acceptable values, or if the values are numbers, those above or below a certain threshold. You can turn it off or on at any time but while one is on, your map will only display a selection of your data. In order to display more than just the ship year about these shipments, you'll have to create two different layers one for each year, since ArcGIS Pro won't display both by category (the year) and by numeric amounts (either the acquisition values or items shipped).
If you ran into any issues and need to see how I configured my file the zip file with my project is located below.
While on some occasions you'll be presenting only one map that you have created with your data, on others, for example for poster sessions, you may be adding in multiple maps that represent your data. Rather than taking screenshots of individual maps, using Layout View and multiple data frames allows you to present your maps in a unified fashion while still being able to customize and fine-tune the geographic aspects of your maps.
In a tutorial in the first module, Visualizing Data on a Map, you learned how to create a map when you had only one data frame. After completing this one you'll learn how to create a layout with multiple dataframes, thus allowing you to create a layout containing multiple maps. You'll add individual map elements for each data frame and make sure that the scale is as consistent as possible across both so that you are creating a unified picture of what information each presents.
We'll be using the attached map document to start with which is a modified version of the maps created in the last exercise
Up until now, we've only worked with one map, but in order for there to be two different data frames, we'll have to create a second one. No problem, we can copy layers between maps.
Since you are going to want to add a two different map frames and a title and legends to this layout you'll want to add a Guide or two to make it easier to align things. A Guide is a s a straight blue line that will run across your layout horizontally or vertically at whatever distance in from the edge that you want. It won't show up when you print your map, it's just there for your own guidance.
When you've finished that, it will look something like this
You also will need to add text letting your viewer know where you got your information from. This lets people know if you are using credible sources, and lets other scholars to engage with your work and do work that builds off of yours. Maybe they are working in a similar area and when they see that you have statistics on felony drug arrest rates or acquisitions of decommissioned military equipment by police departments they'll want to know where they can can find similar information for their own geographic area or time period that they're interested in. You can convey this information by adding source text
The way for people to understand what the different symbols mean is to insert a legend which will explain what the symbols in each layer represent. However the legend's information is going to come from the scale, the titling and the headings you have for your layers in your Contents pane. To have clear explanatory text on your legend, click on the titles and headings on each of the visible layers in your Contents pane for your map, and change the language to make it very clear what the symbols in it are representing. In my case I've done that ahead of time, but keep that in mind for your own data when making your own layout. In my case I'll change the heading of Acquisition Value of Shipment for each of the different options to Acquisition Value of 1033 Shipment(s), 2020 and Acquisition Value of 1033 Shipment(s), 2021 so that the titles on the legends match
You'll now create a separate legend for Acquisition Value of 1033 Shipment(s), 2020 to go under that map frame on the left, for 2020- Felony Drug Arrests Per 100,000 residents to go between the two since the same scale is on both maps, and the last legend for Acquisition Value of 1033 Shipment(s), 2021 to go below that map on the right
Now you've added the legends for your two maps.
The Legend boxes that you create do not contain layer information in their own right. They are dynamic. If you change the symbols or turn a layer off or on using the Table of Contents view, the legend's labels, titles, and symbols will change accordingly. This comes in handy because sometimes until you see all the legends together on your map you won't realize that something about them needs to change.
From a cursory look at the map with the scales the way they are, it looks like there was a lot more valuable equipment shipped in Long island in 2021 than 2020, but then look at what the largest dots mean on our two scales? What about the smallest?
In 2020, largest class of shipments went from 135,000 to 705, 421. In 2021 it only went from 87,409 to 126,462. The same sized symbol on each map for the maximum number represents very different amounts in terms of the value of equipment. Though these symbols both are the same size, because they are for scales drawn up for the variation between total amounts within their own maps, they are not to scale between each other and that can lead to a misleading picture.
Let's change the symbology here so that they show a more accurate representation. Take a look at the distribution of the acquisition values across the attribute table for each year, and see what makes sense to you. I've created the below scale system doing that to try to create a scale that as much as possible has meaning across both of the years.
|Size of symbol
|Upper Value (note: 2021 chart doesn't contain the top class)
So edit the symbology for each year's Acquisition Value symbol by going into the Symbology tab for each class, choosing that you want to divide it into 9 classes for 2020, 8 for 2021. Then in each choose that the Method will be Manual, and adjust the upper range, starting from the highest amount and working your way down.
Change the symbol sizes by double-clicking on the symbol in the Classes, and then editing it in the Format Point Symbol menu under Size.
This newer version of the map makes it a bit more evident what the different monetary amounts between the shipments in the two years were.
You can experiment with different class boundaries and symbol sizes to create your own picture.
These basic navigation aids are less crucial on thematic maps like these that won't be used for navigation. A reader, however, might still want to know the distance between different counties and whether the map is in the typical configuration with North being straight up so it is helpful to add these.
You've now created a suitable layout for your project, it should look something like the below.
Options for exporting your layout live in the Share tab. Here you will have options to print it, to export it in a variety of formats, or just simply use Capture to Clipboard if all you want to do is copy it so you can paste it into an email or research paper.
The way I constructed it is in the zip file attached below, but please explore different manners of configuring your symbols and legends and titles and navigation aids to construct the map a different way if you prefer a different look.