topic Re: Spatial Reference Info in File Geodatabase API Questions

Spatial Reference Info

ahuarte — Fri, 18 Feb 2011 09:28:26 GMT

Hi!

I need read the SpatialReference info of a FeatureClass.

XML samples in the doc-SDK contains this description (WKT, WKID...) but calling to Table::GetDefinition() function it always returns no data.

I have test all sample gdb files and other personal gdb files FgdbV10.
What it's wrong?

thank you very much

Re: Spatial Reference Info

LanceShipman — Sat, 11 Dec 2021 09:27:36 GMT

The following code produces XML with the spatial information:

  // Open the geodatabase.
  int hr;
  Geodatabase geodatabase;
  if ((hr = OpenGeodatabase(L"../data/ctg94AllDataset.gdb", geodatabase)) != S_OK)
  {
    wcout << "An error occurred while opening the geodatabase." << endl;
    wcout << "Error code: " << hr << endl;
    return -1;
  }

  // Open the ManyFieldTypes table.
  Table table;
  if ((hr = geodatabase.OpenTable(L"\\ctg83FDS\\ctg83FCinTopo", table)) != S_OK)
  {
    wcout << "An error occurred while opening the table." << endl;
    wcout << "Error code: " << hr << endl;
    return -1;
  }

  // GetDefitition
  wcout << "Test GetDefitition:" << endl;
  string xmlDef;
  if ((hr = table.GetDefinition(xmlDef)) != S_OK)
  {
    wcout << "An error occurred getting the table definition." << endl;
    wcout << "Error code: " << hr << endl;
    return -1;
  }

  cout << xmlDef << endl;

I've attached the XML that this code produces.

Re: Spatial Reference Info

ahuarte — Sat, 19 Feb 2011 16:18:52 GMT

thanks your reply

I am confused. I get this XML reading the ExecuteSQL-cities gdb sample from the sdk.

It have not WKT and WKID info and Table::getDefinition returns me the -2147211775 error code.

The table was opened success.

All samples from SDK and my gdbv10 files return equals.
why ¿?

Re: Spatial Reference Info

LanceShipman — Tue, 22 Feb 2011 15:54:27 GMT

thanks your reply

I am confused. I get this XML reading the ExecuteSQL-cities gdb sample from the sdk.

It have not WKT and WKID info and Table::getDefinition returns me the -2147211775 error code.

What beta are you using we have released 2. I get the WKT in the XML. When does the error get returned? It's an item not found error. Can you post your code?

All samples from SDK and my gdbv10 files return equals.
why ¿?

I'm sorry, I don't understand. What returns equals?

Re: Spatial Reference Info

ahuarte — Tue, 22 Feb 2011 21:41:24 GMT

I use the beta release 2.

my code...

std::wstring tempString = L"";
Helper_MarshalString(tableName, tempString);

m_pDatabase = database->m_pDatabase;
m_pTable = new FileGDBAPI::Table();
long hr = m_pDatabase->OpenTable(tempString, *m_pTable);
if (hr==S_OK) return false;

std::string tempString2 = "";
long hr = m_pTable->GetDefinition(tempString2); //-> ### ERROR -2147211775

tempString2 has XML content but NO WKT info!
all samples and my FGDB files (Imported in ArcCatalog 10 from shapefiles) return this error.

Sorry my bad english!
Thank you very much

Re: Spatial Reference Info

LanceShipman — Wed, 23 Feb 2011 00:06:11 GMT

I use the beta release 2.

my code...

std::wstring tempString = L"";
Helper_MarshalString(tableName, tempString);

m_pDatabase = database->m_pDatabase;
m_pTable = new FileGDBAPI::Table();
long hr = m_pDatabase->OpenTable(tempString, *m_pTable);
if (hr==S_OK) return false;

std::string tempString2 = "";
long hr = m_pTable->GetDefinition(tempString2); //-> ### ERROR -2147211775

tempString2 has XML content but NO WKT info!
all samples and my FGDB files (Imported in ArcCatalog 10 from shapefiles) return this error.

Sorry my bad english!
Thank you very much

What version of Winodow and Visual Studio are you using?

Re: Spatial Reference Info

ahuarte — Wed, 23 Feb 2011 09:24:43 GMT

I use

- Windows XP 32bits SP3 (spanish)
- Visual Studio 2008 9.0.30729.1 SP (english)

Re: Spatial Reference Info

LanceShipman — Sat, 11 Dec 2021 09:27:39 GMT

std::wstring tempString = L"";
Helper_MarshalString(tableName, tempString);

m_pDatabase = database->m_pDatabase;
m_pTable = new FileGDBAPI::Table();
long hr = m_pDatabase->OpenTable(tempString, *m_pTable);
if (hr==S_OK) return false; <- this is incorrect. 

std::string tempString2 = "";
long hr = m_pTable->GetDefinition(tempString2); //-> ### ERROR -2147211775

if (hr != S_OK) return false

S_OK (0) indicates success. The likely problem is that the table name is incorrect. Using

if(hr==S_OK) return false

the code will only continue executing if OpenTable fails. Any results from the GetDefinition is an error.

Do the samples execute for you?

Re: Spatial Reference Info

ahuarte — Fri, 25 Feb 2011 05:27:17 GMT

I'm sorry, I copied the wrong code.

Please, ignore... "if (hr==S_OK) return false;" <- this is incorrect

XML file that I sent is the example "ExecuteSQL.gdb"

thak you very much!!!!

Re: Spatial Reference Info

LanceShipman — Fri, 25 Feb 2011 14:28:47 GMT

Do the samples execute? This is important. We have tested the samples on most Windows platforms and have never seen a problem.

Re: Spatial Reference Info

ahuarte — Tue, 01 Mar 2011 13:11:59 GMT

Hi!
I test Table::GetDefinition() in the ExecutingSQL sample and it works OK.

I got to know how it fails!
I'm developing a C++ CLI/.NET with a 'ref class' which handle the FileGDBAPI::Table*.

This 'ref class' has two data member...

FileGDBAPI:: Database*
FileGDBAPI:: Table*

The database and table are open correctly. Envelope, RowCount, Search ... work fine!
Only "Table::GetDefinition()" return error.

if instead of using a database* I use database&, it work fine :confused:

I can rewrite the code, but I still question why the failure

thank you ver much!!!!

Re: Spatial Reference Info

SasaI_ — Wed, 02 Mar 2011 12:41:16 GMT

I just replied to the .NET Wrapper thread with this, but here is the summary:

It seems you must prefix the table name with a "\". So in case of the ExecuteSQL.gdb database, if you want to open the cities table you'll want to make the call as OpenTable(L"\\Cities"). If you don't prefix the path with a "\", the table opens successfully AND the table definition is populated properly from the GetDefinition call. However, the result code is -2147211775, indicating the path is not found. Prefixing the table will make the function return 0.

This is made even more confusing with the samples opening the table by using both L"Cities" (Display/Querying) and L"\\Cities" (Editing).