12

I've recently started creating SQLite geodatabases using ArcGIS 10.2 for Desktop with both ST_GEOMETRY and SPATIALITE storage data types and was impressed by how easy this was to do.

I then tried to Start Editing them from ArcMap only to be blocked by an error:

No editable layers.

and a warning

The workspace containing this data cannot be edited.

enter image description here

I looked and could not find this limitation mentioned anywhere, and originally mistook it as SQLite being read-only to ArcGIS for Desktop.

Is the non-editability of SQLite within ArcMap edit sessions documented anywhere?

11

It's not strictly read-only access. You can load data via copy/paste and import into a SQLite or SpatiaLite database. Tables and feature classes can be appended to using append or Load Data.

You can edit the SQLite/SpatiaLite data via code as Insert/Update/Delete are supported.

What you can't do is open an edit session in ArcMap.

  • Thanks for clarifying and documenting that here Lance and it is great to have your authority behind it. Please do not be offended that I am about to remove your signature, which we do here because every post you make is already signed by your user card which is the ideal place for it. If you want to also document this in the Help then perhaps this would be a suitable place: desktop.arcgis.com/en/desktop/latest/manage-data/databases/… – PolyGeo Sep 24 '15 at 21:35
11

In the documentation, it is alluded to that you cannot edit data in a SQLite database from ArcMap:

You can connect from ArcGIS to an SQLite database to create maps and perform spatial analysis on your data.

However, the only place this appears to be explicitly stated by Esri is in the ArcGIS Discussion Forum:

Yes; you cannot edit data in a SQLite database from ArcMap.

  • 3
    Wow. That's pretty disheartening. I got a little excited when I heard "support for SQLite" in the list of what's new at 10.2. Nice how it never really says that it's read-only access. – Chad Cooper Sep 23 '13 at 13:48
  • 2
    The 10.2 mobile apis (iOS, Android, and Windows) use SQLite under the hood for disconnected editing. But they're able to control that database so that it behaves like a file geodatabase. That's harder to do with a SQLite database in the wild. – raykendo Sep 23 '13 at 13:55
  • 3
    After some test the only way to "create" features using ArcGIS Desktop I found is to copy&paste a feature class from an ArcGIS format (ex: File Geodatabase) to the sqlite database. – Luca Palli Sep 24 '13 at 19:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.