I am using ArcGIS for Desktop 10.2.
I trying to import and display project data for various regions. Each project is tied to a location and I want to display Project Type, Funding Source, and a dollar amount.
I have three data tables in excel. For the 2 "Acquisitions" tables (the upper left and lower left in the screen shot) I used REGION and NAME to join the 2 tables to a polygon feature class (Town-City-Village). I had to delete villages with the same names as towns so the individual data entries wouldn't duplicate.
Adding the 2 Acquisition tables: Since they are in separate tables I just made a copy of my polygon feature class and joined each table to it separately - I feel like that is sloppy and I might try consolidating the two Acquisition tables into one.
The "Infrastructure" table (TOP-RIGHT in Screenshot) poses a problem because in that data table there are multiple entries (projects) with a unique funding source, and dollar amount BUT IN THE SAME REGION.
- Region: Type: Amount: Funding Source:
- Manhattan Infrastructure $1,000,000 CDBG
- Manhattan Infrastructure $250,000 HMGP
So I'm not sure how to: A. join the infrastructure data and B. Symbolize the information in a succinct way if I even did get it in.
With just the Acquisiton data in the map right now it is already too busy. I don't know what I'll do when I have to symbolize Infrastructure too. ( SEE OTHER SCREEN SHOT )