Questions tagged [geodatabase-xml]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
96 views

Index for SDE XML data in Enterprise Geodatabase 10.6.1 in Oracle 19c

We are in ArcGIS Desktop 10.6.1. We are running Oracle 19c Enterprise Geodatabase. The geoprocessing tools for managing domains are extremely slow. Taking as much as 15 mins sometimes. Is that due ...
captonssj's user avatar
1 vote
1 answer
283 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 ...
User1974's user avatar
  • 1,122
1 vote
1 answer
453 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:...
User1974's user avatar
  • 1,122
0 votes
1 answer
61 views

Where is the SDE.SDEXMLTOTEXT() function located?

Oracle 18c 10.7.1 EGDB: In SDE.GDB_ITEMS_VW, there is a function being used called SDE.SDEXMLTOTEXT(): sde.sdexmltotext(d1.xml_doc) AS definition, sde.sdexmltotext(d2.xml_doc) AS documentation, sde....
User1974's user avatar
  • 1,122
0 votes
1 answer
203 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 ...
User1974's user avatar
  • 1,122
2 votes
1 answer
477 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 ...
User1974's user avatar
  • 1,122
2 votes
1 answer
81 views

Esri Workspace XML to FME dropping first record

I am working with some Esri Workspace XML documents supplied by a third party. These have (for years) successfully loaded via python into Personal GDB for minor attribution before being imported into ...
Midavalo's user avatar
  • 29.7k
0 votes
0 answers
49 views

Exporting two layers' data as geospatially dependent tables (preferably to XML) using QGIS

I am pretty new to in-depth GIS Work, so I may be using the wrong terminology. If I have a map in QGIS where I have two layers, can I export their tables, with the bottom layer info being sorted ...
dlamp's user avatar
  • 1
0 votes
1 answer
119 views

Fields Read-only after Import from XML Workspace Document

I have a process that I follow where I import from XML into a Personal Geodatabase (PGDB), do some checks and updates, and then load into an enterprise GDB. Now after I've imported from XML I ...
Midavalo's user avatar
  • 29.7k
1 vote
1 answer
171 views

Import XML workspace into enterprise geodatabase with different spatial reference system

An XML document with the schema definition of a geodatabase (ESRI Format) is available to be restored in another server (UPDM definition 2018). The definition was created with the spatial reference ...
XtianGIS's user avatar
  • 782
0 votes
1 answer
856 views

Finding the distance between two coordinates (longitudes/latitudes) which are not found as nodes in OSM

I intend to make my own OSM Router, and I do not want to use third party OSM routers. WHAT I HAVE DONE: I have downloaded OSM data in XML format and applied different algorithms to find the shortest ...
Hamza Khalid's user avatar
-2 votes
4 answers
273 views

Loading geodatabase into new empty geodatabase using ArcPy?

I am trying to copy entire gdb into new empty gdb. How should I proceed? I tried this example: # path to the cross-reference database cross_ref_db = "C:/Program Files/ESRIDefenseMapping/Desktop10....
user138779's user avatar
1 vote
0 answers
153 views

Where is XSD file for XML found in Gdb_Items table?

I would like to be able to deserialize the xml in Gdb_items table using .NET. The xml in an sde geodatabase appears to be the same as the xml returned using the File GDB API. I tried using xsd.exe ...
Kirk Kuykendall's user avatar
1 vote
1 answer
499 views

Exporting only some feature classes to XML using ArcPy? [closed]

Is it possible to only export only some feature classes when exporting a workspace to an XML document? I know that when I am in ArcCatalog, I can right click my database --> Export XML Workspace ...
sushi's user avatar
  • 317
2 votes
1 answer
391 views

Edit XML from geodatabase using Python element tree

I am trying to disallow Null values for specific fields within a gdb. Changing field properties using arcpy.AlterField_managment only changes the properties in the Python object and not in the gdb ...
cmitt's user avatar
  • 31
4 votes
1 answer
548 views

Setting DATE as default column type for esriFieldTypeDate in ArcGIS Desktop?

If I use esriFieldTypeDate with ArcGIS 10.2 a DATE column is created in Oracle. If I use it in ArcGIS 10.6 a TIMESTAMP(6) is used Is there a way to set DATE as default column type for ...
NieCola's user avatar
  • 43
2 votes
1 answer
619 views

Merging multilane road into one lane

I have a road network file (openstreetmap exported file) that has various types of edges (freeway, highway, primary, residential, service, ...). Some of these edges have multiple lanes (parallel), so ...
bijan's user avatar
  • 21
0 votes
1 answer
1k views

Export GDB Schema to XML Workspace Document

Using ArcGIS 10.2 Basic, the functions to export and import XML workspace documents (gdb schema) are greyed out. I have seen the previous discussions here, but the suggestions didn't help. It shouldn'...
DanielSE's user avatar
1 vote
0 answers
117 views

ArcCatalog import geodatabase xml schema: domain name conflict

I've exported a geodb xml schema "A" with ArcCatalog from a file geodatabase in order to import it into a sde geodb in Oracle. I've created a geodatabase with the "create enterprise geodatabase tool" ...
user1071138's user avatar
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 | ...
User1974's user avatar
  • 1,122
4 votes
1 answer
592 views

Reading an ESRI XML Workspace Document with python or other FOSS

I've recently run into data in "ESRI XML Workspace Format," I have never run into this format before, and can't find any reference to using it with FOSS tools, or any documentation on the format the ...
Jesse Crocker's user avatar
1 vote
0 answers
221 views

open ecw file in mapwindow

I'm very new to mapping. I have a bunch of ecw files and also xml files with their mapping information. I'm trying to load them in mapwindow but am having no success. Can this be done?
asher's user avatar
  • 11
3 votes
1 answer
3k views

ArcGIS XML Import Failed - how to find out why it failed?

I am creating an ESRi XML Workspace document in some of my own C# code. The XML doc that is produced validates against the GdbExchange.xsd schema provided by ESRI. However, when I use ArcCatalog to ...
Jon Pawley's user avatar
3 votes
1 answer
4k views

Error importing XML workspace document to file geodatabase

Ok so I have a large SDE geodatabase that I exported to an XML Workspace Document. I tried to importing it again into a file geodatabase to test if the export worked correctly and got the following ...
Boyle300's user avatar
  • 264
1 vote
0 answers
2k views

Importing XML file in ArcGIS failed

I have created a model in Enterprise Architect (in ArcGIS technology). Inside I have several point, polygon, line feature classes and a couple of domains which correspond to them. From the level of ...
com's user avatar
  • 3,694
1 vote
1 answer
3k views

Converting Microsoft Visio 2007 .vsd file to xml workspace document (without the macro)

I was just editing my geodatabase schema in Microsoft Visio and noticed that it is the new 2007 version, rather than 2003 which had a handy export tool, therefore I downloaded the ESRIExportToXML ...
Duncan's user avatar
  • 63