Question
In ArcGIS we were asked: Determine the number of stores per 100,000 people in each state, using the POP2014 field. Which state has the most
In ArcGIS we were asked:
Determine the number of stores per 100,000 people in each state, using the POP2014 field. Which state has the most stores per capita? Which has the least? (Hint: In a joined table, only the target table fields may be calculated.)
This step has been completed. After joining the tables and compiling the data successfully, we were then asked to:
Capture a map showing the number of stores in each state; include a legend in the map. Also capture a map showing the number of stores per capita in each state. Compare the two maps and discuss what they could mean.
I have not been able to figure out how to take the data from the new table and create a working layer. The tool creates a layer with unusable numbers as shown in the image. Please advise on what I'm doing incorrectly.
Thanks
Print Layout Geoprocessing Contents Make Feature Layer + Search Parameters Environments Input Features State Population Output Layer Stores ? Drawing Order Stores Per State Map Stores Stores Per State Map X Layout2 Expression FREQUENCY -1.797693e+308 - 1.797693e+308 Load Save Remove D State Population 1:41,088,038 124.4323942W 44.1947019N SQL Topographic Stores PerState X Where Select a... + Add Clause X Standalone Tables Field: Selection: Rows: store openings.csv OBJECTID * STATE_ABBR FREQUENCY COUNT_storenum STATE ABBR Openings Table 1 4 CA 159 159 CA Workspace or Feature Dataset StoresPerState 2 32 NY 83 83 NY 3 29 NJ 41 41 NJ Field Info 4 45 WA 40 40 WA Run 5 44 VT 4 4 VT Make Feature Layer completed. View Details Open History 0 of 48 selected Filters: Filters: $
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started