Load Features from Spatialite database

ViníciusCosta — Wed, 13 May 2020 19:58:58 GMT

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.

Re: Load Features from Spatialite database

LucasDanzinger — Thu, 11 Jun 2020 22:04:44 GMT

We do not support the SpatialLite format. Geodatabases can be created through ArcGIS Pro's create Mobile Map Package tool (the .geodatabase will be inside the mmpk), ArcMap's Create Runtime Content tool, or various online REST endpoints/Go Offline APIs that we have (OfflineMapTask, GeodatabaseSyncTask)

topic Load Features from Spatialite database in Qt Maps SDK Questions

Load Features from Spatialite database

Re: Load Features from Spatialite database