topic Re: Creating feature class with unknown coordinate system - XML definition in File Geodatabase API Questions

Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Tue, 12 Jul 2011 09:02:04 GMT

Hi,
I am trying to create feature classes with an unknown coordinate system using the FGDB API.
The feature classes appear to create OK, and I can add features, but I then get drawing errors
in Arcmap, and errors in ArcCatalog if I try to copy/paste the feature class or export it as XML.

Can you tell me what I am missing from my XML feature class definition? Please see attached XML feature class definition.

Thanks very much,

Chris

Re: Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Fri, 10 Dec 2021 21:19:40 GMT

Some additional information.
Here's my sample code to create an empty feature class

int main()
{
  fgdbError hr;
  wstring   errorText;

  // create geodatabase
  Geodatabase geodatabase;
  if ((hr = CreateGeodatabase(L"c:\\testing.gdb", geodatabase)) != S_OK) {
 wcout << "Geodatabase create error" << endl;
 ErrorInfo::GetErrorDescription(hr, errorText);
 wcout << errorText << "(" << hr << ")." << endl;
 return -1;
  }

  // load XML table def
  string tableDef;
  string defLine;
  ifstream defFile("C:\\create-chris1.xml");
  while (getline(defFile,defLine))
   tableDef.append(defLine+"\n");
  defFile.close();

  // create table from XML def
  Table table;
  if ((hr = geodatabase.CreateTable(tableDef,L"",table)) != S_OK) {
    wcout << "CreateTable error" << endl;
 ErrorInfo::GetErrorDescription(hr, errorText);
 wcout << errorText << "(" << hr << ")." << endl;
 return -1;
  }

  if ((hr = geodatabase.CloseTable(table)) != S_OK) {
    wcout << "CloseTable error" << endl;
 ErrorInfo::GetErrorDescription(hr, errorText);
 wcout << errorText << "(" << hr << ")." << endl;
 return -1;
  }

  // Close the geodatabase
  if ((hr = CloseGeodatabase(geodatabase)) != S_OK)
  {
    wcout << "An error occurred while closing the geodatabase." << endl;
    ErrorInfo::GetErrorDescription(hr, errorText);
    wcout << errorText << "(" << hr << ")." << endl;
    return -1;
  }

  return 0;
}

This creates the FGDB and feature class without any apparent errors.

Then, in ArcCatalog (10 SP2), I try to copy/paste the feature class, and receive this error:
Failed to paste chris1
The XML being loaded could not be parsed. [physical name: CHRIS1]
The item does not have a definition.
The XML being loaded could not be parsed. [physical name: CHRIS1]

This would appear to imply to me that my initial XML feature class definition is missing some required field. Help would be very much appreciated! Thanks.

Chris

Re: Creating feature class with unknown coordinate system - XML definition

VinceAngelo — Wed, 13 Jul 2011 19:49:12 GMT

The folks most likely to able to answer this are probably swamped with UC attendance.
You might get quicker response by contacting Tech Support.

It looks to me like you're missing the AliasName and ModelName tags within Field; though
the XSD doesn't seem to require them, all the examples do include both.

- V

Re: Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Wed, 13 Jul 2011 20:30:34 GMT

Hi,
Thanks for the reply.
I had tried adding the AliasName and ModelName to each field, but it appears to make no difference.
In my actual application I am attempting to create the XML dynamically, using
IXMLDomDocument, and I already have have a screen full of node.addChildElement(...) etc, so I'm
just trying to cut the XML down to the bare essentials.
I'll keep on experimenting. I can create correct feature classes if I already know the spatial reference, but the trouble is, I don't, The API does not seem to have any mechanism for choosing a valid one (a redistributable XML file of valid spatial references would be useful). I was planning to create feature classes with an undefined spatial reference, and then let the user define the spatial reference later using ArcCatalog.
So I'm still trying to find the minimum required XML for a feature class with an undefined spatial reference.

cheers,

Chris

Re: Creating feature class with unknown coordinate system - XML definition

VinceAngelo — Thu, 14 Jul 2011 01:23:51 GMT

It isn't particularly wise to leave the coordinate system undefined. Using an impossibly large
spatial reference does more harm than good, and origin and scale parameters cannot be
adjusted later with the coordsys.

There are several thousand "standard" coordinate systems, and an infinite number of
potential spatial references. The Esri Projection Engine is used to define coordinate
systems; it is based on the EPSG reference standard. Samples of the most common
forms ship with every copy of ArcGIS. The projection gurus established a standard set
of parameters for each spatial reference used by ArcGIS, but any of them can (and really
should) be overridden to optimize performance for any particular dataset.

I agree that the XML definition process leaves a lot to be desired, but coming from the
ArcSDE side of the house, and knowing that the Projection Engine and Coordinate Reference
code represents nearly half of the ArcSDE functions, I can see how this could be a slippery
slope that could have delayed the FileGDB API delivery by years.

- V

Re: Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Thu, 14 Jul 2011 08:01:43 GMT

It isn't particularly wise to leave the coordinate system undefined. Using an impossibly large
spatial reference does more harm than good, and origin and scale parameters cannot be
adjusted later with the coordsys.

Hi Vince,
I am aware that it is far from ideal to create a feature class with an unknown spatial reference,
but the FGDB API seems to allow it, and ArcCatalog allows it as well.
I am intending that the spatial reference will be defined later, within ArcCatalog, since at this stage
I wish to avoid having to develop an entire spatial reference selection/editing mechanism - that is
what ArcGIS does, and I have no wish to duplicate it at this stage!

The FGDB API samples XMLSamples dir even includes a sample XML table def FC_Unknown_PolygonMin.xml which is supposed to have the minimal required spatial reference info,
but this fails when called with CreateTable (General function failure (-2147467259)).

I tried constructing a feature class in ArcCatalog with undefined spatial reference, then exported the schema as XML, and used that as the basis for my XML used in CreateTable. This is the basis for my create-chris1.xml table def. However, I am still missing something, as ArcCatalog does not fully recognise the new feature class.

cheers,

Chris

Re: Creating feature class with unknown coordinate system - XML definition

VinceAngelo — Thu, 14 Jul 2011 18:14:18 GMT

Unfortunately, when you set out to use the FileGDB API to create new tables, you are choosing to
take over ArcGIS' role in feature class creation. Using generic parameters for table creation may
be possible, but it's unlikely to generate high quality datasets -- if you don't know, at a minimum,
the spatial units being used and the range of possible values (and alter the spatial reference to
correspond to them) then I'd argue that it's not really worth the effort of loading the data.

I know the samples execute cleanly on the reference machines, so this should probably be your
first line of inquiry with Tech Support.

- V

Re: Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Fri, 15 Jul 2011 08:26:54 GMT

Unfortunately, when you set out to use the FileGDB API to create new tables, you are choosing to
take over ArcGIS' role in feature class creation. Using generic parameters for table creation may
be possible, but it's unlikely to generate high quality datasets -- if you don't know, at a minimum,
the spatial units being used and the range of possible values (and alter the spatial reference to
correspond to them) then I'd argue that it's not really worth the effort of loading the data.

Hi Vince,
The problem I am having is that the XML definition for an undefined spatial reference in the sample XML seems to be incomplete, and will not create a valid feature class - even an empty one. If I can get a working definition of an undefined spatial reference, then I can adjust the range and tolerance accordingly. But, as I have said, the spatial reference will be set later, before the feature class in ever used, within the ArcGIS environment.

cheers,

Chris

Re: Creating feature class - XML definition

ChrisMorgan1 — Fri, 15 Jul 2011 10:26:25 GMT

OK, let's try another tack. The unknown coordinate system turns out to be too much of a distraction.
I now have an XML feature class definition with a defined spatial reference - see attachment.

This creates an empty polyline-M feature class 'chris1'.
I have code which successfully adds features to this feature class, but I have not included that here.

However, ArcCatalog still does not fully recognise this feature class as valid.
The features can be viewed, but when attempting to copy/paste the feature class in
ArcCatalog, I now get the error message

Failed to paste chris1
Unable to create object class instance COM component
Unable to create object class instance COM component

I have concluded that my XML definition is still incomplete. What am I missing?

Thanks,

Chris

Re: Creating feature class with unknown coordinate system - XML definition

LanceShipman — Fri, 15 Jul 2011 16:25:11 GMT

We have duplicated your issue and are debugging it. I will be on vacation next week, so I will not get back to you until the week of July the 25th.

Re: Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Sat, 16 Jul 2011 16:38:36 GMT

We have duplicated your issue and are debugging it. I will be on vacation next week, so I will not get back to you until the week of July the 25th.

Thanks for the reply - it is always reassuring to at least have verification of the problem!
Have a good vacation.

cheers,

Chris

Re: Creating feature class with unknown coordinate system - XML definition

TomBreed — Fri, 10 Dec 2021 21:19:42 GMT

Hi - Thank you for your patience! I was able to get feature classes based on the referenced xml copy/pasting correctly by making a few minor changes:

Add the Shape_Length field to the fieldset for the feature class:

<Field xsi:type="esri:Field">
 <Name>Shape_Length</Name>
 <Type>esriFieldTypeDouble</Type>
 <IsNullable>true</IsNullable>
 <Length>8</Length>
 <Precision>0</Precision>
 <Scale>0</Scale>
 <Required>true</Required>
 <Editable>false</Editable>
 <AliasName>Shape_Length</AliasName>
 <ModelName>Shape_Length</ModelName>
</Field>

Then I added information on what the area and length field names are between the <HasSpatialIndex /> and <Extent /> tags. Note that there is no Shape_Area, but the empty tag needs to be there:

<HasSpatialIndex>true</HasSpatialIndex>
<AreaFieldName/>
<LengthFieldName>Shape_Length</LengthFieldName>
<Extent xsi:nil="true"/>

Finally I changed the CLSID from

<CLSID>{86E3C61F-7D4E-48DF-8B2E-AF71CD0BCB61}</CLSID>

<CLSID>{52353152-891A-11D0-BEC6-00805F7C4268}</CLSID>

Hope this gets you past this hurdle!

Re: Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Wed, 20 Jul 2011 07:42:02 GMT

Finally I changed the CLSID from

<CLSID>{86E3C61F-7D4E-48DF-8B2E-AF71CD0BCB61}</CLSID>

<CLSID>{52353152-891A-11D0-BEC6-00805F7C4268}</CLSID>

Hi Thomas, thanks for your reply.
I now have a working XML definition - thanks! ArcCatalog copy/paste of an empty feature class
created with this XML definition works without errors.
The Shape_Length field does not seem to be required, but the CLSID value is crucial.
But what is the deal with the CLSID value - is this a defined 'magic number' that I should always use? Do all feature classes have the same CLSID value in their definition? Is this defined/documented anywhere?

cheers,

Chris

Re: Creating feature class with unknown coordinate system - XML definition

TomBreed — Wed, 20 Jul 2011 15:21:12 GMT

Hi Chris,

Glad I was able to help. You are correct in a sense that the CLSID is a magic number: COM uses it to identify what it needs to instantiate a COM object. In this specific case, the CLSID identifies what makes up the table: i.e. rows or features or something else. While the File GDB API is not COM based, ArcGIS is.

As far as the File GDB API is concerned, you can safely use the CLSID of Feature as noted earlier in the thread and the CLSID for a row for non-spatial tables.

Features  - {52353152-891A-11D0-BEC6-00805F7C4268}

Rows - {7A566981-C114-11D2-8A28-006097AFF44E}

I hope this helps,
Tom

Re: Creating feature class with unknown coordinate system - XML definition

ChrisMorgan1 — Wed, 20 Jul 2011 15:36:05 GMT

Features  - {52353152-891A-11D0-BEC6-00805F7C4268}

Rows - {7A566981-C114-11D2-8A28-006097AFF44E}

So any feature class that I create (points, lines or polygons), should use the first CLSID above,
and any standalone table that I create should use the second CLSID?

cheers,

Chris