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; } } }

Adding data from sqlite fails (ArcGIS Pro 3.0)

TomGeo

AGP 3.0 has no problem reading the content of an sqlite file in, however, adding data from an sqlite file to map hangs at a 'New Query Layer' dialog, where it seems AGP is trying to read the column properties, and fails.

QGIS does not have any problem reading and visualizing the data. Hence, I don not think there is anything wrong with the sqlite file.

Finde mehr Beiträge mit dem Tag

Desktop

Accepted answers

All comments

TomGeo

Well, Copenhagen here, and after a full working day, plus Tour de France… Colorado sounds good, but my neck hurts immediately again when I think at my last time at the 1st flat iron, and it seems to get pretty hot during the next couple of days.

I will test the sqlite with some feature classes and see about the results for educational purposes.
If it works writing to FGDB than that’s fine for me as well. If everything goes well with the data I will write them anyway into an Enterprise DB.

Robert LeClair

11 PM is getting late certainly! 3 PM Mountain Time Zone in Denver, CO!

So ArcGIS can "kind of" handle OSM data. There are two ways - one using the Data Interability extension. BUT it writes the output to a file geodatabase vs. a Sqlite database. Tried to force it to write to the Sqlite database but it defaulted back to *.gdb. But it did import the OSM data just fine. Another way is to download and install the ArcGIS Editor for OpenStreetMap but it uses ArcMap for this workflow. Not sure if there will be an ArcGIS Pro version of this tool. You can read more about these workflows here.

TomGeo

Will try tomorrow… it’s almost 11pm here now. 😉

Can AGP actually handle an OSM file by itself?

Also, as Said in the initial posting, QGIS reads and visualize the data from the sqlite db without breaking into sweat.

Robert LeClair

Interesting. Thank you for the response and the details. So what I do wonder is the WAY you create the sqlite database may be the issue. One thing to test is to use the Create Sqlite Database GP tool in ArcGIS Pro, bring in some data for 1 or 2 feature classes and see what happens in the UI when you add the data and/or drag/drop. Does the "New Query Layer" dialog open again and stops?

TomGeo

@Robert_LeClair - yes, I do connect to the sqlite via ‘Add Database’ in the catalog pane, and AGP has no issue in listing all the tables within the database.
I did not try the ‘Add Data’ button, but used drag and drop instead - from the catalog pane onto an existing map. I did try a right click as well, adding the table to a new map. Then the map view ic created, and the dialog from my initial post shows up.

Whatever way I tried, the result is the same and I’m stuck at the dialog ‘New Query Layer’. Also, the only way to close the dialog is the close button, the cancel button does not work in this case.

The way I create the sqlite db and it’s data source might be of interest. Who knows.

I build the db in the FME Interoperability workbench by reading an OSM file in. I read every layer of the OSM file as single feature types and write them into the db file via the Spatialite writer, set to allow dynamic schemas.

Robert LeClair

Tom - I presume you're following the steps for connecting to and adding data from a sqlite database as referenced in this help document? Please advise.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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