[Qgis-user] columns in spatialite

[aperi2007]

I understand that the real spatialite format is not really knowed.

The test you report is a read only test on the spatialite-gui.
But the spatialite-gui is a all-version readable software.
This mean that it is capable to read and understand EVERY VERSION of the 
spatialite format.
Also the oldest one.

For the write test the report has used the QGIS 1.9.0 that is an old 
version
using the old driver spatialite 2.x

This mean that the arcgis is capable to read/write only the spatialite 
versione 2.x ? version.

Whoa ! This mean it is a very old format of spatialite.

After the format spatialite 2.x
there was the
spatialite 3.1 and the
spatialite 4.0 format.
And at now the spatialite 4.1, 4.2 and 4.3

But at binary level the major difference isbetween

the spatialite 2.x, 3.x and 4.0

You should ask to the ML spatialite to have more details.

A.



Il 12/11/2015 18:01, Alex M ha scritto:
> Sure you can clarify there.
>
> I have tested spatialite in ArcGIS 10.2+
>
> http://blog.geomusings.com/2013/08/07/spatialite-and-arcgis-10-dot-2/
> http://www.northrivergeographic.com/archives/spatialite-arcgis-qgis
>
> Enjoy,
> Alex
>
> On 11/12/2015 08:57 AM, Andrea Peri wrote:
>> As the better ML for ask for any differnce between the spatialite and
>> geopackage is the ML Spatialite.
>> Also for ask if the Arcgis is really capable to read a true spatialite
>> or instead is reading someone surely is not the QGIS ML,
>> perhaps the Spatialite ML could know something, but perhaps no.
>>
>> A.
>>
>>
>> 2015-11-12 17:54 GMT+01:00 Alex M <tech_dev at wildintellect.com>:
>>> On 11/12/2015 04:12 AM, Micha Silver wrote:
>>>> On 12/11/2015 14:10, Paulo van Breugel wrote:
>>>>>
>>>>> On Thu, Nov 12, 2015 at 1:05 PM, Bernd Vogelgesang
>>>>> <<mailto:bernd.vogelgesang at gmx.de>bernd.vogelgesang at gmx.de> wrote:
>>>>>
>>>>>      Am 12.11.2015, 08:01 Uhr, schrieb Paolo Cavallini
>>>>>      <<mailto:cavallini at faunalia.it>cavallini at faunalia.it>:
>>>>>
>>>>>          Il 12/11/2015 00:31, Bernd Vogelgesang ha scritto:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>      I repeatedly ask for this, and do not receive much positive echo. What are
>>>>>      the reasons for people to prefer ESRI shapes over sqlite files? Are they
>>>>>      not aware of the benefits or do I just miss sth completely obvious that is
>>>>>      an argument against sqlite?
>>>>>
>>>> Well there's still the problem of exchanging data with users of the other
>>>> proprietary GIS software. Spatialite is still, unfortunately, not that popular.
>>> FYI, ArcGIS as of 10.2 can read Spatialite files. Even more recent
>>> ArcGIS can read GeoPackage.
>>>
>>> -Alex
>>> _______________________________________________
>>> Qgis-user mailing list
>>> Qgis-user at lists.osgeo.org
>>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>