topic Re: Add feature with attributes and geometry to mobile geodatabase in Qt Maps SDK Questions

Add feature with attributes and geometry to mobile geodatabase

JanWillemsen — Sun, 12 Dec 2021 16:12:27 GMT

Hi,

I have an editable mobile geodatabase (simulation.geodatabase, generated from a feature service) which has a table "Result" with a field "Value" (float64/double) and a Geometry (a polyline).

I want to add some features to this table, but I only succeed in adding empty features (with null for Value and SHAPE).

Below is the relevant code:

...
Esri::ArcGISRuntime::Geodatabase* geodatabase = new Esri::ArcGISRuntime::Geodatabase(QString::fromStdString(_simulationGeodatabasePath));
geodatabase->load();

Esri::ArcGISRuntime::LoadStatus ls = geodatabase->loadStatus();

while (ls != Esri::ArcGISRuntime::LoadStatus::Loaded)
{
    boost::interprocess::winapi::sleep(100);
    ls = geodatabase->loadStatus();
}
 _simTable = EsriContext::getInstance()->getSimulationGeodatabase()->geodatabaseFeatureTable("Result");
if (_simTable)
{
    _simTable->load();
    while (_simTable->loadStatus() != Esri::ArcGISRuntime::LoadStatus::Loaded)
    {
        boost::interprocess::winapi::sleep(100);
    }
    QList<Esri::ArcGISRuntime::Feature*> simResults;

    std::vector<std::shared_ptr<Esri::ArcGISRuntime::PolylineBuilder> >::iterator it = _polylineBuilders.begin();
    int i = 1;
    for (it; it != _polylineBuilders.end(); ++it, ++i)
    {
        std::string index = boost::lexical_cast<std::string>(i);

        QMap<QString, QVariant> featureAttributes;
        featureAttributes.insert("Value", 1.0);
        Esri::ArcGISRuntime::Feature* feature = _simTable->createFeature(featureAttributes, (*it)->toGeometry(), geodatabase);
        simResults.append(feature);
    }


    if (_simTable->canAdd())
    {
        Esri::ArcGISRuntime::TaskWatcher& taskWatcher = _simTable->addFeatures(simResults);

        while (!(taskWatcher.isDone()))
        {
            boost::interprocess::winapi::sleep(100);
        }
    }
}
...

The wkid of the polylines from the polylinebuilders is the same as the one of the .geodatabase.

When I just create an empty feature (_simTable->createFeature(_geodatabase);) and add them, they are added to the geodatabase (I check it with "db browser for sqlite"). When I try to assign an attribute and geometry like in the code above, nothing is added. Anybody has any idea what I'm doing wrong?

Kind regards,

Jan

Re: Add feature with attributes and geometry to mobile geodatabase

JamesBallard1 — Thu, 31 Aug 2017 18:41:58 GMT

Hi Jan,

This is difficult to diagnose without the geodatabase. Here are some things to try.

Can you verify this is returning a valid, non-null feature? It's possible there's a schema mismatch or maybe there's a missing required field.

Esri::ArcGISRuntime::Feature* feature = _simTable->createFeature(featureAttributes, (*it)->toGeometry(), geodatabase);

You could also connect to the errorOccurred signal to see if any errors are being reported on the table.

if (_simTable)
{
connect(_simTable, &FeatureTable::errorOccurred, this, [](Error e)
{
qDebug() << "Error:" << e.message() << e.additionalMessage();
});
...

Please let us know if that helps.

Re: Add feature with attributes and geometry to mobile geodatabase

JanWillemsen — Fri, 01 Sep 2017 10:17:12 GMT

Hi James,

thanks for the suggestion. It didn't give me any error though (valid pointer and the code didn't arrive in the slot either).

We found out that the spatial reference of the exported .geodatabase was still wrong, now it seems to work.

Thanks,

Jan

Re: Add feature with attributes and geometry to mobile geodatabase

JamesBallard1 — Fri, 01 Sep 2017 15:19:04 GMT

Jan,

Thanks for the update. It's good to hear it's working now.