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

[pcav]

Salve.
Ho seguito la discussione un po' al volo, ma mi pare che questa nota aiuti a capire
(se no, scusatemi).
Saluti.


-------- Messaggio originale --------
Oggetto: Re: [Qgis-user] Spatialite : problems with spatial views
Data: Wed, 05 Feb 2014 12:26:55 +0200
Mittente: Micha Silver <[hidden email]>
A: giedrius <[hidden email]>, [hidden email]



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 you have GROUP BY with two columns in your query. I think
that what will resolve this is creating a new integer column with unique values for
each Fortas-rusis pair.

If you could try this: add to both the siksnosparniai_rusis table and the
siksnosparniai_patalpa tables  additional integer columns with unique values for each
Fortas and unique values for each rusis. Then in your view, combine these two
integers in some way to get a new *unique* value to be used as the ROWID. That should
work out the duplicate error values in QGIS.

Good luck,
Micha




On 05/02/2014 09:25, giedrius wrote:

> 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 data:
> http://i.imgur.com/ZeXk6Xz.png
>
> Is this a bug? Is it my fault as a user?
>
> I work with Debian
>
> VAM_test_s.sqlite
> <http://osgeo-org.1560.x6.nabble.com/file/n5101983/VAM_test_s.sqlite>  

--
Micha Silver
GIS Consulting
052-3665918
http://www.surfaces.co.il



_______________________________________________
[hidden email]
http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss
Questa e' una lista di discussione pubblica aperta a tutti.
I messaggi di questa lista non hanno relazione diretta con le posizioni dell'Associazione GFOSS.it.
666 iscritti al 22.7.2013

[Andrea Peri]

Sicuramente.
Con i DB occorre fare attenzione alla replicazione degli id. È un mantra da ripetere,

Mai provocare la duplicazipne degli id nelle viste.
..
Mai provocare la duplicazione degli id nelle viste .
..
Mai .....

A.

Il 05/feb/2014 11:40 "Paolo Cavallini" <[hidden email]> ha scritto:

Salve.
Ho seguito la discussione un po' al volo, ma mi pare che questa nota aiuti a capire
(se no, scusatemi).
Saluti.


-------- Messaggio originale --------
Oggetto:        Re: [Qgis-user] Spatialite : problems with spatial views
Data:   Wed, 05 Feb 2014 12:26:55 +0200
Mittente:       Micha Silver <[hidden email]>
A:      giedrius <[hidden email]>, [hidden email]



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 you have GROUP BY with two columns in your query. I think
that what will resolve this is creating a new integer column with unique values for
each Fortas-rusis pair.

If you could try this: add to both the siksnosparniai_rusis table and the
siksnosparniai_patalpa tables  additional integer columns with unique values for each
Fortas and unique values for each rusis. Then in your view, combine these two
integers in some way to get a new *unique* value to be used as the ROWID. That should
work out the duplicate error values in QGIS.

Good luck,
Micha




On 05/02/2014 09:25, giedrius wrote:
> 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 data:
> http://i.imgur.com/ZeXk6Xz.png
>
> Is this a bug? Is it my fault as a user?
>
> I work with Debian
>
> VAM_test_s.sqlite
> <http://osgeo-org.1560.x6.nabble.com/file/n5101983/VAM_test_s.sqlite>

--
Micha Silver
GIS Consulting
052-3665918
http://www.surfaces.co.il



_______________________________________________
[hidden email]
http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss
Questa e' una lista di discussione pubblica aperta a tutti.
I messaggi di questa lista non hanno relazione diretta con le posizioni dell'Associazione GFOSS.it.
666 iscritti al 22.7.2013

_______________________________________________
[hidden email]
http://lists.gfoss.it/cgi-bin/mailman/listinfo/gfoss
Questa e' una lista di discussione pubblica aperta a tutti.
I messaggi di questa lista non hanno relazione diretta con le posizioni dell'Associazione GFOSS.it.
666 iscritti al 22.7.2013