Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 23 down vote favorite
10

SpatiaLite is playing an increasing role in my organization. As it stands now, using SpatiaLite alongside ArcGIS Desktop requires an amount of importing and exporting of data that isn't always trivial. Outside of products such as the Data Interoperability Extension or FME, what other options, if any, are there for SpatiaLite support in ArcGIS Desktop?

share|improve this question

6 Answers

up vote 1 down vote

I don't know of any as of yet but I bet you could approach the ZigGIS folks for support. I know ZIG only does PostGIS now but both databases have the same functionality.

Once ESRI finally gets rid of SDE/ArcGIS Server database and supports direct connections to ST_ compliant databases then there will be much rejoicing!

share|improve this answer
Don't hold your breath on that one :) – gsherman Aug 6 '10 at 14:25
ZigGIS did come to mind when I was thinking about the question. I'm sure those guys wouldn't mind my pestering. :-) – Roger D. Aug 6 '10 at 16:59
up vote 1 down vote

On Google Code, I found that Umbriel ArcGIS Desktop Tools have a project called Umbriel.ArcGIS.Spatialite but I haven't found any documentation on it yet.

share|improve this answer
up vote 1 down vote

I wouldn't use anything out of Umbriel.ArcGIS.Spatialite--I was just messing about. No warranties there...I was just trying things out.

I did work up a ZigGIS-based project to access Spatialite (not on google code). It's really rough and I didn't have additional time work with it. MP4 Video: http://drop.io/htz3c7w

It was written against ziggis source code that isn't open source (according to the code files I was working with). The ZigGIS 3.0 provider model will make it a lot easier to use spatialite as a data provider to ArcGIS, but they weren't interested in weaving what I wrote into the current version (a decision I agree with).

If they are cool with me releasing what I wrote, I'll make it available.

share|improve this answer
1  
ZigGIS 3.0 Roadmap: goo.gl/Uzwj – Jay Cummins Aug 6 '10 at 13:08
Nice find, Jay! – Roger D. Aug 6 '10 at 17:07
Jay, please do. Our source is open, actually, but the license only grants personal use. If you wanted to customize the source and use it in your enterprise, then you'd have to purchase licenses. More info here: pub.obtusesoft.com/source.aspx – xanadont Aug 7 '10 at 23:44
2  
FYI a license which restricts certain persons, groups, or fields of endeavour (e.g not for military or commercial use) is not open source, as defined by the Open Source Definition, points 5&6. @xanadont from your phrasing I think you know this, but people following the thread might not. @Jay if you put your mods on Google Code under the ziggis license you will be transgressing their terms of service, and if you put it up under your Umbriel's GPL3 you'll be crossing Zig. So you need a different host. – matt wilkie♦ Aug 8 '10 at 7:22
yes, i never intended to release it under Umbriel. In fact, I never intended to release it at all...I intended to give what I wrote to Obtuse/ZigGIS and let them decide what to do with it! And that's when they told me about the provider model for the open source ZigGIS @ version 3. – Jay Cummins Aug 8 '10 at 10:57
up vote 1 down vote

This really isn't an answer, but I imagine it would be interesting to some folks. As has been pointed out in the comments we'll be extending zigGIS's reach by having a generic "provider" model so that other datasources such as MS SQL Server, Oracle, and, yes, Spatialite can be easily plugged in. For Spatialite support we hope to work closely with Jay. We're hoping to break ground on zigGIS 3.0 by summer's end.

share|improve this answer
up vote 9 down vote

I started an open source GDAL/OGR ArcGIS plugin project this weekend that gives read support to spatialite and any other OGR vector data source like Google Fusion Tables.

I have it working locally reading spatialite and will cleanup and push the rest of changes this coming Friday. I hope you find it useful.

Update 1:

OK, got it working today. The following is a spatialite file being read from ArcGIS 10.1 natively.

Add data dialog spatialite read from ArcGIS

Since it uses GDAL/OGR, it doesn't just read spatialite but it also adds support to a gazzilion other formats.

For example, this screenshot is a mix of reading S57 ENC files with spatialite:

S57 and spatialite being read

If you want to test the binaries, that would be helpful, so I can add them for anyone else.

share|improve this answer
OK, I finished it and it works. Updating answer – Ragi Yaser Burhum Sep 18 '12 at 0:10
up vote 1 down vote
  1. FME can't read SpatiaLite outside of some FDO hoops.
  2. This should be a wakeup call as to why you don't want your organization using niche data formats, no matter how well thought out or open they are.
  3. Down-vote my hatred of SpatiaLite.
share|improve this answer
FME 2013 contains a non-FDO SpatialLite reader/writer. downloads.safe.com/fme/beta/whatsnew.txt – Raven Sep 11 '12 at 22:26
1  
well @James, as much as you hate spatialite, now you can read to it in ArcGIS without any hoops. – Ragi Yaser Burhum Sep 18 '12 at 1:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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