SQLITESTUDIO UNABLE TO EXTRACT METADATA CODE
Here is a code snippet for an example of extracting the xml metadata with Java from Oracle/ArcSDE 10.2. More detailed instructions can be found here:Īre your layers registered with the geodatabase? They will need to be to work with gdb_items_vw. If that is the case, it starts to look like you may need to make an official support call for this with ESRI. Some issue with the gdb_items_vw database view or the ArcSDE / Geodatabase repository. But maybe you need to add 'instance_name' in Oracle? (I can't check it for you, since I don't have it running). in SQL Server, you need to write 'database_er_name.table_name' since SQL Server supports multiple databases per instance. Is it really enough to just specify 'user_name.table_name' ? E.g. Did you have a look at the Name column in the gdb_items tables. Otherwise, the Documentation field will stay empty (Null) for the particular Feature Class you tried to query.Īll the other automatically maintained system data, like the Feature Class properties, is stored elsewhere in the geodatabase system tables. So why this table is empty? Is that the right table to get metadata?ĭid you actually define / write metadata for the layers in your geodatabase?, or are you just interested in general Feature Class properties like extent, fields, projection etc., and have falsely assumed that ArcGIS automatically stores these as ESRI/ISO XML metadata in the gdb_items table as well? This is not the case, you need to, at the very least, activate the Metadata TAB in ArcCatalog once to have it write XML metadata to the gdb_item's metadata column (named "Documentation") for the selected Feature Class. but as my sde.gdb_items_vw table is empty, the query gives me 0 selected lines! SQL> select EXTRACT (XMLType (DOCUMENTATION), '/ metadata') as DOCUMENTATION from sde.gdb_items_vw where name = 'user_name.table_name' I want to pass a SQL command, something like Select DOCUMENTATION from gdb_items_vw, to retrieve all the information about the metadata of the layer.īut the difficulty is that this DOCUMENTATION field is CLOB type. Maybe you are looking for the information in the "DEFINITION" column rather than the "DOCUMENTATION" column? See Configuring the Oracle listener to use SQL for more information."Īnd some examples are available here in the doc as well. To query the contents of the CLOB columns, you must configure the Oracle server to accept SQL connections. Be aware that if you attempt to create an XML type for a column that contains a blank string, it will fail with the message "XML parsing failed" because Oracle does not support this. When querying these views, you extract the string from the CLOB column, convert it to an XML type, and execute an XPath query on it. The contents of the CLOB columns can be read as text. The GDB_ItemRelationships_vw shows the contents of the Attributes column of the GDB_ItemRelationships table in a CLOB column. The GDB_Items_vw shows the contents of the Definition, Documentation, and ItemInfo columns from the GDB_Items table in CLOB columns. "To allow you to view the contents of the XML columns in the system tables in geodatabases in Oracle, two system views exist that store the contents from the geodatabase system table XML columns in a CLOB data type.
In continuing the quote from the same documentation link (first one) above it also says you can query the GDB_Items_vw, etc.: You can save the code below as a XLST document to feed into the tool. Use the XSLT Transformation tool and with an identity XSLT to extract all the metadata.
I suggest using a Python script/Model to fully export the metadata. (I tried to hunt for this as you have in the past.) As such, they cannot be directly accessed with SQL."Īs such, the XML metadata cannot be accessed directly by a simple query to the database.
SQLITESTUDIO UNABLE TO EXTRACT METADATA SERIES
"In geodatabases in Oracle and Informix, the XML columns use ArcSDE XML, which stores information as BLOBs in a series of separate tables. # list feature classes inside the datasetįcList = arcpy.ListFeatureClasses("","",dataset) Spot = tree.find("idinfo/descript/purpose") Xmlfile = r"U:\my docs\GIS Projects\Python\Scripts\List Metadata\working_test.xml"Īrcpy.ExportMetadata_conversion(fc, translatorpath, xmlfile) Translatorpath = AGSHOME + r"Metadata\Translator\ARCGIS2FGDC.xml" From import ElementTreeĮnv.workspace = r"D:\Lakeland_GIS\GDB\Lakeland\Lakeland.gdb\AddPoints"ĪGSHOME = arcpy.GetInstallInfo("Desktop")
0 kommentar(er)
