How-To - ArcFM - How to Get Object Type GUIDs in 10.x Geodatabases

Version 2

    Solution

     

    As of ArcGIS 10.0, GUIDs for feature and object classes are no longer stored in the GDB_ObjectClasses table. They are now stored in the Definition column of the GDB_Items table as an XML type. The following SQL Server query may be used to get the GUIDs. The GUIDs can be used to tell whether the object is an ArcFM, Designer or ESRI type.

     

    SELECT
    items.[Name] as 'Object Class Name',
    items.Definition.value('(/DETableInfo//CLSID)[1]','varchar(40)') as CLSID,
    items.Definition.value('(/DETableInfo//EXTCLSID)[1]', 'varchar(40)') as EXTCLSID
    FROM [sde].[GDB_ITEMTYPES] itypes
    inner join [sde].[GDB_ITEMS] items on itypes.uuid = items.type
    WHERE
    itypes.name = 'Table'

    SELECT
    items.[Name] as 'Feature Class Name',
    items.Definition.value('(/DEFeatureClassInfo//CLSID)[1]', 'varchar(40)') as CLSID,
    items.Definition.value('(/DEFeatureClassInfo//EXTCLSID)[1]', 'varchar(40)') as ExtCLSID
    FROM [sde].[GDB_ITEMTYPES] itypes
    inner join [sde].[GDB_ITEMS] items on itypes.uuid = items.type
    WHERE
    itypes.name = 'Feature Class'

     

    GUID Definitions

     

    Match the GUID from the queries above to the definition in this table to get the object type

    ArcFM CGOs (CLSID)
    {EA831E01-7D3D-11D4-9A1B-0001031AE963}mmGeodatabase.MMArcFMObject
    {EA831E02-7D3D-11D4-9A1B-0001031AE963}mmGeodatabase.MMArcFMFeature
    {EA831E05-7D3D-11D4-9A1B-0001031AE963}mmGeodatabase.MMArcFMSimpleEdgeFeature
    {EA831E06-7D3D-11D4-9A1B-0001031AE963}mmGeodatabase.MMArcFMComplexEdgeFeature
    {EA831E03-7D3D-11D4-9A1B-0001031AE963}mmGeodatabase.MMArcFMSimpleJunctionFeature
    {1CBACE68-7E30-46EF-89F6-486082380E16}mmGeodatabase.mmArcFMAnnotationFeature

     

    Designer CGOs (CLSID)

    {53D0BFE5-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8DesignFeature
    {53D0BFE2-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8WorkRequestFeature
    {53D0BFE7-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8WorkLocationFeature
    {53D0BFE9-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8ConstructionFeature
    {53D0BFFB-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8ConstructionSimpleEdgeFeature
    {53D0BFFD-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8ConstructionComplexEdgeFeature
    {53D0BFF4-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8ConstructionSimpleJunctionFeature
    {53D0BFF8-446E-11D3-88FC-00104B9F25F6}mmGeodatabase.D8ConstructionComplexJunctionFeature

     

    ESRI Objects (CLSID)

    {7A566981-C114-11D2-8A28-006097AFF44E}esriGeoDatabase.Object
    {52353152-891A-11D0-BEC6-00805F7C4268}esriGeoDatabase.Feature
    {DF9D71F4-DA32-11D1-AEBA-0000F80372B4}esriGeoDatabase.ComplexJunctionFeature
    {CEE8D6B8-55FE-11D1-AE55-0000F80372B4}esriGeoDatabase.SimpleJunctionFeature
    {E7031C90-55FE-11D1-AE55-0000F80372B4}esriGeoDatabase.SimpleEdgeFeature
    {A30E8A2A-C50B-11D1-AEA9-0000F80372B4}esriGeoDatabase.ComplexedgeFeature
    {E3676993-C682-11D2-8A2A-006097AFF44E}esriCarto.AnnotationFeature

     

    MMClassExtensions (EXTCLSID)

    {E0EC09F6-0588-4882-B12C-DE0306550FD6}mmGeoDatabase.MMSimpleEdgeFeatureExtension
    {91BC9A23-B210-4EE5-B524-93BCD640E58D}mmGeoDatabase.MMSimpleJunctionFeatureExtension
    {BF77404C-E8B3-4EE8-9456-BCA121416675}mmGeoDatabase.MMFeatureExtension
    {D94429F6-466F-4DF9-8262-DE969EF4491C}mmGeoDatabase.MMObjectExtension
    {27E88E1C-9598-49C3-9B48-08FB5F5836B2}mmGeoDatabase.MMComplexEdgeFeatureExtension

     

    Known Class Extensions (EXTCLSID)

    {70B0A6EF-CCAA-11D4-8210-005004ABB140}MMLasso.MMLassoClassExtension (deprecated)
    {2C721DC1-FEC6-4F37-AE75-EEDB2103D3A0}mmCSMGeoDatabase.MMLassoClassExtension
    {5A8B04E3-05FB-422F-9628-5230C819D3C8}MMMapInset.MapInsetClassExtension
    {48F935E2-DA66-11D3-80CE-00C04F601565}esriCarto.DimensionClassExtension
    {24429589-D711-11D2-9F41-00C04F6BC6A5}esriCarto.AnnotationFeatureClassExtension