topic Re: custom coordinate system SRID with PostGis in ArcGIS Pro Questions

custom coordinate system SRID with PostGis

jherbst5 — Tue, 25 Apr 2023 08:25:19 GMT

Hello all,

This is my first post here. I am just getting started with a PostgreSql/PostGis database in ArcGis Pro. I have successfully connected the database to ArcGis and I am able to move GIS data back and forth using various methods. However in the excavation where I work, we use a custom coordinate system and the GIS data from PostGis appears in Layer Properties>Source>Spatial Reference: Unknown Coordinate System. I have added our coordinate system to the spatial_ref_sys table in the database and its recognized by QGIS fine but not ArcGis.

I have searched around how to get ArcGis to recognize the SRID and found a couple of old posts from 2013 and 2018:

https://community.esri.com/t5/geodatabase-questions/accessing-a-postgis-table-with-a-custom-srid/td-p/782976

https://community.esri.com/t5/arcgis-enterprise-questions/add-data-query-with-custom-srid/td-p/442991

The posts mention a "back door" method of adding a custom system that ArcGis will recognize. Does anyone happen to know this method or any other way?

Thank you,

James

Re: custom coordinate system SRID with PostGis

jherbst5 — Wed, 26 Apr 2023 06:00:21 GMT

I see in some other threads for similar topics that @MelitaKennedy is the expert on such problems. I hope its ok to tag her here.

Re: custom coordinate system SRID with PostGis

MelitaKennedy — Thu, 27 Apr 2023 14:24:17 GMT

Hi James,

If you look at the files here: Github Esri projection-engine-db-doc objedit folder and I can send you a document that explains it. Please drop me an email at mkennedy at esri dot com.

Melita

Re: custom coordinate system SRID with PostGis

jherbst5 — Fri, 28 Apr 2023 13:53:07 GMT

Thank you Melita, I have sent you an email. Thanks for your help.

James

Re: custom coordinate system SRID with PostGis

FabioNeiraAlzate — Fri, 19 Apr 2024 21:32:13 GMT

Hello Melita, Please, Can you share this document with me?

Re: custom coordinate system SRID with PostGis

AlexanderGray — Fri, 21 Mar 2025 18:23:29 GMT

I too am having this problem. Is there a solution to this?