AnsweredAssumed Answered

Load Features from Spatialite database

Question asked by Supaidaman on May 13, 2020
Latest reply on Jun 11, 2020 by LDanzinger-esristaff

Hello, I've been looking into the Feature Layer (Geodatabase) QML example and I've tried to just do the same with a sqlite spatialite database, to no avail

 

Is it possible to do so?

 

I have a spatial table with the following structure, created from SQlite:

CREATE TABLE "furos" (
"OBJECTID" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
"SHAPE" MULTIPOINT,
"ID_FURO" integer NOT NULL,
"FURO_TX_NOME" text(255),
"FURO_VL_MC" text(50),
"FURO_VL_LAM_DAGUA" text(50),
"FURO_VL_PROF_FINAL" text(50),
"X_SIRGAS" text(50),
"Y_SIRGAS" text(50),
"X_CGS" text(50),
"Y_CGS" text(50),
"GUID" TEXT(255),
"DATA_IMPORTACAO" DATE
);

 

 

And I've tried loading the database file by basically doing the same code from the geodatabase example:

 Map {
            id: map
            BasemapStreetsVector {}
            FeatureLayer {
                featureTable: gdb.geodatabaseFeatureTablesByTableName["furos"] ?
                                  gdb.geodatabaseFeatureTablesByTableName["furos"] :
                                  null
                Geodatabase {
                    id: gdb
                     path: pathName
                    onErrorChanged: errorMessage = error.message;
                }
                onLoadStatusChanged: {
                    console.log(dataPath);
                    console.log(errorMessage);
                    if (loadStatus !== Enums.LoadStatusLoaded)
                        return;
                    mapView.setViewpointCenterAndScale(fullExtent.center, 80000);
                }
            }

 

Unfortunately, nothing happens. I receive these three errors from Qt:

 

Exception at 0x7ffd59bfa799, code: 0xe06d7363: C++ exception, flags=0x1 (execution cannot be continued) (first chance) in runtimecore!RT_UtilityTraversability_fromJSON

Exception at 0x7ffd59bfa799, code: 0xe06d7363: C++ exception, flags=0x1 (execution cannot be continued) (first chance) in runtimecore!ESRI_CopyProtect_GetInstallDir

Exception at 0x7ffd59bfa799, code: 0xe06d7363: C++ exception, flags=0x1 (execution cannot be continued) (first chance) in ntdll!RtlCaptureContext

 

Is it possible to load only geodatabases created from ArcMap or something similar? I can open these kind of files in the SQLite Browser so I thought the format was basically the same.

Outcomes