nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export/download non-spatial tables to runtime geodatabase

MarcWouters

I have published a feature service which has both spatial layers and non-spatial tables.

Next, I want to generate a runtime .geodatabase using GenerateGeodatabaseJob::generateGeodatabase(parameters, fileLocation).

The parameters are generated with GeodatabaseSyncTask::createDefaultGenerateGeodatabaseParameters().

The documentation of this method says

All layers from the service will be included

But also

Related tables and layers are not included.

I guess this included non-spatial tables.

To fix this, I set the GenerateLayerOption.setUseGeometry to False, and add a whereClause to select everything ("1=1").

But still, I get the following error :

Unable to create replica. Please check your parameters." : "Exporting data for layer 10 failed."

First of all, is it possible to download non-spatial tables with these methods ?

And if yes, which settings do I need to change ?

All suggestions are welcome.

PS : There is an "ugly" workaround, but I like to avoid it : convert all non-spatial tables to feature tables, by adding a shape field with 1 point

Find more posts tagged with

Accepted answers

LucasDanzinger

We have a test that does this. I just ran it, and it successfully generated the gdb with the table. Here is the code:

<SPAN class="comment token">// Create default generate geodatabase parameters</SPAN>
<SPAN class="keyword token">auto</SPAN> geodatabaseSyncTask <SPAN class="operator token">=</SPAN> std<SPAN class="operator token">::</SPAN>unique_ptr<SPAN class="operator token"><</SPAN>GeodatabaseSyncTask<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">new</SPAN> <SPAN class="token function">GeodatabaseSyncTask</SPAN><SPAN class="punctuation token">(</SPAN>url_standAloneTable<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">VERIFY2</SPAN><SPAN class="punctuation token">(</SPAN>TestObject<SPAN class="operator token">::</SPAN><SPAN class="token function">waitForLoadableInit</SPAN><SPAN class="punctuation token">(</SPAN>geodatabaseSyncTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">get</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Sync task did not initialize, tests will fail"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

Envelope <SPAN class="token function">env</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1.36572476878E7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1.15446130221E7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4281966740</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.41330105216E7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">SpatialReference</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">102100</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// A GenerateLayerOption must be specified, otherwise generateGeodatabaseAsync() throws an exception</SPAN>
GenerateLayerOption option<SPAN class="punctuation token">;</SPAN>
option<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setLayerId</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
option<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setWhereClause</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"1=1"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

GenerateGeodatabaseParameters params<SPAN class="punctuation token">;</SPAN>
params<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setLayerOptions</SPAN><SPAN class="punctuation token">(</SPAN>QList<SPAN class="operator token"><</SPAN>GenerateLayerOption<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><<</SPAN> option<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// An extent must be specified, because "Geometry cannot be null in generate geodatabase parameters"</SPAN>
params<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setExtent</SPAN><SPAN class="punctuation token">(</SPAN>env<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

QString path <SPAN class="operator token">=</SPAN> QDir<SPAN class="operator token">::</SPAN><SPAN class="token function">tempPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">QString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"/nonSpatial.geodatabase"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
QPointer<SPAN class="operator token"><</SPAN>GenerateGeodatabaseJob<SPAN class="operator token">></SPAN> generateGeodatabaseJob <SPAN class="operator token">=</SPAN> geodatabaseSyncTask<SPAN class="operator token">-</SPAN><SPAN class="operator token">></SPAN><SPAN class="token function">generateGeodatabase</SPAN><SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">,</SPAN> path<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

LucasDanzinger

Marc-

This should be possible without the workaround you suggest. See the suggestion here - GenerateGeodatabaseParameters Class | ArcGIS for Developers

"For non-spatial records, set GenerateLayerOption::useGeometry to false and provide a GenerateLayerOption::whereClause."

MarcWouters

Hi Luke,

I've tried that already, without success. Perhaps my whereClause is not valid ?

(but I've successfully used this in other queries).

params.setSyncModel(SyncModel::Layer);
QList<GenerateLayerOption> glo = params.layerOptions();
for (int i = 0; i < glo.size(); ++i) {
   glo.setQueryOption(GenerateLayerQueryOption::All);
   if (i > 10) {      // the first layers do have geometry
      glo.setUseGeometry(false);
      glo.setWhereClause("1=1");
   }
}

Do I need to change something else ?

LucasDanzinger

We have a test that does this. I just ran it, and it successfully generated the gdb with the table. Here is the code:

<SPAN class="comment token">// Create default generate geodatabase parameters</SPAN>
<SPAN class="keyword token">auto</SPAN> geodatabaseSyncTask <SPAN class="operator token">=</SPAN> std<SPAN class="operator token">::</SPAN>unique_ptr<SPAN class="operator token"><</SPAN>GeodatabaseSyncTask<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">new</SPAN> <SPAN class="token function">GeodatabaseSyncTask</SPAN><SPAN class="punctuation token">(</SPAN>url_standAloneTable<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">this</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="token function">VERIFY2</SPAN><SPAN class="punctuation token">(</SPAN>TestObject<SPAN class="operator token">::</SPAN><SPAN class="token function">waitForLoadableInit</SPAN><SPAN class="punctuation token">(</SPAN>geodatabaseSyncTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">get</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Sync task did not initialize, tests will fail"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

Envelope <SPAN class="token function">env</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1.36572476878E7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1.15446130221E7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">4281966740</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1.41330105216E7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="token function">SpatialReference</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">102100</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// A GenerateLayerOption must be specified, otherwise generateGeodatabaseAsync() throws an exception</SPAN>
GenerateLayerOption option<SPAN class="punctuation token">;</SPAN>
option<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setLayerId</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
option<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setWhereClause</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"1=1"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

GenerateGeodatabaseParameters params<SPAN class="punctuation token">;</SPAN>
params<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setLayerOptions</SPAN><SPAN class="punctuation token">(</SPAN>QList<SPAN class="operator token"><</SPAN>GenerateLayerOption<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><<</SPAN> option<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

<SPAN class="comment token">// An extent must be specified, because "Geometry cannot be null in generate geodatabase parameters"</SPAN>
params<SPAN class="punctuation token">.</SPAN><SPAN class="token function">setExtent</SPAN><SPAN class="punctuation token">(</SPAN>env<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

QString path <SPAN class="operator token">=</SPAN> QDir<SPAN class="operator token">::</SPAN><SPAN class="token function">tempPath</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="token function">QString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"/nonSpatial.geodatabase"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
QPointer<SPAN class="operator token"><</SPAN>GenerateGeodatabaseJob<SPAN class="operator token">></SPAN> generateGeodatabaseJob <SPAN class="operator token">=</SPAN> geodatabaseSyncTask<SPAN class="operator token">-</SPAN><SPAN class="operator token">></SPAN><SPAN class="token function">generateGeodatabase</SPAN><SPAN class="punctuation token">(</SPAN>params<SPAN class="punctuation token">,</SPAN> path<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

MarcWouters

Hi Luke,

I am stupid.

Of course it works, because you actually set the LayerOptions in the params (line 13 in your code snippet)

In my code, I only changed a copy, but didn't assign them back to the actual parameters.

Now it works as documented.

Just one small thing : is there a way to identify the layers in GenerateLayerOption list by name or so?

From the GeodatabaseSyncTask::featureServiceInfo(), I can get the layernames (spatial) and the tablenames (non-spatial). This allows me to calculate the number of the layer in the GenerateLayerOption list with the 1st non-spatial table. There should be an easier way to find this.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.