Add Data Query with Custom SRID

Discussion created by dfalkenberg on Nov 13, 2013
Latest reply on Nov 18, 2013 by MKennedy-esristaff
I am trying to set up a procedure for our County in which we will allow County users to load tables from a PostGIS database.  The tables in the database use a custom SRID which is defined by our County Coordinate System.  What I would like to be able to do is to load a table and for ArcMap to know what SRID it is reading.  In my case, the custom SRID is 97306, and is stored with that designation in the PostGIS table geometry column.  I have also added SRID 97306 to the Coordinate System Favorites in ArcMap.  (C:\Users\[login name]\AppData\Roaming\ESRI\Desktop10.2\ArcMap\Coordinate Systems\97306.prj)  Is there a way to make ArcMap recognize 97306 without me directly clicking on that choice?  Right now I always get UNKNOWN for the spatial reference system.
Thank you for any help or tips!