[Qgis-user] Problem loading a FME generated SpatiaLite file

[Jonathan Moules]

Further to this, for anyone who is curious, there's a solution on the
SpatiaLite list now (they're very on the ball!):

https://groups.google.com/forum/?fromgroups#!topic/spatialite-users/Q6qEhnT3ynQ

As noted, apparently QGIS doesn't like the generic GEOMETRY.

Jonathan



On 10 September 2012 09:46, Micha Silver <micha at arava.co.il> wrote:

>  On 10/09/2012 10:45, Jonathan Moules wrote:
>
> Hi Micha,
> Looking in the geometry_columns table, the all six rows have the same
> values for the columns: "f_geometry_column" and "type". That value being
> "GEOMETRY"; in actuality, five of them are line and the sixth is a
> polygon. I'd guess this is a FME problem then.
>
>
>
> Yes, Note Jukka's post on the spatialite-users list.
>
>   Per Andreas's suggestion, I'll report it to the Spatialite list.
>
> Jonathan
>
>
>
>  On 7 September 2012 14:09, Micha Silver <micha at arava.co.il> wrote:
>
>>   On 09/07/2012 03:58 PM, Jonathan Moules wrote:
>>
>> Hi,
>> I've got a SpatiaLite file that was generated with FME 2013. Its beta,
>> and the writer is new, so maybe it has problems and that's where this
>> problem is caused.
>>
>> Anyway, when i try and "add" one of the tables, QGIS gives an error:
>> *dbname='//wcc-corp.ad/BuData/MSSystems/Cad/GIS_DATA/ZZ Temporary GIS
>> Data & Map Storage/jm - alternate
>> mastermaps/conwy_spatialite_uncompressed.sl3' table="os_mm_boundaryline"
>> (GEOMETRY) sql= is an invalid layer - not loaded *
>>
>> However, it opens fine in SQLiteStudio (though being spatial data, I
>> can't actually .
>>
>> If I double click on one of the tables in the "add spatiaLite table(s)"
>> page, nothing happens but an error appears in the log:
>> *SQLite error: unknown cause
>> SQL: SELECT type, srid, spatial_index_enabled, coord_dimension FROM
>> geometry_columns WHERE f_table_name='os_mm_boundaryline' and
>> f_geometry_column='GEOMETRY'*
>>
>> But that SQL query runs fine in SQLiteStudio and returns:
>> *GEOMETRY, 27700, 1, XY*
>>
>>
>>
>> I'm not sure what's going on either, but that query should return a
>> geometry *type* for the first column as:
>> POINT, 27700,1,XY
>> or LINESTRING, POLYGON etc
>>
>>
>>
>>    The file looks fine and the query works in SQLiteStudio, so I'm more
>> inclined to suspect its a QGIS issue than a FME one, but that's just a
>> barely-educated guess.
>> This exact same data worked fine as a SQLite export from FME.
>>
>> Any thoughts what's going on?
>>
>> Jonathan
>>
>>
>> This transmission is intended for the named addressee(s) only and may
>> contain sensitive or protectively marked material up to RESTRICTED and
>> should be handled accordingly. Unless you are the named addressee (or
>> authorised to receive it for the addressee) you may not copy or use it, or
>> disclose it to anyone else. If you have received this transmission in error
>> please notify the sender immediately. All email traffic sent to or from us,
>> including without limitation all GCSX traffic, may be subject to recording
>> and/or monitoring in accordance with relevant legislation.
>>
>> This mail was received via Mail-SeCure System.
>>
>>
>> _______________________________________________
>> Qgis-user mailing listQgis-user at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>>
>> This mail was received via Mail-SeCure System.
>>
>>
>>
>>
>>
>> --
>> Micha Silver
>> GIS Consultant, Arava Development Co.http://www.surfaces.co.il
>>
>>
>
>
> This transmission is intended for the named addressee(s) only and may
> contain sensitive or protectively marked material up to RESTRICTED and
> should be handled accordingly. Unless you are the named addressee (or
> authorised to receive it for the addressee) you may not copy or use it, or
> disclose it to anyone else. If you have received this transmission in error
> please notify the sender immediately. All email traffic sent to or from us,
> including without limitation all GCSX traffic, may be subject to recording
> and/or monitoring in accordance with relevant legislation.
>
> This mail was received via Mail-SeCure System.
>
>
>
> --
> Micha Silver
> 052-3665918
>
>


This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us,  including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120910/e54491e3/attachment.html>