[Qgis-user] Spatialite data portability

[David Fawcett]

I second Andreas.  The Spatialite list is great.

You could also use the spatialite-gui:
https://www.gaia-gis.it/fossil/spatialite_gui/index

David.

On Thu, Mar 15, 2012 at 7:16 AM, Andreas Neumann <a.neumann at carto.net> wrote:
> Hi Walter,
>
> Unfortunately I can't help. But I suggest that you ask the SpatiaLite cracks
> at their mailinglist:
> http://groups.google.com/group/spatialite-users
>
> I am pretty sure they can help you better than we here.
>
> Good luck!
>
> Andreas
>
>
> On Thu, 15 Mar 2012 12:09:57 +0000, Walter Ludwick wrote:
>>
>> Following the consensus opinion of all those who kindly answered my
>> inquiry (Re: QGIS Farm Application), i have installed Spatialite and
>> managed to export all the data from a layer to a .SQLITE file, and
>> then view it from several different SQLite browsers, which confirms
>> integrity of data & database structure. This already is a constructive
>> step forward (thanks to all those who helped, too numerous already to
>> mention :).
>>
>> Moreover, i have managed to create a database in LibreOffice based
>> upon that .sqlite file (after (re)learning more than i really wanted
>> to know about ODBC drivers!), which displays all the data as it
>> should. This is another good step forward, because -tho the business
>> of my farm is predicated on geo-located resources (e.g. a paddock on
>> the ground) having certain attributes that are best defined in QGIS
>> (e.g. perimeter, area, etc.)- i will still be working with that data
>> in spreadsheets on a much more dynamic basis.
>>
>> However: When i try to edit those .sqlite files from QGIS in another
>> tool, i'm running into an error message that varies slightly,
>> depending on the editor i use (anything but OO at this point: ODBC is
>> too much pain, until i get these other mechanics worked out), but the
>> message is essentially this (from SQLiteStudio):
>>      "Error while updating cell value; no such function: RTreeAlign".
>>
>> Presuming that what i am trying to do is in fact possible*;  then i
>> am left scratching my head as to why all these SQL tools are having
>> this trouble, and where that problematic function is coming from. Does
>> that error message suggest anything to you?
>>
>> * (Of course, if what i am trying to do with such round-trip editing
>> is in fact not possible, i would sure appreciate if someone could let
>> me know :)
>>
>> /wl
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
> --
> --
> Andreas Neumann
> Böschacherstrasse 10A
> 8624 Grüt (Gossau ZH)
> Switzerland
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user