Re: [Qgis-user] spatialite with update trigger seems to result in 'unselectable' geometry

Hi Claas, Indeed that worked Thank you so much. Any idea if it's already in the documentation somewhere (in which case I clearly didn't read the manual...)? Otherwise I'll include that on my to do list. Again, thanks, Janneke On 08/02/2019 00:47, Claas Leiner wrote: Hi Janneke in a

Re: [Qgis-user] spatialite with update trigger seems to result in 'unselectable' geometry

Hi Janneke in a similar problem, it helped to update the spatial index: - CREATE TRIGGER update_geom AFTER UPDATE ON watersources BEGIN UPDATE watersources SET geom = Transform(MakePoint(east, north, 4326), 32638) WHERE id=1678; -- I have done this in my trigger Select

[Qgis-user] spatialite with update trigger seems to result in 'unselectable' geometry

Dear list, Could anybody maybe help me understand what I'm doing wrong (or even tell me that what I want to do can't be done)? This is what I'm trying to do. I have a spatialite layer with columns north and east which contain coordinates in decimal degrees. I would like to be able to change

Re: [Qgis-user] spatialite layer does not show

Thanks for the reply, Jay M Johnson advised me this link: https://gis.stackexchange.com/questions/131996/shapefile-layers-in-qgis-dont-display-unless-i-zoom-out Meanwhile I solved the problem by saving the features in a postgresql layer. Regards, -- Sent from:

Re: [Qgis-user] spatialite layer does not show

Hi Reginald, Sometimes a invalid spatialIndex is a reason, that spatialite layer does not shown. Open the DB-manager in QGIS Klick of your database in the tree and and then open the SQL-Windows (press F2). execute this statement in the SQL-Windows of the DB-Manager: select

Re: [Qgis-user] spatialite layer does not show

Update, In the logmessages I found this message: 2018-12-19T13:34:13 WARNINGKon geen stijlen laden uit F:/QGIS/dev/notarisattest/inlichtingen.sqlite (Query: SELECT styleQML FROM layer_styles WHERE f_table_schema IS NULL AND f_table_name='uittreksels' AND f_geometry_column ='geom' ORDER

[Qgis-user] spatialite layer does not show

Hi qgis users, I have a model in which i use a parcellayer. From this parcellayer I get the selected features. In order to obtain one geometry I convert from singlepart to multipart geometry. In order to query the layers that overlay this parcels I make a buffer of -0.3m. The last step the model

[Qgis-user] spatialite disconnection and problem to quit qgis

Hello, I'm using QGIS 3.4.2 with Windows 10. I've a project with WMS layers, spatialite layers and shapefiles. I've two problems: 1) Spatialite sometimes results disconnected and I cant'save the layers I'm editing 2) When I try to close the project, I recive a message about activities in

[Qgis-user] SpatiaLite nvarchar fields not visible in QGIS

OS: Win10 QGIS: 2.18.13 I have a polygon table in a SpatiaLite db that has three fields defined as nvarchar. These are visible in QspatiaLite (plugin) and in the spatialite_gui (application), but are absent when the attribute table of the layer is viewed in QGIS and are not present under the

[Qgis-user] SpatiaLite - sqlite database delete

Hi all, Very quick one. How do I delete a Spatialite sqlite database? Cannot see an obvious way in DB manager. If I delete the .sqlite file in Windows explorer, it still shows up in the list. Did read that these databases could be deleted via the QGIS browser, but did not see any way there

[Qgis-user] SpatiaLite data rendered slowly

Hi I have polygon data in a shapefile that is rendered instantly on the screen when I zoom and pan. Now I want to use the more advanced capabilities of SpatiaLite and I have loaded the data into a SpatiaLite database. Rendering the SpatiaLite data on the screen is much slower. The polygons appear

Re: [Qgis-user] SpatiaLite data rendered slowly

One observation regarding this problem: Both the shapefile and SpatiaLite database are on a NAS box. If I move the SpatiaLite file to a local drive, it renders instantly like the shapefile. So the question is: What is it about being stored on a NAS box that throttles down the speed of SpatiaLite

Re: [Qgis-user] SpatiaLite data rendered slowly

On Mon, Sep 14, 2015 at 7:55 AM, Árni Geirsson wrote: > One observation regarding this problem: Both the shapefile and SpatiaLite > database are on a NAS box. If I move the SpatiaLite file to a local drive, > it renders instantly like the shapefile. So the question is: What is it >

Re: [Qgis-user] Spatialite queries return text instead of numeric values

2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com: Hello, When querying a spatialite database in the database manager, if you create some calculations (say add two columns values) the resulting column returns as TEXT instead of the expected numeric field. Is this intended or a

Re: [Qgis-user] Spatialite queries return text instead of numeric values

On 12/10/2014 09:55 AM, Goyo wrote: 2014-12-10 1:50 GMT+01:00 Alexandre Neto senhor.n...@gmail.com: Hello, When querying a spatialite database in the database manager, if you create some calculations (say add two columns values) the resulting column returns as TEXT instead of the expected

Re: [Qgis-user] Spatialite queries return text instead of numeric values

Hello all, To make some tests I have the folllowing table: General info Relation type: Table Rows: 3 SpatiaLite Column: geometry Geometry: MULTIPOLYGON Dimension: XY Spatial ref: WGS 84 (4326) Extent: (unknown) (find out action:extent/get) Fields # Name Type Null

Re: [Qgis-user] Spatialite queries return text instead of numeric values

What happens if you CREATE VIEW with those tests? Does QGIS read the VIEW differently? Thanks, Alex On 12/10/2014 10:57 AM, Alexandre Neto wrote: Hello all, To make some tests I have the folllowing table: General info Relation type: Table Rows: 3 SpatiaLite

[Qgis-user] Spatialite queries return text instead of numeric values

Hello, When querying a spatialite database in the database manager, if you create some calculations (say add two columns values) the resulting column returns as TEXT instead of the expected numeric field. Is this intended or a bug? Trying to cast it as real, double or float did not work either.

[Qgis-user] Spatialite-Layer with Z-coordinate

Hello! I'm using QGIS 2.4.0. Is it possible to create a Spatialite layer with Z-coordinate, for example a point layer with x, y and z value? According to Spatialite documentation this 2.5D-Layer seems to be supported, but I found no possibilities to create such geometry layer type in QGIS.

Re: [Qgis-user] Spatialite VIEW in QGIS question

Dear folks, thanks a lot for all who tried to help. I have a working solution now, which I will hopefuly be able to forge into some script, so all steps for many layers will run more automatic. I maybe had other working solutions before, but I made the mistake and didn't see that I had

Re: [Qgis-user] Spatialite VIEW in QGIS question

Bernd - I think, that you have misunderstood some of the basic tenets of relational database technology: * If you establish a straight 1:n relationships in a relational database (as SQLite, SpatiaLite or Postgres/PostGis) you'll get at least n rows in the resulting view; if you want it

Re: [Qgis-user] Spatialite VIEW in QGIS question

Am 21.02.2014, 22:17 Uhr, schrieb Bo Victor Thomsen bo.victor.thom...@gmail.com: Bernd - I think, that you have misunderstood some of the basic tenets of relational database technology: If you establish a straight 1:n relationships in a relational

Re: [Qgis-user] Spatialite VIEW in QGIS question

Am 19.02.2014 20:06, schrieb Alex Mandel: On 02/19/2014 10:43 AM, Bernd Vogelgesang wrote: Am 19.02.2014 16:55, schrieb Alex Mandel: On 02/18/2014 12:29 PM, Bernd Vogelgesang wrote: Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not

Re: [Qgis-user] Spatialite VIEW in QGIS question

Am 19.02.2014 20:02, schrieb Olivier Dalang: Dear Bernd, I encountered some similar problems with Spatialite views, but in the end I had it working (sometimes) both in 2.0 and in master... I used the manual method from the spatialite cookbook though (not the Spatialite GUI). I have no time

Re: [Qgis-user] Spatialite VIEW in QGIS question

Bernd, Here's a procedure which works here on QGIS master : 1. Create a spatialite layer countries with fields name and a geometry column geom of type polygon. 2. Add some features to that layer. 3. In the DB manager, create the view: CREATE VIEW countries_influence AS SELECT rowid as rowid,

Re: [Qgis-user] Spatialite VIEW in QGIS question

Am 20.02.2014 18:13, schrieb Olivier Dalang: Bernd, Here's a procedure which works here on QGIS master : 1. Create a spatialite layer countries with fields name and a geometry column geom of type polygon. 2. Add some features to that layer. 3. In the DB manager, create the view: CREATE

Re: [Qgis-user] Spatialite VIEW in QGIS question

Try this - CREATE VIEW Testview23 AS SELECT a.PK_UID*1 + b.PK_UID AS NEWID, a.ROWID AS ROWID, a.Geometry AS Geometry, b.ora_nachweis_id AS ora_nachweis_id, b.zahl AS zahl, b.jahr AS jahr, b.art AS art, b.sta AS sta FROM ASK_VOEGEL AS a JOIN ask_art AS b USING (id) Afterwards you can do

Re: [Qgis-user] Spatialite VIEW in QGIS question

Hi Olivier, thank you for trying to help, but, ermm, actually I do not see the point performing this. I have not really a problem creating views, but more making these functional in QGIS. Your example, as far as i understand, lacks a join-part completely, but thats the culprit I fear. OK

Re: [Qgis-user] Spatialite VIEW in QGIS question

Hello Bernd, In QGis 1.8 and 1.7, perhaps this will help (exporting *shp* to *csv* with *wkt *geometry, also your observation entries to *csv*, and linking both*; *not very productive, I suppose) http://gis.stackexchange.com/questions/10788/how-to-join-multiple-records-to-single-feature

Re: [Qgis-user] Spatialite VIEW in QGIS question

This does not directly answer your question about spatialite views, but you might be able to use relationships directly in QGIS in the near future (I think this is a 2.1 update). See: http://blog.vitu.ch/10112013-1201/qgis-relations -Steve -- View this message in context:

Re: [Qgis-user] Spatialite VIEW in QGIS question

Am 19.02.2014 16:55, schrieb Alex Mandel: On 02/18/2014 12:29 PM, Bernd Vogelgesang wrote: Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in my spatialite database and a normal table with bird

Re: [Qgis-user] Spatialite VIEW in QGIS question

Am 19.02.2014 19:14, schrieb Steve G: This does not directly answer your question about spatialite views, but you might be able to use relationships directly in QGIS in the near future (I think this is a 2.1 update). See: http://blog.vitu.ch/10112013-1201/qgis-relations -Steve Hi Steve,

Re: [Qgis-user] Spatialite VIEW in QGIS question

Dear Bernd, I encountered some similar problems with Spatialite views, but in the end I had it working (sometimes) both in 2.0 and in master... I used the manual method from the spatialite cookbook though (not the Spatialite GUI). I have no time to test now, but from what I recall, this does not

Re: [Qgis-user] Spatialite VIEW in QGIS question

On 02/19/2014 10:43 AM, Bernd Vogelgesang wrote: Am 19.02.2014 16:55, schrieb Alex Mandel: On 02/18/2014 12:29 PM, Bernd Vogelgesang wrote: Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in

Re: [Qgis-user] Spatialite VIEW in QGIS question

Maybe I'm unclear on the issue. If it's just how to get a view with geometry to show up, I've found you often have register view with spatialite metadata: INSERT INTO views_geometry_columns (view_name, view_geometry, view_rowid, f_table_name, f_geometry_column) VALUES (theview, thegeometry,

Re: [Qgis-user] Spatialite VIEW in QGIS question

Bernd Vogelgesang bernd.vogelgesang@... writes: Guys, this is a very sad topic and I really can't understand how people can work with 1:n data even on the most basic level under these circumstances ... Or doesn't anyone work with 1:n data? Well, the the world I'm living in is full of that

[Qgis-user] Spatialite VIEW in QGIS question

Hi folks, I'm quite desperate, cause I do not seem to understand what I'm doing wrong, or if it's just not possible to do. I have a polygon layer in my spatialite database and a normal table with bird observations. There are many observation entries for each item in the polygons. They

Re: [Qgis-user] Spatialite : problems with spatial views

Notice that you have duplicate ROWID values in your view results. Spatialite (and DB manager) don't care about this since the ROWID is more a convenience. But for QGIS it's critical that this column be like a unique primary key. This is happening because

Re: [Qgis-user] Spatialite : problems with spatial views

Hello, I have a problem with the display of tables add to QGIS from spatialite. DB Manager displays the correct data, but uploading to QGIS table entries changed to false: http://i.imgur.com/Pahw13c.png http://i.imgur.com/9Y1zaq4.png When loaded data export to shapfile then show the correct

[Qgis-user] SpatiaLite views

Hi, I wanted to create a view with spatial data in SpatiaLite. I can create the view by hand in DB-Manager and I created entries in the views_geometry_columns table. But when I add the view it is always added as a non-geometry table containing only attributes but no geometry. Am I missing

Re: [Qgis-user] SpatiaLite views

2013/6/10 Andreas Neumann a.neum...@carto.net: Hi, I wanted to create a view with spatial data in SpatiaLite. I can create the view by hand in DB-Manager and I created entries in the views_geometry_columns table. But when I add the view it is always added as a non-geometry table containing

Re: [Qgis-user] SpatiaLite views

Hi, I get problems in spatialite views too. I created views in spatialitegui follow the same instructions and I can open the view in qgis but if I try to open Attribute table, in all values get ERROR (in qgis ubuntu 12.04 from http://qgis.org/debian-nightly and in osgeo4w (1.8 and 1.9-dev

Re: [Qgis-user] Spatialite - can't type fields of a view

I found that: http://sqlite.1065341.n5.nabble.com/Computed-columns-in-VIEWs-return-NULL-but-should-be-able-to-be-typed-Any-ideas-td56769.html#a56770 http://sqlite.1065341.n5.nabble.com/Computed-columns-in-VIEWs-return-NULL-but-should-be-able-to-be-typed-Any-ideas-td56769.html#a56770 Its dated

[Qgis-user] Spatialite - can't type Fields

Hi all, I have troubles with spatialite view column's type. Numeric fields, even explicitly typed with a CAST are not recognized in QGIS.. No possible graduated classification then. As anyone a hint? Here is the create view statement: All the best -- View this message in context:

[Qgis-user] Spatialite Version 4.0

Hello All: Spatialite stable is at version 4.0. [1] for some months now. Sandro Furieri has put the new QGIS data provider into QGIS trunk [2], also a while back. Any idea when windows builds of either 1.8.x or 1.9.0 will incorporate that new

Re: [Qgis-user] Spatialite Version 4.0

On 04/30/2013 07:58 AM, Micha Silver wrote: Hello All: Spatialite stable is at version 4.0. [1] for some months now. Sandro Furieri has put the new QGIS data provider into QGIS trunk [2], also a while back. Any idea when windows builds of either 1.8.xor 1.9.0 will incorporate that new data

Re: [Qgis-user] Spatialite Version 4.0

2013/4/30 Alex Mandel tech_...@wildintellect.com: Are you sure it's not already in those nightly builds? QGIS-Dev package in OSGeo4w. The problem is not the provider (which is already there) but the spatialite version QGIS is built against. It's 3.0.1 in OSGeo4W (so I think) and 3.1.0-rc2 in

Re: [Qgis-user] Spatialite Version 4.0

On 04/30/2013 10:00 AM, Goyo wrote: 2013/4/30 Alex Mandel tech_...@wildintellect.com: Are you sure it's not already in those nightly builds? QGIS-Dev package in OSGeo4w. The problem is not the provider (which is already there) but the spatialite version QGIS is built against. It's 3.0.1 in

Re: [Qgis-user] Spatialite Version 4.0

On 4/30/2013 8:11 PM, Alex Mandel wrote: On 04/30/2013 10:00 AM, Goyo wrote: 2013/4/30 Alex Mandel tech_...@wildintellect.com: Are you sure it's not already in those nightly builds? QGIS-Dev

[Qgis-user] Spatialite : problems with spatial views

Hello all, When I load a valid spatial view from Qspatialite in QGis, I have some problems : 1. If the spatialite table on which depend the spatial view have a spatial index, the features are not visible on Qgis after loading. To fix this problem, I have to remove the spatial index before.

Re: [Qgis-user] Spatialite : problems with spatial views

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 22/02/2013 10:55, Samy Mezani ha scritto: Hello all, When I load a valid spatial view from Qspatialite in QGis, I have some problems : have you tried with DB Manager? all the best. - -- Paolo Cavallini - Faunalia www.faunalia.eu Full

Re: [Qgis-user] Spatialite : problems with spatial views

le 22/02/2013 11:32, Paolo Cavallini a écrit: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 22/02/2013 10:55, Samy Mezani ha scritto: Hello all, When I load a valid spatial view from Qspatialite in QGis, I have some problems : have you tried with DB Manager? Yes, but the geometry is

Re: [Qgis-user] Spatialite : problems with spatial views

I had the same problem as you, all attributes showed ERROR in the attribute table. I asked here: http://gis.stackexchange.com/questions/32592/how-to-open-a-spatialite-non-spatial-view-in-qgis And was directed to the following page on Spatialite

Re: [Qgis-user] Spatialite : problems with spatial views

le 22/02/2013 11:57, Alexandre Neto a écrit: There, I found out that, for correctly open a spatialite spatial view in QGIS, I would need to have a column named ROWID. Thanks Alexandre, My problems are partially resolved with your workaround : 1. The spatial index still blocks the load of

Re: [Qgis-user] Spatialite : problems with spatial views

On Fri, Feb 22, 2013 at 12:07 PM, Samy Mezani samy.mez...@wanadoo.frwrote: le 22/02/2013 11:57, Alexandre Neto a écrit: There, I found out that, for correctly open a spatialite spatial view in QGIS, I would need to have a column named ROWID. Thanks Alexandre, My problems are partially

Re: [Qgis-user] Spatialite : problems with spatial views

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 22/02/2013 13:07, Samy Mezani ha scritto: So Qspatialite should integrate a creation of a rowid to load correctly a spatial view in Qgis. DB Manager continue to not load the geometry even if a rowid is created. what happens exactly? all the

Re: [Qgis-user] Spatialite : problems with spatial views

le 22/02/2013 13:19, Alexandre Neto a écrit: On Fri, Feb 22, 2013 at 12:07 PM, Samy Mezani samy.mez...@wanadoo.fr mailto:samy.mez...@wanadoo.fr wrote: 2. After adding a rowid, the attributes window show all the values of features but I have to wait 70s for 44 features and CPU used

Re: [Qgis-user] Spatialite : problems with spatial views

le 22/02/2013 13:21, Paolo Cavallini a écrit: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Il 22/02/2013 13:07, Samy Mezani ha scritto: So Qspatialite should integrate a creation of a rowid to load correctly a spatial view in Qgis. DB Manager continue to not load the geometry even if a

[Qgis-user] SpatiaLite creation problem

Hello everybody, I'm using the new 1.8 version and maybe I'm missing something, but I was not able to create a new spatialite archive with spatial tables in it. I'm able to create the database file using Qspatialite plugin, but i wan not able to create e new table with the plugin. After creating

Re: [Qgis-user] SpatiaLite creation problem

On 27/06/2012 16:59, Julian Bogdani wrote: Hello everybody, I'm using the new 1.8 version and maybe I'm missing something, but I was not able to create a new spatialite archive with spatial tables in it. I'm able to create the database file

[Qgis-user] Spatialite data portability

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

Re: [Qgis-user] Spatialite data portability

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 +, Walter Ludwick wrote:

Re: [Qgis-user] Spatialite data portability

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.neum...@carto.net wrote: Hi Walter, Unfortunately I can't help. But I suggest that you ask the

Re: [Qgis-user] Spatialite data portability

Error while updating cell value; no such function: RTreeAlign. Sounds like the other SQLite apps you are using can't find the spatial (rtree) libraries. So, effectively, you are trying to open a db with a different version of SQLite. I'll be curious to know your solution to the

Re: [Qgis-user] Spatialite data portability

Most of SQLite editors, if not could not read the spatial aspect of the spatailite database file. Use spatialite-gui, spatialite CLI, and QGIS spatialite plugins, if you want to manage the spatial aspect of your spatialite database. Noli On 3/16/12, Tyler Mitchell i...@locatepress.com wrote:

Re: [Qgis-user] Spatialite data portability

Most of SQLite editors, if not all could not read... Noli On 3/16/12, Noli Sicad nsi...@gmail.com wrote: Most of SQLite editors, if not could not read the spatial aspect of the spatailite database file. Use spatialite-gui, spatialite CLI, and QGIS spatialite plugins, if you want to manage

[Qgis-user] Spatialite queries

Just wondering if there is a utility that allows one to select a shape through a GUI and display it / zoom to it. What I am working on is a set of shapes that represent areas where individuals work and I need to be able to go to any given area and find info on and display that area. I have been

[Qgis-user] spatialite (and postgis) queries

Hi list Some questions on building querys with spatialite and postgis: 1 - Is it possible to build a query where two (or more) layers are involved? Something like: SELECT a.* FROM a, b WHERE Contains(b, a) and get a visual result in the main Qgis display? I know I can do such a query using the

Re: [Qgis-user] spatialite (and postgis) queries

Have a look at this: http://www.carsonfarmer.com/?p=713 and the RT Sql Layer plugin Carson On 30 September 2010 13:15, Ricardo Filipe Soares Garcia da ricardo.garcia.si...@gmail.com wrote: Hi list Some questions on building querys with spatialite and postgis: 1 - Is it possible to build a

Re: [Qgis-user] spatialite (and postgis) queries

Hi Ricardo, On Thu, Sep 30, 2010 at 2:15 PM, Ricardo Filipe Soares Garcia da ricardo.garcia.si...@gmail.com wrote: Some questions on building querys with spatialite and postgis: You can use the RT Sql Layer plugin, but for postgis layers only. In this moment there is no way to do the same

Re: [Qgis-user] spatialite (and postgis) queries

Hi Carson, On Thu, 30. Sep 2010 at 13:18:46 +0100, Carson Farmer wrote: http://www.carsonfarmer.com/?p=713 and the RT Sql Layer plugin 1 - Is it possible to build a query where two (or more) layers are involved? Something like: SELECT a.* FROM a, b WHERE Contains(b, a) and that

Re: [Qgis-user] spatialite (and postgis) queries

Hi all Thanks for your positive (and fast!) replies. I'll be giving the RT Sql layer plugin a try and I'll also investigate whether this functionality is available (using python scripting) with spatialite layers. Jurgen: thanks for the SQL EXISTS tip. I have to brush up on my SQL ;) Still I

Re: [Qgis-user] spatialite (and postgis) queries

If your query is very common, you might want to consider making a database VIEW, so you can add the dynamic layer whenever you want. To do this, just tailor your SELECT statement so it shows the right columns, including geometry and a unique integer column (this can be tricky). For PostGIS, I'd

Re: [Qgis-user] spatialite and ftools

Hi Carson, sorry for the lack of information. I use QGIS 1.3.0 on ubuntu 9.10, with spatialite 1.3.0. I want to retrieve the intersections between the Highways layer (lines) and the Regions layer (polygons), but the intersection ftools tool doesn't complaint and gives an empty result layer.

[Qgis-user] spatialite and ftools

Hi all, Can't apply some vectors operations via the ftools toolbox (intersect, convex hull, ...) on layers imported from a spatialite db (the test-2.3.sqlite available at http://www.gaia-gis.it/spatialite/resources.html). Is it normal? thanks -- Lionel Roubeyrie - lroubey...@limair.asso.fr

Re: [Qgis-user] spatialite and ftools

Hi Lionel, Hi all, Can't apply some vectors operations via the ftools toolbox (intersect, convex hull, ...) on layers imported from a spatialite db (the test-2.3.sqlite available at http://www.gaia-gis.it/spatialite/resources.html). Is it normal? Shouldn't be ;-) Could you please supply an

Re: [Qgis-user] spatialite]

Thanks for the reply Paolo, but after investigation, it seems spatialite has problems with accentuated attributes names. Changing them to normal names and qgis can correctly import the layer. Strange that spatialite-gui doesn't take care of the encoding for the names, just for the values. Paolo

Re: [Qgis-user] spatialite]

Lionel Roubeyrie ha scritto: but after investigation, it seems spatialite has problems with accentuated attributes names. Changing them to normal names and qgis can correctly import the layer. Strange that spatialite-gui doesn't take care of the encoding for the names, just for the values.

Re: [Qgis-user] spatialite]

The original datas are in a ISO-8859-15 encoded shapefile. In the spatialite-gui after import, columns containing accentuated characters are replaced by with no datas. Paolo Cavallini a écrit : Lionel Roubeyrie ha scritto: but after investigation, it seems spatialite has problems with

[Qgis-user] spatialite

Hi all, can't correctly import a simple polygon table from a spatialite db, all attributes are equal to ERROR. The polygons are displayed after the import, but a zoom/unzoom and they disapear :( The table is ok in the spatialite-gui and correctly displayed in the spatialite-gis. Is there a

Re: [Qgis-user] spatialite

Lionel Roubeyrie ha scritto: Hi all, can't correctly import a simple polygon table from a spatialite db, all attributes are equal to ERROR. The polygons are displayed after the try upgrading to current trunk, a bug has been fixed recently -- Paolo Cavallini: http://www.faunalia.it/pc