Pie Chart Problem

Question

Hello, I am mapping our fish survey trawls on ArcGISpro, and I was wondering if it's possible to place a pie chart on each location that we trawled showing the % species caught. Is it possible to do that since the species is not numeric? Is there any other work around  that doesn't involve me having to write the expression to convert to numeric data for 20 different fish species? Any help would be great.

KimberlyGarbade · Answer

Sorry.  No easy way.  Just a not so bad way.

If your data is in a database table leave it their before you convert the data to points.  Then create a database view using SQL similar to that shown below.

Original Data (SQL Table, could have been imported from .csv):

Use the "Create Database View" geoprocessing tool using this code

easier to read version below

Then you can use this view (TestView in my case) to create a new query layer in your map by dragging it onto your map's table of contents.  The new query layer looks like this:

You can now use the add data tool's X,Y point conversion tool to bring the data into the map in such a way that it can use Pie Chart Symbology

As for the weights being in text, you can make the conversion when you make your database view using the SQL CAST() function... something like this should work:

Hope this helps.

tomsanfilppo · Answer

Its just like your example and its  a feature class with multiple points stacked on top.

KimberlyGarbade · Answer

Sorry to ask another question, but I'm trying to picture the data: each tow will have many records in the table; one for each fish type?  For example:

If this is true is this a table linked to a point feature class or is it a feature class with multiple points at the same location.. I.E. stacked on top of each other, one point for each fish type at each tow location?