I have an excel spreadsheet showing different wind speeds for a location based off of zip codes. I want to try to create polygons to represent each windspeed for each location. How can this be done in ArcMap? The table only includes Zip Codes and Windspeed
You shouldn't have to create a polygon layer.
There are zipcode boundary files already created by the CENSUS bureau. If you do not already have a layer, what did you join the 'windspeed' attribute table to?
What you need to do is symbolize each zip code by wind speed.
Layer Properties--> Symbology --> Categories --> choose the 'WindSpeed' field
Will have to try this. I've never tried joining an .xls file in ArcMap. I've always converted it to a .dbf file and then brought it into ArcMap to perform the join
What I would do it this:
1.) Copy and paste zip code/ windspeed data into new Excel sheet
2.) Add zip code polygon layer to ArcMap
3.) Add newly created windspeed .xls table into arcmap
4.) Join .xls table to polygon layer by Zipcode field
5.) Export layer as .shp to solidify joined features
Let me know if that works. Arc is sometimes finicky when working with tables. So start with a fresh .xls table.
I Tried this but all I get is null values for the zipcode feature. The Zip Codes and wind speeds were given to me in a .pdf format. I then copied the values to an Excel spreadsheet. Then I opened Access and imported the spreadsheet, then exported it to a .dbf file to bring into ArcMap. I then did a Join with my Zip Code feature class but all the values for zip code become 'null'. Is there anyway to solve this?
If that's the only data your table contains, you'll need to get a polygon layer of zipcode boundaries--> Join that to your wind table --> symbolize by category (or label features by wind speed)
2014 TIGER/Line® Shapefiles --> Select 'Zip Code' from the drop down box
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
