Problem: Unable to alter properties of an existing geodatabase created with CASE Tools using Enterprise Architect
When creating a geodatabase schema using Unified Modeling Language (UML) in Microsoft Visio Professional 2007, the geodatabase schema is exported as an XML Metadata Interchange (XMI) document in the file format of .xml.
This is readable by CASE Tools to create empty template geodatabases and allow properties, such as the spatial reference, extent, and precision of data in the geodatabase to be modified.
However, when using UML in Enterprise Architect to create and manage the geodatabase schema, the model is exported to an XML Workspace Document, which is used to create geodatabase templates. The existing properties for spatial reference, precision and extent of the geodatabase created from the XML Workspace Document cannot be modified using Enterprise Architect.
By design, when a template geodatabase is created, the geodatabase properties are set according to the existing schema. There are no options available to allow the predefined spatial reference, extent, or precision of data in the geodatabase to be modified.
A geodatabase schema modeled in Enterprise Architect requires an XML workspace document, as the XMI document exported from Enterprise Architect is not supported for use with CASE Tools and the Schema Generation Wizard.
Since incremental updates to the geodatabase schema are not supported when exporting to an XML workspace document, the entire document must be updated.
Solution or Workaround
To modify the geodatabase properties, follow the steps below.
- Create a UML geodatabase schema in Enterprise Architect.
- Specify a spatial reference for the schema to export a valid geodatabase schema from Enterprise Architect. In Enterprise Architect, select the desired coordinate system when defining the spatial reference to automatically insert default values for the geodatabase properties.
- Generate the geodatabase schema as an XML workspace document by selecting the Export to ArcGIS Workspace XML option.
- In ArcCatalog, import the XML workspace document to a new geodatabase.
a. In the Catalog tree, right-click the geodatabase name > Import > XML Workspace Document.
b. In the Import XML Workspace Document wizard, select the 'Schema Only' option and specify the location of the XML source to import.
c. Click the Next button to begin the importing process.
d. When the schema information of the geodatabase is displayed in the Import XML Workspace Document wizard, click Finish.
- Use the X-Ray for ArcCatalog Add-in to apply a different spatial reference to the existing data from a different geodatabase.
a. Create a new file geodatabase.
b. Open the XML workspace document in X-Ray.
c. Under the Options menu, select the Use Spatial Reference option to use the spatial reference from another geodatabase.
d. Save the spatial reference.
- Import the updated XML workspace document to a new geodatabase.
- Load existing data into the new geodatabase.
- In Enterprise Architect, make the necessary updates to the UML of the new geodatabase.
- Export the UML back to an XML workspace document in ArcCatalog.
- Use the ArcGIS Solutions Schema Migration Wizard to update the existing geodatabase with the updated schema. For more information, refer to Upgrade information model.
- ArcGIS Help: Geodatabase XML
- ArcGIS Help: Exporting a geodatabase schema to an XML workspace document
- ArcGIS Help: Importing a geodatabase schema from an XML workspace document
- ArcGIS Help: Using CASE tools and UML to create a geodatabase schema
- ArcGIS Help: A note about the use of UML for geodatabase design
- ArcGIS Resources: Getting Started with the Local Government Information Model
- What versions of Microsoft Visio are supported for use with CASE Tools?
- Is it possible to export a geodatabase schema to a UML object model?
- Load data into a geodatabase created with a UML model (CASE Tools)
- What versions of Sparx Systems