I'm using qgis and grass for my work. I've produced a shapefile which is over 100mbs (s a result of some statistical analysis).

If i convert it to sqlite format (spatially enabled) the data shrinks down to 15 mbs. Which is acceptable for sharing it with email or dropbox.

BUT my colleague is using arcgis 9.3 - will he be able to read the data without any problems?

  • 1
    You could zip up the shapefile and get similar compression. 7zip will compress it even further. Probably less hassle than trying to get ArcGIS 9.3 to read a SQLite database.
    – Rayner
    Sep 11 '12 at 11:38
  • so basically that's a "no arcgis 9.3 can not read sqlite data"?
    – nickves
    Sep 11 '12 at 11:59
  • S-FTP and zipping the files with a higher compression (winzip has this option) would be a solution - best of the ftp free bunch is filezilla filezilla-project.org
    – Mapperz
    Sep 11 '12 at 13:42

My understanding is that to do this using ArcGIS Desktop 9.3 (or 10.0 or 10.1) the simplest, but expensive, option would be to use the Data Interoperability extension.

However, using ArcGIS Desktop 10.2 (or later) with no extensions ...

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

You connect directly to the SQLite database file from your ArcGIS client.

To store and work with spatial data, you must have either the Esri ST_Geometry type or SpatiaLite installed in your database. You can use the CreateSQLiteDatabase ArcPy function to create an SQLite database with either of these spatial data types.


You can install the Open Source ArcGIS OGR Workspace plugin from AmigoCloud that will give ArcMap read access to spatialite and a whole bunch of other formats. It is free. Let me know if you want to test the binaries - I already have some people doing that with success. They only work with 10.1 at the moment since that is the only ArcGIS version I have access to. It should compile fine on 9.3 though.

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.