Load Features from Spatialite database

576
1
Jump to solution
05-13-2020 12:58 PM
ViníciusCosta
New Contributor III

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.

0 Kudos
1 Solution

Accepted Solutions
LucasDanzinger
Esri Frequent Contributor

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)

View solution in original post

1 Reply
LucasDanzinger
Esri Frequent Contributor

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)