Skip to main content
  • EN

Due to certain circumstances, primarily due to a limitation within ESRI, I find myself in the situation where I must retrieve data from my database not directly via the sde reader, but rather indirectly through the postGIS reader. Despite encountering various challenges along the way, I managed to surmount these obstacles.

However, the primary issue I currently face involves the resolution of domains in my output. Naturally, the postGIS reader does not offer an immediate solution for this matter. My consideration was to take an alternate route, yet I am encountering difficulties here as well.

My proposed approach involves extracting information from the domain tables and subsequently configuring it using AttributeManager.

Regrettably, I am unable to locate the domain tables within postGIS. I hold the belief that these tables must exist within the postGIS setup, albeit their exact location eludes me.

Any form of assistance in this matter would be greatly appreciated. Thank you for your support!

This article on Esri's website might provide some more inforomation on what you're looking for: https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-postgresql/geodatabase-system-tables-postgresql.htm

It looks like the Domain information is stored in the gdb_items table. I recommend reaching out to Esri support to get a more concrete answer since this question falls more within their area of expertise.

 

Hope this helps!

Dan

Thanks a lot @danminneyatsaf​!

I found it, and where the the codes & names are stored!

in the sde.gdb_items table there is a column name 'definition', and inside there are xmls which contains all of the data.

 The xmls looks like this:

<GPCodedValueDomain2 xsi:type='typens:GPCodedValueDomain2' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.8'><DomainName>dbo_lut_diameter</DomainName><FieldType>esriFieldTypeInteger</FieldType><MergePolicy>esriMPTDefaultValue</MergePolicy><SplitPolicy>esriSPTDuplicate</SplitPolicy><Description>name</Description><Owner>gis_user</Owner><CodedValues xsi:type='typens:ArrayOfCodedValue'><CodedValue xsi:type='typens:CodedValue'><Name>לא ידוע</Name><Code xsi:type='xs:int'>0</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>1</Name><Code xsi:type='xs:int'>1</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>2</Name><Code xsi:type='xs:int'>2</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>3</Name><Code xsi:type='xs:int'>3</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>4</Name><Code xsi:type='xs:int'>4</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>6</Name><Code xsi:type='xs:int'>6</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>8</Name><Code xsi:type='xs:int'>8</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>10</Name><Code xsi:type='xs:int'>10</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>12</Name><Code xsi:type='xs:int'>12</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>14</Name><Code xsi:type='xs:int'>14</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>16</Name><Code xsi:type='xs:int'>16</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>18</Name><Code xsi:type='xs:int'>18</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>20</Name><Code xsi:type='xs:int'>20</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>24</Name><Code xsi:type='xs:int'>24</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>28</Name><Code xsi:type='xs:int'>28</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>70</Name><Code xsi:type='xs:int'>70</Code></CodedValue><CodedValue xsi:type='typens:CodedValue'><Name>80</Name><Code xsi:type='xs:int'>80</Code></CodedValue></CodedValues></GPCodedValueDomain2>

And I really don't know how to extract the data from them..

If some can help me, I will really apricate it.

Reply


Community Stats

30,167
Posts
114,520
Replies
37,824
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.