All Questions
Tagged with domains enterprise-geodatabase
24 questions
2
votes
1
answer
344
views
For each domain of a subtype field, select the domain data and subtype data (using SQL)
Oracle 18c 10.7.1 EGDB
For a given table/subtype:
For each domain of a subtype field, select the domain data and the subtype data:
Domain code
Domain description
Domain name
Subtype code
Subtype ...
- 1,272
1
vote
1
answer
535
views
Select domain codes/descriptions using XMLTABLE instead of EXTRACTVALUE
Oracle 18c 10.7.1 GDB:
The ArcGIS system table docs have an example for extracting domain codes and descriptions from XML:
Example: Resolving domain codes to description values using SQL
--simplified:...
- 1,272
0
votes
1
answer
240
views
Find problem rows in GDB_ITEMS_VW
Oracle 18c 10.7.1 EGDB:
Oracle GDBs have a view called GDB_ITEMS_VW that has a DEFINITION column with extracted XML values (clob).
I can extract data, such as coded value domains, from the XML column ...
- 1,272
2
votes
1
answer
595
views
Select subtype and a subtype field's domain names using SQL
I have a non-spatial table with a subtype in an Oracle 18c 10.7.1 EGDB.
Using SQL, I want to select the following as columns in a query:
Subtype Code
Subtype Description
A specific subtype field ...
- 1,272
0
votes
1
answer
85
views
ArcPy GPValueTable to get all domains in the GDB
I write simple code using Python similar to AddCodedValueToDomain tool.
my tool works very well, but without the drop down menu to select fields from the geodatabase, so how I can allow the end user ...
- 23
0
votes
0
answers
224
views
Create ArcGIS geodatabase domains from a CSV file using Python
I want to create ArcGIS geodatabase domains from a CSV file.The problem is that my output says field values in the row are "None". It doesn't recognize the values in my CSV file.
Any ideas ?
...
- 183
0
votes
0
answers
50
views
Select domain's last update date
I have tables in an Oracle 18c GDB that I integrate to a work order management system.
I create views on the tables to translate the data. For example, I translate domain codes to domain descriptions.
...
- 1,272
4
votes
1
answer
378
views
Limit users' editing privileges by attribute and role
I have a feature class in an Oracle 12c geodatabase.
The feature class has a type column. The column has a coded domain.
I would like to limit user's ability to edit the features based on the type ...
- 1,272
1
vote
1
answer
342
views
Writing domains with coded values in ArcSDE Enterprise Geodatabase
I'm trying to write a new domain and values in our ArcSDE database but I receive the following error:
Runtime error Traceback (most recent call last): File "", line 34, in File "c:\program ...
- 281
1
vote
0
answers
327
views
Importing domains to ArcSDE?
Is there a way to import a geodatabase into a sde on the server and keep the sde domains, while adding the new geodatabse domains?
- 101
7
votes
4
answers
2k
views
Restricting values to domain codes (beyond attribute table)?
Geodatabase fields can be assigned domains. ArcGIS Desktop uses the domains as lookup tables (a.k.a. validation tables).
When users edit data in the attribute table or attribute editing window, the ...
- 1,272
3
votes
3
answers
5k
views
List of all fields and their domains for each table using SQL (table name, field name, domain name)
I'm trying to generate a list of all fields (in all tables in an Oracle geodatabase) and the coded value domains that they use.
+------------+------------+-------------+
| table_name | field_name | ...
- 1,272
1
vote
1
answer
212
views
Create additional 'fields' in GDB domain system table (GDB_items)?
Is it possible to create additional 'fields' in the geodatabase domain system table (GDB_items) in SDE 10.3/Oracle?
It would be handy to store additional information in domains.
For example:
CODE [...
- 1,272
3
votes
1
answer
1k
views
Get domain descriptions for multiple fields using SQL
How can I get domain descriptions for multiple fields using SQL?
I have successfully used the Oracle SQL in this ESRI document: Resolving domain codes to description values using SQL. But how do I do ...
- 1,272
5
votes
1
answer
2k
views
Is it possible to change or reconfigure a domain owner on SDE?
We have had to reconfigure a few things within a geodatabase managed in SDE. This inadvertently has caused some issues updating the domains within the gdb, to the point where not even the DBO can ...
- 1,262
0
votes
1
answer
2k
views
How do I set the domain extents to default?
I have a feature class that seems to be cutting off geometry. I looked around to see if there is a bounding box applied and found the Domain, Resolution and Tolerance tab in the Feature Class ...
- 3,197
1
vote
1
answer
145
views
Associating 9.3 geodatabase domains to a SDE feature class' field in ArcCatalog 10.1 fails
I have succesfully created Domains into a 9.3 geodatabase based on Oracle (SDE) by using ArcCatalog (ArcGIS 10.1). Proof: If I open the table GDB_DOMAINS in Oracle the new domains are listed. ...
- 1,575
4
votes
2
answers
2k
views
Get Coded Value Domains from a Oracle geodatabase using PLSQL
i'm trying to get all coded value domains from a Oracle geodatabase. I dont have access to arcmap. I only have access to oracle 10g database.
SELECT
I.NAME Domain, EXTRACTVALUE(CodedValues....
- 951
4
votes
1
answer
427
views
Update value in domain and same should reflect in attribute field
I have a SDE GDB, where i have no. of domains created. we have created domain for state names, which is used by all feature classes to update their respective state name.
Now i have discovered that ...
- 177
-1
votes
1
answer
147
views
Issues while changing ArcSDE from a Workgroup to Domain Environment
Our organisation was a having a multi-user Geodatabase ( ArcSDE 10.1 gateway on an Oracle 11 g DB) in a Workgroup configuration.
The type of Authentication for DB connection was "Database ...
- 774
4
votes
1
answer
2k
views
No domain coded values on REST Arcgis 10.2
We have created a map service using version 10.2 from a map which all layers data source are point to an SDE connection service using DB2 database. However, the coded value domain not appear in the ...
- 53
7
votes
2
answers
422
views
ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server
I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field.
In order to help themselves, they asked me to implement a particular ...
- 103
4
votes
3
answers
3k
views
Is there a way to see the coded value domain list of possible values from arcmap 9.3.1?
Is there a way to see the possible values of a specific coded value domain in arcmap 9.3.1 (I have no access to the SDE which holds all the data in arcCatalog)?
- 3,185
7
votes
3
answers
380
views
Changing a coded Domain to no codes
If we have coded domains in the geodatabase model, what are any disadvantages to changing the codes to the Description. For example:
Existing Coded Domain:
Code, Description
1, Single Family ...
- 3,398