AnsweredAssumed Answered

Accessing a PostGIS table with a custom SRID

Question asked by clruwebdev on Apr 27, 2018
Latest reply on Jul 13, 2018 by MKennedy-esristaff

Like • Show 0 Likes0
Comment • 2

Hi,

I created a custom spatial reference at spatialreference.org ( http://spatialreference.org/ref/sr-org/8391/ ) and defined it in PostGIS using the INSERT statement generated by this site. I created my tables with geometry type using this custom SRID ( st_setsrid(geom,98391) ). These tables works fine when accessed through QGIS, but when I try to load at ArcMap with a Database Connection, I receive the message "Could not add the specified object to the map. The coordinate system identifier is invalid". Ok, I invented this identifier. But, how can I tell this to ArcGIS?

I tried this connection using different ArcGIS versions (10.2, 10.4) and database instances. The message is the same. So, it´s an old issue.

P.S.: I don´t have a geodatabase configured, and don´t want it.

No one else has this question

Outcomes

RRobichaux-esristaff

May 1, 2018 9:44 AM

Hi Claudio,

You might be experiencing an issue similar as to what was described here: Add Data Query with Custom SRID. You might want to reach out to Melita who would likely be able to either answer your question or point you in the right direction to someone who can. I hope this is helpful!

1 person found this helpful

Actions

MKennedy-esristaff

Jul 13, 2018 11:32 AM

We have no idea how to interpret 98391. The WKID gets used more on the DBMS side. For instance, if you had shapefiles, we would likely just ignore the WKID and use the well-known text.

There's a way to add a custom definition to ArcGIS with a WKID, but we use a certain range of numbers for that and 98391 wouldn't work. The range we use is 202000 - 202999. If you're interested in trying that, please send me an email at mkennedy at esri dot com.

Actions

2 Replies

RRobichaux-esristaff May 1, 2018 9:44 AM
Mark Correct
Correct Answer
Hi Claudio,

You might be experiencing an issue similar as to what was described here: Add Data Query with Custom SRID. You might want to reach out to Melita who would likely be able to either answer your question or point you in the right direction to someone who can. I hope this is helpful!
1 person found this helpful
Like • Show 0 Likes0
Actions
MKennedy-esristaff Jul 13, 2018 11:32 AM
Mark Correct
Correct Answer
We have no idea how to interpret 98391. The WKID gets used more on the DBMS side. For instance, if you had shapefiles, we would likely just ignore the WKID and use the well-known text.

There's a way to add a custom definition to ArcGIS with a WKID, but we use a certain range of numbers for that and 98391 wouldn't work. The range we use is 202000 - 202999. If you're interested in trying that, please send me an email at mkennedy at esri dot com.
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Accessing a PostGIS table with a custom SRID

Outcomes

Related Content

Recommended Content